| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
1 | GBI11 | GBI Row 11 - Devalue Provision of Enterprise Assets | 3 | ItemName | Item Name | nVarChar | 100 | 0 | | |
2 | GBI12 | GBI Row 12 - Shareholder's Rights and Interests Changing Report | 5 | ItemName | Item Name | nVarChar | 100 | 0 | | |
3 | GBI13 | GBI Row 13 - Enterprise's Profit Distribution Report | 3 | ItemName | Item Name | nVarChar | 100 | 0 | | |
4 | GBI15 | GBI Row 15 - Enterprise's VAT Payable Detail Report | 3 | ItemName | Item Name | nVarChar | 100 | 0 | | |
5 | SHR1 | Shareholder's Rights and Interests Report History - Rows | 5 | ItemName | Item Name | nVarChar | 100 | 0 | | |
TOPInventory and Production |
6 | AITM | Items - History | 2 | ItemName | Item Description | nVarChar | 100 | 0 | | |
7 | IQI1 | Inventory Initial Qty Rows | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
8 | IQR1 | Inventory Stock Posting (Reconcile) Lines | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
9 | OIBT | Batch No. for Item | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
10 | OITL | Inventory Transactions Log | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
11 | OITM | Items | 2 | ItemName | Item Description | nVarChar | 100 | 0 | | |
12 | OSRI | Serial Numbers for Items | 22 | ItemName | Item Description | nVarChar | 100 | 0 | | |
13 | UITM | Items | 2 | ItemName | Item Description | nVarChar | 100 | 0 | | |
TOPMarketing Documents |
14 | MIN2 | Item Imformation of MI | 7 | ItemName | Item Name | nVarChar | 100 | 0 | | |
15 | MIV2 | A/P Monthly Invoice - Item | 7 | ItemName | Item Name | nVarChar | 100 | 0 | | |
TOPService |
16 | AINS | Customer Equipment Card - History | 15 | itemName | Item Description | nVarChar | 100 | 0 | | |
17 | ASC2 | Service Call Inventory Expenses - History | 4 | ItemName | Item Description - History | nVarChar | 100 | 0 | | |
18 | ASC3 | Service Call Travel/Labor Expenses - History | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
19 | ASCL | History | 16 | itemName | Item Description | nVarChar | 100 | 0 | | |
20 | CTR1 | Service Contract - Items | 6 | ItemName | Item Description | nVarChar | 100 | 0 | | |
21 | OINS | Customer Equipment Card | 15 | itemName | Item Description | nVarChar | 100 | 0 | | |
22 | OSCL | Service Calls | 16 | itemName | Item Description | nVarChar | 100 | 0 | | |
23 | SCL2 | Service Call Inventory Expenses | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
24 | SCL3 | Service Call Travel/Labor Expenses | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |