| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBusiness Partners |
1 | ACP2 | Campaign - Items | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
2 | AOA1 | Blanket Agreement - Rows | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
3 | CPN2 | Campaign - Items | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
4 | OAT1 | Blanket Agreement - Rows | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
TOPFinance |
5 | GBI11 | GBI Row 11 - Devalue Provision of Enterprise Assets | 3 | ItemName | Item Name | nVarChar | 100 | 0 | | |
6 | GBI12 | GBI Row 12 - Shareholder's Rights and Interests Changing Report | 5 | ItemName | Item Name | nVarChar | 100 | 0 | | |
7 | GBI13 | GBI Row 13 - Enterprise's Profit Distribution Report | 3 | ItemName | Item Name | nVarChar | 100 | 0 | | |
8 | GBI15 | GBI Row 15 - Enterprise's VAT Payable Detail Report | 3 | ItemName | Item Name | nVarChar | 100 | 0 | | |
9 | SHR1 | Shareholder's Rights and Interests Report History - Rows | 5 | ItemName | Item Name | nVarChar | 100 | 0 | | |
TOPInventory and Production |
10 | ABTN | Batch Numbers Master Data | 21 | itemName | Item Description | nVarChar | 100 | 0 | | |
11 | AITM | Items - History | 2 | ItemName | Item Description | nVarChar | 100 | 0 | | |
12 | ASRN | Serial Numbers Master Data | 21 | itemName | Item Description | nVarChar | 100 | 0 | | |
13 | IQI1 | Inventory Initial Qty Rows | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
14 | IQR1 | Inventory Stock Posting (Reconcile) Lines | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
15 | OBTN | Batch Numbers Master Data | 21 | itemName | Item Description | nVarChar | 100 | 0 | | |
16 | ODBN | Bat. Nos - Draft - Master Data | 21 | itemName | Item Description | nVarChar | 100 | 0 | | |
17 | ODSN | SNs - Draft - Master Data | 21 | itemName | Item Description | nVarChar | 100 | 0 | | |
18 | OIBT | Batch No. for Item | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
19 | OITL | Inventory Transactions Log | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
20 | OITM | Items | 2 | ItemName | Item Description | nVarChar | 100 | 0 | | |
21 | OSRI | Serial Numbers for Items | 22 | ItemName | Item Description | nVarChar | 100 | 0 | | |
22 | OSRN | Serial Numbers Master Data | 21 | itemName | Item Description | nVarChar | 100 | 0 | | |
23 | SITM | Items | 2 | ItemName | Item Description | nVarChar | 100 | 0 | | |
24 | UITM | Items | 2 | ItemName | Item Description | nVarChar | 100 | 0 | | |
TOPMarketing Documents |
25 | GTI1 | GTS Invoice Details | 4 | ItemName | Item Name | nVarChar | 60 | 0 | | |
26 | GTM1 | GTS Mapping Object Details | 4 | ItemName | Item Name | nVarChar | 100 | 0 | | |
27 | MIN2 | Item Imformation of MI | 7 | ItemName | Item Name | nVarChar | 100 | 0 | | |
28 | MIV2 | A/P Monthly Invoice - Item | 7 | ItemName | Item Name | nVarChar | 100 | 0 | | |
TOPService |
29 | AINS | Customer Equipment Card - History | 15 | itemName | Item Description | nVarChar | 100 | 0 | | |
30 | ASC2 | Service Call Inventory Expenses - History | 4 | ItemName | Item Description - History | nVarChar | 100 | 0 | | |
31 | ASC3 | Service Call Travel/Labor Expenses - History | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
32 | ASCL | History | 16 | itemName | Item Description | nVarChar | 100 | 0 | | |
33 | CTR1 | Service Contract - Items | 6 | ItemName | Item Description | nVarChar | 100 | 0 | | |
34 | OINS | Customer Equipment Card | 15 | itemName | Item Description | nVarChar | 100 | 0 | | |
35 | OSCL | Service Calls | 16 | itemName | Item Description | nVarChar | 100 | 0 | | |
36 | SCL2 | Service Call Inventory Expenses | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |
37 | SCL3 | Service Call Travel/Labor Expenses | 4 | ItemName | Item Description | nVarChar | 100 | 0 | | |