D3202380 - Process Sales Order Detail Line Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
cCacheMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szOrderCo | KCOO | char | OPT | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnOrderNo | DOCO | MATH_NUMERIC | OPT | 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 | OPT | 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
| ||||
mnParentLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnComponentLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szBusinessUnit | 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
| ||||
mnShipToNo | SHAN | MATH_NUMERIC | OPT | NONE |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
jdCancelDate | CNDJ | JDEDATE | OPT | NONE |
The date that the order should be canceled if the goods have not been sent to the customer or the goods have not been received from the
| ||||
szItemNo | UITM | char | OPT | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szLotNo | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
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
| ||||
mnUnitPrice | UPRC | MATH_NUMERIC | OPT | NONE |
The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table
| ||||
mnUnitCost | UNCS | MATH_NUMERIC | OPT | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
szPrintMesg | INMG | char | OPT | NONE |
A user defined code that you assign to each print message. Examples of text used in messages are engineering specifications, hours of
| ||||
cPaymentInstrument | RYIN | char | OPT | NONE |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
szAdjustmentSchedule | ASN | char | OPT | NONE |
A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
cSalesTaxableYN | TAX1 | char | OPT | NONE |
A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
| ||||
cAssociatedText | ATXT | char | OPT | NONE |
This is a one byte flag that is used to determine whether or not a specific line item on a sales or purchase order has additional extended
| ||||
szTransactionUOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szPricingUOM | UOM4 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. | ||||
szWeightUOM | WTUM | char | OPT | NONE |
The unit of measure that indicates the weight of an individual item. Typical weight units of measure are:
GM Gram
OZ Ounce
LB Pound
| ||||
mnForeignUnitPrice | FUP | MATH_NUMERIC | OPT | NONE |
The foreign price per unit. | ||||
mnForeignUnitCost | FUC | MATH_NUMERIC | OPT | NONE |
Amount - Foreign Unit Cost | ||||
szRelatedKitItemNo | RLIT | char | OPT | NONE |
If an individual item of inventory is sold as a component of a kit or assembly (single level bill-of-materials), the item number of that kit is the
| ||||
mnKitMasterLineNo | KTLN | MATH_NUMERIC | OPT | NONE |
This line number indicates the relative sequence in which a component is added to a kit or single level bill of materials. For example, the
| ||||
mnComponentLineNo | CPNT | MATH_NUMERIC | OPT | NONE |
A number that indicates the sequence of the components on a bill of material.
It initially indicates the relative sequence in which a
| ||||
mnRelatedKitComponent | RKIT | MATH_NUMERIC | OPT | NONE |
In the Sales Order Processing System, when a kit component is defined in the Bill of Materials Master (F3002) as a second level or higher
| ||||
mnNoOfCpntPerParent | KTP | MATH_NUMERIC | OPT | NONE |
The total number of the current component needed per unit of the parent kit. | ||||
cOverrideCost | CSTO | char | OPT | NONE |
A code that specifies whether the change order is a terms only change. For those organizations that elect to view subcontracts on a
| ||||
mnOriginalOrderLineNo | OGNO | MATH_NUMERIC | OPT | NONE |
A number identifying which line on the original order that the current line matches. | ||||
mnSODLineNo | EDLN | MATH_NUMERIC | OPT | NONE |
This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any
| ||||
mnSODDocNo | EDOC | MATH_NUMERIC | OPT | NONE |
The document number that is assigned by the transmitter in an EDI transaction.
In a non EDI environment, this would be consistent with the
| ||||
szSODDocType | EDCT | char | OPT | NONE |
The document type that is assigned by the transmitter in an EDI transaction.
In a non EDI environment, this would be consistent with the order
| ||||
szSODOrderCo | EKCO | char | OPT | NONE |
Company - Key (EDI - Document Key Co) | ||||
mnSoldToCust | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szSoldToCurrencyCode | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szRevenueBusinessUnit | EMCU | char | OPT | NONE |
A business unit is an accounting entity required for management reporting. It can be a profit center, department, warehouse location, job,
| ||||
cSuppressErrorMessage | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
| ||||
szErrorMessageID | DTAI | char | OPT | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
cCacheCodeError | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idCursor | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cReturnCursor | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
nIndexNumber | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
szCMComputerID | CTID | char | OPT | NONE |
mnProcessID | PEID | MATH_NUMERIC | OPT | NONE |
A code that identifies the Inter-Process Communication ID. | ||||
mnTransactionID | TCID | MATH_NUMERIC | OPT | NONE |
szOriginalOrderKeyCo | OKCO | char | OPT | NONE |
A number that is used in conjunction with the values in the ODOC and ODCT fields to identify a transaction. | ||||
szOriginalOrderNumber | OORN | char | OPT | NONE |
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document
| ||||
szOriginalOrderType | OCTO | char | OPT | NONE |
This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher
| ||||
mnShortItemNumber | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
mnOriginalUnitsTransactionQty | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
szModeOfTransport | MOT | char | OPT | NONE |
A user defined code (00/TM) that describes the nature of the carrier being used to transport goods to the customer. For example, by rail, by
| ||||
mnCarrierNumber | CARS | MATH_NUMERIC | OPT | NONE |
The address number for the preferred carrier of the item. The customer or your organization might prefer a certain carrier due to route or
| ||||
mnAmountExtendedPrice | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
mnAmountForeignExtPrice | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
mnAmountExtendedCost | ECST | MATH_NUMERIC | OPT | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mnAmountForeignExtCost | FEC | MATH_NUMERIC | OPT | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. |
None |
None |