GiftCertificatePayments Table
The GiftCertificatePayments table in the transactions database contains information about gift certificate payments that are associated with completed orders.
The following table describes the columns in the GiftCertificatePayments 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 gift certificate. |
Amount |
money |
no |
The amount of the payment. |
PaymentType |
int |
no |
The type of payment. |
ExpirationDate |
datetime |
no |
The date that the gift certificate expires. |
GiftCertificateNumber |
nvarchar(64) |
yes |
The gift certificate number. |
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. |