| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | CDPM | Dynamic Permission | 3 | ObjectType | Object Type | Int | 11 | 0 | | |
2 | OCMN | Customized Menu | 7 | ObjectType | Target Object Type | Int | 11 | 0 | | |
3 | OUTB | User Tables | 4 | ObjectType | Object Type | nVarChar | 20 | 0 | 0 | |
TOPBanking |
4 | ARC7 | Incoming Payments - Tax Amount per Document - History | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 24 | |
5 | ARC8 | Incoming Payment - TDS Entries - History | 6 | ObjectType | Object Type | nVarChar | 20 | 0 | 24 | |
6 | PDF7 | Payment Draft - Tax Amount per Document | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 24 | |
7 | PDF8 | Payment Draft - TDS Entries | 6 | ObjectType | Object Type | nVarChar | 20 | 0 | | |
8 | PMV8 | Incoming Payment - TDS Entries | 6 | ObjectType | Object Type | nVarChar | 20 | 0 | 24 | |
9 | RCT7 | Incoming Pmt - Tax Amount per Document | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 24 | |
10 | RCT8 | Incoming Payment - TDS Entries | 6 | ObjectType | Object Type | nVarChar | 20 | 0 | 24 | |
11 | TMP8 | Incoming Payment - TDS Entries | 6 | ObjectType | Object Type | nVarChar | 20 | 0 | 24 | |
12 | VPM7 | Outgoing Payments - Tax Amount per Document | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 46 | |
13 | VPM8 | Outgoing Payment - TDS Entries | 6 | ObjectType | Object Type | nVarChar | 20 | 0 | 46 | |
TOPFinance |
14 | VTR1 | Tax Groups | 5 | ObjectType | Object Type | VarChar | 1 | 0 | | |
TOPInventory and Production |
15 | IGE12 | Goods Issue - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 60 | |
16 | IGE14 | Goods Issue - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 60 | |
17 | IGE4 | Goods Issue - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
18 | IGN12 | Goods Receipt - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 59 | |
19 | IGN14 | Goods Receipt - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 59 | |
20 | IGN4 | Goods Receipt - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
21 | WTQ12 | Inventory Transfer Request - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
22 | WTQ14 | Inventory Transfer Request - Assembly - Rows | 9 | ObjectType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
23 | WTQ4 | Inventory Transfer Request - Tax Amount per Document | 17 | ObjectType | Base Amount (SC) | nVarChar | 20 | 0 | | |
24 | WTR12 | Inventory Transfer - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 67 | |
25 | WTR14 | Inventory Transfer - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 67 | |
26 | WTR4 | Inventory Transfer - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
TOPMarketing Documents |
27 | ADO12 | A/R Invoice - Tax Extension - History | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | | |
28 | ADO14 | Invoice - Assembly - Rows - History | 9 | ObjectType | object type | nVarChar | 20 | 0 | | |
29 | ADO4 | Documents - Tax - History | 17 | ObjectType | Base Amount (SC) | nVarChar | 20 | 0 | | |
30 | CIN12 | Correction Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 132 | |
31 | CIN4 | Correction Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 132 | |
32 | CPI12 | A/P Correction Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 163 | |
33 | CPI14 | A/P Correction Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 163 | |
34 | CPI4 | A/P Correction Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 163 | |
35 | CPV12 | A/P Correction Invoice Reversal - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 164 | |
36 | CPV14 | A/P Correction Invoice Reversal - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 164 | |
37 | CPV4 | A/P Correction Invoice Reversal - Tax Amt per Doc. | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 164 | |
38 | CSI12 | A/R Correction Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 165 | |
39 | CSI14 | A/R Correction Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 165 | |
40 | CSI4 | A/R Correction Invoice - Tax Amount Per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 165 | |
41 | CSV12 | A/R Correction Invoice Reversal - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 166 | |
42 | CSV14 | A/R Correction Invoice Reversal - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 166 | |
43 | CSV4 | A/R Correction Invoice Reversal - Tax Amount Per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 166 | |
44 | DLN12 | Delivery - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 15 | |
45 | DLN14 | Delivery Notes - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 15 | |
46 | DLN4 | Delivery - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 15 | |
47 | DPI12 | Down Payment In - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 203 | |
48 | DPI14 | A/R Down Payment - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 203 | |
49 | DPI4 | A/R Down Payment - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 203 | |
50 | DPO12 | Down Payment - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 204 | |
51 | DPO14 | A/P Down Payment - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 204 | |
52 | DPO4 | A/P Down Payment - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 204 | |
53 | DRF12 | Draft - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 112 | |
54 | DRF14 | Draft - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | | |
55 | DRF4 | Draft Documents - Tax | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
56 | IEI12 | Incoming Excise Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 140000010 | |
57 | IEI14 | Incoming Excise Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 140000010 | |
58 | IEI4 | Incoming Excise Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 140000010 | |
59 | INV12 | A/R Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
60 | INV14 | A/R Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 13 | |
61 | INV4 | A/R Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
62 | OEI12 | Outgoing Excise Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 140000009 | |
63 | OEI14 | Outgoing Excise Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 140000009 | |
64 | OEI4 | Outgoing Excise Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 140000009 | |
65 | PCH12 | A/P Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 18 | |
66 | PCH14 | A/P Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 18 | |
67 | PCH4 | A/P Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 18 | |
68 | PDN12 | Goods Receipt PO - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 20 | |
69 | PDN14 | Goods Receipt PO - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 20 | |
70 | PDN4 | Goods Receipt PO - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 20 | |
71 | POR12 | Purchase Order - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 22 | |
72 | POR14 | Purchase Order - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 22 | |
73 | POR4 | Purchase Order - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 22 | |
74 | PQT12 | Purchase Quotation - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 540000006 | |
75 | PQT14 | Purchase Quotation - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 540000006 | |
76 | PQT4 | Purchase Quotation - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 540000006 | |
77 | QUT12 | Sales Quotation - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 23 | |
78 | QUT14 | Sales Quotation - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 23 | |
79 | QUT4 | Sales Quotation - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 23 | |
80 | RDN12 | Returns - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 16 | |
81 | RDN14 | Return - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 16 | |
82 | RDN4 | Returns - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 16 | |
83 | RDR12 | Sales Order - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 17 | |
84 | RDR14 | Sales Order - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 17 | |
85 | RDR4 | Sales Order - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 17 | |
86 | RIN12 | A/R Credit Memo - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 14 | |
87 | RIN14 | A/R Credit Memo - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 14 | |
88 | RIN4 | A/R Credit Memo - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 14 | |
89 | RPC12 | A/P Credit Memo - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 19 | |
90 | RPC14 | A/P Credit Memo - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 19 | |
91 | RPC4 | A/P Credit Memo - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 19 | |
92 | RPD12 | Goods Return - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 21 | |
93 | RPD14 | Goods Return - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 21 | |
94 | RPD4 | Goods Return - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 21 | |
TOPService |
95 | ASC2 | Service Call Inventory Expenses - History | 12 | ObjectType | Object Type - History | nVarChar | 20 | 0 | 191 | |
96 | ASC3 | Service Call Travel/Labor Expenses - History | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
97 | ASC4 | Service Call Travel/Labor Expenses - History | 7 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
98 | ASC5 | Service Call Activities - History | 4 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
99 | MDC1 | Master Data Cleanup - Log | 3 | ObjectType | Object Type | nVarChar | 20 | 0 | | |
100 | MDC2 | Master Data Cleanup - MD Log | 2 | ObjectType | Object Type | nVarChar | 20 | 0 | | |
101 | SCL2 | Service Call Inventory Expenses | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
102 | SCL3 | Service Call Travel/Labor Expenses | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
103 | SCL4 | Expense Documents | 7 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
104 | SCL5 | Service Call Activities | 4 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |