Functional Description
Purpose
To read the landed cost cache.
Setup Notes and Prerequisites
Special Logic
Called from named ER Landed Cost Selection.
Technical Specification
If idGenericLong is NULL
Fetch cache record using Key
else
Fetch record from cache sequentially starting with the first one
D4300980 - Retrieve Landed Cost Cache
Special Input Expected
SEQmnSequenceNumberI/OKey 3 (required if GENLNG = 0)
GENLNGidGenericLong I/OFetch by Key: GENLNG = 0 Fetch Sequentially: Initial GENLNG = 0
Subsequently GENLNG != 0
CTIDszComputerID I/OKey 1 (required if GENLNG = 0)
JOBSmnJobnumberI/O Key 2 (required if GENLNG = 0)
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnDocumentOrderInvoice | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szOrderType | DCTO | char | NONE | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
szCompanyKeyOrderNo | KCOO | char | NONE | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szDescriptionLine | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
mnUnitsOpenQuantity | UOPN | MATH_NUMERIC | NONE | NONE |
The original quantity for the order detail line, plus or minus any changes to that quantity, minus all quantities shipped, received, and
| ||||
mnPurchasingUnitPrice | PRRC | MATH_NUMERIC | NONE | NONE |
The unit cost of one item, as purchased from the supplier, excluding freight,taxes, discounts, and other factors that might modify the actual
| ||||
mnExtendedAmount | AOPN | MATH_NUMERIC | NONE | NONE |
The amount of the order, invoice, or voucher that is still unpaid or open.
When you enter a document (for example, an order, invoice, or
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szCurrencyCodeApAmounts | CRCP | char | NONE | NONE |
The currency in which a supplier's amounts are stored. For example, the Prior Year Vouchered, Year to Date Vouchered, and so forth. | ||||
idGenericLong | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
szGlClass | GLC | char | NONE | NONE |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
cReceiverRecord | RCYN | char | NONE | NONE |
Code indicating whether the landed cost is to be displayed during Voucher Match or not. The possible values are as follows:
Y A receipt
| ||||
cType | TYPE | char | NONE | NONE |
A 1-character code that indicates whether to enforce security at the warehouse (W) level or at the company level. Only W level security is
| ||||
mnSequenceNumber | SEQ | MATH_NUMERIC | NONE | NONE |
A number that specifies the sequence of information. | ||||
cIncludeInUnitCost | INYN | char | NONE | NONE |
Code indicating whether you want the landed cost to be added to the item's unit cost. Valid codes are:
Y Add the landed cost to the unit
| ||||
szSupplierName | ALPH | char | NONE | NONE |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
mnExchangeRate | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
szBaseCurrency | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
szCostLevel | LVLA | char | NONE | NONE |
User defined code (table 40/CA) designating an add-on cost. This code also specifies the sequence of the cost add-ons for a particular
| ||||
szComputerID | CTID | char | NONE | NONE |
mnJobnumber | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnNoOfLinesOnOrder | NLIN | MATH_NUMERIC | NONE | NONE |
A number representing the number of lines on either a purchase or sales order.
or The number of receivers recorded during the receipts
| ||||
idhCursor | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
mnTriangulationRateFrom | TRR1 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate used to convert the From currency code to the Triangulation currency code. | ||||
mnTriangulationRateTo | TRR2 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code. | ||||
cCurrencyConversionMethod | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
szOrderSuffix | SFXO | char | OPT | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
mnJournalEntryLineNo | JELN | MATH_NUMERIC | OPT | NONE |
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry lines for inquiry purposes. |
None |
None |