Commission deduction 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 |
|
|
|