ZenotiHelp

Opportunity Custom Field Values Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Stores custom field values associated with sales opportunities, linking field definitions to their values per opportunity and center.

Columns

Column Name Data Type Nullable Description
opportunityfieldvaluewid BIGINT IDENTITY NOT NULL Surrogate key and primary key for the opportunity custom field value record.
opportunityfieldvalueid VARCHAR(36) YES GUID identifier for the opportunity field value.
fieldwid BIGINT YES Foreign key to the custom field dimension.
opportunityid VARCHAR(36) YES GUID of the associated opportunity.
value VARCHAR(32000) YES The custom field value.
centerwid BIGINT YES Foreign key to the center dimension (Bi_DimCenter.centerwid).
isactive BOOLEAN YES Flag indicating whether the field value is active.
podid INTEGER YES Identifier for the pod (database partition).
void BOOLEAN YES Soft-delete flag indicating the record is logically deleted.

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

opportunityfieldvaluewid

Foreign Keys

Column References
centerwid Bi_DimCenter.centerwid

Enumerator Values

Column Values
isactive TRUE if the field value is active; FALSE otherwise.
void TRUE if the record is soft-deleted; FALSE otherwise.
Was this article helpful?
Your feedback helps us improve our documentation.