Invoice item taxes fact table
bi_factinvoiceitemtaxes
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
factinvoiceitemtaxeswid | BIGINT | Unique identifier for the row. Primary key | yes | ||
invoiceitemtaxpk | BIGINT | Identifier from core data base. Internal to Zenoti | |||
invoiceitemtaxid | VARCHAR(36) | Identifier from core data base. Internal to Zenoti | |||
taxgroupdetailswid | BIGINT | unique identifier of row in mapped dimension table | bi_dimtaxgroupdetails taxgroupdetailswid | ||
taxtypeid | VARCHAR(36) | ID of tax component applied | bi_dimtaxgroupdetails TaxTypeId | ||
taxgroupid | VARCHAR(36) | ID of tax group applied | bi_dimtaxgroupdetails taxgroupid | ||
invoiceitemid | VARCHAR(36) | unique identifier of an item in an invoice | |||
centerwid | BIGINT, | unique identifer for center | bi_dimcenter centerwid | ||
taxamount | NUMERIC(19,4) | amount of tax applied | |||
OrderofApplication | INT | order in which tax type is applied when compared to other taxes in same tax group | |||
createddate | DATE | date on which invoice is created | |||
LastUpdated | DATE | latest date on which entry is updated | |||
etlcreatedby | NUMERIC(19,0) | ETL system admin user who inserted or updated the corresponding record in this table. | |||
etlcreateddate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
podname | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
organizationid | VARCHAR(36) | A unique identifier for the organition for which this data belongs | bi_dimcenter organizationid | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||