Entity Definition

Logical Name : RaincheckDocument
Physical Name : RNCHK

A raincheck is an assurance of a deferred extension of an offer, especially an assurance that a customer can take advantage of a sale later if the item or service offered is not available (as by being sold out). A raincheck is typically represented as a kind of point of sale printed document that is used to secure the missed discount when it is presented in a subsequent retail transaction. Rainchecks have an expiration date and may allow substitution of other items for the original, out of stock item.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RaincheckID (PK) Token ID to uniquely identify each RainCheckitem. ID_RNCHK Identity integer
RetailTransactionDocumentID (FK)(PK) A token identifier for a RetailTransactionDocument instance. ID_RTL_TRN_DCM Identity integer
SubstituteRaincheckItemAllowedFlag A boolean indicator that if YES means that the original rain check item ID may be substituted with a different item and still take the promised discount. FL_SBST_RNCHK_ALW Flag integer
RaincheckItemRegularSaleslUnitPrice The regular (non-discounted) retail unit selling price for the Raincheck item. MO_RNCHK_ITM_UN_REG_SLS_PRC Money decimal(16,5)
RaincheckItemUnitDiscountAmount The discount amount associated with a raincheck item. For a 10% raincheck discount on a $10 item the value of the discount is $1. MO_RNCHK_ITM_UN_DSC Money decimal(16,5)
RaincheckItemQuantity The count of item retail selling units for the item in this raincheck. QU_RNCHK_ITM Quantity DECIMAL(9,3)
InventoryReservationID A reference to a document that sets aside a quantity of the item that is part of a raincheck. For example a customer wants to purchase 5 sale units of item A with a coupon for 20% off and can't use the coupone because the retailer is out of stock. The retailer issues a raincheck citing the items, quantity, original price and discount to the customer so they can obtain the discount. A week later, the retailer receives the items and reserves 5 sale units to honor its raincheck to the customer. When the customer comes back the stock is available and they can obtain the original discount. ID_INV_RSRVTN Identity integer
RaincheckIssue (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query CD_RNCHK_ISS Code varchar(20) Reason(CO_CD_RSN)
RainCheckUnavailable (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM_UNAVLBL IdentityUUID char(32) Item(AS_ITM)
RaincheckRedeemedFlag A boolean indicator that if set to TRUE means that the Raincheck has been redeemed. FL_RNCHK_RDMD Flag integer


Parent Entity Verb Phrase Child Entity
Reason explains RaincheckDocument
Item unavailability causes RaincheckDocument

No Logical Views for RaincheckDocument