| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ADP1 | Object Settings - History | 7 | Remark | Standard Remarks | Text | 16 | 0 | | |
2 | NFN1 | Not a Fiscal Sequence | 9 | Remark | Remarks | nVarChar | 50 | 0 | | |
3 | NNM1 | Documents Numbering - Series | 9 | Remark | Remarks | nVarChar | 50 | 0 | | |
4 | NNM4 | Electronic Series | 10 | Remark | Remarks | nVarChar | 50 | 0 | | |
5 | OWFER | Workflow Error Message | 9 | Remark | Remarks | Text | 16 | 0 | | |
6 | UDG1 | User Defaults - Documents | 7 | Remark | Permanent Remark | Text | 16 | 0 | | |
TOPFinance |
7 | FIX1 | Fixed Asset Transaction - Rows | 32 | Remark | Remarks | nVarChar | 254 | 0 | | |
8 | GBI7 | GBI Row 7 - Accounting Vouchers | 7 | Remark | Details of Each Line | nVarChar | 50 | 0 | | |
TOPHuman Resources |
9 | AHEM | Employees - History | 55 | remark | Remarks | Text | 16 | 0 | | |
10 | OHEM | Employees | 55 | remark | Remarks | Text | 16 | 0 | | |
TOPInventory and Production |
11 | AIN1 | Inventory Counting - Rows | 12 | Remark | Remarks | nVarChar | 254 | 0 | | |
12 | AQI1 | Inventory Opening Balance - Rows | 31 | Remark | Remarks | nVarChar | 254 | 0 | | |
13 | AQR1 | Inventory Posting - Rows | 38 | Remark | Remarks | nVarChar | 254 | 0 | | |
14 | AWO5 | Production Order - Document Reference Information - History | 10 | Remark | Remarks | nVarChar | 254 | 0 | | |
15 | ICD1 | Inventory Counting Draft - Rows | 12 | Remark | Remarks | nVarChar | 254 | 0 | | |
16 | IGE21 | Goods Issue - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
17 | IGN21 | Goods Receipt - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
18 | INC1 | Inventory Counting - Rows | 12 | Remark | Remarks | nVarChar | 254 | 0 | | |
19 | IOD1 | Inventory Opening Balance Draft - Rows | 31 | Remark | Remarks | nVarChar | 254 | 0 | | |
20 | IPD1 | Inventory Posting Draft - Rows | 38 | Remark | Remarks | nVarChar | 254 | 0 | | |
21 | IQI1 | Inventory Opening Balance - Rows | 31 | Remark | Remarks | nVarChar | 254 | 0 | | |
22 | IQR1 | Inventory Posting - Rows | 38 | Remark | Remarks | nVarChar | 254 | 0 | | |
23 | UWOR5 | Production Order - Document Reference Information | 10 | Remark | Remarks | nVarChar | 254 | 0 | | |
24 | WOR2V | Production Order - Base | 8 | Remark | Document Remarks | nVarChar | 254 | 0 | | |
25 | WOR5 | Production Order - Document Reference Information | 10 | Remark | Remarks | nVarChar | 254 | 0 | | |
26 | WTQ21 | Inventory Transfer Request - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
27 | WTR21 | Inventory Transfer - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
TOPMarketing Documents |
28 | ADO21 | A/R Invoice - Document Reference Information - History | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
29 | ATX3 | Tax Invoice Archive - Document Reference Information | 10 | Remark | Remarks | nVarChar | 254 | 0 | | |
30 | CIN21 | Correction Invoice - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
31 | CPI21 | A/P Correction Invoice - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
32 | CPV21 | A/P Correction Invoice Reversal - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
33 | CSI21 | A/R Correction Invoice - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
34 | CSV21 | A/R Correction Invoice Reversal - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
35 | DLN21 | Delivery - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
36 | DPI21 | A/R Down Payment - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
37 | DPO21 | A/P Down Payment - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
38 | DRF21 | Draft - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
39 | IEI21 | Incoming Excise Invoice - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
40 | INV21 | A/R Invoice - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
41 | OEI21 | Outgoing Excise Invoice - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
42 | OGTM | GTS Mapping Object | 11 | Remark | Remarks | nVarChar | 254 | 0 | | |
43 | PCH21 | A/P Invoice - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
44 | PDN21 | Goods Receipt PO - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
45 | POR21 | Purchase Order - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
46 | PQT21 | Purchase Quotation - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
47 | PRQ21 | Purchase Request - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
48 | PRR21 | A/P Return Request - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
49 | QUT21 | Sales Quotation - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
50 | RDN21 | Returns - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
51 | RDR21 | Sales Order - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
52 | RIN21 | A/R Credit Memo - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
53 | RPC21 | A/P Credit Memo - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
54 | RPD21 | Goods Return - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
55 | RRR21 | A/R Return Request - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
56 | SFC21 | Self Credit Memo - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
57 | SFI21 | Self Invoice - Document Reference Information | 20 | Remark | Remarks | nVarChar | 254 | 0 | | |
58 | TPI3 | Purchase Tax Invoice - Document Reference Information | 10 | Remark | Remarks | nVarChar | 254 | 0 | | |
59 | TSI3 | Sales Tax Invoice - Document Reference Information | 10 | Remark | Remarks | nVarChar | 254 | 0 | | |
60 | TXD3 | Tax Invoice Draft - Document Reference Information | 10 | Remark | Remarks | nVarChar | 254 | 0 | | |
61 | VRT1 | Tax Invoice Report - Rows | 10 | Remark | Remarks | nVarChar | 100 | 0 | | |
62 | VRT2 | Tax Invoice Report Grid Info | 19 | Remark | Remarks | nVarChar | 100 | 0 | | |
TOPReports |
63 | SRT2 | Korean Summary Report - Rows2 | 9 | Remark | Line Item Remark, do not use | nVarChar | 100 | 0 | | |
TOPService |
64 | ASC6 | Service Call Scheduling - History | 40 | Remark | Remarks | nVarChar | 254 | 0 | | |
65 | OCTT | Contract Template | 38 | Remark | Remarks | Text | 16 | 0 | | |
66 | SCL6 | Service Call Scheduling | 40 | Remark | Remarks | nVarChar | 254 | 0 | | |