CreditCardPayments Table
The CreditCardPayments table in the transactions database contains information about credit card payments that are associated with completed orders.
The following table describes the columns in the CreditCardPayments table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
PaymentId |
uniqueidentifier |
no |
The ID of the payment. This is the primary key. |
OrderFormId |
uniqueidentifier |
no |
The ID of the order form that is associated with the payment. This is a foreign key. |
OrderGroupId |
uniqueidentifier |
no |
The ID of the order group that is associated with the payment. |
BillingAddressId |
nvarchar(50) |
yes |
The ID of the billing address that is associated with the payment. |
PaymentMethodId |
uniqueidentifier |
no |
The ID of the payment method. |
PaymentMethodName |
nvarchar(128) |
yes |
The name of the payment method. |
CustomerNameOnPayment |
nvarchar(64) |
yes |
The name of the customer who owns the credit card. |
Amount |
money |
no |
The amount of the payment. |
PaymentType |
int |
no |
The type of payment. |
CreditCardIdentifier |
nvarchar(40) |
yes |
An ID that is associated with the credit card, for example, the last four digits of the credit card number. .gif "Important note") Important Note:
This value is not encrypted.
|
CardType |
nvarchar(40) |
yes |
The type of credit card. |
ExpirationMonth |
int |
no |
The month that the credit card expires. |
ExpirationYear |
int |
no |
The year that the credit card expires. |
ValidationCode |
nvarchar(64) |
yes |
The validation code of the credit card. |
AuthorizationCode |
Nvarchar(255) |
yes |
The authorization code that was provided when the payment was authorized. |
Status |
nvarchar(64) |
yes |
The status of the payment. |
MarshalledData |
image |
yes |
A binary large object (BLOB) that stores a serialized representation of the values of weakly typed indexer properties. |