| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBanking |
1 | ARC5 | Reciept log | 9 | BaseSum | Base Amount - History | Num | 19 | 6 | | |
2 | ARC7 | Incoming Payments - Tax Amount per Document - History | 9 | BaseSum | Base Amount | Num | 19 | 6 | | |
3 | PDF5 | PaymentDraft - | 9 | BaseSum | Base Amount | Num | 19 | 6 | | |
4 | PDF7 | Payment Draft - Tax Amount per Document | 9 | BaseSum | Base Amount | Num | 19 | 6 | | |
5 | PMN5 | Payment - VAT Adjustment | 9 | BaseSum | Base Amount | Num | 19 | 6 | | |
6 | RCT5 | Reciept vat adjustment | 9 | BaseSum | Base Amount | Num | 19 | 6 | | |
7 | RCT7 | Incoming Pmt - Tax Amount per Document | 9 | BaseSum | Base Amount | Num | 19 | 6 | | |
8 | VPM5 | Outgoing Payments - Vat Adjustment | 9 | BaseSum | Base Amount | Num | 19 | 6 | | |
9 | VPM7 | Outgoing Payments - Tax Amount per Document | 9 | BaseSum | Base Amount | Num | 19 | 6 | | |
TOPFinance |
10 | AJD1 | Journal Entry - History - Rows | 42 | BaseSum | Base Amount | Num | 19 | 6 | | |
11 | BTF1 | Journal Voucher | 42 | BaseSum | Base Amount | Num | 19 | 6 | | |
12 | JDT1 | Journal Entry - Rows | 42 | BaseSum | Base Amount | Num | 19 | 6 | | |
13 | TAX1 | VAT Transactions - Rows | 23 | BaseSum | Base Sum | Num | 19 | 6 | | |
14 | UTX1 | Unreported VAT Transactions - Rows | 23 | BaseSum | Base Sum | Num | 19 | 6 | | |
TOPInventory and Production |
15 | IGE4 | Goods Issue - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
16 | IGN4 | Goods Receipt - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
17 | WTQ4 | Inventory Transfer Request - Tax Amount per Document | 14 | BaseSum | Tax Amount (FC) | Num | 19 | 6 | | |
18 | WTR4 | Inventory Transfer - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
TOPMarketing Documents |
19 | ADO4 | Documents - Tax - History | 14 | BaseSum | Tax Amount (FC) | Num | 19 | 6 | | |
20 | CIN4 | Correction Invoice - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
21 | CPI4 | A/P Correction Invoice - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
22 | CPV4 | A/P Correction Invoice Reversal - Tax Amt per Doc. | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
23 | CSI4 | A/R Correction Invoice - Tax Amount Per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
24 | CSV4 | A/R Correction Invoice Reversal - Tax Amount Per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
25 | DLN4 | Delivery - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
26 | DPI4 | A/R Down Payment - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
27 | DPO4 | A/P Down Payment - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
28 | DRF4 | Draft Documents - Tax | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
29 | IEI4 | Incoming Excise Invoice - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
30 | INV4 | A/R Invoice - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
31 | OEI4 | Outgoing Excise Invoice - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
32 | PCH4 | A/P Invoice - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
33 | PDN4 | Goods Receipt PO - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
34 | POR4 | Purchase Order - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
35 | PQT4 | Purchase Quotation - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
36 | QUT4 | Sales Quotation - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
37 | RDN4 | Returns - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
38 | RDR4 | Sales Order - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
39 | RIN4 | A/R Credit Memo - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
40 | RPC4 | A/P Credit Memo - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |
41 | RPD4 | Goods Return - Tax Amount per Document | 14 | BaseSum | Base Amount | Num | 19 | 6 | | |