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
24 COLUMNS | TOP
BusinessOne9.3 | ORCJ Resource Capacity Log
4 INDICIES | TOP
BusinessOne9.3 | ORCJ Resource Capacity Log
| Name | Primary | Unique | Type | Columns |
| PRIMARY |
No |
Yes |
|
Id |
| RWDT |
No |
No |
|
CapType, CapDate, WhsCode, ResCode |
| BASE_DOC |
No |
No |
|
BaseLine, BaseAbsEnt, BaseObjTyp |
| OWNING_DOC |
No |
No |
|
OwnLine, OwnAbsEnt, OwnObjTyp |