Employee Invoice Item Revenue Fact Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Stores employee-level revenue breakdowns per invoice item, including cash, membership, gift card, loyalty point redemptions, commissions, and various financial split ratios.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| empinvoiceitemwid | BIGINT IDENTITY | NOT NULL | Surrogate key and primary key for the employee invoice item revenue record. |
| factemployeeinvoiceitemrevenueid | BIGINT | NOT NULL | Source system identifier for the revenue fact. |
| employeewid | BIGINT | YES | Foreign key to the employee dimension (Bi_DimUser.userwid). |
| invoiceid | VARCHAR(36) | NOT NULL | GUID of the associated invoice. |
| itemwid | BIGINT | YES | Foreign key to the item dimension. |
| packageserviceid | VARCHAR(36) | YES | GUID of the associated package service. |
| invoiceitemid | VARCHAR(36) | YES | GUID of the associated invoice item. |
| centerwid | BIGINT | YES | Foreign key to the center dimension (Bi_DimCenter.centerwid). |
| itemtypewid | BIGINT | YES | Foreign key to the item type dimension. |
| cashrevenue | DOUBLE PRECISION | YES | Revenue from cash payments. |
| membershipredemption | DOUBLE PRECISION | YES | Revenue from membership redemptions. |
| gcredemption | DOUBLE PRECISION | YES | Revenue from gift card redemptions. |
| lpredemption | DOUBLE PRECISION | YES | Revenue from loyalty point redemptions. |
| cashbackredemption | DOUBLE PRECISION | YES | Revenue from cashback redemptions. |
| commission | DOUBLE PRECISION | YES | Commission amount for the employee on this item. |
| invoicecloseddate | TIMESTAMP | YES | Date/time the invoice was closed (UTC). |
| invoicecloseddateincenter | TIMESTAMP | YES | Date/time the invoice was closed in center local time. |
| lastupdatedincore | TIMESTAMP | YES | Timestamp of the last update in the core system. |
| packageredemption | DOUBLE PRECISION | YES | Revenue from package redemptions. |
| membershipfsr | DOUBLE PRECISION | YES | Membership financial split ratio. |
| campaignfsr | DOUBLE PRECISION | YES | Campaign financial split ratio. |
| lpfsr | DOUBLE PRECISION | YES | Loyalty point financial split ratio. |
| manualdiscountfsr | DOUBLE PRECISION | YES | Manual discount financial split ratio. |
| gcfsr | DOUBLE PRECISION | YES | Gift card financial split ratio. |
| orgpaymentorrevenue | SMALLINT | YES | Flag indicating organization-level payment or revenue. |
| void | SMALLINT | YES | Soft-delete flag (0 = active, non-zero = voided). |
| processedon | TIMESTAMP | YES | Timestamp when the record was processed. |
| quantity | INTEGER | YES | Quantity of items on the invoice line. |
| cancelornoshowstatus | INTEGER | YES | Status indicating cancellation or no-show. |
| therapistrequesttype_statuswid | BIGINT | YES | Foreign key to therapist request type status dimension. |
| actualsaleprice | DOUBLE PRECISION | YES | Actual sale price of the item. |
| daypackageprice | DOUBLE PRECISION | YES | Day package price for the item. |
| packageitemprice | DOUBLE PRECISION | YES | Package item price allocation. |
| prepaidcardfsr | DOUBLE PRECISION | YES | Prepaid card financial split ratio. |
| refundedprepaidcardfsr | DOUBLE PRECISION | YES | Refunded prepaid card financial split ratio. |
| gcpayment | DOUBLE PRECISION | YES | Gift card payment amount. |
| leftmembershipredemption | DOUBLE PRECISION | YES | Remaining membership redemption amount. |
| leftgcredemption | DOUBLE PRECISION | YES | Remaining gift card redemption amount. |
| leftlpredemption | DOUBLE PRECISION | YES | Remaining loyalty point redemption amount. |
| MembershipCreditFSRBasedonMembershipPrice | DOUBLE PRECISION | YES | Membership credit FSR based on membership price. |
| MembershipCreditFSR | DOUBLE PRECISION | YES | Membership credit financial split ratio. |
| Appointmentid | VARCHAR(36) | YES | GUID of the associated appointment. |
| AppointmentSegmentId | VARCHAR(36) | YES | GUID of the associated appointment segment. |
| invoiceno | VARCHAR(160) | YES | Human-readable invoice number. |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
empinvoiceitemwid
Foreign Keys
| Column | References |
|---|---|
| employeewid | Bi_DimUser.userwid |
| centerwid | Bi_DimCenter.centerwid |
| invoicecloseddateincenter | Bi_DimDate.datewid |
Enumerator Values
| Column | Values |
|---|---|
| orgpaymentorrevenue | 0 = Center-level 1 = Organization-level |
| void | 0 = active; non-zero = voided/soft-deleted. |
| cancelornoshowstatus | -2 = No Show -1 = Cancelled 0 = New/Open 1 = Closed 2 = Checkin 4 = Confirm 5 = Cancel 7 = Void 10 = Noshow (Redo Penalty) 11 = Cancelled (Redo Penalty) 12 = Closed (Redo Penalty) |
Was this article helpful?
Your feedback helps us improve our documentation.