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 Name Column Type Column Description
CHARGETYPE_ID INTEGER
NOT NULL
Generated unique key.
CODE CHARACTER (10)
NOT NULL
Code used for referencing this Charge Type.
DISPLAYAGGREGATED CHARACTER (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.
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
Indicates if this Charge Type has been marked for deletion:
0 = No.
1 = Yes.
STOREENT_ID INTEGER
NOT NULL
The Store Entity that uses this Charge Type.
Indexes:
Index Name Indexed Column Names Index Type
I0000071 STOREENT_ID, CODE Unique Index
SQL030416034906890 CHARGETYPE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_233 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_238 CHARGETYPE_ID CHRGTYPDSC CHARGETYPE_ID Cascade
F_701 CHARGETYPE_ID RMACHARGE CHARGETYPE_ID Cascade