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
Administration
1	Business One	8.82	OUSR	90	4	Users	Administration

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	USERID	User Signature	int	6	0				Allow NULL?
2	PASSWORD	User Password	nvarchar	254	0		0		Allow NULL?
3	PASSWORD1	User Password	nvarchar	8	0				Allow NULL?
4	PASSWORD2	User Password	nvarchar	8	0				Allow NULL?
5	INTERNAL_K	Internal Number	int	6	0				Allow NULL?
6	USER_CODE	User Code	nvarchar	8	0				Allow NULL?
7	U_NAME	User Name	nvarchar	155	0				Allow NULL?
8	GROUPS	User Group	int	6	0		0	0, 99	Allow NULL?
9	PASSWORD4	Password	nvarchar	254	0				Allow NULL?
10	ALLOWENCES	User Confirmation	text	16	0
11	SUPERUSER	Superuser	char	1	0		N	N, Y	Allow NULL?
12	DISCOUNT	Max. Discount	num	19	6				Allow NULL?
13	PASSWORD3	User Password	nvarchar	8	0				Allow NULL?
14	Info1File	Info1File	nvarchar	4	0				Allow NULL?
15	Info1Field	Info1Field	int	6	0				Allow NULL?
16	Info2File	Info2File	nvarchar	4	0				Allow NULL?
17	Info2Field	Info2Field	int	6	0				Allow NULL?
18	Info3File	Info3File	nvarchar	4	0				Allow NULL?
19	Info3Field	Info3Field	int	6	0				Allow NULL?
20	Info4File	Info4File	nvarchar	4	0				Allow NULL?
21	Info4Field	Info4Field	int	6	0				Allow NULL?
22	dType	dType	char	1	0		H	H, N, X, Y	Allow NULL?
23	E_Mail	E-Mail	nvarchar	100	0				Allow NULL?
24	PortNum	Mobile Phone Number	nvarchar	50	0				Allow NULL?
25	OutOfOffic	Out of Office	char	1	0		N	N, Y	Allow NULL?
26	SendEMail	Send E-Mail	char	1	0		N	N, Y	Allow NULL?
27	SendSMS	Send SMS	char	1	0		N	N, Y	Allow NULL?
28	DfltsGroup	Defaults	nvarchar	8	0	OUDG			Allow NULL?
29	CashLimit	Cash Amount Limit	char	1	0		N	N, Y	Allow NULL?
30	MaxCashSum	Max. Cash Total	num	19	6				Allow NULL?
31	Fax	Fax Number	nvarchar	20	0				Allow NULL?
32	SendFax	Send Fax	char	1	0		N	N, Y	Allow NULL?
33	Locked	User Locked	char	1	0		N	N, Y	Allow NULL?
34	Department	Department	int	6	0	OUDP	-2		Allow NULL?
35	Branch	Branch	int	6	0	OUBR	-2		Allow NULL?
36	UserPrefs	User Preferences	text	16	0
37	Language	Language	int	6	0				Allow NULL?
38	Charset	Font Language	int	6	0				Allow NULL?
39	OpenCdt	Open Window for Credit Reference	char	1	0		N	N, Y	Allow NULL?
40	CdtPrvDays	Vouchers from Last Days	int	11	0		1		Allow NULL?
41	DsplyRates	Display Rate Table on start up	char	1	0		N	N, Y	Allow NULL?
42	AuImpRates	Import Currency Rates Automatically	char	1	0		N	N, Y	Allow NULL?
43	OpenDps	Open Postdated Checks Window	char	1	0		N	N, Y	Allow NULL?
44	RcrFlag	Display Transactions Scheduled for Today	char	1	0		N	N, Y	Allow NULL?
45	CheckFiles	File Check	char	1	0		N	N, Y	Allow NULL?
46	OpenCredit	Open Postdated Credit Vouchers Window	char	1	0		N	D, N, Y	Allow NULL?
47	CreditDay1	Credit Handling Day 1	int	6	0		1		Allow NULL?
48	CreditDay2	Credit Handling Day 2	int	6	0		15		Allow NULL?
49	WallPaper	Wallpaper	text	16	0
50	WllPprDsp	Wallpaper Display	int	6	0		1	1, 2, 3	Allow NULL?
51	AdvImagePr	Extended Image Processing	char	1	0		N	N, O, Y	Allow NULL?
52	ContactLog	Today's Activity Alert	char	1	0		N	N, Y	Allow NULL?
53	LastWarned	Last Warned Date	date	8	0
54	AlertPolFr	Message Check Frequency	int	6	0		5		Allow NULL?
55	ScreenLock	Screen Lock Delay	int	6	0		30		Allow NULL?
56	ShowNewMsg	Open Message on Arrival	char	1	0		Y	N, Y	Allow NULL?
57	Picture	Picture	nvarchar	200	0				Allow NULL?
58	Position	Position	nvarchar	90	0				Allow NULL?
59	Address	Address	nvarchar	100	0				Allow NULL?
60	Country	Country	nvarchar	3	0	OCRY			Allow NULL?
61	Tel1	Telephone 1	nvarchar	20	0				Allow NULL?
62	Tel2	Telephone 2	nvarchar	20	0				Allow NULL?
63	GENDER	Gender	char	1	0		F	F, M	Allow NULL?
64	Birthday	Birthday	date	8	0
65	EnbMenuFlt	Enable Forbidden Menu Items	char	1	0		N	N, Y	Allow NULL?
66	objType	Object Type - History	nvarchar	20	0		12		Allow NULL?
67	logInstanc	Log Instance - History	int	6	0				Allow NULL?
68	userSign	Creating User - History	int	6	0	OUSR			Allow NULL?
69	createDate	Creation Date - History	date	8	0
70	userSign2	Updating User - History	int	6	0	OUSR			Allow NULL?
71	updateDate	Date of Update - History	date	8	0
72	OneLogPwd	At first logon change password	char	1	0		Y	N, Y	Allow NULL?
73	lastLogin	Last Logon Date	date	8	0
74	LastPwds	Last Passwords 1	nvarchar	254	0		0		Allow NULL?
75	LastPwds2	Last Passwords 2	nvarchar	254	0		0		Allow NULL?
76	LastPwdSet	Last Password Change	date	8	0
77	FailedLog	Failed Login Count	int	11	0		0		Allow NULL?
78	PwdNeverEx	Password Never Expires	char	1	0		N	N, Y	Allow NULL?
79	SalesDisc	Max. Sales Discount	num	19	6				Allow NULL?
80	PurchDisc	Max. Purchase Discount	num	19	6				Allow NULL?
81	LstLogoutD	Last Logoff Date	date	8	0
82	LstLoginT	Last Logon Time	int	11	0				Allow NULL?
83	LstLogoutT	Last Logoff Time	int	11	0				Allow NULL?
84	LstPwdChT	Last Password Change Time	int	11	0				Allow NULL?
85	LstPwdChB	Last Password Changed By	nvarchar	8	0				Allow NULL?
86	RclFlag	Display Recurring Transactions	char	1	0		N	N, Y	Allow NULL?
87	MobileUser	Mobile User	char	1	0		N	N, Y	Allow NULL?
88	MobileIMEI	Mobile IMEI	nvarchar	64	0				Allow NULL?
89	PrsWkCntEb	Personal Work Center Enable	char	1	0		N	N, Y	Allow NULL?
90	SnapShotId	Snapshot ID	int	11	0		0		Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	USERID
PASSWORD	No	No	PASSWORD
USER_CODE	No	Yes	USER_CODE
INTERNAL	No	Yes	INTERNAL_K

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

90 COLUMNS | 4 INDEXES | B1 8.82 | OUSR TABLE

TOP B1 8.82 | OUSR COLUMNS

TOP B1 8.82 | OUSR 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

90 COLUMNS | 4 INDEXES | B1 8.82 | OUSR TABLE

TOPB1 8.82 | OUSR COLUMNS

TOPB1 8.82 | OUSR INDEXES

TOP B1 8.82 | OUSR COLUMNS

TOP B1 8.82 | OUSR INDEXES