This table stores return merchandise authorization (RMA) tax credits.
Column Description(s):
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(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031307200 |
RMA_ID+TAXCGRY_ID |
Primary Key |
I0000751 |
TAXCGRY_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_718 |
RMA_ID |
RMA |
RMA_ID |
Cascade |
F_717 |
TAXCGRY_ID |
TAXCGRY |
TAXCGRY_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.