| 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 | ACHO | Checks for Payment - History | 50 | BPLId | Branch | Int | 11 | 0 | | |
13 | ARCT | Incoming Payment - History | 166 | BPLId | Branch | Int | 11 | 0 | | |
14 | BNK2 | Bank Statement - Recommendation List | 28 | BPLId | Branch ID | Int | 11 | 0 | | |
15 | OCHD | Checks for Payment Drafts | 50 | BPLId | Branch | Int | 11 | 0 | | |
16 | OCHO | Checks for Payment | 50 | BPLId | Branch | Int | 11 | 0 | | |
17 | ODPS | Deposit | 63 | BPLId | Branch | Int | 11 | 0 | | |
18 | OITR | Internal Reconciliation | 24 | BPLId | Branch | Int | 11 | 0 | | |
19 | OPDF | Payment Draft | 166 | BPLId | Branch | Int | 11 | 0 | | |
20 | OPWZ | Payment Wizard | 57 | BPLId | Active Branch | Int | 11 | 0 | | |
21 | ORCT | Incoming Payment | 166 | BPLId | Branch | Int | 11 | 0 | | |
22 | OVPM | Outgoing Payments | 166 | BPLId | Branch | Int | 11 | 0 | | |
23 | PWZ3 | Payment Wizard - Rows 3 | 123 | BPLId | Branch | Int | 11 | 0 | | |
24 | PWZ5 | Payment Wizard - Rows 5 | 19 | BPLId | Branch | Int | 11 | 0 | | |
TOPBusiness Partners |
25 | ABPL | Business Place | 1 | BPLId | Branch ID | Int | 11 | 0 | | |
26 | CRD8 | BP Branch Assignment | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
27 | OBPL | Business Place | 1 | BPLId | Branch ID | Int | 11 | 0 | | |
28 | USR6 | User Branch Assignment | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
TOPFinance |
29 | AACS | Asset Classes - History | 12 | BPLId | Branch | Int | 11 | 0 | | |
30 | AACT | G/L Account - History | 107 | BPLId | Assigned Branch | Int | 11 | 0 | | |
31 | AFAD | Asset Document - History | 38 | BPLId | Branch | Int | 11 | 0 | | |
32 | AJD1 | Journal Entry - History - Rows | 118 | BPLId | Branch | Int | 11 | 0 | | |
33 | BTF1 | Journal Voucher - Rows | 118 | BPLId | Branch | Int | 11 | 0 | | |
34 | JDT1 | Journal Entry - Rows | 118 | BPLId | Branch | Int | 11 | 0 | | |
35 | OACD | Credit Memo | 38 | BPLId | Branch | Int | 11 | 0 | | |
36 | OACQ | Capitalization | 38 | BPLId | Branch | Int | 11 | 0 | | |
37 | OACS | Asset Classes | 12 | BPLId | Branch | Int | 11 | 0 | | |
38 | OACT | G/L Accounts | 107 | BPLId | Assigned Branch | Int | 11 | 0 | | |
39 | OFAR | Fixed Asset Revaluation | 14 | BPLId | Branch | Int | 11 | 0 | | |
40 | OFTR | Transfer | 38 | BPLId | Branch | Int | 11 | 0 | | |
41 | OMDP | Manual Depreciation | 38 | BPLId | Branch | Int | 11 | 0 | | |
42 | ORTI | Retirement | 38 | BPLId | Branch | Int | 11 | 0 | | |
43 | ORTM | Rate Differences | 16 | BPLId | Branch | Int | 11 | 0 | | |
44 | OVRW | VAT Reposting Wizard | 15 | BPLId | Active Branch | Int | 11 | 0 | | |
45 | RCR1 | Recurring Postings - Rows | 28 | BPLId | Branch | Int | 11 | 0 | | |
46 | RTM1 | Rate Differences - Rows | 18 | BPLId | Branch | Int | 11 | 0 | | |
47 | VRW2 | VAT Reposting Wizard - Rows 2 | 16 | BPLId | Branch | Int | 11 | 0 | | |
TOPGeneral |
48 | OBTA | Brazil - Tax Adjustment | 42 | BPLId | Branch ID | Int | 11 | 0 | | |
49 | OPTI | Point of Issue | 8 | BPLId | Branch | Int | 11 | 0 | | |
TOPHuman Resources |
50 | AHEM | Employees | 116 | BPLId | Branch | Int | 11 | 0 | | |
51 | OHEM | Employees | 116 | BPLId | Branch | Int | 11 | 0 | | |
TOPInventory and Production |
52 | AINC | Inventory Counting | 23 | BPLId | Branch | Int | 11 | 0 | | |
53 | AIQI | Inventory Opening Balance | 30 | BPLId | Branch | Int | 11 | 0 | | |
54 | AIQR | Inventory Posting | 31 | BPLId | Branch | Int | 11 | 0 | | |
55 | AWHS | Warehouses - History | 67 | BPLid | Business Place ID | Int | 11 | 0 | | |
56 | OICD | Inventory Counting Draft | 23 | BPLId | Branch | Int | 11 | 0 | | |
57 | OIGE | Goods Issue | 166 | BPLId | Branch | Int | 11 | 0 | | |
58 | OIGN | Goods Receipt | 166 | BPLId | Branch | Int | 11 | 0 | | |
59 | OINC | Inventory Counting | 23 | BPLId | Branch | Int | 11 | 0 | | |
60 | OIOD | Inventory Opening Balance Draft | 30 | BPLId | Branch | Int | 11 | 0 | | |
61 | OIPD | Inventory Posting Draft | 31 | BPLId | Branch | Int | 11 | 0 | | |
62 | OIQI | Inventory Opening Balance | 30 | BPLId | Branch | Int | 11 | 0 | | |
63 | OIQR | Inventory Posting | 31 | BPLId | Branch | Int | 11 | 0 | | |
64 | OWHS | Warehouses | 67 | BPLid | Business Place ID | Int | 11 | 0 | | |
65 | OWTQ | Inventory Transfer Request | 166 | BPLId | Branch | Int | 11 | 0 | | |
66 | OWTR | Inventory Transfer | 166 | BPLId | Branch | Int | 11 | 0 | | |
TOPMarketing Documents |
67 | ADOC | Invoice - History | 166 | BPLId | Branch | Int | 11 | 0 | | |
68 | ATXI | Tax Invoice - History | 42 | BPLId | Branch | Int | 11 | 0 | | |
69 | DWZ3 | Dunning Wizard Array 3 - Recommended Service Invoice | 21 | BPLId | BPL ID Assigned to Invoice | Int | 11 | 0 | | |
70 | OCIN | A/R Correction Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
71 | OCPI | A/P Correction Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
72 | OCPV | A/P Correction Invoice Reversal | 166 | BPLId | Branch | Int | 11 | 0 | | |
73 | OCSI | A/R Correction Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
74 | OCSV | A/R Correction Invoice Reversal | 166 | BPLId | Branch | Int | 11 | 0 | | |
75 | ODLN | Delivery | 166 | BPLId | Branch | Int | 11 | 0 | | |
76 | ODPI | A/R Down Payment | 166 | BPLId | Branch | Int | 11 | 0 | | |
77 | ODPO | A/P Down Payment | 166 | BPLId | Branch | Int | 11 | 0 | | |
78 | ODRF | Drafts | 166 | BPLId | Branch | Int | 11 | 0 | | |
79 | ODWZ | Dunning Wizard | 38 | BPLId | BPL ID Assigned to Invoice | Int | 11 | 0 | | |
80 | OIEI | Incoming Excise Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
81 | OINV | A/R Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
82 | OOEI | Outgoing Excise Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
83 | OPCH | A/P Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
84 | OPDN | Goods Receipt PO | 166 | BPLId | Branch | Int | 11 | 0 | | |
85 | OPOR | Purchase Order | 166 | BPLId | Branch | Int | 11 | 0 | | |
86 | OPQT | Purchase Quotation | 166 | BPLId | Branch | Int | 11 | 0 | | |
87 | OPRQ | Purchase Request | 166 | BPLId | Branch | Int | 11 | 0 | | |
88 | OQUT | Sales Quotation | 166 | BPLId | Branch | Int | 11 | 0 | | |
89 | ORDN | Returns | 166 | BPLId | Branch | Int | 11 | 0 | | |
90 | ORDR | Sales Order | 166 | BPLId | Branch | Int | 11 | 0 | | |
91 | ORIN | A/R Credit Memo | 166 | BPLId | Branch | Int | 11 | 0 | | |
92 | ORPC | A/P Credit Memo | 166 | BPLId | Branch | Int | 11 | 0 | | |
93 | ORPD | Goods Return | 166 | BPLId | Branch | Int | 11 | 0 | | |
94 | OTPI | Purchase Tax Invoice | 42 | BPLId | Branch | Int | 11 | 0 | | |
95 | OTSI | Sales Tax Invoice | 42 | BPLId | Branch | Int | 11 | 0 | | |
96 | OTXD | Tax Invoice Draft | 42 | BPLId | Branch | Int | 11 | 0 | | |
97 | VRT2 | Tax Invoice Report Grid Info | 3 | BPLId | Business Place ID | Int | 11 | 0 | | |
TOPMRP |
98 | ORCM | Recommendation Data | 18 | BPLid | Business Place ID | Int | 11 | 0 | -1 | |
TOPReports |
99 | AEC1 | Parameters for Various Types of Electronic Communication | 4 | BPLId | Branch ID | Int | 11 | 0 | -1 | |
100 | AEC2 | Electronic Transactions | 11 | BPLId | Branch ID | Int | 11 | 0 | -1 | |
101 | ECM1 | Parameters for Various Types of Electronic Communication | 4 | BPLId | Branch ID | Int | 11 | 0 | -1 | |
102 | ECM2 | Electronic Transactions | 11 | BPLId | Branch ID | Int | 11 | 0 | -1 | |
103 | OSRT | Korean Summary Report | 4 | BPLId | Business Place ID | Int | 11 | 0 | | |
104 | OTRB | Tax Report Wizard for Brazil | 2 | BPLId | Branch ID | Int | 11 | 0 | | |