| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | NFN1 | Not a Fiscal Sequence | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
2 | NFN2 | NFSeq User Default | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
3 | NFN3 | Assigned Nota Fiscal Series | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
4 | NFN4 | Manual Nota Fiscal Number | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
5 | NNM1 | Documents Numbering - Series | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
6 | NNM2 | Series Default | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
7 | NNM3 | Documents Numbering -Belgium Series | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
8 | NNM5 | Document Numbering - Removed Serial Numbers | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
9 | NNM6 | Documents Numbering - Supplementary Code | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
10 | ONFN | Nota Fiscal Numbering | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
11 | ONNM | Document Numbering | 1 | ObjectCode | Document | nVarChar | 20 | 0 | | |
12 | ORLD | Reference Links Definition | 2 | ObjectCode | Document | nVarChar | 20 | 0 | | |
TOPFinance |
13 | VTR1 | Tax Groups | 2 | ObjectCode | Object Code | nVarChar | 30 | 0 | | |
14 | 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 |
15 | VTR3 | Series Filter | 2 | ObjectCode | Object Code | nVarChar | 15 | 0 | | |
TOPService |
16 | MDC1 | Master Data Cleanup - Log | 8 | ObjectCode | Object Code | nVarChar | 100 | 0 | | |