StoredValueTenderLineItem

Entity Definition

Logical Name : StoredValueTenderLineItem
Physical Name : TR_LTM_VCHR_TND

StoredValueTenderLine item records the debit or credit of monetary value to a StoredValueInstrument within the context of a retail transaction. StoredValueInstrument balances will be reduced by sales and increased by returns.

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
StoredValueInstrumentID (FK) A token ID for a StoredValueInstrument ID_STRD_VL_INSTRMNT Identity integer StoredValueInstrument(DO_STRD_VL_INSTRMNT)
StoredValueInstrumentEntryMethodCode A code that indicates how the StoredValueInstrument information was entered: Eg: swiped (MSR), tapped (contactless RFID card), near field (mobile) or manually keyed. LU_MTH_CRD_ENR Code2AccessControl char(2)
StoredValueEntrySourceCode A code denoting who entered the StoredValueInstrument information for this VoucherTenderLineItem: Merchant or Customer. LU_SCR_ENR Code2 char(2)
StoredValueAuthorizationMethodCode Identifies the method used to authorize tender. Examples include by electronic query, by sales employee visual inspection of customer card and id. LU_MTH_AZN Code4 char(4)
StoredValueAdjudicationCode A code indicating the result of a request to authorize the use of tender to settle a transaction. LU_ADJN_CRDB Code6 char(6)
StoredValueReconciliationCode A code used to indicate if thie credit/debit card instance is reconciled or not. CD_RCN Identity integer

Relationships

Parent Entity Verb Phrase Child Entity
StoredValueInstrument provides funds for StoredValueTenderLineItem
TenderLineItem can be a StoredValueTenderLineItem

Logical Views containing StoredValueTenderLineItem

Logical View
Logical 01420 - Prepaid and Stored Value Payment Instruments
Logical 02300 - Retail Transaction - Macro View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02390 - Retail Transaction - Stored Value Instrument
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 07040 - Customer Segment Dependent Behavior