| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ABP1 | Business Place Tax IDs | 1 | BPLId | BPL ID | Int | 11 | 0 | | |
2 | ABP2 | Branch Tributary Info. Log | 1 | BPLId | BPL ID | Int | 11 | 0 | | |
3 | BPL1 | Branch I.E. Numbers | 1 | BPLId | BPL ID | Int | 11 | 0 | | |
4 | BPL2 | Branch Tributary Info. | 1 | BPLId | BPL ID | Int | 11 | 0 | | |
5 | DGP4 | Business Place List | 3 | BPLId | Business Place ID | Int | 11 | 0 | | |
6 | GPC1 | Authority Assignment | 2 | BPLId | Branch | Int | 11 | 0 | | |
7 | NFN1 | Not a Fiscal Sequence | 21 | BPLId | Assigned Branch | Int | 11 | 0 | 0 | |
8 | NNM1 | Documents Numbering - Series | 23 | BPLId | Assigned Branch | Int | 11 | 0 | | |
9 | ODGP | Document Generation Parameter Sets | 54 | BPLId | Branch | Int | 11 | 0 | | |
10 | OPQW | Purchase Quotation Generation: Parameter Sets | 10 | BPLId | Branch | Int | 11 | 0 | | |
11 | OUDG | User Defaults | 33 | BPLId | Default Branch | Int | 11 | 0 | | |
TOPBanking |
12 | ABOE | Bill of Exchange for Payment - History | 89 | BPLId | Branch | Int | 11 | 0 | | |
13 | ACHO | Checks for Payment - History | 50 | BPLId | Branch | Int | 11 | 0 | | |
14 | ARCT | Incoming Payment - History | 166 | BPLId | Branch | Int | 11 | 0 | | |
15 | BNK2 | Bank Statement - Recommendation List | 28 | BPLId | Branch ID | Int | 11 | 0 | | |
16 | BOT1 | Bill of Exchange Transactions | 11 | BPLId | Branch | Int | 11 | 0 | | |
17 | OBOE | Bill of Exchange for Payment | 89 | BPLId | Branch | Int | 11 | 0 | | |
18 | OCHD | Checks for Payment Drafts | 50 | BPLId | Branch | Int | 11 | 0 | | |
19 | OCHO | Checks for Payment | 50 | BPLId | Branch | Int | 11 | 0 | | |
20 | ODPS | Deposit | 63 | BPLId | Branch | Int | 11 | 0 | | |
21 | OITR | Internal Reconciliation | 24 | BPLId | Branch | Int | 11 | 0 | | |
22 | OPDF | Payment Draft | 166 | BPLId | Branch | Int | 11 | 0 | | |
23 | OPWZ | Payment Wizard | 57 | BPLId | Active Branch | Int | 11 | 0 | | |
24 | ORCT | Incoming Payment | 166 | BPLId | Branch | Int | 11 | 0 | | |
25 | OVPM | Outgoing Payments | 166 | BPLId | Branch | Int | 11 | 0 | | |
26 | PWZ3 | Payment Wizard - Rows 3 | 123 | BPLId | Branch | Int | 11 | 0 | | |
27 | PWZ5 | Payment Wizard - Rows 5 | 19 | BPLId | Branch | Int | 11 | 0 | | |
TOPBusiness Partners |
28 | ABPL | Business Place | 1 | BPLId | Branch ID | Int | 11 | 0 | | |
29 | CRD8 | BP Branch Assignment | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
30 | OBPL | Business Place | 1 | BPLId | Branch ID | Int | 11 | 0 | | |
31 | USR6 | User Branch Assignment | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
TOPFinance |
32 | AACS | Asset Classes - History | 12 | BPLId | Branch | Int | 11 | 0 | | |
33 | AACT | G/L Account - History | 107 | BPLId | Assigned Branch | Int | 11 | 0 | | |
34 | AFAD | Asset Document - History | 38 | BPLId | Branch | Int | 11 | 0 | | |
35 | AJD1 | Journal Entry - History - Rows | 118 | BPLId | Branch | Int | 11 | 0 | | |
36 | BTF1 | Journal Voucher - Rows | 118 | BPLId | Branch | Int | 11 | 0 | | |
37 | JDT1 | Journal Entry - Rows | 118 | BPLId | Branch | Int | 11 | 0 | | |
38 | OACD | Credit Memo | 38 | BPLId | Branch | Int | 11 | 0 | | |
39 | OACQ | Capitalization | 38 | BPLId | Branch | Int | 11 | 0 | | |
40 | OACS | Asset Classes | 12 | BPLId | Branch | Int | 11 | 0 | | |
41 | OACT | G/L Accounts | 107 | BPLId | Assigned Branch | Int | 11 | 0 | | |
42 | OFAR | Fixed Asset Revaluation | 14 | BPLId | Branch | Int | 11 | 0 | | |
43 | OFTR | Transfer | 38 | BPLId | Branch | Int | 11 | 0 | | |
44 | OMDP | Manual Depreciation | 38 | BPLId | Branch | Int | 11 | 0 | | |
45 | ORTI | Retirement | 38 | BPLId | Branch | Int | 11 | 0 | | |
46 | ORTM | Rate Differences | 16 | BPLId | Branch | Int | 11 | 0 | | |
47 | OVRW | VAT Reposting Wizard | 15 | BPLId | This field is not used anymore | Int | 11 | 0 | | |
48 | OWTA | Withholding Tax Accumulation | 8 | BPLId | Branch | Int | 11 | 0 | 0 | |
49 | RCR1 | Recurring Postings - Rows | 28 | BPLId | Branch | Int | 11 | 0 | | |
50 | RTM1 | Rate Differences - Rows | 18 | BPLId | Branch | Int | 11 | 0 | | |
51 | VRW2 | VAT Reposting Wizard - Rows 2 | 16 | BPLId | Branch | Int | 11 | 0 | | |
TOPGeneral |
52 | APMG | Project Management Document - History | 23 | BPLid | Business Place ID | Int | 11 | 0 | | |
53 | OBTA | Brazil - Tax Adjustment | 42 | BPLId | Branch ID | Int | 11 | 0 | | |
54 | OPMG | Project Management Document | 23 | BPLid | Business Place ID | Int | 11 | 0 | | |
55 | OPTI | Point of Issue | 8 | BPLId | Branch | Int | 11 | 0 | | |
TOPHuman Resources |
56 | AHEM | Employees - History | 116 | BPLId | Branch | Int | 11 | 0 | | |
57 | HEM10 | Employee Branch Assignment | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
58 | OHEM | Employees | 116 | BPLId | Branch | Int | 11 | 0 | | |
TOPInventory and Production |
59 | AINC | Inventory Counting | 23 | BPLId | Branch | Int | 11 | 0 | | |
60 | AIQI | Inventory Opening Balance | 30 | BPLId | Branch | Int | 11 | 0 | | |
61 | AIQR | Inventory Posting | 31 | BPLId | Branch | Int | 11 | 0 | | |
62 | AWHS | Warehouses - History | 67 | BPLid | Business Place ID | Int | 11 | 0 | | |
63 | OICD | Inventory Counting Draft | 23 | BPLId | Branch | Int | 11 | 0 | | |
64 | OIGE | Goods Issue | 166 | BPLId | Branch | Int | 11 | 0 | | |
65 | OIGN | Goods Receipt | 166 | BPLId | Branch | Int | 11 | 0 | | |
66 | OINC | Inventory Counting | 23 | BPLId | Branch | Int | 11 | 0 | | |
67 | OIOD | Inventory Opening Balance Draft | 30 | BPLId | Branch | Int | 11 | 0 | | |
68 | OIPD | Inventory Posting Draft | 31 | BPLId | Branch | Int | 11 | 0 | | |
69 | OIPF | Landed Costs | 63 | BPLId | Branch | Int | 11 | 0 | | |
70 | OIQI | Inventory Opening Balance | 30 | BPLId | Branch | Int | 11 | 0 | | |
71 | OIQR | Inventory Posting | 31 | BPLId | Branch | Int | 11 | 0 | | |
72 | OWHS | Warehouses | 67 | BPLid | Business Place ID | Int | 11 | 0 | | |
73 | OWTQ | Inventory Transfer Request | 166 | BPLId | Branch | Int | 11 | 0 | | |
74 | OWTR | Inventory Transfer | 166 | BPLId | Branch | Int | 11 | 0 | | |
TOPMarketing Documents |
75 | ADOC | Invoice - History | 166 | BPLId | Branch | Int | 11 | 0 | | |
76 | ATXI | Tax Invoice - History | 42 | BPLId | Branch | Int | 11 | 0 | | |
77 | DWZ2 | Dunning Wizard Array 2-Invoice Filter | 43 | BPLId | Assigned Branch | Int | 11 | 0 | | |
78 | DWZ3 | Dunning Wizard Array 3 - Recommended Service Invoice | 21 | BPLId | BPL ID Assigned to Invoice | Int | 11 | 0 | | |
79 | DWZ4 | Dunning Wizard Array 4-Paging Grid | 51 | BPLId | Branch ID | Int | 11 | 0 | | |
80 | DWZ5 | Dunning Wizard Array 5-Selected Branches | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
81 | OCIN | A/R Correction Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
82 | OCPI | A/P Correction Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
83 | OCPV | A/P Correction Invoice Reversal | 166 | BPLId | Branch | Int | 11 | 0 | | |
84 | OCSI | A/R Correction Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
85 | OCSV | A/R Correction Invoice Reversal | 166 | BPLId | Branch | Int | 11 | 0 | | |
86 | ODLN | Delivery | 166 | BPLId | Branch | Int | 11 | 0 | | |
87 | ODPI | A/R Down Payment | 166 | BPLId | Branch | Int | 11 | 0 | | |
88 | ODPO | A/P Down Payment | 166 | BPLId | Branch | Int | 11 | 0 | | |
89 | ODRF | Drafts | 166 | BPLId | Branch | Int | 11 | 0 | | |
90 | ODWZ | Dunning Wizard | 38 | BPLId | BPL ID Assigned to Invoice | Int | 11 | 0 | | |
91 | OIEI | Incoming Excise Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
92 | OINV | A/R Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
93 | OOEI | Outgoing Excise Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
94 | OPCH | A/P Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
95 | OPDN | Goods Receipt PO | 166 | BPLId | Branch | Int | 11 | 0 | | |
96 | OPOR | Purchase Order | 166 | BPLId | Branch | Int | 11 | 0 | | |
97 | OPQT | Purchase Quotation | 166 | BPLId | Branch | Int | 11 | 0 | | |
98 | OPRQ | Purchase Request | 166 | BPLId | Branch | Int | 11 | 0 | | |
99 | OPRR | Goods Return Request | 166 | BPLId | Branch | Int | 11 | 0 | | |
100 | OQUT | Sales Quotation | 166 | BPLId | Branch | Int | 11 | 0 | | |
101 | ORDN | Returns | 166 | BPLId | Branch | Int | 11 | 0 | | |
102 | ORDR | Sales Order | 166 | BPLId | Branch | Int | 11 | 0 | | |
103 | ORIN | A/R Credit Memo | 166 | BPLId | Branch | Int | 11 | 0 | | |
104 | ORPC | A/P Credit Memo | 166 | BPLId | Branch | Int | 11 | 0 | | |
105 | ORPD | Goods Return | 166 | BPLId | Branch | Int | 11 | 0 | | |
106 | ORRR | Return Request | 166 | BPLId | Branch | Int | 11 | 0 | | |
107 | OSFC | Self Credit Memo | 166 | BPLId | Branch | Int | 11 | 0 | | |
108 | OSFI | Self Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
109 | OTPI | Purchase Tax Invoice | 42 | BPLId | Branch | Int | 11 | 0 | | |
110 | OTSI | Sales Tax Invoice | 42 | BPLId | Branch | Int | 11 | 0 | | |
111 | OTXD | Tax Invoice Draft | 42 | BPLId | Branch | Int | 11 | 0 | | |
112 | PWZ7 | Payment Wizard 7-Selected Branches | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
113 | VRT2 | Tax Invoice Report Grid Info | 3 | BPLId | Business Place ID | Int | 11 | 0 | | |
114 | VRW4 | VAT Reposting Wizard Array 4-Selected Branches | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
TOPMRP |
115 | ORCM | Recommendation Data | 18 | BPLid | Business Place ID | Int | 11 | 0 | -1 | |
TOPReports |
116 | AEC1 | Parameters for Various Types of Electronic Communication | 4 | BPLId | Branch ID | Int | 11 | 0 | -1 | |
117 | AEC2 | Electronic Transactions | 10 | BPLId | Branch ID | Int | 11 | 0 | -1 | |
118 | ECM1 | Parameters for Various Types of Electronic Communication | 4 | BPLId | Branch ID | Int | 11 | 0 | -1 | |
119 | ECM2 | Electronic Transactions | 10 | BPLId | Branch ID | Int | 11 | 0 | -1 | |
120 | OSRT | Korean Summary Report | 4 | BPLId | Business Place ID | Int | 11 | 0 | | |
121 | OTRB | Tax Report Wizard for Brazil | 2 | BPLId | Branch ID | Int | 11 | 0 | | |
122 | SOI2 | Statement of Import - Branches | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
123 | SOI3 | Statement of Import - Invoices | 19 | BPLId | Branch | Int | 11 | 0 | | |