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
228 COLUMNS | TOP
920 | 43 | F4311 Purchase Order Detail File
12 INDICIES | TOP
920 | 43 | F4311 Purchase Order Detail File
1: Doc No Order Type + 1 (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|
| 5 |
LNID |
Line Number |
Ascending |
| 4 |
SFXO |
Order Suffix |
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 +
| 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 |
|---|
| 1 |
AN8 |
Address Number |
Ascending |
4: Item Number Branch + A
| Element | Alias | Description | Sequence |
|---|
| 3 |
PDDJ |
Date - Scheduled Pick |
Ascending |
| 2 |
MCU |
Business Unit |
Ascending |
| 1 |
ITM |
Item Number - Short |
Ascending |
5: Item Number Order Type +
| Element | Alias | Description | Sequence |
|---|
| 6 |
LNID |
Line Number |
Ascending |
| 5 |
SFXO |
Order Suffix |
Ascending |
| 4 |
KCOO |
Order Company (Order Number) |
Ascending |
| 3 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
| 2 |
DCTO |
Order Type |
Ascending |
| 1 |
ITM |
Item Number - Short |
Ascending |
6: Order Number Order Type +
| Element | Alias | Description | Sequence |
|---|
| 5 |
PDDJ |
Date - Scheduled Pick |
Ascending |
| 4 |
OGNO |
Original Line Number |
Ascending |
| 3 |
OKCO |
Document Company (Original Order) |
Ascending |
| 2 |
OCTO |
Original Order Type |
Ascending |
| 1 |
OORN |
Original Order Number |
Ascending |
7: Address No Item no (Short) +
| 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 |
9: AID DCTO DOCO KCOO SFXO LNID
| Element | Alias | Description | Sequence |
|---|
| 6 |
LNID |
Line Number |
Ascending |
| 5 |
SFXO |
Order Suffix |
Ascending |
| 4 |
KCOO |
Order Company (Order Number) |
Ascending |
| 3 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
| 2 |
DCTO |
Order Type |
Ascending |
| 1 |
AID |
Account ID |
Ascending |
10: Subledger Subledger Type
| Element | Alias | Description | Sequence |
|---|
| 2 |
SBLT |
Subledger Type |
Ascending |
| 1 |
SBL |
Subledger - G/L |
Ascending |
11: DOCO DCTO KCOO SHAN +
| Element | Alias | Description | Sequence |
|---|
| 6 |
LNID |
Line Number |
Ascending |
| 5 |
SFXO |
Order Suffix |
Ascending |
| 4 |
SHAN |
Address Number - Ship To |
Ascending |
| 3 |
KCOO |
Order Company (Order Number) |
Ascending |
| 2 |
DCTO |
Order Type |
Ascending |
| 1 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
12: Item Number Status Next +
| Element | Alias | Description | Sequence |
|---|
| 2 |
NXTR |
Status Code - Next |
Ascending |
| 1 |
ITM |
Item Number - Short |
Ascending |
13: Shipment Number SHPN
| Element | Alias | Description | Sequence |
|---|
| 1 |
SHPN |
Shipment Number |
Ascending |
ERPRef.com