WebSphere Commerce database table: EDPATMREF

This table stores the value object Payment Instruction in WebSphere Commerce which contains the detailed information required by plug-ins to process financial transactions. The amount in the payment instruction can be used by plug-ins to determine what is the maximum target amount the WebSphere Commerce Payments intends to consume collectively.

Column Descriptions
Column Name Column Type Description
EDPATMREF_ID BIGINT NOT NULL Atomic Refund unique identifier (generated)
EDPREFINST_ID BIGINT identifier of the refund instruction in Payment Rules this Atomic Refund object associates to. CMR relationship with RefundInstruction
TOTALAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 total amount of the Atomic Refund
REFUNDINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 amount pending in refund actions
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
BACKENDREFUNDID VARCHAR(64) the associated backend refund object
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
FIELD1 DECIMAL (20,5) Customizable.
FIELD2 DECIMAL (20,5) Customizable.
FIELD3 VARCHAR(254) Customizable.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235152680 EDPATMREF_ID Primary Key
I0000851 EDPREFINST_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1100 EDPREFINST_ID EDPREFINST EDPREFINST_ID Cascade