This table stores the information of a financial transaction processed by a payment plug-in.
Column Descriptions
| Column Name
| Column 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 finanical 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
| Reserved for IBM internal use.
|
| 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.
|