Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RMA
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...
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.
Indexes Index Name Indexed Column Names Index Type SQL100520030423370 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
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names 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_718 RMA_ID RMATAX RMA_ID Cascade F_730 RMA_ID RTNRECEIPT RMA_ID Cascade F_881 RMA_ID TRDREFAMT RMA_ID Cascade
- Order management - RMA data model
- Order management - RMAitem data model
- Order management adjustment and tax data model
- Order management - receipt and disposition data model