OPPORTUNITY_AUDIT

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

Columns

Column	Data type	Description
AUDDATE	TIMESTAMP_NTZ	The timestamp the audit record was created.
AUDFROM	VARCHAR	The field's original / from value.
AUDTO	VARCHAR	The field's updated / to value.
AUDTYPE	VARCHAR	An indicator of what was changed (e.g., opp_nextstep_date, opp_nextstep).
AUDUSERID	NUMBER	The user ID for the user that made the change that is being captured in this record.
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.
LASTUPDATEDDATE	TIMESTAMP_NTZ	The timestamp when the row was last updated.
OPPAUDID	NUMBER	The identifier for this record.
OPPID	NUMBER	The identifier for the opportunity.