Item commission deductions fact table
bi_factitemcommissiondeductions
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
deductionamount | float8 | Amount to be deducted from employee revenue | |||
deductiondescription | varchar(65535) | Description of the deduction type | |||
deductionenddate | timestamp | date till which deduction is applicable | |||
deductionpk | bigint | Unique identifier for the row. Primary Key | |||
deductionstartdate | timestamp | Date from which deduction is applicable | |||
deductiontype | varchar(100) | Type of deduction. Eg: shop cost, labour cost, etc. | |||
isvoid | boolean | Indicates if deduction is void or active | |||
itemdeductionwid | bigint | Unique identifier for the row in the table | Yes | ||
itemtypewid | bigint | Item type to which item in "ItemID" column belongs to | Bi_DimItemType itemtypewid | ||
itemwid | bigint | Unique identifier of service/product/membership on whose sale deduction is applied | Bi_DimItems itemwid | ||
organizationid | varchar(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter organizationID | ||
podid | integer | Unique identifier for the POD on which customer data is hosted | |||
podname | varchar(20) | Internal to the ETL, says from which POD data is being synced the table | |||
void | boolean | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||