EDPRMA

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

Column Descriptions:

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

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	EDPRMA_ID	Primary Key
I0000848	STORE_ID+RMA_ID	Non-Unique Index

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1099	EDPRMA_ID	EDPREFINST	EDPRMA_ID	Cascade