Reference > Database > WebSphere Commerce database tables > O
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 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 SQL100520030359740 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
_vcc_freeselect_bottom_