| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCollateral Management System |
1 | TCMS_BPF_BPF_SET | Business Partner Function Sets | 2 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
2 | TCMS_BPF_SET | Business Partner Function Sets | 2 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
3 | TCMS_BPF_SET_T | Business Partner Function Sets | 2 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
4 | TCMS_COR_TYP_GRP | Correspondence type grouping | 5 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
TOPLiquidation |
5 | TCMS_LIQ_TYP | Liquidation types | 3 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
TOPMaster Data |
6 | TCMS_AST_TYP | Asset Type Details | 9 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
7 | TCMS_CAG_TYP | Collateral Agreement type Description | 7 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
8 | TCMS_PRD | Product description | 10 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
9 | TCMS_SAS_TYP | Sub-asset type details | 4 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
TOPMovables |
10 | TCMS_MOV_TYP | Customizing table for Movable Type | 10 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
11 | TCMS_MVTY_PRTY | Relation between Object Types -> Part Types | 9 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
TOPReal Estate |
12 | TCMS_RE_TYP | Customizing table for real estate types | 10 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
TOPRights |
13 | TCMS_INS_TYP | Customizing table for Insurance Type | 9 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
14 | TCMS_RIG_TYP | Right Types (Patents & Claims) | 9 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
TOPSecurities |
15 | TCMS_SEC_AST | Asset type for securities accounts | 7 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |
TOPShip |
16 | TCMS_SHP_TYP | Customizing table for Ship type | 9 | BPF_SET | Business Partner Function Set | nvarchar | 6 | 0 | | |