Product Barcodes Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Dimension table storing barcode associations for products, including primary barcode designation and code-type flags.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| ProductBarcodeWID | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| ProductBarcodeId | VARCHAR(36) | Yes | Source system unique identifier for the product barcode record |
| ProductId | VARCHAR(36) | Yes | Unique identifier of the associated product |
| Barcode | VARCHAR(1024) | Yes | Barcode value/string |
| IsPrimary | BOOLEAN | Yes | Indicates if this is the primary barcode for the product |
| IsCode | BOOLEAN | Yes | Indicates if this entry represents a product code rather than a scanned barcode |
| CreationDate | DATETIME | Yes | Date/time the barcode record was created |
| void | INT | Yes | Soft-delete flag (non-zero indicates voided) |
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
ProductBarcodeWID
Foreign Keys
| Column | References |
|---|---|
| ProductId | the product dimension (Bi_DimProduct or equivalent) |
Was this article helpful?
Your feedback helps us improve our documentation.