| 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 transactions 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| 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 (512) | 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 |