Petty Cash Details Fact Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Records petty cash transaction details including entries, reversals, opening/closing balances, category information, and associated cash register details.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| factsegmentwid | BIGINT IDENTITY | NOT NULL | Surrogate key for the petty cash detail fact record. |
| factsegmentid | INTEGER | NULL | Business/natural key for the fact segment. |
| reportingdate | DATE | NULL | Reporting date for the petty cash entry. |
| enteredon | TIMESTAMP | NULL | Date and time when the entry was recorded. |
| lastupdated | TIMESTAMP | NULL | Timestamp of the last update to the source record. |
| entryid | VARCHAR(36) | NULL | Unique identifier (GUID) of the petty cash entry. |
| entrytypeid | BOOLEAN | NULL | Type identifier for the entry (income vs. expense). |
| entrytype | VARCHAR(50) | NULL | Description of the entry type. |
| salebywid | BIGINT | NULL | Foreign key to the employee who recorded the entry. |
| categoryid | VARCHAR(36) | NULL | GUID of the petty cash category. |
| categoryname | VARCHAR(100) | NULL | Name of the petty cash category. |
| categorydescription | VARCHAR(400) | NULL | Description of the petty cash category. |
| centerwid | BIGINT | NULL | Foreign key to the center dimension. |
| source | VARCHAR(50) | NULL | Source of the petty cash entry. |
| cashregisterid | VARCHAR(36) | NULL | GUID of the associated cash register. |
| cashregistercode | VARCHAR(64) | NULL | Code of the associated cash register. |
| cashregistername | VARCHAR(512) | NULL | Name of the associated cash register. |
| pettycashdescription | VARCHAR(400) | NULL | Description of the petty cash transaction. |
| voucherno | VARCHAR(40) | NULL | Voucher number for the petty cash entry. |
| amount | DOUBLE PRECISION | NULL | Transaction amount. |
| openingbalance | NUMERIC(18,2) | NULL | Petty cash balance at the start of the period. |
| closingbalance | NUMERIC(18,2) | NULL | Petty cash balance at the end of the period. |
| reversalamount | NUMERIC(18,2) | NULL | Amount reversed, if applicable. |
| reversalenteredon | TIMESTAMP | NULL | Date and time when the reversal was entered. |
| void_custom | INTEGER | NULL | Custom void flag. |
| podid | INTEGER | NULL | Identifier of the source pod/database. |
| void | INTEGER | NULL | Indicates whether the record has been voided. |
| cashregisterwid | BIGINT | NULL | Foreign key to the cash register dimension. |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
factsegmentwid
Foreign Keys
| Column | References |
|---|---|
| centerwid | Bi_DimCenter.centerwid |
| salebywid | Bi_DimUser.userwid |
| cashregisterwid | Bi_DimCashRegister.cashregisterwid |
| reportingdate | Bi_DimDate.datewid |
Enumerator Values
| Column | Values |
|---|---|
| entrytypeid | FALSE = Expense, TRUE = Income |
| entrytype | Income Expense |
| void | 0 = active, non-zero = voided |
| void_custom | 0 = Active Non-zero = Voided (Custom) |
| source | 0 = Store (MMS) 1 = Mobile 2 = Web 3 = Imports 4 = Offline 5 = Dunning 6 = Employee App 7 = Manager App 8 = Auto Collection 9 = Biometric App 10 = Support Login 11 = Take 5 12 = Therapist App Android 13 = Therapist App iOS 14 = Mobile POS (Point of Sale) Android 15 = Mobile POS iOS 16 = PoS 17 = Shopify 18 = ECommerce 19 = Instore App 20 = Api Direct 21 = Unknown 22 = Extension 23 = Queue 24 = Kiosk 25 = Kiosk CMA (Customer Mobile App) 26 = Kiosk Web 27 = Invoice Refund 28 = Membership Unfreeze 29 = Membership Cancellation 30 = External CMA 31 = External Webstore 32 = Client App 33 = Bot |
Was this article helpful?
Your feedback helps us improve our documentation.