WebSphere Commerce database table: ORDADJTXEX
Each row of this table indicates that an OrderAdjustment is exempt from taxation of a particular TaxCategory. For example, an "after tax rebate" can be represented as a negative OrderAdjustment that is exempt from taxation of all TaxCategories.
Column Descriptions
| Column Name
| Column Type
| Description |
| ORDADJUST_ID
| BIGINT NOT NULL
| The OrderAdjustment.
|
| TAXCGRY_ID
| INTEGER NOT NULL
| The TaxCategory.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235218200
| ORDADJUST_ID+TAXCGRY_ID
| Primary Key
|
| I0000633
| TAXCGRY_ID
| Non-Unique Index
|
Constraints
| Constraint Name
| Column Names
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_488
| ORDADJUST_ID
| ORDADJUST
| ORDADJUST_ID
| Cascade
|
| F_489
| TAXCGRY_ID
| TAXCGRY
| TAXCGRY_ID
| Cascade
|
Related reference