| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Finance | ||||||||||
| 1 | AJDT | Journal Entry - History | 96 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 2 | AWD2 | Value Ranges | 8 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 3 | AWH2 | WTax Definition - Rows2 | 10 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 4 | AWH3 | Value Range | 10 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 5 | BOX1 | Box Definition - Rows | 4 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 6 | BOX2 | Box Definition - Accounts | 4 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 7 | BOX4 | Box Definition - Contra Accounts of Accounts | 6 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 8 | OBTF | Journal Voucher Entry | 96 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 9 | OJDT | Journal Entry | 96 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 10 | WHT2 | Withholding Tax Definition - Rows2 | 10 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 11 | WHT3 | Value Range | 10 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 12 | WTD2 | Value Ranges | 8 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| Inventory and Production | ||||||||||
| 13 | ATT2 | BOM - Route Stages - History | 3 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 14 | AWO4 | Production Order - Route Stages - History | 3 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 15 | ITT2 | BOM - Route Stages | 3 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 16 | UWOR4 | Production Order - Route Stages | 3 | SeqNum | Sequence Number | Int | 11 | 0 | ||
| 17 | WOR4 | Production Order - Route Stages | 3 | SeqNum | Sequence Number | Int | 11 | 0 | ||