| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
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 | | |
TOPInventory 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 | | |