Product dimension table
bi_dimproduct
Field | Description | Field Type | Primary Key |
|---|---|---|---|
brandcode | varchar ( 512 ) | ||
brandid | varchar ( 36 ) | ||
brandname | varchar ( 512 ) | ||
businessunitdescription | varchar ( 65535 ) | ||
businessunitid | varchar ( 36 ) | ||
businessunitname | The business unit to which the item belongs. | varchar ( 800 ) | |
categorycode | varchar ( 128 ) | ||
categoryid | varchar ( 36 ) | ||
categoryname | The category of the product. This is setup as sub-category in core. | varchar ( 65535 ) | |
comissioneligible | boolean | ||
commissionfactor | double precision | ||
consummable | This flag indicates whether the product can be consumed as part of a service. - True indicates that the product can also be a consumable. - False indicates that the product is not a consumable. | boolean | |
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
hasvariant | This flag indicates whether the product has a variant. - True indicates that the product has a variant. - False indicates that the product does not have a variant. - Not applicable. | boolean | |
issouldout | boolean | ||
loyaltyeligible | boolean | ||
metadescription | varchar ( 1024 ) | ||
metakeywords | varchar ( 1024 ) | ||
mrp | Maximum price at which the product can be sold in retail | double precision | |
organizationid | varchar ( 36 ) | ||
parentcategorycode | varchar ( 128 ) | ||
parentcategoryid | varchar ( 36 ) | ||
parentcategoryname | The parent category of the product. This is setup as category in core. | varchar ( 65535 ) | |
podname | Indicates the region of the business, applicable for businesses spread across global locations. Acts as a differentiator to identify data of different regions. | varchar ( 20 ) | |
productcatalogprice | varchar ( 256 ) | ||
productcode | Unique code associated with the product. | varchar ( 128 ) | |
productcolorname | The color name associated with the product. | varchar ( 2048 ) | |
productdesc | varchar ( 65535 ) | ||
productdisplayname | varchar ( 512 ) | ||
productid | varchar ( 36 ) | ||
productname | The name of the product. | varchar ( 1024 ) | |
productnew | boolean | ||
productrecommended | boolean | ||
productsizename | The size name associated with the product. | varchar ( 2048 ) | |
productsortorder | integer | ||
productwid | bigint | ||
retail | This flag indicates whether the product can be sold as a retail product. - True indicates that the product can be sold as a retail product. - False indicates that the product cannot be sold as a retail product. | boolean | |
tags | The tags associated with the product. | varchar ( 65535 ) | |
transferprice | double precision | ||
void | This flag indicates whether the product is inactive. A product is considered inactive if it has been removed from the system. - True indicates that the product is inactive. - False indicates that the product is active. | boolean | |
volumeperitem | Per item volume of the sold product. For example, if the sold product is a 150 ml shampoo, this field would display '150'. The unit of the volume is recorded in the 'product volume type name' field. | double precision | |
volumetypename | Unit of the volume populated in the 'product volume per item' field. For example, if the product sold is a 150 ml shampoo, this field would display 'ml'. | varchar ( 36 ) | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |