CHARGETYPE

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

Column Descriptions:

Name	Type	Description
CHARGETYPE_ID	INTEGER NOT NULL	Generated unique key. -1 is reserved as 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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CHARGETYPE_ID	Primary Key
I0000071	STOREENT_ID+CODE	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_233	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_238	CHARGETYPE_ID	CHRGTYPDSC	CHARGETYPE_ID	Cascade
F_701	CHARGETYPE_ID	RMACHARGE	CHARGETYPE_ID	Cascade

Related reference
Order management adjustment and tax data model