ZenotiHelp

Product Batches Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing product batch information including batch numbers, expiry dates, and their association with products and organizations.

Columns

Column Name Data Type Nullable Description
batchwid BIGINT IDENTITY No Surrogate warehouse key for the product batch record
batchpk DECIMAL(19,0) Yes Source system primary key for the batch
batchid VARCHAR(36) Yes Unique identifier (GUID) for the product batch
batchnumber VARCHAR(256) Yes Human-readable batch number assigned to the product batch
ProductId VARCHAR(36) Yes Unique identifier (GUID) of the product associated with this batch
batchexpiry TIMESTAMP Yes Expiry date/time of the product batch
Void BOOLEAN Yes Indicates whether the record has been voided/soft-deleted

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

batchwid

Foreign Keys

Column References
ProductId Product entity in the source system

Enumerator Values

Column Values
Void FALSE = Active
TRUE = Voided
Was this article helpful?
Your feedback helps us improve our documentation.