| 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 | 0=No Object, 1=Master Data, 2=Master Data Lines, 3=Document, 4=Document Lines |
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 | IGE4 | Goods Issue - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
17 | IGN12 | Goods Receipt - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 59 | |
18 | IGN4 | Goods Receipt - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
19 | WTR12 | Inventory Transfer - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 67 | |
20 | WTR4 | Inventory Transfer - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
TOPMarketing Documents |
21 | ADO12 | A/R Invoice - Tax Extension - History | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | | |
22 | ADO14 | Invoice - Assembly - Rows - History | 9 | ObjectType | object type | nVarChar | 20 | 0 | | |
23 | ADO4 | Documents - Tax - History | 17 | ObjectType | Base Amount (SC) | nVarChar | 20 | 0 | | |
24 | CIN12 | Correction Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 132 | |
25 | CIN4 | Correction Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 132 | |
26 | CPI12 | A/P Correction Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 163 | |
27 | CPI14 | A/P Correction Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 163 | |
28 | CPI4 | A/P Correction Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 163 | |
29 | CPV12 | A/P Correction Invoice Reversal - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 164 | |
30 | CPV14 | A/P Correction Invoice Reversal - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 164 | |
31 | CPV4 | A/P Correction Invoice Reversal - Tax Amt per Doc. | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 164 | |
32 | CSI12 | A/R Correction Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 165 | |
33 | CSI14 | A/R Correction Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 165 | |
34 | CSI4 | A/R Correction Invoice - Tax Amount Per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 165 | |
35 | CSV12 | A/R Correction Invoice Reversal - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 166 | |
36 | CSV14 | A/R Correction Invoice Reversal - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 166 | |
37 | CSV4 | A/R Correction Invoice Reversal - Tax Amount Per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 166 | |
38 | DLN12 | Delivery - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 15 | |
39 | DLN14 | Delivery Notes - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 15 | |
40 | DLN4 | Delivery - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 15 | |
41 | DPI12 | Down Payment In - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 203 | |
42 | DPI14 | A/R Down Payment - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 203 | |
43 | DPI4 | A/R Down Payment - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 203 | |
44 | DPO12 | Down Payment - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 204 | |
45 | DPO14 | A/P Down Payment - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 204 | |
46 | DPO4 | A/P Down Payment - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 204 | |
47 | DRF12 | Draft - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 112 | |
48 | DRF14 | Draft - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | | |
49 | DRF4 | Draft Documents - Tax | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
50 | IEI12 | Incoming Excise Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 140000010 | |
51 | IEI14 | Incoming Excise Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 140000010 | |
52 | IEI4 | Incoming Excise Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 140000010 | |
53 | IGE14 | Goods Issue - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 60 | |
54 | IGN14 | Goods Receipt - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 59 | |
55 | INV12 | A/R Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
56 | INV14 | A/R Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 13 | |
57 | INV4 | A/R Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 13 | |
58 | OEI12 | Outgoing Excise Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 140000009 | |
59 | OEI14 | Outgoing Excise Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 140000009 | |
60 | OEI4 | Outgoing Excise Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 140000009 | |
61 | PCH12 | A/P Invoice - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 18 | |
62 | PCH14 | A/P Invoice - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 18 | |
63 | PCH4 | A/P Invoice - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 18 | |
64 | PDN12 | Goods Receipt PO - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 20 | |
65 | PDN14 | Goods Receipt PO - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 20 | |
66 | PDN4 | Goods Receipt PO - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 20 | |
67 | POR12 | Purchase Order - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 22 | |
68 | POR14 | Purchase Order - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 22 | |
69 | POR4 | Purchase Order - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 22 | |
70 | QUT12 | Sales Quotation - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 23 | |
71 | QUT14 | Sales Quotation - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 23 | |
72 | QUT4 | Sales Quotation - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 23 | |
73 | RDN12 | Returns - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 16 | |
74 | RDN14 | Return - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 16 | |
75 | RDN4 | Returns - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 16 | |
76 | RDR12 | Sales Order - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 17 | |
77 | RDR14 | Sales Order - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 17 | |
78 | RDR4 | Sales Order - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 17 | |
79 | RIN12 | A/R Credit Memo - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 14 | |
80 | RIN14 | A/R Credit Memo - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 14 | |
81 | RIN4 | A/R Credit Memo - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 14 | |
82 | RPC12 | A/P Credit Memo - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 19 | |
83 | RPC14 | A/P Credit Memo - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 19 | |
84 | RPC4 | A/P Credit Memo - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 19 | |
85 | RPD12 | Goods Return - Tax Extension | 26 | ObjectType | Object Type | nVarChar | 20 | 0 | 21 | |
86 | RPD14 | Goods Return - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 21 | |
87 | RPD4 | Goods Return - Tax Amount per Document | 17 | ObjectType | Object Type | nVarChar | 20 | 0 | 21 | |
88 | WTR14 | Inventory Transfer - Assembly - Rows | 9 | ObjectType | object type | nVarChar | 20 | 0 | 67 | |
TOPService |
89 | ASC2 | Service Call Inventory Expenses - History | 12 | ObjectType | Object Type - History | nVarChar | 20 | 0 | 191 | |
90 | ASC3 | Service Call Travel/Labor Expenses - History | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
91 | ASC4 | Service Call Travel/Labor Expenses - History | 7 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
92 | ASC5 | Service Call Activities - History | 4 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
93 | SCL2 | Service Call Inventory Expenses | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
94 | SCL3 | Service Call Travel/Labor Expenses | 12 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
95 | SCL4 | Expense Documents | 7 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |
96 | SCL5 | Service Call Activities | 4 | ObjectType | Object Type | nVarChar | 20 | 0 | 191 | |