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