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
254 COLUMNS | TOP
812 | 42 | F4211 Sales Order Detail File
15 INDICIES | TOP
812 | 42 | F4211 Sales Order Detail File
1: Order Number Order Type +A (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|
| 1 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
| 2 |
DCTO |
Order Type |
Ascending |
| 3 |
KCOO |
Order Company (Order Number) |
Ascending |
| 4 |
LNID |
Line Number |
Ascending |
2: Order Type Next Status +B
| Element | Alias | Description | Sequence |
|---|
| 1 |
DCTO |
Order Type |
Ascending |
| 2 |
NXTR |
Status Code - Next |
Ascending |
| 3 |
LNTY |
Line Type |
Ascending |
3: Address Number
| Element | Alias | Description | Sequence |
|---|
| 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 |
|---|
| 1 |
ITM |
Item Number - Short |
Ascending |
| 2 |
MCU |
Business Unit |
Ascending |
| 3 |
PDDJ |
Date - Scheduled Pick |
Ascending |
| 4 |
PDTT |
Time - Scheduled Pick |
Ascending |
7: Address No Short Item +C
| Element | Alias | Description | Sequence |
|---|
| 1 |
AN8 |
Address Number |
Ascending |
| 2 |
ITM |
Item Number - Short |
Ascending |
| 3 |
UOM |
Unit of Measure as Input |
Ascending |
| 4 |
CRCD |
Currency Code - From |
Ascending |
| 5 |
OTQY |
Other Quantity (1/2) |
Ascending |
| 6 |
DCTO |
Order Type |
Ascending |
| 7 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
8: ShipmentNumber
| Element | Alias | Description | Sequence |
|---|
| 1 |
SHPN |
Shipment Number |
Ascending |
| 2 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
| 3 |
DCTO |
Order Type |
Ascending |
| 4 |
KCOO |
Order Company (Order Number) |
Ascending |
| 5 |
LNID |
Line Number |
Ascending |
9: Short Item Branch +D
| Element | Alias | Description | Sequence |
|---|
| 1 |
ITM |
Item Number - Short |
Ascending |
| 2 |
MCU |
Business Unit |
Ascending |
| 3 |
DRQJ |
Date - Requested |
Ascending |
10: Original Order No Type Co
| Element | Alias | Description | Sequence |
|---|
| 1 |
OORN |
Original Order Number |
Ascending |
| 2 |
OCTO |
Original Order Type |
Ascending |
| 3 |
OKCO |
Document Company (Original Order) |
Ascending |
11: Cross Dock Order No Type Co +
| Element | Alias | Description | Sequence |
|---|
| 1 |
XORN |
Cross Dock Order No |
Ascending |
| 2 |
XCTO |
Cross Dock Order Type |
Ascending |
| 3 |
XKCO |
Cross Dock Order Company (Order Number) |
Ascending |
| 4 |
XSFX |
Cross Dock Order Suffix |
Ascending |
| 5 |
XLLN |
Cross Dock Line Number |
Ascending |
| 6 |
XPTY |
Cross Docking Priority for Sales Orders |
Ascending |
12: Branch Sold To +S
| Element | Alias | Description | Sequence |
|---|
| 1 |
MCU |
Business Unit |
Ascending |
| 2 |
AN8 |
Address Number |
Ascending |
| 3 |
SHAN |
Address Number - Ship To |
Ascending |
| 4 |
PPDJ |
Date - Promised Shipment |
Ascending |
| 5 |
PMDT |
Scheduled Shipment Time |
Ascending |
| 6 |
VR01 |
Reference |
Ascending |
13: Demand ID
| Element | Alias | Description | Sequence |
|---|
| 1 |
DEID |
Demand Unique Key ID |
Ascending |
14: Invoice Number Type Company
| Element | Alias | Description | Sequence |
|---|
| 1 |
DOC |
Document (Voucher Invoice etc.) |
Ascending |
| 2 |
DCT |
Document Type |
Ascending |
| 3 |
KCO |
Document Company |
Ascending |
15: Order Number Variance
| Element | Alias | Description | Sequence |
|---|
| 1 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
| 2 |
SO16 |
Manufacturing Variance Accounting Flag |
Ascending |
ERPRef.com