| 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 | BPL1 | Business Place Tax IDs | 1 | BPLId | BPL ID | Int | 11 | 0 | | |
3 | DGP4 | Business Place List | 3 | BPLId | Business Place ID | Int | 11 | 0 | | |
4 | NFN1 | Not a Fiscal Sequence | 21 | BPLId | Assigned Branch | Int | 11 | 0 | 0 | |
5 | NNM1 | Documents Numbering - Series | 23 | BPLId | Assigned Branch | Int | 11 | 0 | | |
6 | OUDG | User Defaults | 33 | BPLId | Default Branch | Int | 11 | 0 | | |
TOPBanking |
7 | ARCT | Incoming Payment - History | 166 | BPLId | Branch | Int | 11 | 0 | | |
8 | OITR | Internal Reconciliation | 24 | BPLId | Branch | Int | 11 | 0 | | |
9 | OPDF | Payment Draft | 166 | BPLId | Branch | Int | 11 | 0 | | |
10 | OPWZ | Payment Wizard | 57 | BPLId | Active Branch | Int | 11 | 0 | | |
11 | ORCT | Incoming Payment | 166 | BPLId | Branch | Int | 11 | 0 | | |
12 | OVPM | Outgoing Payments | 166 | BPLId | Branch | Int | 11 | 0 | | |
TOPBusiness Partners |
13 | ABPL | Business Place | 1 | BPLId | Branch ID | Int | 11 | 0 | | |
14 | CRD8 | BP Branch Assignment | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |
15 | OBPL | Business Place | 1 | BPLId | Branch ID | Int | 11 | 0 | | |
TOPFinance |
16 | AACT | G/L Account - History | 106 | BPLId | Assigned Branch | Int | 11 | 0 | | |
17 | AJD1 | Journal Entry - History - Rows | 118 | BPLId | Branch | Int | 11 | 0 | | |
18 | BTF1 | Journal Voucher | 118 | BPLId | Branch | Int | 11 | 0 | | |
19 | JDT1 | Journal Entry - Rows | 118 | BPLId | Branch | Int | 11 | 0 | | |
20 | OACT | G/L Accounts | 106 | BPLId | Assigned Branch | Int | 11 | 0 | | |
TOPHuman Resources |
21 | AHEM | Employees | 116 | BPLid | Business Place ID | Int | 11 | 0 | | |
22 | OHEM | Employees | 116 | BPLid | Business Place ID | Int | 11 | 0 | | |
TOPInventory and Production |
23 | AWHS | Warehouses - History | 67 | BPLid | Business Place ID | Int | 11 | 0 | | |
24 | OIGE | Goods Issue | 166 | BPLId | Branch | Int | 11 | 0 | | |
25 | OIGN | Goods Receipt | 166 | BPLId | Branch | Int | 11 | 0 | | |
26 | OWHS | Warehouses | 67 | BPLid | Business Place ID | Int | 11 | 0 | | |
27 | OWTQ | Inventory Transfer Request | 166 | BPLId | Branch | Int | 11 | 0 | | |
28 | OWTR | Inventory Transfer | 166 | BPLId | Branch | Int | 11 | 0 | | |
TOPMarketing Documents |
29 | ADOC | Invoice - History | 166 | BPLId | Branch | Int | 11 | 0 | | |
30 | DWZ3 | Dunning Wizard Array 3 - Recommended Service Invoice | 21 | BPLId | BPL ID Assigned to Invoice | Int | 11 | 0 | | |
31 | OCIN | A/R Correction Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
32 | OCPI | A/P Correction Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
33 | OCPV | A/P Correction Invoice Reversal | 166 | BPLId | Branch | Int | 11 | 0 | | |
34 | OCSI | A/R Correction Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
35 | OCSV | A/R Correction Invoice Reversal | 166 | BPLId | Branch | Int | 11 | 0 | | |
36 | ODLN | Delivery | 166 | BPLId | Branch | Int | 11 | 0 | | |
37 | ODPI | A/R Down Payment | 166 | BPLId | Branch | Int | 11 | 0 | | |
38 | ODPO | A/P Down Payment | 166 | BPLId | Branch | Int | 11 | 0 | | |
39 | ODRF | Drafts | 166 | BPLId | Branch | Int | 11 | 0 | | |
40 | ODWZ | Dunning Wizard | 38 | BPLId | BPL ID Assigned to Invoice | Int | 11 | 0 | | |
41 | OIEI | Incoming Excise Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
42 | OINV | A/R Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
43 | OOEI | Outgoing Excise Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
44 | OPCH | A/P Invoice | 166 | BPLId | Branch | Int | 11 | 0 | | |
45 | OPDN | Goods Receipt PO | 166 | BPLId | Branch | Int | 11 | 0 | | |
46 | OPOR | Purchase Order | 166 | BPLId | Branch | Int | 11 | 0 | | |
47 | OPQT | Purchase Quotation | 166 | BPLId | Branch | Int | 11 | 0 | | |
48 | OQUT | Sales Quotation | 166 | BPLId | Branch | Int | 11 | 0 | | |
49 | ORDN | Returns | 166 | BPLId | Branch | Int | 11 | 0 | | |
50 | ORDR | Sales Order | 166 | BPLId | Branch | Int | 11 | 0 | | |
51 | ORIN | A/R Credit Memo | 166 | BPLId | Branch | Int | 11 | 0 | | |
52 | ORPC | A/P Credit Memo | 166 | BPLId | Branch | Int | 11 | 0 | | |
53 | ORPD | Goods Return | 166 | BPLId | Branch | Int | 11 | 0 | | |
54 | VRT2 | Tax Invoice Report Grid Info | 3 | BPLId | Business Place ID | Int | 11 | 0 | | |
TOPMRP |
55 | ORCM | Recommendation Data | 18 | BPLid | Business Place ID | Int | 11 | 0 | -1 | |
TOPReports |
56 | OSRT | Korean Summary Report | 4 | BPLId | Business Place ID | Int | 11 | 0 | | |
TOPService |
57 | USR6 | User Branch Assignment | 2 | BPLId | Assigned Branch | Int | 11 | 0 | | |