Opportunities
The opportunities view object stores details about the opportunity such as customer, sales method and sales stage. This view object contains extensible columns that support 350 fields of type string, 200 fields of type number, 50 fields of type time and 25 fields of type CLOB.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.MooBiccExtractAM.OpportunityExtractPVO
Primary Keys : OptyId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
AssetId | The unique identifier of the asset associated with the opportunities. |
AssignmentImpactedDate | This attribute is used for incremental territory based assignment. |
BatchTag | This attribute is used to tag opportunities for inclusion in a batch job, such as the batch assignment of opportunities. |
BdgtAmt | The amount budgeted for this opportunity. |
BdgtAmtCurcyCd | The currency code for the budgeted amount. |
BdgtAvailableDt | The date when the budget will be available. |
BdgtedFlg | Indicates if the opportunity target has been budgeted for procuring the solution proposed by this opportunity. A list of accepted values is defined in the lookup type YES_NO. |
BuOrgId | The unique identifier of the business unit to which this opportunity belongs. |
ChampionFlag | Indicates if the opportunity has an internal sponsor. If the value is true, then the opportunity has an internal sponsor. The default value is False. |
ChannelTypeCd | The sales channel from which the opportunity originates. A list of accepted values is defined in the lookup type SALES_CHANNEL_TYPE. |
Comments | The user-provided comments for the opportunity. |
CorpCurrencyCode | The transaction currency for extensibility. |
CreatedBy | The user who created the opportunity row. |
CreationDate | The date and time when the opportunity row was created. |
CurcyConvRateType | The currency conversion rate type for extensibility. |
CurrStgId | The identifier of the current stage for the opportunities. This is a foreign key of the Sales Stage view object. |
CurrencyCode | The currency code for extensibility. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. |
CustAccountId | The identifier of the customer account for the opportunities. This is a foreign key of the Customer Account view object. |
CustPartyId | The identifier of the customer party for the opportunities. This is a foreign key of the Parties view object. |
CustPartyType | The party type of the associated account. A list of accepted values is defined in the lookup type ZCA_RECORD_TYPE. |
DealHorizonCode | The code indicating the estimated time, in days, required to close the deal. A list of valid values is defined in the lookup MOO_SETID_DEAL_HORIZON. |
DealHorizonCodeSetId | The SetId of the deal horizon code for this opportunity. |
DecisionLvlCode | The code indicating the job level of the person who takes the final decision for the opportunity. A list of valid values is defined in the lookup MOO_SETID_DECISION_LEVEL. |
DecisionLvlCodeSetId | The SetId of the decision level code for this opportunity. |
DescText | The description of the opportunity including the sales objective. The sales representative provides the description. |
EffectiveDate | The date when the opportunity is expected to close. |
ExtnAttributeChar001 | A column reserved for custom extension attributes of type string for the opportunity. |
ExtnAttributeChar002 | |
ExtnAttributeChar003 | |
ExtnAttributeChar004 | |
ExtnAttributeChar005 | |
ExtnAttributeChar006 | |
ExtnAttributeChar007 | |
ExtnAttributeChar008 | |
ExtnAttributeChar009 | |
ExtnAttributeChar010 | |
ExtnAttributeChar011 | |
ExtnAttributeChar012 | |
ExtnAttributeChar013 | |
ExtnAttributeChar014 | |
ExtnAttributeChar015 | |
ExtnAttributeChar016 | |
ExtnAttributeChar017 | |
ExtnAttributeChar018 | |
ExtnAttributeChar019 | |
ExtnAttributeChar020 | |
ExtnAttributeChar021 | |
ExtnAttributeChar022 | |
ExtnAttributeChar023 | |
ExtnAttributeChar024 | |
ExtnAttributeChar025 | |
ExtnAttributeChar026 | |
ExtnAttributeChar027 | |
ExtnAttributeChar028 | |
ExtnAttributeChar029 | |
ExtnAttributeChar030 | |
ExtnAttributeChar031 | |
ExtnAttributeChar032 | |
ExtnAttributeChar033 | |
ExtnAttributeChar034 | |
ExtnAttributeChar035 | |
ExtnAttributeChar036 | |
ExtnAttributeChar037 | |
ExtnAttributeChar038 | |
ExtnAttributeChar039 | |
ExtnAttributeChar040 | |
ExtnAttributeChar041 | |
ExtnAttributeChar042 | |
ExtnAttributeChar043 | |
ExtnAttributeChar044 | |
ExtnAttributeChar045 | |
ExtnAttributeChar046 | |
ExtnAttributeChar047 | |
ExtnAttributeChar048 | |
ExtnAttributeChar049 | |
ExtnAttributeChar050 | |
ExtnAttributeChar051 | |
ExtnAttributeChar052 | |
ExtnAttributeChar053 | |
ExtnAttributeChar054 | |
ExtnAttributeChar055 | |
ExtnAttributeChar056 | |
ExtnAttributeChar057 | |
ExtnAttributeChar058 | |
ExtnAttributeChar059 | |
ExtnAttributeChar060 | |
ExtnAttributeChar061 | |
ExtnAttributeChar062 | |
ExtnAttributeChar063 | |
ExtnAttributeChar064 | |
ExtnAttributeChar065 | |
ExtnAttributeChar066 | |
ExtnAttributeChar067 | |
ExtnAttributeChar068 | |
ExtnAttributeChar069 | |
ExtnAttributeChar070 | |
ExtnAttributeChar071 | |
ExtnAttributeChar072 | |
ExtnAttributeChar073 | |
ExtnAttributeChar074 | |
ExtnAttributeChar075 | |
ExtnAttributeChar076 | |
ExtnAttributeChar077 | |
ExtnAttributeChar078 | |
ExtnAttributeChar079 | |
ExtnAttributeChar080 | |
ExtnAttributeChar081 | |
ExtnAttributeChar082 | |
ExtnAttributeChar083 | |
ExtnAttributeChar084 | |
ExtnAttributeChar085 | |
ExtnAttributeChar086 | |
ExtnAttributeChar087 | |
ExtnAttributeChar088 | |
ExtnAttributeChar089 | |
ExtnAttributeChar090 | |
ExtnAttributeChar091 | |
ExtnAttributeChar092 | |
ExtnAttributeChar093 | |
ExtnAttributeChar094 | |
ExtnAttributeChar095 | |
ExtnAttributeChar096 | |
ExtnAttributeChar097 | |
ExtnAttributeChar098 | |
ExtnAttributeChar099 | |
ExtnAttributeChar100 | |
ExtnAttributeChar101 | |
ExtnAttributeChar102 | |
ExtnAttributeChar103 | |
ExtnAttributeChar104 | |
ExtnAttributeChar105 | |
ExtnAttributeChar106 | |
ExtnAttributeChar107 | |
ExtnAttributeChar108 | |
ExtnAttributeChar109 | |
ExtnAttributeChar110 | |
ExtnAttributeChar111 | |
ExtnAttributeChar112 | |
ExtnAttributeChar113 | |
ExtnAttributeChar114 | |
ExtnAttributeChar115 | |
ExtnAttributeChar116 | |
ExtnAttributeChar117 | |
ExtnAttributeChar118 | |
ExtnAttributeChar119 | |
ExtnAttributeChar120 | |
ExtnAttributeChar121 | |
ExtnAttributeChar122 | |
ExtnAttributeChar123 | |
ExtnAttributeChar124 | |
ExtnAttributeChar125 | |
ExtnAttributeChar126 | |
ExtnAttributeChar127 | |
ExtnAttributeChar128 | |
ExtnAttributeChar129 | |
ExtnAttributeChar130 | |
ExtnAttributeChar131 | |
ExtnAttributeChar132 | |
ExtnAttributeChar133 | |
ExtnAttributeChar134 | |
ExtnAttributeChar135 | |
ExtnAttributeChar136 | |
ExtnAttributeChar137 | |
ExtnAttributeChar138 | |
ExtnAttributeChar139 | |
ExtnAttributeChar140 | |
ExtnAttributeChar141 | |
ExtnAttributeChar142 | |
ExtnAttributeChar143 | |
ExtnAttributeChar144 | |
ExtnAttributeChar145 | |
ExtnAttributeChar146 | |
ExtnAttributeChar147 | |
ExtnAttributeChar148 | |
ExtnAttributeChar149 | |
ExtnAttributeChar150 | |
ExtnAttributeChar151 | |
ExtnAttributeChar152 | |
ExtnAttributeChar153 | |
ExtnAttributeChar154 | |
ExtnAttributeChar155 | |
ExtnAttributeChar156 | |
ExtnAttributeChar157 | |
ExtnAttributeChar158 | |
ExtnAttributeChar159 | |
ExtnAttributeChar160 | |
ExtnAttributeChar161 | |
ExtnAttributeChar162 | |
ExtnAttributeChar163 | |
ExtnAttributeChar164 | |
ExtnAttributeChar165 | |
ExtnAttributeChar166 | |
ExtnAttributeChar167 | |
ExtnAttributeChar168 | |
ExtnAttributeChar169 | |
ExtnAttributeChar170 | |
ExtnAttributeChar171 | |
ExtnAttributeChar172 | |
ExtnAttributeChar173 | |
ExtnAttributeChar174 | |
ExtnAttributeChar175 | |
ExtnAttributeChar176 | |
ExtnAttributeChar177 | |
ExtnAttributeChar178 | |
ExtnAttributeChar179 | |
ExtnAttributeChar180 | |
ExtnAttributeChar181 | |
ExtnAttributeChar182 | |
ExtnAttributeChar183 | |
ExtnAttributeChar184 | |
ExtnAttributeChar185 | |
ExtnAttributeChar186 | |
ExtnAttributeChar187 | |
ExtnAttributeChar188 | |
ExtnAttributeChar189 | |
ExtnAttributeChar190 | |
ExtnAttributeChar191 | |
ExtnAttributeChar192 | |
ExtnAttributeChar193 | |
ExtnAttributeChar194 | |
ExtnAttributeChar195 | |
ExtnAttributeChar196 | |
ExtnAttributeChar197 | |
ExtnAttributeChar198 | |
ExtnAttributeChar199 | |
ExtnAttributeChar200 | |
ExtnAttributeChar201 | |
ExtnAttributeChar202 | |
ExtnAttributeChar203 | |
ExtnAttributeChar204 | |
ExtnAttributeChar205 | |
ExtnAttributeChar206 | |
ExtnAttributeChar207 | |
ExtnAttributeChar208 | |
ExtnAttributeChar209 | |
ExtnAttributeChar210 | |
ExtnAttributeChar211 | |
ExtnAttributeChar212 | |
ExtnAttributeChar213 | |
ExtnAttributeChar214 | |
ExtnAttributeChar215 | |
ExtnAttributeChar216 | |
ExtnAttributeChar217 | |
ExtnAttributeChar218 | |
ExtnAttributeChar219 | |
ExtnAttributeChar220 | |
ExtnAttributeChar221 | |
ExtnAttributeChar222 | |
ExtnAttributeChar223 | |
ExtnAttributeChar224 | |
ExtnAttributeChar225 | |
ExtnAttributeChar226 | |
ExtnAttributeChar227 | |
ExtnAttributeChar228 | |
ExtnAttributeChar229 | |
ExtnAttributeChar230 | |
ExtnAttributeChar231 | |
ExtnAttributeChar232 | |
ExtnAttributeChar233 | |
ExtnAttributeChar234 | |
ExtnAttributeChar235 | |
ExtnAttributeChar236 | |
ExtnAttributeChar237 | |
ExtnAttributeChar238 | |
ExtnAttributeChar239 | |
ExtnAttributeChar240 | |
ExtnAttributeChar241 | |
ExtnAttributeChar242 | |
ExtnAttributeChar243 | |
ExtnAttributeChar244 | |
ExtnAttributeChar245 | |
ExtnAttributeChar246 | |
ExtnAttributeChar247 | |
ExtnAttributeChar248 | |
ExtnAttributeChar249 | |
ExtnAttributeChar250 | |
ExtnAttributeChar251 | |
ExtnAttributeChar252 | |
ExtnAttributeChar253 | |
ExtnAttributeChar254 | |
ExtnAttributeChar255 | |
ExtnAttributeChar256 | |
ExtnAttributeChar257 | |
ExtnAttributeChar258 | |
ExtnAttributeChar259 | |
ExtnAttributeChar260 | |
ExtnAttributeChar261 | |
ExtnAttributeChar262 | |
ExtnAttributeChar263 | |
ExtnAttributeChar264 | |
ExtnAttributeChar265 | |
ExtnAttributeChar266 | |
ExtnAttributeChar267 | |
ExtnAttributeChar268 | |
ExtnAttributeChar269 | |
ExtnAttributeChar270 | |
ExtnAttributeChar271 | |
ExtnAttributeChar272 | |
ExtnAttributeChar273 | |
ExtnAttributeChar274 | |
ExtnAttributeChar275 | |
ExtnAttributeChar276 | |
ExtnAttributeChar277 | |
ExtnAttributeChar278 | |
ExtnAttributeChar279 | |
ExtnAttributeChar280 | |
ExtnAttributeChar281 | |
ExtnAttributeChar282 | |
ExtnAttributeChar283 | |
ExtnAttributeChar284 | |
ExtnAttributeChar285 | |
ExtnAttributeChar286 | |
ExtnAttributeChar287 | |
ExtnAttributeChar288 | |
ExtnAttributeChar289 | |
ExtnAttributeChar290 | |
ExtnAttributeChar291 | |
ExtnAttributeChar292 | |
ExtnAttributeChar293 | |
ExtnAttributeChar294 | |
ExtnAttributeChar295 | |
ExtnAttributeChar296 | |
ExtnAttributeChar297 | |
ExtnAttributeChar298 | |
ExtnAttributeChar299 | |
ExtnAttributeChar300 | |
ExtnAttributeChar301 | |
ExtnAttributeChar302 | |
ExtnAttributeChar303 | |
ExtnAttributeChar304 | |
ExtnAttributeChar305 | |
ExtnAttributeChar306 | |
ExtnAttributeChar307 | |
ExtnAttributeChar308 | |
ExtnAttributeChar309 | |
ExtnAttributeChar310 | |
ExtnAttributeChar311 | |
ExtnAttributeChar312 | |
ExtnAttributeChar313 | |
ExtnAttributeChar314 | |
ExtnAttributeChar315 | |
ExtnAttributeChar316 | |
ExtnAttributeChar317 | |
ExtnAttributeChar318 | |
ExtnAttributeChar319 | |
ExtnAttributeChar320 | |
ExtnAttributeChar321 | |
ExtnAttributeChar322 | |
ExtnAttributeChar323 | |
ExtnAttributeChar324 | |
ExtnAttributeChar325 | |
ExtnAttributeChar326 | |
ExtnAttributeChar327 | |
ExtnAttributeChar328 | |
ExtnAttributeChar329 | |
ExtnAttributeChar330 | |
ExtnAttributeChar331 | |
ExtnAttributeChar332 | |
ExtnAttributeChar333 | |
ExtnAttributeChar334 | |
ExtnAttributeChar335 | |
ExtnAttributeChar336 | |
ExtnAttributeChar337 | |
ExtnAttributeChar338 | |
ExtnAttributeChar339 | |
ExtnAttributeChar340 | |
ExtnAttributeChar341 | |
ExtnAttributeChar342 | |
ExtnAttributeChar343 | |
ExtnAttributeChar344 | |
ExtnAttributeChar345 | |
ExtnAttributeChar346 | |
ExtnAttributeChar347 | |
ExtnAttributeChar348 | |
ExtnAttributeChar349 | |
ExtnAttributeChar350 | |
ExtnAttributeClob001 | A column reserved for custom extension attributes of type CLOB for the opportunity. |
ExtnAttributeClob002 | |
ExtnAttributeClob003 | |
ExtnAttributeClob004 | |
ExtnAttributeClob005 | |
ExtnAttributeClob006 | |
ExtnAttributeClob007 | |
ExtnAttributeClob008 | |
ExtnAttributeClob009 | |
ExtnAttributeClob010 | |
ExtnAttributeClob011 | |
ExtnAttributeClob012 | |
ExtnAttributeClob013 | |
ExtnAttributeClob014 | |
ExtnAttributeClob015 | |
ExtnAttributeClob016 | |
ExtnAttributeClob017 | |
ExtnAttributeClob018 | |
ExtnAttributeClob019 | |
ExtnAttributeClob020 | |
ExtnAttributeClob021 | |
ExtnAttributeClob022 | |
ExtnAttributeClob023 | |
ExtnAttributeClob024 | |
ExtnAttributeClob025 | |
ExtnAttributeNumber001 | A column reserved for custom extension attributes of type number for the opportunity. |
ExtnAttributeNumber002 | |
ExtnAttributeNumber003 | |
ExtnAttributeNumber004 | |
ExtnAttributeNumber005 | |
ExtnAttributeNumber006 | |
ExtnAttributeNumber007 | |
ExtnAttributeNumber008 | |
ExtnAttributeNumber009 | |
ExtnAttributeNumber010 | |
ExtnAttributeNumber011 | |
ExtnAttributeNumber012 | |
ExtnAttributeNumber013 | |
ExtnAttributeNumber014 | |
ExtnAttributeNumber015 | |
ExtnAttributeNumber016 | |
ExtnAttributeNumber017 | |
ExtnAttributeNumber018 | |
ExtnAttributeNumber019 | |
ExtnAttributeNumber020 | |
ExtnAttributeNumber021 | |
ExtnAttributeNumber022 | |
ExtnAttributeNumber023 | |
ExtnAttributeNumber024 | |
ExtnAttributeNumber025 | |
ExtnAttributeNumber026 | |
ExtnAttributeNumber027 | |
ExtnAttributeNumber028 | |
ExtnAttributeNumber029 | |
ExtnAttributeNumber030 | |
ExtnAttributeNumber031 | |
ExtnAttributeNumber032 | |
ExtnAttributeNumber033 | |
ExtnAttributeNumber034 | |
ExtnAttributeNumber035 | |
ExtnAttributeNumber036 | |
ExtnAttributeNumber037 | |
ExtnAttributeNumber038 | |
ExtnAttributeNumber039 | |
ExtnAttributeNumber040 | |
ExtnAttributeNumber041 | |
ExtnAttributeNumber042 | |
ExtnAttributeNumber043 | |
ExtnAttributeNumber044 | |
ExtnAttributeNumber045 | |
ExtnAttributeNumber046 | |
ExtnAttributeNumber047 | |
ExtnAttributeNumber048 | |
ExtnAttributeNumber049 | |
ExtnAttributeNumber050 | |
ExtnAttributeNumber051 | |
ExtnAttributeNumber052 | |
ExtnAttributeNumber053 | |
ExtnAttributeNumber054 | |
ExtnAttributeNumber055 | |
ExtnAttributeNumber056 | |
ExtnAttributeNumber057 | |
ExtnAttributeNumber058 | |
ExtnAttributeNumber059 | |
ExtnAttributeNumber060 | |
ExtnAttributeNumber061 | |
ExtnAttributeNumber062 | |
ExtnAttributeNumber063 | |
ExtnAttributeNumber064 | |
ExtnAttributeNumber065 | |
ExtnAttributeNumber066 | |
ExtnAttributeNumber067 | |
ExtnAttributeNumber068 | |
ExtnAttributeNumber069 | |
ExtnAttributeNumber070 | |
ExtnAttributeNumber071 | |
ExtnAttributeNumber072 | |
ExtnAttributeNumber073 | |
ExtnAttributeNumber074 | |
ExtnAttributeNumber075 | |
ExtnAttributeNumber076 | |
ExtnAttributeNumber077 | |
ExtnAttributeNumber078 | |
ExtnAttributeNumber079 | |
ExtnAttributeNumber080 | |
ExtnAttributeNumber081 | |
ExtnAttributeNumber082 | |
ExtnAttributeNumber083 | |
ExtnAttributeNumber084 | |
ExtnAttributeNumber085 | |
ExtnAttributeNumber086 | |
ExtnAttributeNumber087 | |
ExtnAttributeNumber088 | |
ExtnAttributeNumber089 | |
ExtnAttributeNumber090 | |
ExtnAttributeNumber091 | |
ExtnAttributeNumber092 | |
ExtnAttributeNumber093 | |
ExtnAttributeNumber094 | |
ExtnAttributeNumber095 | |
ExtnAttributeNumber096 | |
ExtnAttributeNumber097 | |
ExtnAttributeNumber098 | |
ExtnAttributeNumber099 | |
ExtnAttributeNumber100 | |
ExtnAttributeNumber101 | |
ExtnAttributeNumber102 | |
ExtnAttributeNumber103 | |
ExtnAttributeNumber104 | |
ExtnAttributeNumber105 | |
ExtnAttributeNumber106 | |
ExtnAttributeNumber107 | |
ExtnAttributeNumber108 | |
ExtnAttributeNumber109 | |
ExtnAttributeNumber110 | |
ExtnAttributeNumber111 | |
ExtnAttributeNumber112 | |
ExtnAttributeNumber113 | |
ExtnAttributeNumber114 | |
ExtnAttributeNumber115 | |
ExtnAttributeNumber116 | |
ExtnAttributeNumber117 | |
ExtnAttributeNumber118 | |
ExtnAttributeNumber119 | |
ExtnAttributeNumber120 | |
ExtnAttributeNumber121 | |
ExtnAttributeNumber122 | |
ExtnAttributeNumber123 | |
ExtnAttributeNumber124 | |
ExtnAttributeNumber125 | |
ExtnAttributeNumber126 | |
ExtnAttributeNumber127 | |
ExtnAttributeNumber128 | |
ExtnAttributeNumber129 | |
ExtnAttributeNumber130 | |
ExtnAttributeNumber131 | |
ExtnAttributeNumber132 | |
ExtnAttributeNumber133 | |
ExtnAttributeNumber134 | |
ExtnAttributeNumber135 | |
ExtnAttributeNumber136 | |
ExtnAttributeNumber137 | |
ExtnAttributeNumber138 | |
ExtnAttributeNumber139 | |
ExtnAttributeNumber140 | |
ExtnAttributeNumber141 | |
ExtnAttributeNumber142 | |
ExtnAttributeNumber143 | |
ExtnAttributeNumber144 | |
ExtnAttributeNumber145 | |
ExtnAttributeNumber146 | |
ExtnAttributeNumber147 | |
ExtnAttributeNumber148 | |
ExtnAttributeNumber149 | |
ExtnAttributeNumber150 | |
ExtnAttributeNumber151 | |
ExtnAttributeNumber152 | |
ExtnAttributeNumber153 | |
ExtnAttributeNumber154 | |
ExtnAttributeNumber155 | |
ExtnAttributeNumber156 | |
ExtnAttributeNumber157 | |
ExtnAttributeNumber158 | |
ExtnAttributeNumber159 | |
ExtnAttributeNumber160 | |
ExtnAttributeNumber161 | |
ExtnAttributeNumber162 | |
ExtnAttributeNumber163 | |
ExtnAttributeNumber164 | |
ExtnAttributeNumber165 | |
ExtnAttributeNumber166 | |
ExtnAttributeNumber167 | |
ExtnAttributeNumber168 | |
ExtnAttributeNumber169 | |
ExtnAttributeNumber170 | |
ExtnAttributeNumber171 | |
ExtnAttributeNumber172 | |
ExtnAttributeNumber173 | |
ExtnAttributeNumber174 | |
ExtnAttributeNumber175 | |
ExtnAttributeNumber176 | |
ExtnAttributeNumber177 | |
ExtnAttributeNumber178 | |
ExtnAttributeNumber179 | |
ExtnAttributeNumber180 | |
ExtnAttributeNumber181 | |
ExtnAttributeNumber182 | |
ExtnAttributeNumber183 | |
ExtnAttributeNumber184 | |
ExtnAttributeNumber185 | |
ExtnAttributeNumber186 | |
ExtnAttributeNumber187 | |
ExtnAttributeNumber188 | |
ExtnAttributeNumber189 | |
ExtnAttributeNumber190 | |
ExtnAttributeNumber191 | |
ExtnAttributeNumber192 | |
ExtnAttributeNumber193 | |
ExtnAttributeNumber194 | |
ExtnAttributeNumber195 | |
ExtnAttributeNumber196 | |
ExtnAttributeNumber197 | |
ExtnAttributeNumber198 | |
ExtnAttributeNumber199 | |
ExtnAttributeNumber200 | |
ExtnAttributeTimestamp001 | A column reserved for custom extension attributes of type date for the opportunity. |
ExtnAttributeTimestamp002 | |
ExtnAttributeTimestamp003 | |
ExtnAttributeTimestamp004 | |
ExtnAttributeTimestamp005 | |
ExtnAttributeTimestamp006 | |
ExtnAttributeTimestamp007 | |
ExtnAttributeTimestamp008 | |
ExtnAttributeTimestamp009 | |
ExtnAttributeTimestamp010 | |
ExtnAttributeTimestamp011 | |
ExtnAttributeTimestamp012 | |
ExtnAttributeTimestamp013 | |
ExtnAttributeTimestamp014 | |
ExtnAttributeTimestamp015 | |
ExtnAttributeTimestamp016 | |
ExtnAttributeTimestamp017 | |
ExtnAttributeTimestamp018 | |
ExtnAttributeTimestamp019 | |
ExtnAttributeTimestamp020 | |
ExtnAttributeTimestamp021 | |
ExtnAttributeTimestamp022 | |
ExtnAttributeTimestamp023 | |
ExtnAttributeTimestamp024 | |
ExtnAttributeTimestamp025 | |
ExtnAttributeTimestamp026 | |
ExtnAttributeTimestamp027 | |
ExtnAttributeTimestamp028 | |
ExtnAttributeTimestamp029 | |
ExtnAttributeTimestamp030 | |
ExtnAttributeTimestamp031 | |
ExtnAttributeTimestamp032 | |
ExtnAttributeTimestamp033 | |
ExtnAttributeTimestamp034 | |
ExtnAttributeTimestamp035 | |
ExtnAttributeTimestamp036 | |
ExtnAttributeTimestamp037 | |
ExtnAttributeTimestamp038 | |
ExtnAttributeTimestamp039 | |
ExtnAttributeTimestamp040 | |
ExtnAttributeTimestamp041 | |
ExtnAttributeTimestamp042 | |
ExtnAttributeTimestamp043 | |
ExtnAttributeTimestamp044 | |
ExtnAttributeTimestamp045 | |
ExtnAttributeTimestamp046 | |
ExtnAttributeTimestamp047 | |
ExtnAttributeTimestamp048 | |
ExtnAttributeTimestamp049 | |
ExtnAttributeTimestamp050 | |
GroupSpaceId | This column stores the GUID of the group space associated with this opportunity. |
IBAssetId | The unique identifier of the installed base asset of the opportunity. |
LastAssignedDate | The date on which the last assignment was performed on this opportunity. |
LastUpdateDate | The date and time when the opportunity row was last updated. |
LastUpdateLogin | The session login associated to the user who last updated the opportunity row. |
LastUpdatedBy | The user who last updated the opportunity row. |
LineOfBusinessCode | The line of business that owns this opportunity. A list of accepted values is defined in the lookup type MOT_LINE_OF_BUSINESS. |
LockAssignmentFlag | The option to exclude this row from assignment evaluation. The value Y excludes this row from assignment evaluation. If previously assigned, this locks the assignment. The value N either assigns or re-assigns this row. |
Name | The name of the opportunity. |
OptyCreatedBy | The replicated user who created the opportunity row. |
OptyCreationDate | The replicated date and time when the opportunity row was created. |
OptyId | The unique identifier of the opportunity. This is a primary key of the Opportunities view object. |
OptyLastUpdateDate | The replicated date and time when the opportunity row was last updated. |
OptyLastUpdatedBy | The replicated user who last updated the opportunity row. |
OptyNumber | The alternate unique identifier of the opportunity record. This is an alternate primary key of the Opportunities entity object. |
OptyPartySiteId | The identifier of the opportunity party site in the opportunity. This is a foreign key of the Party Site view object. |
OwnerResourceId | The identifier of the owner resource in the opportunity. This is a foreign key of the Parties view object. |
ParOptyId | The identifier of the parent opportunity in the opportunity. This is a foreign key of the Opportunity view object. |
PrCmptPartyId | The identifier of the primary competitor party in the opportunity. This is a foreign key of the Parties view object. |
PrConPartyId | The identifier of the primary contact party in the opportunity. This is a foreign key of the Parties view object. |
PrConRelationshipId | The RelationshipId of the primary contact associated to another party. |
PrSrcNumber | The alternate key identifier of the primary marketing source or campaign that generated this opportunity. |
PredWinProb | The AI predicted win probability percent. |
PrimaryPartnerId | The unique identifier of the primary partner associated with the opportunity. |
QuotedFlag | Indicates whether a quote has been created for this opportunity. |
ReasonWonLostCd | The code indicating the reason for winning or losing an opportunity. This field refers to the lookup type MOO_SETID_WIN_LOSS_REASON. |
ReasonWonLostCdSetId | The SetId of the win loss reason code for this opportunity. |
Registered | The option to indicate if the opportunity was registered. The valid values are Expired, Yes, and No. A list of accepted values is defined in the lookup type ORA_MOO_DEAL_REGISTERED_FLAG. |
RegistrationStatus | The registration status of the opportunity or deal created by a partner. A list of accepted values is defined in the lookup type OPTY_PARTNER_REGISTRATION_TYPE. |
RegistrationType | The registration type used by the partner to create the opportunity or deal. A list of accepted values is defined in the lookup type PARTNER_REGISTRATION_INITIATOR. |
RiskLvlCode | Indicates the risk level for this opportunity. This field refers to the lookup type MOO_SETID_RISK_LEVEL. |
RiskLvlCodeSetId | The SetId of the risk level code for this opportunity. |
SalesAccountId | The identifier of the sales account in the Opportunities object. This is a foreign key of the Sales Account view object. |
SalesMethodId | The identifier of the sales method in the Opportunities object. This is a foreign key of the Sales Method view object. |
StatusCategory | The status category of the opportunity status. The values can be OPEN, LOST, NO_SALE, or WON. |
StatusCd | The code indicating that the status of the opportunity. A list of accepted values are defined in the lookup MOO_OPTY_STATUS |
StatusCdSetId | The SetId of the status code for this opportunity. |
StrategicValueCode | Indicates the level of the strategic value to work with the opportunity target. A list of accepted values is defined in the lookup type MOO_SETID_STRATEGIC_VALUE. |
StrategicValueCodeSetId | The SetId of the strategic value code for this opportunity. |
SumRevnId | The identifier of the summary revenue in the Opportunities object. This is a foreign key of the Revenue view object. |
UserLastUpdateDate | The date and time when the opportunity was last updated. |