Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EDPRMA
This table stores the information of the value object container Refund in Payment Rules.
Column Name Column Type Description EDPRMA_ID BIGINT NOT NULL the Refund identifier RMA_ID BIGINT the returns RMA identifier; null when refund information is stored as collateral STORE_ID INTEGER NOT NULL store identifier AMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0.00000 amount to be refunded CURRENCY CHAR(3) NOT NULL currency used when the RMA was created; the assumption is that an RMA is able to handle only one single currency, otherwise the currency should be in the Refund Instruction instead. 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 BLOCKED INTEGER NOT NULL DEFAULT 0 indicates if the RMA is blocked or not; once blocked, the RMA needs to be unblocked to be useable again BGJOBSTATUS INTEGER NOT NULL DEFAULT 0 indicates the status of the task working on a refund action, in background OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use. FIELD1 INTEGER customizable FIELD2 VARCHAR(254) customizable FIELD3 VARCHAR(254) customizable
Indexes Index Name Indexed Column Names Index Type SQL100520030331070 EDPRMA_ID Primary Key I0000848 STORE_ID+RMA_ID Non-Unique Index
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1099 EDPRMA_ID EDPREFINST EDPRMA_ID Cascade _vcc_freeselect_bottom_