RECEIVABLEPAYMENTCREDITCARD (4.0SP20)

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 that was used when making this payment.

CREDITCARDPARTIALNUMBER

nvarchar(4)

false

Used to store the last few digits of a credit card number for credit card payments.

EXPIRESON

UDT_FUZZYDATE

false

The expiration date of the credit card for a credit card payment.

AUTHORIZATIONCODE

nvarchar(20)

false

The authorization code for a credit card payment, if applicable.

TRANSACTIONID

uniqueidentifier

true

The BBPS transaction ID.

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.

IX_RECEIVABLEPAYMENTCREDITCARD_DATEADDED

False

False

True

IX_RECEIVABLEPAYMENTCREDITCARD_DATECHANGED

False

False

False

PK_RECEIVABLEPAYMENTCREDITCARD

True

True

False

TR_RECEIVABLEPAYMENTCREDITCARD_RECEIVABLEPAYMENTTYPECORRECT

TR_RECEIVABLEPAYMENTCREDITCARD_AUDIT_UPDATE

TR_RECEIVABLEPAYMENTCREDITCARD_AUDIT_DELETE