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.