Entity Definition

Logical Name : CreditDebitCardTenderLineItem
Physical Name : TR_LTM_CRDB_CRD_TN

A sub-type of TenderLineItem that records the specifics about a credit or debit card used to settle a transaction.

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
CreditDeibitCardTypeCode A code denoting which kind of card is being accepted. Sample values include: DEBIT CREDIT EBT FLEET OTHER TY_CRD Code6 char(6)
CardIssuerCode The first six digits from the Credit/Debit card. It identifies the bank or other financial institution that issued the debit/credit card used in the transaction. ID_ISSR_TND_CRD Code6 char(6)
AccountNumber The account number appearing on a debit/credit card and identifying the card issuer's customer account to be charged or credited for the transaction. This information must be encrypted. ID_ACNT_DB_CR_CRD Name varchar(40)
CardEntryMethodCode A code that indicates how the credit or debit card information was entered: Eg: swiped (MSR), tapped (contactless RFID card), near field (mobile) or manually keyed. LU_MTH_CRD_ENR Code2AccessControl char(2)
EntrySourceCode A code denoting who entered the card: Merchant or Customer. LU_SCR_ENR Code2 char(2)
PersonalIDRequiredTypeCode Identifies the type of personal identification required to authorize tender. Examples include driver's license, a second credit card, social security card, etc. TY_ID_PRSL_RQ Code2 char(2)
PersonalIDReferenceNumber The identifying number of the driver license or other personal id provided by the customer to verify his/her identity at the point of sale. ID_RFC_PRSL_ID Identity integer
AuthorizationMethodCode 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)
Track1CreditCardBitMap Defines the bit pattern used on track 1 of the magnetic strip on the back of a credit card. DE_TRCK_1_BT_MP BitMap binary(128)
Track2CreditCardBitMap Defines the bit pattern used on track 2 of the magnetic strip on the back of a credit card. DE_TRCK_2_BT_MP BitMap binary(128)
Track3CreditCardBitMap Defines the bit pattern used on track 3 of the magnetic strip on the back of a credit card. DE_TRCK_3_BT BitMap binary(128)
AdjudicationCode A code indicating the result of a request to authorize the use of tender to settle a transaction. LU_ADJN_CRDB Code6 char(6)
CardExpirationDate The expiration date of the Credit or Debit card, as taken from the card in MMYY format. DC_EP_CRD Code4 char(4)
CardHolderName The name of the cardholder, as taken from the card. NM_CRD_HLD Name varchar(40)
CardIssuerSequenceNumber The IssueSequnce number of the credit card being used assigned by the Credit/Debit Card issuer. AI_CRD_ISS Identity integer
CardStartDate The commencement date of the Credit or Debit card, as taken from the card in MMYY format. DT_CRD_SRT Code4 char(4)
ServiceCode The value of the service field from the card. In XML this is referred to as a SecurityCode. The names vary from one credit debit card provider to another. Both are the same thing - a 3-4 digit code used to validate a card at the POS. CD_SV Code4 char(4)
Track4CreditCardBitMap Defines the bit pattern used on track 4 of the magnetic strip on the back of a credit card. BM_CR_CRD_TRK_4 BitMap binary(128)
ReconciliationCode A code used to indicate if thie credit/debit card instance is reconciled or not. CD_RCN Identity integer


Parent Entity Verb Phrase Child Entity
TenderLineItem can be a CreditDebitCardTenderLineItem
CreditDebitCardTenderLineItem can be a FleetManagementCharge
CreditDebitCardTenderLineItem can be a ElectronicBenefitsTransferTender

Logical Views containing CreditDebitCardTenderLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02336 - Retail Transaction - Tender - Authorization View
Logical 07040 - Customer Segment Dependent Behavior