📚 SAP Business One SDK Help

Table Name: AHEM

Table Description: Employees - History

Field Description Type Size Related Default Value Constraints
empID Employee No. Int 11 -      
lastName Last Name nVarChar 50 -      
firstName First Name nVarChar 50 -      
middleName Middle Name nVarChar 50 -      
sex Gender VarChar 1 - M F Female
            M Male
            E Not Specified
            * Masked
            I Not Valid for System
jobTitle Job Title nVarChar 20 -      
type Employee Type Int 11 OHTY      
dept Department Int 6 OUDP      
branch Branch Int 6 OUBR      
workStreet Work Street nVarChar 100 -      
workBlock Work Block nVarChar 100 -      
workZip Work Zip Code nVarChar 20 -      
workCity Work City nVarChar 100 -      
workCounty Work County nVarChar 100 -      
workCountr Work Country/Region nVarChar 3 OCRY      
workState Work State nVarChar 3 OCST      
manager Manager Int 11 OHEM      
userId User ID Int 11 OUSR      
salesPrson Sales Employee Int 11 OSLP      
officeTel Office Phone nVarChar 50 -      
officeExt Office Ext. nVarChar 50 -      
mobile Mobile Phone nVarChar 50 -      
pager Pager nVarChar 50 -      
homeTel Home Phone nVarChar 50 -      
fax Fax nVarChar 50 -      
email E-Mail nVarChar 100 -      
startDate Start Date Date 8 -      
status Status Int 11 OHST      
salary Salary Num 19.6 -      
salaryUnit Salary Unit VarChar 1 - M H Hour
            D Day
            W Week
            M Month
            Y Year
            S Semimonthly
            B Biweekly
emplCost Employee Costs Num 19.6 -      
empCostUnt Employee Cost Unit VarChar 1 - M H Hour
            D Day
            W Week
            M Month
            Y Year
termDate Termination Date Date 8 -      
termReason Termination Reason Int 11 OHTR      
bankCode Bank Code nVarChar 30 ODSC      
bankBranch Bank Branch nVarChar 100 -      
bankBranNo Bank Branch No. nVarChar 30 -      
bankAcount Bank Account nVarChar 100 -      
homeStreet Home Street nVarChar 100 -      
homeBlock Home Block nVarChar 100 -      
homeZip Home Zip Code nVarChar 20 -      
homeCity Home City nVarChar 100 -      
homeCounty Home County nVarChar 100 -      
homeCountr Home Country/Region nVarChar 3 OCRY      
homeState Home State nVarChar 3 OCST      
birthDate Date of Birth Date 8 -      
brthCountr Country/Region of Birth nVarChar 3 OCRY      
martStatus Marital Status VarChar 1 - S S Single
            M Married
            D Divorced
            W Widowed
            N Not Specified
nChildren No. of Children Int 6 -      
govID ID Issued by Authorities nVarChar 64 -      
citizenshp Citizenship nVarChar 3 OCRY      
passportNo Passport No. nVarChar 64 -      
passportEx Passport Expiration Date Date 8 -      
picture Picture nVarChar 200 -      
remark Remarks Text 16 -      
attachment Attachments Text 16 -      
salaryCurr Salary Currency nVarChar 3 -      
empCostCur Employee Costs Currency nVarChar 3 -      
WorkBuild Work Building/Floor/Room Text 16 -      
HomeBuild Home Building/Floor/Room Text 16 -      
position Position Int 11 OHPS      
AtcEntry Attachment Entry Int 11 -      
AddrTypeW Work Address Type nVarChar 100 -      
AddrTypeH Home Address Type nVarChar 100 -      
StreetNoW Work Street No. nVarChar 100 -      
StreetNoH Home Street No. nVarChar 100 -      
DispMidNam Display Middle Name VarChar 1 - N N No
            Y Yes
NamePos Name Positioning Set VarChar 1 - 1 1 Last Name, First Name
            2 First Name, Last Name
DispComma Display Comma VarChar 1 - N N No
            Y Yes
CostCenter Cost Center nVarChar 8 OPRC      
CompanyNum Company Number nVarChar 20 -      
VacPreYear Vacation: Previous Year Int 11 -      
VacCurYear Vacation: Current Year Int 11 -      
MunKey Municipality Key nVarChar 20 -      
TaxClass Tax Class nVarChar 2 - 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
InTaxLiabi Income Tax Liability nVarChar 2 - 0 0  
            1 On Tax Card
            2 Flat-Rate Tax
            3 Cross-Border Employee
            4 Not Liable
EmTaxCCode Religion nVarChar 9 - 0 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
RelPartner Religion of Partner nVarChar 9 - 0 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
ExemptAmnt Exemption Amount Num 19.6 -      
ExemptUnit Exemption Amount Period nVarChar 20 - 0 0  
            1 Yearly
            2 Monthly
            3 Weekly
            4 Daily
AddiAmnt Additional Amount Num 19.6 -      
AddiUnit Additional Amount Period nVarChar 20 - 0 0  
            1 Yearly
            2 Monthly
            3 Weekly
            4 Daily
TaxOName Tax Office Name nVarChar 50 -      
TaxONum Tax Office Number nVarChar 20 -      
HeaInsName Health Insurance Company Name nVarChar 50 -      
HeaInsCode Health Insurance Code nVarChar 50 -      
HeaInsType Type of Health Insurance nVarChar 20 - ' ' ' '  
            AOK (AOK)
            IKK (IKK)
            EKK (EKK)
            BKK (BKK)
            BKS (BKS)
            LKK (LKK)
SInsurNum Social Insurance Number nVarChar 20 -      
StatusOfP Professional Status nVarChar 2 - -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 <18 hrs
            9 Part Time > 18 Hrs
StatusOfE Educational Status nVarChar 2 - 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
BCodeDateV Bank Code for DATEV nVarChar 20 -      
DevBAOwner Deviating Bank Account Owner VarChar 1 - N Y Yes
            N No
FNameSP First Name of Spouse nVarChar 50 -      
SurnameSP Last Name of Spouse nVarChar 50 -      
LogInstanc Log Instance Int 11 - 0    
UserSign User Signature Int 6 OUSR      
UserSign2 Updating User Int 6 OUSR      
UpdateDate Update Date Date 8 -      
PersGroup Person Group nVarChar 5 - -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
            997 Not Specified
JTCode Job Title Code nVarChar 5 -      
ExtEmpNo Ext. Employee No. nVarChar 20 -      
BirthPlace Place of Birth nVarChar 100 -      
PymMeth Payment Method nVarChar 2 - 05 -1  
            05 Bank Transfer
ExemptCurr Exemption Amount Currency nVarChar 3 -      
AddiCurr Additional Amount Currency nVarChar 3 -      
STDCode STD Code Int 11 -      
FatherName Father's Name nVarChar 150 -      
CPF Personal Fiscal ID nVarChar 100 -      
CRC CRC Number nVarChar 20 -      
ContResp Accountant Responsible VarChar 1 - N Y Yes
            N No
RepLegal Legal Representative VarChar 1 - N Y Yes
            N No
DirfDeclar DIRF Responsible VarChar 1 - N Y Yes
            N No
UF_CRC CRC State nVarChar 3 OCST      
IDType ID Type nVarChar 30 OIDT      
Active Employee Status VarChar 1 - Y Y Active
            N Inactive
BPLId Branch Int 11 OBPL      
ManualNUM Manual EMP No. nVarChar 60 -      
PassIssue Passport Issue Date Date 8 -      
PassIssuer Passport Issuer nVarChar 254 -      
QualCode Qualification Code nVarChar 3 - 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 Inventariante
            313 Liquidante
            315 Interventor
            801 Empres�rio
            900 Contador
            999 Outros
PRWebAccss Enable Access to PR from Web VarChar 1 - N Y Yes
            N No
PrePRWeb Previous Stats of PR Web Access VarChar 1 - N Y Yes
            N No
BPLink BP Link nVarChar 15 OCRD      
NaturalPer Natural Person VarChar 1 - N N No
            Y Yes
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
            B Blocked
            U Unblocked
EnRligion Encryption of Religion Text 16 -      
EnRligionP Encryption of Religion Partner Text 16 -      
EncryptIV Encrypt IV nVarChar 100 -      
EnGovID Encryption of Government ID Text 16 -      
EnPassport Encryption of Passport No. Text 16 -      
CreateDate Creation Date Date 8 -      
CreateTS Creation Time Incl. Sec. Int 11 -      
UpdateTS Update Full Time Int 11 -      
EnInsurNum Encryption of Social Insurance No. Text 16 -      
EnBnkAcct Encryption of Bank Account Text 16 -      
Code Employee Code nVarChar 50 -      
ARetSEFAZ Authorization to Retrieve NFe from SEFAZ VarChar 1 - N N No
            Y Yes
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
            G Fixed Assets Migration
EnSex Encryption of Sex Text 16 -      
SexEx Gender nVarChar 15 OGDR M    
EnSexEx Encryption of SexEx Text 16 -      
Key Unique Field
PRIMARY Yes empID
    LogInstanc