101 COLUMNS | 10 INDICIES BusinessOne8.8 | Inventory and Production | OINM Whse Journal
| Schema | Product | Version | Table | Description | Columns | Indicies | Module |
|---|---|---|---|---|---|---|---|
| BusinessOne8.8 | Business One | 8.8 | OINM | Whse Journal | 101 | 10 | Inventory and Production |
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
101 COLUMNS | TOP BusinessOne8.8 | OINM Whse Journal
| Col# | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
10 INDICIES | TOP BusinessOne8.8 | OINM Whse Journal
| Name | Primary | Unique | Type | Columns |
|---|---|---|---|---|
| PRIMARY | No | Yes | INSTANCE, NUM | |
| CARD | No | No | CARD_CODE | |
| ITEM | No | No | WAREHOUSE, ITEM_CODE | |
| CURRENCY | No | No | CURRENCY | |
| DOCDATE | No | No | DATE | |
| DOCENTRY | No | No | LINE_NUM, TYPE, CREATED_BY | |
| TRANSSEQ | No | Yes | TRANS_SEQUENCE | |
| APPOBJ | No | No | APPL_OBJ_TYPE, APPL_OBJ_ABS, APPL_OBJECT | |
| OPENQTYCOM | No | No | OPEN_QTY, INSTANCE, NUM, ITEM_CODE | |
| OPENQTYWH | No | No | OPEN_QTY, INSTANCE, NUM, WAREHOUSE, ITEM_CODE |