|
|
DTW Administration / Setup / General / Commission Groups
API OCOG / Commission Groups
OCOG - Commission Groups Table
Commission Groups CommissionGroups Object· Table: OCOG
OCOG SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | GroupCode KEY UNIQUE | Commission Group Code | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| GroupName KEY UNIQUE | Commission Group Name | nVarChar | 30 | GROUP_NAME | Yes | |||
| Commission | Commission Percentage | Num | 20 | |||||
| PrvComsnPr | Prev. Commission in % | Num | 20 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR 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
CommissionGroups
Method
Property
CommissionGroupCode
DTW DB
CommissionGroupName
DTW DB
CommissionPercentage
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
