Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EDPRELEASE
This table stores the information of the value object container Release in Payment Rules.
Column Name Column Type Description EDPRELEASE_ID BIGINT NOT NULL unique release in Payment Rules identifier EDPORDER_ID BIGINT CMR relationship with EDPORDER RELEASE_ID BIGINT NOT NULL The identifier of the release this EDPRelease object associates with TOTALAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 total amount of the release RESERVATIONAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 amount of the Release that has been processed during reservePayment calls FINALIZATIONAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 amount of the Release that has been processed during finalizePayment calls RESERVINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 amount of the Release that is being processed by reservePayment BG payment thread or is not ready yet due to pending actions FINALIZINGAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 amount of the Release that is being processed by finalizePayment BG thread or is not ready yet due to pending 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 OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use. REQUESTFINALAMT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 The requested finalization amount. FIELD1 DECIMAL (20,5) customizable FIELD2 DECIMAL (20,5) customizable FIELD3 VARCHAR(254) customizable
Indexes Index Name Indexed Column Names Index Type SQL100520030330610 EDPRELEASE_ID Primary Key I0000847 EDPORDER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1098 EDPORDER_ID EDPORDER EDPORDER_ID Cascade _vcc_freeselect_bottom_