| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T042M | User Numbers At The Bank | 5 | BNKID | User Number at the Bank | nvarchar | 14 | 0 | | |
2 | TBACN | Bank EDI file version numbers | 3 | BNKID | User Number at the Bank | nvarchar | 14 | 0 | | |
TOPContract Accounts Receivable and Payable |
3 | DFKKPNBKA | Prenotification data (latest) | 21 | BNKID | User Number at the Bank | nvarchar | 14 | 0 | | |
4 | DFKKPNBKH | Prenotification data (history) | 21 | BNKID | User Number at the Bank | nvarchar | 14 | 0 | | |
5 | FKKPREPACC | Master Data for Prepaid Account | 17 | BNKID | Bank Details ID in Prepaid Account | nvarchar | 4 | 0 | | |
6 | TFK042H | Own Bank Details | 6 | BNKID | User Number at the Bank | nvarchar | 14 | 0 | | |
7 | TFK042M | Payment Medium: User Numbers at Bank | 4 | BNKID | User Number at the Bank | nvarchar | 14 | 0 | | |
8 | TFK042U | Payment Medium: Internal Note to Payee | 4 | BNKID | User Number at the Bank | nvarchar | 14 | 0 | | |
TOPLocalization |
9 | TBACN_NO | Store Sequence and Transaction Numbers - Norway | 3 | BNKID | User Number at the Bank | nvarchar | 14 | 0 | | |
TOPNew Zealand |
10 | PA0310 | Superannuation NZ | 43 | BNKID | Bank ID | nvarchar | 2 | 0 | | |