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