WebSphere Commerce database table: CHARGETYPE

Charge or credit applied against a transaction which is not for product. Examples include expedite fees, customization fees, and restocking fees.

Column Descriptions
Column Name Column Type Description
CHARGETYPE_ID INTEGER NOT NULL Generated unique key.
STOREENT_ID INTEGER NOT NULL The Store Entity that uses this Charge Type.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if this Charge Type has been marked for deletion:
0 = No.
1 = Yes.
DISPLAYAGGREGATED CHAR(1) NOT NULL A suggestion to the GUI to aggregate the charge or credit into the appropriate transaction or transaction item for display purposes. Charges or credits are stored individually to facilitate tax calculations.
CODE CHAR(10) NOT NULL Code used for referencing this Charge Type.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000071 STOREENT_ID+CODE Unique Index
SQL060903235140510 CHARGETYPE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_233 STOREENT_ID STOREENT STOREENT_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_238 CHARGETYPE_ID CHRGTYPDSC CHARGETYPE_ID Cascade
F_701 CHARGETYPE_ID RMACHARGE CHARGETYPE_ID Cascade
Related reference