Database Table: ORDPAYMTHD

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.)
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035022570 ORDERS_ID, PAYMETHOD, PAYDEVICE, REFUNDNUMBER Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable