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
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
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
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

286 columns | Print definition?B1 9.3  | 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, H=Gross - VAT, 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, H=Gross - VAT, N=Net, V=VAT
9UWTX1WTax Transactions - Rows15BaseTypeBase TypeVarChar10NG=Gross, H=Gross - VAT, N=Net, V=VAT
10WTX1WTax Transactions - Rows15BaseTypeBase TypeVarChar10NG=Gross, H=Gross - VAT, 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, 60=Goods Issue
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
31IVL2Inventory Components for Production14BaseTypeBase Transaction TypeInt110-160=Goods Issue
32OAIMArchive 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
33OIGEGoods Issue408BaseTypeBase Document TypeInt110-1
34OIGNGoods Receipt408BaseTypeBase Document TypeInt110-1
35OILMInventory 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
36OIMTTemplates for Inventory JE3BaseTypeBase Transaction TypeInt60-1
37OITLInventory 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
38ORTLResource Transaction Log6BaseTypeBase Document TypeInt110
39OTNLCCD Log11BaseTypeBase Document TypeInt110
40OWTQInventory Transfer Request408BaseTypeBase Document TypeInt110-1
41OWTRInventory Transfer408BaseTypeBase Document TypeInt110-1
42SIVL2Inventory Components for Production14BaseTypeBase Transaction TypeInt110-160=Goods Issue
43UILMIVI 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
44UILM3Non-Inventory and Resource Components Log Msg11BaseTypeBase Transaction TypeInt110-160=Goods Issue
45UIVL2Inventory Components for Production14BaseTypeBase Transaction TypeInt110-160=Goods Issue
46WTQ1Inventory Transfer Request - Rows6BaseTypeBase Document TypeInt110-120=Purchase Delivery Notes, 59=Inventory General Entry, 67=Warehouse Transfers
47WTQ11Inv. Transfer Request - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
48WTQ13Inventory Transfer Request Rows - Distributed Freights41BaseTypeBase Document TypeInt110
49WTQ3Inventory Transfer Request - Freight41BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 59=Goods Receipt
50WTQ4Inventory Transfer Request - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
51WTQ5Inventory Transfer Request - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
52WTR1Inventory Transfer - Rows6BaseTypeBase Document TypeInt110-11250000001=Inventory Transfer Request, 20=Purchase Delivery Notes, 59=Inventory General Entry, 67=Warehouses Transfers
53WTR11Inv. Transfer - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
54WTR13Inventory Transfer Rows - Distributed Freights41BaseTypeBase Document TypeInt110
55WTR3Inventory Transfer - Freight41BaseTypeBase Document TypeInt110-11250000001=Inventory Transfer Request, 20=Goods Receipt PO, 59=Goods Receipt, 67=Inventory Transfer
56WTR4Inventory Transfer - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
57WTR5Inventory Transfer - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
TOPMarketing Documents
58ADO1A/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, 60=Goods Issue
59ADO11A/R Inv (Drawn Dpm Det) - Hist5BaseTypeBase Object TypeInt110-1
60ADO13A/R Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
61ADO20Intrastat 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
62ADO3A/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
63ADO4Documents - Tax - History25BaseTypeBase Document TypeInt110-1
64ADO5Withholding Tax - History18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
65ADOCInvoice - History408BaseTypeBase Document TypeInt110-167=Inventory Transfer
66CIN1Correction Invoice - Rows6BaseTypeBase Document TypeInt110-116=A/R Returns, 17=Sales Order, 23=Sales Quotation
67CIN13Correction Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
68CIN20Intrastat 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
69CIN3A/R Correction Invoice - Freight41BaseTypeBase Document TypeInt110-116=A/R Returns, 17=Sales Order, 23=Sales Quotation
70CIN4Correction Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
71CIN5AR Correction Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
72CPI1A/P Correction Invoice - Rows6BaseTypeBase Document TypeInt110-1163=A/P Correction Invoice, 18=A/P Invoice
73CPI11A/P Corr. Inv - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
74CPI13A/P Correction Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
75CPI20Intrastat 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
76CPI3A/P Correction Invoice - Freight41BaseTypeBase Document TypeInt110163=A/P Correction Invoice, 18=A/P Invoice
77CPI4A/P Correction Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
78CPI5Withholding Tax Data18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
79CPV1A/P Correction Invoice Reversal - Rows6BaseTypeBase Document TypeInt110-1163=A/P Correction Invoice
80CPV11A/P CrIn Rev - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
81CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
82CPV20Intrastat 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
83CPV3A/P Correction Invoice Reversal - Freight41BaseTypeBase Document TypeInt110163=A/P Correction Invoice
84CPV4A/P Correction Invoice Reversal - Tax Amt per Doc.25BaseTypeBase Document TypeInt110-1
85CPV5A/P Correction Invoice Reversal - WTax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
86CSI1A/R Correction Invoice - Rows6BaseTypeBase Document TypeInt110-113=A/R Invoice, 165=A/R Correction Invoice
87CSI11A/R Corr. Inv. - Drawn Dpm Det5BaseTypeBase Object TypeInt110-1
88CSI13A/R Correction Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
89CSI20Intrastat 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
90CSI3A/R Correction Invoice - Freight41BaseTypeBase Document TypeInt11013=A/R Invoice, 165=A/R Correction Invoice
91CSI4A/R Correction Invoice - Tax Amount Per Document25BaseTypeBase Document TypeInt110-1
92CSI5A/R Correction Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
93CSV1A/R Correction Invoice Reversal - Rows6BaseTypeBase Document TypeInt110-1165=A/R Correction Invoice
94CSV11A/R CrIn Rev - Drawn Dpm Det.5BaseTypeBase Object TypeInt110-1
95CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
96CSV20Intrastat 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
97CSV3A/R Correction Invoice Reversal - Freight41BaseTypeBase Document TypeInt110165=A/R Correction Invoice
98CSV4A/R Correction Invoice Reversal - Tax Amount Per Document25BaseTypeBase Document TypeInt110-1
99CSV5A/R Correction Invoice Reversal - WTax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
100DLN1Delivery - Rows6BaseTypeBase Document TypeInt110-113=A/R Invoice, 15=Delivery, 165=A/R Correction Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
101DLN11Delivery - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
102DLN13Delivery Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
103DLN20Intrastat 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
104DLN3Delivery Notes - Freight41BaseTypeBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 17=Sales Order, 23=Sales Quotation
105DLN4Delivery - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
106DLN5Delivery - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
107DOC20Intrastat 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
108DPI1A/R Down Payment - Rows6BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 203=A/R Down Payment, 23=Quotation
109DPI11A/R DP - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
110DPI13A/R Down Payment Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
111DPI20Intrastat 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
112DPI3A/R Down Payment - Freight41BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
113DPI4A/R Down Payment - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
114DPI5A/R Down Payment - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
115DPO1A/P Down Payment - Rows6BaseTypeBase Document TypeInt110-1204=A/P Down Payment, 20=Goods Receipt PO, 22=Purchase Order, 540000006=Purchase Quotation
116DPO11A/P DP - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
117DPO13A/P Down Payment Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
118DPO20Intrastat 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
119DPO3A/P Down Payment - Freight41BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
120DPO4A/P Down Payment - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
121DPO5A/P Down Payment - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
122DRF1Draft - 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
123DRF11Draft - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
124DRF13Draft Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
125DRF20Intrastat 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
126DRF3Draft - 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
127DRF4Draft Documents - Tax25BaseTypeBase Document TypeInt110-1
128DRF5Draft Documents - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
129GPA1Gross Profit Adjustment - Documents30BaseTypeBase TypenVarChar200
130IEI1Incoming 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
131IEI11IEI - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
132IEI13Incoming Excise Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
133IEI20Intrastat 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
134IEI3IEI - Freight41BaseTypeBase Document TypeInt110-1
135IEI4Incoming Excise Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
136IEI5Incoming Excise Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
137IGE20Intrastat 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
138IGN20Intrastat 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
139INV1A/R Invoice - Rows6BaseTypeBase Document TypeInt110-113=Invoice, 15=Delivery, 17=Sales Order, 23=Sales Quotation
140INV11A/R Invoice - Drawn Dpm Detail5BaseTypeBase Object TypeInt110203203=A/R Down Payment
141INV13A/R Invoice Rows - Distributed Freights41BaseTypeBase Document TypeInt110
142INV20Intrastat 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
143INV3A/R Invoice - Freight41BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
144INV4A/R Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
145INV5A/R Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
146OCINA/R Correction Invoice408BaseTypeBase Document TypeInt110-1
147OCPIA/P Correction Invoice408BaseTypeBase Document TypeInt110-1
148OCPVA/P Correction Invoice Reversal408BaseTypeBase Document TypeInt110-1
149OCSIA/R Correction Invoice408BaseTypeBase Document TypeInt110-1
150OCSVA/R Correction Invoice Reversal408BaseTypeBase Document TypeInt110-1
151ODLNDelivery408BaseTypeBase Document TypeInt110-1
152ODPIA/R Down Payment408BaseTypeBase Document TypeInt110-1
153ODPOA/P Down Payment408BaseTypeBase Document TypeInt110-1
154ODRFDrafts408BaseTypeBase Document TypeInt110-167=Inventory Transfer
155OEI1Outgoing 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
156OEI11OEI - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
157OEI13Outgoing Excise Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
158OEI20Intrastat 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
159OEI3OEI - Freight41BaseTypeBase Document TypeInt110-1
160OEI4Outgoing Excise Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
161OEI5Outgoing Excise Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
162OIEIIncoming Excise Invoice408BaseTypeBase Document TypeInt110-1
163OINVA/R Invoice408BaseTypeBase Document TypeInt110-167=Inventory Transfer
164OOEIOutgoing Excise Invoice408BaseTypeBase Document TypeInt110-1
165OPCHA/P Invoice408BaseTypeBase Document TypeInt110-167=Inventory Transfer
166OPDNGoods Receipt PO408BaseTypeBase Document TypeInt110-1
167OPORPurchase Order408BaseTypeBase Document TypeInt110-1
168OPQTPurchase Quotation408BaseTypeBase Document TypeInt110-1
169OPRQPurchase Request408BaseTypeBase Document TypeInt110-1
170OPRRGoods Return Request408BaseTypeBase Document TypeInt110-1
171OQUTSales Quotation408BaseTypeBase Document TypeInt110-1
172ORDNReturns408BaseTypeBase Document TypeInt110-1
173ORDRSales Order408BaseTypeBase Document TypeInt110-1
174ORINA/R Credit Memo408BaseTypeBase Document TypeInt110-1
175ORPCA/P Credit Memo408BaseTypeBase Document TypeInt110-1
176ORPDGoods Return408BaseTypeBase Document TypeInt110-1
177ORRRReturn Request408BaseTypeBase Document TypeInt110-1
178OSFCSelf Credit Memo408BaseTypeBase Document TypeInt110-167=Inventory Transfer
179OSFISelf Invoice408BaseTypeBase Document TypeInt110-167=Inventory Transfer
180PCH1A/P Invoice - Rows6BaseTypeBase Document TypeInt110-118=A/P Invoice, 20=Goods Receipt PO, 22=Purchase Orders, 540000006=Purchase Quotation, 69=Landed Costs
181PCH11A/P Invoice - Drawn Dpm Det.5BaseTypeBase Object TypeInt110204204=A/P Down Payment
182PCH13A/P Invoice Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
183PCH20Intrastat 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
184PCH3A/P Invoice - Freight41BaseTypeBase Document TypeInt110-120=Goods Receipt PO, 22=Purchase orders
185PCH4A/P Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
186PCH5A/P Invoice - Withholding Tax Data18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
187PDN1Goods 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
188PDN11GRPO - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
189PDN13Goods Receipt PO Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
190PDN20Intrastat 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
191PDN3Goods Receipt PO - Freight41BaseTypeBase Document TypeInt110-118=A/P Invoice, 21=Goods Return, 22=Purchase orders
192PDN4Goods Receipt PO - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
193PDN5Goods Reciept PO - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
194POR1Purchase Order - Rows6BaseTypeBase Document TypeInt110-11470000113=Purchase Request, 17=Sales Order, 22=Purchase Orders, 23=Sales Quotation, 540000006=Purchase Quotation
195POR11PO - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
196POR13Purchase Order Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
197POR20Intrastat 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
198POR3Purchase Order - Freight41BaseTypeBase Document TypeInt110-11470000113=Purchase Request, 17=Sales Order
199POR4Purchase Order - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
200POR5Purchase Order - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
201PQT1Purchase Quotation - Rows6BaseTypeBase Document TypeInt110-11470000113=Purchase Request, 17=Sales Order, 23=Sales Quotation
202PQT11PQ - Drawn DPM Detail5BaseTypeBase Object TypeInt110-1
203PQT13Purchase Quotation Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
204PQT20Intrastat 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
205PQT3Purchase Quotation - Freight41BaseTypeBase Document TypeInt110-117=Sales Order
206PQT4Purchase Quotation - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
207PQT5Purchase Quotation - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
208PRQ1Purchase Request - Rows6BaseTypeBase Document TypeInt110-117=Sales Order, 23=Sales Quotation
209PRQ11PR - Drawn DPM Detail5BaseTypeBase Object TypeInt110-1
210PRQ13Purchase Request Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
211PRQ20Intrastat 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
212PRQ3Purchase Request - Freight41BaseTypeBase Document TypeInt110-117=Sales Order
213PRQ4Purchase Request - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
214PRQ5Purchase Request - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
215PRR1A/P Return Request - Rows6BaseTypeBase Document TypeInt110-118=A/P Invoice, 20=Purchase Delivery Notes
216PRR11A/P Return Request - Drawn Dpm Detail5BaseTypeBase Object TypeInt110203203=A/R Down Payment
217PRR13A/P Return Request - Distributed Freights41BaseTypeBase Document TypeInt110
218PRR20Intrastat 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
219PRR3A/P Return Request - Freight41BaseTypeBase Document TypeInt110-118=A/P Invoice, 20=Goods Receipt PO
220PRR4A/P Return Request - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
221PRR5A/P Return Request - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
222QUT1Sales Quotation - Rows6BaseTypeBase Document TypeInt110-1
223QUT11Sls Quote - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
224QUT13Sales Quotation Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
225QUT20Intrastat 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
226QUT3Sales Quotation - Freight41BaseTypeBase Document TypeInt110-1
227QUT4Sales Quotation - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
228QUT5Sales Quotation - Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
229RDN1Returns - Rows6BaseTypeBase Document TypeInt110-115=A/R Delivery Note, 16=A/R Returns, 234000031=A/R Return Request
230RDN11Returns - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
231RDN13Returns Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
232RDN20Intrastat 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
233RDN3Return - Freight41BaseTypeBase Document TypeInt110-115=Delivery, 234000031=A/R Return Request
234RDN4Returns - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
235RDN5Returns - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
236RDR1Sales Order - Rows6BaseTypeBase Document TypeInt110-123=Sales Quotation
237RDR11Sls Ord. - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
238RDR13Sales Order Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
239RDR20Intrastat 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
240RDR3Sales Order - Freight41BaseTypeBase Document TypeInt110-123=Sales Quotation
241RDR4Sales Order - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
242RDR5Sales Order - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
243RIN1A/R Credit Memo - Rows6BaseTypeBase Document TypeInt110-113=A/R Invoice, 14=A/R Credit Note, 16=A/R Returns, 203=A/R Down Payment, 234000031=A/R Return Request
244RIN11A/R Cr. Memo - Drawn Dpm Det.5BaseTypeBase Object TypeInt110203203=A/R Down Payment
245RIN13A/R Credit Memo Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
246RIN20Intrastat 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
247RIN3A/R Credit Memo - Freight41BaseTypeBase Document TypeInt110-113=A/R Invoice, 16=A/R Returns, 203=A/R Down Payment, 234000031=A/R Return Request
248RIN4A/R Credit Memo - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
249RIN5A/R Credit Memo - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
250RPC1A/P Credit Memo - Rows6BaseTypeBase Document TypeInt110-118=A/P Invoice, 19=A/P Credit Memo, 204=A/P Down Payment, 21=Goods Return, 234000032=A/P Return Request
251RPC11A/P Cr. Memo - Drawn Dpm Det.5BaseTypeBase Object TypeInt110204204=A/P Down Payment
252RPC13A/P Credit Memo Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
253RPC20Intrastat 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
254RPC3A/P Credit Memo - Freight41BaseTypeBase Document TypeInt110-118=A/P Invoice, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 234000032=A/P Return Request
255RPC4A/P Credit Memo - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
256RPC5A/P Credit Memo - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
257RPD1Goods Return - Rows6BaseTypeBase Document TypeInt110-120=Purchase Delivery Notes, 21=Goods Return, 234000032=A/P Return Request
258RPD11Gds Return - Drawn Dpm Detail5BaseTypeBase Object TypeInt110-1
259RPD13Goods Returns Rows - Distributed Expenses41BaseTypeBase Document TypeInt110
260RPD20Intrastat 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
261RPD3Goods Return - Freight41BaseTypeBase Document TypeInt110-120=Purchase Delivery Notes, 234000032=A/P Return Request
262RPD4Goods Return - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
263RPD5Goods Return - Withholding Tax Data18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
264RRR1A/R Return Request - Rows6BaseTypeBase Document TypeInt110-113=Invoice, 15=Delivery
265RRR11A/R Return Request - Drawn Dpm Detail5BaseTypeBase Object TypeInt110203203=A/R Down Payment
266RRR13A/R Return Request - Distributed Freights41BaseTypeBase Document TypeInt110
267RRR20Intrastat 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
268RRR3A/R Return Request - Freight41BaseTypeBase Document TypeInt110-113=Invoice, 15=Delivery
269RRR4A/R Return Request - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
270RRR5A/R Return Request - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
271SFC1Self Credit Memo - Rows6BaseTypeBase Document TypeInt110-119=A/P Credit Memo, 254000066=Self Credit Memo
272SFC11Self Credit Memo - Drawn Down Payment Detail5BaseTypeBase Object TypeInt110-1
273SFC13Self Credit Memo Rows - Distributed Freights41BaseTypeBase Document TypeInt110
274SFC20Intrastat Expenses12BaseTypeBase Document TypeInt110-113=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
275SFC3Self Credit Memo - Freight41BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
276SFC4Self Credit Memo - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
277SFC5Self Credit Memo - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
278SFI1Self Invoice - Rows6BaseTypeBase Document TypeInt110-118=A/P Invoice, 19=A/P Credit Memo, 254000065=Self Invoice
279SFI11Self Invoice - Drawn Down Payment Detail5BaseTypeBase Object TypeInt110-1
280SFI13Self Invoice Rows - Distributed Freights41BaseTypeBase Document TypeInt110
281SFI20Intrastat 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
282SFI3Self Invoice - Freight41BaseTypeBase Document TypeInt110-115=Delivery, 17=Sales Order, 23=Sales Quotation
283SFI4Self Invoice - Tax Amount per Document25BaseTypeBase Document TypeInt110-1
284SFI5Self Invoice - Withholding Tax18BaseTypeBase TypeVarChar10G=Gross, N=Net, V=VAT
285WTQ20Intrastat 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
286WTR20Intrastat 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