Entity Definition

Logical Name : WorkerCommissionPlanItem
Physical Name : CO_PLN_EM_CMN_ITM

Defines the percentage of sales the Worker receives when performing the assigned SalesAssociateAction of an item in the assigned MerchandiseHierarchyGroup

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EmployeeCommissionPlanID (FK)(PK) A unique reference number for an employee's commission plan. This may be the employee's payroll number. ID_PLN_EM_CMN Code4 char(4) WorkerCommissionPlan(CO_PLN_EM_CMN)
MerchandiseHierarchyGroupID (FK)(PK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)
AssociateActionID (FK)(PK) A unique system assigned identifier for an action that is performed by a Worker while assisting a customer purchasing the merchandise or services. ID_ACTN_ASCTE Code2 char(2) SalesAssociateAction(CO_SLS_ASCTE_ACTN)
CommissionPercent The percentage of the Item's actual selling price that the Worker receives as part of their CommissionPlan. PE_CMN Percent decimal(7,4)
CommissionAmount A fixed monetary amount a Worker receives as part of their CommissionPlan. MO_CMN Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
MerchandiseHierarchyGroup defines WorkerCommissionPlanItem
WorkerCommissionPlan includes WorkerCommissionPlanItem
SalesAssociateAction defines WorkerCommissionPlanItem

Logical Views containing WorkerCommissionPlanItem

Logical View
Logical 02310 - Retail Transaction - Item Sale View
Logical 11100 - Worker - Macro View
Logical 11120 - Worker - Job Definition View
Logical 11140 - Worker - Retail Transaction View