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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000071 STOREENT_ID+CODE Unique Index
SQL050212031211430 CHARGETYPE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_233 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_238 CHARGETYPE_ID CHRGTYPDSC CHARGETYPE_ID Cascade
F_701 CHARGETYPE_ID RMACHARGE CHARGETYPE_ID Cascade

Feedback