Organization Royalty Category dimension table
Bi_DimOrgRoyaltyCategory_s3
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|
OrgRoyaltyCategoryId | Unique identifier for the row | VARCHAR(36) | Y | |
OrganizationId | Unique identifier for the organization | VARCHAR(36) | BI_dimcenter_s3 organizationid | |
RoyaltyCategoryName | Category name | NVARCHAR(2048) | ||
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 | ||
CategoryDescription | Description of Category | NVARCHAR(MAX) | ||
CategoryCode | Category Code | NVARCHAR(512) | ||
Active | Indicates of the category is active or not | BOOLEAN | ||
CalculationParameter | Indicates if royalty fee for this royalty category is a fixed value or a percentage value. 1 - percentage, 2 - flat amount | INT | ||
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 |