| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBanking |
| 1 | ARCT | Incoming Payment - History | 153 | OperatCode | Operation Code | VarChar | 1 | 0 | | A=Summary Invoices Entry, B=Summary Receipts Entry, C=Invoice with Several VAT Rates, D=Correction Invoice, E=Due VAT Pending Invoice Issuance, F=Expenses Incurred by Travel Agent for Customers, G=Special Regulation for VAT Group, H=Special Regulation for Gold Investment, I=Reverse Charge Procedure, J=Unsummarized Receipts, K=Identificatio |
| 2 | OPDF | Payment Draft | 153 | OperatCode | Operation Code | VarChar | 1 | 0 | | A=Summary Invoices Entry, B=Summary Receipts Entry, C=Invoice with Several VAT Rates, D=Correction Invoice, E=Due VAT Pending Invoice Issuance, F=Expenses Incurred by Travel Agent for Customers, G=Special Regulation for VAT Group, H=Special Regulation for Gold Investment, I=Reverse Charge Procedure, J=Unsummarized Receipts, K=Identificatio |
| 3 | ORCT | Incoming Payment | 153 | OperatCode | Operation Code | VarChar | 1 | 0 | | A=Summary Invoices Entry, B=Summary Receipts Entry, C=Invoice with Several VAT Rates, D=Correction Invoice, E=Due VAT Pending Invoice Issuance, F=Expenses Incurred by Travel Agent for Customers, G=Special Regulation for VAT Group, H=Special Regulation for Gold Investment, I=Reverse Charge Procedure, J=Unsummarized Receipts, K=Identificatio |
| 4 | OVPM | Outgoing Payments | 153 | OperatCode | Operation Code | VarChar | 1 | 0 | | A=Summary Invoices Entry, B=Summary Receipts Entry, C=Invoice with Several VAT Rates, D=Correction Invoice, E=Due VAT Pending Invoice Issuance, F=Expenses Incurred by Travel Agent for Customers, G=Special Regulation for VAT Group, H=Special Regulation for Gold Investment, I=Reverse Charge Procedure, J=Unsummarized Receipts, K=Identificatio |
| TOPFinance |
| 5 | AJDT | Journal Entry - History | 81 | OperatCode | Operation Code | VarChar | 1 | 0 | | A=Summary Invoices Entry, B=Summary Receipts Entry, C=Invoice with Several VAT Rates, D=Correction Invoice, E=Due VAT Pending Invoice Issuance, F=Expenses Incurred by Travel Agent for Customers, G=Special Regulation for VAT Group, H=Special Regulation for Gold Investment, I=Reverse Charge Procedure, J=Unsummarized Receipts, K=Identificatio |
| 6 | OBTF | Journal Voucher Entry | 81 | OperatCode | Operation Code | VarChar | 1 | 0 | | A=Summary Invoices Entry, B=Summary Receipts Entry, C=Invoice with Several VAT Rates, D=Correction Invoice, E=Due VAT Pending Invoice Issuance, F=Expenses Incurred by Travel Agent for Customers, G=Special Regulation for VAT Group, H=Special Regulation for Gold Investment, I=Reverse Charge Procedure, J=Unsummarized Receipts, K=Identificatio |
| 7 | OJDT | Journal Entry | 81 | OperatCode | Operation Code | VarChar | 1 | 0 | | 1=Deferred Tax - Summary Invoices Entry, 2=Deferred Tax - Invoices with Several Entries (More Than One Tax Group), 3=Deferred Tax - Correction Invoice, 4=Deferred Tax - Acquisitions Made by Travel Agencies in the Travelers Own Interest (Special Regime for Travel Agencies), 5=Deferred Tax - Simplified Invoices, 6=Deferred Tax - Correction o |
