Entity Definition

Logical Name : CustomerAccountTenderLineItem
Physical Name : TR_LTM_CTAC_TND

A sub-type of TenderLineItem whereby the RetailTransaction is tendered against a CustomerAccountCard or CustomerAccount

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
CustomerAccountID (FK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerAccount(LE_CTAC)
CustomerAccountInvoiceID (FK) A unique system assigned identifier for the CustomerAccountInvoice ID_INVC_CTAC Identity integer CustomerAccountInvoice(DO_INVC_CTAC)
CustomerRepresentativeID (FK) A customer assigned identifier for the Driver fueling the vehicle. ID_CT_RPS Identity integer CustomerAgent(PA_CT_RPS)
CustomerAccountCardID (FK) A 16 digit Credit or Debit card PAN as defined by ISO-7812, uniquely identifying CustomerAccountCard. AI_ACNT_CT_CRD CreditDebitCardPAN varchar(20) CustomerAccountCard(LE_ACNT_CT_CRD)


Parent Entity Verb Phrase Child Entity
CustomerAccountInvoice summarizes charges from CustomerAccountTenderLineItem
CustomerAccountCard is charged to CustomerAccountTenderLineItem
CustomerAccount is charged to CustomerAccountTenderLineItem
CustomerAgent performed CustomerAccountTenderLineItem
CustomerAccountTenderLineItem includes CustomerPurchaseOrder
TenderLineItem can be a CustomerAccountTenderLineItem

Logical Views containing CustomerAccountTenderLineItem

Logical View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02339 - Retail Transaction - Tender - Account View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 07040 - Customer Segment Dependent Behavior
Logical 07200 - Customer Purchase Transaction History View