| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBanking |
1 | ARC2 | Incoming Payment - Invoices - History | 11 | DocLine | Row Key | Int | 11 | 0 | 0 | |
2 | ARC8 | Incoming Payment - TDS Entries - History | 5 | DocLine | Invoice Row Number | Int | 11 | 0 | | |
3 | PDF2 | Payment Draft - Invoices | 11 | DocLine | Row Key | Int | 11 | 0 | 0 | |
4 | PDF8 | Payment Draft - TDS Entries | 5 | DocLine | Invoice Row Number | Int | 11 | 0 | | |
5 | PMV8 | Incoming Payment - TDS Entries | 5 | DocLine | Invoice Row Number | Int | 11 | 0 | | |
6 | RCT2 | Incoming Payments - Invoices | 11 | DocLine | Row Key | Int | 11 | 0 | 0 | |
7 | RCT8 | Incoming Payment - TDS Entries | 5 | DocLine | Invoice Row Number | Int | 11 | 0 | | |
8 | TMP8 | Incoming Payment - TDS Entries | 5 | DocLine | Invoice Row Number | Int | 11 | 0 | | |
9 | VPM2 | Outgoing Payments - Invoices | 11 | DocLine | Row Key | Int | 11 | 0 | 0 | |
10 | VPM8 | Outgoing Payment - TDS Entries | 5 | DocLine | Invoice Row Number | Int | 11 | 0 | | |
TOPFinance |
11 | AJD1 | Journal Entry - History - Rows | 128 | DocLine | Source Line Internal ID | Int | 11 | 0 | | |
12 | BTF1 | Journal Voucher - Rows | 128 | DocLine | Source Line Internal ID | Int | 11 | 0 | | |
13 | JDT1 | Journal Entry - Rows | 128 | DocLine | Source Line Internal ID | Int | 11 | 0 | | |
TOPInventory and Production |
14 | OITL | Inventory Transactions Log | 7 | DocLine | Doc. Row Number | Int | 11 | 0 | | |
15 | ORTL | Resource Transaction Log | 5 | DocLine | Doc. Row Number | Int | 11 | 0 | | |