EDPRMA

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

Column Descriptions:

NameTypeDescription
EDPRMA_IDBIGINT NOT NULLthe Refund identifier
RMA_IDBIGINTthe returns RMA identifier; null when refund information is stored as collateral
STORE_IDINTEGER NOT NULLstore identifier
AMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0.00000amount to be refunded
CURRENCYCHAR (3) NOT NULLcurrency 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.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0The flag indicates whether this object has been marked for deletion. 0: not marked for deletion 1: marked for deletion
BLOCKEDINTEGER NOT NULL DEFAULT 0indicates if the RMA is blocked or not; once blocked, the RMA needs to be unblocked to be useable again
BGJOBSTATUSINTEGER NOT NULL DEFAULT 0indicates the status of the task working on a refund action, in background
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.
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EDPRMA_IDPrimary Key
I0000848STORE_ID+RMA_IDNon-Unique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1099EDPRMA_IDEDPREFINSTEDPRMA_IDCascade