ZenotiHelp

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 wid references 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.