WebSphere Commerce database table: ORDPAYMTHD

WebSphere Commerce database table: ORDPAYMTHD

This table is deprecated and is provided for backward compatibility only. 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 Descriptions
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235222590 ORDERS_ID+PAYMETHOD+PAYDEVICE+REFUNDNUMBER Primary Key
I0000664 CREDITLINE_ID Non-Unique Index
I0000665 TRADING_ID Non-Unique Index
I0000666 BUYERPO_ID Non-Unique Index
I0000667 PAYSUMMARY_ID Non-Unique Index
I0000668 POLICY_ID Non-Unique Index
I0000669 RMA_ID Non-Unique Index
I0000670 ACCOUNT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_541 ACCOUNT_ID ACCOUNT ACCOUNT_ID Cascade
F_538 BUYERPO_ID BUYERPO BUYERPO_ID Cascade
F_540 CREDITLINE_ID CREDITLINE CREDITLINE_ID Cascade
F_542 ORDERS_ID ORDERS ORDERS_ID Cascade
F_537 PAYSUMMARY_ID PAYSUMMARY PAYSUMMARY_ID Cascade
F_536 POLICY_ID POLICY POLICY_ID Cascade
F_535 RMA_ID RMA RMA_ID Cascade
F_539 TRADING_ID TRADING TRADING_ID Cascade
Related reference

Payment data model
Order data model

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.

Index Name	Indexed Column Names	Index Type
SQL060903235222590	ORDERS_ID+PAYMETHOD+PAYDEVICE+REFUNDNUMBER	Primary Key
I0000664	CREDITLINE_ID	Non-Unique Index
I0000665	TRADING_ID	Non-Unique Index
I0000666	BUYERPO_ID	Non-Unique Index
I0000667	PAYSUMMARY_ID	Non-Unique Index
I0000668	POLICY_ID	Non-Unique Index
I0000669	RMA_ID	Non-Unique Index
I0000670	ACCOUNT_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_541	ACCOUNT_ID	ACCOUNT	ACCOUNT_ID	Cascade
F_538	BUYERPO_ID	BUYERPO	BUYERPO_ID	Cascade
F_540	CREDITLINE_ID	CREDITLINE	CREDITLINE_ID	Cascade
F_542	ORDERS_ID	ORDERS	ORDERS_ID	Cascade
F_537	PAYSUMMARY_ID	PAYSUMMARY	PAYSUMMARY_ID	Cascade
F_536	POLICY_ID	POLICY	POLICY_ID	Cascade
F_535	RMA_ID	RMA	RMA_ID	Cascade
F_539	TRADING_ID	TRADING	TRADING_ID	Cascade