Package dimension table
bi_dimpackage
Field | Description | Field Type | Primary Key |
|---|---|---|---|
active | boolean | ||
allowgiftcertificates | boolean | ||
allowmembershipredemption | boolean | ||
bookingenddate | timestamp without time zone | ||
bookingstartdate | timestamp without time zone | ||
businessunitdescription | varchar ( 65535 ) | ||
businessunitid | varchar ( 36 ) | ||
businessunitname | The business unit to which the package belongs. | varchar ( 800 ) | |
closeontargetcompletion | boolean | ||
comissioneligible | boolean | ||
comissionpercentage | double precision | ||
commissionfactor | double precision | ||
commissiontype | integer | ||
custom | boolean | ||
enddate | timestamp without time zone | ||
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 | |
expirationdate | timestamp without time zone | ||
expirationdays | integer | ||
flatcommissionvalue | double precision | ||
freeqty | integer | ||
graceperiod | varchar ( 40 ) | ||
initiallyrecognized | double precision | ||
iscustomtemplate | boolean | ||
isofferpackage | boolean | ||
metadescription | varchar ( 65535 ) | ||
metakeywords | varchar ( 1024 ) | ||
minpartialamount | numeric | ||
organizationid | varchar ( 36 ) | ||
packagecatalogprice | varchar ( 128 ) | ||
packagecategorydescription | varchar ( 65535 ) | ||
packagecategoryid | varchar ( 36 ) | ||
packagecategoryname | The category to which the package belongs. | varchar ( 800 ) | |
packagecode | Unique code associated with the package. | varchar ( 512 ) | |
packagedesc | varchar ( 65535 ) | ||
packagedisplayname | varchar ( 512 ) | ||
packagefreezecount | integer | ||
packageid | varchar ( 36 ) | ||
packageinternalcost | numeric | ||
packagelength | integer | ||
packagename | The name of the package. | varchar ( 1024 ) | |
packageowner | varchar ( 1024 ) | ||
packageprice | numeric | ||
packagetype | The type of the package. This is usually a day package, series package, or promo package. | integer | |
packagevaliditymodelid | varchar ( 36 ) | ||
packageversionid | varchar ( 36 ) | ||
packageversionwid | bigint | ||
podname | varchar ( 20 ) | ||
prereqqty | integer | ||
redemptionfrequencydays | integer | ||
showincatalog | integer | ||
showprice | boolean | ||
sortorder | integer | ||
tags | The tags associated with the package. | varchar ( 65535 ) | |
targetname | varchar ( 1024 ) | ||
targettype | integer | ||
targetvalue | double precision | ||
templatepackageversionid | Unique identifier associated to each template version of the package. | varchar ( 36 ) | |
visits | integer | ||
void | A flag indicating whether the package is inactive. A package is considered inactive if it has been removed from the system. - True indicates that the package is inactive - False indicates that the package is active | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |
IsServiceBundleDayPackage | Helps you identify whether the package sold is a bundle package. | BOOLEAN |