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.