D3200830 - F4211 Get Configurator Sales Row
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnDocumentorderinvoicee | 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
| ||||
szCostcenter | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
mnItemnumbershortkit | KIT | MATH_NUMERIC | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
mnQuantity | QTY | MATH_NUMERIC | NONE | NONE |
The number of units associated with an asset. | ||||
szStatuscodelast | LTTR | char | NONE | NONE |
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed. | ||||
mnAmtpriceperunit2 | UPRC | MATH_NUMERIC | NONE | 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
| ||||
mnAmountextendedprice | AEXP | MATH_NUMERIC | NONE | NONE |
The number of units multiplied by the unit price. | ||||
szLinetype | LNTY | char | NONE | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szStatuscodenext | NXTR | char | NONE | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
szUnitofmeasureasinput | UOM | char | NONE | 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). | ||||
szUnitofmeasurepricing | UOM4 | char | NONE | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. | ||||
jdDaterequestedjulian | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
mnUnitsquantityshipped | SOQS | MATH_NUMERIC | NONE | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
mnUnitsquanbackorheld | SOBK | MATH_NUMERIC | NONE | NONE |
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of
| ||||
mnUnitsquantitycanceled | SOCN | MATH_NUMERIC | NONE | NONE |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
| ||||
mnAmountextendedcost | ECST | MATH_NUMERIC | NONE | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
szCurrencycodefrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
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
| ||||
mnAmountunitcost | UNCS | MATH_NUMERIC | NONE | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
szConfiguratorLineType | LNTY | char | NONE | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
jdPromiseddeliverydate | PDDJ | JDEDATE | NONE | NONE |
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
| ||||
szPriceadjustmentschedulen | ASN | char | NONE | NONE |
A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
szErrorMessageID | DTAI | char | NONE | 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
| ||||
cSalesorderstatus01 | SO01 | char | NONE | NONE |
A value of 1 indicates that this sales detail line contains an inter branch item.
Interbranch sales orders allow the user to record the
| ||||
mnCurrencyconverrateov | 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
| ||||
mnAmountforeignunitcost | FUC | MATH_NUMERIC | NONE | NONE |
Amount - Foreign Unit Cost | ||||
mnAmountforeignextcost | FEC | MATH_NUMERIC | NONE | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
cCostoverridecode | CSTO | char | NONE | NONE |
A code that specifies whether the change order is a terms only change. For those organizations that elect to view subcontracts on a
| ||||
mnExtendedcosttransfer | TCST | MATH_NUMERIC | NONE | NONE |
This is the cost of transferring inventory from one branch to another. The method of calculating this transfer cost is maintained in the Inter
| ||||
cSuppressErrorMessages | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnTriangulationRate1 | TRR1 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate used to convert the From currency code to the Triangulation currency code. | ||||
mnTriangulationRate2 | TRR2 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code. |
None |
F4211 Sales Order Detail File |