| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
1 | AACP | Periods Category-Log | 36 | ExmptIncom | Tax Exempt Revenue Account | nVarChar | 15 | 0 | | |
2 | AGAR | G/L Account Advanced Rules - History | 34 | ExmptIncom | Tax Exempt Revenue Account | nVarChar | 15 | 0 | | |
3 | OACP | Periods Category | 36 | ExmptIncom | Tax Exempt Revenue Account | nVarChar | 15 | 0 | | |
4 | OGAR | G/L Account Advanced Rules | 34 | ExmptIncom | Tax Exempt Revenue Account | nVarChar | 15 | 0 | | |
TOPInventory and Production |
5 | AITB | Item Groups - History | 19 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
6 | AITM | Items - History | 16 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
7 | AITW | Items - Warehouse - History | 28 | ExmptIncom | Exempt Revenues Account | nVarChar | 15 | 0 | | |
8 | AWHS | Warehouses - History | 31 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
9 | OITB | Item Groups | 19 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
10 | OITM | Items | 16 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
11 | OITW | Items - Warehouse | 28 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
12 | OWHS | Warehouses | 31 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
13 | SITM | Items | 16 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
14 | SITW | Items - Warehouse | 28 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
15 | UITM | Items | 16 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |
16 | UITW | Items - Warehouse | 28 | ExmptIncom | Exempt Revenue Account | nVarChar | 15 | 0 | | |