| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBanking |
1 | ARCT | Incoming Payment - History | 170 | DraftKey | Payment Draft Internal ID | Int | 11 | 0 | | |
2 | OPDF | Payment Draft | 170 | DraftKey | Payment Draft Internal ID | Int | 11 | 0 | | |
3 | ORCT | Incoming Payment | 170 | DraftKey | Payment Draft Internal ID | Int | 11 | 0 | | |
4 | OVPM | Outgoing Payments | 170 | DraftKey | Payment Draft Internal ID | Int | 11 | 0 | | |
TOPInventory and Production |
5 | AINC | Inventory Counting | 21 | DraftKey | Draft Document Internal ID | Int | 11 | 0 | -1 | |
6 | AIQI | Inventory Opening Balance | 27 | DraftKey | Draft Document Internal ID | Int | 11 | 0 | -1 | |
7 | AIQR | Inventory Posting | 28 | DraftKey | Draft Document Internal ID | Int | 11 | 0 | -1 | |
8 | OICD | Inventory Counting Draft | 21 | DraftKey | Draft Document Internal ID | Int | 11 | 0 | -1 | |
9 | OIGE | Goods Issue | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
10 | OIGN | Goods Receipt | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
11 | OINC | Inventory Counting | 21 | DraftKey | Draft Document Internal ID | Int | 11 | 0 | -1 | |
12 | OIOD | Inventory Opening Balance Draft | 27 | DraftKey | Draft Document Internal ID | Int | 11 | 0 | -1 | |
13 | OIPD | Inventory Posting Draft | 28 | DraftKey | Draft Document Internal ID | Int | 11 | 0 | -1 | |
14 | OIQI | Inventory Opening Balance | 27 | DraftKey | Draft Document Internal ID | Int | 11 | 0 | -1 | |
15 | OIQR | Inventory Posting | 28 | DraftKey | Draft Document Internal ID | Int | 11 | 0 | -1 | |
16 | OWTQ | Inventory Transfer Request | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
17 | OWTR | Inventory Transfer | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
TOPMarketing Documents |
18 | ADOC | Invoice - History | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
19 | OCIN | A/R Correction Invoice | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
20 | OCPI | A/P Correction Invoice | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
21 | OCPV | A/P Correction Invoice Reversal | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
22 | OCSI | A/R Correction Invoice | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
23 | OCSV | A/R Correction Invoice Reversal | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
24 | ODLN | Delivery | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
25 | ODPI | A/R Down Payment | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
26 | ODPO | A/P Down Payment | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
27 | ODRF | Drafts | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
28 | OIEI | Incoming Excise Invoice | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
29 | OINV | A/R Invoice | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
30 | OOEI | Outgoing Excise Invoice | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
31 | OPCH | A/P Invoice | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
32 | OPDN | Goods Receipt PO | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
33 | OPOR | Purchase Order | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
34 | OPQT | Purchase Quotation | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
35 | OPRQ | Purchase Request | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
36 | OPRR | Goods Return Request | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
37 | OQUT | Sales Quotation | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
38 | ORDN | Returns | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
39 | ORDR | Sales Order | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
40 | ORIN | A/R Credit Memo | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
41 | ORPC | A/P Credit Memo | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
42 | ORPD | Goods Return | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
43 | ORRR | Return Request | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
44 | OSFC | Self Credit Memo | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |
45 | OSFI | Self Invoice | 84 | draftKey | Document Draft Internal ID | Int | 11 | 0 | -1 | |