EDPATMREF

This table stores the value object Payment Instruction in HCL 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 payments subsystem intends to consume collectively.

Column Descriptions:

Name	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	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
FIELD1	DECIMAL (20,5)	Customizable.
FIELD2	DECIMAL (20,5)	Customizable.
FIELD3	VARCHAR (254)	Customizable.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	EDPATMREF_ID	Primary Key
I0000851	EDPREFINST_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1100	EDPREFINST_ID	EDPREFINST	EDPREFINST_ID	Cascade