biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Sales Employee
DTW Administration / Setup / General / Sales Employees
API OSLP / Sales Persons
OSLP - Sales Employee Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SlpCode KEY UNIQUESales Employee CodeInt
11
PRIMARYYes
SlpName KEY UNIQUESales Employee NamenVarChar
127
SLP_NAMEYes
MemoRemarksnVarChar
50
Commission% Commission for Sales EmployeeNum
20
GroupCode KEYCommission GroupInt
6OCOG
Commission Groups		0COM_GROUPNo
LockedLockedVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
EmpIDEmployee IDInt
11OHEM
Employees
ActiveActiveVarChar
Y) Active
N) Inactive
1
Y
TelephoneTelephonenVarChar
20
MobilMobilenVarChar
50
FaxFaxnVarChar
20
EmailE-MailnVarChar
100

Table relationship map

SELECT statement

SELECT OSLP.SlpCode AS 'Sales Employee Code', OSLP.SlpName AS 'Sales Employee Name', OSLP.Memo AS 'Remarks', OSLP.Commission AS '% Commission for Sales Employee', OSLP.GroupCode AS 'Commission Group', OSLP.Locked AS 'Locked', OSLP.DataSource AS 'Data Source', OSLP.UserSign AS 'User Signature', OSLP.EmpID AS 'Employee ID', OSLP.Active AS 'Active', OSLP.Telephone AS 'Telephone', OSLP.Mobil AS 'Mobile', OSLP.Fax AS 'Fax', OSLP.Email AS 'E-Mail' FROM OSLP AS OSLP

Related information


Sales Persons SalesPersons Object· Table: OSLP
The SalesPersons object enables to define sales employees and their commision percentage. Source table: OSLP.

OSLP SQL Table

Commission Groups OCOG 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