Package user dimension table
bi_dimpackageuser
Field | Description | Field Type | Primary Key |
|---|---|---|---|
businessunitid | varchar ( 36 ) | ||
centerid | varchar ( 36 ) | ||
closed | boolean | ||
closedby | varchar ( 36 ) | ||
closedinvoice | varchar ( 36 ) | ||
closedon | timestamp without time zone | ||
creationdate | timestamp without time zone | ||
enddate | timestamp without time zone | ||
enddatewithgraceperiod | 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 | |
firstname | varchar ( 1024 ) | ||
invoiceid | varchar ( 36 ) | ||
invoiceitemid | varchar ( 36 ) | ||
lastname | varchar ( 1024 ) | ||
organizationid | varchar ( 36 ) | ||
packagecode | varchar ( 1024 ) | ||
packageid | varchar ( 36 ) | ||
packagename | varchar ( 1024 ) | ||
packageprice | numeric | ||
packagestatus | integer | ||
packageuserid | varchar ( 36 ) | ||
packageuserpk | numeric | ||
packageuserwid | bigint | ||
podid | integer | ||
podname | varchar ( 20 ) | ||
salecenterid | varchar ( 36 ) | ||
startdate | timestamp without time zone | ||
userid | varchar ( 36 ) | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |