Entity Definition

Logical Name : LineItemAssociate
Physical Name : TR_LTM_SL_ASCTE

A modifier that captures the Worker involved in serving the customer purchasing the merchandise or service item identified in the SaleReturnLineItem.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) SaleReturnLineItem(TR_LTM_SLS_RTN)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint SaleReturnLineItem(TR_LTM_SLS_RTN)
ItemSaleAssociateSequenceNumber (PK) A sequential counter used to uniquely identify an instance of a COMMISSION MODIFIER. AI_MDFR_CMN LineNumber smallint
WorkerID (FK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
AssociateActionID (FK) 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)
ActionDatetime The date and time that the associate performed the action for which a commission is payable. TS_ACTN AuditDateTime datetime
CommissionAmount Defines the flat amount of commission earned on the sale of this item MO_CMN Money decimal(16,5)
CommissionPercent Defines the percentage applied to the sold-at retail amount to arrive at the commission for an item or service sold in the SALE/RETURN LINE ITEM. PE_CMN Percent decimal(7,4)
CommissionOverrideFlag A flag denoting that the commission calculation contained in this entity was not made with the normal commission calculation rules. FL_CMN_OVR Flag integer
MethodCode A code denoting the commission calculation method to be used. FL_PE_CMN_AMT Code varchar(20)


Parent Entity Verb Phrase Child Entity
SalesAssociateAction was performed by LineItemAssociate
Worker acted as LineItemAssociate
SaleReturnLineItem was performed by LineItemAssociate

Logical Views containing LineItemAssociate

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02310 - Retail Transaction - Item Sale View
Logical 11100 - Worker - Macro View
Logical 11140 - Worker - Retail Transaction View