Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.
Select SQL
Insert SQL
Update SQL
Create SQL
268 COLUMNS | TOP
920 | 42 | F4211 Sales Order Detail File
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 |
ERPRef.com