ZenotiHelp

Invoice Item Taxes Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Stores tax amounts applied to individual invoice items, including tax group and type details, order of application, and associated center information.

Columns

Column Name Data Type Nullable Description
factinvoiceitemtaxeswid BIGINT IDENTITY NOT NULL Surrogate key for the invoice item taxes fact record
invoiceitemtaxpk BIGINT NULL Source system primary key for the invoice item tax
invoiceitemtaxid VARCHAR(36) NULL Unique identifier (GUID) of the invoice item tax record
taxgroupdetailswid BIGINT NULL Foreign key to the tax group details dimension
taxtypeid VARCHAR(36) NULL Unique identifier (GUID) of the tax type
taxgroupid VARCHAR(36) NOT NULL Unique identifier (GUID) of the tax group
invoiceitemid VARCHAR(36) NULL Unique identifier (GUID) of the invoice item
centerwid BIGINT NULL Foreign key to the center dimension
taxamount NUMERIC(19,4) NULL Tax amount applied to the invoice item
OrderofApplication INT NULL Order in which the tax is applied (for compound taxes)
createddate DATE NOT NULL Date when the tax record was created
LastUpdated TIMESTAMP NULL Timestamp of the last update to the source record
void BOOLEAN NULL Indicates whether the record has been voided

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

Primary Key

factinvoiceitemtaxeswid

Foreign Keys

Column References
centerwid Bi_DimCenter.centerwid
createddate Bi_DimDate.datewid

Enumerator Values

Column Values
void FALSE = Active, TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.