Membership fee type details dimension table
Bi_DimMembershipFeeTypeDetails
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|
MembershipFeeTypeDetailswid | Primary key | BIGINT | PK | |
FeeTypePK | unique identifier for the row | BIGINT | ||
FeeName | Name of the fee levied | VARCHAR(1000) | ||
AdditionalProperties | additional information on the fee type | VARCHAR(MAX) | ||
EtlLastUpdatedOn | Date and Time on which row is updated | TIMESTAMP | ||
EtlLastUpdatedBy | System user which created the row. Internal to Zenoti | VARCHAR(50) | ||
podname | Identifer for the region customer belongs to. Internal to Zenoti | VARCHAR(20) | ||
organizationid | Unique identifier for the organization | VARCHAR(36) | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |