The Order Payment Method table contains order payment or refund methods selected for an order. It is also used to keep track of the actual amount charged or refunded against the order.
Column Description(s):
Column Name | Column Type | Description |
PAYMETHOD |
CHAR(5) NOT NULL |
The order payment method up to 5 characters. If WebSphere Commerce Payments is used to process payment for the Order this column holds the word "PSRVR". "LOC" is used to indicate payment using CreditLine. |
ORDERS_ID |
BIGINT NOT NULL |
Order ID. Foreign key to the ORDERS table. |
PAYDEVICE |
BINARY NOT NULL |
The payment device identifier. The default DoPayment implementation stores the credit card number in this column. The number will be encrypted if PDIEncrypt is set to "on" in the WebSphere Commerce configuration file. |
STARTDATE |
TIMESTAMP |
The start date. DoPayment implementation may use this for its own purpose. (This column is not used by the default DoPayment implementation.) |
REFUNDNUMBER |
BIGINT NOT NULL DEFAULT 0 |
Refund number if this entry represents a refund entry. (For refund, use the return merchandise authorization (RMA) ID as the refund number.) |
TRADING_ID |
BIGINT |
ID for the Trading Agreement. Usually used for Refund entries only. Foreign key to the Trading table. |
ACCOUNT_ID |
BIGINT |
The ID of the business account. Foreign key to the ACCOUNT table. |
RMA_ID |
BIGINT |
The return merchandise authorization (RMA) ID for the refund against this order. Foreign key to the RMA table. |
POLICY_ID |
BIGINT |
The payment policy ID which identifies the payment policy used for this purchase. |
PAYSUMMARY_ID |
BIGINT |
Identifies the payment summary entry that this payment is part of. This field is updated when the Payment Summary entry is created by running the PaymentSummaryGenerate command. |
ENDDATE |
TIMESTAMP |
The end date. The default DoPayment implementation uses this column to hold the credit card expiry date. |
BUYERPO_ID |
BIGINT |
ID of the BuyerPO representing the buyer purchase order number specified for the Order. Foreign key to the BUYERPO table. |
MAXAMOUNT |
DECIMAL (20,5) |
Payment maximum authorization amount. |
CREDITLINE_ID |
BIGINT |
ID of the credit line to track charges for purchases that have PayMethod equals "LOC". Foreign key to the CREDITLINE table. |
ACTUALAMOUNT |
DECIMAL (20,5) |
Actual amount deposited or refunded for this order. For refunds, this amount is negative. This amount is in the same currency as the Order. |
CHARGEAMOUNT |
DECIMAL (20,5) |
The actual amount converted to the default currency of the store. |
CHARGETIME |
TIMESTAMP |
Time charge amount was updated. |
CHARGEAMTCURR |
CHAR(3) |
Currency for the CHARGEAMOUNT column. This is a currency code as per ISO 4217 standards. |
XMLDATA |
CLOB |
The Order XML generated at payment deposit time. (Used by the default DebitAccount task command implementation.) |
STRINGFIELD1 |
VARCHAR(254) |
Reserved for IBM internal use. |
STRINGFIELD2 |
VARCHAR(254) |
Reserved for IBM internal use. |
STRINGFIELD3 |
VARCHAR(254) |
Reserved for IBM internal use. |
STRINGFIELD4 |
VARCHAR(254) |
Reserved for IBM internal use. |
STATUS |
INTEGER DEFAULT 0 |
Reserved for IBM internal use. |
BIGINTFIELD1 |
BIGINT |
Reserved for IBM internal use. |
BIGINTFIELD2 |
BIGINT |
Reserved for IBM internal use. |
BIGINTFIELD3 |
BIGINT |
Reserved for IBM internal use. |
DECIMALFIELD1 |
DECIMAL (20,5) |
Reserved for IBM internal use. |
DECIMALFIELD2 |
DECIMAL (20,5) |
Reserved for IBM internal use. |
DECIMALFIELD3 |
DECIMAL (20,5) |
Reserved for IBM internal use. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |