Reference > Database > WebSphere Commerce database tables > O
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 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 SQL100520030403970 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
_vcc_freeselect_bottom_