CREDITCARD (4.0SP25)

ID

uniqueidentifier

CREDITTYPECODEID

uniqueidentifier

true

The type of credit card used when making a credit card payment.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CARDHOLDERNAME

nvarchar(255)

false

The name on the credit card.

CREDITCARDPARTIALNUMBER

nvarchar(4)

false

Stores the last four digits of a credit card number

EXPIRESON

UDT_FUZZYDATE

false

The expiration date of the credit card.

CREDITCARDTOKEN

uniqueidentifier

true

The token used to identify the card on the BBPS service.

VALIDFROM

UDT_FUZZYDATE

false

The date a credit card is valid from. Only applies for UK credit cards.

ISSUENUMBER

nvarchar(3)

false

The issue number of the credit card. Only applies for UK credit cards.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

ISTRANSIENT

bit

false

Indicates if the card is transient or not.

REGISTEREDFORUPDATES

bit

false

IX_CREDITCARD_CREDITCARDPARTIALNUMBER_EXPIRESON

False

False

False

IX_CREDITCARD_CREDITCARDTOKEN

False

False

False

IX_CREDITCARD_DATEADDED

False

False

True

IX_CREDITCARD_DATECHANGED

False

False

False

IX_CREDITCARD_ID

False

False

False

PK_CREDITCARD

True

True

False

TR_CREDITCARD_AUDIT_UPDATE

TR_CREDITCARD_AUDIT_DELETE

BATCHEVENTSPONSORSHIP

CREDITCARDID

BATCHMEMBERSHIPDUES

CREDITCARDID

BATCHREVENUE

CREDITCARDID

BATCHSPONSORSHIP

CREDITCARDID

CREDITCARDUPDATE

CREDITCARDID

DONATIONBATCH

CREDITCARDID

EVENTSPONSOR

CREDITCARDID

REGISTRANTBATCH

CREDITCARDID

REGISTRANTEXTENSION

CREDITCARDID

REVENUESCHEDULE

CREDITCARDID