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