Database Table: RMATAX

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

Column Name Column Type Column Description
LASTUPDATE TIMESTAMP
NOT NULL
Timestamp of the last update.
RMA_ID BIGINT
NOT NULL
The ID of the RMA for which this tax amount applies.
TAXAMOUNT DECIMAL (20,5)
NOT NULL
Tax amount in the currency of the RMA.
TAXCGRY_ID INTEGER
NOT NULL
The TaxCategory.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035055930 RMA_ID, TAXCGRY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_717 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade
F_718 RMA_ID RMA RMA_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable