Product categories dimension table
bi_dimcategoryproducts
Field | Description | Field Type | Primary Key |
|---|---|---|---|
categoryid | varchar ( 36 ) | ||
etllastupdatedby | varchar ( 50 ) | ||
etllastupdatedon | timestamp without time zone | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
productcategorypk | numeric | ||
productcategorywid | bigint | ||
productid | varchar ( 36 ) | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |