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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search