Items dimension table
bi_dimitems
Field | Description | Field Type | Primary Key |
|---|---|---|---|
businessunitid | varchar ( 65535 ) | ||
businessunitname | The business unit to which the item belongs. | varchar ( 65535 ) | |
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 | |
itemcode | The unique code of the item sold. For example, if item type code = Service, then item code is the code associated with that service. If item type code = Product, then item code is the code associated with that product. It is slightly different for a gift card. If item type code = Gift card, then item code is unique for every gift card sold. | varchar ( 256 ) | |
itemid | varchar ( 36 ) | ||
itemname | The name of the item. For example, if item type code = Service, then item name is the name of the service. If item type code = Product, then item name is the name the product. | varchar ( 512 ) | |
itemwid | bigint | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
tags | The tags associated with the item. | varchar ( 65535 ) | |
void | This flag indicates whether the item is inactive. An item is considered inactive if it has been removed from the system. - True indicates that the item is inactive. - False indicates that the Item is active. | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |