ZenotiHelp

Pettycash Fact Consolidated

ZTZenoti Docs Team Updated April 10, 2026 3 min readGuide

Consolidated fact table storing petty cash transactions including entries, reversals, opening/closing balances, and associated cash register and employee details.

Columns

Column Name Data Type Nullable Description
organization name VARCHAR(512) YES Name of the organization. Sourced from DimOrganization.organization_name.
organization account name VARCHAR(256) YES Account name of the organization. Sourced from DimOrganization.organization_account_name.
center name VARCHAR(128) YES Name of the center. Sourced from DimCenter.center_name.
center company name VARCHAR(128) YES Company name associated with the center. Sourced from DimCenter.center_company_name.
reporting date DATE YES Reporting date for the petty cash entry.
entered on TIMESTAMP WITHOUT TIME ZONE YES Date and time when the entry was created.
last updated TIMESTAMP WITHOUT TIME ZONE YES Date and time when the entry was last updated.
entry id VARCHAR(36) YES Unique identifier for the petty cash entry.
entry type VARCHAR(50) YES Type of petty cash entry (e.g., Cash In, Cash Out).
category id VARCHAR(36) YES Unique identifier for the petty cash category.
category name VARCHAR(100) YES Name of the petty cash category.
category description VARCHAR(400) YES Description of the petty cash category.
source VARCHAR(50) YES Source of the petty cash entry.
cash register id VARCHAR(36) YES Unique identifier of the cash register.
cash register code VARCHAR(64) YES Code assigned to the cash register.
cash register name VARCHAR(512) YES Name of the cash register.
petty cash description VARCHAR(400) YES Description of the petty cash transaction.
voucher no VARCHAR(40) YES Voucher number associated with the entry.
amount DOUBLE PRECISION YES Amount of the petty cash transaction.
opening balance NUMERIC(18,2) YES Opening balance of the petty cash register.
closing balance NUMERIC(18,2) YES Closing balance of the petty cash register.
reversal amount NUMERIC(18,2) YES Amount reversed, if applicable.
reversal entered on TIMESTAMP WITHOUT TIME ZONE YES Date and time when the reversal was entered.
void INTEGER YES Indicates whether the entry has been voided (1 = voided).
entered by employee first name VARCHAR(160) YES First name of the employee who entered the transaction. Sourced from DimEmployee.employee_first_name.
entered by employee middle name VARCHAR(256) YES Middle name of the employee who entered the transaction. Sourced from DimEmployee.employee_middle_name.
entered by employee last name VARCHAR(256) YES Last name of the employee who entered the transaction. Sourced from DimEmployee.employee_last_name.
entered by employee code VARCHAR(128) YES Code of the employee who entered the transaction. Sourced from DimEmployee.employee_code.
entered by employee - code VARCHAR(128) YES Alternate code format for the employee who entered the transaction. Sourced from DimEmployee.employee_code.
entered by employee job name VARCHAR(1020) YES Job title of the employee who entered the transaction. Sourced from DimEmployee.employee_job_name.
entered by employee job code VARCHAR(1020) YES Job code of the employee who entered the transaction. Sourced from DimEmployee.employee_job_code.
is center franchise BOOLEAN YES Indicates whether the center is a franchise location. Sourced from DimCenter.is_center_franchise.
center cstn number VARCHAR(80) YES CSTN number of the center. Sourced from DimCenter.center_cstn_number.
center tin number VARCHAR(80) YES TIN number of the center. Sourced from DimCenter.center_tin_number.
center tot number VARCHAR(80) YES TOT number of the center. Sourced from DimCenter.center_tot_number.
center service tax number VARCHAR(80) YES Service tax number of the center. Sourced from DimCenter.center_service_tax_number.
center vat number VARCHAR(80) YES VAT number of the center. Sourced from DimCenter.center_vat_number.
center luxary tax number VARCHAR(80) YES Luxury tax number of the center. Sourced from DimCenter.center_luxary_tax_number.
minutes to add INTEGER YES Time zone offset in minutes to convert to center local time.
Center Code VARCHAR(40) YES Code assigned to the center. Sourced from DimCenter.center_code.

Primary Key

entry id (VARCHAR(36))

Foreign Keys

  • center name references DimCenter
  • Entered-by employee columns reference DimEmployee
  • cash register id references the cash register dimension

Enumerator Values

Column Name Known Values
entry type Cash In, Cash Out
source Source origin values
void 0 = Active, 1 = Voided

Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.

Was this article helpful?
Your feedback helps us improve our documentation.