| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInventory and Production |
| 1 | AITM | Items - History | 318 | SOIExc | SOI Excisable | VarChar | 1 | 0 | 4 | 1=Excisable, 2=Exemption of excises, 3=Excises are paid to another authority, 4=Not Excisable |
| 2 | OITM | Items | 318 | SOIExc | SOI Excisable | VarChar | 1 | 0 | 4 | 1=Excisable, 2=Exemption of excises, 3=Excises are paid to another authority, 4=Not Excisable |
| 3 | SITM | Items | 318 | SOIExc | SOI Excisable | VarChar | 1 | 0 | 4 | 1=Excisable, 2=Exemption of excises, 3=Excises are paid to another authority, 4=Not Excisable |
| 4 | UITM | Items | 318 | SOIExc | SOI Excisable | VarChar | 1 | 0 | 4 | 1=Excisable, 2=Exemption of excises, 3=Excises are paid to another authority, 4=Not Excisable |
