| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | DAR1 | Data Archive - Transaction Log | 6 | Total | Total | Num | 19 | 6 | | |
2 | DAR2 | Data Archive - Transaction Log | 11 | Total | Total | Num | 19 | 6 | | |
TOPBanking |
3 | OITR | Internal Reconciliation | 5 | Total | Total Reconciliation Amount | Num | 19 | 6 | | |
TOPFinance |
4 | ACD3 | Credit Memo - Item Areas | 5 | Total | Total | Num | 19 | 6 | | |
5 | ACQ3 | Capitalization - Item Areas | 5 | Total | Total | Num | 19 | 6 | | |
6 | FTR3 | Transfer - Item Areas | 5 | Total | Total | Num | 19 | 6 | | |
7 | MDP3 | Manual Depreciation - Item Areas | 5 | Total | Total | Num | 19 | 6 | | |
8 | RTI3 | Retirement - Item Areas | 5 | Total | Total | Num | 19 | 6 | | |
TOPGeneral |
9 | APH4 | Project Management - Stages - Documents - History | 8 | Total | Total | Num | 19 | 6 | | |
10 | APM4 | Project Management - Stages - Documents - History | 8 | Total | Total | Num | 19 | 6 | | |
11 | OPMX | Payroll | 2 | Total | Total | Num | 19 | 6 | | |
12 | PHA4 | Project Management - Stages - Documents | 8 | Total | Total | Num | 19 | 6 | | |
13 | PMG4 | Project Management - Stages - Documents | 8 | Total | Total | Num | 19 | 6 | | |
TOPInventory and Production |
14 | OIMT | Templates for Inventory JE | 10 | Total | Total Type | VarChar | 1 | 0 | M | C=Total from Calculator, F=Total from Formula, M=Total from Message |
15 | RTL1 | Resource Transaction Log | 6 | Total | Total | Num | 19 | 6 | | |
TOPMarketing Documents |
16 | ADO22 | A/R Invoice (Resource Costs) - History | 5 | Total | Total | Num | 19 | 6 | | |
17 | CIN22 | Correction Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
18 | CPI22 | A/P Correction Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
19 | CPV22 | A/P Correction Invoice Reversal - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
20 | CSI22 | A/R Correction Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
21 | CSV22 | A/R Correction Invoice Reversal - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
22 | DLN22 | Delivery - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
23 | DPI22 | A/R Down Payment - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
24 | DPO22 | A/P Down Payment - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
25 | DRF22 | Draft - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
26 | IEI22 | Incoming Excise Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
27 | IGE22 | Goods Issue - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
28 | IGN22 | Goods Receipt - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
29 | INV22 | A/R Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
30 | OEI22 | Outgoing Excise Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
31 | OVRT | Tax Invoice Report | 8 | Total | Total Base + Total Tax | Num | 19 | 6 | | |
32 | PCH22 | A/P Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
33 | PDN22 | Goods Receipt PO - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
34 | POR22 | Purchase Order - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
35 | PQT22 | Purchase Quotation - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
36 | PRQ22 | Purchase Request - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
37 | PRR22 | A/P Return Request - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
38 | QUT22 | Sales Quotation - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
39 | RDN22 | Returns - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
40 | RDR22 | Sales Order - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
41 | RIN22 | A/R Credit Memo - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
42 | RPC22 | A/P Credit Memo - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
43 | RPD22 | Goods Return - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
44 | RRR22 | A/R Return Request - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
45 | SFC22 | Self Credit Memo - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
46 | SFI22 | Self Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
47 | WTQ22 | Inventory Transfer Request - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
48 | WTR22 | Inventory Transfer - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |