| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBank Customer Accounts |
1 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 34 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
2 | BKKSO | BCA: Standing Orders | 7 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
TOPFSCM In-House Cash |
3 | IHC_DB_CL_TYPES | Technical Settings for AMS Update | 8 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
TOPGL transfer |
4 | BKKCNOITGL | Table of Items not Updated on the Account | 16 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
5 | T8J4H | Non-Op saved bills - Detail Info (for holding bills) | 13 | PAYMETHOD | JV Payment Method | nvarchar | 1 | 0 | | |
TOPMaster Data |
6 | BKK43 | BCA: Reference Accounts | 19 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
7 | BKK615 | Data for External Root Accounts Cash Concentration | 8 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
8 | TBKK65 | Settings for Cash Concentration | 8 | PAYMETHOD | Payment Method for External Root Accts. - Cash Concentration | nvarchar | 4 | 0 | | |
TOPPayment Item |
9 | BKKIT | Payment Item | 34 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
10 | BKKITAI | Info Items for Interest Penalty at Balancing | 14 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
11 | BKKITENQ | Blocked Payment Items | 34 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
12 | BKKITREL | Payment Item | 34 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
13 | BKKITRETREL | Payment Item Return to be released | 6 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
14 | BKKITTMP | Planned Payment Items | 35 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
15 | BKKITTMP_DEL | Planned Payment Items - Completed | 35 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
16 | BKKPAYMEX_IT | EFT Management: Items in Outgoing Payment Transactions | 31 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
17 | TBKKI1 | Assignment Medium/Payment Method to Processes | 4 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
18 | TBKKIDF | BCA: Defaults for Transaction | 5 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
TOPPayment Order |
19 | BKKPOHD | Payment Order, Header Data | 8 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
20 | BKKPOHD_TMP | Planned Payment Order, Header Data | 9 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
21 | BKKPOHD_TMP_DEL | Planned Payment Order, Header Data | 9 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
22 | BKKPOIT | Item in Payment Order | 18 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
23 | BKKPOIT_TMP | Items in Planned Payment Order | 19 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
24 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 17 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
25 | TBKK_SDD_DAYS | Date Determination for SEPA Direct Debit Orders | 2 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |
TOPProduct definition |
26 | TBKKG1_TCODEPM | Assignment Transaction to Payment Method | 3 | PAYMETHOD | Payment Method | nvarchar | 4 | 0 | | |