ERPRef.com
is JDE Date
268 COLUMNS | 19 INDICIES 920 | 42 | F4211 Sales Order Detail File
| Schema | Name | Prefix | Columns | Indicies | Description | Type | Report | Category |
|---|---|---|---|---|---|---|---|---|
| 920 | F4211 | SD | 268 | 19 | Sales Order Detail File | Transaction Files | 42: Sales Management |
268 COLUMNS | TOP 920 | 42 | F4211 Sales Order Detail File
| Column | Field | Description | Data Type | Edit Type | Length | Decimals |
|---|
19 INDICIES | TOP 920 | 42 | F4211 Sales Order Detail File
1: Order Number Order Type +A (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 4 | LNID | Line Number | Ascending |
| 3 | KCOO | Order Company (Order Number) | Ascending |
| 2 | DCTO | Order Type | Ascending |
| 1 | DOCO | Document (Order No Invoice etc.) | Ascending |
2: Order Type Next Status +B
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | LNTY | Line Type | Ascending |
| 2 | NXTR | Status Code - Next | Ascending |
| 1 | DCTO | Order Type | Ascending |
3: Address Number
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 2 | TRDJ | Date - Order/Transaction | Ascending |
| 1 | AN8 | Address Number | Ascending |
4: Ship To
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 1 | SHAN | Address Number - Ship To | Ascending |
5: Pick Slip Number
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 1 | PSN | Pick Slip Number | Ascending |
6: Short Item Branch
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 4 | PDTT | Time - Scheduled Pick | Ascending |
| 3 | PDDJ | Date - Scheduled Pick | Ascending |
| 2 | MCU | Business Unit | Ascending |
| 1 | ITM | Item Number - Short | Ascending |
7: Address No Short Item +C
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 7 | DOCO | Document (Order No Invoice etc.) | Ascending |
| 6 | DCTO | Order Type | Ascending |
| 5 | OTQY | Other Quantity (1/2) | Ascending |
| 4 | CRCD | Currency Code - From | Ascending |
| 3 | UOM | Unit of Measure as Input | Ascending |
| 2 | ITM | Item Number - Short | Ascending |
| 1 | AN8 | Address Number | Ascending |
8: ShipmentNumber
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 5 | LNID | Line Number | Ascending |
| 4 | KCOO | Order Company (Order Number) | Ascending |
| 3 | DCTO | Order Type | Ascending |
| 2 | DOCO | Document (Order No Invoice etc.) | Ascending |
| 1 | SHPN | Shipment Number | Ascending |
9: Short Item Branch +D
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | DRQJ | Date - Requested | Ascending |
| 2 | MCU | Business Unit | Ascending |
| 1 | ITM | Item Number - Short | Ascending |
10: Original Order No Type Co
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | OKCO | Document Company (Original Order) | Ascending |
| 2 | OCTO | Original Order Type | Ascending |
| 1 | OORN | Original Order Number | Ascending |
11: Cross Dock Order No Type Co +
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 6 | XPTY | Cross Docking Priority for Sales Orders | Ascending |
| 5 | XLLN | Cross Dock Line Number | Ascending |
| 4 | XSFX | Cross Dock Order Suffix | Ascending |
| 3 | XKCO | Cross Dock Order Company (Order Number) | Ascending |
| 2 | XCTO | Cross Dock Order Type | Ascending |
| 1 | XORN | Cross Dock Order No | Ascending |
12: Branch Sold To +S
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 6 | VR01 | Reference | Ascending |
| 5 | PMDT | Scheduled Shipment Time | Ascending |
| 4 | PPDJ | Date - Promised Shipment | Ascending |
| 3 | SHAN | Address Number - Ship To | Ascending |
| 2 | AN8 | Address Number | Ascending |
| 1 | MCU | Business Unit | Ascending |
13: Demand ID
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 1 | DEID | Demand Unique Key ID | Ascending |
14: Invoice Number Type Company
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 3 | KCO | Document Company | Ascending |
| 2 | DCT | Document Type | Ascending |
| 1 | DOC | Document (Voucher Invoice etc.) | Ascending |
15: Order Number Variance
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 2 | SO16 | Manufacturing Variance Accounting Flag | Ascending |
| 1 | DOCO | Document (Order No Invoice etc.) | Ascending |
16: Order Number Type Co KitID
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 5 | LNID | Line Number | Ascending |
| 4 | KITID | Kit Identifier | Ascending |
| 3 | KCOO | Order Company (Order Number) | Ascending |
| 2 | DCTO | Order Type | Ascending |
| 1 | DOCO | Document (Order No Invoice etc.) | Ascending |
17: FulfillmentPlanID OrderScore
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 2 | OSCORE | Sales Order Score | Ascending |
| 1 | FULPID | Fulfillment Plan ID | Ascending |
18: Short Item Trans Date SoldTo
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 16 | DCTO | Order Type | Ascending |
| 15 | LTTR | Status Code - Last | Ascending |
| 14 | UORG | Units - Order/Transaction Quantity | Ascending |
| 13 | KTLN | Kit Master Line Number | Ascending |
| 12 | KCOO | Order Company (Order Number) | Ascending |
| 11 | CMCO | Customer Master Company | Ascending |
| 10 | UOM4 | Unit of Measure - Pricing | Ascending |
| 9 | MCU | Business Unit | Ascending |
| 8 | DOCO | Document (Order No Invoice etc.) | Ascending |
| 7 | ECST | Amount - Extended Cost | Ascending |
| 6 | AEXP | Amount - Extended Price | Ascending |
| 5 | UNCS | Amount - Unit Cost | Ascending |
| 4 | UPRC | Amount - Price per Unit | Ascending |
| 3 | ITM | Item Number - Short | Ascending |
| 2 | AN8 | Address Number | Ascending |
| 1 | TRDJ | Date - Order/Transaction | Ascending |
19: Item Branch Alloc Flag
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 9 | SONE | Units - Future Quantity Committed | Ascending |
| 8 | SOQS | Quantity Shipped | Ascending |
| 7 | ALLSTS | Allocation Status Number | Ascending |
| 6 | UOM | Unit of Measure as Input | Ascending |
| 5 | OSCORE | Sales Order Score | Ascending |
| 4 | KTLN | Kit Master Line Number | Ascending |
| 3 | ALLOC | Allocation Process Flag | Ascending |
| 2 | MCU | Business Unit | Ascending |
| 1 | ITM | Item Number - Short | Ascending |