biuan SAP® BUSINESS ONE SDK
API AHEM
AHEM - Employees Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
empID KEY UNIQUEEmployee No.Int
11
PRIMARYYes
lastNameLast NamenVarChar
50
firstNameFirst NamenVarChar
50
middleNameMiddle NamenVarChar
50
sexGenderVarChar
F) Female
M) Male
1
M
jobTitleJob TitlenVarChar
20
typeEmployee TypeInt
11OHTY
Employee Types
deptDepartmentInt
6OUDP
Departments
branchBranchInt
6OUBR
Branches
workStreetWork StreetnVarChar
100
workBlockWork BlocknVarChar
100
workZipWork Zip CodenVarChar
20
workCityWork CitynVarChar
100
workCountyWork CountynVarChar
100
workCountrWork CountrynVarChar
3OCRY
Countries
workStateWork StatenVarChar
3
managerManagerInt
11OHEM
Employees
userIdUser IDInt
11OUSR
Users
salesPrsonSales EmployeeInt
11OSLP
Sales Employee
officeTelOffice PhonenVarChar
20
officeExtOffice Ext.nVarChar
20
mobileMobile PhonenVarChar
20
pagerPagernVarChar
20
homeTelHome PhonenVarChar
20
faxFaxnVarChar
20
emailE-MailnVarChar
100
startDateStart DateDate
8
statusStatusInt
11OHST
Employee Status
salarySalaryNum
20
salaryUnitSalary UnitVarChar
H) Hour
D) Day
W) Week
M) Month
Y) Year
S) Semimonthly
B) Biweekly
1
M
emplCostEmployee CostsNum
20
empCostUntEmployee Cost UnitVarChar
H) Hour
D) Day
W) Week
M) Month
Y) Year
1
M
termDateTermination DateDate
8
termReasonTermination ReasonInt
11OHTR
Termination Reason
bankCodeBank CodenVarChar
30ODSC
Bank Codes
bankBranchBank BranchnVarChar
100
bankBranNoBank Branch No.nVarChar
30
bankAcountBank AccountnVarChar
100
homeStreetHome StreetnVarChar
100
homeBlockHome BlocknVarChar
100
homeZipHome Zip CodenVarChar
20
homeCityHome CitynVarChar
100
homeCountyHome CountynVarChar
100
homeCountrHome CountrynVarChar
3OCRY
Countries
homeStateHome StatenVarChar
3
birthDateDate of BirthDate
8
brthCountrCountry of BirthnVarChar
3OCRY
Countries
martStatusMarital StatusVarChar
S) Single
M) Married
D) Divorced
W) Widowed
1
S
nChildrenNo. of ChildrenInt
6
govIDID Issued by AuthoritiesnVarChar
64
citizenshpCitizenshipnVarChar
3OCRY
Countries
passportNoPassport No.nVarChar
64
passportExPassport Expiration DateDate
8
picturePicturenVarChar
127
remarkRemarksText
16
attachmentAttachmentsText
16
salaryCurrSalary CurrencynVarChar
3
empCostCurEmployee Costs CurrencynVarChar
3
WorkBuildWork Building/Floor/RoomText
16
HomeBuildHome Building/Floor/RoomText
16
positionPositionInt
11OHPS
Employee Position
AtcEntryAttachment EntryInt
11
AddrTypeWWork Address TypenVarChar
100
AddrTypeHHome Address TypenVarChar
100
StreetNoWWork Street No.nVarChar
100
StreetNoHHome Street No.nVarChar
100
DispMidNamDisplay Middle NameVarChar
N) No
Y) Yes
1
N
NamePosName Positioning SetVarChar
1) Last Name, First Name
2) First Name, Last Name
1
1
DispCommaDisplay CommaVarChar
N) No
Y) Yes
1
N
CostCenterCost CenternVarChar
8OPRC
Cost Center
CompanyNumCompany NumbernVarChar
20
VacPreYearVacation: Previous YearInt
11
VacCurYearVacation: Current YearInt
11
MunKeyMunicipality KeynVarChar
20
TaxClassTax ClassnVarChar
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
2
0
InTaxLiabiIncome Tax LiabilitynVarChar
0
1) On Tax Card
2) Flat-Rate Tax
3) Cross-Border Employee
4) Not Liable
2
0
EmTaxCCodeReligionnVarChar
0
--) No Church Tax Liability
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 Offenbach/Mainz
IB) (IB) Israelite Religious Community Baden
IL) (IL) Israelite Rural
IS) (IS) Israelite
IW) (IW) Israelite Religious Community Wuerttemberg
JD) (JD) Jewish Religion Tax
JH) (JH) Jewish Religion Tax
JS) (JS) Jewish Religion Tax
LT) (LT) Lutheran
RF) (RF) Reformed
RK) (RK) Roman Catholic
9
0
RelPartnerReligion of PartnernVarChar
0
--) No Church Tax Liability
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 Offenbach/Mainz
IB) (IB) Israelite Religious Community Baden
IL) (IL) Israelite Rural
IS) (IS) Israelite
IW) (IW) Israelite Religious Community Wuerttemberg
JD) (JD) Jewish Religion Tax
JH) (JH) Jewish Religion Tax
JS) (JS) Jewish Religion Tax
LT) (LT) Lutheran
RF) (RF) Reformed
RK) (RK) Roman Catholic
9
0
ExemptAmntExemption AmountNum
20
ExemptUnitExemption Amount PeriodnVarChar
0
1) Yearly
2) Monthly
3) Weekly
4) Daily
20
0
AddiAmntAdditional AmountNum
20
AddiUnitAdditional Amount PeriodnVarChar
0
1) Yearly
2) Monthly
3) Weekly
4) Daily
20
0
TaxONameTax Office NamenVarChar
50
TaxONumTax Office NumbernVarChar
20
HeaInsNameHealth Insurance Company NamenVarChar
50
HeaInsCodeHealth Insurance CodenVarChar
50
HeaInsTypeType of Health InsurancenVarChar
' ')
AOK) (AOK)
IKK) (IKK)
EKK) (EKK)
BKK) (BKK)
BKS) (BKS)
LKK) (LKK)
20
' '
SInsurNumSocial Insurance NumbernVarChar
20
StatusOfPProfessional StatusnVarChar
-1)
0
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 <18 hrs
9) Part Time > 18 Hrs
2
-1
StatusOfEEducational StatusnVarChar
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
2
0
BCodeDateVBank Code for DATEVnVarChar
20
DevBAOwnerDeviating Bank Account OwnerVarChar
Y) Yes
N) No
1
N
FNameSPFirst Name of SpousenVarChar
50
SurnameSPLast Name of SpousenVarChar
50
LogInstancLog InstanceInt
11
0
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
PersGroupPerson GroupnVarChar
-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
997) Not Specified
5
-1
JTCodeJob Title CodenVarChar
5
ExtEmpNoExt. Employee No.nVarChar
20
BirthPlacePlace of BirthnVarChar
100
PymMethPayment MethodnVarChar
-1)
05) Bank Transfer
2
05
ExemptCurrExemption Amount CurrencynVarChar
3
AddiCurrAdditional Amount CurrencynVarChar
3
STDCodeSTD CodeInt
11
FatherNameFather's NamenVarChar
127
CPFPersonal Fiscal IDnVarChar
100
CRCCRC NumbernVarChar
20
ContRespAccountant ResponsibleVarChar
Y) Yes
N) No
1
N
RepLegalLegal RepresentativeVarChar
Y) Yes
N) No
1
N
DirfDeclarDIRF ResponsibleVarChar
Y) Yes
N) No
1
N
UF_CRCCRC StatenVarChar
3
IDTypeID TypenVarChar
30OIDT
Employee ID Type
ActiveEmployee StatusVarChar
Y) Active
N) Inactive
1
Y
BPLIdBranchInt
11OBPL
Business Place
ManualNUMManual EMP No.nVarChar
60
PassIssuePassport Issue DateDate
8
PassIssuerPassport IssuernVarChar
127
QualCodeQualification CodenVarChar
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) Inventariante
313) Liquidante
315) Interventor
801) Empresário
900) Contador
999) Outros
3
000
PRWebAccssEnable Access to PR from WebVarChar
Y) Yes
N) No
1
N
PrePRWebPrevious Stats of PR Web AccessVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT AHEM.empID AS 'Employee No.', AHEM.lastName AS 'Last Name', AHEM.firstName AS 'First Name', AHEM.middleName AS 'Middle Name', AHEM.sex AS 'Gender', AHEM.jobTitle AS 'Job Title', AHEM.type AS 'Employee Type', AHEM.dept AS 'Department', AHEM.branch AS 'Branch', AHEM.workStreet AS 'Work Street', AHEM.workBlock AS 'Work Block', AHEM.workZip AS 'Work Zip Code', AHEM.workCity AS 'Work City', AHEM.workCounty AS 'Work County', AHEM.workCountr AS 'Work Country', AHEM.workState AS 'Work State', AHEM.manager AS 'Manager', AHEM.userId AS 'User ID', AHEM.salesPrson AS 'Sales Employee', AHEM.officeTel AS 'Office Phone', AHEM.officeExt AS 'Office Ext.', AHEM.mobile AS 'Mobile Phone', AHEM.pager AS 'Pager', AHEM.homeTel AS 'Home Phone', AHEM.fax AS 'Fax', AHEM.email AS 'E-Mail', AHEM.startDate AS 'Start Date', AHEM.status AS 'Status', AHEM.salary AS 'Salary', AHEM.salaryUnit AS 'Salary Unit', AHEM.emplCost AS 'Employee Costs', AHEM.empCostUnt AS 'Employee Cost Unit', AHEM.termDate AS 'Termination Date', AHEM.termReason AS 'Termination Reason', AHEM.bankCode AS 'Bank Code', AHEM.bankBranch AS 'Bank Branch', AHEM.bankBranNo AS 'Bank Branch No.', AHEM.bankAcount AS 'Bank Account', AHEM.homeStreet AS 'Home Street', AHEM.homeBlock AS 'Home Block', AHEM.homeZip AS 'Home Zip Code', AHEM.homeCity AS 'Home City', AHEM.homeCounty AS 'Home County', AHEM.homeCountr AS 'Home Country', AHEM.homeState AS 'Home State', AHEM.birthDate AS 'Date of Birth', AHEM.brthCountr AS 'Country of Birth', AHEM.martStatus AS 'Marital Status', AHEM.nChildren AS 'No. of Children', AHEM.govID AS 'ID Issued by Authorities', AHEM.citizenshp AS 'Citizenship', AHEM.passportNo AS 'Passport No.', AHEM.passportEx AS 'Passport Expiration Date', AHEM.picture AS 'Picture', AHEM.remark AS 'Remarks', AHEM.attachment AS 'Attachments', AHEM.salaryCurr AS 'Salary Currency', AHEM.empCostCur AS 'Employee Costs Currency', AHEM.WorkBuild AS 'Work Building/Floor/Room', AHEM.HomeBuild AS 'Home Building/Floor/Room', AHEM.position AS 'Position', AHEM.AtcEntry AS 'Attachment Entry', AHEM.AddrTypeW AS 'Work Address Type', AHEM.AddrTypeH AS 'Home Address Type', AHEM.StreetNoW AS 'Work Street No.', AHEM.StreetNoH AS 'Home Street No.', AHEM.DispMidNam AS 'Display Middle Name', AHEM.NamePos AS 'Name Positioning Set', AHEM.DispComma AS 'Display Comma', AHEM.CostCenter AS 'Cost Center', AHEM.CompanyNum AS 'Company Number', AHEM.VacPreYear AS 'Vacation: Previous Year', AHEM.VacCurYear AS 'Vacation: Current Year', AHEM.MunKey AS 'Municipality Key', AHEM.TaxClass AS 'Tax Class', AHEM.InTaxLiabi AS 'Income Tax Liability', AHEM.EmTaxCCode AS 'Religion', AHEM.RelPartner AS 'Religion of Partner', AHEM.ExemptAmnt AS 'Exemption Amount', AHEM.ExemptUnit AS 'Exemption Amount Period', AHEM.AddiAmnt AS 'Additional Amount', AHEM.AddiUnit AS 'Additional Amount Period', AHEM.TaxOName AS 'Tax Office Name', AHEM.TaxONum AS 'Tax Office Number', AHEM.HeaInsName AS 'Health Insurance Company Name', AHEM.HeaInsCode AS 'Health Insurance Code', AHEM.HeaInsType AS 'Type of Health Insurance', AHEM.SInsurNum AS 'Social Insurance Number', AHEM.StatusOfP AS 'Professional Status', AHEM.StatusOfE AS 'Educational Status', AHEM.BCodeDateV AS 'Bank Code for DATEV', AHEM.DevBAOwner AS 'Deviating Bank Account Owner', AHEM.FNameSP AS 'First Name of Spouse', AHEM.SurnameSP AS 'Last Name of Spouse', AHEM.LogInstanc AS 'Log Instance', AHEM.UserSign AS 'User Signature', AHEM.UserSign2 AS 'Updating User', AHEM.UpdateDate AS 'Update Date', AHEM.PersGroup AS 'Person Group', AHEM.JTCode AS 'Job Title Code', AHEM.ExtEmpNo AS 'Ext. Employee No.', AHEM.BirthPlace AS 'Place of Birth', AHEM.PymMeth AS 'Payment Method', AHEM.ExemptCurr AS 'Exemption Amount Currency', AHEM.AddiCurr AS 'Additional Amount Currency', AHEM.STDCode AS 'STD Code', AHEM.FatherName AS 'Father's Name', AHEM.CPF AS 'Personal Fiscal ID', AHEM.CRC AS 'CRC Number', AHEM.ContResp AS 'Accountant Responsible', AHEM.RepLegal AS 'Legal Representative', AHEM.DirfDeclar AS 'DIRF Responsible', AHEM.UF_CRC AS 'CRC State', AHEM.IDType AS 'ID Type', AHEM.Active AS 'Employee Status', AHEM.BPLId AS 'Branch', AHEM.ManualNUM AS 'Manual EMP No.', AHEM.PassIssue AS 'Passport Issue Date', AHEM.PassIssuer AS 'Passport Issuer', AHEM.QualCode AS 'Qualification Code', AHEM.PRWebAccss AS 'Enable Access to PR from Web', AHEM.PrePRWeb AS 'Previous Stats of PR Web Access' FROM AHEM AS AHEM

Related information


Bank Codes ODSC SQL Table

Business Place OBPL SQL Table

Branches OUBR SQL Table

Countries OCRY SQL Table

Cost Center OPRC SQL Table

Departments OUDP SQL Table

Employee ID Type OIDT SQL Table

Employees OHEM SQL Table

Employee Position OHPS SQL Table

Sales Employee OSLP SQL Table

Employee Status OHST SQL Table

Termination Reason OHTR SQL Table

Employee Types OHTY SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates