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