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.