Entity Definition

Logical Name : GiftCertificate
Physical Name : DO_CF_GF

A certificate (which may be a paper document, magnetic card or other media) with a face monetary value issued by a retailer store for subsequent exchange for merchandise. A GIFT CERTIFICATE when sold to a customer represents a current liability that is carried until the GIFT CERTIFICATE is redeemed or until it is aged to the point where the store declares it invalid/expired.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
IssuingRetailStoreID (FK)(PK) A unique store number reference to identify the RETAIL STORE that issued the GIFT CERTIFICATE. ID_STR_ISSG Identity integer RetailStore(PA_STR_RTL)
GiftCertificateSerialNumber (PK) The serial number that uniquely identifies a GIFT CERTIFICATE. ID_NMB_SRZ_GF_CF IdentityUUID char(32)
GiftCertificateTypeCode (FK) TY_GF_CF Code2 char(2) GiftCertificateClass(CO_CLS_GF_CF)
IssueTypeCode A code to denote how GIFT CERTIFICATEs are issued by the RETAIL STORE, e.g. embossed or printed at the point of sale. TY_ISS_GF_CF Code2 char(2)
IssueDateTimestamp The time and date when the gift certificate was issued by the retail enterprise. TS_ISS_GF_CF AuditDateTime datetime
ActivatedDateTimestamp The time and date when the gift certificate was activated by the retail enterprise TS_ACTV AuditDateTime datetime
ExpirationDate The expiration date when the GIFT CERTIFICATE can no longer be tendered. DC_EP_GF_CF ExpirationDate date
FaceValueAmount The monetary value printed or embossed on the GIFT CERTIFICATE. MO_VL_FC_GF_CF Money decimal(16,5)
UnspentBalanceAmount The monetary value of the unspent amount outstanding on a specific GIFT CERTIFICATE. MO_BLNC_UNSP Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
RetailStore issues GiftCertificate
GiftCertificateClass defines rules governing GiftCertificate
GiftCertificate is sold/issued through GiftCertificateLineItem
GiftCertificate was given as ZCustomerRewardRedemptionLineItem

Logical Views containing GiftCertificate

Logical View
Logical 01010 - Item Description - Subtype View