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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Administration
1	Business One	8.82	AUSR	90	1	Archive Users - History	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		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 the 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	Default	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 Confirmation	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 Vouchers Ref. Update	char	1	0		N	N, Y	Allow NULL?
40	CdtPrvDays	Vouchers from Last Days	int	11	0		1		Allow NULL?
41	DsplyRates	Display Rates Table on Startup	char	1	0		N	N, Y	Allow NULL?
42	AuImpRates	Import Currency Exchange 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 Scheduled Recurring Postings	char	1	0		N	N, Y	Allow NULL?
45	CheckFiles	Perform Data Check	char	1	0		N	N, Y	Allow NULL?
46	OpenCredit	Open Window for Postdated Credit Vouchers	char	1	0		N	D, N, Y	Allow NULL?
47	CreditDay1	Handle Postdated Credit Day 1	int	6	0		1		Allow NULL?
48	CreditDay2	Handle Postdated Credit 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 (Min.)	int	6	0		5		Allow NULL?
55	ScreenLock	Screen Lock Delay	int	6	0		30		Allow NULL?
56	ShowNewMsg	Display Message/Alert 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	Date of Birth	date	8	0
65	EnbMenuFlt	Enable Forbidden Menu Items	char	1	0		N	N, Y	Allow NULL?
66	objType	Object Type	nvarchar	20	0		12		Allow NULL?
67	logInstanc	Log Instance	int	6	0				Allow NULL?
68	userSign	Creating User	int	6	0	OUSR			Allow NULL?
69	createDate	Creation Date	date	8	0
70	userSign2	Updating User	int	6	0	OUSR			Allow NULL?
71	updateDate	Update Date	date	8	0
72	OneLogPwd	At first logon change password	char	1	0		N	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, 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?

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 | 1 INDEXES | B1 8.82 | AUSR TABLE

TOP B1 8.82 | AUSR COLUMNS

TOP B1 8.82 | AUSR 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 | 1 INDEXES | B1 8.82 | AUSR TABLE

TOPB1 8.82 | AUSR COLUMNS

TOPB1 8.82 | AUSR INDEXES

TOP B1 8.82 | AUSR COLUMNS

TOP B1 8.82 | AUSR INDEXES