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 Descriptions
| 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
|