| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBanking |
1 | ARC2 | Incoming Payment - Invoices - History | 7 | InvType | Document Type | nVarChar | 20 | 0 | 13 | |
2 | ARC8 | Incoming Payment - TDS Entries - History | 3 | InvType | Invoice Category | nVarChar | 20 | 0 | | |
3 | PDF2 | Payment Draft - Invoices | 7 | InvType | Invoice Category | nVarChar | 20 | 0 | 13 | |
4 | PDF8 | Payment Draft - TDS Entries | 3 | InvType | Invoice Category | nVarChar | 20 | 0 | -1 | -1=All Transactions, 10000079=TDS Adjustment, 18=A/P Invoice, 19=A/P Credit Memo, 204=A/P Down Payment |
5 | PMV8 | Incoming Payment - TDS Entries | 3 | InvType | Invoice Category | nVarChar | 20 | 0 | | |
6 | RCT2 | Incoming Payments - Invoices | 7 | InvType | Invoice Category | nVarChar | 20 | 0 | 13 | |
7 | RCT8 | Incoming Payment - TDS Entries | 3 | InvType | Invoice Category | nVarChar | 20 | 0 | | |
8 | TMP8 | Incoming Payment - TDS Entries | 3 | InvType | Invoice Category | nVarChar | 20 | 0 | | |
9 | VPM2 | Outgoing Payments - Invoices | 7 | InvType | Invoice Category | nVarChar | 20 | 0 | 18 | |
10 | VPM8 | Outgoing Payment - TDS Entries | 3 | InvType | Invoice Category | nVarChar | 20 | 0 | -1 | -1=All Transactions, 10000079=TDS Adjustment, 18=A/P Invoice, 19=A/P Credit Memo, 204=A/P Down Payment |
TOPReports |
11 | AMD1 | Amout Differences Report Lines | 6 | InvType | Invoice Category | nVarChar | 20 | 0 | 13 | 13=Sales Invoice |