RMA

This table is a container for return merchandise authorizations (RMAs).

Column Descriptions:

NameTypeDescription
RMA_IDBIGINT NOT NULLGenerated unique key.
STORE_IDINTEGER NOT NULLThe ID of the store against which the RMA is being processed.
ORGENTITY_IDBIGINTThe buying organization.
POLICY_IDBIGINTThe ID of the RefundPaymentMethod policy.
MEMBER_IDBIGINT NOT NULLThe 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_IDBIGINTThe ID of the trading agreement under which this RMA is being processed. This determines the policies for approval, charges, and refund payment.
FFMCENTER_IDINTEGERThe FulfillmentCenter to which the returned items are to be shipped.
RMADATETIMESTAMP NOT NULLThe time the RMA was created.
TOTALCREDITDECIMAL (20,5) DEFAULT 0The total credit due in the currency specified by the CURRENCY column. If this amount is NULL then the total amount is unknown.
STATUSCHAR (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
COMMENTSVARCHAR (254)Comment that applies to the entire RMA.
LASTUPDATETIMESTAMP NOT NULLTimestamp of the last update.
REFUNDAGAINSTORDIDBIGINTThe order Id to credit the refund against.
INUSECHAR (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.
CURRENCYCHAR (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.
PREPAREDCHAR (1) NOT NULL DEFAULT 'N'Specifies whether the ReturnPrepare command was the last command executed against the RMA.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RMA_IDPrimary Key
I0000213RMA_ID+RMADATENon-Unique Index
I0000737TRADING_IDNon-Unique Index
I0000738POLICY_IDNon-Unique Index
I0000739ORGENTITY_IDNon-Unique Index
I0000740FFMCENTER_IDNon-Unique Index
I0000741MEMBER_IDNon-Unique Index
I0000742STORE_IDNon-Unique Index
I836116RMA_ID+STATUSNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_694ORGENTITY_IDORGENTITYORGENTITY_IDCascade
F_695POLICY_IDPOLICYPOLICY_IDCascade
F_696TRADING_IDTRADINGTRADING_IDCascade
F_697STORE_IDSTORESTORE_IDCascade
F_698MEMBER_IDMEMBERMEMBER_IDCascade
F_699FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1119RMA_IDEXCHORDERSRMA_IDCascade
F_535RMA_IDORDPAYMTHDRMA_IDCascade
F_673RMA_IDREFUNDMTHDRMA_IDCascade
F_700RMA_IDRMAAUTHLOGRMA_IDCascade
F_702RMA_IDRMACHARGERMA_IDCascade
F_713RMA_IDRMAITEMRMA_IDCascade
F_718RMA_IDRMATAXRMA_IDCascade
F_730RMA_IDRTNRECEIPTRMA_IDCascade
F_881RMA_IDTRDREFAMTRMA_IDCascade