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
910 | 42 | F42119 Sales Order History File
8 INDICIES | TOP
910 | 42 | F42119 Sales Order History File
1: Order Num Order Type (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: Item Branch +D
| Element | Alias | Description | Sequence |
|---|
| 1 |
ITM |
Item Number - Short |
Ascending |
| 2 |
MCU |
Business Unit |
Ascending |
| 3 |
DRQJ |
Date - Requested |
Ascending |
3: OrderType NextStatus +B
| Element | Alias | Description | Sequence |
|---|
| 1 |
DCTO |
Order Type |
Ascending |
| 2 |
NXTR |
Status Code - Next |
Ascending |
| 3 |
LNTY |
Line Type |
Ascending |
4: OriginalOrderNo 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 |
8: AddressNumber
| Element | Alias | Description | Sequence |
|---|
| 1 |
AN8 |
Address Number |
Ascending |
9: ShipTo
| Element | Alias | Description | Sequence |
|---|
| 1 |
SHAN |
Address Number - Ship To |
Ascending |
10: Order Num Variance
| Element | Alias | Description | Sequence |
|---|
| 1 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
| 2 |
SO16 |
Manufacturing Variance Accounting Flag |
Ascending |
11: Order Num Type Co KitID
| 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 |
KITID |
Kit Identifier |
Ascending |
| 5 |
LNID |
Line Number |
Ascending |
ERPRef.com