EDPRELEASE

This table stores the information of the value object container Release in Payment Rules.

Column Descriptions:

NameTypeDescription
EDPRELEASE_IDBIGINT NOT NULLunique release in Payment Rules identifier
EDPORDER_IDBIGINTCMR relationship with EDPORDER
RELEASE_IDBIGINT NOT NULLThe identifier of the release this EDPRelease object associates with
TOTALAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000total amount of the release
RESERVATIONAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of the Release that has been processed during reservePayment calls
FINALIZATIONAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of the Release that has been processed during finalizePayment calls
RESERVINGAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of the Release that is being processed by reservePayment BG payment thread or is not ready yet due to pending actions
FINALIZINGAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount of the Release that is being processed by finalizePayment BG thread or is not ready yet due to pending 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
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.
REQUESTFINALAMTDECIMAL (20,5) NOT NULL DEFAULT 0.00000The requested finalization amount.
FIELD1DECIMAL (20,5)Customizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EDPRELEASE_IDPrimary Key
I0000847EDPORDER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1098EDPORDER_IDEDPORDEREDPORDER_IDCascade