Product dimension table
Bi_DimProduct_s3 | BusinessUnitId | VARCHAR(36) | ||
|---|---|---|---|---|
Bi_DimProduct_s3 | CategoryId | VARCHAR(36) | ||
Bi_DimProduct_s3 | CategoryName | NVARCHAR(1024) | ||
Bi_DimProduct_s3 | CategoryCode | NVARCHAR(128) | ||
Bi_DimProduct_s3 | ParentCategoryID | VARCHAR(36) | ||
Bi_DimProduct_s3 | ParentCategoryName | NVARCHAR(1024) | ||
Bi_DimProduct_s3 | ParentCategoryCode | NVARCHAR(128) | ||
Bi_DimProduct_s3 | BusinessUnitName | NVARCHAR(800) | ||
Bi_DimProduct_s3 | BusinessUnitDescription | NVARCHAR(8000) | ||
Bi_DimProduct_s3 | ComissionEligible | BOOLEAN | ||
Bi_DimProduct_s3 | CommissionFactor | FLOAT | ||
Bi_DimProduct_s3 | Consummable | BOOLEAN | ||
Bi_DimProduct_s3 | HasVariant | BOOLEAN | ||
Bi_DimProduct_s3 | IsSouldOut | BOOLEAN | ||
Bi_DimProduct_s3 | LoyaltyEligible | BOOLEAN | ||
Bi_DimProduct_s3 | MetaDescription | NVARCHAR(1024) | ||
Bi_DimProduct_s3 | MetaKeywords | NVARCHAR(1024) | ||
Bi_DimProduct_s3 | MRP | FLOAT | ||
Bi_DimProduct_s3 | organizationID | VARCHAR(36) | ||
Bi_DimProduct_s3 | ProductCatalogPrice | NVARCHAR(256) | ||
Bi_DimProduct_s3 | ProductCode | NVARCHAR(128) | ||
Bi_DimProduct_s3 | ProductDesc | NVARCHAR(4096) | ||
Bi_DimProduct_s3 | ProductDisplayName | NVARCHAR(512) | ||
Bi_DimProduct_s3 | productid | VARCHAR(36) | PK | |
Bi_DimProduct_s3 | ProductName | NVARCHAR(1024) | ||
Bi_DimProduct_s3 | ProductNew | BOOLEAN | ||
Bi_DimProduct_s3 | ProductRecommended | BOOLEAN | ||
Bi_DimProduct_s3 | ProductSortOrder | INT | ||
Bi_DimProduct_s3 | Retail | BOOLEAN | ||
Bi_DimProduct_s3 | TransferPrice | FLOAT | ||
Bi_DimProduct_s3 | Volumeperitem | FLOAT | ||
Bi_DimProduct_s3 | VolumeTypeName | NVARCHAR(256) | ||
Bi_DimProduct_s3 | void | BOOLEAN | ||
Bi_DimProduct_s3 | TAGS | VARCHAR(MAX) | ||
Bi_DimProduct_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimProduct_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimProduct_s3 | ProductColorName | NVARCHAR(1024) | ||
Bi_DimProduct_s3 | ProductSizeName | NVARCHAR(1024) | ||
Bi_DimProduct_s3 | BrandId | VARCHAR(36) | ||
Bi_DimProduct_s3 | BrandCode | VARCHAR(512) | ||
Bi_DimProduct_s3 | BrandName | VARCHAR(512) | ||
Bi_DimProduct_s3 | PodName | VARCHAR(20) | ||
Bi_DimProduct_s3 | groupid | BIGINT |