Employee invoice items revenue fact table
Bi_FactEmployeeInvoiceItemRevenue_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
ActualSaleprice | DECIMAL(19,4) | actual sale price of the item | |||
Appointmentid | VARCHAR(36) | appointment id for the service received. This is populated for appointments | |||
AppointmentSegmentId | VARCHAR(36) | unique id for an appointment segment within appointment | |||
CampaignFSR | DECIMAL(19,4) | discount received on using campaigns | |||
CancelOrNoShowStatus | INT | Indicates status of appointment. 0- Fulfilled Appointment -1 - Cancelled Appointment -2 - Noshow | |||
CashbackRedemption | DECIMAL(19,4) | amount redeemed from cashbacks on which commissions are applicable. If cashbacks are redeemed but commissions are not applicable, then this value is 0 | |||
CashRevenue | DECIMAL(19,4) | amount collected as cash/creditcard on which commission is applicable | |||
CenterId | NVARCHAR(MAX) | Unique identifier for a center. It is unique across organization | Bi_DimCenter_s3 centerID | ||
Commission | DECIMAL(19,4) | Percentage of commission employee should receive out of total commission set as part of product settings. If an employee is supposed to get 10% commission, and value in this table is 100%, then employee earns their 10% commission. If this value is set at 80%, then employee earns 8% commission | |||
DaypackagePrice | DECIMAL(19,4) | price of day package sold | |||
EmployeeId | NVARCHAR(MAX) | Unique identifier for employee. Unique across organization | Bi_DimUser_s3 userid | ||
FactEmployeeInvoiceItemRevenueID | DECIMAL(19,0) | Unique identifier for the row in table. Primary Key | Yes | ||
GcFSR | DECIMAL(19,4) | discount received on using giftcards | |||
GCPayment | DECIMAL(19,4) | amount paid through giftcards. All prepaid cards are giftcards. But giftcards are not prepaid cards | |||
GCRedemption | DECIMAL(19,4) | amount redeemed from giftcard redemptions on which commissions are applicable. If giftcard is redeemed but commissions are not applicable, then this value is 0 | |||
InvoiceClosedDate | TIMESTAMP | date on which invoice is closed in UTC time | |||
InvoiceClosedDateInCenter | TIMESTAMP | date on which invoice is closed in center timezone | |||
InvoiceId | NVARCHAR(MAX) | Unique identifier for Invoice number. Unique across organization | |||
InvoiceitemId | NVARCHAR(MAX) | Unique identifier for each invoice item within the invoice | |||
ItemId | NVARCHAR(MAX) | Unique identifier for Item sold. Item can product/service/package/etc. | Bi_DimItems_S3 itemid | ||
Itemtype | INT | Indicate what type of item is sold | Bi_DimItemType_S3 itemtypeid | ||
LastupdatedInCore | TIMESTAMP | Date on which invoice is updated in core product | |||
LeftGCRedemption | DECIMAL(19,4) | amount left to redeem using giftcard | |||
LeftLPRedemption | DECIMAL(19,4) | amount left to redeem using giftcards | |||
LeftMembershipRedemption | DECIMAL(19,4) | amount left to redeem using membership | |||
LPFSR | DECIMAL(19,4) | discount received on using loyalty points | |||
LPRedemption | DECIMAL(19,4) | amount redeemed from loyalty points on which commissions are applicable. If loyalty points are redeemed but commissions are not applicable, then this value is 0 | |||
ManualDiscountFSR | DECIMAL(19,4) | manual discount provided for the guest | |||
MembershipCreditFSR | DECIMAL(19,4) | service credit value | |||
MembershipCreditFSRBasedonMembershipPrice | DECIMAL(19,4) | service credit value based on membership price | |||
MembershipFSR | DECIMAL(19,4) | discount received on using membership | |||
MembershipRedemption | DECIMAL(19,4) | amount redeemed from memberships on which commissions are applicable. If membership is redeemed but commissions are not applicable, then this value is 0 | |||
organizationid | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 OrganizationID | ||
OrgPaymentorRevenue | BOOLEAN | Indicates if commission is on revenue realised or payment in case of giftcard redemptions. 1- commission on payment, 0 - commission on revenue realised | |||
PackageItemPrice | DECIMAL(19,4) | price of day package sold | |||
packageRedemption | DECIMAL(19,4) | amount redeemed from packages on which commissions are applicable. If packages are redeemed but commissions are not applicable, then this value is 0 | |||
PackageServiceId | NVARCHAR(MAX) | Unique identifier for the services. This is only filled if service is offered as part of day package | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
PrepaidCardFSR | DECIMAL(19,4) | amount paid using prepaid card. All prepaid cards are considered as gifts cards also. But giftcards are not prepaid cards | |||
ProcessedOn | TIMESTAMP | date on which invoice is processed | |||
Quantity | INT | no of units sold | |||
RefundedPrepaidCardFSR | DECIMAL(19,4) | amount redeemed using refundprepaidcard. | |||
TherapistRequestType | INT | indicates if guest requested for a therapist of specifc gender. 57 - Any 58 - Male 59 - Female 60- Specific | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||
InvoiceNo | VARCHAR(160) | Invoice number that helps in identifying and tracking the invoice. | |||