Bi_DimCenterRoyaltyCategory_s3
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|
CenterRoyaltyCategoryId | Unique identifier for the row | VARCHAR(36) | Y | |
OrgRoyaltyCategoryId | Unique identifier for Royalty category | VARCHAR(36) | Bi_DimOrgRoyaltyCategory_s3OrgRoyaltyCategoryId | |
CenterId | Unique identifier for the center | VARCHAR(36) | Bi_Dimcenter_s3 centerid | |
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_dimuser_s3 userid | |
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_s3 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 |