Entity Definition

Logical Name : TransactionAssociate
Physical Name : TR_RTL_SL_ASCTE

Records the Worker (other than the Operator of record) involved in conducting the Transaction. e.g. Serving the customer purchasing the merchandise or services identified in a RetailTransaction.

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) Transaction(TR_TRN)
AssociateSequenceNumber (PK) A sequential counter used to uniquely identify the association within the confines of the current RetailTransaction. 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 any items or services sold in the RetailTransaction. PE_CMN Percent decimal(7,4)
MethodCode A code denoting the commission calculation method to be used. FL_PE_CMN_AMT Code varchar(20)


Parent Entity Verb Phrase Child Entity
Transaction was performed by TransactionAssociate
SalesAssociateAction was performed by TransactionAssociate
Worker acted as TransactionAssociate

Logical Views containing TransactionAssociate

Logical View
Logical 02305 - Retail Transaction - Header View
Logical 11120 - Worker - Job Definition View
Logical 11140 - Worker - Retail Transaction View