PPCPAYTRAN

This table stores the information of a financial transaction processed by a payment plug-in.

Column Descriptions:

NameTypeDescription
PPCPAYTRAN_IDBIGINT NOT NULLThe generated financial transaction identifier
PPCPAYMENT_IDBIGINTThe 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_IDBIGINTThe 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
TRANSACTIONTYPESMALLINT NOT NULLThe type of this financial transaction: 0: APPROVE 1: DEPOSIT 2: APPROVE_AND_DEPOSIT 3: CREDIT 4: REVERSE_APPROVAL 5: REVERSE_DEPOSIT 6: REVERSE_CREDIT
REQUESTEDAMOUNTDECIMAL (20,5) NOT NULLThe requested amount to be processed by this financial transaction
PROCESSEDAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000The processed amount of this financial transaction by the plug-in.
STATESMALLINT NOT NULLThe STATE of this financial transaction: 0: STATE_NEW 1: STATE_PENDING 2: STATE_SUCCESS 3: STATE_FAILED 4: STATE_CANCELED
TIMECREATEDTIMESTAMP NOT NULLThe time when the financial transaction was created
TIMEUPDATEDTIMESTAMP NOT NULLThe time when the financial transaction was updated
MARKFORDELETEINTEGER NOT NULL DEFAULT 0The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
RESPONSECODEVARCHAR (25)The response code received from the backend financial system
REASONCODEVARCHAR (25)The reason code for the response code received from the backend financial system
REFERENCENUMBERVARCHAR (64)The reference number received from the backend financial system, it could be used later in the subsequent transactions
TRACKINGIDVARCHAR (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_IDBIGINTThe 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:

NameColumn NamesType
<SYSTEM-GENERATED>PPCPAYTRAN_IDPrimary Key
I0000924PPCPAYMENT_IDNon-Unique Index
I0000925PPCCREDIT_IDNon-Unique Index
I0001103PPCBATCH_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1172PPCPAYMENT_IDPPCPAYMENTPPCPAYMENT_IDCascade
F_1173PPCCREDIT_IDPPCCREDITPPCCREDIT_IDCascade
F_3478PPCBATCH_IDPPCBATCHPPCBATCH_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1175PPCPAYTRAN_IDPPCEXTDATAPPCPAYTRAN_IDCascade