| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Administration / Setup / General / Sales Employees API OSLP / Sales Persons | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OSLP - Sales Employee Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationSales 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 |