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 payments subsystem intends to consume collectively.

Column Descriptions:

NameTypeDescription
EDPATMREF_IDBIGINT NOT NULLAtomic Refund unique identifier (generated)
EDPREFINST_IDBIGINTidentifier of the refund instruction in Payment Rules this Atomic Refund object associates to. CMR relationship with RefundInstruction
TOTALAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000total amount of the Atomic Refund
REFUNDINGAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount pending in refund actions
MARKFORDELETEINTEGER NOT NULL DEFAULT 0The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
BACKENDREFUNDIDVARCHAR (64)the associated backend refund object
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
FIELD1DECIMAL (20,5)Customizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EDPATMREF_IDPrimary Key
I0000851EDPREFINST_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1100EDPREFINST_IDEDPREFINSTEDPREFINST_IDCascade