PurchaseOrderPayments Table
The PurchaseOrderPayments table in the transactions database contains information about payments made by purchase order that are associated with completed orders.
The following table describes the columns in the PurchaseOrderPayments 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 issued the purchase order. |
Amount |
money |
no |
The amount of the payment. |
PaymentType |
int |
no |
The type of payment. |
PurchaseOrderPaymentNumber |
nvarchar(64) |
yes |
The purchase order number. |
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. |