Opportunity source dimension table
bi_dimopportunitysource
Field | Description | Field Type | Primary Key |
|---|---|---|---|
active | boolean | ||
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 | |
opportunitysourcecode | Code assigned to the opportunity source. | varchar ( 256 ) | |
opportunitysourcedescription | Description of the opportunity source. | varchar ( 4096 ) | |
opportunitysourceid | varchar ( 36 ) | ||
opportunitysourcename | Source of the opportunity. | varchar ( 256 ) | |
opportunitysourcewid | bigint | ||
optionalfield1 | Optional field 1 to add more information about the opportunity source. | varchar ( 16000 ) | |
optionalfield2 | Optional field 2 to add more information about the opportunity source. | varchar ( 16000 ) | |
optionalfield3 | Optional field 3 to add more information about the opportunity source. | varchar ( 16000 ) | |
optionalfield4 | Optional field 4 to add more information about the opportunity source. | varchar ( 16000 ) | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |