Entity Definition

Logical Name : RetailTransactionDocumentLineitem
Physical Name : DO_RTL_TRN _DCM_LN_ITM

A subtype of retail transaction line item used to capture the issue of a RetailTransactionDocument to a customer. In ARTS a number of different kinds of RetailTransactionDocuments are supported including: Bounceback Coupons Rebate Claims Reward Vouchers (gift certifcates, stored value cards, etc.) Rainchecks (delayed coupons) As represented in ARTS, retail transaction documents represent a kind of deferrable reward which means it is earned in one transaction and redeemed in a subsequent retail transaction. The document provides an explicit link between a reward "earn" action and a reward "burn" or redemption action when they are executed in separate retail transactions.

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)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
RetailTransactionDocumentActionCode A code that designates the type of document action being taken by a RetailTransactionLineItem. Valid values are: ISSUE REDEEM VOID Retailers may add other actions that are relevant to their business. CD_RTL_TRN_DCM_ACTN Code varchar(20)
RetailTransactionDocumentID (FK) A token identifier for a RetailTransactionDocument instance. ID_RTL_TRN_DCM Identity integer RetailTransactionDocument(DO_RTL_TRN_DCM)


Parent Entity Verb Phrase Child Entity
RetailTransactionDocument is issued or redeemed by RetailTransactionDocumentLineitem

Logical Views containing RetailTransactionDocumentLineitem

Logical View
Logical 02390 - Retail Transaction - Stored Value Instrument