Itemcomissiondeductions Consolidated
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Consolidated table storing commission deduction rules applied to items, including deduction amounts, types, and effective date ranges.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| organization name | VARCHAR(512) | YES | Name of the organization. Sourced from DimOrganization.organization_name. |
| organization account name | VARCHAR(512) | YES | Account name of the organization. Sourced from DimOrganization.organization_account_name. |
| item deduction pk | BIGINT | YES | Primary key for the item deduction record. |
| item deduction description | VARCHAR(65535) | YES | Description of the commission deduction. |
| item deduction amount | DOUBLE PRECISION | YES | Amount of the deduction applied. |
| item deduction type | VARCHAR(200) | YES | Type or category of the deduction. |
| item deduction start date | DATE | YES | Start date from which the deduction is effective. |
| item deduction end date | DATE | YES | End date after which the deduction is no longer effective. |
| is voided | BOOLEAN | YES | Indicates whether the deduction has been voided. |
| item wid | BIGINT | YES | Warehouse ID of the associated item. Sourced from DimItem.item_wid. |
| item name | VARCHAR(512) | YES | Name of the item. Sourced from DimItem.item_name. |
| item code | VARCHAR(256) | YES | Code assigned to the item. Sourced from DimItem.item_code. |
| item business unit name | VARCHAR(512) | YES | Business unit to which the item belongs. Sourced from DimItem.item_business_unit_name. |
| item tags | VARCHAR(65535) | YES | Tags associated with the item. Sourced from DimItem.item_tags. |
| item type | VARCHAR(100) | YES | Type classification of the item (e.g., Service, Product). Sourced from DimItem.item_type. |
Primary Key
item deduction pk (BIGINT)
Foreign Keys
item widreferences DimItem
Enumerator Values
| Column Name | Known Values |
|---|---|
| item deduction type | Deduction type values (e.g., Flat, Percentage) |
| item type | Service, Product, Membership, Package, Gift Card, Day Package |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.