Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RMATAX
This table stores return merchandise authorization (RMA) tax credits.
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 SQL100520030424700 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
_vcc_freeselect_bottom_