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
Human Resources
1	Business One	8.82	OHEM	116	3	Employees	Human Resources

Column	Field	Description	SQL Type	Length	Decimals	Relation	Default Value	Constraints	SQL Create Statement
1	empID	Employee No.	int	11	0				Allow NULL?
2	lastName	Last Name	nvarchar	50	0				Allow NULL?
3	firstName	First Name	nvarchar	50	0				Allow NULL?
4	middleName	Middle Name	nvarchar	50	0				Allow NULL?
5	sex	Gender	char	1	0		M	F, M	Allow NULL?
6	jobTitle	Job Title	nvarchar	20	0				Allow NULL?
7	type	Employee Type	int	11	0	OHTY			Allow NULL?
8	dept	Department	int	6	0	OUDP			Allow NULL?
9	branch	Branch	int	6	0	OUBR			Allow NULL?
10	workStreet	Work Street	nvarchar	100	0				Allow NULL?
11	workBlock	Work Block	nvarchar	100	0				Allow NULL?
12	workZip	Work Zip Code	nvarchar	20	0				Allow NULL?
13	workCity	Work City	nvarchar	100	0				Allow NULL?
14	workCounty	Work County	nvarchar	100	0				Allow NULL?
15	workCountr	Work Country	nvarchar	3	0	OCRY			Allow NULL?
16	workState	Work State	nvarchar	3	0	OCST			Allow NULL?
17	manager	Manager	int	11	0	OHEM			Allow NULL?
18	userId	User ID	int	11	0	OUSR			Allow NULL?
19	salesPrson	Sales Employee	int	6	0	OSLP			Allow NULL?
20	officeTel	Office Phone	nvarchar	20	0				Allow NULL?
21	officeExt	Office Ext.	nvarchar	20	0				Allow NULL?
22	mobile	Mobile Phone	nvarchar	20	0				Allow NULL?
23	pager	Pager	nvarchar	20	0				Allow NULL?
24	homeTel	Home Phone	nvarchar	20	0				Allow NULL?
25	fax	Fax	nvarchar	20	0				Allow NULL?
26	email	E-Mail	nvarchar	100	0				Allow NULL?
27	startDate	Start Date	date	8	0
28	status	Status	int	11	0	OHST			Allow NULL?
29	salary	Salary	num	19	6				Allow NULL?
30	salaryUnit	Salary Unit	char	1	0		M	B, D, H, M, S, W, Y	Allow NULL?
31	emplCost	Employee Costs	num	19	6				Allow NULL?
32	empCostUnt	Employee Cost Unit	char	1	0		M	D, H, M, W, Y	Allow NULL?
33	termDate	Termination Date	date	8	0
34	termReason	Termination Reason	int	11	0	OHTR			Allow NULL?
35	bankCode	Bank Code	nvarchar	30	0	ODSC			Allow NULL?
36	bankBranch	Bank Branch	nvarchar	100	0				Allow NULL?
37	bankBranNo	Bank Branch No.	nvarchar	30	0				Allow NULL?
38	bankAcount	Bank Account	nvarchar	100	0				Allow NULL?
39	homeStreet	Home Street	nvarchar	100	0				Allow NULL?
40	homeBlock	Home Block	nvarchar	100	0				Allow NULL?
41	homeZip	Home Zip Code	nvarchar	20	0				Allow NULL?
42	homeCity	Home City	nvarchar	100	0				Allow NULL?
43	homeCounty	Home County	nvarchar	100	0				Allow NULL?
44	homeCountr	Home Country	nvarchar	3	0	OCRY			Allow NULL?
45	homeState	Home State	nvarchar	3	0	OCST			Allow NULL?
46	birthDate	Date of Birth	date	8	0
47	brthCountr	Country of Birth	nvarchar	3	0	OCRY			Allow NULL?
48	martStatus	Marital Status	char	1	0		S	D, M, S, W	Allow NULL?
49	nChildren	No. of Children	int	6	0				Allow NULL?
50	govID	ID Issued by Authorities	nvarchar	20	0				Allow NULL?
51	citizenshp	Citizenship	nvarchar	3	0	OCRY			Allow NULL?
52	passportNo	Passport No.	nvarchar	20	0				Allow NULL?
53	passportEx	Passport Expiration Date	date	8	0
54	picture	Picture	nvarchar	200	0				Allow NULL?
55	remark	Remarks	text	16	0
56	attachment	Attachments	text	16	0
57	salaryCurr	Salary Currency	nvarchar	3	0				Allow NULL?
58	empCostCur	Employee Costs Currency	nvarchar	3	0				Allow NULL?
59	WorkBuild	Work Building/Floor/Room	text	16	0
60	HomeBuild	Home Building/Floor/Room	text	16	0
61	position	Position	int	11	0	OHPS			Allow NULL?
62	AtcEntry	Attachment Entry	int	11	0				Allow NULL?
63	AddrTypeW	Work Address Type	nvarchar	100	0				Allow NULL?
64	AddrTypeH	Home Address Type	nvarchar	100	0				Allow NULL?
65	StreetNoW	Work Street No.	nvarchar	100	0				Allow NULL?
66	StreetNoH	Home Street No.	nvarchar	100	0				Allow NULL?
67	DispMidNam	Display Middle Name	char	1	0		N	N, Y	Allow NULL?
68	NamePos	Name Positioning Set	char	1	0		1	1, 2	Allow NULL?
69	DispComma	Display Comma	char	1	0		N	N, Y	Allow NULL?
70	CostCenter	Cost Center	nvarchar	8	0	OPRC			Allow NULL?
71	CompanyNum	Company Number	nvarchar	20	0				Allow NULL?
72	VacPreYear	Vacation: Previous Year	int	11	0				Allow NULL?
73	VacCurYear	Vacation: Current Year	int	11	0				Allow NULL?
74	MunKey	Municipality Key	nvarchar	20	0				Allow NULL?
75	TaxClass	Tax Class	nvarchar	2	0		0	0, 1, 2, 3, 4, 5, 6	Allow NULL?
76	InTaxLiabi	Income Tax Liability	nvarchar	2	0		0	0, 1, 2, 3, 4	Allow NULL?
77	EmTaxCCode	Religion	nvarchar	9	0		0	--, 0, AK, EV, FA, FB, FG, FM, FR, FS, IB, IL, IS, IW, JD, JH, JS, LT, RF, RK	Allow NULL?
78	RelPartner	Religion of Partner	nvarchar	9	0		0	--, 0, AK, EV, FA, FB, FG, FM, FR, FS, IB, IL, IS, IW, JD, JH, JS, LT, RF, RK	Allow NULL?
79	ExemptAmnt	Exemption Amount	num	19	6				Allow NULL?
80	ExemptUnit	Exemption Amount Period	nvarchar	20	0		0	0, 1, 2, 3, 4	Allow NULL?
81	AddiAmnt	Additional Amount	num	19	6				Allow NULL?
82	AddiUnit	Additional Amount Period	nvarchar	20	0		0	0, 1, 2, 3, 4	Allow NULL?
83	TaxOName	Tax Office Name	nvarchar	50	0				Allow NULL?
84	TaxONum	Tax Office Number	nvarchar	20	0				Allow NULL?
85	HeaInsName	Health Insurance Company Name	nvarchar	50	0				Allow NULL?
86	HeaInsCode	Health Insurance Code	nvarchar	50	0				Allow NULL?
87	HeaInsType	Type of Health Insurance	nvarchar	20	0			, AOK, BKK, BKS, EKK, IKK, LKK	Allow NULL?
88	SInsurNum	Social Insurance Number	nvarchar	20	0				Allow NULL?
89	StatusOfP	Professional Status	nvarchar	2	0		-1	-1, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9	Allow NULL?
90	StatusOfE	Educational Status	nvarchar	2	0		0	0, 1, 2, 3, 4, 5, 6, 7	Allow NULL?
91	BCodeDateV	Bank Code for DATEV	nvarchar	20	0				Allow NULL?
92	DevBAOwner	Deviating Bank Account Owner	char	1	0		N	N, Y	Allow NULL?
93	FNameSP	First Name of Spouse	nvarchar	50	0				Allow NULL?
94	SurnameSP	Last Name of Spouse	nvarchar	50	0				Allow NULL?
95	LogInstanc	Log Instance	int	11	0		0		Allow NULL?
96	UserSign	User Signature	int	6	0	OUSR			Allow NULL?
97	UserSign2	Updating User	int	6	0	OUSR			Allow NULL?
98	UpdateDate	Update Date	date	8	0
99	PersGroup	Person Group	nvarchar	5	0		-1	-1, 101, 102, 104, 105, 106, 108, 109, 110, 112, 113, 114, 116, 118, 119, 997	Allow NULL?
100	JTCode	Job Title Code	nvarchar	5	0				Allow NULL?
101	ExtEmpNo	Ext. Employee No.	nvarchar	20	0				Allow NULL?
102	BirthPlace	Place of Birth	nvarchar	100	0				Allow NULL?
103	PymMeth	Payment Method	nvarchar	2	0		05	-1, 05	Allow NULL?
104	ExemptCurr	Exemption Amount Currency	nvarchar	3	0				Allow NULL?
105	AddiCurr	Additional Amount Currency	nvarchar	3	0				Allow NULL?
106	STDCode	STD Code	int	11	0				Allow NULL?
107	FatherName	Father's Name	nvarchar	150	0				Allow NULL?
108	CPF	Personal Fiscal ID	nvarchar	100	0				Allow NULL?
109	CRC	CRC Number	nvarchar	20	0				Allow NULL?
110	ContResp	Accountant Responsible	char	1	0		N	N, Y	Allow NULL?
111	RepLegal	Legal Representative	char	1	0		N	N, Y	Allow NULL?
112	DirfDeclar	DIRF Responsible	char	1	0		N	N, Y	Allow NULL?
113	UF_CRC	CRC State	nvarchar	3	0	OCST			Allow NULL?
114	IDType	ID Type	nvarchar	30	0	OIDT			Allow NULL?
115	Active	Employee Status	char	1	0		Y	N, Y	Allow NULL?
116	BPLid	Business Place ID	int	11	0	OBPL			Allow NULL?

Name	Primary	Unique	Columns
PRIMARY	No	Yes	empID
OUSR	No	No	userId
OSLP	No	No	salesPrson

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

116 COLUMNS | 3 INDEXES | B1 8.82 | OHEM TABLE

TOP B1 8.82 | OHEM COLUMNS

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

116 COLUMNS | 3 INDEXES | B1 8.82 | OHEM TABLE

TOPB1 8.82 | OHEM COLUMNS

TOPB1 8.82 | OHEM INDEXES

TOP B1 8.82 | OHEM COLUMNS

TOP B1 8.82 | OHEM INDEXES