This table is a container for return merchandise authorizations (RMAs).
Column Name | Column Type | Column Description |
---|---|---|
COMMENTS | VARCHAR (254) NULL |
Comment that applies to the entire RMA. |
CURRENCY | CHARACTER (3) NULL |
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. |
FFMCENTER_ID | INTEGER NULL |
The FulfillmentCenter to which the returned items are to be shipped. |
INUSE | CHARACTER (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. |
LASTUPDATE | TIMESTAMP NOT NULL |
Timestamp of the last update. |
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. |
ORGENTITY_ID | BIGINT NULL |
The buying organization. |
POLICY_ID | BIGINT NULL |
The ID of the RefundPaymentMethod policy. |
PREPARED | CHARACTER (1) NOT NULL, DEFAULT 'N' |
Specifies whether the ReturnPrepare command was the last command executed against the RMA. |
REFUNDAGAINSTORDID | BIGINT NULL |
The order Id to credit the refund against. |
RMADATE | TIMESTAMP NOT NULL |
The time the RMA was created. |
RMA_ID | BIGINT NOT NULL |
Generated unique key. |
STATUS | CHARACTER (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 |
STORE_ID | INTEGER NOT NULL |
The ID of the store against which the RMA is being processed. |
TOTALCREDIT | DECIMAL (20,5) NULL, 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. |
TRADING_ID | BIGINT NULL |
The ID of the trading agreement under which this RMA is being processed. This determines the policies for approval, charges, and refund payment. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000213 | RMA_ID, RMADATE | Non-Unique Index |
I836116 | RMA_ID, STATUS | Non-Unique Index |
SQL030416035053420 | RMA_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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_718 | RMA_ID | RMATAX | RMA_ID | Cascade |
F_730 | RMA_ID | RTNRECEIPT | RMA_ID | Cascade |
F_881 | RMA_ID | TRDREFAMT | RMA_ID | Cascade |