| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BSNAGT/FILE_INF | File Status Information | 11 | CRUSR | User Name | nvarchar | 12 | 0 | | |
2 | BKK_OPD_IT_EXT | External Item Selection Table - Outgoing Payment Dispatcher | 46 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
3 | BKK_SEPA_LIM_EV | Event Table for Mandate Limits | 17 | CRUSR | User Who Created Events for Mandate Limits | nvarchar | 12 | 0 | | |
4 | BKK_SEPA_LIM_HIS | History Table for Mandate Limits | 18 | CRUSR | User Who Created Events for Mandate Limits | nvarchar | 12 | 0 | | |
5 | CNVLTHCM_STATUS | Status of Path Determination | 7 | CRUSR | Created by | nvarchar | 12 | 0 | | |
6 | CNV_10020_ACT | Actions - Header data | 11 | CRUSR | Created by | nvarchar | 12 | 0 | | |
7 | CNV_10020_CDOBJH | Condition objects: Header data | 10 | CRUSR | Created by | nvarchar | 12 | 0 | | |
8 | CNV_10020_CFOBJH | Concatenated/fragmented objects: Header data | 11 | CRUSR | Created by | nvarchar | 12 | 0 | | |
9 | CNV_10020_COND | Conditions - Header data | 11 | CRUSR | Created by | nvarchar | 12 | 0 | | |
10 | CNV_10020_DTFLD | Assignment of determination to tables and fields | 24 | CRUSR | Created by | nvarchar | 12 | 0 | | |
11 | CNV_10020_DTOBJH | Determination objects | 12 | CRUSR | Created by | nvarchar | 12 | 0 | | |
12 | CNV_10020_FVOBJ | Fixed value objects | 12 | CRUSR | Created by | nvarchar | 12 | 0 | | |
13 | CNV_10020_PATH | Determination paths: Header data | 27 | CRUSR | Created by | nvarchar | 12 | 0 | | |
14 | CNV_10020_RCOMP | Assignment of rules to non-transp. field components | 15 | CRUSR | Created by | nvarchar | 12 | 0 | | |
15 | CNV_10020_RDTOBJ | Assignment of rules to determination object components | 15 | CRUSR | Created by | nvarchar | 12 | 0 | | |
16 | CNV_10020_RULE | Rules - Header data | 10 | CRUSR | Created by | nvarchar | 12 | 0 | | |
17 | CNV_10020_VLIST | Value lists - Header data | 11 | CRUSR | Created by | nvarchar | 12 | 0 | | |
18 | SEPA_CI_PROC | SEPA CI Limits and CI Whitelist | 11 | CRUSR | User Name | nvarchar | 12 | 0 | | |
19 | SEPA_CI_PROC_HIS | SEPA CI Limits and CI Whitelist | 12 | CRUSR | User Name | nvarchar | 12 | 0 | | |
TOPAccount Management |
20 | BKK42_NTC | Master Data for Notice and Allowances | 16 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
21 | BKKNTC | Notice: Partial Amount and Full Amount Notice | 17 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPBank Customer Accounts |
22 | BKK58 | Master Data Savings Prod: Fxd-Term Deposit, Installmnt Savgs | 21 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
23 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 91 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
24 | BKKSO | BCA: Standing Orders | 36 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
25 | BKK_PRENOTE | Prenotes | 37 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
26 | NIHC_DB_PO_PNTA | Source Document for Incoming Payment Orders | 41 | CRUSR | User that created or changed the object | nvarchar | 12 | 0 | | |
27 | NIHC_DB_PO_STAT | Status of Payment Order | 7 | CRUSR | User that created or changed the object | nvarchar | 12 | 0 | | |
28 | TBKKCORR | BCA: Table showing if Correspondence is Active | 3 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPBusiness Partner |
29 | BPOBTAB | Partner-Object Relationship | 13 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPFinancial Supply Chain Management |
30 | BNK_BATCH_HEADER | Batch Header | 17 | CRUSR | Create User | nvarchar | 12 | 0 | | |
31 | BNK_BTCH_STREF | Status reference | 8 | CRUSR | Create User | nvarchar | 12 | 0 | | |
32 | BNK_XSTAT_MSG | External Status Message | 6 | CRUSR | Create User | nvarchar | 12 | 0 | | |
TOPFSCM In-House Cash |
33 | IHC_DB_PN | Source Document for Incoming Payment Orders | 87 | CRUSR | Created By | nvarchar | 12 | 0 | | |
34 | IHC_DB_PN_STATUS | IHC: Payment Order Status | 13 | CRUSR | User that created or changed the object | nvarchar | 12 | 0 | | |
TOPGeneric Contract Accounts Receivable and Payable |
35 | BCA_DIM_CALCDET | Calculation details for billing items | 20 | CRUSR | Created By | nvarchar | 12 | 0 | | |
TOPGL transfer |
36 | BKKC01 | Gen.Ledger: Reconciliation Key Accounting Documents | 11 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
37 | BKKCNOITGL | Table of Items not Updated on the Account | 39 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
38 | BKKCVA | Administration Table Individual Value Adjustment | 10 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPHoliday Calendar, Factory Calendar, Appointment Calendar |
39 | TFACD | Factory calendar definition | 15 | CRUSR | Calendar: Calendar creator/changer | nvarchar | 12 | 0 | | |
40 | THOCI | Public holiday calendar index | 5 | CRUSR | Calendar: Calendar creator/changer | nvarchar | 12 | 0 | | |
TOPMaster Data |
41 | BCA_US_HLD2REL | Hold Records which have not been released - Dual Control | 23 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
42 | BCA_US_HOLD | Hold Amounts Which Affect Available Balance | 22 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPPayment Item |
43 | BKKIT | Payment Item | 91 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
44 | BKKITAI | Info Items for Interest Penalty at Balancing | 24 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
45 | BKKITENQ | Blocked Payment Items | 91 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
46 | BKKITREL | Payment Item | 91 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
47 | BKKITTMP | Planned Payment Items | 92 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
48 | BKKITTMP_DEL | Planned Payment Items - Completed | 92 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPPayment Order |
49 | BKKPOHD | Payment Order, Header Data | 30 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
50 | BKKPOHD_TMP | Planned Payment Order, Header Data | 31 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
51 | BKKPOHD_TMP_DEL | Planned Payment Order, Header Data | 31 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
52 | FMOPBL | Document Reference IS-PS <=> IS-PS-CA | 6 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPReal Estate Management |
53 | BPOBIMMO | Business Partner - Object Relationship: Real Estate | 24 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPStakeholder Relationship Management |
54 | USC_CONTACT | SRM Contact: Central Storage of Contacts | 14 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
55 | USC_CONT_DOC | SRM Contact: Documents | 8 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
56 | USC_CONT_KWD | SRM Contact: Keywords | 5 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
57 | USC_CONT_REL | SRM Contact: Related Contacts | 5 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
58 | USC_CONT_STH | SRM Contact: Stakeholders | 11 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
59 | USS_STAKEHOLDER | SEM-SRM: Specific Master Data of Stakeholder | 9 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
60 | USS_STH_COVER | SEM-SRM: Relationship Stakeholder and Coverage | 5 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
61 | USS_STH_EXPECT | SEM-SRM: Expectations of Stakeholders | 15 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
62 | USS_STH_INFL | SEM-SRM: Influence of Stakeholders | 10 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
63 | USS_STH_SHARE | SEM-SRM: Shares of Stakeholders | 9 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
64 | USS_STH_STH_GRP | SEM-SRM: Group of Stakeholders | 8 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
TOPUse AP-MD-BP Components |
65 | BUT000 | BP: General data I | 76 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
66 | BUT000_TD | BP: General Data I, Shadow Table Time Dependency | 77 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
67 | BUT000_TDS | BP: General Data I, Shadow Table Time Dependency | 78 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
68 | BUT050 | BP relationships/role definitions: General data | 12 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |
69 | BUT050S | BP Relationships/Role Definitions: General Data | 13 | CRUSR | User who created the object | nvarchar | 12 | 0 | | |