| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | NFN1 | Not a Fiscal Sequence | 19 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
2 | NFN4 | Manual Nota Fiscal Number | 8 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | | |
3 | OPOS | POS Master Data | 2 | Model | Model | nVarChar | 20 | 0 | | |
TOPInventory and Production |
4 | IGE21 | Goods Issue - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
5 | IGN21 | Goods Receipt - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
6 | OIGE | Goods Issue | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
7 | OIGN | Goods Receipt | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
8 | OWTQ | Inventory Transfer Request | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
9 | OWTR | Inventory Transfer | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
10 | WTQ21 | Inventory Transfer Request - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
11 | WTR21 | Inventory Transfer - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
TOPMarketing Documents |
12 | ADO21 | A/R Invoice - Document Reference Information - History | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
13 | ADOC | Invoice - History | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
14 | CIN21 | Correction Invoice - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
15 | CPI21 | A/P Correction Invoice - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
16 | CPV21 | A/P Correction Invoice Reversal - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
17 | CSI21 | A/R Correction Invoice - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
18 | CSV21 | A/R Correction Invoice Reversal - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
19 | DLN21 | Delivery - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
20 | DPI21 | A/R Down Payment - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
21 | DPO21 | A/P Down Payment - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
22 | DRF21 | Draft - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
23 | IEI21 | Incoming Excise Invoice - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
24 | INV21 | A/R Invoice - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
25 | OCIN | A/R Correction Invoice | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
26 | OCPI | A/P Correction Invoice | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
27 | OCPV | A/P Correction Invoice Reversal | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
28 | OCSI | A/R Correction Invoice | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
29 | OCSV | A/R Correction Invoice Reversal | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
30 | ODLN | Delivery | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
31 | ODPI | A/R Down Payment | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
32 | ODPO | A/P Down Payment | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
33 | ODRF | Drafts | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
34 | OEI21 | Outgoing Excise Invoice - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
35 | OIEI | Incoming Excise Invoice | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
36 | OINV | A/R Invoice | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
37 | OOEI | Outgoing Excise Invoice | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
38 | OPCH | A/P Invoice | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
39 | OPDN | Goods Receipt PO | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
40 | OPOR | Purchase Order | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
41 | OPQT | Purchase Quotation | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
42 | OPRQ | Purchase Request | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
43 | OPRR | Goods Return Request | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
44 | OQUT | Sales Quotation | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
45 | ORDN | Returns | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
46 | ORDR | Sales Order | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
47 | ORIN | A/R Credit Memo | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
48 | ORPC | A/P Credit Memo | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
49 | ORPD | Goods Return | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
50 | ORRR | Return Request | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
51 | OSFC | Self Credit Memo | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
52 | OSFI | Self Invoice | 236 | Model | Nota Fiscal Model | nVarChar | 6 | 0 | 0 | |
53 | PCH21 | A/P Invoice - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
54 | PDN21 | Goods Receipt PO - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
55 | POR21 | Purchase Order - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
56 | PQT21 | Purchase Quotation - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
57 | PRQ21 | Purchase Request - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
58 | PRR21 | A/P Return Request - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
59 | QUT21 | Sales Quotation - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
60 | RDN21 | Returns - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
61 | RDR21 | Sales Order - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
62 | RIN21 | A/R Credit Memo - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
63 | RPC21 | A/P Credit Memo - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
64 | RPD21 | Goods Return - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
65 | RRR21 | A/R Return Request - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
66 | SFC21 | Self Credit Memo - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |
67 | SFI21 | Self Invoice - Document Reference Information | 14 | Model | Fiscal Document Model | nVarChar | 6 | 0 | | |