Sales Leads
The lead view object contains lead-related information such as contact middle name, sales channel, lead, province, deal size, and so on.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.MklBiccExtractAM.LeadExtractPVO
Primary Keys : LeadId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AILeadScore | |
| AcceptedDateTime | The date and time when the sales lead is accepted by a resource assigned to it. |
| AddrElementAttribute1 | The additional address element to support flexible address format. |
| AddrElementAttribute2 | |
| AddrElementAttribute3 | |
| AddrElementAttribute4 | |
| AddrElementAttribute5 | |
| Address1 | The first line of the address associated with the primary contact of the lead. |
| Address2 | The second line of the address associated with the primary contact of the lead. |
| Address3 | The third line of the address associated with the primary contact of the lead. |
| Address4 | The fourth line of the address associated with the primary contact of the lead. |
| AddressLinesPhonetic | The phonetic or kana representation of the Kanji address lines. |
| AddressStyle | A context value for the flexible address format descriptive flexfield . |
| ApprovalDateTime | The date and time when the sales lead is approved. This is only applicable to deal registrations. |
| ApproverId | The unique identifier of the approver. This is a foreign key to the Party Id of the resource who approved the lead registration. |
| AssetId | The unique identifier of the asset associated with the sales lead. |
| AssignmentStatusCode | The current assignment related status for the lead. For example, it indicates whether the lead is assigned or unassigned. A list of accepted values is defined in the lookup type MKL_LEAD_ASGNT_STATUS_CODE. |
| Aux1ClassCategory | The class category for auxiliary class code 1. |
| Aux2ClassCategory | The class category for auxiliary class code 2. |
| Aux3ClassCategory | The class category for auxiliary class code 3. |
| BuId | The unique identifier of the business unit which is associated with the business unit of the sales lead creator. |
| BudgetAmount | The budget amount associated with this sales lead. |
| BudgetCurrencyCode | The currency code associated with the budget amount associated with this sales lead. |
| BudgetStatus | The budget status associated with the budget amount of the sales lead. A list of accepted values is defined in the lookup type MKL_LEAD_BUDGET_STATUS_SETID. |
| BudgetStatusSetId | |
| Building | The specific building name or number at a given address. |
| CallLstId | The unique identifier of the call list in the lead. This is a foreign key of the Market Call List view object. |
| CampConId | The identifier of the campaign contact in the lead. This is a foreign key of the Campaign Member view object. |
| ChannelType | Indicates the channel through which this lead contacted the company. A list of accepted values is defined in the lookup type MKL_LEAD_CHANNEL_SETID. |
| ChannelTypeSetId | |
| City | The city where the primary contact of the lead is located. |
| ClaimedFlag | This option denotes whether the lead is claimed by a partner. A list of accepted values is defined in the lookup type MKL_LEAD_CLAIMED_FLAG. |
| ClassCodeAux1 | The auxiliary dimension for the account. |
| ClassCodeAux2 | |
| ClassCodeAux3 | |
| ContactFirstName | The first name of the primary contact for a lead. |
| ContactLastName | The last name of the primary contact for a lead. |
| ContactMiddleName | The middle name of the primary contact for a lead. |
| ContactName | The name associated with the primary lead contact. |
| ContactTimezoneCd | The preferred time zone of the contact pursued on the lead. A list of accepted values is defined in the lookup type ORA_HZ_TIMEZONE_CODES. |
| ConvCurrCode | The currency code used to convert the lead currency. This is typically the corporate currency. |
| ConvExchangeRate | The exchange rate used to convert the lead currency to the corporate currency. |
| ConvRateType | The rate type used to convert the lead currency to the corporate currency. |
| ConvReason | The conversion reason for the lead row. |
| ConvertedContactId | The contact created from the simplified lead. |
| ConvertedCustomerId | The customer created from the simplified lead. |
| ConvertedDateTime | The date and time when the sales lead is converted to an opportunity. |
| ConvertedOptyId | The unique identifier of the converted opportunity. |
| Country | The country where the primary contact of the lead is located. |
| County | The county where the primary contact of the lead is located. |
| CreatedBy | The user who created the lead row. |
| CreationDate | The date and time when the lead row was created. |
| CurrencyCode | The currency code of the lead row. |
| CurrencyConversionDate | The date of currency exchange rate for the lead against the corporate currency. |
| CustPartyType | The party type of the account associated with the lead. A list of accepted values is defined in the lookup type ZCA_RECORD_TYPE. |
| CustomerExisting | This denotes if the customer is an existing customer. |
| CustomerId | The unique identifier of the customer in the lead. This is a foreign key of the Party view object. |
| CustomerName | The name of the lead customer. |
| CustomerNeed | The need the lead product serves for the customer. |
| DealSize | The total amount attributed to a lead. |
| DealType | Indicates the registration type of the sales lead. This is a deal specific attribute. A list of specific values is defined in the lookup type MKL_DEAL_TYPE_SETID. |
| DealTypeSetId | |
| DecisionMakerIdentified | Indicates if the decision maker at the customer site has been identified. |
| DescText | The description associated with this sales lead. |
| DuplicateCheckFlag | The value would be set to y when duplicates have been checked for this field. |
| EmailAddress | The email address for the primary sales lead contact on the lead. |
| EstimatedCloseDate | The estimated close date of the deal. This is a deal specific attribute. |
| ExpirationDate | The expiry date of the deal. This is a deal specific attribute. |
| ExtnAttributeChar001 | A column reserved for custom extension attributes for lead of type string. |
| 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 for lead 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 custom extension attributes for lead 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 custom extension attributes for lead 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 | |
| FloorNumber | The specific floor number at a given address or in a building when the building number is provided. |
| FollowupStatusCode | The follow up status code of the lead. |
| FollowupTm | Indicates when the sales lead needs to be followed up. |
| GeographyId | The unique identifier of the lead customer geography. |
| IBAssetId | The unique identifier of the IB asset associated with the sales lead. |
| ImprtTskId | The unique identifier of the import task. |
| IndustryClassCategory | The class category for the industry class code. |
| IndustryClassCode | The auxiliary dimension for the account. |
| JobTitle | The job title of the primary contact for the sales lead. |
| LastAssgnmtDate | The date on which the lead was last reassigned. |
| LastOwnerAssignedTm | The date on which the last owner was assigned to the lead. |
| LastUpdateDate | The date and time when the lead row was last updated. |
| LastUpdateLogin | The session login associated to the user who last updated the lead row. |
| LastUpdatedBy | The user who last updated the lead row. |
| Latitude | The latitude information for the lead address. The latitude information for the location is used for spatial proximity and containment purposes. |
| LeadAcceptedFlag | Indicates if the lead has been accepted. A list of accepted values is defined in the lookup type MKL_LEAD_ACCEPTED_FLAG. |
| LeadCreatedBy | The replicated user who created the lead row. |
| LeadCreationDate | The replicated date and time when the lead row was created. |
| LeadDistributionMode | This denotes how the lead is going to be distributed to a partner. |
| LeadId | The unique identifier of the lead. This is a primary key of the Lead view object. |
| LeadLastUpdateDate | The replicated date and time when the lead row was last updated. |
| LeadLastUpdatedBy | The replicated user who last updated the lead row. |
| LeadName | The lead name used to identify the lead. |
| LeadNumber | The alternate unique identifier of the lead. This is an alternate primary key of the Lead entity object. |
| Longitude | The longitude information for the lead address. The longitude information for the location is used for spatial proximity and containment purposes. |
| MicrositeId | The foreign key to the web marketing microsite for tracking purposes. |
| NumTmsRejected | The number of times a lead has been rejected by different users. |
| ObjectUsage | This denotes whether the current row is representing a lead or a deal object. |
| OrganizationSize | The size of the organization. A list of accepted values is defined in the lookup type HZ_ORGANIZATION_SIZE. |
| OrganizationType | The name of the organization type in the lead. |
| OwnerId | The unique identifier of the owner in the lead. This is a foreign key of the Party view object. |
| PartnerId | The unique identifier for the primary partner associated with the lead. |
| PartnerProgramId | The unique identifier for the partner program in which the primary partner associated with this sales lead is enrolled. This is a deal specific attribute. |
| PartnerType | Indicates the type of the primary partner associated with this sales lead. This is a deal specific attribute. |
| PostalCode | The area code where the primary contact of the lead is located. |
| PostalPlus4Code | The four digit extension to the United States postal code. |
| PrimaryContactId | The unique identifier of the primary contact in the lead. This is a foreign key of the Party view object. |
| PrimaryContactNumber | The unique identifier of the primary contact associated with a lead. |
| PrimaryInvItemId | The unique identifier of the primary product associated with a lead. |
| PrimaryInvOrgId | The unique identifier of the organization to which the primary product associated with a lead belongs. |
| PrimaryPhoneAreaCode | The primary phone area code for the sales lead contact. |
| PrimaryPhoneCountryCode | The primary phone country code for the sales lead contact. |
| PrimaryPhoneNumber | The primary phone number for the sales lead contact. |
| PrimaryProdGroupId | The unique identifier of the primary product group associated with a lead. |
| Project | The customer project identified for this sales lead. |
| PropensityToBuy | The likelihood of buying a product specified in the lead. |
| Province | The province where the primary contact of the lead is located. |
| QualificationComments | The comments pertaining to a lead qualification. |
| QualificationScore | The qualification score of the lead . |
| QualifiedDate | The date and time when the sales lead is qualified. |
| QualifiedTm | The qualified time tracks the date when this lead got qualified. |
| QualityCode | The quality code of the lead. |
| Rank | The rank associated with this sales lead. A list of accepted values is defined in the lookup type MKL_LEAD_RANK_SETID. |
| RankSetId | |
| ReassignCommentText | A comment provided by a user while requesting the lead to be reassigned. |
| ReassignReasonCode | The predefined code used to indicate the reason for lead reassignment. A list of accepted values is defined in the lookup type MKL_LEAD_REASSIGN_REASON_SETID. |
| ReassignReasonCodeSetId | |
| RecommendationRationale | The rationale behind a recommendation when the user generates a recommendation. |
| RegistrationNumber | The registration number of the sales lead. This unique identifier is generated when the sales lead is approved. This is a deal specific attribute. |
| RegistrationStatus | The approval status of the sales lead. This is a deal specific attribute. A list of accepted values is defined in the lookup type MKL_DEAL_APPROVAL_STATUS. |
| RejectByTerritoryId | The territory of the partner resource who rejected the lead. |
| RejectByTerritoryVersionId | The territory version of the partner resource who rejected the lead. |
| RejectByUserId | The unique identifier of the sales representative who rejected this sales lead. |
| RejectCommentText | The comments provided by the sales representative who rejected this sales lead. |
| RejectReasonCode | The reason for rejection of this lead. A list of accepted values is defined in the lookup type MKL_REJECT_REASON_SETID . |
| RejectReasonCodeSetId | |
| RejectedTm | The date and time when the lead is rejected. |
| RelationshipId | The unique identifier of the relationship for the primary contact with it's parent organization. |
| RetireCommentText | The comments recorded when the sales lead is moved to Retired status. |
| RetireReasonCode | The predefined code used to indicate the reason for retiring a lead. A list of accepted values is defined in the lookup type MKL_RETIRE_REASON_CD. |
| RetireReasonCodeSetId | |
| RetiredTm | The date and time when the sales lead is moved to Retired status. |
| SalesAccountId | The unique identifier of the sales account to which the lead is associated. |
| SalesChannel | Indicates the sales channel responsible for following up on this sales lead. A list of accepted values is defined in the lookup type ZPM_SALES_CHANNEL. |
| Score | The score associated with this sales lead. This score is computed based on the scoring rules. |
| SourceCode | The marketing source code associated with this sales lead. |
| SourceCodeId | The unique identifier of the marketing source code associated with the lead. |
| State | The state where the primary contact of the lead is located. |
| StatusCode | The predefined code used to indicate the status of a lead. A list of accepted values is defined in the lookup type MKL_LEAD_STATUS. |
| StgExecId | The identifier of the stage execution in the lead. This is a foreign key of the Stage Execution view object. |
| TaskGuid | The unique identifier of the approval task pertaining to a partner registered lead. |
| TestFlag | |
| Timeframe | The time frame associated with this sales lead. A list of accepted values is defined in the lookup type MKL_LEAD_TIMELINE_SETID. |
| TimeframeSetId | |
| ToReassignFlag | Indicates leads that are either unassigned or have been selected for automatic reassignment. A list of accepted values is defined in the lookup type YES_NO. |
| ToRescoreFlag | Indicates if this lead needs to be re-scored. A list of accepted values is defined in the lookup type YES_NO. |
| UserLastUpdateDate | The date and time of last update date of lead row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database. |
| VerifiedContact | The option used for lead qualification. |
| WorkPhoneAreaCode | The area code of the work phone associated with the sales lead contact. |
| WorkPhoneCountryCode | The country code of the work phone associated with the sales lead contact. |
| WorkPhoneNumber | The work phone number for the sales lead contact. |