Database Table: RMAITEM

This table stores item information for a return or credit for a return merchandise authorization (RMA).

Column Name Column Type Column Description
ADJUSTMENT DECIMAL (20,5)
NOT NULL, DEFAULT 0
Any adjustment to be made to the credit amount by a Customer Service Representative.
ADJUSTMENTCREDIT DECIMAL (20,5)
NOT NULL, DEFAULT 0
The adjustment, from the original order, to be credited.
CATENTRY_ID BIGINT
NOT NULL
Reserved for IBM internal use.
COMMENTS VARCHAR (254)
NULL
Comment that applies to the RMA item.
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.
CREDITDATE TIMESTAMP
NULL
The date that the credit was initiated.
CURRENCY CHARACTER (3)
NOT NULL
The currency of the monetary amounts specified for this item. This is a currency code as per ISO 4217 standards.
INVQUANTITY INTEGER
NOT NULL, DEFAULT 0
Quantity in inventory units.
ITEMSPC_ID BIGINT
NOT NULL
Identity of the inventory item.
LASTUPDATE TIMESTAMP
NULL
Timestamp of the last update.
MEMBER_ID BIGINT
NOT NULL
The ID of the member who created the RMA item record.
ORDERITEMS_ID BIGINT
NULL
The OrderItem from which the ITEMSPC_ID is from.
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.
REFUNDORREPLACE CHARACTER (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.
RMAITEM_ID BIGINT
NOT NULL
Generated unique key.
RMA_ID BIGINT
NOT NULL
The RMA of which this RMAItem is a part.
RTNREASON_ID INTEGER
NOT NULL
The reason for the item to be returned.
STATUS CHARACTER (3)
NULL, DEFAULT 'PND'
The status of the RMAItem as follows:
PND = pending
APP = automatically approved
MAN = manually approved
TAXAMOUNT DECIMAL (20,5)
NULL
The amount of tax to be refunded, in the currency specified by CURRENCY. If this amount is NULL then the tax amount is unknown.
TOTALCREDIT DECIMAL (20,5)
NOT NULL, DEFAULT 0
Total credit for the RMA Item.
Indexes:
Index Name Indexed Column Names Index Type
I0000215 RMA_ID, RMAITEM_ID Non-Unique Index
I837116 ORDERITEMS_ID, RMAITEM_ID, STATUS, RMA_ID Non-Unique Index
SQL030416035055250 RMAITEM_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
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