| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JJCPFREESUB | IS-M: Free Subscription - Contact Person Relationship | 10 | STARTDATUM | Valid-From Date | nvarchar | 8 | 0 | | |
2 | JJCPRESPONSIB | IS-M: Responsibility in Contact Person Relationship | 13 | STARTDATUM | Valid-From Date | nvarchar | 8 | 0 | | |
3 | JJTAF | IS-M/AM: Free Subscription for Media Contact Person | 10 | STARTDATUM | Valid-From Date | nvarchar | 8 | 0 | | |
4 | JJTAZ | IS-M/AM: Media Contact Person Responsibility | 13 | STARTDATUM | Valid-From Date | nvarchar | 8 | 0 | | |
TOPAssetLiability Management |
5 | JBRLZB | Maturity band | 3 | STARTDATUM | Start Date of Maturity Band | nvarchar | 8 | 0 | | |
TOPClinical System |
6 | NJOBSTART | IS-H*MED: Log for jobs started | 4 | STARTDATUM | Field of type DATS | nvarchar | 8 | 0 | | |
TOPLocal Currency Changeover |
7 | EWUPGSTAT | Conversion programs status | 7 | STARTDATUM | Start date of the program | nvarchar | 8 | 0 | | |
TOPReporting |
8 | P05T_CVZ_REG_DAT | (De)registration data for HCIB | 25 | STARTDATUM | Effective Date End of Benefit, Relocation Date | nvarchar | 10 | 0 | | |