ZenotiHelp

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.