Reference > Database > WebSphere Commerce database tables > E
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 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 SQL100520030329860 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 _vcc_freeselect_bottom_