| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TCM_C_TCTXC_MAP | Map transportation charge type to Tax code | 2 | TRCHARG_TYPECD | Transportation Charge Item Type Code | nvarchar | 15 | 0 | | |
TOPSupply Chain Management |
2 | TCMC_TCET | Charge Calculation - Charge Element Type | 2 | TRCHARG_TYPECD | Transportation Charge Element Type Code | nvarchar | 15 | 0 | | |
3 | TCMC_TCETT | Charge Calculation - Charge Element Type (Text Tab.) | 3 | TRCHARG_TYPECD | Transportation Charge Element Type Code | nvarchar | 15 | 0 | | |
4 | TCM_C_COND_MAP | Mapping Transportation Charges Elements - Conditions | 4 | TRCHARG_TYPECD | Transportation Charge Item Type Code | nvarchar | 15 | 0 | | |
5 | TCM_C_TCET | Charge Calculation - Charge Element Type | 2 | TRCHARG_TYPECD | Transportation Charge Item Type Code | nvarchar | 15 | 0 | | |
6 | TCM_C_TCETT | Charge Calculation - Charge Element Type (Text Tab.) | 3 | TRCHARG_TYPECD | Transportation Charge Item Type Code | nvarchar | 15 | 0 | | |
7 | TCM_C_TCETYP_MAP | Mapping Transportation Charges Elements External/Internal | 2 | TRCHARG_TYPECD | Charge Type Code External | nvarchar | 4 | 0 | | |
8 | TCM_D_TC_SRV_MAP | Mapping Transportation Charges Elements - Services | 4 | TRCHARG_TYPECD | Transportation Charge Item Type Code | nvarchar | 15 | 0 | | |
9 | TCM_TCETY_MAP | Mapping Transportation Charges Elements external/internal | 2 | TRCHARG_TYPECD | Transportation Charge Element Type Code External | nvarchar | 4 | 0 | | |
10 | TCM_TCET_MAP | Mapping Transportation Charges Elements external/internal | 2 | TRCHARG_TYPECD | Transportation Charge Element Type Code External | nvarchar | 4 | 0 | | |
11 | TCM_TC_CE_MAP | Mapping Charge Elements -> Cost Elements | 4 | TRCHARG_TYPECD | Transportation Charge Element Type Code | nvarchar | 15 | 0 | | |
12 | TCM_TC_COND_MAP | Mapping Transportation Charges Elements - Conditions | 4 | TRCHARG_TYPECD | Transportation Charge Element Type Code | nvarchar | 15 | 0 | | |
13 | TCM_TC_SRV_MAP | Mapping Transportation Charges Elements - Services | 4 | TRCHARG_TYPECD | Transportation Charge Element Type Code | nvarchar | 15 | 0 | | |