Center royalty category dimension table
Bi_DimCenterRoyaltyCategory
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|
CenterRoyaltyCategorywid | Unique identifier for the row. Primary key | BIGINT | Y | |
CenterRoyaltyCategoryId | Unique identifier for the row | VARCHAR(36) | ||
OrgRoyaltyCategoryId | Unique identifier for Royalty category | VARCHAR(36) | Bi_DimOrgRoyaltyCategoryOrgRoyaltyCategoryId | |
CenterId | Unique identifier for the center | VARCHAR(36) | Bi_Dimcente centerwid | |
ServiceRoyaltyPercentage | Royalty percentage on service sales/collections for given royalty category | FLOAT | ||
ProductRoyaltyPercentage | Royalty percentage on product sales/collections for given royalty category | FLOAT | ||
MembershipRoyaltyPercentage | Royalty percentage on Membership sales/collections for given royalty category | FLOAT | ||
PackageRoyaltyPercentage | Royalty percentage on package sales/collections for given royalty category | FLOAT | ||
GiftcardRoyaltyPercentage | Royalty percentage on giftcard sales/collections for given royalty category | FLOAT | ||
PrepaidcardRoyaltyPercentage | Royalty percentage on prepaid card sales/collections for given royalty category | FLOAT | ||
ClassRoyaltyPercentage | Royalty percentage on class sales/collections for given royalty category | FLOAT | ||
AddedBy | Unique identifer of the user who updated royalty percentages | VARCHAR(36) | bi_dimuse userwid | |
AddedOn | Date on which royalty percentages are added | TIMESTAMP | ||
Void | Indicates if the row is active or inactive | BOOLEAN | ||
OrganizationID | Unique identifier for the organization | VARCHAR(36) | BI_dimcenter organizationid | |
ETLLastUpdatedOn | Date on which row is updated | TIMESTAMP | ||
ETLLastUpdatedBy | User who updated the row | VARCHAR(50) | ||
Podname | Indicates region in which customer is located. Internal to Zenoti | VARCHAR(20) | ||
groupid | Batch number in which row is processed. Internal to Zenoti | BIGINT |