40 COLUMNS | 9 INDICIES BusinessOne9.3 | Inventory and Production | OITL Inventory Transactions Log
| Schema | Product | Version | Table | Description | Columns | Indicies | Module |
|---|---|---|---|---|---|---|---|
| BusinessOne9.3 | Business One | 9.3 | OITL | Inventory Transactions Log | 40 | 9 | 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
40 COLUMNS | TOP BusinessOne9.3 | OITL Inventory Transactions Log
| Col# | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
9 INDICIES | TOP BusinessOne9.3 | OITL Inventory Transactions Log
| Name | Primary | Unique | Type | Columns |
|---|---|---|---|---|
| PRIMARY | No | Yes | LogEntry | |
| DOC_INFO | No | No | DocEntry, SubLineNum, DocLine, ManagedBy, DocType | |
| BASEREF | No | No | BSubLineNo, BaseLine, BaseEntry, BaseType | |
| APPLYREF | No | No | AppSubLine, ApplyLine, ApplyEntry, ApplyType | |
| TRANSID | No | No | TransId | |
| ACTUAL_INF | No | No | ManagedBy, ActBaseTp, ActBaseEnt, ActBaseLn, ActBasSubL | |
| ALLOC_REF | No | No | AllocateLn, AllocatEnt, AllocateTp | |
| DOC_REF | No | No | LogEntry, DocLine, DocEntry, DocType | |
| ITEM_CODE | No | No | ApplyType, LogEntry, ItemCode, LocCode, ManagedBy, Instance, ApplyEntry |