Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: PPCPAYINST

This table stores the value object Payment Instruction in WebSphere Commerce which contains the detailed information required by plug-ins to process financial transactions. The amount in the payment instruction can be used by plug-ins to determine what is the maximum target amount the WebSphere Commerce Payments intends to consume collectively.

Column Name Column Type Description
PPCPAYINST_ID BIGINT NOT NULL The generated payment instruction identifier
ORDER_ID BIGINT OMS order identifier; null when this payment instruction is not associated to any order
RMA_ID BIGINT The returns' RMA identifier; null when this payment instruction is not associated to any RMA
STORE_ID INTEGER NOT NULL The store identifier to which this payment instruction is associated
AMOUNT DECIMAL (20,5) NOT NULL The maximum amount that will be used on this payment instruction to process Payments/Credits. This is what Payment Rules will expect to use but it could be less than this amount. No more amount is allowed. If Payment Rules wants to use more amount, it must increase the amount by call the editPaymentInstruction API.
APPROVINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all payments with pending approve transactions under this payment instruction
APPROVEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all payments that have been approved under this payment instruction
CREDITINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all credits with pending credit transactions under this payment instruction
CREDITEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all credits that have been credited under this payment instruction
DEPOSITINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all payment with pending deposit tracactions under this payment instruction
DEPOSITEDAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all payment that have been deposited under this payment instruction
RVRSNGAPRVEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all payments with pending reverse approval transactions under this payment instruction
RVRSNGDPSTEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all payments with pending reverse deposit transactions under this payment instruction
RVRSNGCRDTEDAMNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 This is a cumulative value of all credits with pending reverse credit transactions under this payment instruction
TIMECREATED TIMESTAMP NOT NULL The time when the payment instruction was created
TIMEUPDATED TIMESTAMP NOT NULL The time when the payment instruction was updated
CURRENCY CHAR(3) NOT NULL The currency used when the order was placed
STATE SMALLINT NOT NULL DEFAULT 0 The state of this payment instruction:
0: STATE_NEW
1: STATE_VALID
2: STATE_INVALID
3: STATE_CLOSED
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 The flag indicates whether this object has been marked for deletion.
0: not marked for deletion
1: marked for deletion
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
PLUGINNAME VARCHAR(64) NOT NULL The plug-in name which is used to process the financial transactions for this payment instruction. This is retrieved from the PaymentSystemPluginMapping.xml when this payment instruction is created
PAYMENTSYSTEMNAME VARCHAR(64) NOT NULL The name of the payment system that is used to process financial transactions for this payment instruction; This name is used to find out the corresponding plug-in for a payment configuration group
ACCOUNTNUMBER VARCHAR(64) The account number for different payment method (Credit Card number, checking account, Gift Certificate number, etc); an empty string means the payment instruction does not contain account numbers.
PAYCONFIGID VARCHAR(64) NOT NULL The payment configuration id which is used by this payment instruction

Indexes
Index Name Indexed Column Names Index Type
SQL100520030412510 PPCPAYINST_ID Primary Key
I0000918 ORDER_ID+MARKFORDELETE Non-Unique Index
I0000919 RMA_ID+MARKFORDELETE Non-Unique Index

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1170 PPCPAYINST_ID PPCCREDIT PPCPAYINST_ID Cascade
F_1174 PPCPAYINST_ID PPCEXTDATA PPCPAYINST_ID Cascade
F_1168 PPCPAYINST_ID PPCPAYMENT PPCPAYINST_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search