| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | IDAR_TXDITM | Document item used in country specific taxation | 7 | LICNO | Tax exemption license number | nvarchar | 20 | 0 | | |
| 2 | J1IEX_LICUTL_LOG | EXIM : License Detail | 3 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| 3 | J_1I_LICDTL | EXIM : License Detail | 3 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| 4 | J_1I_LICHDR | EXIM : License Header | 3 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| 5 | J_1I_LICSTATUS | EXIM : License Status Details | 3 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| 6 | J_1I_LICT | EXIM : License Text | 4 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| 7 | J_1I_PMLICUTIL | EXIM : License Utilization | 3 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| 8 | J_1I_SHIPDTL | EXIM : Shipping Bill Detail | 8 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| 9 | T7QA17I | Company License | 6 | LICNO | Company License Number | nvarchar | 20 | 0 | | |
| TOPBasic Functions |
| 10 | TLIC | Tax Exemption License | 2 | LICNO | Tax exemption license number | nvarchar | 20 | 0 | | |
| TOPConditions |
| 11 | KONH | Conditions (Header) | 20 | LICNO | Tax exemption license number | nvarchar | 20 | 0 | | |
| 12 | KOTF006 | Tax exemption license number | 3 | LICNO | Tax exemption license number | nvarchar | 20 | 0 | | |
| TOPInvoice Verification |
| 13 | RSEG | Document Item: Incoming Invoice | 92 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| TOPLocalization |
| 14 | J_1IEXCDTL | Excise invoice line item details | 83 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| 15 | J_1ILICDTL | Excise Bonding: License detail | 3 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
| 16 | J_1ILICHDR | Excise Bonding: License Header | 3 | LICNO | Internal License Number | nvarchar | 10 | 0 | | |
