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
68 COLUMNS | TOP
812 | 00 | F0018 Sales/Use/V.A.T. Tax File
5 INDICIES | TOP
812 | 00 | F0018 Sales/Use/V.A.T. Tax File
2: Doc Order No 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 |
SFXO |
Order Suffix |
Ascending |
| 5 |
LNID |
Line Number |
Ascending |
| 6 |
UPMJ |
Date - Updated |
Ascending |
| 7 |
UPMT |
Time - Last Updated |
Ascending |
3: Order Type Doc Oreder No +
| Element | Alias | Description | Sequence |
|---|
| 1 |
DCTO |
Order Type |
Ascending |
| 2 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
| 3 |
SFXO |
Order Suffix |
Ascending |
| 4 |
KCOO |
Order Company (Order Number) |
Ascending |
| 5 |
LNID |
Line Number |
Ascending |
4: Order Type Order No Order +
| Element | Alias | Description | Sequence |
|---|
| 1 |
DCTO |
Order Type |
Ascending |
| 2 |
DOCO |
Document (Order No Invoice etc.) |
Ascending |
| 3 |
KCOO |
Order Company (Order Number) |
Ascending |
| 4 |
DGL |
Date - For G/L (and Voucher) |
Ascending |
| 5 |
LNID |
Line Number |
Ascending |
5: Doc Order No Order Type +
| 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 |
TXA1 |
Tax Rate/Area |
Ascending |
| 5 |
EXR1 |
Tax Expl Code 1 |
Ascending |
| 6 |
ITM |
Item Number - Short |
Ascending |
| 7 |
UPMT |
Time - Last Updated |
Ascending |
| 8 |
UPMJ |
Date - Updated |
Ascending |
6: Processed Flag
| Element | Alias | Description | Sequence |
|---|
| 1 |
PROCFL |
Tax Processed Flag |
Ascending |
ERPRef.com