Revenue Snapshots
The revenue time based snapshot view object contains the snapshots for the revenue lines which have information about products, amounts, price, quantity, discount percent, reason for winning or losing the revenue, percentage of split revenue, split type, owner deal start and expiry dates, sales channel code and so on.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.MooBiccExtractAM.RevenueTimeBasedSnapshotExtractPVO
Primary Keys : RevnSnapshotId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
ActualCloseDate | The date on the revenue snapshot row when the revenue line was closed. |
AdditionalAmount1 | An additional currency field on the revenue snapshot row. |
AdditionalNum1 | An additional numeric field on the revenue snapshot row. |
AdditionalText1 | An additional text 1 field on the revenue snapshot row. |
AdditionalText2 | An additional text 2 field on the revenue snapshot row. |
AttributeCategory | |
BaseRevnAmt | The amount of the base revenue on the revenue snapshot row. |
BuOrgId | The unique identifier of the Business Unit that owns the opportunity on the revenue snapshot row. |
CloseReasonCode | The code indicating the reason for winning or losing the revenue on the revenue snapshot row. A list of valid values is defined in the lookup type MOO_SETID_WIN_LOSS_REASON. |
CloseReasonCodeSetId | The Set Id of the Close Reason Code MOO_REVN.CLOSE_REASON_CODE for the revenue snapshot row. |
Comments | The user-provided comments on the revenue snapshot row. |
CommitFlag | Indicates if this revenue snapshot line should be used for forecasting. A list of accepted values is defined in the lookup type YES_NO. |
ConversionRate | The currency conversion rate stamped on the revenue snapshot row and used for converting the revenue amount to the opportunity summary currency. This rate is used if the currency of the revenue line is different from the opportunity currency. |
ConversionRateType | The currency conversion rate type stamped on the revenue snapshot row and used for converting the revenue amount to the opportunity summary currency. This rate type is used if the currency of the revenue line is different from the opportunity currency. The rate type can be spot, user-defined, or corporate. |
CostAmt | The cost amount for the opportunity on the revenue snapshot row. |
CrRcptPartOrgPartyId | The unique identifier of the credit recipient partner organization party on the revenue snapshot row. |
CreatedBy | The user who created the revenue snapshot row. |
CreationDate | The date and time when the revenue snapshot row was created. |
CrmConversionDate | The date stamped on the revenue snapshot row and used to obtain the currency conversion rate for the conversion of the revenue amount to the common CRM currency, if the currency of the revenue line is different from the common CRM currency. |
CrmConversionRate | The rate stamped on the revenue snapshot row and used for the conversion of the revenue amount to the common CRM currency, if the currency of the revenue line is different from the common CRM currency. |
CrmConversionRateType | The rate type stamped on the revenue snapshot row and used for the conversion of the revenue amount to the common CRM currency if the currency of the revenue line is different from the common CRM currency. The rate type can be spot, user-defined, or corporate. |
CrmCurcyCode | The common CRM currency code on the revenue snapshot row. |
CustAccountId | The unique identifier of the customer account that owns the opportunity on the revenue snapshot row. This is a foreign key to the Customer Accounts view object. |
CustPartyId | The unique identifier of the sales account that owns the opportunity on the revenue snapshot row. This is a foreign key to the Parties view object. |
Discount | The discount percent on the revenue snapshot row. |
DownsideAmt | The minimum amount of revenue for the opportunity on the revenue snapshot row. |
EffectiveDate | The estimated date when the revenue closes on the revenue snapshot row. The default value is the opportunity's close date. |
ExpectAmt | The expected amount of revenue for the opportunity on the revenue snapshot row. |
ExpectDlvryDate | The date on the revenue snapshot row when the product in the opportunity is expected to be delivered. This is used only for opportunities that include products. |
ExtnAttributeChar001 | A column reserved for custom extension attributes for the revenue snapshot. |
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 | |
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 | |
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 | |
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 | |
ForecastOverrideCode | The code on the revenue snapshot row which indicates if the revenue forecast should be overridden. The valid values are ALWAYS, NEVER, and CRITERIA. A list of valid values is defined in the lookup type ZSF_FCST_INCLUDE_IN_FCST. |
InventoryItemId | The unique identifier of the product in the inventory on the revenue snapshot row. |
InventoryOrgId | The unique identifier of the organization in the inventory on the revenue snapshot row. This is a foreign key to the Item Organization Associations view object. |
LastUpdateDate | The date and time when the revenue snapshot row was last updated. |
LastUpdateLogin | The session login associated to the user who last updated the revenue snapshot row. |
LastUpdatedBy | The user who last updated the revenue snapshot row. |
MarginAmt | The margin amount for the opportunity on the revenue snapshot row. |
NqSplitAllocTypeCode | The code indicating the non-quota allocation split type on the revenue snapshot row. The valid values are Ad hoc amount and Proportional to Revenue. A list of valid values is defined in the lookup type MOO_REVN_SPLIT_ALLOC_TYPE. |
OptyId | The unique identifier of the opportunity on the revenue snapshot row. |
OptyLeadId | The unique Identifier of the lead associated with opportunity on the revenue snapshot row. |
OwnerDealExpirationDate | The date on the revenue snapshot row when the owner deal expires. |
OwnerDealProtectedDate | The date on the revenue snapshot row when the owner deal starts. |
OwnerInTerrFlag | Indicates that the owner of the revenue line from the revenue snapshot row is a member of any territories to which the revenue line belongs. |
OwnerLockAsgnFlag | Indicates if the revenue owner assignment on the revenue snapshot row should be locked. If the value is Y, then the owner assignment for the revenue should be locked. The default value is N. |
OwnerOrgTreeCode | |
OwnerOrgTreeStructCode | |
OwnerResourceId | The unique identifier of the revenue owner on the revenue snapshot row. This is a foreign key to the Parties view object. |
OwnerResourceOrgId | |
ParentRevnId | The unique identifier of the parent revenue for the opportunity on the revenue snapshot row. |
PartEngagementTypeCode | The code on the revenue snapshot row indicating the type of partner engagement. |
PrCmptPartyId | The identifier of the primary competitor party on the revenue snapshot row. This is a foreign key to the Parties view object. |
PrCmptProductId | The identifier of the primary competitor product on the revenue snapshot row. |
PrPartOrgPartyId | The unique identifier of the primary revenue partner organization party on the revenue snapshot row. |
PrTerritoryUpdatedById | The identifier of the resource who last updated the primary forecast territory associated with the revenue snapshot row. |
PrTerritoryVersionId | The unique identifier of the primary territory on the revenue snapshot row. |
PrimaryFlag | Indicates if the current row is the primary revenue snapshot row. |
ProdGroupId | The unique identifier of the product group on the revenue snapshot row. This is a foreign key to the Product Groups view object. |
Qty | The quantity of the product for this opportunity on the revenue snapshot row. |
RecmdEffectiveDate | The recommended effective date on the revenue snapshot row. |
RecmdLastUpdateDate | The recommended date and time when the revenue snapshot row was last updated. |
RecmdRevnAmt | The recommended revenue amount on the revenue snapshot row. |
RecmdWinProb | The recommended win probability on the revenue snapshot row. |
RecurAdditionalAmount1 | An additional currency field for the recurrence on the revenue snapshot row. |
RecurAdditionalNum1 | An additional numeric field for the recurrence on the revenue snapshot row. |
RecurDownsideAmt | The minimum revenue amount from the recurrence on the revenue snapshot row. |
RecurEndDate | The date on the revenue snapshot row when the revenue recurrence ends. |
RecurExpectAmount | The expected amount of revenue for the revenue recurrence on the revenue snapshot row. |
RecurFrequencyCode | The code on the revenue snapshot row that indicates the frequency of recurrence. A list of valid values is defined in the lookup type MOO_RECURRING_FREQUENCY. |
RecurNumPeriods | The number of times the revenue on the revenue snapshot row should recur. |
RecurParentRevnId | The unique identifier for the parent revenue of the recurring revenue lines on the revenue snapshot row. This is a foreign key to the Revenues view object. |
RecurQty | The quantity of the revenue recurrence on the revenue snapshot row. |
RecurRevnAmt | The amount of revenue from the revenue recurrence on the revenue snapshot row. |
RecurStartDate | The date on the revenue snapshot row when the recurrence starts. |
RecurTypeCode | The code on the revenue snapshot row indicating if the line is a standard revenue line or a recurring revenue line. A list of valid values is defined in the lookup type MOO_REVN_RECUR_TYPE. |
RecurUnitPrice | The unit price for each revenue recurrence on the revenue snapshot row. |
RecurUpsideAmt | The maximum revenue amount from the recurrence on the revenue snapshot row. |
RevnAmt | The amount of revenue that is earned from this opportunity on the revenue snapshot row. |
RevnAmtCurcyCode | The currency code stamped on the revenue snapshot row and used to calculate the revenue for this opportunity. A list of valid values is defined in the lookup type ZCA_COMMON_CORPORATE_CURRENCY. |
RevnCategoryCode | The code on the revenue snapshot row indicating the revenue category. A list of valid values is defined in the lookup type MOO_REVN_CATEGORY. |
RevnCreationDate | The date and time on the revenue snapshot row when the revenue line was created. |
RevnId | The unique identifier of the revenue line for the opportunity on the revenue snapshot row. This is a primary key of the Revenues view object. |
RevnLastUpdateDate | The date and time on the revenue snapshot row when the revenue record was last updated. |
RevnLineTypeCode | The code on the revenue snapshot row indicating the type of revenue line, such as Opportunity Summary Revenue, Standard Revenue, and so on. A list of valid values is defined in the lookup type MOO_REVN_LINE_TYPE. |
RevnNumber | The user-editable unique identifier for the revenue on the revenue snapshot row. The default value is the revenue identifier and is required. |
RevnSeqNum | The revenue sequence number on the revenue snapshot row. |
RevnSnapshotId | The unique identifier of the revenue snapshot row. This is a primary key of the Revenue Snapshot view object. |
SalesAccountId | The unique identifier of the opportunity sales account on the revenue snapshot row. This is a foreign key to the Sales Accounts view object. |
SalesChannelCode | The code on the revenue snapshot row indicating the sales channel for the revenue. A list of valid values is defined in the lookup type ZPM_SALES_CHANNEL. |
SalesCreditTypeCode | The code on the revenue snapshot row indicating the type of the sales credit, such as quota or non-quota. A list of valid values is defined in the lookup type MOO_SALES_CREDIT_TYPE. |
SnapshotDate | The date when the snapshot revenue row was taken. |
SnapshotId | This column is a foreign key to the MOO_SNAPSHOTS table that contains details about the snapshots. |
SplitParentRevnId | The unique identifier of the split parent revenue on the revenue snapshot row. This is a foreign key to the Revenues view object. |
SplitPercent | The percentage of split revenue on the revenue snapshot row. |
SplitTypeCode | The code on the revenue snapshot row that indicates if the split is revenue or non-revenue. A list of valid values is defined in the lookup type MOO_REVN_SPLIT_TYPE. |
StatusCategory | The revenue status category on the revenue snapshot row. |
StatusCode | The unique code indicating the status of the revenue snapshot row. A list of valid values is defined in the lookup type OPTY_STATUS. |
StatusCodeSetId | The Set Id of the Status Code MOO_REVN.STATUS_CODE for the revenue snapshot row. |
TopParentRevnNumber | The revenue number of the revenue line on the revenue snapshot row to which the child revenue lines roll up to. |
TypeCode | The code on the revenue snapshot row indicating the type of revenue earned from this opportunity. A list of valid values is defined in the lookup type MOO_SETID_REVENUE_TYPE. |
TypeCodeSetId | The Set Id of the Revenue Type MOO_REVN.TYPE_CODE for the revenue snapshot row. |
UnitPrice | The estimated unit price for the product on the revenue snapshot row. |
UomCode | The unit of measure code for the product on the revenue snapshot row. |
UpsideAmt | The maximum amount of revenue for the opportunity on the revenue snapshot row. |
UserLastUpdateDate | The date and time of last update date of revenue snapshot row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database. |
WinProb | The estimated probability of winning the opportunity on the revenue snapshot row. |