Functional Description
Purpose
To retrieve, write, update, and delete the Reversal Landed Cost Cache.
Setup Notes and Prerequisites
Special Logic
Technical Specification
This function will be driven by the MODE.
MODE = 0 Clear
Delete the full cache and close the cache.
1Write
Add one record to the Cache
3 Get
Retrieve the record matching the full key.
4Delete
Delete only one record matching the full key.
CACHE KEY. (7) (CTID,JOBS,DOCO,DCTO,KCOO,SFXO,LNID,ALIN)
ID for the Cache "RF41291Z"
^
D4301350 - F41291 Reversal Landed Cost Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szComputerID | CTID | char | NONE | NONE |
mnJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
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
| ||||
mnAssociatedLineNo | ALIN | MATH_NUMERIC | NONE | NONE |
Indicates how receiver records are associated with Landed Cost receiver records. This field relates to the PRLAND field in the PO
| ||||
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
| ||||
mnAmountOpen | 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. | ||||
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
| ||||
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
| ||||
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 | RWT1 | char | NONE | NONE |
This flag indicates whether a record has been written to a transaction work file or not. Allowed values are :
0 Record does NOT exist in the
| ||||
mnSequenceNumber | SEQ | MATH_NUMERIC | NONE | NONE |
A number that specifies the sequence of information. | ||||
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
| ||||
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
| ||||
szLineType | LNTY | char | OPT | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szBranch | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
cMode | MODE | char | OPT | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
idCursor | GENLNG | ID | OPT | 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
| ||||
mnAverageCostDifference | AVCO | MATH_NUMERIC | OPT | NONE |
The amount by which the average cost for an item was either increased or decreased due to an over- or under-payment at match time. | ||||
mnFromJournalEntryLineNo | 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. | ||||
mnToJournalEntryLineNo | 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. | ||||
mnF0911JobnumberA | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
None |
F41291Z Landed Cost Cache Table |