| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CN/CTXSAPX0100 | Country/Region | 25 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
2 | /1CN/CTXSAPX0101 | Country/Supplier BP ID/Business Partner ID | 26 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
3 | /1CN/CTXSAPX0102 | Country/Business Partner Tax Group | 25 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
4 | /1CN/CTXSAPX0103 | Country/Supplier BP ID/Business Partner ID/Product Tax Group | 29 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
5 | /1CN/CTXSAPX0104 | Recipient Country/Recipient Tax Region/Locat. Relationship | 26 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
6 | /1CN/CTXSAPX0105 | Country/Product Tax Group | 25 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
7 | /1CN/CTXSAPX0106 | Country/Region/Product Tax Group | 26 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
8 | /1CN/CTXSAPX0140 | Country/Product Tax Group/Jurisdiction Code | 25 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
9 | /1CN/CTXSAPX0141 | Country/Business Partner Tax Group/Jurisdiction Code | 25 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
10 | /1CN/CTXSAPX0146 | Country/Region/Product Tax Group | 25 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
11 | /1CN/CTXSAPX0147 | Country/Region/Business Partner Tax Group | 25 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
12 | /1CN/CTXSAPX0148 | Country | 23 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
13 | /1CN/CTXSAPXBR01 | Country/Tax Tariff Code | 24 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
14 | /1CN/CTXSAPXBR02 | Country/Product Tax Group | 24 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
15 | /1CN/CTXSAPXBR03 | Country/Product Tax Group/Business Partner Tax Group | 25 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
16 | /1CN/CTXSAPXBR11 | Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code | 26 | REASONCODE | Exemption reason in TTE | nvarchar | 6 | 0 | | |
17 | /BSNAGT/FILE_INF | File Status Information | 21 | REASONCODE | Reason Code for Error | nvarchar | 3 | 0 | | |
18 | T7PIQINVRSN | Possible reason codes for invalidating External Test Result | 2 | REASONCODE | Reason for invalidating the Test Result | nvarchar | 3 | 0 | | |
19 | T7PIQINVRSNT | Possible reasons for invalidating an External Test Result | 3 | REASONCODE | Reason for invalidating the Test Result | nvarchar | 3 | 0 | | |
TOPMedia Product Sales and Distribution |
20 | JKSDDEMANDFIXDAT | IS-M: Fix Planned Quantities - Media Issues | 8 | REASONCODE | Comment | nvarchar | 50 | 0 | | |
21 | JKSDDEMANDFIXISS | IS-M: Fix Planned Quantities - Media Issues | 8 | REASONCODE | Comment | nvarchar | 50 | 0 | | |
22 | JKSEINTERRUPT | IS-M: Suspensions | 12 | REASONCODE | Reason for Suspension | nvarchar | 2 | 0 | | |
23 | TJKSDREASONCODE | IS-M/SD: Reasons for Quantity Changes | 2 | REASONCODE | IS-M: Reason for Quantity Change | nvarchar | 2 | 0 | | |
24 | TJKSDREASONCODET | IS-M/SD: Reasons for Quantity Changes - Texts | 2 | REASONCODE | IS-M: Reason for Quantity Change | nvarchar | 2 | 0 | | |
TOPTransaction Tax Engine |
25 | TTED_INEXEMP_COM | Exemptions | 14 | REASONCODE | Reason Code | nvarchar | 6 | 0 | | |
26 | TTED_OEXEMP_COM | Output Exemptions | 14 | REASONCODE | Reason Code | nvarchar | 6 | 0 | | |
27 | TTEPD3_EXEMP | Exemptions | 14 | REASONCODE | Reason Code | nvarchar | 6 | 0 | | |
28 | TTEPDT_EXEMPT | Persistency TTE Document Output Exemptions | 11 | REASONCODE | Reason Code | nvarchar | 6 | 0 | | |
29 | TTESDT_EXEMPT | Output Exemptions | 11 | REASONCODE | Reason Code | nvarchar | 6 | 0 | | |