Membership transfers fact table
bi_factmembershiptransfers
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field | |
|---|---|---|---|---|---|
factmembershiptransferwid | Unique identifier for the row in the org. Primary key | BIGINT | yes | ||
factmembershiptransferid | Unique identifier for the row in the table. | BIGINT | |||
usermembershipwid | Unique identifier of the membership sold to user. Unique for a member and membership | BIGINT | |||
invoiceid | unique identifier for the invoice | VARCHAR(36) | |||
transfereddate | date on which membership is transferred | TIMESTAMP | |||
transfertocenterwid | center to which membership is transferred | BIGINT | bi_dimcenter centerwid | ||
salecenterwid | center at which sale is made | BIGINT | bi_dimcenter centerwid | ||
membershipversionwid | unique identifier for the membership that is transferred | BIGINT | |||
price | price to transfer membership | FLOAT | |||
isdiscount | indicates if there is a discount on the membership transfer price | BOOLEAN | |||
transferredbywid | userwid of the employee who transferred the membership | BIGINT | |||
actualnextcollectiondate | next collection date if membership is not transferred | TIMESTAMP | |||
nextcollectiondate | next collection date after membership is transferred | TIMESTAMP | |||
recurringenddate | date on which recurring membership ends | TIMESTAMP | |||
comments | employee comments when transferring the membership | VARCHAR(MAX) | |||
updatedinvoiceid | Invoice id that got created in the new center | VARCHAR(36) | |||
updatedusermembershipwid | New membership user that got generated in the new center | BIGINT | |||
active | indicates if membership is active | BOOLEAN | |||
etlcreateddate | Date and Time on which row is created | TIMESTAMP | |||
etlcreatedby | System user which created the row. Internal to Zenoti | BIGINT | |||
void | Indicates if row is void or not. 0-active, 1- void | BOOLEAN | |||
etllastupdatedon | Date and Time on which row is updated | TIMESTAMP | |||
etllastupdatedby | System user which updated the row. Internal to Zenoti | VARCHAR(50) | |||
organizationid | Unique identifier for the organization | VARCHAR(36) | bi_dimcenter organizationid | ||
podname | Identifer for the region customer belongs to. Internal to Zenoti | VARCHAR(200) | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||