This table stores the information of a financial
transaction processed by a payment plug-in.
Column Descriptions:
| Name | Type | Description |
| PPCPAYTRAN_ID | BIGINT NOT NULL | The generated financial transaction
identifier |
| PPCPAYMENT_ID | BIGINT | The identifier of the payment under which this
financial transaction is created. null when this transaction is a
transaction for an independent credit. This column represents the
CMR relationship with PPCPAYMENT |
| PPCCREDIT_ID | BIGINT | The identifier of the credit under which this
financial transaction is created. Null when the transaction is
payment related. This column represents the CMR relationship with
PPCCREDIT |
| TRANSACTIONTYPE | SMALLINT NOT NULL | The type of this financial transaction:
0: APPROVE
1: DEPOSIT
2: APPROVE_AND_DEPOSIT
3: CREDIT
4: REVERSE_APPROVAL
5: REVERSE_DEPOSIT
6: REVERSE_CREDIT |
| REQUESTEDAMOUNT | DECIMAL (20,5) NOT NULL | The requested amount to be processed by this
financial transaction |
| PROCESSEDAMOUNT | DECIMAL (20,5) NOT NULL DEFAULT 0.00000 | The processed amount of this financial
transaction by the plug-in. |
| STATE | SMALLINT NOT NULL | The STATE of this financial transaction:
0: STATE_NEW
1: STATE_PENDING
2: STATE_SUCCESS
3: STATE_FAILED
4: STATE_CANCELED |
| TIMECREATED | TIMESTAMP NOT NULL | The time when the financial transaction was
created |
| TIMEUPDATED | TIMESTAMP NOT NULL | The time when the financial transaction was
updated |
| 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. |
| RESPONSECODE | VARCHAR (25) | The response code received from the backend
financial system |
| REASONCODE | VARCHAR (25) | The reason code for the response code received
from the backend financial system |
| REFERENCENUMBER | VARCHAR (64) | The reference number received from the backend
financial system, it could be used later in the subsequent
transactions |
| TRACKINGID | VARCHAR (64) | The identifier generated by the plug-in for this
financial transaction. Plug-in will generate this value on behalf
of the merchant for tracking purpose. |
| PPCBATCH_ID | BIGINT | The batch ID of this payment transaction
referring to, and if it does not refer to any batch objects, then
this column is null. This column is the foreign key referring to
PPCBATCH. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | PPCPAYTRAN_ID | Primary Key |
| I0000924 | PPCPAYMENT_ID | Non-Unique Index |
| I0000925 | PPCCREDIT_ID | Non-Unique Index |
| I0001103 | PPCBATCH_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1172 | PPCPAYMENT_ID | PPCPAYMENT | PPCPAYMENT_ID | Cascade |
| F_1173 | PPCCREDIT_ID | PPCCREDIT | PPCCREDIT_ID | Cascade |
| F_3478 | PPCBATCH_ID | PPCBATCH | PPCBATCH_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1175 | PPCPAYTRAN_ID | PPCEXTDATA | PPCPAYTRAN_ID | Cascade |