biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / General / Commission Groups
API OCOG / Commission Groups
OCOG - Commission Groups Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
GroupCode KEY UNIQUECommission Group CodeInt
6
PRIMARYYes
GroupName KEY UNIQUECommission Group NamenVarChar
30
GROUP_NAMEYes
CommissionCommission PercentageNum
20
PrvComsnPrPrev. Commission in %Num
20
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

Table relationship map

SELECT statement

SELECT OCOG.GroupCode AS 'Commission Group Code', OCOG.GroupName AS 'Commission Group Name', OCOG.Commission AS 'Commission Percentage', OCOG.PrvComsnPr AS 'Prev. Commission in %', OCOG.Locked AS 'Locked', OCOG.DataSource AS 'Data Source', OCOG.UserSign AS 'User Signature' FROM OCOG AS OCOG

Related information


Commission Groups CommissionGroups Object· Table: OCOG
The CommissionGroups object enables to define commission groups for a sales employee, an item, or a customer. Source table: OCOG.

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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates