SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPCH386A/P Invoice
9OPOR386Purchase Order
10OACT114G/L Accounts

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool
Human Resources
1Business One9.2OHEM1224EmployeesHuman Resources
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT empID, lastName, firstName, middleName, sex, jobTitle, type, dept, branch, workStreet, workBlock, workZip, workCity, workCounty, workCountr, workState, manager, userId, salesPrson, officeTel, officeExt, mobile, pager, homeTel, fax, email, startDate, status, salary, salaryUnit, emplCost, empCostUnt, termDate, termReason, bankCode, bankBranch, bankBranNo, bankAcount, homeStreet, homeBlock, homeZip, homeCity, homeCounty, homeCountr, homeState, birthDate, brthCountr, martStatus, nChildren, govID, citizenshp, passportNo, passportEx, picture, remark, attachment, salaryCurr, empCostCur, WorkBuild, HomeBuild, position, AtcEntry, AddrTypeW, AddrTypeH, StreetNoW, StreetNoH, DispMidNam, NamePos, DispComma, CostCenter, CompanyNum, VacPreYear, VacCurYear, MunKey, TaxClass, InTaxLiabi, EmTaxCCode, RelPartner, ExemptAmnt, ExemptUnit, AddiAmnt, AddiUnit, TaxOName, TaxONum, HeaInsName, HeaInsCode, HeaInsType, SInsurNum, StatusOfP, StatusOfE, BCodeDateV, DevBAOwner, FNameSP, SurnameSP, LogInstanc, UserSign, UserSign2, UpdateDate, PersGroup, JTCode, ExtEmpNo, BirthPlace, PymMeth, ExemptCurr, AddiCurr, STDCode, FatherName, CPF, CRC, ContResp, RepLegal, DirfDeclar, UF_CRC, IDType, Active, BPLId, ManualNUM, PassIssue, PassIssuer, QualCode, PRWebAccss, PrePRWeb FROM OHEM


ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1empIDEmployee No.int110 Allow NULL? 
2lastNameLast Namenvarchar500 Allow NULL? 
3firstNameFirst Namenvarchar500 Allow NULL? 
4middleNameMiddle Namenvarchar500 Allow NULL? 
5sexGenderchar10MF=Female, M=Male Allow NULL? 
6jobTitleJob Titlenvarchar200 Allow NULL? 
7typeEmployee Typeint110 Allow NULL? 
8deptDepartmentint60 Allow NULL? 
9branchBranchint60 Allow NULL? 
10workStreetWork Streetnvarchar1000 Allow NULL? 
11workBlockWork Blocknvarchar1000 Allow NULL? 
12workZipWork Zip Codenvarchar200 Allow NULL? 
13workCityWork Citynvarchar1000 Allow NULL? 
14workCountyWork Countynvarchar1000 Allow NULL? 
15workCountrWork Countrynvarchar30 Allow NULL? 
16workStateWork Statenvarchar30 Allow NULL? 
17managerManagerint110 Allow NULL? 
18userIdUser IDint110 Allow NULL? 
19salesPrsonSales Employeeint110 Allow NULL? 
20officeTelOffice Phonenvarchar200 Allow NULL? 
21officeExtOffice Ext.nvarchar200 Allow NULL? 
22mobileMobile Phonenvarchar200 Allow NULL? 
23pagerPagernvarchar200 Allow NULL? 
24homeTelHome Phonenvarchar200 Allow NULL? 
25faxFaxnvarchar200 Allow NULL? 
26emailE-Mailnvarchar1000 Allow NULL? 
27startDateStart Datedate80
28statusStatusint110 Allow NULL? 
29salarySalarynum196 Allow NULL? 
30salaryUnitSalary Unitchar10MB=Biweekly, D=Day, H=Hour, M=Month, S=Semimonthly, W=Week, Y=Year Allow NULL? 
31emplCostEmployee Costsnum196 Allow NULL? 
32empCostUntEmployee Cost Unitchar10MD=Day, H=Hour, M=Month, W=Week, Y=Year Allow NULL? 
33termDateTermination Datedate80
34termReasonTermination Reasonint110 Allow NULL? 
35bankCodeBank Codenvarchar300 Allow NULL? 
36bankBranchBank Branchnvarchar1000 Allow NULL? 
37bankBranNoBank Branch No.nvarchar300 Allow NULL? 
38bankAcountBank Accountnvarchar1000 Allow NULL? 
39homeStreetHome Streetnvarchar1000 Allow NULL? 
40homeBlockHome Blocknvarchar1000 Allow NULL? 
41homeZipHome Zip Codenvarchar200 Allow NULL? 
42homeCityHome Citynvarchar1000 Allow NULL? 
43homeCountyHome Countynvarchar1000 Allow NULL? 
44homeCountrHome Countrynvarchar30 Allow NULL? 
45homeStateHome Statenvarchar30 Allow NULL? 
46birthDateDate of Birthdate80
47brthCountrCountry of Birthnvarchar30 Allow NULL? 
48martStatusMarital Statuschar10SD=Divorced, M=Married, S=Single, W=Widowed Allow NULL? 
49nChildrenNo. of Childrenint60 Allow NULL? 
50govIDID Issued by Authoritiesnvarchar640 Allow NULL? 
51citizenshpCitizenshipnvarchar30 Allow NULL? 
52passportNoPassport No.nvarchar640 Allow NULL? 
53passportExPassport Expiration Datedate80
54picturePicturenvarchar2000 Allow NULL? 
57salaryCurrSalary Currencynvarchar30 Allow NULL? 
58empCostCurEmployee Costs Currencynvarchar30 Allow NULL? 
59WorkBuildWork Building/Floor/Roomtext160
60HomeBuildHome Building/Floor/Roomtext160
61positionPositionint110 Allow NULL? 
62AtcEntryAttachment Entryint110 Allow NULL? 
63AddrTypeWWork Address Typenvarchar1000 Allow NULL? 
64AddrTypeHHome Address Typenvarchar1000 Allow NULL? 
65StreetNoWWork Street No.nvarchar1000 Allow NULL? 
66StreetNoHHome Street No.nvarchar1000 Allow NULL? 
67DispMidNamDisplay Middle Namechar10NN=No, Y=Yes Allow NULL? 
68NamePosName Positioning Setchar1011=Last Name, First Name, 2=First Name, Last Name Allow NULL? 
69DispCommaDisplay Commachar10NN=No, Y=Yes Allow NULL? 
70CostCenterCost Centernvarchar80 Allow NULL? 
71CompanyNumCompany Numbernvarchar200 Allow NULL? 
72VacPreYearVacation: Previous Yearint110 Allow NULL? 
73VacCurYearVacation: Current Yearint110 Allow NULL? 
74MunKeyMunicipality Keynvarchar200 Allow NULL? 
75TaxClassTax Classnvarchar2000, 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? 
76InTaxLiabiIncome Tax Liabilitynvarchar2000, 1=On Tax Card, 2=Flat-Rate Tax, 3=Cross-Border Employee, 4=Not Liable Allow NULL? 
77EmTaxCCodeReligionnvarchar900--=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? 
78RelPartnerReligion of Partnernvarchar900--=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? 
79ExemptAmntExemption Amountnum196 Allow NULL? 
80ExemptUnitExemption Amount Periodnvarchar20000, 1=Yearly, 2=Monthly, 3=Weekly, 4=Daily Allow NULL? 
81AddiAmntAdditional Amountnum196 Allow NULL? 
82AddiUnitAdditional Amount Periodnvarchar20000, 1=Yearly, 2=Monthly, 3=Weekly, 4=Daily Allow NULL? 
83TaxONameTax Office Namenvarchar500 Allow NULL? 
84TaxONumTax Office Numbernvarchar200 Allow NULL? 
85HeaInsNameHealth Insurance Company Namenvarchar500 Allow NULL? 
86HeaInsCodeHealth Insurance Codenvarchar500 Allow NULL? 
87HeaInsTypeType of Health Insurancenvarchar200, AOK=(AOK), BKK=(BKK), BKS=(BKS), EKK=(EKK), IKK=(IKK), LKK=(LKK) Allow NULL? 
88SInsurNumSocial Insurance Numbernvarchar200 Allow NULL? 
89StatusOfPProfessional Statusnvarchar20-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? 
90StatusOfEEducational Statusnvarchar2000, 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? 
91BCodeDateVBank Code for DATEVnvarchar200 Allow NULL? 
92DevBAOwnerDeviating Bank Account Ownerchar10NN=No, Y=Yes Allow NULL? 
93FNameSPFirst Name of Spousenvarchar500 Allow NULL? 
94SurnameSPLast Name of Spousenvarchar500 Allow NULL? 
95LogInstancLog Instanceint1100 Allow NULL? 
96UserSignUser Signatureint60 Allow NULL? 
97UserSign2Updating Userint60 Allow NULL? 
98UpdateDateUpdate Datedate80
99PersGroupPerson Groupnvarchar50-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? 
100JTCodeJob Title Codenvarchar50 Allow NULL? 
101ExtEmpNoExt. Employee No.nvarchar200 Allow NULL? 
102BirthPlacePlace of Birthnvarchar1000 Allow NULL? 
103PymMethPayment Methodnvarchar2005-1, 05=Bank Transfer Allow NULL? 
104ExemptCurrExemption Amount Currencynvarchar30 Allow NULL? 
105AddiCurrAdditional Amount Currencynvarchar30 Allow NULL? 
106STDCodeSTD Codeint110 Allow NULL? 
107FatherNameFather's Namenvarchar1500 Allow NULL? 
108CPFPersonal Fiscal IDnvarchar1000 Allow NULL? 
109CRCCRC Numbernvarchar200 Allow NULL? 
110ContRespAccountant Responsiblechar10NN=No, Y=Yes Allow NULL? 
111RepLegalLegal Representativechar10NN=No, Y=Yes Allow NULL? 
112DirfDeclarDIRF Responsiblechar10NN=No, Y=Yes Allow NULL? 
113UF_CRCCRC Statenvarchar30 Allow NULL? 
114IDTypeID Typenvarchar300 Allow NULL? 
115ActiveEmployee Statuschar10YN=Inactive, Y=Active Allow NULL? 
116BPLIdBranchint110 Allow NULL? 
117ManualNUMManual EMP No.nvarchar600 Allow NULL? 
118PassIssuePassport Issue Datedate80
119PassIssuerPassport Issuernvarchar2540 Allow NULL? 
120QualCodeQualification Codenvarchar30000000=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? 
121PRWebAccssEnable Access to PR from Webchar10NN=No, Y=Yes Allow NULL? 
122PrePRWebPrevious Stats of PR Web Accesschar10NN=No, Y=Yes Allow NULL? 


NAMENoNofirstName, middleName, lastName