This table is a container for return merchandise
authorizations (RMAs).
Column Descriptions:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | RMA_ID | Primary Key |
| I0000213 | RMA_ID+RMADATE | Non-Unique Index |
| I0000737 | TRADING_ID | Non-Unique Index |
| I0000738 | POLICY_ID | Non-Unique Index |
| I0000739 | ORGENTITY_ID | Non-Unique Index |
| I0000740 | FFMCENTER_ID | Non-Unique Index |
| I0000741 | MEMBER_ID | Non-Unique Index |
| I0000742 | STORE_ID | Non-Unique Index |
| I836116 | RMA_ID+STATUS | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_694 | ORGENTITY_ID | ORGENTITY | ORGENTITY_ID | Cascade |
| F_695 | POLICY_ID | POLICY | POLICY_ID | Cascade |
| F_696 | TRADING_ID | TRADING | TRADING_ID | Cascade |
| F_697 | STORE_ID | STORE | STORE_ID | Cascade |
| F_698 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
| F_699 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | Cascade |
Referenced By Child Tables: