| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAgency Business Global Trade |
1 | TWLFEX | Determination of Transaction Type for Intrastat Declaration | 5 | ITEMCAT | Agency Business: Item Category | nvarchar | 1 | 0 | | |
2 | WBRP | Agency business: Item | 88 | ITEMCAT | Agency Business: Item Category | nvarchar | 1 | 0 | | |
TOPClaims Management |
3 | ICLITEM | Claim Item | 9 | ITEMCAT | Claim Item Category | nvarchar | 2 | 0 | | |
4 | ICL_WCMPD | FS-CM: Item Data Workers Compensation | 10 | ITEMCAT | Workers Compensation Item Category | nvarchar | 2 | 0 | | |
5 | ICL_WCMPD_SCH | FS-CM: Item Data Workers Compensation | 10 | ITEMCAT | Workers Compensation Item Category | nvarchar | 2 | 0 | | |
6 | ICSITEM | Claim Item | 9 | ITEMCAT | Claim Item Category | nvarchar | 2 | 0 | | |
7 | ICS_WCMPD | FS-CM: Item Data Workers Compensation | 10 | ITEMCAT | Workers Compensation Item Category | nvarchar | 2 | 0 | | |
8 | ICS_WCMPD_SCH | FS-CM: Scheduled Workers Compensation | 10 | ITEMCAT | Workers Compensation Item Category | nvarchar | 2 | 0 | | |
9 | TICL139 | Claim Item Category | 2 | ITEMCAT | Claim Item Category | nvarchar | 2 | 0 | | |
10 | TICL139T | Name: Claim Item Category | 3 | ITEMCAT | Claim Item Category | nvarchar | 2 | 0 | | |
TOPEnvironment, Health and Safety |
11 | /TDAG/CPT_TRCKI | Obsolete - CP: Tracker - Positionsdaten | 4 | ITEMCAT | Item Category | nvarchar | 3 | 0 | | |
12 | /TDAG/CPT_TRCKIA | Obsolete - CP: Tracker - Positionsdaten / Archiv | 4 | ITEMCAT | Item Category | nvarchar | 3 | 0 | | |
TOPLocalization |
13 | ISJPINVSUMIT | Line items for invoice summary | 26 | ITEMCAT | Item category | nvarchar | 2 | 0 | | |