Reference > Database > WebSphere Commerce database tables > C
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 Name Column Type Description CHARGETYPE_ID INTEGER NOT NULL Generated unique key. -1 is reserved as the the ID for restocking fee. Use any integer other than -1 for custom types. STOREENT_ID INTEGER NOT NULL The Store Entity that uses this Charge Type. The STOREENT_ID is the primary key of the table STOREENT. Each row of this table represents a StoreEntity. A StoreEntity is an abstract superclass that represents either a Store or a StoreGroup. The default value, -1, represents a store group. By default, all stores are set to the same store group, -1. The value 0 represents an abstract store - the whole site. It includes all the stores in the site, regardless of the store group. 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 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 SQL100520030314170 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
Referenced By 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
_vcc_freeselect_bottom_