Entity Definition

Logical Name : WorkerCommissionPlan
Physical Name : CO_PLN_EM_CMN

A plan for compensating employees for sales they make to customers.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EmployeeCommissionPlanID (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)
Description A textual description of the type of employee's commission plan DE_PLN_EM_CMN DescriptionShort varchar(255)
FinancialLedgerAccountID (FK) The reference for the FinancialLedgeraAccount ID_ACNT_LDG Identity integer FinancialLedgerAccount(CO_LE_ACNT_FN)


Parent Entity Verb Phrase Child Entity
FinancialLedgerAccount defines the accounting disposition of WorkerCommissionPlan
WorkerCommissionPlan includes WorkerCommissionPlanItem
WorkerCommissionPlan defines commission for Position

Logical Views containing WorkerCommissionPlan

Logical View
Logical 02310 - Retail Transaction - Item Sale View
Logical 04000 - Financial Ledger - Macro View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 11100 - Worker - Macro View
Logical 11120 - Worker - Job Definition View