| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CBP_TAXCLASS | Obsolete... | 2 | COUNTRY_KEY | Country Key | nvarchar | 3 | 0 | | |
2 | CTCET_TAXCLASS | Assign Tax Group/Tax Type to SAP ECC Tax Classification-TCET | 2 | COUNTRY_KEY | Country Key | nvarchar | 3 | 0 | | |
3 | DIAN_C_COUNTRY | DIAN Corresponding Country numbers | 2 | COUNTRY_KEY | Country Key | nvarchar | 3 | 0 | | |
4 | TCM_C_BPTAXCLASS | Assign Tax Group/Tax Type to SAP ECC Tax Classification BP | 2 | COUNTRY_KEY | Country Key | nvarchar | 3 | 0 | | |
5 | TCM_C_TCTXC_MAP | Map transportation charge type to Tax code | 3 | COUNTRY_KEY | Country Key | nvarchar | 3 | 0 | | |
TOPBusiness Partner |
6 | BP1030 | BP: Business partner - reporting data | 32 | COUNTRY_KEY | Numeric Code for German Federal Bank Country Indicator | nvarchar | 4 | 0 | | |
7 | TPLZB | Land gem. LZB-Länderkennzeichen | 2 | COUNTRY_KEY | Numerischer Code des LZB-Länderkennzeichens | nvarchar | 4 | 0 | | |
8 | TPLZBT | Bezeichnung Land gem. LZB-Länderkennzeichen | 3 | COUNTRY_KEY | Numerischer Code des LZB-Länderkennzeichens | nvarchar | 4 | 0 | | |
9 | TPZ_LZB | Country According to German Federal Bank Country Indicator | 1 | COUNTRY_KEY | Numeric Code for German Federal Bank Country Indicator | nvarchar | 4 | 0 | | |
TOPMaster Data |
10 | CMS_AST | Asset Details | 11 | COUNTRY_KEY | Identification Key for Country | nvarchar | 3 | 0 | | |
11 | CMS_CAG | Collateral Agreement Details | 15 | COUNTRY_KEY | Jurisdiction Country | nvarchar | 3 | 0 | | |
TOPNon Profit Organizations |
12 | T7UNPAD_DPAC | Counries for dependency allowance amount calculation | 3 | COUNTRY_KEY | Country Key | nvarchar | 3 | 0 | | |