Opportunity Time Based Snapshots
The opportunity time based snapshot view object contains snapshot of opportunities details 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.OpportunityTimeBasedSnapshotExtractPVO
Primary Keys : OptySnapshotId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
AssetId | The Asset ID for the opportunity from the table ZCA_ASSETS. |
AssignmentImpactedDate | This column is used for incremental territory based assignment. |
AttributeCategory | The context name for the Opportunities descriptive flexfield. |
BatchTag | This column will be used to tag opportunities for inclusion in a batch job such as batch assignment of opportunities. |
BdgtAmt | The amount budgeted for this opportunity. |
BdgtAmtCurcyCd | The budget amount currency code. |
BdgtAvailableDt | The date when the budget will be available in the current quarter. |
BdgtedFlg | Indicates if the opportunity target has been budgeted to buy the solution proposed by this opportunity. |
BuOrgId | The business unit or internal organization to which this opportunity belongs. |
ChampionFlag | Indicates if winning this opportunity is a strong internal champion. |
ChannelTypeCd | The sales channel from which the opportunity originates. This field refers to the lookup type OPTY_CHANNEL_TYPE. |
Comments | The comments about this opportunity. |
CorpCurrencyCode | The corporate currency code for extensibility. |
CreatedBy | The user who created the opportunity or imported it from an external system. |
CreationDate | The date when the opportunity was created. |
CurcyConvRateType | The currency conversion rate type for extensibility. |
CurrStgId | The identifier of the current stage in the opportunities. This is a foreign key of the Sales Stage view object. |
CurrencyCode | The currency code for extensibility. |
CustAccountId | The identifier of the customer account in the opportunities. This is a foreign key of the Customer Account view object. |
CustPartyId | The identifier of the customer party in the opportunities. This is a foreign key of the Parties view object. |
DealHorizonCode | Indicates the time required to close the deal. This field refers to the lookup type MOO_SETID_DEAL_HORIZON. |
DealHorizonCodeSetId | The Set ID of the Deal Horizon Code MOO_OPTY_SNAPSHOTS.DEAL_HORIZON_CODE for this opportunity snapshot |
DecisionLvlCode | Indicates the decision level for the opportunity target. This field refers to the lookup type MOO_SETID_DECISION_LEVEL. |
DecisionLvlCodeSetId | The Set ID of the Decision Level Code MOO_OPTY_SNAPSHOTS.DECISION_LVL_CODE for this opportunity snapshot. |
DescText | A brief description of the opportunity. |
EffectiveDate | The estimated close date for this opportunity. |
EnableSocialFlag | The value Y indicates if you have requested OSN to create social networking data for this opportunity. |
ExtnAttributeChar001 | A column reserved for opportunities custom extension attributes of type character. |
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 opportunities custom extension attributes of type CLOB. |
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 opportunities custom extension attributes of type number. |
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 opportunities custom extension attributes of type time. |
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 is used to store the GUID of the group space associated with this opportunity. |
LastAssignedDate | The date on which this last assignment was performed on this opportunity. |
LastUpdateDate | The date when the opportunities row was last updated. |
LastUpdateLogin | The session login associated to the user who last updated the opportunities row. |
LastUpdatedBy | The user who last updated the opportunities row. |
LineOfBusinessCode | The line of business that is responsible for the opportunity. |
LockAssignmentFlag | The value Y notifies Assignment Manager that this row should be excluded from assignment evaluation. If previously assigned, this value locks the assignment. Set this value to N to notify the Assignment Manager that this row should either be assigned or re-assigned. |
Name | The name of the opportunity. |
OptyCreatedBy | The user who created the opportunities row. |
OptyCreationDate | The date when the opportunity was created in a source system. |
OptyId | The system generated identifier for this opportunity. |
OptyLastUpdateDate | The date when the opportunities row was last updated. |
OptyLastUpdatedBy | The user who last updated the opportunities row. |
OptyNumber | The unique public identifier of the opportunity. This is a public surrogate key. |
OptyPartySiteId | The identifier of the opportunity party site in the opportunities. This is a foreign key of the Party Site view object. |
OptySnapshotId | The unique identifier of the opportunities . This is a primary key of the Opportunities view object. |
OwnerResourceId | The identifier of the owner resource in the opportunities. This is a foreign key of the Parties view object. |
ParOptyId | The identifier of the parent opportunity in the opportunities. This is a foreign key of the Opportunity view object. |
PrCmptPartyId | The identifier of the primary competitor party in the opportunities. This is a foreign key of the Parties view object. |
PrConPartyId | The identifier of the primary contact party in the opportunities. This is a foreign key of the Parties view object. |
PrConRelationshipId | The RelationshipId of the primary contact associated to another party. |
PrPartPartyId | The party ID of the primary partner. |
PrSrcNumber | The primary source or campaign that generated 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 Set ID of the Win Loss Reason Code MOO_OPTY_SNAPSHOTS.REASON_WON_LOST_CD for this opportunity snapshot. |
Registered | Indicates the deal registration status such as Expired, Yes, or No. |
RegistrationStatus | Indicates the registration status of the opportunity. |
RegistrationType | Indicates the registration type of the opportunity. |
RiskLvlCode | Indicates the risk level for this opportunity. This field refers to the lookup type MOO_SETID_RISK_LEVEL. |
RiskLvlCodeSetId | The Set ID of the Risk Level Code MOO_OPTY_SNAPSHOTS.RISK_LVL _CODE for this opportunity snapshot. |
RuleBasedLastAsgnDate | The rule based last assigned date. |
SalesAccountId | The Sales Account Id from the ZCA_SALES_ACCOUNTS table. |
SalesMethodId | The identifier of the sales method in the opportunities. This is a foreign key of the Sales Method view object. |
SnapshotDate | This date on which the snapshot of the opportunity is taken. |
SnapshotId | This column is the foreign key to the MOO_SNAPSHOTS table. It refers to the snapshot ID to which this opportunity snapshot row belongs. |
StatusCategory | The status category of the opportunity. |
StatusCd | The status code such as Pending, Accepted, or Re-routed which can be different from the status of the current sales stage. |
StatusCdSetId | The Set ID of the Status Code MOO_OPTY_SNAPSHOTS.STATUS_CD for this opportunity snapshot. |
StrategicValueCode | Indicates the level of the strategic value to work with the opportunity target. This field refers to the lookup type MOO_SETID_STRATEGIC_VALUE. The options are Low, Medium, and High. |
StrategicValueCodeSetId | The SetId of the Strategic Value Code for this opportunity snapshot. |
SumRevnId | The identifier of the summary revenue in the opportunities. This is a foreign key of the Revenue view object. |
UserLastUpdateDate | The date and time when the opportunities row was last updated. This value is different from LAST_UPDATE_DATE, if the opportunities row was updated in a different database. |