Database Table: RMA

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.
Indexes:
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
Constraints:
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

Referenced By:
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