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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000071 | STOREENT_ID, CODE | Unique Index |
SQL030416034906890 | CHARGETYPE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_233 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
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 |