This table is a container for return merchandise authorizations (RMAs).
Column Descriptions
| Column Name
| Column Type
| Description
|
| RMA_ID
| BIGINT NOT NULL
| Generated unique key.
|
| STORE_ID
| INTEGER NOT NULL
| The ID of the store against which the RMA is being processed.
|
| ORGENTITY_ID
| BIGINT
| The buying organization.
|
| POLICY_ID
| BIGINT
| The ID of the RefundPaymentMethod policy.
|
| MEMBER_ID
| BIGINT NOT NULL
| The member requesting the return. If the RMA was created by a Customer Service Representative, this will be the member who contacted the Customer Service Representative.
|
| TRADING_ID
| BIGINT
| The ID of the trading agreement under which this RMA is being processed. This determines the policies for approval, charges, and refund payment.
|
| FFMCENTER_ID
| INTEGER
| The FulfillmentCenter to which the returned items are to be shipped.
|
| RMADATE
| TIMESTAMP NOT NULL
| The time the RMA was created.
|
| TOTALCREDIT
| DECIMAL (20,5) DEFAULT 0
| The total credit due in the currency specified by the CURRENCY column. If this amount is NULL then the total amount is unknown.
|
| STATUS
| CHAR(3) NOT NULL DEFAULT 'PRC'
| The status of the RMA as follows:
PRC = being edited by a customer
EDT = being edited by a Customer Service Representative
PND = pending)
APP = approved
CLO = closed
CAN = canceled
|
| COMMENTS
| VARCHAR(254)
| Comment that applies to the entire RMA.
|
| LASTUPDATE
| TIMESTAMP NOT NULL
| Timestamp of the last update.
|
| REFUNDAGAINSTORDID
| BIGINT
| The order Id to credit the refund against.
|
| INUSE
| CHAR(1) NOT NULL DEFAULT 'N'
| Used by the WebSphere Commerce Accelerator to mark the record as being used. A CSR opens the Change Returns notebook to edit a return. The INUSE column is set to Y to indicate that this RMA is in use. Once closed, the column is set to N.
|
| CURRENCY
| CHAR(3)
| The currency of all monetary amounts within the RMA. All items added to the RMA will have the same currency value. This is a currency code as per ISO 4217 standards.
|
| PREPARED
| CHAR(1) NOT NULL DEFAULT 'N'
| Specifies whether the ReturnPrepare command was the last command executed against the RMA.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|