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
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPOR386Purchase Order
8JDT1124Journal Entry - Rows
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

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

510 columns | Print definition?B1 8.82  | 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 TypenVarChar200
26ORCTIncoming Payment56ObjTypeObject TypenVarChar20024
27OVPMOutgoing Payments56ObjTypeObject TypenVarChar20046
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 TypenVarChar200
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
63AJD2Withholding Tax - History28ObjTypeObject TypenVarChar20030
64AJDTJournal Entry - History31ObjTypeObject TypenVarChar200
65BTF1Journal Voucher 47ObjTypeObject TypenVarChar20030
66BTF2Journal Voucher Withholding Tax - History28ObjTypeObject TypenVarChar20030
67JDT1Journal Entry - Rows47ObjTypeObject TypenVarChar20030
68JDT2Withholding Tax - History28ObjTypeObject TypenVarChar20030
69OACTG/L Accounts52ObjTypeObject TypenVarChar2001
70OBTFJournal Voucher Entry31ObjTypeObject TypenVarChar20030
71OJDTJournal Entry31ObjTypeObject TypenVarChar20030
TOPInventory and Production
72ABTNBatch Numbers Master Data20ObjTypeObject TypenVarChar200
73ABTWBatch Attributes in Location11ObjTypeObject TypenVarChar200
74AIT1Item - Prices - History8ObjTypeObjectnVarChar200
75AIT2Items - Multiple Preferred Vendors - History4ObjTypeObjectnVarChar200
76AITMItems - History199ObjTypeObject TypenVarChar200
77AMR1Inventory Revaluation - History - Rows15ObjTypeObject TypenVarChar200162
78AMR2Inventory Revaluation FIFO Rows (Archive)16ObjTypeObject TypenVarChar200162
79AMRVInventory Revaluation - History22ObjTypeObject TypenVarChar200162
80APKLPick List - History12ObjTypeObject TypenVarChar200156
81ASRNSerial Numbers Master Data20ObjTypeObject TypenVarChar200
82AWHSWarehouses - History54objTypeObject Type - HistorynVarChar20064
83IGE1Goods Issue - Rows79ObjTypeObject TypenVarChar20060
84IGE10Goods Issue - Row Structure8ObjTypeObject TypenVarChar20060
85IGE11Goods Issue - Drawn Dpm Detail14ObjTypeObject TypenVarChar20060
86IGE13Goods Issue Rows - Distributed Expenses11ObjTypeObject TypenVarChar20060
87IGE15Gds Issue - Drawn Dpm Applied3ObjTypeobject typenVarChar20060
88IGE16Goods Issue - SnB properties11ObjTypeObject TypenVarChar20060
89IGE2Goods Issue - Freight - Rows11ObjTypeObject TypenVarChar20060
90IGE3Goods Issue - Freight10ObjTypeObject TypenVarChar20060
91IGE5Goods Issue - Withholding Tax28ObjTypeObject TypenVarChar20060
92IGE6Goods Issue - Installments3ObjTypeObject TypenVarChar20060
93IGE7Delivery Packages - Goods Issue6ObjTypeObject TypenVarChar20060
94IGE8Items in Package - Goods Issue6ObjTypeObject TypenVarChar20060
95IGE9Goods Issue - Drawn Dpm6ObjTypeBase Object TypenVarChar200
96IGN1Goods Receipt - Rows79ObjTypeObject TypenVarChar20059
97IGN10Goods Receipt - Row Structure8ObjTypeObject TypenVarChar20059
98IGN11Goods Receipt - Drawn Dpm Det14ObjTypeObject TypenVarChar20059
99IGN13Goods Receipt Rows - Distributed Expenses11ObjTypeObject TypenVarChar20059
100IGN15Gds Rcpt - Drawn Dpm Applied3ObjTypeobject typenVarChar20059
101IGN16Goods Receipt - SnB properties11ObjTypeObject TypenVarChar20059
102IGN2Goods Receipt - Freight - Rows11ObjTypeObject TypenVarChar20059
103IGN3Goods Receipt - Freight10ObjTypeObject TypenVarChar20059
104IGN5Goods Receipt - Withholding Tax28ObjTypeObject TypenVarChar20059
105IGN6Goods Receipt- Installments3ObjTypeObject TypenVarChar20059
106IGN7Goods Receipt - Delivery Packages6ObjTypeObject TypenVarChar20059
107IGN8Goods Receipt - Items in Package6ObjTypeObject TypenVarChar20059
108IGN9Goods Receipt - Drawn Dpm6ObjTypeBase Object TypenVarChar200
109IQI1Inventory Initial Qty Rows22ObjTypeObject TypenVarChar200310000001
110IQR1Inventory Stock Posting (Reconcile) Lines22ObjTypeObject TypenVarChar20010000071
111ITM1Items - Prices8ObjTypeObjectnVarChar2004
112ITM2Items - Multiple Preferred Vendors4ObjTypeObjectnVarChar2004
113MRV1Inventory Revaluation Information Array15ObjTypeObject TypenVarChar200162
114MRV2Inventory Revaluation FIFO Rows16ObjTypeObject TypenVarChar200162
115OBTNBatch Numbers Master Data20ObjTypeobject typenVarChar200
116OBTWBatch Attributes in Location11ObjTypeObject TypenVarChar200
117ODBNBat. Nos - Draft - Master Data20ObjTypeobject typenVarChar200
118ODBWBatch Draft Attribs in Locat.11ObjTypeObject TypenVarChar200
119ODSNSNs - Draft - Master Data20ObjTypeobject typenVarChar200
120ODSWSN Draft Attribs in Location11ObjTypeObject TypenVarChar200
121OENTShipping Types5ObjTypeObject TypenVarChar200
122OIGEGoods Issue10ObjTypeObject TypenVarChar20060
123OIGNGoods Receipt10ObjTypeObject TypenVarChar20059
124OIPFLanded Costs48ObjTypeObject TypenVarChar20069
125OIQIInventory Initial Quantity15ObjTypeObject TypenVarChar200310000001
126OIQRInventory Stock Posting (Reconcile)15ObjTypeObject TypenVarChar20010000071
127OITMItems199ObjTypeObject TypenVarChar2004
128OMRVInventory Revaluation22ObjTypeObject TypenVarChar200162
129OPKLPick List12ObjTypeObject TypenVarChar200156
130OSPGSpecial Prices for Groups2ObjTypeObject TypenVarChar20052=Item Group, 8=Item Properties, 43=Companies
131OSRNSerial Numbers Master Data20ObjTypeobject typenVarChar200
132OSRWSerial No. Attribs in Location11ObjTypeObject TypenVarChar200
133OWHSWarehouses54objTypeObject Type - HistorynVarChar20064
134OWKOProduction Instructions27ObjTypeObject TypenVarChar20068
135OWTQInventory Transfer Request10ObjTypeObject TypenVarChar2001250000001
136OWTRInventory Transfer10ObjTypeObject TypenVarChar20067
137SITMItems199ObjTypeObject TypenVarChar2004
138UITMItems199ObjTypeObject TypenVarChar2004
139UWKOProduction Instructions27ObjTypeObject TypenVarChar20068
140WTQ1Inventory Transfer Request - Rows79ObjTypeObject TypenVarChar2001250000001
141WTQ10Inventory Transfer Request - Row Structure8ObjTypeObject TypenVarChar2001250000001
142WTQ11Inv. Transfer Request - Drawn Dpm Det.14ObjTypeObject TypenVarChar2001250000001
143WTQ13Inventory Transfer Request Rows - Distributed Freights11ObjTypeObject TypenVarChar2001250000001
144WTQ15Inv. Transfer Request - Drawn Dpm Appl3ObjTypeObject TypenVarChar2001250000001
145WTQ16Inventory Transfer Request - SnB Properties11ObjTypeObject TypenVarChar200
146WTQ2Inventory Transfer Request - Freight - Rows11ObjTypeObject TypenVarChar200
147WTQ3Inventory Transfer Request - Freight10ObjTypeObject TypenVarChar200
148WTQ5Inventory Transfer Request - Withholding Tax28ObjTypeObject TypenVarChar200
149WTQ6Inventory Transfer Request - Installments3ObjTypeObject TypenVarChar2001250000001
150WTQ7Inventory Transfer Request - Delivery Packages6ObjTypeObject TypenVarChar2001250000001
151WTQ8Inventory Transfer Request - Items in Package6ObjTypeObject TypenVarChar2001250000001
152WTQ9Inventory Transfer Request - Drawn DPM6ObjTypeBase Object TypenVarChar200
153WTR1Inventory Transfer - Rows79ObjTypeObject TypenVarChar20067
154WTR10Inventory Transfer - Row Structure8ObjTypeObject TypenVarChar20067
155WTR11Inv. Transfer - Drawn Dpm Det.14ObjTypeObject TypenVarChar20067
156WTR13Inventory Transfer Rows - Distributed Freights11ObjTypeObject TypenVarChar20067
157WTR15Inv. Transfer - Drawn Dpm Appl3ObjTypeobject typenVarChar20067
158WTR16Inventory Transfer - SnB properties11ObjTypeObject TypenVarChar20067
159WTR2Inventory Transfer - Freight - Rows11ObjTypeObject TypenVarChar20067
160WTR3Inventory Transfer - Freight10ObjTypeObject TypenVarChar20067
161WTR5Inventory Transfer - Withholding Tax28ObjTypeObject TypenVarChar20067
162WTR6Inventory Transfer - Installments3ObjTypeObject TypenVarChar20067
163WTR7Inventory Transfer - Delivery Packages6ObjTypeObject TypenVarChar20067
164WTR8Inventory Transfer - Items in Package6ObjTypeObject TypenVarChar20067
165WTR9Inventory Transfer - Drawn Dpm6ObjTypeBase Object TypenVarChar200
TOPMarketing Documents
166ADO1A/R Invoice (Rows) - History79ObjTypeObject TypenVarChar200
167ADO10A/R Invoice - Row Structure - History8ObjTypeObject TypenVarChar20023
168ADO11A/R Inv (Drawn Dpm Det) - Hist14ObjTypeObject TypenVarChar20013
169ADO13A/R Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200
170ADO15A/R Inv (Drawn Dpm Applied) - Hist3ObjTypeobject typenVarChar20013
171ADO16Draft - SnB properties11ObjTypeObject TypenVarChar200
172ADO2A/R Invoice - Freight - Rows11ObjTypeObject TypenVarChar200
173ADO3A/R Invoice - Freight - History10ObjTypeObject TypenVarChar200
174ADO5Withholding Tax - History28ObjTypeObject TypenVarChar200
175ADO6Documents History - Installments3ObjTypeObject TypenVarChar200
176ADO7Delivery Packages - History6ObjTypeObject TypenVarChar200
177ADO8Items in Package - History6ObjTypeObject TypenVarChar200
178ADO9A/R Invoice (Rows) - History6ObjTypeBase Object TypenVarChar200
179ADOCInvoice - History10ObjTypeObject TypenVarChar200
180ATX1Tax Invoice - History - Rows7ObjTypeObject TypeInt60
181ATXITax Invoice - History8ObjTypeObject TypenVarChar200194
182CIN1Correction Invoice - Rows79ObjTypeObject TypenVarChar200132
183CIN10Correction Invoice - Row Structure8ObjTypeObject TypenVarChar200132
184CIN13Correction Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200132
185CIN2A/R Correction Invoice - Freight - Rows11ObjTypeObject TypenVarChar200132
186CIN3A/R Correction Invoice - Freight10ObjTypeObject TypenVarChar200132
187CIN5AR Correction Invoice - Withholding Tax28ObjTypeObject TypenVarChar200132
188CIN6Correction Invoice - Installments3ObjTypeObject TypenVarChar200132
189CIN7Delivery Packages - Correction Invoice6ObjTypeObject TypenVarChar200132
190CIN8Items in Package - Correction Invoice6ObjTypeObject TypenVarChar200132
191CIN9Correction Invoice - Drawn Dpm6ObjTypeBase Object TypenVarChar200
192CPI1A/P Correction Invoice - Rows79ObjTypeObject TypenVarChar200163
193CPI10A/P Correction Invoice - Row Structure8ObjTypeObject TypenVarChar200163
194CPI11A/P Corr. Inv - Drawn Dpm Det.14ObjTypeObject TypenVarChar200163
195CPI13A/P Correction Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200163
196CPI15A/P Corr Inv - Drawn Dpm Appld3ObjTypeobject typenVarChar200163
197CPI16A/P Corr. Inv - SnB properties11ObjTypeObject TypenVarChar200163
198CPI2A/P Correction Invoice - Freight - Rows11ObjTypeObject TypenVarChar200163
199CPI3A/P Correction Invoice - Freight10ObjTypeObject TypenVarChar200163
200CPI5Withholding Tax Data28ObjTypeObject TypenVarChar200163
201CPI6Documents History - Installments3ObjTypeObject TypenVarChar200163
202CPI7A/P Correction Invoice - Delivery Packages6ObjTypeObject TypenVarChar200163
203CPI8A/P Correction Invoice - Items in Package6ObjTypeObject TypenVarChar200163
204CPI9A/P Corr. Invoice - Drawn Dpm6ObjTypeBase Object TypenVarChar200
205CPV1A/P Correction Invoice Reversal - Rows79ObjTypeObject TypenVarChar200164
206CPV10A/P CrIn Rev - Row Structure8ObjTypeObject TypenVarChar200164
207CPV11A/P CrIn Rev - Drawn Dpm Det.14ObjTypeObject TypenVarChar200164
208CPV13A/P Correction Invoice Reversal Rows - Distributed Expenses11ObjTypeObject TypenVarChar200164
209CPV15A/P CrIn Rev - Drawn Dpm Appld3ObjTypeobject typenVarChar200164
210CPV16A/P Correction Invoice Reversal - SnB properties11ObjTypeObject TypenVarChar200164
211CPV2A/P Correction Invoice Reversal - Freight - Rows11ObjTypeObject TypenVarChar200164
212CPV3A/P Correction Invoice Reversal - Freight10ObjTypeObject TypenVarChar200164
213CPV5A/P Correction Invoice Reversal - WTax28ObjTypeObject TypenVarChar200164
214CPV6A/P Correction Invoice Reversal - Installments3ObjTypeObject TypenVarChar200164
215CPV7A/P Corr Inv Rvsl - Deliv Pkgs6ObjTypeObject TypenVarChar20013
216CPV8A/P Correction Invoice Reversal - Items in Package6ObjTypeObject TypenVarChar200164
217CPV9A/P Corr Inv Rvrsl - Drawn Dpm6ObjTypeBase Object TypenVarChar200
218CSI1A/R Correction Invoice - Rows79ObjTypeObject TypenVarChar200165
219CSI10A/R Correction Invoice - Row Structure8ObjTypeObject TypenVarChar200165
220CSI11A/R Corr. Inv. - Drawn Dpm Det14ObjTypeObject TypenVarChar200165
221CSI13A/R Correction Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200165
222CSI15A/R Corr Inv - Drawn Dpm Appld3ObjTypeobject typenVarChar200165
223CSI16A/R Corr. Inv. - SnB properties11ObjTypeObject TypenVarChar200165
224CSI2A/R Corr Inv - Freight - Rows11ObjTypeObject TypenVarChar200165
225CSI3A/R Correction Invoice - Freight10ObjTypeObject TypenVarChar200165
226CSI5A/R Correction Invoice - Withholding Tax28ObjTypeObject TypenVarChar200165
227CSI6A/R Corr. Inv. - Installments3ObjTypeObject TypenVarChar200165
228CSI7A/R Corr. Inv. Deliv. Pkgs6ObjTypeObject TypenVarChar200165
229CSI8A/R Corr. Inv. - Items in Pkg6ObjTypeObject TypenVarChar200165
230CSI9A/R Corr. Inv. - Drawn Dpm6ObjTypeBase Object TypenVarChar200203
231CSV1A/R Correction Invoice Reversal - Rows79ObjTypeObject TypenVarChar200166
232CSV10A/R Correction Invoice Reversal - Row Structure8ObjTypeObject TypenVarChar200166
233CSV11A/R CrIn Rev - Drawn Dpm Det.14ObjTypeObject TypenVarChar200166
234CSV13A/R Correction Invoice Reversal Rows - Distributed Expenses11ObjTypeObject TypenVarChar200166
235CSV15A/R CrIn Rev - Drawn Dpm Appld3ObjTypeobject typenVarChar200166
236CSV16A/R Correction Invoice Reversal - SnB properties11ObjTypeObject TypenVarChar200166
237CSV2A/R Correction Invoice Reversal - Freight - Rows11ObjTypeObject TypenVarChar200166
238CSV3A/R Correction Invoice Reversal - Freight10ObjTypeObject TypenVarChar200166
239CSV5A/R Correction Invoice Reversal - WTax28ObjTypeObject TypenVarChar200166
240CSV6A/R Correction Invoice Reversal - Installments3ObjTypeObject TypenVarChar200166
241CSV7A/R Correction Invoice Reversal - Delivery Packages6ObjTypeObject TypenVarChar200166
242CSV8A/R Correction Invoice Reversal - Items in Package6ObjTypeObject TypenVarChar200166
243CSV9A/R CrIn Rev - Drawn Dpm6ObjTypeBase Object TypenVarChar200
244DLN1Delivery - Rows79ObjTypeObject TypenVarChar20015
245DLN10Delivery - Row Structure8ObjTypeObject TypenVarChar20015
246DLN11Delivery - Drawn Dpm Detail14ObjTypeObject TypenVarChar20015
247DLN13Delivery Rows - Distributed Expenses11ObjTypeObject TypenVarChar20015
248DLN15Delivery - Drawn Dpm Applied3ObjTypeobject typenVarChar20015
249DLN16Delivery - SnB properties11ObjTypeObject TypenVarChar20015
250DLN2Delivery Notes - Freight - Rows11ObjTypeObject TypenVarChar20015
251DLN3Delivery Notes - Freight10ObjTypeObject TypenVarChar20015
252DLN5Delivery - Withholding Tax28ObjTypeObject TypenVarChar20015
253DLN6Delivery - Installments3ObjTypeObject TypenVarChar20015
254DLN7Delivery Packages6ObjTypeObject TypenVarChar20015
255DLN8Items in Package - Delivery6ObjTypeObject TypenVarChar20015
256DLN9Delivery - Drawn Dpm6ObjTypeBase Object TypenVarChar200
257DPI1A/R Down Payment - Rows79ObjTypeObject TypenVarChar200203
258DPI10A/R Down Payment - Row Structure8ObjTypeObject TypenVarChar200203
259DPI11A/R DP - Drawn Dpm Detail14ObjTypeObject TypenVarChar200203
260DPI13A/R Down Payment Rows - Distributed Expenses11ObjTypeObject TypenVarChar200202
261DPI15A/R DP - Drawn Dpm Applied3ObjTypeobject typenVarChar200203
262DPI16A/R Down Payment - SnB properties11ObjTypeObject TypenVarChar200203
263DPI2A/R Down Payment - Freight - Rows11ObjTypeObject TypenVarChar200203
264DPI3A/R Down Payment - Freight10ObjTypeObject TypenVarChar200202
265DPI5A/R Down Payment - Withholding Tax28ObjTypeObject TypenVarChar200203
266DPI6A/R Down Payment - Installments3ObjTypeObject TypenVarChar200203
267DPI7Delivery Packages - A/R Down Pymt6ObjTypeObject TypenVarChar200203
268DPI8Items in Package - A/R Down Pmt.6ObjTypeObject TypenVarChar200203
269DPI9Down Payment Incoming - Drawn Dpm6ObjTypeBase Object TypenVarChar200
270DPO1A/P Down Payment - Rows79ObjTypeObject TypenVarChar200204
271DPO10A/P Down Payment - Row Structure8ObjTypeObject TypenVarChar200204
272DPO11A/P DP - Drawn Dpm Detail14ObjTypeObject TypenVarChar200204
273DPO13A/P Down Payment Rows - Distributed Expenses11ObjTypeObject TypenVarChar200204
274DPO15A/P DP - Drawn Dpm Applied3ObjTypeobject typenVarChar200204
275DPO16A/P Down Payment - SnB properties11ObjTypeObject TypenVarChar200204
276DPO2A/P Down Payment - Freight - Rows11ObjTypeObject TypenVarChar200204
277DPO3A/P Down Payment - Freight10ObjTypeObject TypenVarChar200204
278DPO5A/P Down Payment - Withholding Tax28ObjTypeObject TypenVarChar200204
279DPO6Down Payment Out - Installments3ObjTypeObject TypenVarChar200204
280DPO7Delivery Packages - A/P Down Pymt6ObjTypeObject TypenVarChar200204
281DPO8Items in Package - A/P Down Pmt.6ObjTypeObject TypenVarChar200204
282DPO9Down Payment Outgoing - Drawn Dpm6ObjTypeBase Object TypenVarChar200
283DRF1Draft - Rows79ObjTypeObject TypenVarChar200112
284DRF10Draft - Row Structure8ObjTypeObject TypenVarChar200112
285DRF11Draft - Drawn Dpm Detail14ObjTypeObject TypenVarChar200112
286DRF13Draft Rows - Distributed Expenses11ObjTypeObject TypenVarChar200112
287DRF15Draft - Drawn Dpm Applied3ObjTypeObject TypenVarChar200112
288DRF16Draft - SnB - Rows11ObjTypeObject TypenVarChar200
289DRF2Draft - Freight - Rows11ObjTypeObject TypenVarChar200112
290DRF3Draft - Freight10ObjTypeObject TypenVarChar200112
291DRF5Draft Documents - Withholding Tax28ObjTypeObject TypenVarChar200112
292DRF6Document Drafts - Installments3ObjTypeObject TypenVarChar200112
293DRF7Delivery Packages - Drafts6ObjTypeObject TypenVarChar200112
294DRF8Items in Package - Draft6ObjTypeObject TypenVarChar200112
295DRF9Document Draft - Drawn Dpm6ObjTypeBase Object TypenVarChar200
296IEI1Incoming Excise Invoice - Rows79ObjTypeObject TypenVarChar200140000010
297IEI10Incoming Excise Invoice - Row Structure8ObjTypeObject TypenVarChar200140000010
298IEI11IEI - Drawn Dpm Detail14ObjTypeObject TypenVarChar200140000010
299IEI13Incoming Excise Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200140000010
300IEI15IEI - Drawn Dpm Applied3ObjTypeobject typenVarChar200140000010
301IEI16Incoming Excise Invoice - SnB properties11ObjTypeObject TypenVarChar200140000010
302IEI2Incoming Excise Invoice - Freight - History - Rows11ObjTypeObject TypenVarChar200140000010
303IEI3IEI - Freight10ObjTypeObject TypenVarChar200140000010
304IEI5Incoming Excise Invoice - Withholding Tax28ObjTypeObject TypenVarChar200140000010
305IEI6IEI - Installments3ObjTypeObject TypenVarChar200140000010
306IEI7Delivery Packages - Incoming Excise Invoice6ObjTypeObject TypenVarChar200140000010
307IEI8Incoming Excise Invoice - Items in Package6ObjTypeObject TypenVarChar200140000010
308IEI9IEI - Drawn Dpm6ObjTypeBase Object TypenVarChar200203
309INV1A/R Invoice - Rows79ObjTypeObject TypenVarChar20013
310INV10A/R Invoice - Row Structure8ObjTypeObject TypenVarChar20013
311INV11A/R Invoice - Drawn Dpm Detail14ObjTypeObject TypenVarChar20013
312INV13A/R Invoice Rows - Distributed Freights11ObjTypeObject TypenVarChar20013
313INV15A/R Inv. - Drawn Dpm Applied3ObjTypeobject typenVarChar20013
314INV16A/R Invoice - SnB properties11ObjTypeObject TypenVarChar20013
315INV2A/R Invoice - Freight - Rows11ObjTypeObject TypenVarChar20013
316INV3A/R Invoice - Freight10ObjTypeObject TypenVarChar20013
317INV5A/R Invoice - Withholding Tax28ObjTypeObject TypenVarChar20013
318INV6A/R Invoice - Installments3ObjTypeObject TypenVarChar20013
319INV7A/R Invoice - Delivery Packages6ObjTypeObject TypenVarChar20013
320INV8A/R Invoice - Items in Package6ObjTypeObject TypenVarChar20013
321INV9A/R Invoice - Drawn Dpm6ObjTypeBase Object TypenVarChar200203
322OCINA/R Correction Invoice10ObjTypeObject TypenVarChar200132
323OCPIA/P Correction Invoice10ObjTypeObject TypenVarChar200163
324OCPVA/P Correction Invoice Reversal10ObjTypeObject TypenVarChar200164
325OCSIA/R Correction Invoice10ObjTypeObject TypenVarChar200165
326OCSVA/R Correction Invoice Reversal10ObjTypeObject TypenVarChar200166
327ODLNDelivery10ObjTypeObject TypenVarChar20015
328ODPIA/R Down Payment10ObjTypeObject TypenVarChar200203
329ODPOA/P Down Payment10ObjTypeObject TypenVarChar200204
330ODRFDrafts10ObjTypeObject TypenVarChar200
331OEI1Outgoing Excise Invoice - Rows79ObjTypeObject TypenVarChar200140000009
332OEI10Outgoing Excise Invoice - Row Structure8ObjTypeObject TypenVarChar200140000009
333OEI11OEI - Drawn Dpm Detail14ObjTypeObject TypenVarChar200140000009
334OEI13Outgoing Excise Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar200140000009
335OEI15OEI - Drawn Dpm Applied3ObjTypeobject typenVarChar200140000009
336OEI16Outgoing Excise Invoice - SnB properties11ObjTypeObject TypenVarChar200140000009
337OEI2OEI - Freight Rows11ObjTypeObject TypenVarChar200140000009
338OEI3OEI - Freight10ObjTypeObject TypenVarChar200140000009
339OEI5Outgoing Excise Invoice - Withholding Tax28ObjTypeObject TypenVarChar200140000009
340OEI6Outgoing Excise Invoice - Installments3ObjTypeObject TypenVarChar200140000000
341OEI7Delivery Packages - Outgoing Excise Invoice6ObjTypeObject TypenVarChar200140000009
342OEI8Outgoing Excise Invoice - Items in Package6ObjTypeObject TypenVarChar200140000009
343OEI9OEI - Drawn Dpm6ObjTypeBase Object TypenVarChar200203
344OIEIIncoming Excise Invoice10ObjTypeObject TypenVarChar200140000010
345OINVA/R Invoice10ObjTypeObject TypenVarChar20013
346OLGLLegal Data4ObjTypeObject TypenVarChar200540000073
347OOEIOutgoing Excise Invoice10ObjTypeObject TypenVarChar200140000009
348OPCHA/P Invoice10ObjTypeObject TypenVarChar20018
349OPDNGoods Receipt PO10ObjTypeObject TypenVarChar20020
350OPORPurchase Order10ObjTypeObject TypenVarChar20022
351OPQTPurchase Quotation10ObjTypeObject TypenVarChar200540000006
352OQUTSales Quotation10ObjTypeObject TypenVarChar20023
353ORDNReturns10ObjTypeObject TypenVarChar20016
354ORDRSales Order10ObjTypeObject TypenVarChar20017
355ORINA/R Credit Memo10ObjTypeObject TypenVarChar20014
356ORPCA/P Credit Memo10ObjTypeObject TypenVarChar20019
357ORPDGoods Return10ObjTypeObject TypenVarChar20021
358OSALOutgoing5ObjTypeObject TypenVarChar200
359OTPIPurchase Tax Invoice8ObjTypeObject TypenVarChar200194
360OTRATransition5ObjTypeObject TypenVarChar200
361OTSISales Tax Invoice8ObjTypeObject TypenVarChar200194
362OTXDTax Invoice Draft8ObjTypeObject TypenVarChar200194
363OWDDDocs. for Confirmation5ObjTypeObject TypenVarChar200
364PCH1A/P Invoice - Rows79ObjTypeObject TypenVarChar20018
365PCH10A/P Invoice - Row Structure8ObjTypeObject TypenVarChar20018
366PCH11A/P Invoice - Drawn Dpm Det.14ObjTypeObject TypenVarChar20018
367PCH13A/P Invoice Rows - Distributed Expenses11ObjTypeObject TypenVarChar20018
368PCH15A/P Invoice - Drawn Dpm Appld3ObjTypeobject typenVarChar20018
369PCH16A/P Invoice - SnB properties11ObjTypeObject TypenVarChar20018
370PCH2A/P Invoice - Freight - Rows11ObjTypeObject TypenVarChar20018
371PCH3A/P Invoice - Freight10ObjTypeObject TypenVarChar20018
372PCH5A/P Invoice - Withholding Tax Data28ObjTypeObject TypenVarChar20018
373PCH6A/P Invoice - Installments3ObjTypeObject TypenVarChar20018
374PCH7Delivery Packages - A/P Invoice6ObjTypeObject TypenVarChar20018
375PCH8A/P Invoice - Items in Package6ObjTypeObject TypenVarChar20018
376PCH9A/P Invoice - Drawn Dpm6ObjTypeBase Object TypenVarChar200204
377PDN1Goods Receipt PO - Rows79ObjTypeObject TypenVarChar20020
378PDN10Goods Receipt PO - Row Structure8ObjTypeObject TypenVarChar20020
379PDN11GRPO - Drawn Dpm Detail14ObjTypeObject TypenVarChar20020
380PDN13Goods Receipt PO Rows - Distributed Expenses11ObjTypeObject TypenVarChar20020
381PDN15GRPO - Drawn Dpm Applied3ObjTypeobject typenVarChar20020
382PDN16Goods Receipt PO - SnB properties11ObjTypeObject TypenVarChar20020
383PDN2Goods Receipt PO - Freight - Rows11ObjTypeObject TypenVarChar20020
384PDN3Goods Receipt PO - Freight10ObjTypeObject TypenVarChar20020
385PDN5Goods Reciept PO - Withholding Tax28ObjTypeObject TypenVarChar20020
386PDN6Goods Receipt PO - Installments3ObjTypeObject TypenVarChar20020
387PDN7Goods Receipt PO - Delivery Packages6ObjTypeObject TypenVarChar20020
388PDN8Goods Receipt PO - Items in Package6ObjTypeObject TypenVarChar20020
389PDN9Goods Receipt PO - Drawn Dpm6ObjTypeBase Object TypenVarChar200
390POR1Purchase Order - Rows79ObjTypeObject TypenVarChar20022
391POR10Purchase Order - Row structure8ObjTypeObject TypenVarChar20022
392POR11PO - Drawn Dpm Detail14ObjTypeObject TypenVarChar20022
393POR13Purchase Order Rows - Distributed Expenses11ObjTypeObject TypenVarChar20022
394POR15PO - Drawn Dpm Applied3ObjTypeobject typenVarChar20022
395POR16Purchase Order - SnB properties11ObjTypeObject TypenVarChar20022
396POR2Purchase Order - Freight - Rows11ObjTypeObject TypenVarChar20022
397POR3Purchase Order - Freight10ObjTypeObject TypenVarChar20022
398POR5Purchase Order - Withholding Tax28ObjTypeObject TypenVarChar20022
399POR6Purchase Order - Installments3ObjTypeObject TypenVarChar20022
400POR7Delivery Packages - Purchase Order6ObjTypeObject TypenVarChar20022
401POR8Items in Package - Purchase Order6ObjTypeObject TypenVarChar20022
402POR9Purchase Order - Drawn Dpm6ObjTypeBase Object TypenVarChar200
403PQT1Purchase Quotation - Rows79ObjTypeObject TypenVarChar200540000006
404PQT10Purchase Quotation - Row Structure8ObjTypeObject TypenVarChar200540000006
405PQT11PQ - Drawn DPM Detail14ObjTypeObject TypenVarChar200540000006
406PQT13Purchase Quotation Rows - Distributed Expenses11ObjTypeObject TypenVarChar200540000006
407PQT15PQ - Drawn DPM Applied3ObjTypeobject typenVarChar200540000006
408PQT16Purchase Quotation - SnB properties11ObjTypeObject TypenVarChar200540000006
409PQT2Purchase Quotation - Freight - Rows11ObjTypeObject TypenVarChar200540000006
410PQT3Purchase Quotation - Freight10ObjTypeObject TypenVarChar200540000006
411PQT5Purchase Quotation - Withholding Tax28ObjTypeObject TypenVarChar200540000006
412PQT6Purchase Quotation - Installments3ObjTypeObject TypenVarChar200540000006
413PQT7Delivery Packages - Purchase Quotation6ObjTypeObject TypenVarChar200540000006
414PQT8Items in Package - Purchase Quotation6ObjTypeObject TypenVarChar200540000006
415PQT9Purchase Quotation - Drawn DPM6ObjTypeBase Object TypenVarChar200
416QUT1Sales Quotation - Rows79ObjTypeObject TypenVarChar20023
417QUT10Sales Quotation - Row Structure8ObjTypeObject TypenVarChar20023
418QUT11Sls Quote - Drawn Dpm Detail14ObjTypeObject TypenVarChar20023
419QUT13Sales Quotation Rows - Distributed Expenses11ObjTypeObject TypenVarChar20023
420QUT15Sls Quote - Drawn Dpm Applied3ObjTypeobject typenVarChar20023
421QUT16Sales Quotation - SnB properties11ObjTypeObject TypenVarChar20023
422QUT2Sales Quotation - Freight - Rows11ObjTypeObject TypenVarChar20023
423QUT3Sales Quotation - Freight10ObjTypeObject TypenVarChar20023
424QUT5Sales Quotation - Tax28ObjTypeObject TypenVarChar20023
425QUT6Sales Quotation - Installments3ObjTypeObject TypenVarChar20023
426QUT7Delivery Packages - Sales Quotation6ObjTypeObject TypenVarChar20023
427QUT8Sales Quotation - Items in Package6ObjTypeObject TypenVarChar20023
428QUT9Sales Quotation - Drawn Dpm6ObjTypeBase Object TypenVarChar200
429RDN1Returns - Rows79ObjTypeObject TypenVarChar20016
430RDN10Returns - Row Structure8ObjTypeObject TypenVarChar20016
431RDN11Returns - Drawn Dpm Detail14ObjTypeObject TypenVarChar20016
432RDN13Returns Rows - Distributed Expenses11ObjTypeObject TypenVarChar20016
433RDN15Returns - Drawn Dpm Applied3ObjTypeobject typenVarChar20016
434RDN16Returns - SnB properties11ObjTypeObject TypenVarChar20016
435RDN2Return - Freight - Rows11ObjTypeObject TypenVarChar20016
436RDN3Return - Freight10ObjTypeObject TypenVarChar20016
437RDN5Returns - Withholding Tax28ObjTypeObject TypenVarChar20016
438RDN6Returns - Installments3ObjTypeObject TypenVarChar20016
439RDN7Delivery Packages - Returns6ObjTypeObject TypenVarChar20016
440RDN8Returns - Items in Package6ObjTypeObject TypenVarChar20016
441RDN9Returns - Drawn Dpm6ObjTypeBase Object TypenVarChar200
442RDR1Sales Order - Rows79ObjTypeObject TypenVarChar20017
443RDR10Sales Order - Row Structure8ObjTypeObject TypenVarChar20017
444RDR11Sls Ord. - Drawn Dpm Detail14ObjTypeObject TypenVarChar20017
445RDR13Sales Order Rows - Distributed Expenses11ObjTypeObject TypenVarChar20017
446RDR15Sls Ord. - Drawn Dpm Applied3ObjTypeobject typenVarChar20017
447RDR16Sales Order - SnB properties11ObjTypeObject TypenVarChar20017
448RDR2Sales Order - Freight - Rows11ObjTypeObject TypenVarChar20017
449RDR3Sales Order - Freight10ObjTypeObject TypenVarChar20017
450RDR5Sales Order - Withholding Tax28ObjTypeObject TypenVarChar20017
451RDR6Sales Order - Installments3ObjTypeObject TypenVarChar20017
452RDR7Delivery Packages - Sales Order6ObjTypeObject TypenVarChar20017
453RDR8Sales Order - Items in Package6ObjTypeObject TypenVarChar20017
454RDR9Order - Drawn Dpm6ObjTypeBase Object TypenVarChar200
455RIN1A/R Credit Memo - Rows79ObjTypeObject TypenVarChar20014
456RIN10A/R Credit Memo - Row Structure8ObjTypeObject TypenVarChar20014
457RIN11A/R Cr. Memo - Drawn Dpm Det.14ObjTypeObject TypenVarChar20014
458RIN13A/R Credit Memo Rows - Distributed Expenses11ObjTypeObject TypenVarChar20014
459RIN15A/R Cr. Memo - Drawn Dpm Appld3ObjTypeobject typenVarChar20014
460RIN16A/R Credit Memo - SnB properties11ObjTypeObject TypenVarChar20014
461RIN2A/R Credit Memo - Freight - Rows11ObjTypeObject TypenVarChar20014
462RIN3A/R Credit Memo - Freight10ObjTypeObject TypenVarChar20014
463RIN5A/R Credit Memo - Withholding Tax28ObjTypeObject TypenVarChar20014
464RIN6A/R Credit Memo - Installments3ObjTypeObject TypenVarChar20014
465RIN7A/R Credit Memo - Delivery Packages6ObjTypeObject TypenVarChar20014
466RIN8Items in Package - A/R Credit Memo6ObjTypeObject TypenVarChar20014
467RIN9A/R Credit Memo - Drawn Dpm6ObjTypeBase Object TypenVarChar200
468RPC1A/P Credit Memo - Rows79ObjTypeObject TypenVarChar20019
469RPC10A/P Credit Memo - Row Structure8ObjTypeObject TypenVarChar20019
470RPC11A/P Cr. Memo - Drawn Dpm Det.14ObjTypeObject TypenVarChar20019
471RPC13A/P Credit Memo Rows - Distributed Expenses11ObjTypeObject TypenVarChar20019
472RPC15A/P Cr. Memo - Drawn Dpm Appld3ObjTypeobject typenVarChar20019
473RPC16A/P Credit Memo - SnB properties11ObjTypeObject TypenVarChar20019
474RPC2A/P Credit Memo Rows - Expenses11ObjTypeObject TypenVarChar20019
475RPC3A/P Credit Memo - Freight10ObjTypeObject TypenVarChar20019
476RPC5A/P Credit Memo - Withholding Tax28ObjTypeObject TypenVarChar20019
477RPC6A/P Credit Memo - Installments3ObjTypeObject TypenVarChar20019
478RPC7Delivery Packages - A/P Credit Memo6ObjTypeObject TypenVarChar20019
479RPC8Items in Package - A/P Credit Memo6ObjTypeObject TypenVarChar20019
480RPC9A/P Credit Memo - Drawn Dpm6ObjTypeBase Object TypenVarChar200
481RPD1Goods Return - Rows79ObjTypeObject TypenVarChar20021
482RPD10Goods Return - Row Structure8ObjTypeObject TypenVarChar20021
483RPD11Gds Return - Drawn Dpm Detail14ObjTypeObject TypenVarChar20021
484RPD13Goods Returns Rows - Distributed Expenses11ObjTypeObject TypenVarChar20021
485RPD15Gds Return - Drawn Dpm Applied3ObjTypeobject typenVarChar20021
486RPD16Goods Return - SnB properties11ObjTypeObject TypenVarChar20021
487RPD2Goods Return - Freight - Rows11ObjTypeObject TypenVarChar20021
488RPD3Goods Return - Freight10ObjTypeObject TypenVarChar20021
489RPD5Goods Return - Withholding Tax Data28ObjTypeObject TypenVarChar20021
490RPD6Goods Return - Installments3ObjTypeObject TypenVarChar20021
491RPD7Goods Return - Delivery Packages6ObjTypeObject TypenVarChar20021
492RPD8Goods Return - Items in Package6ObjTypeObject TypenVarChar20021
493RPD9Goods Return - Drawn Dpm6ObjTypeBase Object TypenVarChar200
494TPI1Purchase Tax Invoice - Rows7ObjTypeObject TypeInt60
495TSI1Sales Tax Invoice - Rows17ObjTypeObject TypeInt60
496TXD1Tax Invoice Drafts - Rows7ObjTypeObject TypeInt60
TOPMRP
497ORCMRecommendation Data3ObjTypeDocument NumberInt110
TOPReports
498OTRSTax Report Saving Object2ObjTypeObject TypenVarChar200
499SRA3Scheduled Report Recipients3ObjTypeObject TypenVarChar200
500TRS1Tax Report Saving Object - Approved Documents2ObjTypeObject TypenVarChar200
501TRS2Tax Rpt Sav Obj Man Chgd Vals2ObjTypeObject TypenVarChar200
502XROBJXLR Company Report Objects7ObjTypeObjTypeInt110
TOPSales Opportunities
503OPR1Sales Opportunity - Rows13ObjTypeObject TypenVarChar20-123=Quotations, 17=Sales Orders, 15=Delivery Notes, 13=Sales Invoices
TOPService
504AINSCustomer Equipment Card - History36objTypeObject TypenVarChar200176
505ASC1Service Call Solutions - History4objTypeObject Type - HistorynVarChar200191
506ASCLHistory24objTypeObject TypenVarChar200191
507OINSCustomer Equipment Card36objTypeObject TypenVarChar200176
508OSCLService Calls24objTypeObject TypenVarChar200191
509QUE2Queue Elements2objTypeObject TypenVarChar200
510SCL1Service Call Solutions - Rows4objTypeObject TypenVarChar200191