| 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 | | |
TOPInventory and Production |
9 | 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 |
10 | RTL1 | Resource Transaction Log | 6 | Total | Total | Num | 19 | 6 | | |
TOPMarketing Documents |
11 | ADO22 | A/R Invoice (Resource Costs) - History | 5 | Total | Total | Num | 19 | 6 | | |
12 | CIN22 | Correction Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
13 | CPI22 | A/P Correction Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
14 | CPV22 | A/P Correction Invoice Reversal - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
15 | CSI22 | A/R Correction Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
16 | CSV22 | A/R Correction Invoice Reversal - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
17 | DLN22 | Delivery - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
18 | DPI22 | A/R Down Payment - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
19 | DPO22 | A/P Down Payment - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
20 | DRF22 | Draft - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
21 | IEI22 | Incoming Excise Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
22 | IGE22 | Goods Issue - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
23 | IGN22 | Goods Receipt - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
24 | INV22 | A/R Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
25 | OEI22 | Outgoing Excise Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
26 | OVRT | Tax Invoice Report | 8 | Total | Total Base + Total Tax | Num | 19 | 6 | | |
27 | PCH22 | A/P Invoice - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
28 | PDN22 | Goods Receipt PO - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
29 | POR22 | Purchase Order - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
30 | PQT22 | Purchase Quotation - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
31 | PRQ22 | Purchase Request - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
32 | QUT22 | Sales Quotation - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
33 | RDN22 | Returns - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
34 | RDR22 | Sales Order - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
35 | RIN22 | A/R Credit Memo - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
36 | RPC22 | A/P Credit Memo - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
37 | RPD22 | Goods Return - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
38 | WTQ22 | Inventory Transfer Request - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |
39 | WTR22 | Inventory Transfer - Resource Costs | 5 | Total | Total | Num | 19 | 6 | | |