Invoice item fact table

TableName 

Field 

Field Type 

Description 

PrimaryKey 

MappedDimensionTable 

DimensionTableField 

Bi_FactInvoiceItem_s3

ActionPerformedDateTimeInCenter

TIMESTAMP

The latest date and time on which a change was made to the appointment status, the appointment start time, or the appointment end time.

Bi_FactInvoiceItem_s3

ActualAppointmentTime

TIMESTAMP

The scheduled start date and time of an appointment at the time of its creation. If any changes are made to the appointment start date, this column will not change.

Bi_FactInvoiceItem_s3

AddOnGuestMembershipStatus

INT

Membership status of the guest as an add-on member. If the guest is associated with a membership as an add-on member, the status of the membership is populated here. If the guest is associated with multiple memberships as an add-on member, the status is populated as per a precedence order.

- If a membership is actually sold on the corresponding sale date (when 'membership sold in invoice' is marked as True), the membership status as of the corresponding sale date is considered. Otherwise, the membership status as of the day prior to the corresponding sale date is considered.

If the guest was associated with a membership as an add-on member in the past but was then removed from the membership, this field populates 'Add-on member before but not currently'. In this case, the status of the membership does not matter.

If the guest was never associated with any membership as an add-on member, this field populates 'Never been an add-on member'.

The following list describes the precendence order from highest priority on top to lowest priority at the bottom:

Possible values:

- Active

- Frozen

- Suspended

- Prior Member with service credits

- Prior Member without service credits

- Add-on member before but not currently

- Never been an add-on member

- Not applicable

Bi_FactInvoiceItem_s3

AppliedBY

NVARCHAR(MAX)

A unique identifier for the user that applied the discount.(Bi_DimUser)

Bi_FactInvoiceItem_s3

AppointmentPK

DECIMAL(19,0)

Unique identifier for each appointment.

Bi_FactInvoiceItem_s3

appointmentstatus

INT

A unique identifier that signifies the status of the Appointment, generated in status dimension(Bi_DimStatus)

Bi_FactInvoiceItem_s3

CampaignId

NVARCHAR(MAX)

The unique identifier that indicates the Campaign details(Bi_DimCampaign).

Bi_FactInvoiceItem_s3

CampaignUsageDateInCenter

DATE

Date on which the campaign was applied to the corresponding invoice item in centre.

Bi_FactInvoiceItem_s3

CampaignUsageDateTimeInCenter

TIMESTAMP

Date and time at which the campaign was applied to the corresponding invoice item in centre.

Bi_FactInvoiceItem_s3

CancelOrNoShowStatus

SMALLINT

Flag that indicates whether the appointments with status as 'Cancel' or 'Noshow' have a cancellation or no-show fee associated with them. Possible values:

- Cancelled Appointment: Appointment has a cancellation fee.

- No Show: Appointment has a no-show fee.

- Fulfilled Appointment: Appointment does not have a cancellation or no-show fee.

Bi_FactInvoiceItem_s3

Card

FLOAT

Payment received through card for the corresponding invoice item. This is a right-side transaction.

Bi_FactInvoiceItem_s3

Cash

FLOAT

Payment received through cash for the corresponding invoice item. This is a right-side transaction.

Bi_FactInvoiceItem_s3

CashBackRedemption

FLOAT

Amount redeemed from cashback for the corresponding invoice item. This is a left-side transaction.

Bi_FactInvoiceItem_s3

CenterId

VARCHAR(36)

A unique identifier for the center, generated in Centre dimension(Bi_DimCentre).

Bi_DimCenter_s3

CenterId

Bi_FactInvoiceItem_s3

cheque

FLOAT

Payment received via cheque for the corresponding invoice item. This is a right-side transaction.

Bi_FactInvoiceItem_s3

ClosedBy

NVARCHAR(MAX)

A unique identifier of the employee who closed the invoice(bi_dimuser).

Bi_FactInvoiceItem_s3

ClosedDateInCenter

DATE

The date on which the invoice was closed.

Bi_FactInvoiceItem_s3

ClosedDateTimeInCenter

TIMESTAMP

The date and time at which the invoice was closed.

Bi_FactInvoiceItem_s3

Comments

NVARCHAR(65535)

Comments entered for the corresponding invoice.

Bi_FactInvoiceItem_s3

ConsiderForFinancialZero_Discount

FLOAT

Payment received via custom payments that are not considered in financials for the corresponding invoice item. This is a right-side transaction.

Bi_FactInvoiceItem_s3

CreateDateInCenter

DATE

The date on which the invoice item was added into the invoice.

Bi_FactInvoiceItem_s3

CreateDateTimeInCenter

TIMESTAMP

The date and time at which the invoice item was added into the invoice.

Bi_FactInvoiceItem_s3

CreatedBy

NVARCHAR(MAX)

A unique identifier of the employee who created the invoice(bi_dimuser).

Bi_Dimuser_s3

userid

Bi_FactInvoiceItem_s3

Custom

FLOAT

Payment received via monetary- financial custom payments for the corresponding invoice item. This is a right-side transaction.

Bi_FactInvoiceItem_s3

CustomDiscount

FLOAT

Custom discount applied on the corresponding invoice item. This is already included in 'discount applied'.

Bi_FactInvoiceItem_s3

CustomDiscountid

VARCHAR(36)

A system-generated unique identifier that is populated when a membership discount is applied on the invoice item.

Bi_FactInvoiceItem_s3

CustomDiscountType

VARCHAR(2048)

This field displays 'Membership Discount' when a membership discount is applied on the invoice item. Otherwise, it is blank.

Bi_FactInvoiceItem_s3

CustomPaymentName

NVARCHAR(65535)

Comma-separated list of custom payment types used while making the payment.

Bi_FactInvoiceItem_s3

Discount

FLOAT

Total discount applied on the corresponding invoice item.

Bi_FactInvoiceItem_s3

DiscountId

NVARCHAR(MAX)

A unique identifier generated for a discount.(Bi_DimDiscount)

Bi_DimDiscount_s3

DiscountId

Bi_FactInvoiceItem_s3

DiscountUserMembershipID

VARCHAR(36)

If membership discount is applied it is populated with user membership id that was used

Bi_FactInvoiceItem_s3

discountWithTax

FLOAT

Total discount applied on the corresponding invoice item inclusive of apportioned tax.

Bi_FactInvoiceItem_s3

DRR

FLOAT

Daily recurring revenue of the membership calculated based on the membership payment frequency and amount. This is calculated assuming that the 'discount or order setting' is disabled.

Bi_FactInvoiceItem_s3

DRRWithDiscountorOrderSetting

FLOAT

Daily recurring revenue of the membership calculated based on the membership payment frequency and amount. This is calculated assuming that the 'discount or order setting' is enabled.

Bi_FactInvoiceItem_s3

EquipmentId

VARCHAR(36)

The unique identifier that indicates the Equipment that used as part of the appoinmtnet(Bi_DimEquipment).

Bi_DimEquipment_s3

EquipmentId

Bi_FactInvoiceItem_s3

etlCreatedBy

INT

ETL system admin user who inserted or updated the corresponding record in this table.

Bi_FactInvoiceItem_s3

etlCreatedDate

TIMESTAMP

Latest timestamp at which the corresponding record was either inserted or updated in this table.

Bi_FactInvoiceItem_s3

factinvoiceitemid

INT

A system-generated unique identifier for each record in the sales data source. This is generated within Analytics.

Yes

Bi_FactInvoiceItem_s3

FinalSalePrice

FLOAT

The price at which the item was sold. The price is inclusive of discounts and taxes.

Bi_FactInvoiceItem_s3

FirstGuestStatus

SMALLINT

Note: Do not use this field. It is relevant for very specific scenarios only.

Bi_FactInvoiceItem_s3

followup

INT

Note: Do not use this field. It is relevant for very specific scenarios only.

Bi_FactInvoiceItem_s3

GC_PPCSold

SMALLINT

This flag indicates if gc/ppc is sold as part of the line item.

Bi_FactInvoiceItem_s3

GCPayment

FLOAT

Payment received via gift cards for the corresponding invoice item. This is a right-side transaction.

Bi_FactInvoiceItem_s3

GCRedemption

FLOAT

Amount redeemed from gift cards for the corresponding invoice item. This is a left-side transaction.

Bi_FactInvoiceItem_s3

GCRedemptionRevenue

FLOAT

Revenue recognized via gift cards, excluding tax.

Bi_FactInvoiceItem_s3

GCRevenue

FLOAT

Revenue recognised out of gc payment(right side payment)

Bi_FactInvoiceItem_s3

giftCardId

VARCHAR(36)

A unique identifier generated for a Gift Card(Bi_DimGiftCard).

Bi_DimGiftCard_s3

GiftCardId

Bi_FactInvoiceItem_s3

GroupInvoiceId

VARCHAR(36)

Invoice ID of the actual sale of the membership. This gets populated against all the subsequent recurring cycles and helps identify the original membership sale.

Bi_FactInvoiceItem_s3

GroupInvoiceOrder

INT

Number order that indicates the order of the recurring membership invoice. For set up membership, this will be 0 and for the subsequent recurring cycles, this will be 1,2,3,…

Bi_FactInvoiceItem_s3

GuestTierPK

DECIMAL(19,0)

PK of guest tier from guest tier table

Bi_FactInvoiceItem_s3

Invoice_no

NVARCHAR(160)

Unique identifier for the invoice (unique within the center).

Bi_FactInvoiceItem_s3

invoiceDateInCenter

DATE

This is the same as the sale date for all records except for records which contain the initial sale of the membership. For these, it is populated as the membership start date.

Bi_FactInvoiceItem_s3

invoiceDateTimeInCenter

TIMESTAMP

Displays centre date and time at which the invoice was created.

Bi_FactInvoiceItem_s3

Invoiceid

VARCHAR(36)

The unique identifier for the invoice within the organization.

Bi_FactInvoiceItem_s3

InvoiceItemid

VARCHAR(36)

The unique identifier for each line item within the invoice.

Bi_FactInvoiceItem_s3

InvoiceItemPK

DECIMAL(19,0)

Unique identifier for each invoice item within the invoice.

Bi_FactInvoiceItem_s3

InvoiceSource

INT

The source from where the invoice was created(Bi_DimItemSource). 

Bi_DimItemSource_s3

SourceNum

Bi_FactInvoiceItem_s3

invoiceStatus

SMALLINT

This indicates whether the invoice is open or closed. 4 is considered as close and all the remaining values are considered as open

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

isAppointmentReScheduled

SMALLINT

Flag that indicates whether the appointment start time was changed from the initial start time that was set at the time of creation of the appointment.

- 1: Appointment was rescheduled.

- 0: Appointment was not rescheduled.

Bi_FactInvoiceItem_s3

IsDowngradeMembership

SMALLINT

If a membership is cancelled and a new membership is purchased on the same day and the payment made to the new membership is lower than that of the old membership, it is considered as a downgrade membership.(Bi_DimStatus)

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

isinvalidinvoice

BOOLEAN

Flag that indicates whether the invoice item is valid.

- True: Invalid invoice.

- False: Valid invoice.

Bi_FactInvoiceItem_s3

IsMembershipDiscount

INT

This indicates whether membership discount is applied on this invoice item or not

Bi_FactInvoiceItem_s3

IsMembershipDiscounted

SMALLINT

Flag that indicates whether the membership corresponding to the invoice item is discounted.(Bi_DimStatus)

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

IsPaymentReceived

SMALLINT

This flag indicates whether any payment (right-side transaction) is received for the corresponding invoice item.(Bi_DimStatus)

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

IsPriceAdjusted

BOOLEAN

Flag that indicates whether the sale price is adjusted.

- True: Adjusted.

- False: Not adjusted.

Bi_FactInvoiceItem_s3

IsRebooked

SMALLINT

A unique identifier that signifies whether an appointment is rebooked or not, generated in status dimension(Bi_DimStatus)

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

IsRecurringInvoice

SMALLINT

Flag that indicates whether the invoice is a recurring invoice.(Bi_DimStatus)

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

IsRedo

BOOLEAN

Flag that indicates whether the corresponding appointment is a redo appointment (initial appointment).

- True: Appointment led to a redo appointment.

- False: Appointment is not a redo appointment.

Bi_FactInvoiceItem_s3

IsRedone

BOOLEAN

Flag that indicates whether the corresponding appointment is a re-done appointment (subsequent appointment).

- True: Appointment is a re-done appointment.

- False: Appointment is not a re-done appointment.

Bi_FactInvoiceItem_s3

IsRefunded

SMALLINT

Flag that indicates whether the invoice item is refunded (whether the corresponding invoice item is the source for a refund). The actual refund invoice is separate.(Bi_DimStatus)

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

isTaxExempted

SMALLINT

Flag that indicates whether tax is exempted for the guest.

- True: Tax is exempted.

- False: Tax is not exempted.

Bi_FactInvoiceItem_s3

IsUpgradeMembership

SMALLINT

If a membership is cancelled and a new membership is purchased on the same day and the payment made to the new membership is higher than that of the old membership, it is considered as an upgrade membership.(Bi_DimStatus)

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

isUpsell

INT

If the guest buys two packages within 365 days within the same business unit, this flag is marked as True for the second package.

Bi_FactInvoiceItem_s3

Itemid

VARCHAR(36)

A unique identifier for the Item(Bi_DimItems).

Bi_DimItems_S3

itemid

Bi_FactInvoiceItem_s3

ItemsBoughtPreviously

DECIMAL(19,0)

It represnts all the distinct item types that guest has purchased before this line item. It is the sum of 2 to the power of distict itemtype.

Bi_FactInvoiceItem_s3

ItemsBoughtTogether

INT

Indicates the item types bought together in the invoice.

Bi_FactInvoiceItem_s3

ItemType

INT

A unique identifier for the Item Type(Bi_DimItemType).

Bi_DimItemType_S3

itemtypevalue

Bi_FactInvoiceItem_s3

LastServiceDate

DATE

Sale date of the previous appointment with 'appointment status' = 'Closed' or 'Confirmed' or 'Checkin' or 'Open'. The invoice status of the previous appointment does not matter. This field only gets populated if the current invoice item is of service item type.

Bi_FactInvoiceItem_s3

LastUpdatedDateInCenter

DATE

The centre date at which the invoice item was updated in the invoice.

Bi_FactInvoiceItem_s3

LastUpdatedDateTimeInCenter

TIMESTAMP

The centre date and time at which the invoice item was updated in the invoice.

Bi_FactInvoiceItem_s3

LPPayment

FLOAT

Payment received via loyalty points for the corresponding invoice item. This is a right-side transaction.

Bi_FactInvoiceItem_s3

LPRedemption

FLOAT

Amount redeemed from loyalty points for the corresponding invoice item. This is a left-side transaction.

Bi_FactInvoiceItem_s3

membergueststatus

SMALLINT

Membership status of the guest as a primary member. If the guest is associated with a membership as a primary member, the status of the membership is populated here. If the guest is associated with multiple memberships as a primary member, the status is populated as per a precedence order.(Bi_DimStatus)

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

MembershipBenefitRedemptionRevenue

FLOAT

Revenue recognised out of membership service usages

Bi_FactInvoiceItem_s3

MembershipIRR

FLOAT

Initial revenue recognized via memberships, excluding tax.

Bi_FactInvoiceItem_s3

MembershipPayment

FLOAT

Payment received via memberships for the corresponding invoice item. This is a right-side transaction.

Bi_FactInvoiceItem_s3

MembershipRedemption

FLOAT

Amount redeemed from memberships for the corresponding invoice item. This is a left-side transaction.

Bi_FactInvoiceItem_s3

MembershipRedemptionRevenue

FLOAT

Revenue recognised out of membership redemption(left side payment)

Bi_FactInvoiceItem_s3

MembershipRevenue

FLOAT

Revenue recognised out of membership payment(right side payment)

Bi_FactInvoiceItem_s3

MembershipSold

SMALLINT

Flag indicates whether this is new membership sale or not. It is marked for setup membership line item if setup membership exists.

Bi_FactInvoiceItem_s3

MembershipUserId

VARCHAR(36)

The unique identifier of the member user that was purchased as part of this invoice item

Bi_DimMembershipUser_s3

UserMembershipId

Bi_FactInvoiceItem_s3

membershipVersionId

VARCHAR(36)

A unique identifier for membership version(Bi_DimMembership).

Bi_DimMembership_s3

MembershipVersionId

Bi_FactInvoiceItem_s3

ModifiedBy

NVARCHAR(MAX)

A code that identifies the User that modified the record.(Bi_DimUser)

Bi_Dimuser_s3

userid

Bi_FactInvoiceItem_s3

MultipleSoldBy

NVARCHAR(65535)

coma seperated sale by employee ids of the line item.

Bi_FactInvoiceItem_s3

NextSaleDate

DATE

Sale date of the next visit of the guest. Recurring invoices, refund invoices, voided invoices, cancelled, and no-show appointments are not considered for the next visit. The invoice status can be either open or closed for the next visit. This field does not get populated if the current invoice item is a refund, recurring, or invalid invoice item.

Bi_FactInvoiceItem_s3

NextServiceDate

DATE

Sale date of the next appointment with 'appointment status' = 'Closed' or 'Confirmed' or 'Checkin' or 'Open'. The invoice status of the next appointment does not matter. This field only gets populated if the current invoice item is of service item type.

Bi_FactInvoiceItem_s3

OrganizationId

VARCHAR(36)

A unique identifier for the organition for which this data belongs

Bi_DimCenter_s3

OrganizationId

Bi_FactInvoiceItem_s3

OriginalSalePrice

FLOAT

Original sale price of the invoice item. If the sale price is not adjusted, 'sale price' and 'original sale price' will be the same.

Bi_FactInvoiceItem_s3

PackageIRR

FLOAT

Initial revenue recognized via packages, excluding tax.

Bi_FactInvoiceItem_s3

PackageRedemptionRevenue

FLOAT

Revenue recognized via packages, excluding tax.

Bi_FactInvoiceItem_s3

packageVersionId

VARCHAR(36)

A unique identifier for package version(Bi_DimPackage).

Bi_DimPackage_s3

PackageVersionId

Bi_FactInvoiceItem_s3

PaidByCardsName

NVARCHAR(65535)

Comma-separated list of card types used while making the payment.

Bi_FactInvoiceItem_s3

PodName

VARCHAR(20)

Internal to the ETL, says from which POD data is being synced the table

Bi_FactInvoiceItem_s3

PrePaidCardPayment

FLOAT

Payment received via prepaid cards for the corresponding invoice item. This is a right-side transaction.

Bi_FactInvoiceItem_s3

PrePaidCardRevenue

FLOAT

Revenue recognized via prepaid cards, excluding tax.

Bi_FactInvoiceItem_s3

PreviousSaleDate

DATE

Sale date of the previous visit of the guest. Recurring invoices, refund invoices, voided invoices, cancelled, and no-show appointments are not considered for the previous visit. The invoice status can be either open or closed for the previous visit. This field does not get populated if the current invoice item is a refund, recurring, or invalid invoice item.

Bi_FactInvoiceItem_s3

productId

VARCHAR(36)

A unique identifier for a product, generated in Product dimension(Bi_DimProduct).

Bi_DimProduct_s3

productid

Bi_FactInvoiceItem_s3

ProductSoldCount

INT

The number of products sold.

Bi_FactInvoiceItem_s3

Quantity

INT

Quantity sold of the corresponding invoice item.

Bi_FactInvoiceItem_s3

RebookedAppointmentCount

INT

The number of appointments or appointment groups that got rebooked from the source. This is populated only for source appointments.

If the entire appointment group is rebooked, this field populates the number of times the appointment group is rebooked.

If a few appointments within a group are rebooked, this field populates the number of times the appointment is rebooked.

Bi_FactInvoiceItem_s3

RedoTherapist

VARCHAR(36)

A unique identifier for the Therapist performing the redo service.(Bi_DimUser)

Bi_Dimuser_s3

userid

Bi_FactInvoiceItem_s3

RefundAmount

FLOAT

Amount refunded for the invoice item. This is the 'sale price' of the refund invoice item associated with this source invoice item. This field is only populated for invoice items that are the source for a refund - where is refunded is True.

Bi_FactInvoiceItem_s3

RefundDateInCenter

DATE

Date on which the invoice item is refunded. This is the 'sale date' of the refund invoice item associated with this source invoice item.

Bi_FactInvoiceItem_s3

RefundDateTimeInCenter

TIMESTAMP

Date and time at which the invoice item is refunded. This is the 'sale date and time' of the refund invoice item associated with this source invoice item.

Bi_FactInvoiceItem_s3

RefundQuantity

INT

Quantity refunded for the invoice item. This is the 'quantity sold' of the refund invoice item associated with this source invoice item. This is populated only for products. This field is only populated for invoice items that are the source for a refund - where is refunded is True.

Bi_FactInvoiceItem_s3

RefundSourceInvoiceItemId

VARCHAR(65535)

This field establishes the link between the source invoice item and the refund invoice item. It is only populated for refund invoice items. This field populates the invoice item ID of the source invoice item.

Bi_FactInvoiceItem_s3

RefundTax

FLOAT

Tax refunded for the invoice item. This is the 'tax' of the refund invoice item associated with this source invoice item.

Bi_FactInvoiceItem_s3

ReStockQuantity

FLOAT

This is populated for 'item type code' = 'product refund'. This is the quantity restocked out of the refunded quantity.

Bi_FactInvoiceItem_s3

RoomID

VARCHAR(36)

Unique ID of the room in which service is provided

Bi_DimResource_s3

ResourceId

Bi_FactInvoiceItem_s3

RoundingAdjustment

FLOAT

Rounding adjustments done for the particular invoice.

Bi_FactInvoiceItem_s3

SaleById

NVARCHAR(MAX)

A unique identifier of the employee who made the sale(bi_dimuser).

Bi_Dimuser_s3

userid

Bi_FactInvoiceItem_s3

SaleDateInCenter

DATE

For Service item type, this is the date on which the service was performed.

For other item types, this is the date on which the item was added to the invoice.

Bi_FactInvoiceItem_s3

SaleDateTimeInCenter

TIMESTAMP

For Service item type, this is the date and time at which the service was performed.

For other item types, this is the date and time at which the item was added to the invoice.

Bi_FactInvoiceItem_s3

SalePrice

FLOAT

The sale price of the item derived as follows:

sale price = 'list price' - 'discount applied' - 'loyalty point redemption amount' - 'membership redemption amount' - 'gift card redemption amount' - 'cashback redemption amount' + 'tax.'

Bi_FactInvoiceItem_s3

saletax

FLOAT

Tax applicable on the invoice item before discount.

Bi_FactInvoiceItem_s3

serviceId

VARCHAR(36)

A unique identifier for a Service, generated in Service dimension(Bi_DimService).

Bi_DimService_s3

ServiceID

Bi_FactInvoiceItem_s3

SOLDBYS_csv

VARCHAR(MAX)

coma seperated sale by employee ids of the line item.

Bi_FactInvoiceItem_s3

SwitchFromUserMembershipId

VARCHAR(36)

User membership id of the membership from which an upgrade/downgrade is done.

Bi_FactInvoiceItem_s3

Taxes

FLOAT

Final tax applied on the invoice item.

Bi_FactInvoiceItem_s3

Therapistid

VARCHAR(36)

Unique identifier for each employee who is scheduled to service the guest. This is generated in analytics and it does not exist in core.(Bi_DimUser)

Bi_Dimuser_s3

userid

Bi_FactInvoiceItem_s3

TherapistRequestType

INT

A unique identifier that identifies the therapist request type made for the appointment.(Bi_Dimstatus)

Bi_DimStatus_s3

StatusTypeCode

Bi_FactInvoiceItem_s3

UsageType

VARCHAR(160)

This shows whether package usage or membership usage is applied on the invoice item. Membership credit redemptions are not populated as 'membership usage'. Only membership service redemptions are populated as 'membership usage'.

Bi_FactInvoiceItem_s3

UserId

VARCHAR(36)

A unique identifier for the guest, generated in User dimension(Bi_DimUser).

Bi_Dimuser_s3

userid

Bi_FactInvoiceItem_s3

void

BOOLEAN

Indicates if the row should be inserted or deleted. 1- delete, 0-insert

Bi_FactInvoiceItem_s3

feetype

BIGINT

This column helps you to identify the type of fee levied on memberships.

Bi_FactInvoiceItem_s3

groupid

BIGINT

Internal to Zenoti. Used for data processing.

Bi_FactInvoiceItem_s3

AdditionalField

Additional field section in checkout page

nvarchar(max)

Bi_FactInvoiceItem_s3

RefundReasonFK

Reason code for refunding an invoice.

BIGINT

bi_dimreasons_s3 reasonpk

Bi_FactInvoiceItem_s3

utmsource

Helps you the identify the booking source (google, Facebook, Instagram)

NVARCHAR(128)

Bi_FactInvoiceItem_s3

Helps you the identify the booking source (google, Facebook, Instagram)

NVARCHAR(128)

Bi_FactInvoiceItem_s3

BundlePackageID

Helps you identify the bundle package (GUID). In case of multiple bundle packages, then ID remains same.

VARCHAR(36)

Bi_FactInvoiceItem_s3

BundlePackageNo

Helps you identify the number of bundle packages in a invoice.

INT