ZenotiHelp

Membership Fee Type Details Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing membership fee type definitions including fee names and additional configuration properties.

Columns

Column Name Data Type Nullable Description
MembershipFeeTypeDetailswid BIGINT IDENTITY No Surrogate warehouse key for the membership fee type detail record
FeeTypePK BIGINT Yes Source system primary key for the fee type
FeeName VARCHAR(1000) Yes Display name of the membership fee type
AdditionalProperties VARCHAR(MAX) Yes JSON or serialized string containing additional configuration properties for the fee type

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

MembershipFeeTypeDetailswid

Foreign Keys

Column References
organizationid an organization entity in the source system
Was this article helpful?
Your feedback helps us improve our documentation.