| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AADM | Administration - Log | 326 | UserSign2 | Updating User | Int | 6 | 0 | | |
2 | ACRC | Credit Cards | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
3 | AEXD | Freight Setup | 34 | UserSign2 | Updating User | Int | 6 | 0 | | |
4 | AUSR | Archive Users - History | 70 | userSign2 | Updating User | Int | 6 | 0 | | |
5 | OADM | Administration | 326 | UserSign2 | Updating User | Int | 6 | 0 | | |
6 | OCRC | Credit Cards | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
7 | OCRN | Currency Codes | 12 | UserSign2 | Updating User | Int | 6 | 0 | | |
8 | OEXD | Freight Setup | 34 | UserSign2 | Updating User | Int | 6 | 0 | | |
9 | OUSR | Users | 70 | userSign2 | Updating User - History | Int | 6 | 0 | | |
TOPBanking |
10 | ABOC | External Bank Operation Code - Log | 6 | UserSign2 | Updating User | Int | 6 | 0 | | |
11 | ABOE | Bill of Exchange for Payment - History | 77 | UserSign2 | Updating User | Int | 6 | 0 | | |
12 | ABTC | Internal Bank Operation Codes - | 17 | UserSign2 | Updating User | Int | 6 | 0 | | |
13 | ADS1 | House Bank Accounts | 63 | UserSign2 | Updating User | Int | 6 | 0 | | |
14 | ARCT | Incoming Payment - History | 150 | UserSign2 | Updating User | Int | 6 | 0 | | |
15 | DSC1 | House Bank Accounts | 63 | UserSign2 | Updating User | Int | 6 | 0 | | |
16 | OBOC | External Bank Operation Code Category | 6 | UserSign2 | Updating User | Int | 6 | 0 | | |
17 | OBOE | Bill of Exchange for Payment | 77 | UserSign2 | Updating User | Int | 6 | 0 | | |
18 | OBTC | Internal Bank Operation Codes | 17 | UserSign2 | Updating User | Int | 6 | 0 | | |
19 | OPDF | Payment Draft | 150 | UserSign2 | Updating User | Int | 6 | 0 | | |
20 | ORCT | Incoming Payment | 150 | UserSign2 | Updating User | Int | 6 | 0 | | |
21 | OVPM | Outgoing Payments | 150 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPBusiness Partners |
22 | ACRD | Business Partners - History | 274 | UserSign2 | Updating User | Int | 6 | 0 | | |
23 | OCRD | Business Partner | 274 | UserSign2 | Updating User | Int | 6 | 0 | | |
24 | OSCN | Customer/Vendor Cat. No. | 7 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPFinance |
25 | AACP | Periods Category-Log | 134 | UserSign2 | Updating User | Int | 6 | 0 | | |
26 | AACT | G/L Account - History | 91 | UserSign2 | Updating User | Int | 6 | 0 | | |
27 | AFPR | Posting Period-Log | 25 | UserSign2 | Updating User | Int | 6 | 0 | | |
28 | AJDT | Journal Entry - History | 28 | UserSign2 | Updated by | Int | 6 | 0 | | |
29 | AVTG | Tax Definition | 35 | UserSign2 | Updating User | Int | 6 | 0 | | |
30 | AWHT | Withholding Tax | 34 | UserSign2 | Updating User | Int | 6 | 0 | | |
31 | OACP | Periods Category | 134 | UserSign2 | Updating User | Int | 6 | 0 | | |
32 | OACT | G/L Accounts | 91 | UserSign2 | Updating User | Int | 6 | 0 | | |
33 | OBTF | Journal Voucher Entry | 28 | UserSign2 | Updating User | Int | 6 | 0 | | |
34 | OFPR | Posting Period | 25 | UserSign2 | Updating User | Int | 6 | 0 | | |
35 | OIWZ | Inflation Wizard | 34 | userSign2 | Updating User | Int | 6 | 0 | | |
36 | OJDT | Journal Entry | 28 | UserSign2 | Updating User | Int | 6 | 0 | | |
37 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 10 | UserSign2 | Rule Changed By | Int | 6 | 0 | | |
38 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 10 | UserSign2 | Rule Changed By | Int | 6 | 0 | | |
39 | OVTG | Tax Definition | 35 | UserSign2 | Updating User | Int | 6 | 0 | | |
40 | OWHT | Withholding Tax | 34 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPHuman Resources |
41 | AHEM | Employees | 97 | UserSign2 | Updating User | Int | 6 | 0 | | |
42 | OHEM | Employees | 97 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPInventory and Production |
43 | AITB | Item Groups - History | 50 | userSign2 | Updating User - History | Int | 6 | 0 | | |
44 | AITM | Items - History | 249 | UserSign2 | Updating User | Int | 6 | 0 | | |
45 | AITT | Product Tree - History | 16 | UserSign2 | Updating User | Int | 11 | 0 | | |
46 | AITW | Items - Warehouse - History | 51 | userSign2 | Updating User - History | Int | 6 | 0 | | |
47 | AMRV | Inventory Revaluation - History | 17 | UserSign2 | Updating User | Int | 6 | 0 | | |
48 | APKL | Pick List - History | 16 | UserSign2 | Updating User | Int | 6 | 0 | | |
49 | AWHS | Warehouses - History | 57 | userSign2 | Updating User - History | Int | 6 | 0 | | |
50 | AWOR | Production Order - History | 39 | UserSign2 | Updating User | Int | 6 | 0 | | |
51 | OIGE | Goods Issue | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
52 | OIGN | Goods Receipt | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
53 | OITB | Item Groups | 50 | userSign2 | Updating User - History | Int | 6 | 0 | | |
54 | OITM | Items | 249 | UserSign2 | Updating User | Int | 6 | 0 | | |
55 | OITT | Product Tree | 16 | UserSign2 | Updating User | Int | 11 | 0 | | |
56 | OITW | Items - Warehouse | 51 | userSign2 | Updating User - History | Int | 6 | 0 | | |
57 | OMRL | Advanced Inventory Revaluation | 25 | UserSign2 | Updating User | Int | 6 | 0 | | |
58 | OMRV | Inventory Revaluation | 17 | UserSign2 | Updating User | Int | 6 | 0 | | |
59 | OPKL | Pick List | 16 | UserSign2 | Updating User | Int | 6 | 0 | | |
60 | OWHS | Warehouses | 57 | userSign2 | Updating User - History | Int | 6 | 0 | | |
61 | OWOR | Production Order | 39 | UserSign2 | Updating User | Int | 6 | 0 | | |
62 | OWTR | Inventory Transfer | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
63 | UITM | Items | 249 | UserSign2 | Updating User | Int | 6 | 0 | | |
64 | UITW | Items - Warehouse | 51 | userSign2 | Updating User - History | Int | 6 | 0 | | |
65 | UWOR | Production Order | 39 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPMarketing Documents |
66 | ADOC | Invoice - History | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
67 | ATXI | Tax Invoice - History | 27 | UserSign2 | Updating User | Int | 6 | 0 | | |
68 | OCIN | A/R Correction Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
69 | OCPI | A/P Correction Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
70 | OCPV | A/P Correction Invoice Reversal | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
71 | OCSI | A/R Correction Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
72 | OCSV | A/R Correction Invoice Reversal | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
73 | ODLN | Delivery | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
74 | ODPI | A/R Down Payment | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
75 | ODPO | A/P Down Payment | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
76 | ODRF | Drafts | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
77 | OIEI | Incoming Excise Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
78 | OINV | A/R Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
79 | OOEI | Outgoing Excise Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
80 | OPCH | A/P Invoice | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
81 | OPDN | Goods Receipt PO | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
82 | OPOR | Purchase Order | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
83 | OQUT | Sales Quotation | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
84 | ORDN | Returns | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
85 | ORDR | Sales Order | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
86 | ORIN | A/R Credit Memo | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
87 | ORPC | A/P Credit Memo | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
88 | ORPD | Goods Return | 82 | UserSign2 | Updating User | Int | 6 | 0 | | |
89 | OTPI | Purchase Tax Invoice | 27 | UserSign2 | Updating User | Int | 6 | 0 | | |
90 | OTSI | Sales Tax Invoice | 27 | UserSign2 | Updating User | Int | 6 | 0 | | |
91 | OTXD | Tax Invoice Draft | 27 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPReports |
92 | RDOC | Document | 55 | UserSign2 | Updating User | Int | 6 | 0 | | |
TOPService |
93 | AINS | Customer Equipment Card - History | 40 | userSign2 | Updating User | Int | 6 | 0 | | |
94 | ASC1 | Service Call Solutions - History | 8 | userSign2 | Updating User - History | Int | 6 | 0 | | |
95 | ASC2 | Service Call Inventory Expenses - History | 16 | UserSign2 | User Signature 2 - History | Int | 6 | 0 | | |
96 | ASC3 | Service Call Travel/Labor Expenses - History | 16 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
97 | ASC4 | Service Call Travel/Labor Expenses - History | 11 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
98 | ASC5 | Service Call Activities - History | 8 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
99 | ASCL | History | 31 | userSign2 | Updating User | Int | 6 | 0 | | |
100 | OINS | Customer Equipment Card | 40 | userSign2 | Updating User | Int | 6 | 0 | | |
101 | OSCL | Service Calls | 31 | userSign2 | Updating User | Int | 6 | 0 | | |
102 | SCL1 | Service Call Solutions - Rows | 8 | userSign2 | Updating User | Int | 6 | 0 | | |
103 | SCL2 | Service Call Inventory Expenses | 16 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
104 | SCL3 | Service Call Travel/Labor Expenses | 16 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
105 | SCL4 | Expense Documents | 11 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |
106 | SCL5 | Service Call Activities | 8 | UserSign2 | User Signature 2 | Int | 6 | 0 | | |