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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
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
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

474 columns | Print definition?B1 8.8  | OBJTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1ADP1Object Settings - History2ObjTypeObject TypenVarChar200
2ALR1Queue of messages to be sent9ObjTypeObjectnVarChar200
3ALR3Dynamic message data cells5ObjTypeThe linked objectnVarChar200
4AOB1Sent Messages - User History2ObjTypeObjectnVarChar20012-1=Random, 12=User, 11=Contact Person
5AUSRArchive Users - History66objTypeObject TypenVarChar20012
6CUMIMy Menu Items7ObjTypeObject TypenVarChar200
7MLS1Distribution Lists - Recipients3ObjTypeObjectnVarChar200
8OUSRUsers66objTypeObject Type - HistorynVarChar20012
9UDG1User Defaults - Documents2ObjTypeObject TypenVarChar200
TOPBanking
10ACH1Checks for Payment - Rows - History14ObjTypeObject TypenVarChar200
11ACHOChecks for Payment - History43ObjTypeObject TypenVarChar20057
12ARC1Incoming Payment - Checks - History13ObjTypeObjTypenVarChar200
13ARC2Incoming Payment - Invoices - History16ObjTypeObject TypenVarChar200
14ARC3Credit Vouchers History25ObjTypeObject TypenVarChar200
15ARC4Incoming Payment - Account List - History11ObjTypeObject TypenVarChar20024
16ARC5Reciept log 4ObjTypeObject Type - HistorynVarChar200
17ARC6Incoming Payments - WTax Rows - History18ObjTypeObject TypenVarChar20024
18ARCTIncoming Payment - History56ObjTypeObject TypenVarChar200
19CHD1Checks for Payment Drafts - Rows14ObjTypeObject TypenVarChar200123
20CHO1Checks for Payment - Rows14ObjTypeObject TypenVarChar20057
21OCHDChecks for Payment Drafts43ObjTypeObject TypenVarChar200123
22OCHOChecks for Payment43ObjTypeObject TypenVarChar20057
23ODPSDeposit37ObjTypeObject TypenVarChar200
24ODPTPostdated Deposit22ObjTypeObject TypenVarChar200
25OPDFPayment Draft56ObjTypeObject TypenVarChar20024=Incoming Payment, 46=Outgoing Payments
26ORCTIncoming Payment56ObjTypeObject TypenVarChar2002424=Incoming Payment
27OVPMOutgoing Payments56ObjTypeObject TypenVarChar2004646=Outgoing Payments
28PDF1Payment Draft - Checks13ObjTypeObject TypenVarChar20024
29PDF2Payment Draft - Invoices16ObjTypeObject TypenVarChar200
30PDF3Payment Draft - Credit Vouchers25ObjTypeObject TypenVarChar200
31PDF4Payment Draft - Account List11ObjTypeObject TypenVarChar200
32PDF5PaymentDraft - 4ObjTypeObject TypenVarChar200
33PDF6Payment Drafts - Withholding Tax - Rows18ObjTypeObject TypenVarChar20024
34PEX1Payment Results Table - Rows11ObjTypeDocument Object TypenVarChar200
35PMN5Payment - VAT Adjustment4ObjTypeObject TypenVarChar20024
36PWZ3Payment Wizard - Rows 333ObjTypeObject TypenVarChar20013
37PWZ4Payment Wizard - Rows 49ObjTypeObject TypenVarChar20024=Incoming Payment, 46=Outgoing Payment
38RCC4Incoming Payment - Credit Vouchers11ObjTypeNumber of PaymentsnVarChar2001
39RCT1Incoming Payment - Checks13ObjTypeObject TypenVarChar20024
40RCT2Incoming Payments - Invoices16ObjTypeObject TypenVarChar20024
41RCT3Incoming Pmt - Credit Vouchers25ObjTypeObject TypenVarChar20024
42RCT4Incoming Payment - Account List11ObjTypeObject TypenVarChar20024
43RCT5Reciept vat adjustment4ObjTypeObject TypenVarChar20024
44RCT6Incoming Payments - WTax Rows18ObjTypeObject TypenVarChar20024
45VPM1Outgoing Payments - Check Rows13ObjTypeObject TypenVarChar20046
46VPM2Outgoing Payments - Invoices16ObjTypeObject TypenVarChar20046
47VPM3Outgoing Payments - Credit Vouchers25ObjTypeObject TypenVarChar20046
48VPM4Outgoing Payments - Accounts11ObjTypeObject TypenVarChar20046
49VPM5Outgoing Payments - Vat Adjustment4ObjTypeObject TypenVarChar20046
50VPM6Outgoing Payments - WTax 18ObjTypeObject TypenVarChar20046
TOPBusiness Partners
51ACPRContact Persons - History18ObjTypeObject TypenVarChar200
52ACR1Business Partner Addresses - History12ObjTypeObject TypenVarChar2002
53ACR2Bussiness Partners - Payment Methods-History5ObjTypeObject TypeInt602
54ACR3Business Partner Control Accounts - History5ObjTypeObject TypeInt602
55ACRDBusiness Partners - History170ObjTypeObject TypenVarChar2002
56CRD1Business Partners - Addresses12ObjTypeObject TypenVarChar2002
57CRD2Bussiness Partners - Payment Methods5ObjTypeObject TypeInt602
58CRD3BP Control Account5ObjTypeObject TypeInt602
59OCPRContact Persons18ObjTypeObject TypenVarChar20011
60OCRDBusiness Partner170ObjTypeObject TypenVarChar2002
TOPFinance
61AACTG/L Account - History52ObjTypeObject TypenVarChar200
62AJD1Journal Entry - History - Rows47ObjTypeObject TypenVarChar20030
63AJDTJournal Entry - History31ObjTypeObject TypenVarChar200
64BTF1Journal Voucher 47ObjTypeObject TypenVarChar20030
65JDT1Journal Entry - Rows47ObjTypeObject TypenVarChar20030
66OACTG/L Accounts52ObjTypeObject TypenVarChar2001
67OBTFJournal Voucher Entry31ObjTypeObject TypenVarChar20030
68OJDTJournal Entry31ObjTypeObject TypenVarChar20030
TOPInventory and Production
69AIT1Item - Prices - History8ObjTypeObjectnVarChar200
70AITMItems - History199ObjTypeObject TypenVarChar200
71AMR1Inventory Revaluation - History - Rows15ObjTypeObject TypenVarChar200162
72AMR2Inventory Revaluation FIFO Rows (Archive)16ObjTypeObject TypenVarChar200162
73AMRVInventory Revaluation - History22ObjTypeObject TypenVarChar200162
74APKLPick List - History12ObjTypeObject TypenVarChar200156
75AWHSWarehouses - History54objTypeObject Type - HistorynVarChar20064
76IGE1Goods Issue - Rows79ObjTypeObject TypenVarChar20060
77IGE10Goods Issue - Row Structure8ObjTypeObject TypenVarChar20060
78IGE11Goods Issue - Drawn Dpm Detail14ObjTypeObject TypenVarChar20060
79IGE2Goods Issue - Freight - Rows11ObjTypeObject TypenVarChar20060
80IGE3Goods Issue - Freight10ObjTypeObject TypenVarChar20060
81IGE5Goods Issue - Withholding Tax28ObjTypeObject TypenVarChar20060
82IGE6Goods Issue - Installments3ObjTypeObject TypenVarChar20060
83IGE7Delivery Packages - Goods Issue6ObjTypeObject TypenVarChar20060
84IGE8Items in Package - Goods Issue6ObjTypeObject TypenVarChar20060
85IGE9Goods Issue - Drawn Dpm6ObjTypeBase Object TypenVarChar200
86IGN1Goods Receipt - Rows79ObjTypeObject TypenVarChar20059
87IGN10Goods Receipt - Row Structure8ObjTypeObject TypenVarChar20059
88IGN11Goods Receipt - Drawn Dpm Det14ObjTypeObject TypenVarChar20059
89IGN2Goods Receipt - Freight - Rows11ObjTypeObject TypenVarChar20059
90IGN3Goods Receipt - Freight10ObjTypeObject TypenVarChar20059
91IGN5Goods Receipt - Withholding Tax28ObjTypeObject TypenVarChar20059
92IGN6Goods Receipt- Installments3ObjTypeObject TypenVarChar20059
93IGN7Goods Receipt - Delivery Packages6ObjTypeObject TypenVarChar20059
94IGN8Goods Receipt - Items in Package6ObjTypeObject TypenVarChar20059
95IGN9Goods Receipt - Drawn Dpm6ObjTypeBase Object TypenVarChar200
96IQI1Inventory Initial Qty Rows22ObjTypeObject TypenVarChar200310000001
97IQR1Inventory Stock Posting (Reconcile) Lines22ObjTypeObject TypenVarChar20010000071
98ITM1Items - Prices8ObjTypeObjectnVarChar2004
99MRV1Inventory Revaluation Information Array15ObjTypeObject TypenVarChar200162
100MRV2Inventory Revaluation FIFO Rows16ObjTypeObject TypenVarChar200162
101OBTNBatch Numbers Master Data20ObjTypeobject typenVarChar200
102OBTWBatch Attributes in Location11ObjTypeObject TypenVarChar200
103ODBNBat. Nos - Draft - Master Data20ObjTypeobject typenVarChar200
104ODBWBatch Draft Attribs in Locat.11ObjTypeObject TypenVarChar200
105ODSNSNs - Draft - Master Data20ObjTypeobject typenVarChar200
106ODSWSN Draft Attribs in Location11ObjTypeObject TypenVarChar200
107OENTShipping Types5ObjTypeObject TypenVarChar200
108OIGEGoods Issue10ObjTypeObject TypenVarChar2006060=Goods Issue
109OIGNGoods Receipt10ObjTypeObject TypenVarChar2005959=Goods Receipt
110OIPFLanded Costs48ObjTypeObject TypenVarChar20069
111OIQIInventory Initial Quantity15ObjTypeObject TypenVarChar200310000001
112OIQRInventory Stock Posting (Reconcile)15ObjTypeObject TypenVarChar20010000071
113OITMItems199ObjTypeObject TypenVarChar2004
114OMRVInventory Revaluation22ObjTypeObject TypenVarChar200162
115OPKLPick List12ObjTypeObject TypenVarChar200156
116OSPGSpecial Prices for Groups2ObjTypeObject TypenVarChar20052=Item Group, 8=Item Properties, 43=Companies
117OSRNSerial Numbers Master Data20ObjTypeobject typenVarChar200
118OSRWSerial No. Attribs in Location11ObjTypeObject TypenVarChar200
119OWHSWarehouses54objTypeObject Type - HistorynVarChar20064
120OWKOProduction Instructions27ObjTypeObject TypenVarChar20068
121OWTRInventory Transfer10ObjTypeObject TypenVarChar2006767=Inventory Transfer
122UITMItems199ObjTypeObject TypenVarChar2004
123UWKOProduction Instructions27ObjTypeObject TypenVarChar20068
124WTR1Inventory Transfer - Rows79ObjTypeObject TypenVarChar20067
125WTR10Inventory Transfer - Row Structure8ObjTypeObject TypenVarChar20067
126WTR11Inv. Transfer - Drawn Dpm Det.14ObjTypeObject TypenVarChar20067
127WTR2Inventory Transfer - Freight - Rows11ObjTypeObject TypenVarChar20067
128WTR3Inventory Transfer - Freight10ObjTypeObject TypenVarChar20067
129WTR5Inventory Transfer - Withholding Tax28ObjTypeObject TypenVarChar20067
130WTR6Inventory Transfer - Installments3ObjTypeObject TypenVarChar20067
131WTR7Inventory Transfer - Delivery Packages6ObjTypeObject TypenVarChar20067
132WTR8Inventory Transfer - Items in Package6ObjTypeObject TypenVarChar20067
133WTR9Inventory Transfer - Drawn Dpm6ObjTypeBase Object TypenVarChar200
TOPMarketing Documents
134ADO1A/R Invoice (Rows) - History79ObjTypeObject TypenVarChar200
135ADO10A/R Invoice - Row Structure - History8ObjTypeObject TypenVarChar20023
136ADO11A/R Inv (Drawn Dpm Det) - Hist14ObjTypeObject TypenVarChar20013
137ADO13A/R Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200
138ADO15A/R Inv (Drawn Dpm Applied) - Hist3ObjTypeobject typenVarChar20013
139ADO16Draft - SnB properties11ObjTypeObject TypenVarChar200
140ADO2A/R Invoice - Freight - Rows11ObjTypeObject TypenVarChar200
141ADO3A/R Invoice - Freight - History10ObjTypeObject TypenVarChar200
142ADO5Withholding Tax - History28ObjTypeObject TypenVarChar200
143ADO6Documents History - Installments3ObjTypeObject TypenVarChar200
144ADO7Delivery Packages - History6ObjTypeObject TypenVarChar200
145ADO8Items in Package - History6ObjTypeObject TypenVarChar200
146ADO9A/R Invoice (Rows) - History6ObjTypeBase Object TypenVarChar200
147ADOCInvoice - History10ObjTypeObject TypenVarChar200
148AJD2Withholding Tax - History28ObjTypeObject TypenVarChar20030
149ATX1Tax Invoice - History - Rows7ObjTypeObject TypeInt60
150ATXITax Invoice - History8ObjTypeObject TypenVarChar200194
151BTF2Journal Voucher Withholding Tax - History28ObjTypeObject TypenVarChar20030
152CIN1Correction Invoice - Rows79ObjTypeObject TypenVarChar200132
153CIN10Correction Invoice - Row Structure8ObjTypeObject TypenVarChar200132
154CIN13Correction Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200132
155CIN2A/R Correction Invoice - Freight - Rows11ObjTypeObject TypenVarChar200132
156CIN3A/R Correction Invoice - Freight10ObjTypeObject TypenVarChar200132
157CIN5AR Correction Invoice - Withholding Tax28ObjTypeObject TypenVarChar200132
158CIN6Correction Invoice - Installments3ObjTypeObject TypenVarChar200132
159CIN7Delivery Packages - Correction Invoice6ObjTypeObject TypenVarChar200132
160CIN8Items in Package - Correction Invoice6ObjTypeObject TypenVarChar200132
161CIN9Correction Invoice - Drawn Dpm6ObjTypeBase Object TypenVarChar200
162CPI1A/P Correction Invoice - Rows79ObjTypeObject TypenVarChar200163
163CPI10A/P Correction Invoice - Row Structure8ObjTypeObject TypenVarChar200163
164CPI11A/P Corr. Inv - Drawn Dpm Det.14ObjTypeObject TypenVarChar200163
165CPI13A/P Correction Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200163
166CPI15A/P Corr Inv - Drawn Dpm Appld3ObjTypeobject typenVarChar200163
167CPI16A/P Corr. Inv - SnB properties11ObjTypeObject TypenVarChar200163
168CPI2A/P Correction Invoice - Freight - Rows11ObjTypeObject TypenVarChar200163
169CPI3A/P Correction Invoice - Freight10ObjTypeObject TypenVarChar200163
170CPI5Withholding Tax Data28ObjTypeObject TypenVarChar200163
171CPI6Documents History - Installments3ObjTypeObject TypenVarChar200163
172CPI7A/P Correction Invoice - Delivery Packages6ObjTypeObject TypenVarChar200163
173CPI8A/P Correction Invoice - Items in Package6ObjTypeObject TypenVarChar200163
174CPI9A/P Corr. Invoice - Drawn Dpm6ObjTypeBase Object TypenVarChar200
175CPV1A/P Correction Invoice Reversal - Rows79ObjTypeObject TypenVarChar200164
176CPV10A/P CrIn Rev - Row Structure8ObjTypeObject TypenVarChar200164
177CPV11A/P CrIn Rev - Drawn Dpm Det.14ObjTypeObject TypenVarChar200164
178CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses11ObjTypeObject TypenVarChar200164
179CPV15A/P CrIn Rev - Drawn Dpm Appld3ObjTypeobject typenVarChar200164
180CPV16A/P Correction Invoice Reversal - SnB properties11ObjTypeObject TypenVarChar200164
181CPV2A/P Correction Invoice Reversal - Freight - Rows11ObjTypeObject TypenVarChar200164
182CPV3A/P Correction Invoice Reversal - Freight10ObjTypeObject TypenVarChar200164
183CPV5A/P Correction Invoice Reversal - WTax28ObjTypeObject TypenVarChar200164
184CPV6A/P Correction Invoice Reversal - Installments3ObjTypeObject TypenVarChar200164
185CPV7A/P Corr Inv Rvsl - Deliv Pkgs6ObjTypeObject TypenVarChar20013
186CPV8A/P Correction Invoice Reversal - Items in Package6ObjTypeObject TypenVarChar200164
187CPV9A/P Corr Inv Rvrsl - Drawn Dpm6ObjTypeBase Object TypenVarChar200
188CSI1A/R Correction Invoice - Rows79ObjTypeObject TypenVarChar200165
189CSI10A/R Correction Invoice - Row Structure8ObjTypeObject TypenVarChar200165
190CSI11A/R Corr. Inv. - Drawn Dpm Det14ObjTypeObject TypenVarChar200165
191CSI13A/R Correction Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200165
192CSI15A/R Corr Inv - Drawn Dpm Appld3ObjTypeobject typenVarChar200165
193CSI16A/R Corr. Inv. - SnB properties11ObjTypeObject TypenVarChar200165
194CSI2A/R Corr Inv - Freight - Rows11ObjTypeObject TypenVarChar200165
195CSI3A/R Correction Invoice - Freight10ObjTypeObject TypenVarChar200165
196CSI5A/R Correction Invoice - Withholding Tax28ObjTypeObject TypenVarChar200165
197CSI6A/R Corr. Inv. - Installments3ObjTypeObject TypenVarChar200165
198CSI7A/R Corr. Inv. Deliv. Pkgs6ObjTypeObject TypenVarChar200165
199CSI8A/R Corr. Inv. - Items in Pkg6ObjTypeObject TypenVarChar200165
200CSI9A/R Corr. Inv. - Drawn Dpm6ObjTypeBase Object TypenVarChar200203
201CSV1A/R Correction Invoice Reversal - Rows79ObjTypeObject TypenVarChar200166
202CSV10A/R Correction Invoice Reversal - Row Structure8ObjTypeObject TypenVarChar200166
203CSV11A/R CrIn Rev - Drawn Dpm Det.14ObjTypeObject TypenVarChar200166
204CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses11ObjTypeObject TypenVarChar200166
205CSV15A/R CrIn Rev - Drawn Dpm Appld3ObjTypeobject typenVarChar200166
206CSV16A/R Correction Invoice Reversal - SnB properties11ObjTypeObject TypenVarChar200166
207CSV2A/R Correction Invoice Reversal - Freight - Rows11ObjTypeObject TypenVarChar200166
208CSV3A/R Correction Invoice Reversal - Freight10ObjTypeObject TypenVarChar200166
209CSV5A/R Correction Invoice Reversal - WTax28ObjTypeObject TypenVarChar200166
210CSV6A/R Correction Invoice Reversal - Installments3ObjTypeObject TypenVarChar200166
211CSV7A/R Correction Invoice Reversal - Delivery Packages6ObjTypeObject TypenVarChar200166
212CSV8A/R Correction Invoice Reversal - Items in Package6ObjTypeObject TypenVarChar200166
213CSV9A/R CrIn Rev - Drawn Dpm6ObjTypeBase Object TypenVarChar200
214DLN1Delivery - Rows79ObjTypeObject TypenVarChar20015
215DLN10Delivery - Row Structure8ObjTypeObject TypenVarChar20015
216DLN11Delivery - Drawn Dpm Detail14ObjTypeObject TypenVarChar20015
217DLN13Delivery Rows - Distributed Expenses11ObjTypeObject TypenVarChar20015
218DLN15Delivery - Drawn Dpm Applied3ObjTypeobject typenVarChar20015
219DLN16Delivery - SnB properties11ObjTypeObject TypenVarChar20015
220DLN2Delivery Notes - Freight - Rows11ObjTypeObject TypenVarChar20015
221DLN3Delivery Notes - Freight10ObjTypeObject TypenVarChar20015
222DLN5Delivery - Withholding Tax28ObjTypeObject TypenVarChar20015
223DLN6Delivery - Installments3ObjTypeObject TypenVarChar20015
224DLN7Delivery Packages6ObjTypeObject TypenVarChar20015
225DLN8Items in Package - Delivery6ObjTypeObject TypenVarChar20015
226DLN9Delivery - Drawn Dpm6ObjTypeBase Object TypenVarChar200
227DPI1A/R Down Payment - Rows79ObjTypeObject TypenVarChar200203
228DPI10A/R Down Payment - Row Structure8ObjTypeObject TypenVarChar200203
229DPI11A/R DP - Drawn Dpm Detail14ObjTypeObject TypenVarChar200203
230DPI13A/R Down Payment Rows - Distributed Expenses11ObjTypeObject TypenVarChar200202
231DPI15A/R DP - Drawn Dpm Applied3ObjTypeobject typenVarChar200203
232DPI16A/R Down Payment - SnB properties11ObjTypeObject TypenVarChar200203
233DPI2A/R Down Payment - Freight - Rows11ObjTypeObject TypenVarChar200203
234DPI3A/R Down Payment - Freight10ObjTypeObject TypenVarChar200202
235DPI5A/R Down Payment - Withholding Tax28ObjTypeObject TypenVarChar200203
236DPI6A/R Down Payment - Installments3ObjTypeObject TypenVarChar200203
237DPI7Delivery Packages - A/R Down Pymt6ObjTypeObject TypenVarChar200203
238DPI8Items in Package - A/R Down Pmt.6ObjTypeObject TypenVarChar200203
239DPI9Down Payment Incoming - Drawn Dpm6ObjTypeBase Object TypenVarChar200
240DPO1A/P Down Payment - Rows79ObjTypeObject TypenVarChar200204
241DPO10A/P Down Payment - Row Structure8ObjTypeObject TypenVarChar200204
242DPO11A/P DP - Drawn Dpm Detail14ObjTypeObject TypenVarChar200204
243DPO13A/P Down Payment Rows - Distributed Expenses11ObjTypeObject TypenVarChar200204
244DPO15A/P DP - Drawn Dpm Applied3ObjTypeobject typenVarChar200204
245DPO16A/P Down Payment - SnB properties11ObjTypeObject TypenVarChar200204
246DPO2A/P Down Payment - Freight - Rows11ObjTypeObject TypenVarChar200204
247DPO3A/P Down Payment - Freight10ObjTypeObject TypenVarChar200204
248DPO5A/P Down Payment - Withholding Tax28ObjTypeObject TypenVarChar200204
249DPO6Down Payment Out - Installments3ObjTypeObject TypenVarChar200204
250DPO7Delivery Packages - A/P Down Pymt6ObjTypeObject TypenVarChar200204
251DPO8Items in Package - A/P Down Pmt.6ObjTypeObject TypenVarChar200204
252DPO9Down Payment Outgoing - Drawn Dpm6ObjTypeBase Object TypenVarChar200
253DRF1Draft - Rows79ObjTypeObject TypenVarChar200112
254DRF10Draft - Row Structure8ObjTypeObject TypenVarChar200112
255DRF11Draft - Drawn Dpm Detail14ObjTypeObject TypenVarChar200112
256DRF13Draft Rows - Distributed Expenses11ObjTypeObject TypenVarChar200112
257DRF15Draft - Drawn Dpm Applied3ObjTypeObject TypenVarChar200112
258DRF16Draft - SnB - Rows11ObjTypeObject TypenVarChar200
259DRF2Draft - Freight - Rows11ObjTypeObject TypenVarChar200112
260DRF3Draft - Freight10ObjTypeObject TypenVarChar200112
261DRF5Draft Documents - Withholding Tax28ObjTypeObject TypenVarChar200112
262DRF6Document Drafts - Installments3ObjTypeObject TypenVarChar200112
263DRF7Delivery Packages - Drafts6ObjTypeObject TypenVarChar200112
264DRF8Items in Package - Draft6ObjTypeObject TypenVarChar200112
265DRF9Document Draft - Drawn Dpm6ObjTypeBase Object TypenVarChar200
266IEI1Incoming Excise Invoice - Rows79ObjTypeObject TypenVarChar200140000010
267IEI10Incoming Excise Invoice - Row Structure8ObjTypeObject TypenVarChar200140000010
268IEI11IEI - Drawn Dpm Detail14ObjTypeObject TypenVarChar200140000010
269IEI13Incoming Excise Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200140000010
270IEI15IEI - Drawn Dpm Applied3ObjTypeobject typenVarChar200140000010
271IEI16Incoming Excise Invoice - SnB properties11ObjTypeObject TypenVarChar200140000010
272IEI2Incoming Excise Invoice - Freight - History - Rows11ObjTypeObject TypenVarChar200140000010
273IEI3IEI - Freight10ObjTypeObject TypenVarChar200140000010
274IEI5Incoming Excise Invoice - Withholding Tax28ObjTypeObject TypenVarChar200140000010
275IEI6IEI - Installments3ObjTypeObject TypenVarChar200140000010
276IEI7Delivery Packages - Incoming Excise Invoice6ObjTypeObject TypenVarChar200140000010
277IEI8Incoming Excise Invoice - Items in Package6ObjTypeObject TypenVarChar200140000010
278IEI9IEI - Drawn Dpm6ObjTypeBase Object TypenVarChar200203
279IGE13Goods Issue Rows - Distributed Expenses11ObjTypeObject TypenVarChar20060
280IGE15Gds Issue - Drawn Dpm Applied3ObjTypeobject typenVarChar20060
281IGE16Goods Issue - SnB properties11ObjTypeObject TypenVarChar20060
282IGN13Goods Receipt Rows - Distributed Expenses11ObjTypeObject TypenVarChar20059
283IGN15Gds Rcpt - Drawn Dpm Applied3ObjTypeobject typenVarChar20059
284IGN16Goods Receipt - SnB properties11ObjTypeObject TypenVarChar20059
285INV1A/R Invoice - Rows79ObjTypeObject TypenVarChar20013
286INV10A/R Invoice - Row Structure8ObjTypeObject TypenVarChar20013
287INV11A/R Invoice - Drawn Dpm Detail14ObjTypeObject TypenVarChar20013
288INV13A/R Invoice Rows - Distributed Freights11ObjTypeObject TypenVarChar20013
289INV15A/R Inv. - Drawn Dpm Applied3ObjTypeobject typenVarChar20013
290INV16A/R Invoice - SnB properties11ObjTypeObject TypenVarChar20013
291INV2A/R Invoice - Freight - Rows11ObjTypeObject TypenVarChar20013
292INV3A/R Invoice - Freight10ObjTypeObject TypenVarChar20013
293INV5A/R Invoice - Withholding Tax28ObjTypeObject TypenVarChar20013
294INV6A/R Invoice - Installments3ObjTypeObject TypenVarChar20013
295INV7A/R Invoice - Delivery Packages6ObjTypeObject TypenVarChar20013
296INV8A/R Invoice - Items in Package6ObjTypeObject TypenVarChar20013
297INV9A/R Invoice - Drawn Dpm6ObjTypeBase Object TypenVarChar200203203=A/R Down Payment
298JDT2Withholding Tax - History28ObjTypeObject TypenVarChar20030
299OCINA/R Correction Invoice10ObjTypeObject TypenVarChar200132132=Correction Invoice
300OCPIA/P Correction Invoice10ObjTypeObject TypenVarChar200163163=A/P Correction Invoice
301OCPVA/P Correction Invoice Reversal10ObjTypeObject TypenVarChar200164164=A/P Correction Invoice Reversal
302OCSIA/R Correction Invoice10ObjTypeObject TypenVarChar200165165=A/R Correction Invoice
303OCSVA/R Correction Invoice Reversal10ObjTypeObject TypenVarChar200166166=A/R Correction Invoice Reversal
304ODLNDelivery10ObjTypeObject TypenVarChar2001515=Delivery
305ODPIA/R Down Payment10ObjTypeObject TypenVarChar200203203=A/R Down Payment
306ODPOA/P Down Payment10ObjTypeObject TypenVarChar200204204=A/P Down Payment
307ODRFDrafts10ObjTypeObject TypenVarChar20015=Delivery, 16=Returns, 203=A/R Down Payment, 13=A/R Invoice, 14=A/R Credit Memo, 132=Correction Invoice, 20=Goods Receipt, 21=Goods Return, 204=A/P Down Payment, 18=A/P Invoice, 19=A/P Credit Memo, 17=Sales Order, 22=Purchase Order, 23=Sales Quotation, 67=Inventory Transfers, 59=Goods Receipt, 60=Goods Issue, 163=A/P Correction Invoice,
308OEI1Outgoing Excise Invoice - Rows79ObjTypeObject TypenVarChar200140000009
309OEI10Outgoing Excise Invoice - Row Structure8ObjTypeObject TypenVarChar200140000009
310OEI11OEI - Drawn Dpm Detail14ObjTypeObject TypenVarChar200140000009
311OEI13Outgoing Excise Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200140000009
312OEI15OEI - Drawn Dpm Applied3ObjTypeobject typenVarChar200140000009
313OEI16Outgoing Excise Invoice - SnB properties11ObjTypeObject TypenVarChar200140000009
314OEI2OEI - Freight Rows11ObjTypeObject TypenVarChar200140000009
315OEI3OEI - Freight10ObjTypeObject TypenVarChar200140000009
316OEI5Outgoing Excise Invoice - Withholding Tax28ObjTypeObject TypenVarChar200140000009
317OEI6Outgoing Excise Invoice - Installments3ObjTypeObject TypenVarChar200140000000
318OEI7Delivery Packages - Outgoing Excise Invoice6ObjTypeObject TypenVarChar200140000009
319OEI8Outgoing Excise Invoice - Items in Package6ObjTypeObject TypenVarChar200140000009
320OEI9OEI - Drawn Dpm6ObjTypeBase Object TypenVarChar200203
321OIEIIncoming Excise Invoice10ObjTypeObject TypenVarChar200140000010140000010=Incoming Excise Invoice
322OINVA/R Invoice10ObjTypeObject TypenVarChar2001313=A/R Invoice
323OOEIOutgoing Excise Invoice10ObjTypeObject TypenVarChar200140000009140000009=Outgoing Excise Invoice
324OPCHA/P Invoice10ObjTypeObject TypenVarChar2001818=A/P Invoice
325OPDNGoods Receipt PO10ObjTypeObject TypenVarChar2002020=Goods Receipt PO
326OPORPurchase Order10ObjTypeObject TypenVarChar2002222=Purchase Order
327OQUTSales Quotation10ObjTypeObject TypenVarChar2002323=Sales Quotation
328ORDNReturns10ObjTypeObject TypenVarChar2001616=Returns
329ORDRSales Order10ObjTypeObject TypenVarChar2001717=Sales Order
330ORINA/R Credit Memo10ObjTypeObject TypenVarChar2001414=A/R Credit Memo
331ORPCA/P Credit Memo10ObjTypeObject TypenVarChar2001919=A/P Credit Memo
332ORPDGoods Return10ObjTypeObject TypenVarChar2002121=Goods Return
333OSALOutgoing5ObjTypeObject TypenVarChar200
334OTPIPurchase Tax Invoice8ObjTypeObject TypenVarChar200194
335OTRATransition5ObjTypeObject TypenVarChar200
336OTSISales Tax Invoice8ObjTypeObject TypenVarChar200194
337OTXDTax Invoice Draft8ObjTypeObject TypenVarChar200194
338OWDDDocs. for Confirmation5ObjTypeObject TypenVarChar20023=Sales Quotation, 17=Sales Order, 15=Delivery, 16=Return, 203=A/R Down Payment, 13=A/R Invoice, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 14=A/R Credit Memo, 132=Correction Invoice, (-=(-, 22=Purchase Order, 20=Goods Receipt PO, 21=Goods Returns, 204=A/P Down Payment, 18=A/P Invoice, 163=A/P Correction Invoice, 164
339PCH1A/P Invoice - Rows79ObjTypeObject TypenVarChar20018
340PCH10A/P Invoice - Row Structure8ObjTypeObject TypenVarChar20018
341PCH11A/P Invoice - Drawn Dpm Det.14ObjTypeObject TypenVarChar20018
342PCH13A/P Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar20018
343PCH15A/P Invoice - Drawn Dpm Appld3ObjTypeobject typenVarChar20018
344PCH16A/P Invoice - SnB properties11ObjTypeObject TypenVarChar20018
345PCH2A/P Invoice - Freight - Rows11ObjTypeObject TypenVarChar20018
346PCH3A/P Invoice - Freight10ObjTypeObject TypenVarChar20018
347PCH5A/P Invoice - Withholding Tax Data28ObjTypeObject TypenVarChar20018
348PCH6A/P Invoice - Installments3ObjTypeObject TypenVarChar20018
349PCH7Delivery Packages - A/P Invoice6ObjTypeObject TypenVarChar20018
350PCH8A/P Invoice - Items in Package6ObjTypeObject TypenVarChar20018
351PCH9A/P Invoice - Drawn Dpm6ObjTypeBase Object TypenVarChar200204204=A/P Down Payment
352PDN1Goods Receipt PO - Rows79ObjTypeObject TypenVarChar20020
353PDN10Goods Receipt PO - Row Structure8ObjTypeObject TypenVarChar20020
354PDN11GRPO - Drawn Dpm Detail14ObjTypeObject TypenVarChar20020
355PDN13Goods Receipt PO Rows - Distributed Expenses11ObjTypeObject TypenVarChar20020
356PDN15GRPO - Drawn Dpm Applied3ObjTypeobject typenVarChar20020
357PDN16Goods Receipt PO - SnB properties11ObjTypeObject TypenVarChar20020
358PDN2Goods Receipt PO - Freight - Rows11ObjTypeObject TypenVarChar20020
359PDN3Goods Receipt PO - Freight10ObjTypeObject TypenVarChar20020
360PDN5Goods Reciept PO - Withholding Tax28ObjTypeObject TypenVarChar20020
361PDN6Goods Receipt PO - Installments3ObjTypeObject TypenVarChar20020
362PDN7Goods Receipt PO - Delivery Packages6ObjTypeObject TypenVarChar20020
363PDN8Goods Receipt PO - Items in Package6ObjTypeObject TypenVarChar20020
364PDN9Goods Receipt PO - Drawn Dpm6ObjTypeBase Object TypenVarChar200
365POR1Purchase Order - Rows79ObjTypeObject TypenVarChar20022
366POR10Purchase Order - Row structure8ObjTypeObject TypenVarChar20022
367POR11PO - Drawn Dpm Detail14ObjTypeObject TypenVarChar20022
368POR13Purchase Order Rows - Distributed Expenses11ObjTypeObject TypenVarChar20022
369POR15PO - Drawn Dpm Applied3ObjTypeobject typenVarChar20022
370POR16Purchase Order - SnB properties11ObjTypeObject TypenVarChar20022
371POR2Purchase Order - Freight - Rows11ObjTypeObject TypenVarChar20022
372POR3Purchase Order - Freight10ObjTypeObject TypenVarChar20022
373POR5Purchase Order - Withholding Tax28ObjTypeObject TypenVarChar20022
374POR6Purchase Order - Installments3ObjTypeObject TypenVarChar20022
375POR7Delivery Packages - Purchase Order6ObjTypeObject TypenVarChar20022
376POR8Items in Package - Purchase Order6ObjTypeObject TypenVarChar20022
377POR9Purchase Order - Drawn Dpm6ObjTypeBase Object TypenVarChar200
378QUT1Sales Quotation - Rows79ObjTypeObject TypenVarChar20023
379QUT10Sales Quotation - Row Structure8ObjTypeObject TypenVarChar20023
380QUT11Sls Quote - Drawn Dpm Detail14ObjTypeObject TypenVarChar20023
381QUT13Sales Quotation Rows - Distributed Expenses11ObjTypeObject TypenVarChar20023
382QUT15Sls Quote - Drawn Dpm Applied3ObjTypeobject typenVarChar20023
383QUT16Sales Quotation - SnB properties11ObjTypeObject TypenVarChar20023
384QUT2Sales Quotation - Freight - Rows11ObjTypeObject TypenVarChar20023
385QUT3Sales Quotation - Freight10ObjTypeObject TypenVarChar20023
386QUT5Sales Quotation - Tax28ObjTypeObject TypenVarChar20023
387QUT6Sales Quotation - Installments3ObjTypeObject TypenVarChar20023
388QUT7Delivery Packages - Sales Quotation6ObjTypeObject TypenVarChar20023
389QUT8Sales Quotation - Items in Package6ObjTypeObject TypenVarChar20023
390QUT9Sales Quotation - Drawn Dpm6ObjTypeBase Object TypenVarChar200
391RDN1Returns - Rows79ObjTypeObject TypenVarChar20016
392RDN10Returns - Row Structure8ObjTypeObject TypenVarChar20016
393RDN11Returns - Drawn Dpm Detail14ObjTypeObject TypenVarChar20016
394RDN13Returns Rows - Distributed Expenses11ObjTypeObject TypenVarChar20016
395RDN15Returns - Drawn Dpm Applied3ObjTypeobject typenVarChar20016
396RDN16Returns - SnB properties11ObjTypeObject TypenVarChar20016
397RDN2Return - Freight - Rows11ObjTypeObject TypenVarChar20016
398RDN3Return - Freight10ObjTypeObject TypenVarChar20016
399RDN5Returns - Withholding Tax28ObjTypeObject TypenVarChar20016
400RDN6Returns - Installments3ObjTypeObject TypenVarChar20016
401RDN7Delivery Packages - Returns6ObjTypeObject TypenVarChar20016
402RDN8Returns - Items in Package6ObjTypeObject TypenVarChar20016
403RDN9Returns - Drawn Dpm6ObjTypeBase Object TypenVarChar200
404RDR1Sales Order - Rows79ObjTypeObject TypenVarChar20017
405RDR10Sales Order - Row Structure8ObjTypeObject TypenVarChar20017
406RDR11Sls Ord. - Drawn Dpm Detail14ObjTypeObject TypenVarChar20017
407RDR13Sales Order Rows - Distributed Expenses11ObjTypeObject TypenVarChar20017
408RDR15Sls Ord. - Drawn Dpm Applied3ObjTypeobject typenVarChar20017
409RDR16Sales Order - SnB properties11ObjTypeObject TypenVarChar20017
410RDR2Sales Order - Freight - Rows11ObjTypeObject TypenVarChar20017
411RDR3Sales Order - Freight10ObjTypeObject TypenVarChar20017
412RDR5Sales Order - Withholding Tax28ObjTypeObject TypenVarChar20017
413RDR6Sales Order - Installments3ObjTypeObject TypenVarChar20017
414RDR7Delivery Packages - Sales Order6ObjTypeObject TypenVarChar20017
415RDR8Sales Order - Items in Package6ObjTypeObject TypenVarChar20017
416RDR9Order - Drawn Dpm6ObjTypeBase Object TypenVarChar200
417RIN1A/R Credit Memo - Rows79ObjTypeObject TypenVarChar20014
418RIN10A/R Credit Memo - Row Structure8ObjTypeObject TypenVarChar20014
419RIN11A/R Cr. Memo - Drawn Dpm Det.14ObjTypeObject TypenVarChar20014
420RIN13A/R Credit Memo Rows - Distributed Expenses11ObjTypeObject TypenVarChar20014
421RIN15A/R Cr. Memo - Drawn Dpm Appld3ObjTypeobject typenVarChar20014
422RIN16A/R Credit Memo - SnB properties11ObjTypeObject TypenVarChar20014
423RIN2A/R Credit Memo - Freight - Rows11ObjTypeObject TypenVarChar20014
424RIN3A/R Credit Memo - Freight10ObjTypeObject TypenVarChar20014
425RIN5A/R Credit Memo - Withholding Tax28ObjTypeObject TypenVarChar20014
426RIN6A/R Credit Memo - Installments3ObjTypeObject TypenVarChar20014
427RIN7A/R Credit Memo - Delivery Packages6ObjTypeObject TypenVarChar20014
428RIN8Items in Package - A/R Credit Memo6ObjTypeObject TypenVarChar20014
429RIN9A/R Credit Memo - Drawn Dpm6ObjTypeBase Object TypenVarChar200
430RPC1A/P Credit Memo - Rows79ObjTypeObject TypenVarChar20019
431RPC10A/P Credit Memo - Row Structure8ObjTypeObject TypenVarChar20019
432RPC11A/P Cr. Memo - Drawn Dpm Det.14ObjTypeObject TypenVarChar20019
433RPC13A/P Credit Memo Rows - Distributed Expenses11ObjTypeObject TypenVarChar20019
434RPC15A/P Cr. Memo - Drawn Dpm Appld3ObjTypeobject typenVarChar20019
435RPC16A/P Credit Memo - SnB properties11ObjTypeObject TypenVarChar20019
436RPC2A/P Credit Memo Rows - Expenses11ObjTypeObject TypenVarChar20019
437RPC3A/P Credit Memo - Freight10ObjTypeObject TypenVarChar20019
438RPC5A/P Credit Memo - Withholding Tax28ObjTypeObject TypenVarChar20019
439RPC6A/P Credit Memo - Installments3ObjTypeObject TypenVarChar20019
440RPC7Delivery Packages - A/P Credit Memo6ObjTypeObject TypenVarChar20019
441RPC8Items in Package - A/P Credit Memo6ObjTypeObject TypenVarChar20019
442RPC9A/P Credit Memo - Drawn Dpm6ObjTypeBase Object TypenVarChar200
443RPD1Goods Return - Rows79ObjTypeObject TypenVarChar20021
444RPD10Goods Return - Row Structure8ObjTypeObject TypenVarChar20021
445RPD11Gds Return - Drawn Dpm Detail14ObjTypeObject TypenVarChar20021
446RPD13Goods Returns Rows - Distributed Expenses11ObjTypeObject TypenVarChar20021
447RPD15Gds Return - Drawn Dpm Applied3ObjTypeobject typenVarChar20021
448RPD16Goods Return - SnB properties11ObjTypeObject TypenVarChar20021
449RPD2Goods Return - Freight - Rows11ObjTypeObject TypenVarChar20021
450RPD3Goods Return - Freight10ObjTypeObject TypenVarChar20021
451RPD5Goods Return - Withholding Tax Data28ObjTypeObject TypenVarChar20021
452RPD6Goods Return - Installments3ObjTypeObject TypenVarChar20021
453RPD7Goods Return - Delivery Packages6ObjTypeObject TypenVarChar20021
454RPD8Goods Return - Items in Package6ObjTypeObject TypenVarChar20021
455RPD9Goods Return - Drawn Dpm6ObjTypeBase Object TypenVarChar200
456TPI1Purchase Tax Invoice - Rows7ObjTypeObject TypeInt60
457TSI1Sales Tax Invoice - Rows17ObjTypeObject TypeInt60
458TXD1Tax Invoice Drafts - Rows7ObjTypeObject TypeInt60
459WTR13Inventory Transfer Rows - Distributed Freights11ObjTypeObject TypenVarChar20067
460WTR15Inv. Transfer - Drawn Dpm Appl3ObjTypeobject typenVarChar20067
461WTR16Inventory Transfer - SnB properties11ObjTypeObject TypenVarChar20067
TOPMRP
462ORCMRecommendation Data3ObjTypeDocument NumberInt110
TOPReports
463OTRSTax Report Saving Object2ObjTypeObject TypenVarChar200
464TRS1Tax Report Saving Object - Approved Documents2ObjTypeObject TypenVarChar200
465TRS2Tax Rpt Sav Obj Man Chgd Vals2ObjTypeObject TypenVarChar200
466XROBJXLR Company Report Objects7ObjTypeObjTypeInt110
TOPSales Opportunities
467OPR1Sales Opportunity - Rows13ObjTypeObject TypenVarChar20-123=Quotations, 17=Sales Orders, 15=Delivery Notes, 13=Sales Invoices
TOPService
468AINSCustomer Equipment Card - History36objTypeObject TypenVarChar200176
469ASC1Service Call Solutions - History4objTypeObject Type - HistorynVarChar200191
470ASCLHistory24objTypeObject TypenVarChar200191
471OINSCustomer Equipment Card36objTypeObject TypenVarChar200176
472OSCLService Calls24objTypeObject TypenVarChar200191
473QUE2Queue Elements2objTypeObject TypenVarChar200
474SCL1Service Call Solutions - Rows4objTypeObject TypenVarChar200191