Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: PPCPAYTRAN

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

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.
PPCBATCH_ID BIGINT No PPCBATCH_ID external description assigned yet

Indexes
Index Name Indexed Column Names Index Type
SQL100520030412830 PPCPAYTRAN_ID Primary Key
I0000924 PPCPAYMENT_ID Non-Unique Index
I0000925 PPCCREDIT_ID Non-Unique Index
I0001103 PPCBATCH_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_3478 PPCBATCH_ID PPCBATCH PPCBATCH_ID Cascade
F_1173 PPCCREDIT_ID PPCCREDIT PPCCREDIT_ID Cascade
F_1172 PPCPAYMENT_ID PPCPAYMENT PPCPAYMENT_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1175 PPCPAYTRAN_ID PPCEXTDATA PPCPAYTRAN_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search