Invoice item taxes fact table
Bi_FactInvoiceitemTaxes_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
invoiceitemtaxpk | BIGINT | Identifier from core data base. Internal to Zenoti | |||
invoiceitemtaxid | VARCHAR(36) | Unique identifier for the row. Primary key | yes | ||
taxtypedetailId | VARCHAR(36) | unique identifier of row in mapped dimension table | Bi_DimTaxGroupDetails_s3 taxtypedetailId | ||
taxtypeid | VARCHAR(36) | ID of tax component applied | Bi_DimTaxGroupDetails_s3 TaxTypeId | ||
taxgroupid | VARCHAR(36) | ID of tax group applied | Bi_DimTaxGroupDetails_s3 taxgroupid | ||
invoiceitemid | VARCHAR(36) | unique identifier of an item in an invoice | |||
centerid | VARCHAR(36) | unique identifer for center | bi_dimcenter_s3 centerid | ||
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_s3 organizationid | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||