ZenotiHelp

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.