CustomerStoredValueAccount

Entity Definition

Logical Name : CustomerStoredValueAccount
Physical Name : LE_CT_STRD_VL_ACNT

A kind of customer account that designates a persistent financial relationship between a customer and a stored value instrument provider. Note that because CustomerStoredValueAccount is modeled here as a SUB-TYPE of CustomerAccount it represents a retailer owned or "house" stored value account where the credit balance carried in the account is a liability of the retailer. This is different from a third party owned stored value account where the liability is owned by the third party not the retailer. In this kind of scenario the retailer may use SVI's like currency but it does not own the liability carried in credit balances. Also, when the retailer sells SVIs it treats it as another item (albeit a non-merchandise item). The StoredValueAccount may have one ore more StoredValueInstruments associated with it.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer
TransactionMaximumSpendLimitAmount The maximum value a customer may use to pay for a single retail transaction. Sets an upper single retail transaction limit on the tender value for a stored valule instrument tied to this account. Example: ABC Gift Card Maximum Spending Limit of $1,000 on any single transaction Keep in mind that this applies to ALL stored value instruments tied to this CustomerStoredValueInstrument. MO_TRN_MXM_SPND_LM_AMT Money decimal(16,5)
TransactionMinimumSpendLimitAmount The minimum value a customer may use to pay for a single retail transaction. Sets an lower single retail transaction limit on the tender value for a stored valule instrument tied to this account. Example: ABC Gift Card Minimum Spending Limit of $1.00 on any single transaction Keep in mind that this applies to ALL stored value instruments tied to this CustomerStoredValueInstrument. MO_TRN_MNM_SPND_LM_AMT Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
CustomerStoredValueAccount is altered by StoredValueTransaction
CustomerStoredValueAccount owns StoredValueInstrument
CustomerStoredValueAccount is updated by StoredValueControlTransaction

Logical Views containing CustomerStoredValueAccount

Logical View
Logical 01420 - Prepaid and Stored Value Payment Instruments
Logical 02500 - Tender Control Transaction - Macro View
Logical 02510 - Tender Control Transaction - Movement View
Logical 07010 - Customer Account Information Extended