| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_BCAPR | Fill Header for BCAPR | 3 | PRODINT | Char 18 for TDMS | nvarchar | 18 | 0 | | |
TOPAccount Management |
2 | TBKKNTC_NTCAMT | Notice: Calculation of Available Amount | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
3 | TBKK_4EYES_NTC | Notice: Dual Control for Each Bank Area/Product/Category | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
4 | TBKK_DC_NTC_AUTH | Notice: Amount Authorization | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPBank Customer Accounts |
5 | BKKARCPERIOD | Archived Periods | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
6 | BKKARCPERIODFILE | Archived Periods per Archive File | 4 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
7 | TBCA_US_DEA_PRO | Cross Reference Escheat Property Codes | 4 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
8 | TBCA_US_DEA_PROT | Property Type Codes Text Description | 5 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
9 | TBCA_US_PAY_AMT | Overdraft transaction sequence for Products | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
10 | TBCA_US_TRAN_SEQ | Overdraft transaction priority sequence for Products | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
11 | TBKKARCPERIOD | Archiving Periods | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
12 | TBKKSOAUTH | Amount Authorization/Dual Control Standing Order | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
13 | TBKKTRMMINDEP | Minimum Deposit for Each Term | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
14 | TFIPR_SETTCOMB | Feature Combination | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPCondition |
15 | TBKK8IW | Periods for Interest Guarantee for Offers | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPDefault Risk and Limit System |
16 | KLARRZU03 | Assign DRR and Limit Product Group to BCA Product (New) | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPInterestCharge Calculation |
17 | BKKM3 | BCA: Parameters for Mass Runs in Parallel Processing | 37 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
18 | TBKKMNEXTDT | Increase Next Date for Bank Statement Table | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPLoans Management |
19 | TDPR_PRODUCT | Product, Master Data | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
20 | TDPR_PRODUCTT | Product Description | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
21 | TDPR_PRODV | Version of a Prodcut, Master Data | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
22 | TDPR_VA | Version Attribute | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
23 | TDPR_VA_FLD | Version Attribute Category Field | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
24 | TDPR_VA_FLDM | Version Attribute Category Field: Multiple Value Fields | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPMarket Risk Analyzer |
25 | VTVBKKBW02 | RM: Assignment of Valuation Rule to BCA Product (New) | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPMaster Data |
26 | BKK42 | Current Account Master Data: Operative Data | 8 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
27 | BKK_4EYES_CLOS | Account Closure Principle of Dual Control | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
28 | BKK_MIN_DEP | Minimum Deposit for Each Product | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
29 | TBKKE_FOUR_EYES | Limits: Validity of Principle of Dual Control | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
30 | TBKKHLDAUTH | Amount Authorization/Permanent Holds | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPPayment Item |
31 | TBKK01E | CpD-accounts for different processes | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
32 | TBKKG10 | Assignment of Recipient Payment Details for Product | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
33 | TBKKIAUTH | Amount Authorization/Dual Control Payment Items | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
34 | TBKKIO1 | Posting Day Shift Forward for Automatic Forward Orders | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPPayment Order |
35 | TBKKG2_DATE_PL | Settings for Date Calculation in Planned Orders | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
36 | TBKKOAUTH | Amount Authorization/Dual Control Payment Order | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPPortfolio |
37 | VDCO_PRO_ASS1 | Assignment: Product + Parameters ---> Condition Table | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
38 | VDCO_PRO_ASS2 | Assignment: Product ---> Condition Table | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPProduct definition |
39 | FIPR_PARTPROD | Assignment Version Partial Product | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
40 | FIPR_PRODUCT | Product, Master Data | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
41 | FIPR_PRODUCTT | Product Description | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
42 | FIPR_PRODV | Version of a Prodcut, Master Data | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
43 | FIPR_VA | Version Attribute | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
44 | FIPR_VA_FLD | Version Attribute Category Field | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
45 | FIPR_VA_FLDM | Version Attribute Category Field: Multiple Value Fields | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
46 | FIPR_VA_FLDVAL | Version Attribute Category Field: Value Restriction | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
47 | FIPR_VA_VALUE | Version Attribute Category List | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
48 | FIPR_VA_VALUE2 | Version Attribute Category Matrix | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
49 | TBKKH1 | Permitted Products per Bank Area | 3 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |
TOPTransaction Data Pool |
50 | JBDTDALLBCA | Assignment of BCA Product to Transaction Differentiations | 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | | |