| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | AFML | Tax Formula Master Table | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
2 | ASTT | Sales Tax Authorities Type | 1 | AbsId | Numerator | Int | 11 | 0 | | |
3 | CSN1 | Certificate Series - Series | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
4 | GPC1 | Authority Assignment | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
5 | OCNA | CNAE Code | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
6 | OCNT | Counties | 1 | AbsId | Auto Key | Int | 11 | 0 | | |
7 | OCSN | Certificate Series | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
8 | OCSQ | Column Sequences | 1 | AbsId | Numerator | Int | 11 | 0 | | |
9 | OFML | Tax Formula Master Table | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
10 | OGPC | Government Payment Code | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
11 | OLTB | Location-based Tax Bal Table | 1 | AbsId | Numerator | Int | 11 | 0 | | |
12 | ONFT | Nota Fiscal Tax Category (Brazil) | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
13 | ONOA | Nature of Assessee | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
14 | ORMK | Remark 1 | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
15 | OSEC | Sections | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
16 | OSTT | Sales Tax Authorities Type | 1 | AbsId | Numerator | Int | 11 | 0 | | |
17 | OTCD | Tax Code Determination | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
18 | OTFC | Tax Type Combination | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
19 | OTNC | Transaction Category | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
20 | OTPA | Tax Parameter Attributes | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
21 | OTPR | Tax Return Values | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
22 | OTPS | Tax Parameter | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
23 | OUPT | User Autorization Tree | 1 | AbsId | Authorization ID | nVarChar | 20 | 0 | | |
24 | TCD1 | Key Fields for Determination | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
25 | TCD2 | Key Field Values | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
26 | TCD3 | Tax Code Determination | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
27 | TCD4 | Withholding Tax Code Determination | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
28 | TCD5 | Tax Code by Usage | 1 | AbsId | Numerator | Int | 11 | 0 | | |
TOPBanking |
29 | OCRH | Credit Card Management | 1 | AbsId | Seq. No. in Amount | Int | 11 | 0 | | |
30 | OCRV | Credit Payments | 1 | AbsId | Seq. No. in Amount | Int | 11 | 0 | | |
TOPBusiness Partners |
31 | AOAT | Blanket Agreement | 1 | AbsID | Agreement No. | Int | 11 | 0 | | |
32 | OOAT | Blanket Agreement | 1 | AbsID | Agreement No. | Int | 11 | 0 | | |
TOPFinance |
33 | AWH3 | Value Range | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
34 | JST1 | TDS Adjustment - Rows | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
35 | OACG | Account Category | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
36 | OACK | Acknowledge Number | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
37 | OACM | Accumulation | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
38 | OASG | Account Segmentation | 1 | AbsId | Numerator | Int | 6 | 0 | | |
39 | OBGS | Budget Scenario | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
40 | OBGT | Budget | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
41 | OFRT | Financial Report Templates | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
42 | OFYM | Financial Year Master | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
43 | OJST | TDS Adjustment | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
44 | WHT3 | Value Range | 1 | AbsId | Internal Number | Int | 11 | 0 | | |
TOPGeneral |
45 | CTNS | Transaction Notification Setting | 1 | AbsId | Internal No. | Int | 11 | 0 | | |
46 | FLR1 | Filter Lines | 1 | AbsId | Foreign Key | Int | 11 | 0 | | |
47 | LOG1 | LOG1 | 1 | absId | | Int | 11 | 0 | | |
48 | MLOG | MLOG | 1 | absId | | Int | 11 | 0 | | |
49 | OFLR | Object Filter | 1 | AbsId | Internal Key | Int | 11 | 0 | | |
TOPMRP |
50 | FCT1 | Sales Forecast - Rows | 1 | AbsID | Internal Number | Int | 11 | 0 | | |
51 | OFCT | Sales Forecast | 1 | AbsID | Internal Number | Int | 11 | 0 | | |
TOPReports |
52 | OSRT | Korean Summary Report | 1 | AbsId | Abstract ID | Int | 11 | 0 | | |