Entity Definition

Logical Name : CustomerAccountCard
Physical Name : LE_ACNT_CT_CRD

An card or other device used in association with an account.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountCardID (PK) A 16 digit Credit or Debit card PAN as defined by ISO-7812, uniquely identifying CustomerAccountCard. AI_ACNT_CT_CRD CreditDebitCardPAN varchar(20)
ExpirationDate The date and time from which the CustomerAccountCard is no longer valid. DC_EP ExpirationDate date
PrimaryAccountNumber The 16 digit PAN encoded on the Card. ID_ACNT_PRMRY CreditDebitCardPAN varchar(20)
IssueSequenceNumber The 4 digit issue sequence number, usually encoded on track 2 of the card. AI_SQN_ISS Number integer


Parent Entity Verb Phrase Child Entity
CustomerAccountCard is assigned CustomerAccountCardAssignment
CustomerAccountCard is credited with PaymentOnAccountLineItem
CustomerAccountCard is charged to CustomerAccountTenderLineItem

Logical Views containing CustomerAccountCard

Logical View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02339 - Retail Transaction - Tender - Account View
Logical 07010 - Customer Account Information Extended
Logical 07200 - Customer Purchase Transaction History View