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	9.3	AHEM	135	1	Employees - History	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	E=Not Specified, F=Female, M=Male	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				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	11	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=Biweekly, D=Day, H=Hour, M=Month, S=Semimonthly, W=Week, Y=Year	Allow NULL?
31	emplCost	Employee Costs	num	19	6				Allow NULL?
32	empCostUnt	Employee Cost Unit	char	1	0		M	D=Day, H=Hour, M=Month, W=Week, Y=Year	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				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=Divorced, M=Married, N=Not Specified, S=Single, W=Widowed	Allow NULL?
49	nChildren	No. of Children	int	6	0				Allow NULL?
50	govID	ID Issued by Authorities	nvarchar	64	0				Allow NULL?
51	citizenshp	Citizenship	nvarchar	3	0	OCRY			Allow NULL?
52	passportNo	Passport No.	nvarchar	64	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=No, Y=Yes	Allow NULL?
68	NamePos	Name Positioning Set	char	1	0		1	1=Last Name, First Name, 2=First Name, Last Name	Allow NULL?
69	DispComma	Display Comma	char	1	0		N	N=No, Y=Yes	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=Tax Class I, 2=Tax Class II, 3=Tax Class III, 4=Tax Class IV, 5=Tax Class V, 6=Tax Class VI	Allow NULL?
76	InTaxLiabi	Income Tax Liability	nvarchar	2	0		0	0, 1=On Tax Card, 2=Flat-Rate Tax, 3=Cross-Border Employee, 4=Not Liable	Allow NULL?
77	EmTaxCCode	Religion	nvarchar	9	0		0	--=No Church Tax Liability, 0, AK=(AK) Old Catholic, EV=(EV) Protestant, FA=(FA) Non-Denomination Alzey, FB=(FB) Non-Denominational Regional Congregation Baden, FG=(FG) Non-Denominational Regional Congregation Palatinate, FM=(FM) Non-Denominational Congregation Mainz, FR=(FR) French-Reformed, FS=(FS) Non-Denominational Congregation Offenba	Allow NULL?
78	RelPartner	Religion of Partner	nvarchar	9	0		0	--=No Church Tax Liability, 0, AK=(AK) Old Catholic, EV=(EV) Protestant, FA=(FA) Non-Denomination Alzey, FB=(FB) Non-Denominational Regional Congregation Baden, FG=(FG) Non-Denominational Regional Congregation Palatinate, FM=(FM) Non-Denominational Congregation Mainz, FR=(FR) French-Reformed, FS=(FS) Non-Denominational Congregation Offenba	Allow NULL?
79	ExemptAmnt	Exemption Amount	num	19	6				Allow NULL?
80	ExemptUnit	Exemption Amount Period	nvarchar	20	0		0	0, 1=Yearly, 2=Monthly, 3=Weekly, 4=Daily	Allow NULL?
81	AddiAmnt	Additional Amount	num	19	6				Allow NULL?
82	AddiUnit	Additional Amount Period	nvarchar	20	0		0	0, 1=Yearly, 2=Monthly, 3=Weekly, 4=Daily	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=(AOK), BKK=(BKK), BKS=(BKS), EKK=(EKK), IKK=(IKK), LKK=(LKK)	Allow NULL?
88	SInsurNum	Social Insurance Number	nvarchar	20	0				Allow NULL?
89	StatusOfP	Professional Status	nvarchar	2	0		-1	-1, 0=Trainee, 1=Worker, 2=Skilled Worker, 3=Supervisor/Foreman, 4=Office Worker, 5=Youth Help/Sheltered Workshop, 6=On Career Advancement Training, 7=Homeworker, 8=Part Time, 9=Part Time > 18 Hrs	Allow NULL?
90	StatusOfE	Educational Status	nvarchar	2	0		0	0, 1=W/o Professional Qualification, 2=W. Professional Qualification, 3=High School w/o Prof. Qualif., 4=High School w. Prof. Qualific., 5=Vocational Qualification, 6=University, 7=Not Possible to Specify	Allow NULL?
91	BCodeDateV	Bank Code for DATEV	nvarchar	20	0				Allow NULL?
92	DevBAOwner	Deviating Bank Account Owner	char	1	0		N	N=No, Y=Yes	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=Subject to Social Insurance, 102=Apprentice, 104=Home Worker, 105=Trainee, 106=Student, 108=Early Retirement, 109=Part-Time Employee, 110=Short-Term Employee, 112=Family Member: Agriculture, 113=Addnl Income: Agriculture, 114=Addnl Income: Seasonal Agriculture, 116=Receiving Compensation Pay, 118=Irregularly Employed, 119=Pensioner	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=Bank Transfer	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=No, Y=Yes	Allow NULL?
111	RepLegal	Legal Representative	char	1	0		N	N=No, Y=Yes	Allow NULL?
112	DirfDeclar	DIRF Responsible	char	1	0		N	N=No, Y=Yes	Allow NULL?
113	UF_CRC	CRC State	nvarchar	3	0				Allow NULL?
114	IDType	ID Type	nvarchar	30	0	OIDT			Allow NULL?
115	Active	Employee Status	char	1	0		Y	N=Inactive, Y=Active	Allow NULL?
116	BPLId	Branch	int	11	0	OBPL			Allow NULL?
117	ManualNUM	Manual EMP No.	nvarchar	60	0				Allow NULL?
118	PassIssue	Passport Issue Date	date	8	0
119	PassIssuer	Passport Issuer	nvarchar	254	0				Allow NULL?
120	QualCode	Qualification Code	nvarchar	3	0		000	000=n/a, 203=Diretor, 204=Conselheiro de Administração, 205=Administrador, 206=Administrador do Grupo, 207=Administrador de Sociedade Filiada, 220=Administrador Judicial - Pessoa Fisica, 222=Administrador Judicial - Pessoa Juridica - profissional responsável, 223=Administrador Judicial / Gestor, 226=Gestor Judicial, 309=Procurador, 312=Inv	Allow NULL?
121	PRWebAccss	Enable Access to PR from Web	char	1	0		N	N=No, Y=Yes	Allow NULL?
122	PrePRWeb	Previous Stats of PR Web Access	char	1	0		N	N=No, Y=Yes	Allow NULL?
123	BPLink	BP Link	nvarchar	15	0	OCRD			Allow NULL?
124	NaturalPer	Natural Person	char	1	0		N	N=No, Y=Yes	Allow NULL?
125	DPPStatus	Data Protection Status	char	1	0		N	B=Blocked, D=Erased, N=None, U=Unblocked	Allow NULL?
126	EnRligion	Encryption of Religion	text	16	0
127	EnRligionP	Encryption of Religion Partner	text	16	0
128	EncryptIV	Encrypt IV	nvarchar	100	0				Allow NULL?
129	EnGovID	Encryption of Government ID	text	16	0
130	EnPassport	Encryption of Passport No.	text	16	0
131	CreateDate	Creation Date	date	8	0
132	CreateTS	Creation Time Incl. Sec.	int	11	0				Allow NULL?
133	UpdateTS	Update Full Time	int	11	0				Allow NULL?
134	EnInsurNum	Encryption of Social Insurance No.	text	16	0
135	EnBnkAcct	Encryption of Bank Account	text	16	0

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

135 COLUMNS | 1 INDEXES | B1 9.3 | AHEM TABLE

TOP B1 9.3 | AHEM COLUMNS

TOP B1 9.3 | AHEM 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

135 COLUMNS | 1 INDEXES | B1 9.3 | AHEM TABLE

TOPB1 9.3 | AHEM COLUMNS

TOPB1 9.3 | AHEM INDEXES

TOP B1 9.3 | AHEM COLUMNS

TOP B1 9.3 | AHEM INDEXES