| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IBS/TRB_ECF_HD | RBD ECF - Value Adjustment Header Data | 42 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
2 | /IBS/TRB_ECH_HD | RBD ECF - Value Adjustment History - Header Data | 43 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
3 | CMS_ARC_CAG | CAG Archiving table | 6 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
4 | CMS_ARC_INS | Insurance Archiving table | 7 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
5 | CMS_ARC_MOVABLES | Movables Archiving Table | 7 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
6 | CMS_ARC_RBL | Receivables Archiving Table | 6 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
7 | CMS_ARC_RE_OBJ | Real Estate Archiving Table | 6 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
8 | CMS_ARC_RIG | RightsArchiving table: Includes claims and patents also | 7 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
9 | CMS_ARC_SEC_ACC | Securities Account Archiving Table | 6 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
10 | CMS_ARC_SHP | Ship Archiving Table | 6 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
TOPAccounting Interface |
11 | GLE_ECS_DI_ADM0 | Management of ECS Direct Input | 12 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
12 | GLE_ECS_ITEM | ECS: Error Correction Items | 35 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
13 | GLE_RUNADM_ID | ERP Run Administration | 18 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
TOPArchiving |
14 | EABLARC | Internal index f. analyzing archivable meter reading results | 4 | ARCHIVE_STATUS | Archive Status of a Meter Reading Document | nvarchar | 1 | 0 | | |
15 | ERCHARC | Index for Archivable Billing Documents | 3 | ARCHIVE_STATUS | Document's archiving status | nvarchar | 1 | 0 | | |
TOPArchiving Engine |
16 | TARCHFLIGHT | Archiving Example: Flights | 15 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
17 | TARCHFLIGHTCONN | Archiving Example: Flight Connections | 9 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
TOPBank Customer Accounts |
18 | BKK_PRENOTE | Prenotes | 46 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
TOPClaims Management |
19 | ICLCCEVENT | Claim Bundle | 45 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
20 | ICLCLAIM | Claim | 95 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
21 | ICLINDRES | Reserve Lot | 13 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
22 | ICLSERVCAT | FS-CM: Benefits/Services/Fees Catalogs | 42 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
23 | ICLSUBCL | Subclaim | 50 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
24 | ICSCCEVENT | Shadow Table Claim Bundle | 45 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
25 | ICSCLAIM | Claim | 95 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
26 | ICSSUBCL | Subclaim | 50 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
27 | IMP_WORKSETS | IMP: Workset | 16 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
TOPCorrespondence Tool |
28 | DFKKCOHI | Correspondence - Correspondence History | 39 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
29 | DFKKCOH_ARC | FI-CA Correspondence - Correspondence Header | 4 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
TOPDefault Risk and Limit System |
30 | KLFAZ01 | Facilities (Header) | 22 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
31 | KLSI01 | Collateral Provision (Header) | 20 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
TOPFinancial Conditions |
32 | FICOT_AMT | Amount Table (Obsolete; Not used for persistency) | 78 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
33 | FICOT_CONDI | Conditions (Unbuffered) | 120 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
34 | FICOT_CONDI_BUFF | Conditions (Buffered) | 120 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
35 | FICOT_DATE | Date (Obsolete; Not used for persistency) | 58 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
TOPFinancial Supply Chain Management |
36 | BNK_BATCH_HEADER | Batch Header | 24 | ARCHIVE_STATUS | Archive Status | nvarchar | 2 | 0 | | |
TOPFramework for the Principle of Dual Control |
37 | BCA_REL_LOG_H | Header Data of Log Table for Release | 6 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
TOPPostprocessing Office |
38 | /SAPPO/ORDER_HDR | Postprocessing Order - Header Data | 78 | ARCHIVE_STATUS | | nvarchar | 1 | 0 | | |
TOPRisk Analysis |
39 | JBRDBKO | RM: DB Table Header Information Extended Risk Object | 26 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
40 | JBRHKO | RM: Version Table: Header Information: Extended Risk Object | 27 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
41 | JBROZ | RM Gap Opportunity Interest Rates from Single Trans. Costing | 6 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
42 | JBRSVGAPHD2 | RM: Header Data (Saved Gap Evaluation Results) | 48 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
TOPTransaction Data Pool |
43 | JBDOBJ1 | Object Table for Financial Transactions, General Part | 33 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
44 | JBDVTBA | Variable Transaction - Balances | 6 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
45 | JBDVTMD | Variable transaction - master data | 19 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
46 | JBDVTTO | Variable Transaction - Turnovers | 9 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
47 | JBDZSKO | Cash Flow Header | 32 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
48 | TJBD_VDARL_ARCH | Archiving Status for Loans | 6 | ARCHIVE_STATUS | Archivability Status | nvarchar | 1 | 0 | | |
TOPValue Adjustment |
49 | /IBS/TRB_SHEETH | RBD IAS - Header Data of Valuation Sheet | 65 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |
50 | /IBS/TRB_SHISTH | RBD IAS - History Header Data Valuation Sheet | 66 | ARCHIVE_STATUS | Archiving Status | nvarchar | 1 | 0 | | |