This table is a container for return merchandise authorizations (RMAs).
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. When 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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031305960 | 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 |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_699 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | Cascade |
F_698 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
F_694 | ORGENTITY_ID | ORGENTITY | ORGENTITY_ID | Cascade |
F_695 | POLICY_ID | POLICY | POLICY_ID | Cascade |
F_697 | STORE_ID | STORE | STORE_ID | Cascade |
F_696 | TRADING_ID | TRADING | TRADING_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1119 | RMA_ID | EXCHORDERS | RMA_ID | Cascade |
F_535 | RMA_ID | ORDPAYMTHD | RMA_ID | Cascade |
F_673 | RMA_ID | REFUNDMTHD | RMA_ID | Cascade |
F_700 | RMA_ID | RMAAUTHLOG | RMA_ID | Cascade |
F_702 | RMA_ID | RMACHARGE | RMA_ID | Cascade |
F_713 | RMA_ID | RMAITEM | RMA_ID | Cascade |
F_1193 | RMA_ID | RMASERIAL | RMA_ID | Cascade |
F_718 | RMA_ID | RMATAX | RMA_ID | Cascade |
F_730 | RMA_ID | RTNRECEIPT | RMA_ID | Cascade |
F_881 | RMA_ID | TRDREFAMT | RMA_ID | Cascade |