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
10 COLUMNS | TOP
812 | 46 | F46013 Carton Recommendation Rules
1 INDICIES | TOP
812 | 46 | F46013 Carton Recommendation Rules
1: CC Itm Rpt6 uom Plttyp CntCd (Primary/Unique)
| Element | Alias | Description | Sequence |
| 1 |
MCU |
Business Unit |
Ascending |
| 2 |
ITM |
Item Number - Short |
Ascending |
| 3 |
PRP6 |
Group - Item Dimension |
Ascending |
| 4 |
UOM |
Unit of Measure as Input |
Ascending |
| 5 |
EQTY |
Container Code |
Ascending |
| 6 |
EQT2 |
Container Code |
Ascending |