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 |