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 namereferences DimCenter- Entered-by employee columns reference DimEmployee
cash register idreferences 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.