| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | MDC1 | Master Data Cleanup - Log | 8 | ObjectCode | Object Code | nVarChar | 100 | 0 | | |
| 2 | NFN1 | Not a Fiscal Sequence | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 3 | NFN2 | NFSeq User Default | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 4 | NFN3 | Assigned Nota Fiscal Series | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 5 | NFN4 | Manual Nota Fiscal Number | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 6 | NNM1 | Documents Numbering - Series | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 7 | NNM2 | Series Default | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 8 | NNM3 | Documents Numbering -Belgium Series | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 9 | NNM5 | Document Numbering - Removed Serial Numbers | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 10 | NNM6 | Documents Numbering - Supplementary Code | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 11 | ONFN | Nota Fiscal Numbering | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 12 | ONNM | Document Numbering | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 13 | ORLD | Reference Links Definition | 2 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| 14 | UDG4 | User Defaults - Default POI for Folio Numbering Documents | 3 | ObjectCode | Document | nVarChar | 20 | 0 | | |
| TOPFinance |
| 15 | FAM1 | Fixed Asset Data Migration - Rows | 4 | ObjectCode | Object Code | nVarChar | 20 | 0 | | |
| 16 | VTR1 | Tax Groups | 2 | ObjectCode | Object Code | nVarChar | 30 | 0 | | |
| 17 | VTR2 | Doc. Type Filter | 2 | ObjectCode | Object Code | nVarChar | 15 | 0 | | 13=A/R Invoices, 14=A/R Credit Memos, 18=A/P Invoices, 19=A/P Credit Memos, 203=A/R Down Payment, 204=A/P Down Payment, 24=Incoming Payments, 30=Journal Entries, 46=Outgoing Payments, 57=Checks for Payment, 67=Inventory Transfers |
| 18 | VTR3 | Series Filter | 2 | ObjectCode | Object Code | nVarChar | 15 | 0 | | |
| TOPGeneral |
| 19 | OFND | Folio Numbering Documents | 2 | ObjectCode | Document | nVarChar | 20 | 0 | | |
