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 |