D32C0100 - F4211 CW Get SO Records
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szOrderCompany | KCOO | char | OPT | INPUT |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnOrderNumber | DOCO | MATH_NUMERIC | OPT | INPUT |
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 | INPUT |
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
| ||||
mnLineNumber | LNID | MATH_NUMERIC | OPT | OUTPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szLastStatus | LTTR | char | OPT | OUTPUT |
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed. | ||||
szNextStatus | NXTR | char | OPT | OUTPUT |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
szLineType | LNTY | char | OPT | OUTPUT |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
mnOrderQuantity | UORG | MATH_NUMERIC | OPT | OUTPUT |
The quantity of units affected by this transaction. | ||||
szWorkOrderNumber | RORN | char | OPT | OUTPUT |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
cRequestType | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
cEndOfFile | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
idhRequestF4211 | GENLNG | ID | OPT | BOTH |
General purpose ID variable. | ||||
mnShortItemNumber | ITM | MATH_NUMERIC | OPT | OUTPUT |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szScndItemNumber | LITM | char | OPT | OUTPUT |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szThirdItemNumber | AITM | char | OPT | OUTPUT |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szDescription1 | DSC1 | char | OPT | OUTPUT |
Brief information about an item; a remark or an explanation. | ||||
szDescription2 | DSC2 | char | OPT | OUTPUT |
A second, 30-character description, remark, or explanation. | ||||
mnForeignUnitPrice | FPRC | MATH_NUMERIC | OPT | OUTPUT |
The list price in the unit of measure of the base price retrieved from the Base Price File (F4106). This is the price the customer would pay if
| ||||
mnForeignExtendedPrice | FEA | MATH_NUMERIC | OPT | OUTPUT |
The product of the foreign price times the number of units. | ||||
szLocation | LOCN | char | OPT | OUTPUT |
The storage location from which goods will be moved. | ||||
szLot | LOTN | char | OPT | OUTPUT |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
mnUnitPrice | LPRC | MATH_NUMERIC | OPT | OUTPUT |
The list price in the unit of measure of the base price retrieved from the Base Price File (F4106). This is the price the customer would pay if
| ||||
mnUnitCost | UNCS | MATH_NUMERIC | OPT | OUTPUT |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnExtendedCost | ECST | MATH_NUMERIC | OPT | OUTPUT |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
szUnitOfMeasure | UOM | char | OPT | OUTPUT |
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 | OPT | OUTPUT |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. | ||||
mnUnitWeight | ITWT | MATH_NUMERIC | OPT | OUTPUT |
The weight of one unit of an item, expressed in the primary unit of measure. | ||||
szUnitOfMeasureWeight | UWUM | char | OPT | OUTPUT |
A user defined code (00/UM) that identifies the unit of measure that the system uses to indicate weight for this item. You can specify ounces,
| ||||
mnForeignUnitCost | FUC | MATH_NUMERIC | OPT | OUTPUT |
Amount - Foreign Unit Cost | ||||
mnForeignExtCost | FEC | MATH_NUMERIC | OPT | OUTPUT |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. |
None |
F4211 Sales Order Detail File |