| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPInventory and Production |
| 1 | AITM | Items - History | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | I=Regular, L=Labor, T=Travel |
| 2 | OITM | Items | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | I=Items, L=Labor, T=Travel |
| 3 | UITM | Items | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | I=Items, L=Labor, T=Travel |
| TOPMarketing Documents |
| 4 | MIN2 | Item Imformation of MI | 12 | ItemType | Item Type | VarChar | 1 | 0 | I | |
| 5 | MIV2 | A/P Monthly Invoice - Item | 12 | ItemType | Item Type | VarChar | 1 | 0 | I | D=Down Payment Paid, E=Expense, I=Item, R=Rounding, S=Service, T=Tax Amount, W=WTax Amount |
