ZenotiHelp

Item Commission Deductions Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Stores commission deduction rules defined at the item level, including deduction amounts, types, and effective date ranges.

Columns

Column Name Data Type Nullable Description
itemdeductionwid BIGINT IDENTITY NOT NULL Surrogate key and primary key for the item commission deduction record.
deductionpk BIGINT YES Source system primary key for the deduction.
itemwid BIGINT YES Foreign key to the item dimension.
itemtypewid BIGINT YES Foreign key to the item type dimension.
deductiondescription VARCHAR(65535) YES Description of the deduction.
deductionamount DOUBLE PRECISION YES Amount of the deduction.
deductiontype VARCHAR(100) YES Type/category of the deduction.
deductionstartdate TIMESTAMP YES Start date of the deduction's effective period.
deductionenddate TIMESTAMP YES End date of the deduction's effective period.
isvoid BOOLEAN YES Flag indicating whether the deduction has been voided.
podid INTEGER YES Identifier for the pod (database partition).
void BOOLEAN YES Soft-delete flag indicating the record is logically deleted.

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

itemdeductionwid

Foreign Keys

This table has no foreign key relationships to other analytics tables.

Enumerator Values

Column Values
deductiontype Fixed
Percentage
Tiered
isvoid TRUE if the deduction has been voided; FALSE otherwise.
void TRUE if the record is soft-deleted; FALSE otherwise.
Was this article helpful?
Your feedback helps us improve our documentation.