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
31 COLUMNS | TOP
920 | 01 | F01151Z1 Batch - Electronic Address
1 INDICIES | TOP
920 | 01 | F01151Z1 Batch - Electronic Address
1: Edi Index (Primary/Unique)
| Element | Alias | Description | Sequence |
| 4 |
EDLN |
EDI - Line Number |
Ascending |
| 3 |
EDTN |
EDI - Transaction Number |
Ascending |
| 2 |
EDBT |
EDI - Batch Number |
Ascending |
| 1 |
EDUS |
EDI - User ID |
Ascending |