| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | NNM5 | Document Numbering - Removed Serial Numbers | 4 | Number | Number | Int | 11 | 0 | | |
TOPBanking |
2 | OPOI | Incoming Payment Order | 2 | Number | Number | Int | 11 | 0 | | |
3 | OPOO | Outgoing Payment Order | 2 | Number | Number | Int | 11 | 0 | | |
TOPBusiness Partners |
4 | ACRD | Business Partners - History | 299 | Number | Number | Int | 11 | 0 | | |
5 | AOAT | Blanket Agreement | 37 | Number | Number | Int | 11 | 0 | | |
6 | OCRD | Business Partner | 299 | Number | Number | Int | 11 | 0 | | |
7 | OOAT | Blanket Agreement | 37 | Number | Number | Int | 11 | 0 | | |
TOPFinance |
8 | AJDT | Journal Entry - History | 42 | Number | Number | Int | 11 | 0 | | |
9 | OBTF | Journal Voucher Entry | 42 | Number | Number | Int | 11 | 0 | | |
10 | OJDT | Journal Entry | 42 | Number | Number | Int | 11 | 0 | | |
11 | ZRD1 | POS Daily Summary - Totals | 4 | Number | Totalizer Number | Int | 11 | 0 | | |
TOPGeneral |
12 | ARSC | Resource Master Data - Log | 4 | Number | Number | Int | 11 | 0 | | |
13 | ORSC | Resources | 4 | Number | Number | Int | 11 | 0 | | |
TOPInventory and Production |
14 | AITM | Items - History | 253 | Number | Number | Int | 11 | 0 | | |
15 | IGE21 | Goods Issue - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
16 | IGN21 | Goods Receipt - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
17 | OITM | Items | 253 | Number | Number | Int | 11 | 0 | | |
18 | OWTC | WTax Certificates | 9 | Number | Number | Int | 11 | 0 | | |
19 | SITM | Items | 253 | Number | Number | Int | 11 | 0 | | |
20 | UITM | Items | 253 | Number | Number | Int | 11 | 0 | | |
21 | WTQ21 | Inventory Transfer Request - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
22 | WTR21 | Inventory Transfer - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
TOPMarketing Documents |
23 | ADO21 | A/R Invoice - Document Reference Information - History | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
24 | CIN21 | Correction Invoice - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
25 | CPI21 | A/P Correction Invoice - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
26 | CPV21 | A/P Correction Invoice Reversal - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
27 | CSI21 | A/R Correction Invoice - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
28 | CSV21 | A/R Correction Invoice Reversal - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
29 | DLN21 | Delivery - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
30 | DPI21 | A/R Down Payment - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
31 | DPO21 | A/P Down Payment - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
32 | DRF21 | Draft - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
33 | IEI21 | Incoming Excise Invoice - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
34 | INV21 | A/R Invoice - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
35 | OEI21 | Outgoing Excise Invoice - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
36 | OMIN | A/R Monthly Invoice | 2 | Number | Monthly Invoice Number | Int | 11 | 0 | | |
37 | OMIV | A/P Monthly Invoice | 2 | Number | Monthly Invoice Number | Int | 11 | 0 | | |
38 | PCH21 | A/P Invoice - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
39 | PDN21 | Goods Receipt PO - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
40 | POR21 | Purchase Order - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
41 | PQT21 | Purchase Quotation - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
42 | PRQ21 | Purchase Request - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
43 | QUT21 | Sales Quotation - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
44 | RDN21 | Returns - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
45 | RDR21 | Sales Order - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
46 | RIN21 | A/R Credit Memo - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
47 | RPC21 | A/P Credit Memo - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
48 | RPD21 | Goods Return - Document Reference Information | 15 | Number | Fiscal Document Number | Int | 11 | 0 | | |
TOPReports |
49 | SRA3 | Scheduled Report Recipients | 10 | Number | Telephone Number | nVarChar | 100 | 0 | | |
TOPService |
50 | OSST | Service Call Solution Statuses | 1 | Number | Number | Int | 11 | 0 | | |