OPPORTUNITIES¶

This source table stores information about BOLD / Front Office Opportunities.

Columns¶

Column	Data type	Description
`ARCHIVEDATEUTC`	TIMESTAMP_NTZ	The date the Opportunity was archived, stored in UTC.
`BUILDID`	NUMBER	Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows.
`CDCSTATUS`	VARCHAR	For Avionté internal use only.
`EXTERNALDB`	VARCHAR	For Avionté internal use only. Non-null values typically mean the row was imported from another data source.
`LASTUPDATEDDATE`	TIMESTAMP_NTZ	The timestamp when the row was last updated.
`LOSTREASONID`	NUMBER	The identifier for the Lost Reason.
`OLDID`	NUMBER	For Avionté internal use only.
`OPPAMT`	NUMBER	The opportunity amount.
`OPPARCHIVE`	NUMBER	An indicator of whether the opportunity has been archived or not.
`OPPARCHIVEDATE`	TIMESTAMP_NTZ	The date the Opportunity was archived.
`OPPCLOSEDATE`	DATE	The date the Opportunity was closed.
`OPPCOMMIT`	NUMBER	The commit amount for the opportunity.
`OPPCOMP`	NUMBER	The identifier for the opportunity comp.
`OPPCONT`	NUMBER	The identifier for the opportunity contact.
`OPPDATE`	TIMESTAMP_NTZ	The opportunity date.
`OPPID`	NUMBER	The identifier for the opportunity.
`OPPNAME`	VARCHAR	The name of the opportunity.
`OPPNEXTSTEP`	VARCHAR	The next step for the opportunity (e.g., Follow Up, Call).
`OPPNEXTSTEPDATE`	TIMESTAMP_NTZ	The date for the next step.
`OPPOWNER`	NUMBER	The user identifier for the opportunity owner.
`OPPPARTNER`	VARCHAR	The user identifier for the opportunity partner.
`OPPPERC`	NUMBER	The opportunity percent.
`OPPSTAGE`	VARCHAR	The opportunity stage (e.g., Prospecting, Closed/Won).
`OPPSTAGEID`	NUMBER	The identifier for the opportunity stage.
`OPPTYPE`	VARCHAR	The opportunity type (e.g., Contract Service).
`OPPTYPEID`	NUMBER	The identifier for the opportunity type.