RetailTransactionDocument

Entity Definition

Logical Name : RetailTransactionDocument
Physical Name : DO_RTL_TRN_DCM

A paper and/or digital document that is ISSUED or REDEEMED as part of a RetailTransaction.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailTransactionDocumentID (PK) A token identifier for a RetailTransactionDocument instance. ID_RTL_TRN_DCM Identity integer
RetailTransactionDocumentTypeCode Designates a specific kind of retail transaction document that is issued or redeemed within the scope of a retail transaction. Valid values include: BOUNCEBACK_CPN REBATE_CLAIM REWARD_VCHR CD_RTL_TRN__DCM_TYP Code varchar(20)
EffectiveDate Date when a document is active and may be issued or redeemed as part of one or more retail transactions. DC_EF_DT EffectiveDate date
ExpirationDate Date when a document is inactive and may NO LONGER be issued or redeemed as part of one or more retail transactions. DC_EP_DT ExpirationDate date
StatusCode The current state of the RetailTransactionDocument instance. Valid values are: ISSUED REDEEMED VOID CD_STS Code varchar(20)
IssueDate The date a RetailTransactionDocument is issued to a customer. DC_ISS_DT DateCalendar date
RedemptionDate The date a document is redeemed by a customer DC_RDM_DT DateCalendar date
RewardID (FK) A token identifier for a Reward instance. ID_RWD Identity integer Reward(TR_RWD)

Relationships

Parent Entity Verb Phrase Child Entity
Reward is presented to customer as RetailTransactionDocument
RetailTransactionDocument redemption referenced by RetailTransactionLineItemAssociation
RetailTransactionDocument is presented as RetailTransactionDocumentImage
RetailTransactionDocument issuance referenced by RetailTransactionLineItemAssociation
RetailTransactionDocument is issued or redeemed by RetailTransactionDocumentLineitem

Logical Views containing RetailTransactionDocument

Logical View
Logical 02390 - Retail Transaction - Stored Value Instrument