Product center dimension table
bi_dimproductcenter
Field | Description | Field Type | Primary Key |
|---|---|---|---|
alertinventory | double precision | ||
centerid | varchar ( 36 ) | ||
centertaxid | varchar ( 36 ) | ||
consumablealertinventory | double precision | ||
consumabledesiredinventory | double precision | ||
consumableorderinventory | double precision | ||
desiredinventory | double precision | ||
etllastupdatedby | varchar ( 50 ) | ||
etllastupdatedon | timestamp without time zone | ||
includestax | boolean | ||
orderinventory | double precision | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
productcenterid | varchar ( 36 ) | ||
productcenterwid | bigint | ||
productid | varchar ( 36 ) | ||
saleprice | double precision | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |
taxgroupid | Indicates the tax group that is associated with the product at the center. Join with bi_dimtaxgroupdetails on “taxgroupid” column for more details. | varchar ( 36 ) | |
taxgroupname | Indicates the tax group name that is associated with the product at the center. Join with bi_dimtaxgroupdetails on “taxgroupname” column for more details. | nvarchar ( 1020 ) |