Item commission deductions fact table
TableName | Field | Field Type | Description | PrimaryKey | MappedDimensionTable | DimensionTableField |
|---|---|---|---|---|---|---|
Bi_FactItemCommissionDeductions_s3 | DeductionAmount | FLOAT | Amount to be deducted from employee revenue | |||
Bi_FactItemCommissionDeductions_s3 | DeductionDescription | NVARCHAR(4096) | Description of the deduction type | |||
Bi_FactItemCommissionDeductions_s3 | DeductionEndDate | TIMESTAMP | date till which deduction is applicable | |||
Bi_FactItemCommissionDeductions_s3 | DeductionPk | DECIMAL(19,0) | Unique identifier for the row. Primary Key | Yes | ||
Bi_FactItemCommissionDeductions_s3 | DeductionStartDate | TIMESTAMP | Date from which deduction is applicable | |||
Bi_FactItemCommissionDeductions_s3 | DeductionType | NVARCHAR(MAX) | Type of deduction. Eg: shop cost, labour cost, etc. | |||
Bi_FactItemCommissionDeductions_s3 | IsVoid | INT | Indicates if deduction is void or active | |||
Bi_FactItemCommissionDeductions_s3 | ItemId | VARCHAR(36) | Unique identifier of service/product/membership on whose sale deduction is applied | Bi_DimItems_S3 | itemid | |
Bi_FactItemCommissionDeductions_s3 | ItemType | INT | Item type to which item in "ItemID" column belongs to | Bi_DimItemType_S3 | itemtypeid | |
Bi_FactItemCommissionDeductions_s3 | OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 | organizationID | |
Bi_FactItemCommissionDeductions_s3 | PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
Bi_FactItemCommissionDeductions_s3 | Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
Bi_FactItemCommissionDeductions_s3 | groupid | BIGINT |