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
72 COLUMNS | TOP
920 | 41 | F4111 Item Ledger File
13 INDICIES | TOP
920 | 41 | F4111 Item Ledger File
1: Unique Key ID (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|
| 1 |
UKID |
Unique Key ID (Internal) |
Ascending |
2: Document No Type +A
| Element | Alias | Description | Sequence |
|---|
| 5 |
JELN |
Journal Entry Line Number |
Ascending |
| 4 |
DGL |
Date - For G/L (and Voucher) |
Ascending |
| 3 |
KCO |
Document Company |
Ascending |
| 2 |
DCT |
Document Type |
Ascending |
| 1 |
DOC |
Document (Voucher Invoice etc.) |
Ascending |
3: Document No Type +B
| Element | Alias | Description | Sequence |
|---|
| 5 |
DGL |
Date - For G/L (and Voucher) |
Ascending |
| 4 |
LNID |
Line Number |
Ascending |
| 3 |
KCO |
Document Company |
Ascending |
| 2 |
DCT |
Document Type |
Ascending |
| 1 |
DOC |
Document (Voucher Invoice etc.) |
Ascending |
4: Type Order No +C
| Element | Alias | Description | Sequence |
|---|
| 5 |
DGL |
Date - For G/L (and Voucher) |
Ascending |
| 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 |
5: Item No Branch +D
| Element | Alias | Description | Sequence |
|---|
| 3 |
TRDJ |
Date - Order/Transaction |
Ascending |
| 2 |
MMCU |
Branch |
Ascending |
| 1 |
ITM |
Item Number - Short |
Ascending |
6: Branch Plant Item N Loc Lot
| Element | Alias | Description | Sequence |
|---|
| 4 |
LOTN |
Lot/Serial Number |
Ascending |
| 3 |
LOCN |
Location |
Ascending |
| 2 |
ITM |
Item Number - Short |
Ascending |
| 1 |
MCU |
Business Unit |
Ascending |
7: Document No Type +C
| Element | Alias | Description | Sequence |
|---|
| 5 |
LOTN |
Lot/Serial Number |
Ascending |
| 4 |
MCU |
Business Unit |
Ascending |
| 3 |
ITM |
Item Number - Short |
Ascending |
| 2 |
DCT |
Document Type |
Ascending |
| 1 |
DOC |
Document (Voucher Invoice etc.) |
Ascending |
8: Unique Key Id Descending
| Element | Alias | Description | Sequence |
|---|
| 1 |
UKID |
Unique Key ID (Internal) |
Descending |
9: Document Type
| Element | Alias | Description | Sequence |
|---|
| 1 |
DCT |
Document Type |
Ascending |
10: Company Date Unique Key
| Element | Alias | Description | Sequence |
|---|
| 3 |
UKID |
Unique Key ID (Internal) |
Ascending |
| 2 |
DGL |
Date - For G/L (and Voucher) |
Descending |
| 1 |
KCO |
Document Company |
Ascending |
11: Parent Lot
| Element | Alias | Description | Sequence |
|---|
| 1 |
PLOT |
Parent Lot |
Ascending |
12: SupplierID Supplier Lot
| Element | Alias | Description | Sequence |
|---|
| 6 |
LOTN |
Lot/Serial Number |
Ascending |
| 5 |
LOCN |
Location |
Ascending |
| 4 |
MCU |
Business Unit |
Ascending |
| 3 |
ITM |
Item Number - Short |
Ascending |
| 2 |
RLOT |
Supplier Lot Number |
Ascending |
| 1 |
AN8 |
Address Number |
Ascending |
13: Lot Number
| Element | Alias | Description | Sequence |
|---|
| 1 |
LOTN |
Lot/Serial Number |
Ascending |
ERPRef.com