CHARGETYPE

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

Column Descriptions:

NameTypeDescription
CHARGETYPE_IDINTEGER NOT NULLGenerated unique key. -1 is reserved as 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:
0
No
1
Yes
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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CHARGETYPE_IDPrimary Key
I0000071STOREENT_ID+CODEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_233STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_238CHARGETYPE_IDCHRGTYPDSCCHARGETYPE_IDCascade
F_701CHARGETYPE_IDRMACHARGECHARGETYPE_IDCascade