Functional Description
Purpose
To write or change landed cost cache.
Setup Notes and Prerequisites
Special Logic
Called from Landed Cost Selection to change a value in one record.
Called from Name ER Landed Cost Selection to write records to the cache.
Technical Specification
If mode = '0', clear the cache for the given ctid and jobs.
If mode = '1', write record to memory cache with values sent in the parameters.
If mode = '2', retrieve cache record with ctid, jobs and seq. Update record with information sent in
parameters.
D4300990 - Write Landed Cost Cache
MODEcModeProcessingIYes0 = Clear 1 = Write 2 = Update
DOCOmnDocumentOrderInvoiceI
DCTOszOrderTypeI
KCOOszCompanyKeyOrderNoI
LNIDmnLineNumberI
DSC1szDescriptionLineI
UOPNmnUnitsOpenQuantityI
PRRCmnPurchasingUnitPriceI
AOPNmnAmountOpenI
AN8mnAddressNumberI
CRCPszCurrencyCodeApAmountI
GLCszGlClassI
INYNcIncludeInUnitCostI
RCYNcReceiverRecordI
SEQmnSequenceNumberIYes *Key 3 (* not required for mode 0)
TYPEcTypeI
ALPHszSupplierNameI
CRRmnExchangeRateI
CRCDszBaseCurrencyI
LVLAszCostLevelI
NLINmnNoOfLinesOnOrderI
CTIDszComputerIDIYesKey 1
JOBSmnJobnumberIYesKey 2
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cModeProcessing | MODE | char | NONE | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
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
| ||||
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. | ||||
mnSequenceNumber | SEQ | MATH_NUMERIC | NONE | NONE |
A number that specifies the sequence of information. | ||||
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
| ||||
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
| ||||
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
| ||||
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 |