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