SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

222 columns | Print definition?B1 9.2  | BASETYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPFinance
1AJD2Withholding Tax - History18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
2AWHTWithholding Tax6BaseTypeBase TypeVarChar10NG=Gross, N=Net, V=VAT
3AWTDWithholding Tax Definition9BaseTypeBase TypeVarChar10NG=Gross, N=Net, V=VAT
4BTF2Journal Voucher Withholding Tax - History18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
5JDT2Withholding Tax - History18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
6JST1TDS Adjustment - Rows20BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
7OWHTWithholding Tax6BaseTypeBase TypeVarChar10NG=Gross, N=Net, V=VAT
8OWTDWithholding Tax Definition9BaseTypeBase TypeVarChar10NG=Gross, N=Net, V=VAT
9UWTX1WTax Transactions - Rows15BaseTypeBase TypeVarChar10NG=Gross, N=Net, V=VAT
10WTX1WTax Transactions - Rows15BaseTypeBase TypeVarChar10NG=Gross, N=Net, V=VAT
TOPGeneral
11CIN11Correction Invoice - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
12OBVLSerial Numbers and Batch Valuation Log5BaseTypeBase Document TypeInt110-113=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
13UBVLSerial Numbers and Batch Valuation Log5BaseTypeBase Document TypeInt110-113=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
14AQR1Inventory Posting - Rows34BaseTypeBase Document TypeInt11014700000651470000065=Inventory Counting
15IGE1Goods Issue - Rows6BaseTypeBase Document TypeInt110-1202=Production Order
16IGE11Goods Issue - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
17IGE13Goods Issue Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
18IGE3Goods Issue - Freight41BaseTypeBase Document TypeInt110-1202=Production Order
19IGE4Goods Issue - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
20IGE5Goods Issue - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
21IGN1Goods Receipt - Rows6BaseTypeBase Document TypeInt110-1202=Production Order
22IGN11Goods Receipt - Drawn Dpm Det5BaseTypeBase Object TypeInt110-1
23IGN13Goods Receipt Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
24IGN3Goods Receipt - Freight41BaseTypeBase Document TypeInt110-1202=Production Order
25IGN4Goods Receipt - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
26IGN5Goods Receipt - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
27ILM3Non-Inventory and Resource Components Log Msg11BaseTypeBase Transaction TypeInt110-160=Goods Issue
28IPD1Inventory Posting Draft - Rows34BaseTypeBase Document TypeInt11014700000651470000065=Inventory Counting
29IPF1Landed Costs - Rows3BaseTypeBase Document TypeInt110-118=A/P Invoice, 20=Goods Receipt PO, 69=Landed Costs
30IQR1Inventory Posting - Rows34BaseTypeBase Document TypeInt11014700000651470000065=Inventory Counting
31OAIMArchive Inventory Message12BaseTypeBase Transaction TypeInt110-113=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
32OILMInventory Log Message13BaseTypeBase Transaction TypeInt110-113=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
33OIMTTemplates for Inventory JE3BaseTypeBase Transaction TypeInt60-1
34OITLInventory Transactions Log12BaseTypeBase Document TypeInt110-113=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
35ORTLResource Transaction Log6BaseTypeBase Document TypeInt110
36UILMIVI Inventory Log Message13BaseTypeBase Transaction TypeInt110-113=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
37UILM3Non-Inventory and Resource Components Log Msg11BaseTypeBase Transaction TypeInt110-160=Goods Issue
38WTQ1Inventory Transfer Request - Rows6BaseTypeBase Document TypeInt110-120=Purchase Delivery Notes, 59=Inventory General Entry, 67=Warehouse Transfers
39WTQ11Inv. Transfer Request - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
40WTQ13Inventory Transfer Request Rows - Distributed Freights41BaseTypeBase Document TypeInt110
41WTQ3Inventory Transfer Request - Freight41BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 59=Goods Receipt
42WTQ4Inventory Transfer Request - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
43WTQ5Inventory Transfer Request - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
44WTR1Inventory Transfer - Rows6BaseTypeBase Document TypeInt110-11250000001=Inventory Transfer Request, 20=Purchase Delivery Notes, 59=Inventory General Entry, 67=Warehouses Transfers
45WTR11Inv. Transfer - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
46WTR13Inventory Transfer Rows - Distributed Freights41BaseTypeBase Document TypeInt110
47WTR3Inventory Transfer - Freight41BaseTypeBase Document TypeInt110-11250000001=Inventory Transfer Request, 20=Goods Receipt PO, 59=Goods Receipt, 67=Inventory Transfer
48WTR4Inventory Transfer - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
49WTR5Inventory Transfer - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
TOPMarketing Documents
50ADO1A/R Invoice (Rows) - History6BaseTypeBase Document TypeInt110-113=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
51ADO11A/R Inv (Drawn Dpm Det) - Hist5BaseTypeBase Object TypeInt110-1
52ADO13A/R Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
53ADO20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
54ADO3A/R Invoice - Freight - History41BaseTypeBase Document TypeInt110-113=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
55ADO4Documents - Tax - History25BaseTypeBase Document TypeInt110-1
56ADO5Withholding Tax - History18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
57CIN1Correction Invoice - Rows6BaseTypeBase Document TypeInt110-116=A/R Returns, 17=Sales Order, 23=Sales Quotation
58CIN13Correction Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
59CIN20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
60CIN3A/R Correction Invoice - Freight41BaseTypeBase Document TypeInt110-116=A/R Returns, 17=Sales Order, 23=Sales Quotation
61CIN4Correction Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
62CIN5AR Correction Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
63CPI1A/P Correction Invoice - Rows6BaseTypeBase Document TypeInt110-1163=A/P Correction Invoice, 18=A/P Invoice
64CPI11A/P Corr. Inv - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
65CPI13A/P Correction Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
66CPI20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
67CPI3A/P Correction Invoice - Freight41BaseTypeBase Document TypeInt110163=A/P Correction Invoice, 18=A/P Invoice
68CPI4A/P Correction Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
69CPI5Withholding Tax Data18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
70CPV1A/P Correction Invoice Reversal - Rows6BaseTypeBase Document TypeInt110-1163=A/P Correction Invoice
71CPV11A/P CrIn Rev - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
72CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
73CPV20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
74CPV3A/P Correction Invoice Reversal - Freight41BaseTypeBase Document TypeInt110163=A/P Correction Invoice
75CPV4A/P Correction Invoice Reversal - Tax Amt per Doc.25BaseTypeBase Document TypeInt110-1
76CPV5A/P Correction Invoice Reversal - WTax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
77CSI1A/R Correction Invoice - Rows6BaseTypeBase Document TypeInt110-113=A/R Invoice, 165=A/R Correction Invoice
78CSI11A/R Corr. Inv. - Drawn Dpm Det5BaseTypeBase Object TypeInt110-1
79CSI13A/R Correction Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
80CSI20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
81CSI3A/R Correction Invoice - Freight41BaseTypeBase Document TypeInt11013=A/R Invoice, 165=A/R Correction Invoice
82CSI4A/R Correction Invoice - Tax Amount Per Document25BaseTypeBase Document TypeInt110-1
83CSI5A/R Correction Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
84CSV1A/R Correction Invoice Reversal - Rows6BaseTypeBase Document TypeInt110-1165=A/R Correction Invoice
85CSV11A/R CrIn Rev - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
86CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
87CSV20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
88CSV3A/R Correction Invoice Reversal - Freight41BaseTypeBase Document TypeInt110165=A/R Correction Invoice
89CSV4A/R Correction Invoice Reversal - Tax Amount Per Document25BaseTypeBase Document TypeInt110-1
90CSV5A/R Correction Invoice Reversal - WTax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
91DLN1Delivery - Rows6BaseTypeBase Document TypeInt110-113=A/R Invoice, 15=Delivery, 165=A/R Correction Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
92DLN11Delivery - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
93DLN13Delivery Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
94DLN20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
95DLN3Delivery Notes - Freight41BaseTypeBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
96DLN4Delivery - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
97DLN5Delivery - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
98DOC20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
99DPI1A/R Down Payment - Rows6BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 203=A/R Down Payment, 23=Quotation
100DPI11A/R DP - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
101DPI13A/R Down Payment Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
102DPI20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
103DPI3A/R Down Payment - Freight41BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
104DPI4A/R Down Payment - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
105DPI5A/R Down Payment - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
106DPO1A/P Down Payment - Rows6BaseTypeBase Document TypeInt110-1204=A/P Down Payment, 20=Goods Receipt PO, 22=Purchase Order, 540000006=Purchase Quotation
107DPO11A/P DP - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
108DPO13A/P Down Payment Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
109DPO20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
110DPO3A/P Down Payment - Freight41BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
111DPO4A/P Down Payment - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
112DPO5A/P Down Payment - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
113DRF1Draft - Rows6BaseTypeBase Document TypeInt110-11250000001=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
114DRF11Draft - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
115DRF13Draft Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
116DRF20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
117DRF3Draft - Freight41BaseTypeBase Document TypeInt11013=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
118DRF4Draft Documents - Tax25BaseTypeBase Document TypeInt110-1
119DRF5Draft Documents - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
120GPA1Gross Profit Adjustment - Documents30BaseTypeBase TypenVarChar200
121IEI1Incoming Excise Invoice - Rows6BaseTypeBase Document TypeInt110-1140000009=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
122IEI11IEI - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
123IEI13Incoming Excise Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
124IEI20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
125IEI3IEI - Freight41BaseTypeBase Document TypeInt110-1
126IEI4Incoming Excise Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
127IEI5Incoming Excise Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
128IGE20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
129IGN20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
130INV1A/R Invoice - Rows6BaseTypeBase Document TypeInt110-113=Invoice, 15=Delivery, 17=Sales Order, 23=Sales Quotation
131INV11A/R Invoice - Drawn Dpm Detail5BaseTypeBase Object TypeInt110203203=A/R Down Payment
132INV13A/R Invoice Rows - Distributed Freights41BaseTypeBase Document TypeInt110
133INV20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
134INV3A/R Invoice - Freight41BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
135INV4A/R Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
136INV5A/R Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
137OEI1Outgoing Excise Invoice - Rows6BaseTypeBase Document TypeInt110-114=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
138OEI11OEI - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
139OEI13Outgoing Excise Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
140OEI20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
141OEI3OEI - Freight41BaseTypeBase Document TypeInt110-1
142OEI4Outgoing Excise Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
143OEI5Outgoing Excise Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
144PCH1A/P Invoice - Rows6BaseTypeBase Document TypeInt110-118=A/P Invoice, 20=Goods Receipt PO, 22=Purchase Orders, 540000006=Purchase Quotation, 69=Landed Costs
145PCH11A/P Invoice - Drawn Dpm Det.5BaseTypeBase Object TypeInt110204204=A/P Down Payment
146PCH13A/P Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
147PCH20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
148PCH3A/P Invoice - Freight41BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
149PCH4A/P Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
150PCH5A/P Invoice - Withholding Tax Data18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
151PDN1Goods Receipt PO - Rows6BaseTypeBase Document TypeInt110-1163=A/P Correction Invoice, 18=A/P Invoice, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase Orders, 540000006=Purchase Quotation
152PDN11GRPO - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
153PDN13Goods Receipt PO Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
154PDN20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
155PDN3Goods Receipt PO - Freight41BaseTypeBase Document TypeInt110-118=A/P Invoice, 21=Goods Return, 22=Purchase orders
156PDN4Goods Receipt PO - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
157PDN5Goods Reciept PO - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
158POR1Purchase Order - Rows6BaseTypeBase Document TypeInt110-11470000113=Purchase Request, 17=Sales Order, 22=Purchase Orders, 23=Sales Quotation, 540000006=Purchase Quotation
159POR11PO - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
160POR13Purchase Order Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
161POR20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
162POR3Purchase Order - Freight41BaseTypeBase Document TypeInt110-11470000113=Purchase Request, 17=Sales Order
163POR4Purchase Order - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
164POR5Purchase Order - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
165PQT1Purchase Quotation - Rows6BaseTypeBase Document TypeInt110-11470000113=Purchase Request, 17=Sales Order, 23=Sales Quotation
166PQT11PQ - Drawn DPM Detail5BaseTypeBase Object TypeInt110-1
167PQT13Purchase Quotation Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
168PQT20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
169PQT3Purchase Quotation - Freight41BaseTypeBase Document TypeInt110-117=Sales Order
170PQT4Purchase Quotation - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
171PQT5Purchase Quotation - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
172PRQ1Purchase Request - Rows6BaseTypeBase Document TypeInt110-117=Sales Order, 23=Sales Quotation
173PRQ11PR - Drawn DPM Detail5BaseTypeBase Object TypeInt110-1
174PRQ13Purchase Request Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
175PRQ20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
176PRQ3Purchase Request - Freight41BaseTypeBase Document TypeInt110-117=Sales Order
177PRQ4Purchase Request - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
178PRQ5Purchase Request - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
179QUT1Sales Quotation - Rows6BaseTypeBase Document TypeInt110-1
180QUT11Sls Quote - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
181QUT13Sales Quotation Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
182QUT20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
183QUT3Sales Quotation - Freight41BaseTypeBase Document TypeInt110-1
184QUT4Sales Quotation - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
185QUT5Sales Quotation - Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
186RDN1Returns - Rows6BaseTypeBase Document TypeInt110-115=A/R Delivery Note, 16=A/R Returns
187RDN11Returns - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
188RDN13Returns Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
189RDN20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
190RDN3Return - Freight41BaseTypeBase Document TypeInt110-115=Delivery
191RDN4Returns - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
192RDN5Returns - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
193RDR1Sales Order - Rows6BaseTypeBase Document TypeInt110-123=Sales Quotation
194RDR11Sls Ord. - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
195RDR13Sales Order Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
196RDR20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
197RDR3Sales Order - Freight41BaseTypeBase Document TypeInt110-123=Sales Quotation
198RDR4Sales Order - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
199RDR5Sales Order - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
200RIN1A/R Credit Memo - Rows6BaseTypeBase Document TypeInt110-113=A/R Invoice, 14=A/R Credit Note, 16=A/R Returns, 203=A/R Down Payment
201RIN11A/R Cr. Memo - Drawn Dpm Det.5BaseTypeBase Object TypeInt110203203=A/R Down Payment
202RIN13A/R Credit Memo Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
203RIN20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
204RIN3A/R Credit Memo - Freight41BaseTypeBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 203=A/R Down Payment
205RIN4A/R Credit Memo - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
206RIN5A/R Credit Memo - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
207RPC1A/P Credit Memo - Rows6BaseTypeBase Document TypeInt110-118=A/P Invoice, 19=A/P Credit Memo, 204=A/P Down Payment, 21=Goods Return
208RPC11A/P Cr. Memo - Drawn Dpm Det.5BaseTypeBase Object TypeInt110204204=A/P Down Payment
209RPC13A/P Credit Memo Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
210RPC20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
211RPC3A/P Credit Memo - Freight41BaseTypeBase Document TypeInt110-118=A/P Invoice, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return
212RPC4A/P Credit Memo - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
213RPC5A/P Credit Memo - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
214RPD1Goods Return - Rows6BaseTypeBase Document TypeInt110-120=Purchase Delivery Notes, 21=Goods Return
215RPD11Gds Return - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
216RPD13Goods Returns Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
217RPD20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
218RPD3Goods Return - Freight41BaseTypeBase Document TypeInt110-120=Purchase Delivery Notes
219RPD4Goods Return - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
220RPD5Goods Return - Withholding Tax Data18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
221WTQ20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
222WTR20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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