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.