| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
1 | AJD2 | Withholding Tax - History | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
2 | AWHT | Withholding Tax | 6 | BaseType | Base Type | VarChar | 1 | 0 | N | G=Gross, N=Net, V=VAT |
3 | AWTD | Withholding Tax Definition | 9 | BaseType | Base Type | VarChar | 1 | 0 | N | G=Gross, H=Gross - VAT, N=Net, V=VAT |
4 | BTF2 | Journal Voucher Withholding Tax - History | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
5 | JDT2 | Withholding Tax - History | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
6 | JST1 | TDS Adjustment - Rows | 20 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
7 | OWHT | Withholding Tax | 6 | BaseType | Base Type | VarChar | 1 | 0 | N | G=Gross, N=Net, V=VAT |
8 | OWTD | Withholding Tax Definition | 9 | BaseType | Base Type | VarChar | 1 | 0 | N | G=Gross, H=Gross - VAT, N=Net, V=VAT |
9 | UWTX1 | WTax Transactions - Rows | 15 | BaseType | Base Type | VarChar | 1 | 0 | N | G=Gross, H=Gross - VAT, N=Net, V=VAT |
10 | WTX1 | WTax Transactions - Rows | 15 | BaseType | Base Type | VarChar | 1 | 0 | N | G=Gross, H=Gross - VAT, N=Net, V=VAT |
TOPGeneral |
11 | CIN11 | Correction Invoice - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
12 | OBVL | Serial Numbers and Batch Valuation Log | 5 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat |
13 | UBVL | Serial Numbers and Batch Valuation Log | 5 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat |
TOPInventory and Production |
14 | AQR1 | Inventory Posting - Rows | 34 | BaseType | Base Document Type | Int | 11 | 0 | 1470000065 | 1470000065=Inventory Counting |
15 | IGE1 | Goods Issue - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 202=Production Order |
16 | IGE11 | Goods Issue - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
17 | IGE13 | Goods Issue Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
18 | IGE3 | Goods Issue - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 202=Production Order |
19 | IGE4 | Goods Issue - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
20 | IGE5 | Goods Issue - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
21 | IGN1 | Goods Receipt - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 202=Production Order, 60=Goods Issue |
22 | IGN11 | Goods Receipt - Drawn Dpm Det | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
23 | IGN13 | Goods Receipt Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
24 | IGN3 | Goods Receipt - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 202=Production Order |
25 | IGN4 | Goods Receipt - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
26 | IGN5 | Goods Receipt - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
27 | ILM3 | Non-Inventory and Resource Components Log Msg | 11 | BaseType | Base Transaction Type | Int | 11 | 0 | -1 | 60=Goods Issue |
28 | IPD1 | Inventory Posting Draft - Rows | 34 | BaseType | Base Document Type | Int | 11 | 0 | 1470000065 | 1470000065=Inventory Counting |
29 | IPF1 | Landed Costs - Rows | 3 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 18=A/P Invoice, 20=Goods Receipt PO, 69=Landed Costs |
30 | IQR1 | Inventory Posting - Rows | 34 | BaseType | Base Document Type | Int | 11 | 0 | 1470000065 | 1470000065=Inventory Counting |
31 | IVL2 | Inventory Components for Production | 14 | BaseType | Base Transaction Type | Int | 11 | 0 | -1 | 60=Goods Issue |
32 | OAIM | Archive Inventory Message | 12 | BaseType | Base Transaction Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat |
33 | OIGE | Goods Issue | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
34 | OIGN | Goods Receipt | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
35 | OILM | Inventory Log Message | 13 | BaseType | Base Transaction Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat |
36 | OIMT | Templates for Inventory JE | 3 | BaseType | Base Transaction Type | Int | 6 | 0 | -1 | |
37 | OITL | Inventory Transactions Log | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat |
38 | ORTL | Resource Transaction Log | 6 | BaseType | Base Document Type | Int | 11 | 0 | | |
39 | OTNL | CCD Log | 11 | BaseType | Base Document Type | Int | 11 | 0 | | |
40 | OWTQ | Inventory Transfer Request | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
41 | OWTR | Inventory Transfer | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
42 | SIVL2 | Inventory Components for Production | 14 | BaseType | Base Transaction Type | Int | 11 | 0 | -1 | 60=Goods Issue |
43 | UILM | IVI Inventory Log Message | 13 | BaseType | Base Transaction Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 202=Production Order, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotat |
44 | UILM3 | Non-Inventory and Resource Components Log Msg | 11 | BaseType | Base Transaction Type | Int | 11 | 0 | -1 | 60=Goods Issue |
45 | UIVL2 | Inventory Components for Production | 14 | BaseType | Base Transaction Type | Int | 11 | 0 | -1 | 60=Goods Issue |
46 | WTQ1 | Inventory Transfer Request - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 20=Purchase Delivery Notes, 59=Inventory General Entry, 67=Warehouse Transfers |
47 | WTQ11 | Inv. Transfer Request - Drawn Dpm Det. | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
48 | WTQ13 | Inventory Transfer Request Rows - Distributed Freights | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
49 | WTQ3 | Inventory Transfer Request - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 20=Goods Receipt PO, 59=Goods Receipt |
50 | WTQ4 | Inventory Transfer Request - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
51 | WTQ5 | Inventory Transfer Request - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
52 | WTR1 | Inventory Transfer - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 1250000001=Inventory Transfer Request, 20=Purchase Delivery Notes, 59=Inventory General Entry, 67=Warehouses Transfers |
53 | WTR11 | Inv. Transfer - Drawn Dpm Det. | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
54 | WTR13 | Inventory Transfer Rows - Distributed Freights | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
55 | WTR3 | Inventory Transfer - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 1250000001=Inventory Transfer Request, 20=Goods Receipt PO, 59=Goods Receipt, 67=Inventory Transfer |
56 | WTR4 | Inventory Transfer - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
57 | WTR5 | Inventory Transfer - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
TOPMarketing Documents |
58 | ADO1 | A/R Invoice (Rows) - History | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=Invoices, 15=Delivery notes, 16=A/R Returns, 17=Sales Order, 18=Purchases, 20=Purchase Delivery Notes, 21=Revert Purchase Delivery Notes, 22=Purchase orders, 23=Sales Quotation, 60=Goods Issue |
59 | ADO11 | A/R Inv (Drawn Dpm Det) - Hist | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
60 | ADO13 | A/R Invoice Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
61 | ADO20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
62 | ADO3 | A/R Invoice - Freight - History | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=Invoices, 15=Delivery notes, 16=Revert Delivery Notes, 17=Orders, 18=Purchases, 20=Purchase Delivery Notes, 21=Revert Purchase Delivery Notes, 22=Purchase orders, 23=Quotations |
63 | ADO4 | Documents - Tax - History | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
64 | ADO5 | Withholding Tax - History | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
65 | ADOC | Invoice - History | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 67=Inventory Transfer |
66 | CIN1 | Correction Invoice - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 16=A/R Returns, 17=Sales Order, 23=Sales Quotation |
67 | CIN13 | Correction Invoice Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
68 | CIN20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
69 | CIN3 | A/R Correction Invoice - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 16=A/R Returns, 17=Sales Order, 23=Sales Quotation |
70 | CIN4 | Correction Invoice - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
71 | CIN5 | AR Correction Invoice - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
72 | CPI1 | A/P Correction Invoice - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 163=A/P Correction Invoice, 18=A/P Invoice |
73 | CPI11 | A/P Corr. Inv - Drawn Dpm Det. | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
74 | CPI13 | A/P Correction Invoice Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
75 | CPI20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
76 | CPI3 | A/P Correction Invoice - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | | 163=A/P Correction Invoice, 18=A/P Invoice |
77 | CPI4 | A/P Correction Invoice - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
78 | CPI5 | Withholding Tax Data | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
79 | CPV1 | A/P Correction Invoice Reversal - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 163=A/P Correction Invoice |
80 | CPV11 | A/P CrIn Rev - Drawn Dpm Det. | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
81 | CPV13 | A/P Correction Invoice Reversal Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
82 | CPV20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
83 | CPV3 | A/P Correction Invoice Reversal - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | | 163=A/P Correction Invoice |
84 | CPV4 | A/P Correction Invoice Reversal - Tax Amt per Doc. | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
85 | CPV5 | A/P Correction Invoice Reversal - WTax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
86 | CSI1 | A/R Correction Invoice - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 165=A/R Correction Invoice |
87 | CSI11 | A/R Corr. Inv. - Drawn Dpm Det | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
88 | CSI13 | A/R Correction Invoice Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
89 | CSI20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
90 | CSI3 | A/R Correction Invoice - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | | 13=A/R Invoice, 165=A/R Correction Invoice |
91 | CSI4 | A/R Correction Invoice - Tax Amount Per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
92 | CSI5 | A/R Correction Invoice - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
93 | CSV1 | A/R Correction Invoice Reversal - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 165=A/R Correction Invoice |
94 | CSV11 | A/R CrIn Rev - Drawn Dpm Det. | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
95 | CSV13 | A/R Correction Invoice Reversal Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
96 | CSV20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
97 | CSV3 | A/R Correction Invoice Reversal - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | | 165=A/R Correction Invoice |
98 | CSV4 | A/R Correction Invoice Reversal - Tax Amount Per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
99 | CSV5 | A/R Correction Invoice Reversal - WTax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
100 | DLN1 | Delivery - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery, 165=A/R Correction Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation |
101 | DLN11 | Delivery - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
102 | DLN13 | Delivery Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
103 | DLN20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
104 | DLN3 | Delivery Notes - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation |
105 | DLN4 | Delivery - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
106 | DLN5 | Delivery - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
107 | DOC20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
108 | DPI1 | A/R Down Payment - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 15=Delivery, 17=Sales Order, 203=A/R Down Payment, 23=Quotation |
109 | DPI11 | A/R DP - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
110 | DPI13 | A/R Down Payment Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
111 | DPI20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
112 | DPI3 | A/R Down Payment - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 15=Delivery, 17=Sales Order, 23=Sales Quotation |
113 | DPI4 | A/R Down Payment - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
114 | DPI5 | A/R Down Payment - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
115 | DPO1 | A/P Down Payment - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 204=A/P Down Payment, 20=Goods Receipt PO, 22=Purchase Order, 540000006=Purchase Quotation |
116 | DPO11 | A/P DP - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
117 | DPO13 | A/P Down Payment Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
118 | DPO20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
119 | DPO3 | A/P Down Payment - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 20=Goods Receipt PO, 22=Purchase orders |
120 | DPO4 | A/P Down Payment - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
121 | DPO5 | A/P Down Payment - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
122 | DRF1 | Draft - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 1250000001=Inventory Transfers Request, 132=Correction Invoice, 13=A/R Invoice, 1470000113=Purchase Request, 14=A/R Credit Memo, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 203=A |
123 | DRF11 | Draft - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
124 | DRF13 | Draft Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
125 | DRF20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 1470000113=Purchase Request, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
126 | DRF3 | Draft - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | | 13=A/R Invoice, 1470000113=Purchase Request, 15=Delivery notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Good Receipt PO, 21=Goods Return, 22=Purchase order, 23=Sales Quotation, 540000006=Purchase Quotation |
127 | DRF4 | Draft Documents - Tax | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
128 | DRF5 | Draft Documents - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
129 | GPA1 | Gross Profit Adjustment - Documents | 30 | BaseType | Base Type | nVarChar | 20 | 0 | | |
130 | IEI1 | Incoming Excise Invoice - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 140000009=Outgoing Excise Invoice, 14=A/R Credit Memo, 15=Delivery, 16=A/R Returns, 19=A/P Credit Memo, 20=Goods Receipt PO, 21=Goods Return |
131 | IEI11 | IEI - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
132 | IEI13 | Incoming Excise Invoice Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
133 | IEI20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
134 | IEI3 | IEI - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
135 | IEI4 | Incoming Excise Invoice - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
136 | IEI5 | Incoming Excise Invoice - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
137 | IGE20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
138 | IGN20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
139 | INV1 | A/R Invoice - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=Invoice, 15=Delivery, 17=Sales Order, 23=Sales Quotation |
140 | INV11 | A/R Invoice - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | 203 | 203=A/R Down Payment |
141 | INV13 | A/R Invoice Rows - Distributed Freights | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
142 | INV20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
143 | INV3 | A/R Invoice - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 15=Delivery, 17=Sales Order, 23=Sales Quotation |
144 | INV4 | A/R Invoice - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
145 | INV5 | A/R Invoice - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
146 | OCIN | A/R Correction Invoice | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
147 | OCPI | A/P Correction Invoice | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
148 | OCPV | A/P Correction Invoice Reversal | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
149 | OCSI | A/R Correction Invoice | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
150 | OCSV | A/R Correction Invoice Reversal | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
151 | ODLN | Delivery | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
152 | ODPI | A/R Down Payment | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
153 | ODPO | A/P Down Payment | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
154 | ODRF | Drafts | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 67=Inventory Transfer |
155 | OEI1 | Outgoing Excise Invoice - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 14=A/R Credit Memo, 15=Delivery, 16=A/R Returns, 19=A/P Credit Memo, 20=Goods Receipt PO, 21=Goods Return, 67=Inventory Transfers |
156 | OEI11 | OEI - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
157 | OEI13 | Outgoing Excise Invoice Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
158 | OEI20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
159 | OEI3 | OEI - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
160 | OEI4 | Outgoing Excise Invoice - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
161 | OEI5 | Outgoing Excise Invoice - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
162 | OIEI | Incoming Excise Invoice | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
163 | OINV | A/R Invoice | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 67=Inventory Transfer |
164 | OOEI | Outgoing Excise Invoice | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
165 | OPCH | A/P Invoice | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 67=Inventory Transfer |
166 | OPDN | Goods Receipt PO | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
167 | OPOR | Purchase Order | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
168 | OPQT | Purchase Quotation | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
169 | OPRQ | Purchase Request | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
170 | OPRR | Goods Return Request | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
171 | OQUT | Sales Quotation | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
172 | ORDN | Returns | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
173 | ORDR | Sales Order | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
174 | ORIN | A/R Credit Memo | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
175 | ORPC | A/P Credit Memo | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
176 | ORPD | Goods Return | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
177 | ORRR | Return Request | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
178 | OSFC | Self Credit Memo | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 67=Inventory Transfer |
179 | OSFI | Self Invoice | 408 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 67=Inventory Transfer |
180 | PCH1 | A/P Invoice - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 18=A/P Invoice, 20=Goods Receipt PO, 22=Purchase Orders, 540000006=Purchase Quotation, 69=Landed Costs |
181 | PCH11 | A/P Invoice - Drawn Dpm Det. | 5 | BaseType | Base Object Type | Int | 11 | 0 | 204 | 204=A/P Down Payment |
182 | PCH13 | A/P Invoice Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
183 | PCH20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
184 | PCH3 | A/P Invoice - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 20=Goods Receipt PO, 22=Purchase orders |
185 | PCH4 | A/P Invoice - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
186 | PCH5 | A/P Invoice - Withholding Tax Data | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
187 | PDN1 | Goods Receipt PO - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 163=A/P Correction Invoice, 18=A/P Invoice, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Orders, 540000006=Purchase Quotation |
188 | PDN11 | GRPO - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
189 | PDN13 | Goods Receipt PO Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
190 | PDN20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
191 | PDN3 | Goods Receipt PO - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 18=A/P Invoice, 21=Goods Return, 22=Purchase orders |
192 | PDN4 | Goods Receipt PO - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
193 | PDN5 | Goods Reciept PO - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
194 | POR1 | Purchase Order - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 1470000113=Purchase Request, 17=Sales Order, 22=Purchase Orders, 23=Sales Quotation, 540000006=Purchase Quotation |
195 | POR11 | PO - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
196 | POR13 | Purchase Order Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
197 | POR20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 1470000113=Purchase Request, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
198 | POR3 | Purchase Order - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 1470000113=Purchase Request, 17=Sales Order |
199 | POR4 | Purchase Order - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
200 | POR5 | Purchase Order - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
201 | PQT1 | Purchase Quotation - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 1470000113=Purchase Request, 17=Sales Order, 23=Sales Quotation |
202 | PQT11 | PQ - Drawn DPM Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
203 | PQT13 | Purchase Quotation Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
204 | PQT20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
205 | PQT3 | Purchase Quotation - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 17=Sales Order |
206 | PQT4 | Purchase Quotation - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
207 | PQT5 | Purchase Quotation - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
208 | PRQ1 | Purchase Request - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 17=Sales Order, 23=Sales Quotation |
209 | PRQ11 | PR - Drawn DPM Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
210 | PRQ13 | Purchase Request Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
211 | PRQ20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
212 | PRQ3 | Purchase Request - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 17=Sales Order |
213 | PRQ4 | Purchase Request - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
214 | PRQ5 | Purchase Request - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
215 | PRR1 | A/P Return Request - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 18=A/P Invoice, 20=Purchase Delivery Notes |
216 | PRR11 | A/P Return Request - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | 203 | 203=A/R Down Payment |
217 | PRR13 | A/P Return Request - Distributed Freights | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
218 | PRR20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
219 | PRR3 | A/P Return Request - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 18=A/P Invoice, 20=Goods Receipt PO |
220 | PRR4 | A/P Return Request - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
221 | PRR5 | A/P Return Request - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
222 | QUT1 | Sales Quotation - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
223 | QUT11 | Sls Quote - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
224 | QUT13 | Sales Quotation Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
225 | QUT20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
226 | QUT3 | Sales Quotation - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
227 | QUT4 | Sales Quotation - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
228 | QUT5 | Sales Quotation - Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
229 | RDN1 | Returns - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 15=A/R Delivery Note, 16=A/R Returns, 234000031=A/R Return Request |
230 | RDN11 | Returns - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
231 | RDN13 | Returns Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
232 | RDN20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
233 | RDN3 | Return - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 15=Delivery, 234000031=A/R Return Request |
234 | RDN4 | Returns - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
235 | RDN5 | Returns - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
236 | RDR1 | Sales Order - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 23=Sales Quotation |
237 | RDR11 | Sls Ord. - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
238 | RDR13 | Sales Order Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
239 | RDR20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
240 | RDR3 | Sales Order - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 23=Sales Quotation |
241 | RDR4 | Sales Order - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
242 | RDR5 | Sales Order - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
243 | RIN1 | A/R Credit Memo - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 14=A/R Credit Note, 16=A/R Returns, 203=A/R Down Payment, 234000031=A/R Return Request |
244 | RIN11 | A/R Cr. Memo - Drawn Dpm Det. | 5 | BaseType | Base Object Type | Int | 11 | 0 | 203 | 203=A/R Down Payment |
245 | RIN13 | A/R Credit Memo Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
246 | RIN20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
247 | RIN3 | A/R Credit Memo - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 16=A/R Returns, 203=A/R Down Payment, 234000031=A/R Return Request |
248 | RIN4 | A/R Credit Memo - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
249 | RIN5 | A/R Credit Memo - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
250 | RPC1 | A/P Credit Memo - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 18=A/P Invoice, 19=A/P Credit Memo, 204=A/P Down Payment, 21=Goods Return, 234000032=A/P Return Request |
251 | RPC11 | A/P Cr. Memo - Drawn Dpm Det. | 5 | BaseType | Base Object Type | Int | 11 | 0 | 204 | 204=A/P Down Payment |
252 | RPC13 | A/P Credit Memo Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
253 | RPC20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
254 | RPC3 | A/P Credit Memo - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 18=A/P Invoice, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 234000032=A/P Return Request |
255 | RPC4 | A/P Credit Memo - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
256 | RPC5 | A/P Credit Memo - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
257 | RPD1 | Goods Return - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 20=Purchase Delivery Notes, 21=Goods Return, 234000032=A/P Return Request |
258 | RPD11 | Gds Return - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
259 | RPD13 | Goods Returns Rows - Distributed Expenses | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
260 | RPD20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
261 | RPD3 | Goods Return - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 20=Purchase Delivery Notes, 234000032=A/P Return Request |
262 | RPD4 | Goods Return - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
263 | RPD5 | Goods Return - Withholding Tax Data | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
264 | RRR1 | A/R Return Request - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=Invoice, 15=Delivery |
265 | RRR11 | A/R Return Request - Drawn Dpm Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | 203 | 203=A/R Down Payment |
266 | RRR13 | A/R Return Request - Distributed Freights | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
267 | RRR20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
268 | RRR3 | A/R Return Request - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=Invoice, 15=Delivery |
269 | RRR4 | A/R Return Request - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
270 | RRR5 | A/R Return Request - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
271 | SFC1 | Self Credit Memo - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 19=A/P Credit Memo, 254000066=Self Credit Memo |
272 | SFC11 | Self Credit Memo - Drawn Down Payment Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
273 | SFC13 | Self Credit Memo Rows - Distributed Freights | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
274 | SFC20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=Self Credit Memo, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
275 | SFC3 | Self Credit Memo - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 15=Delivery, 17=Sales Order, 23=Sales Quotation |
276 | SFC4 | Self Credit Memo - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
277 | SFC5 | Self Credit Memo - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
278 | SFI1 | Self Invoice - Rows | 6 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 18=A/P Invoice, 19=A/P Credit Memo, 254000065=Self Invoice |
279 | SFI11 | Self Invoice - Drawn Down Payment Detail | 5 | BaseType | Base Object Type | Int | 11 | 0 | -1 | |
280 | SFI13 | Self Invoice Rows - Distributed Freights | 41 | BaseType | Base Document Type | Int | 11 | 0 | | |
281 | SFI20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
282 | SFI3 | Self Invoice - Freight | 41 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 15=Delivery, 17=Sales Order, 23=Sales Quotation |
283 | SFI4 | Self Invoice - Tax Amount per Document | 25 | BaseType | Base Document Type | Int | 11 | 0 | -1 | |
284 | SFI5 | Self Invoice - Withholding Tax | 18 | BaseType | Base Type | VarChar | 1 | 0 | | G=Gross, N=Net, V=VAT |
285 | WTQ20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |
286 | WTR20 | Intrastat Expenses | 12 | BaseType | Base Document Type | Int | 11 | 0 | -1 | 13=A/R Invoice, 15=Delivery Notes, 16=Return, 17=Sales Order, 18=A/P Invoice, 203=Down Payment Incoming, 204=Down Payment Outgoing, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Order, 23=Sales Quotation, 540000006=Purchase Quotation |