Revenues
The revenues view object contains 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.RevenueExtractPVO
Primary Keys : RevnId
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 when the revenue line was closed. |
| AdditionalAmount1 | An additional currency field. |
| AdditionalNum1 | An additional numeric field. |
| AdditionalText1 | An additional text 1 field. |
| AdditionalText2 | An additional text 2 field. |
| BaseRevnAmt | The amount of base revenue. |
| BuOrgId | The unique identifier of the Business Unit that owns the opportunity. |
| CloseReasonCode | The code indicating the reason for winning or losing the revenue. 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 row. |
| Comments | The user-provided comments for the revenue line. |
| CommitFlag | Indicates if this revenue line should be used for forecasting. A list of accepted values is defined in the lookup type YES_NO. |
| ConversionRate | The currency conversion rate 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 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. |
| CrRcptPartOrgPartyId | The unique identifier of the credit recipient partner organization party. |
| CreatedBy | The user who created the revenue row. |
| CreationDate | The date and time when the revenue row was created. |
| CrmConversionDate | The date 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 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 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. |
| CustAccountId | The unique identifier of the customer account that owns the opportunity. This is a foreign key to the Customer Accounts view object. |
| CustPartyId | The unique identifier of the sales account that owns the opportunity. This is a foreign key to the Parties view object. |
| Discount | The discount percent. |
| DownsideAmt | The minimum amount of revenue for the opportunity. |
| EffectiveDate | The estimated date when the revenue closes. The default value is the opportunity's close date. |
| ExpectAmt | The expected amount of revenue for the opportunity based on win probability. |
| ExpectDlvryDate | The date 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 revenue. |
| 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 that 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. |
| InventoryOrgId | The unique identifier of the organization in the inventory. This is a foreign key to the Item Organization Associations view object. |
| LastUpdateDate | The date and time when the revenue row was last updated. |
| LastUpdateLogin | The login of the user who last updated the revenue row. |
| LastUpdatedBy | The user who last updated the revenue row. |
| MarginAmt | The margin amount for the opportunity. |
| NqSplitAllocTypeCode | The code indicating the non-quota allocation split type. 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. |
| OptyLeadId | The unique Identifier of the lead associated with opportunity. |
| OwnerDealExpirationDate | The date when the owner deal expires. |
| OwnerDealProtectedDate | The date when the owner deal starts. |
| OwnerLockAsgnFlag | Indicates if the revenue owner assignment should be locked. If the value is Y, then the owner assignment for the revenue should be locked. The default value is N. |
| OwnerResourceId | The unique identifier of the revenue owner. This is a foreign key to the Parties view object. |
| ParentRevnId | The unique identifier of the parent revenue for the opportunity. |
| PartEngagementTypeCode | The code indicating the type of partner engagement. |
| PrCmptPartyId | The identifier of the primary competitor party. This is a foreign key to the Parties view object. |
| PrCmptProductId | The identifier of the primary competitor product. |
| PrPartOrgPartyId | The unique identifier of the primary revenue partner organization party. |
| PrTerritoryUpdatedById | The identifier of the resource who last updated the primary forecast territory associated with the revenue row. |
| PrTerritoryVersionId | The unique identifier of the primary territory. |
| PrimaryFlag | Indicates if the current row is the primary revenue row. |
| ProdGroupId | The unique identifier of the product group. This is a foreign key to the Product Groups view object. |
| Qty | The quantity of the product for this opportunity. |
| RecmdEffectiveDate | The recommended effective date of the revenue row. |
| RecmdLastUpdateDate | The recommended date and time when the revenue row was last updated. |
| RecmdRevnAmt | The recommended revenue amount of the revenue row. |
| RecmdWinProb | The recommended win probability of the revenue row. |
| RecurAdditionalAmount1 | An additional currency field for the recurrence. |
| RecurAdditionalNum1 | An additional numeric field for the recurrence. |
| RecurDownsideAmt | The minimum revenue amount from the recurrence. |
| RecurEndDate | The date when the revenue recurrence ends. |
| RecurExpectAmount | The expected amount of revenue for the revenue recurrence. |
| RecurFrequencyCode | The code that indicates the frequency of recurrence for the revenue. A list of valid values is defined in the lookup type MOO_RECURRING_FREQUENCY. |
| RecurNumPeriods | The number of times the revenue should recur. |
| RecurParentRevnId | The unique identifier for the parent revenue of the recurring revenue lines. This is a foreign key to the Revenues view object. |
| RecurQty | The quantity of the revenue recurrence. |
| RecurRevnAmt | The amount of revenue from the revenue recurrence. |
| RecurStartDate | The date when the recurrence starts. |
| RecurTypeCode | The code 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. |
| RecurUpsideAmt | The maximum revenue amount from the recurrence. |
| RevenueCreationDate | |
| RevnAmt | The amount of revenue that is earned from this opportunity. |
| RevnAmtCurcyCode | The currency code 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 indicating the revenue category. A list of valid values is defined in the lookup type MOO_REVN_CATEGORY. |
| RevnId | The unique identifier of the revenue line for the opportunity. This is a primary key of the Revenues view object. |
| RevnLastUpdateDate | The date and time when the revenue record was last updated. |
| RevnLineTypeCode | The code 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. The default value is the revenue identifier and is required. |
| RevnSeqNum | The revenue sequence number. |
| SalesAccountId | The unique identifier of the opportunity sales account. This is a foreign key to the Sales Accounts view object. |
| SalesChannelCode | The code indicating the sales channel for the revenue. A list of valid values is defined in the lookup type ZPM_SALES_CHANNEL. |
| SalesCreditTypeCode | The code 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. |
| SplitParentRevnId | The unique identifier of the split parent revenue. This is a foreign key to the Revenues view object. |
| SplitPercent | The percentage of split revenue. |
| SplitTypeCode | The code 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. |
| StatusCode | The unique code indicating the status of the revenue. 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 row. |
| TopParentRevnNumber | The revenue number of the revenue line to which the child revenue lines roll up to. |
| TypeCode | The code 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 row. |
| UnitPrice | The estimated unit price for the product. |
| UomCode | The unit of measure code for the product. |
| UpsideAmt | The maximum amount of revenue for the opportunity. |
| UserLastUpdateDate | The date and time of last update date of revenue 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. |