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 |