WebSphere Commerce database table: RMATAX

This table stores return merchandise authorization (RMA) tax credits.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
SQL050212031307200 RMA_ID+TAXCGRY_ID Primary Key
I0000751 TAXCGRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_718 RMA_ID RMA RMA_ID Cascade
F_717 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade

Feedback