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