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_CLOSEDMARKFORDELETE INTEGER NOT NULL DEFAULT 0 The flag indicates whether this object has been marked for deletion.
0: not marked for deletion
1: marked for deletionOPTCOUNTER 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_