WebSphere Commerce database table: RMATAX

WebSphere Commerce database table: RMATAX

This table stores return merchandise authorization (RMA) tax credits.
Column Descriptions
Column Name Column Type Description
RMA_ID BIGINT NOT NULL The ID of the RMA for which this tax amount applies.
TAXCGRY_ID INTEGER NOT NULL The TaxCategory.
TAXAMOUNT DECIMAL (20,5) NOT NULL Tax amount in the currency of the RMA.
LASTUPDATE TIMESTAMP NOT NULL Timestamp of the last update.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235245720 RMA_ID+TAXCGRY_ID Primary Key
I0000751 TAXCGRY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_718 RMA_ID RMA RMA_ID Cascade
F_717 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade
Related reference

Order management adjustment and tax data model

Column Name	Column Type	Description
RMA_ID	BIGINT NOT NULL	The ID of the RMA for which this tax amount applies.
TAXCGRY_ID	INTEGER NOT NULL	The TaxCategory.
TAXAMOUNT	DECIMAL (20,5) NOT NULL	Tax amount in the currency of the RMA.
LASTUPDATE	TIMESTAMP NOT NULL	Timestamp of the last update.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL060903235245720	RMA_ID+TAXCGRY_ID	Primary Key
I0000751	TAXCGRY_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_718	RMA_ID	RMA	RMA_ID	Cascade
F_717	TAXCGRY_ID	TAXCGRY	TAXCGRY_ID	Cascade