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

Column Descriptions:

CHARGETYPE_IDINTEGER NOT NULLGenerated unique key. -1 is reserved as the the ID for restocking fee. Use any integer other than -1 for custom types.
STOREENT_IDINTEGER NOT NULLThe 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.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this Charge Type has been marked for deletion:
DISPLAYAGGREGATEDCHAR (1) NOT NULLAggregate the charge or credit into the appropriate transaction or transaction item for display purposes. Charges or credits are stored individually to facilitate tax calculations.
CODECHAR (10) NOT NULLCode used for referencing this Charge Type.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000071STOREENT_ID+CODEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType