Skip to main content

Package benefits dimension table

bi_dimpackagebenefits

Field

Description

Field Type

Primary Key

benefittype

varchar ( 50 )

etllastupdatedby

varchar ( 50 )

etllastupdatedon

timestamp without time zone

itemid

varchar ( 36 )

itemtags

varchar ( 65535 )

itemtype

integer

organizationid

varchar ( 36 )

packagebenefitwid

bigint

packageid

varchar ( 36 )

packageversionid

varchar ( 36 )

pk

integer

podname

varchar ( 20 )

quantity

integer

void

integer

groupid

Internal to Zenoti. Used for data processing.

BIGINT