Product barcodes dimension table
Bi_DimProductBarcodes
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|
productbarcodewid | unique identifer for the row. Primary key | BIGINT | Y | |
ProductBarcodeId | unique identifer for the row | VARCHAR(36) | ||
ProductId | Unique identifier for the product | VARCHAR(36) | bi_dimproduct productid | |
Barcode | Barcode for the product | VARCHAR(1024) | ||
IsPrimary | Indicates if the barcode is primary barcode or not | boolean | ||
IsCode | Indicates if productcode and Barcode are same | boolean | ||
CreationDate | Date on which bar code is created | datetime | ||
organizationid | unique identifier for the organization | VARCHAR(36) | bi_dimcenter organizationid | |
void | indicates if the row is void | int | ||
etllastupdatedon | date and time on which the row is last updated. Internal to Zenoti | datetime | ||
etllastupdatedby | Sys user who updated the row. Internal to Zenoti | VARCHAR(512) | ||
PodName, | Indicates point of delivery for customer. Internal to Zenoti | VARCHAR(20) | ||
groupid | Indicates the group number in which the row is processed. Internal to Zenoti | BIGINT |