ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

B1 8.8: Top 10 requests

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
General
1	Business One	9.3	SEWIC	41	1	SEWIC	General

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	CompanyNam	CompanyName	nvarchar	100	Allow NULL?
2	SmpTableId	Smp Table ID	nvarchar	3	Allow NULL?
3	EwaSentDat	EWA Sent Date	nvarchar	10	Allow NULL?
4	EwaSentTim	EWA Sent Time	nvarchar	8	Allow NULL?
5	CustNumber	Customer Number	char	1	Allow NULL?
6	CustName	Customer Name	char	1	Allow NULL?
7	CustConPer	Customer contact person	char	1	Allow NULL?
8	CustEmail	Customer Email	nvarchar	100	Allow NULL?
9	PartnerNam	Partner Name	nvarchar	100	Allow NULL?
10	PartConPer	Partnercontact person	char	1	Allow NULL?
11	PartEmail	Partner Email	nvarchar	100	Allow NULL?
12	PartEmail2	Partner Email 2	char	1	Allow NULL?
13	CompDbName	Company DB Name	nvarchar	100	Allow NULL?
14	CompDbVer	Compnay DB Version	nvarchar	32	Allow NULL?
15	SentUser	Sent User	nvarchar	30	Allow NULL?
16	B1Version	B1 Version	nvarchar	32	Allow NULL?
17	B1Suppack	B1 Support Pack	nvarchar	128	Allow NULL?
18	B1Patch	B1 Patch	nvarchar	128	Allow NULL?
19	UiApiVer	UI API Version	nvarchar	32	Allow NULL?
20	InstallNum	Installation Number	nvarchar	128	Allow NULL?
21	SystemNum	System Number	nvarchar	128	Allow NULL?
22	LicenseNum	License Number	nvarchar	128	Allow NULL?
23	SystemStat	System Status	char	1	Allow NULL?
24	DbType	DB Type	nvarchar	64	Allow NULL?
25	DbVersion	DB Version	nvarchar	32	Allow NULL?
26	CommLogPat	SBo-Common Log Path	nvarchar	254	Allow NULL?
27	CommLogSiz	SBO-Common Log Size	int	11	Allow NULL?
28	CommRecovM	SBO-Common Recovery Model	nvarchar	32	Allow NULL?
29	AOFramewor	Addon Framwork	char	1	Allow NULL?
30	AODtw	Addon DTW	char	1	Allow NULL?
31	AOSupTools	Addon Support Tools	nvarchar	12	Allow NULL?
32	AODateV	Addon Date V	nvarchar	12	Allow NULL?
33	AOAld	Addon Ald	nvarchar	12	Allow NULL?
34	AOBcSets	Addon BC Sets	nvarchar	12	Allow NULL?
35	AOElster	Addon Elster	nvarchar	12	Allow NULL?
36	AOFixAsset	Addon Fixed Assets	nvarchar	12	Allow NULL?
37	AOIntrStat	Addon Intra Stat	nvarchar	12	Allow NULL?
38	AOOutlookI	Addon Outlook integration	nvarchar	12	Allow NULL?
39	AOPayEngin	Addon Payment Engine	nvarchar	12	Allow NULL?
40	AOStampIt	Addon Stamp it	nvarchar	12	Allow NULL?
41	CompRecovM	Company Recover Model	nvarchar	32	Allow NULL?

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

41 COLUMNS | 1 INDEXES | B1 9.3 | SEWIC TABLE

TOP B1 9.3 | SEWIC COLUMNS

TOP B1 9.3 | SEWIC INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

41 COLUMNS | 1 INDEXES | B1 9.3 | SEWIC TABLE

TOPB1 9.3 | SEWIC COLUMNS

TOPB1 9.3 | SEWIC INDEXES

TOP B1 9.3 | SEWIC COLUMNS

TOP B1 9.3 | SEWIC INDEXES