Territories
The sales territories view object stores details about the owner, parent territory, and so on. 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.MotBiccExtractAM.TerritoryExtractPVO
Primary Keys : TerritoryVersionId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CorpCurrencyCode | The corporate currency code for the territory extract. |
| CoverageModel | Indicates whether the dimensions of the territory are based on account attributes or partner attributes. A list of accepted values is defined in the lookup type MOT_TERR_COVERAGE_MODEL. |
| CreatedBy | The user who created the territory. |
| CreatedByUserGuid | The identifier of the person creating the territory. |
| CreatedFromTerrVersionId | The version of the territory from which this row was created. If it is a new territory, it will be blank. If it's not a new territory, it will either contain a currently active territory version or the territory version from the past from which it's being restored. |
| CreatedOnDate | The date when the territory was created. |
| CreationDate | The date and time when the territory row was created. |
| CurcyConvRateType | This column stores the conversion rate type for the currency. |
| CurrencyCode | The currency code for the territory. |
| Description | A brief description of the territory. |
| EffectiveEndDate | The date and time when the territory version becomes inactive. |
| EffectiveStartDate | The date and time when the territory version becomes active. If the StatusCode is DRAFT, then this value should be empty. If the StatusCode is FINALIZED, this value should be today's date. |
| EligibleForQuotaFlag | Indicates whether the territory is going to change during a territory realignment. If the value is True, then the territory is unlikely to change during a major realignment and therefore a quota can be entered for the proposed definition. The default value is Y. |
| ExtnAttributeChar001 | A column reserved for the custom attribute 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 the custom attribute 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 the custom attribute 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 the custom attribute of type Time Stamp. |
| 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 | |
| ForecastByParentFlag | Indicates whether the territory needs to be forecast based on the parent territory. |
| ForecastParticipationCode | The code for the forecast participation. The accepted values are: REVENUE, NONREVENUE, REVENUE_AND_NONREVENUE, and NON_FORECASTING. These values are defined in the lookup type MOT_TERR_FCAST_PARTICIPATION. |
| GroupingTerritoryFlag | Indicates whether the territory is a shell territory. |
| LastUpdateDate | The date and time when the territory row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the territory row. |
| LastUpdatedBy | The user who last updated the territory row. |
| LatestVersionFlag | Indicates whether the territory is the latest active version. If the value is Y, then the territory version is the latest active version of the territory. |
| Name | The name of the territory. |
| OwnerOrgId | Unique identifier for the territory owner's organization. |
| OwnerResourceId | The identifier of the owner resource in the Territory. This is a foreign key to the Resource view object. |
| ParentTerritoryId | The unique identifier of the parent territory. |
| PartnerId | The unique identifier of the partner associated with the territory. This is a foreign key to the Partner Profile view object. |
| PartnerProgramId | The unique identifier of the partner program in which the partner is enrolled. |
| PriorActiveTerrVersionId | Original version ID of the territory. |
| QuotaRevReasonCode | Indicates if a quota needs to be updated when a modified territory is activated. A list of accepted values is defined in the lookup type MOT_QUOTA_REASON. |
| QuotaRevReasonDesc | The description of the reason for revising the quota. |
| ReviseQuotaFlag | Indicates whether a submitted quota needs to be revised. |
| SourceTerrId | The unique identifier of the territory from which the dimensions are inherited. |
| SourceTerrLastUpdateDate | The date and time when the source territory was last updated. This attribute is related to the inheritance of dimensions by recipient territories from source territories. |
| SourceTerrName | The name of the territory from which the selected dimensions are inherited. |
| SourceTerrVersionId | The unique identifier of the source territory version. |
| StageCode | This is an obsolete attribute. It specifies the different stages that a territory goes through from creation till activation. |
| StatusCode | The code indicating the status of the territory. The accepted values are DRAFT and FINALIZED. |
| TerrProposalId | The unique identifier of the territory proposal. |
| TerritoryFunctionCode | Business function associated with the territory. A list of accepted values is defined in the lookup type ORA_MOT_TERRITORY_FUNCTION. |
| TerritoryId | The unique identifier of the territory. |
| TerritoryLevel | The level of the territory in the territory hierarchy. |
| TerritoryNumber | The unique alternate identification number for the territory. |
| TerritorySignature | The document number that is used by different processes to compare the territory definition. |
| TerritoryVersionId | The unique identifier of the territory version. This is a primary key of the Territory view object. |
| TypeCode | The code indicating the type of the territory. For example, PRIME or OVERLAY. A list of accepted values is defined in the lookup type MOT_TERRITORY_TYPE. |
| UniqueTerritoryNumber | The unique identification number of the territory. |
| UpdatedByUserGuid | The person who last updated the territory object. This could be the territory or any of the territory child entities. |
| UpdatedOnDate | The date on which the territory object was last updated. This could be the territory or any of the territory child entities. |
| ValidateTerritoryFlag | Indicates whether optional validations are to be applied to the territory. |