| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBusiness Partners |
1 | ACP1 | Campaign - BPs | 38 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
2 | ACR1 | Business Partner Addresses - History | 13 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
3 | ACRD | Business Partners - History | 24 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
4 | CPN1 | Campaign - BPs | 38 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
5 | CRD1 | Business Partners - Addresses | 13 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
6 | OCRD | Business Partner | 24 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
7 | TGG1 | Target Group Details | 27 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
TOPFinance |
8 | AGAR | G/L Account Advanced Rules - History | 22 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | !^| | !^|=All, !^|E=Empty, !^|F=Filled, Enter Tax ID=Enter Tax ID |
9 | AJD1 | Journal Entry - History - Rows | 111 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
10 | BTF1 | Journal Voucher - Rows | 111 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
11 | JDT1 | Journal Entry - Rows | 111 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
12 | OGAR | G/L Account Advanced Rules | 22 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | !^| | !^|=All, !^|E=Empty, !^|F=Filled, Enter Tax ID=Enter Tax ID |
TOPGeneral |
13 | AGRS | G/L Account Advanced Rules for Resources - History | 22 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | !^| | !^|=All, !^|E=Empty, !^|F=Filled, Enter Tax ID=Enter Tax ID |
14 | OGRS | G/L Account Advanced Rules for Resources | 22 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | !^| | !^|=All, !^|E=Empty, !^|F=Filled, Enter Tax ID=Enter Tax ID |
TOPInventory and Production |
15 | IGE1 | Goods Issue - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
16 | IGN1 | Goods Receipt - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
17 | OIGE | Goods Issue | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
18 | OIGN | Goods Receipt | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
19 | OWTQ | Inventory Transfer Request | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
20 | OWTR | Inventory Transfer | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
21 | WTQ1 | Inventory Transfer Request - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
22 | WTR1 | Inventory Transfer - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
TOPMarketing Documents |
23 | ADO1 | A/R Invoice (Rows) - History | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
24 | ADOC | Invoice - History | 103 | LicTradNum | L.T. No. | nVarChar | 32 | 0 | | |
25 | CIN1 | Correction Invoice - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
26 | CPI1 | A/P Correction Invoice - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
27 | CPV1 | A/P Correction Invoice Reversal - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
28 | CSI1 | A/R Correction Invoice - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
29 | CSV1 | A/R Correction Invoice Reversal - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
30 | DLN1 | Delivery - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
31 | DPI1 | A/R Down Payment - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
32 | DPO1 | A/P Down Payment - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
33 | DRF1 | Draft - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
34 | IEI1 | Incoming Excise Invoice - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
35 | INV1 | A/R Invoice - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
36 | OCIN | A/R Correction Invoice | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
37 | OCPI | A/P Correction Invoice | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
38 | OCPV | A/P Correction Invoice Reversal | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
39 | OCSI | A/R Correction Invoice | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
40 | OCSV | A/R Correction Invoice Reversal | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
41 | ODLN | Delivery | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
42 | ODPI | A/R Down Payment | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
43 | ODPO | A/P Down Payment | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
44 | ODRF | Drafts | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
45 | OEI1 | Outgoing Excise Invoice - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
46 | OIEI | Incoming Excise Invoice | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
47 | OINV | A/R Invoice | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
48 | OOEI | Outgoing Excise Invoice | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
49 | OPCH | A/P Invoice | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
50 | OPDN | Goods Receipt PO | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
51 | OPOR | Purchase Order | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
52 | OPQT | Purchase Quotation | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
53 | OPRQ | Purchase Request | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
54 | OPRR | Goods Return Request | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
55 | OQUT | Sales Quotation | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
56 | ORDN | Returns | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
57 | ORDR | Sales Order | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
58 | ORIN | A/R Credit Memo | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
59 | ORPC | A/P Credit Memo | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
60 | ORPD | Goods Return | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
61 | ORRR | Return Request | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
62 | OSFC | Self Credit Memo | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
63 | OSFI | Self Invoice | 103 | LicTradNum | Licensed Dealer No. | nVarChar | 32 | 0 | | |
64 | PCH1 | A/P Invoice - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
65 | PDN1 | Goods Receipt PO - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
66 | POR1 | Purchase Order - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
67 | PQT1 | Purchase Quotation - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
68 | PRQ1 | Purchase Request - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
69 | PRR1 | A/P Return Request - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
70 | QUT1 | Sales Quotation - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
71 | RDN1 | Returns - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
72 | RDR1 | Sales Order - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
73 | RIN1 | A/R Credit Memo - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
74 | RPC1 | A/P Credit Memo - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
75 | RPD1 | Goods Return - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
76 | RRR1 | A/R Return Request - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
77 | SFC1 | Self Credit Memo - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |
78 | SFI1 | Self Invoice - Rows | 261 | LicTradNum | Federal Tax ID | nVarChar | 32 | 0 | | |