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 Name | Column Type | Column Description |
---|---|---|
ACCOUNT_ID | BIGINT NULL |
The ID of the business account. Foreign key to the ACCOUNT table. |
ACTUALAMOUNT | DECIMAL (20,5) NULL |
Actual amount deposited or refunded for this order. For refunds, this amount is negative. This amount is in the same currency as the Order. |
BIGINTFIELD1 | BIGINT NULL |
Reserved for IBM internal use. |
BIGINTFIELD2 | BIGINT NULL |
Reserved for IBM internal use. |
BIGINTFIELD3 | BIGINT NULL |
Reserved for IBM internal use. |
BUYERPO_ID | BIGINT NULL |
ID of the BuyerPO representing the buyer purchase order number specified for the Order. Foreign key to the BUYERPO table. |
CHARGEAMOUNT | DECIMAL (20,5) NULL |
The actual amount converted to the default currency of the store. |
CHARGEAMTCURR | CHARACTER (3) NULL |
Currency for the CHARGEAMOUNT column. This is a currency code as per ISO 4217 standards. |
CHARGETIME | TIMESTAMP NULL |
Time charge amount was updated. |
CREDITLINE_ID | BIGINT NULL |
ID of the credit line to track charges for purchases that have PayMethod equals "LOC". Foreign key to the CREDITLINE table. |
DECIMALFIELD1 | DECIMAL (20,5) NULL |
Reserved for IBM internal use. |
DECIMALFIELD2 | DECIMAL (20,5) NULL |
Reserved for IBM internal use. |
DECIMALFIELD3 | DECIMAL (20,5) NULL |
Reserved for IBM internal use. |
ENDDATE | TIMESTAMP NULL |
The end date. The default DoPayment implementation uses this column to hold the credit card expiry date. |
MAXAMOUNT | DECIMAL (20,5) NULL |
Payment maximum authorization amount. |
ORDERS_ID | BIGINT NOT NULL |
Order ID. Foreign key to the ORDERS table. |
PAYDEVICE | CHARACTER (64) 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. |
PAYMETHOD | CHARACTER (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. |
PAYSUMMARY_ID | BIGINT NULL |
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. |
POLICY_ID | BIGINT NULL |
The payment policy ID which identifies the payment policy used for this purchase. |
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.) |
RMA_ID | BIGINT NULL |
The return merchandise authorization (RMA) ID for the refund against this order. Foreign key to the RMA table. |
STARTDATE | TIMESTAMP NULL |
The start date. DoPayment implementation may use this for its own purpose. (This column is not used by the default DoPayment implementation.) |
STATUS | INTEGER NULL, DEFAULT 0 |
Reserved for IBM internal use. |
STRINGFIELD1 | VARCHAR (254) NULL |
Reserved for IBM internal use. |
STRINGFIELD2 | VARCHAR (254) NULL |
Reserved for IBM internal use. |
STRINGFIELD3 | VARCHAR (254) NULL |
Reserved for IBM internal use. |
STRINGFIELD4 | VARCHAR (254) NULL |
Reserved for IBM internal use. |
TRADING_ID | BIGINT NULL |
ID for the Trading Agreement. Usually used for Refund entries only. Foreign key to the Trading table. |
XMLDATA | LONG VARCHAR NULL |
The Order XML generated at payment deposit time. (Used by the default DebitAccount task command implementation.) |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035022570 | ORDERS_ID, PAYMETHOD, PAYDEVICE, REFUNDNUMBER | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_535 | RMA_ID | RMA | RMA_ID | Cascade |
F_536 | POLICY_ID | POLICY | POLICY_ID | Cascade |
F_537 | PAYSUMMARY_ID | PAYSUMMARY | PAYSUMMARY_ID | Cascade |
F_538 | BUYERPO_ID | BUYERPO | BUYERPO_ID | Cascade |
F_539 | TRADING_ID | TRADING | TRADING_ID | Cascade |
F_540 | CREDITLINE_ID | CREDITLINE | CREDITLINE_ID | Cascade |
F_541 | ACCOUNT_ID | ACCOUNT | ACCOUNT_ID | Cascade |
F_542 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|