Opportunities

This table has 1 row per opportunity and per org id.

Note: depending on how mappings are enabled, definitions for fields may differ between customers

ColumnTypeDefinitionSample Value(s)Sample Use
ACCOUNT_IDVarcharThe account ID associated with the opportunity.Maps to the ACCOUNTS table
AMOUNTNumberThe dollar amount associated with the opportunity.
BENTOVarcharA collection of machines that power the Outreach app. Orgs live inside these.This may distinguish orgs that are in different data centers.
CLOSE_DATETimestamp_NTZThe expected Date (not datetime) for the deal to be closed. This is in local time, not UTC.
COMPUTED_CREATED_ATTimestamp_NTZFor backfilled opportunities, this is the synced created at. For opportunities created after sync, computed and standard created_at match.
COMPUTED_CREATOR_IDVarcharMatches creator ID for non-backfilled opportunities. Otherwise a mapping is created based on the plugin.
COMPUTED_CREATOR_TYPEVarcharWill be Plugin unless created post sync.'plugin', 'import', 'user'
CREATED_ATTimestamp_NTZThe date the record was created in Outreach.
CREATOR_IDVarcharThe ID for whomever created a record in Outreach, or who updated it if records are overwritten when changed. Maps to different tables based on the "creator_type" field.
CREATOR_TYPEVarcharThe object type that created this row.'plugin', 'app', 'user', 'trigger', 'import'This will dictate what table the creator_id maps to.
CURRENCY_TYPEVarcharThe ISO code of the opportunity currency.'USD'
CUSTOM_FIELDS_LONGVariantA variant JSON field of custom values that were associated with the opportunity.{custom9: "commit"}
DESCRIPTIONVarcharAny associated descriptions of the opportunity.
DML_ATTimestamp_NTZA datetime (local to server) in which the row was last modified. dml_at can be used to identify updated and new records, but as tables may not see changed records every day, it is not authoritative on when the table was last synced. 2019-01-01 12:14:01:10Where dml_at::date >= current_date-7 This will return all rows modified in the last 7 days.
DML_TYPEVarcharThe type of manipulation that last occurred to a row.'update', 'delete', 'insert', 'backfill', 'backfill-delete'Where dml_type <> 'delete' Excludes deleted rows.
EXTERNAL_CREATED_ATTimestamp_NTZGenerally NULL. Redundant with computed fields.
EXTERNAL_CREATOR_IDVarcharGenerally NULL. Redundant with computed fields.
IDVarcharRepresents an individual row of data in a table. Fields in other tables that match to this ID will be called thisTable_id. e.g. ID in the calls table will appear as the call_id in another table.Count(1), count(id), and count(distinct id) are equivalent in a table without joins or groupings for a given bento & o_id.
IS_DELETED_IN_APPBooleanIs the latest dml_type "delete" or "backfill-delete".Where is_deleted_in_app = false Only keeps undeleted rows.
NAMEVarcharThe name of the opportunity.
NEXT_STEPVarcharA mappable field for the next action to be taken against an opportunity.
OPPORTUNITY_TYPEVarcharThe type of opportunity.
OWNER_IDVarcharThe user that owns the opportunity currently.Maps to the USERS table
O_IDVarcharOrganization ID, also called instance ID. This hashed string reflects a specific Outreach app instance within a bento. This is the ID for your unique Outreach account.Most commonly used on joins alongside other primary keys. where a.o_id = b.o_id and a.id = b.a_id
PROBABILITYNumberA mappable field for probability from 0-100 of a deal closing.
STAGE_IDVarcharThe current stage of the opportunity.Maps to the OPPORTUNITY_STAGES table
STATEVarcharThe current state of the opportunity, defaults to Open, Lost, or Won. More details available in the OPPORTUNITY_STAGES table.'open', 'lost', 'won'
SURROGATE_IDVarcharAn md5 hash of bento, o_id and ID for a table.This can be used to get distinct counts of records if an account has more than 1 org instance. Two orgs will both have a prospect with ID of "1" but each will have a different surrogate ID.
TOUCHED_ATTimestamp_NTZThe last UTC datetime that the opportunity was engaged.
UPDATED_ATTimestamp_NTZThe UTC datetime for the last time this record was updated.2019-01-01 20:14:01:10Almost equivalent to dml_at (but adjusted for time zones), but doesn't include record creation or deletion.