This table stores the information of the value object container Refund in Payment Rules.
Column Descriptions
| 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
|