| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBank Customer Accounts |
1 | TBCA_US_DEA_REL | Cross Reference Escheat Relationship Codes | 4 | REL_TYP | Business Partner Relationship Category | nvarchar | 6 | 0 | | |
2 | TBCA_US_DEA_RELT | Relationship Codes Text Description | 5 | REL_TYP | Business Partner Relationship Category | nvarchar | 6 | 0 | | |
TOPBusiness Partner |
3 | TPZ7U | BP: Business Partner - Relationship Category | 2 | REL_TYP | Business Partner Relationship Category | nvarchar | 4 | 0 | | |
TOPBusiness Partner Enhancements for Financial Services |
4 | BP2000 | BP: Business Partner - Business Partner - Relationship | 2 | REL_TYP | Business Partner Relationship Category | nvarchar | 4 | 0 | | |
5 | TPZ11 | BP: Business Partner - Relationship Type | 3 | REL_TYP | Business Partner Relationship Category | nvarchar | 4 | 0 | | |
6 | TPZ7 | BP: Business Partner - Relationship Category | 2 | REL_TYP | Business Partner Relationship Category | nvarchar | 4 | 0 | | |
7 | TPZ7T | BP: Business Partner - Name of Relationship Category | 3 | REL_TYP | Business Partner Relationship Category | nvarchar | 4 | 0 | | |
TOPCollateral Management System |
8 | CMS_REL | Relationship details | 3 | REL_TYP | Relationship type | nvarchar | 6 | 0 | | |
9 | TCMS_REL_TYP | Relationship type description | 2 | REL_TYP | Relationship type | nvarchar | 6 | 0 | | |
10 | TCMS_REL_TYP_GRP | Relationship Type - Group Mapping | 3 | REL_TYP | Relationship type | nvarchar | 6 | 0 | | |
11 | TCMS_REL_TYP_T | Relationship type (Text table) | 2 | REL_TYP | Relationship type | nvarchar | 6 | 0 | | |
TOPEnvironment, Health and Safety |
12 | T7EHS00_QFORM | Specific Questionnaire: Assign Form and Program | 2 | REL_TYP | Questionnaire Assignment Category | nvarchar | 3 | 0 | | |
13 | T7EHS00_QSCANP | File Path for the Scanner ASCII File | 2 | REL_TYP | Questionnaire Assignment Category | nvarchar | 3 | 0 | | |
TOPTreasury |
14 | TZV11 | Relationship category of partner-partner relationship | 4 | REL_TYP | Business Partner Relationship Category | nvarchar | 4 | 0 | | |