CashCardPayments Table
The CashCardPayments table in the transactions database contains information about cash card payments that are associated with completed orders.
The following table describes the columns in the CashCardPayments 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 cash card. |
Amount |
money |
no |
The amount of the payment. |
PaymentType |
int |
no |
The type of payment. |
CashCardNumber |
nvarchar(64) |
yes |
A number that is associated with the cash card, for example, the last four digits. |
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. |