📚 SAP Business One SDK Help

Table Name: OSLP

Table Description: Sales Employee

Field Description Type Size Related Default Value Constraints
SlpCode Sales Employee Code Int 11 -      
SlpName Sales Employee Name nVarChar 155 -      
Memo Remarks nVarChar 50 -      
Commission % Commission for Sales Employee Num 19.6 -      
GroupCode Commission Group Int 6 OCOG 0    
Locked Locked VarChar 1 - N Y Yes
            N No
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
UserSign User Signature Int 6 OUSR      
EmpID Employee ID Int 11 OHEM      
Active Active VarChar 1 - Y Y Active
            N Inactive
Telephone Telephone nVarChar 50 -      
Mobil Mobile nVarChar 50 -      
Fax Fax nVarChar 50 -      
Email E-Mail nVarChar 100 -      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
            B Blocked
            U Unblocked
EncryptIV Encrypt IV nVarChar 100 -      
Key Unique Field
PRIMARY Yes SlpCode
SLP_NAME Yes SlpName
COM_GROUP No GroupCode