RMAITEM
This table stores item information for a return or credit for a return merchandise authorization (RMA).
Column Descriptions:
Name Type Description RMAITEM_ID BIGINT NOT NULL Generated unique key. RMA_ID BIGINT NOT NULL The RMA of which this RMAItem is a part. CATENTRY_ID BIGINT NOT NULL Reserved for IBM internal use. MEMBER_ID BIGINT NOT NULL The ID of the member who created the RMA item record. ORDERITEMS_ID BIGINT The OrderItem from which the ITEMSPC_ID is from. ITEMSPC_ID BIGINT NOT NULL Identity of the inventory item. RTNREASON_ID INTEGER NOT NULL The reason for the item to be returned. REFUNDORREPLACE CHAR (3) NOT NULL Specifies whether the RMA item will be refunded or replaced: REF (refund) or REP (replace). This affects whether credit is done internally or externally and whether exchange information was gathered. Only REF is valid. CREDITAMOUNT DECIMAL (20,5) NOT NULL DEFAULT 0 The amount of the credit for this item in the currency specified by CURRENCY. If this amount is NULL then the credit amount is unknown. QUANTITY DOUBLE NOT NULL The result of multiplying QUANTITY by CATENTSHIP.NOMINALQUANTITY must be a multiple of CATENTSHIP.QUANTITYMULTIPLE. And represents the actual quantity being purchased, in the unit of measurement specified by CATENTSHIP.QUANTITYMEASURE. CREDITDATE TIMESTAMP The date that the credit was initiated. STATUS CHAR (3) DEFAULT 'PND' The status of the RMAItem as follows:
PND = pending
APP = automatically approved
MAN = manually approved
Note: If a returns request is denied, the status is then still PND.
CURRENCY CHAR (3) NOT NULL The currency of the monetary amounts specified for this item. This is a currency code as per ISO 4217 standards. COMMENTS VARCHAR (254) Comment that applies to the RMA item. TAXAMOUNT DECIMAL (20,5) The amount of tax to be refunded, in the currency specified by CURRENCY. If this amount is NULL then the tax amount is unknown. ADJUSTMENTCREDIT DECIMAL (20,5) NOT NULL DEFAULT 0 The adjustment, from the original order, to be credited. ADJUSTMENT DECIMAL (20,5) NOT NULL DEFAULT 0 Any adjustment to be made to the credit amount by a Customer Service Representative. LASTUPDATE TIMESTAMP Timestamp of the last update. TOTALCREDIT DECIMAL (20,5) NOT NULL DEFAULT 0 Total credit for the RMA Item. INVQUANTITY INTEGER NOT NULL DEFAULT 0 Quantity in inventory units. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> RMAITEM_ID Primary Key I0000215 RMA_ID+RMAITEM_ID Non-Unique Index I0000747 ITEMSPC_ID Non-Unique Index I0000748 MEMBER_ID Non-Unique Index I0000749 CATENTRY_ID Non-Unique Index I0001282 RTNREASON_ID Non-Unique Index I837116 ORDERITEMS_ID+RMAITEM_ID+STATUS+RMA_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_708 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_709 MEMBER_ID MEMBER MEMBER_ID Cascade F_710 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade F_711 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade F_712 RTNREASON_ID RTNREASON RTNREASON_ID Cascade F_713 RMA_ID RMA RMA_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_3471 RMAITEM_ID RMAITEMSERIAL RMAITEM_ID Cascade F_703 RMAITEM_ID RMACHARGE RMAITEM_ID Cascade F_705 RMAITEM_ID RMAIADJCRD RMAITEM_ID Cascade F_706 RMAITEM_ID RMAIDNYRSN RMAITEM_ID Cascade F_716 RMAITEM_ID RMAITEMCMP RMAITEM_ID Cascade
Related reference
Order management adjustment and tax data model
Order management - receipt and disposition data model
Order management - RMA data model
Order management - RMAitem data model