| Table Name: | territory |
| Table Number: | 5002 |
| Group: | Sales Mgr |
| Description: | Information about a sales territory |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | LONG | tinyint | 1 | DIRECT | Indicates whether the territory is active; i.e., 0=inactive, 1=active. Default=1 | |||
| comments | CHAR | varchar | 255 | Comments about the territory | ||||
| description | CHAR | varchar | 255 | The description of the territory | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| end_date | CLK_TIME | datetime | The ending date of the territory | Search (1) | ||||
| is_default | LONG | int | 0 | DIRECT | Indicates whether the object is the default territory; i.e., 0=no, 1=yes. Used for auto-generated opportunities, which must be related to a territory | |||
| name | CHAR | varchar | 2 | 80 | Name of the territory | Search (10) | ||
| node_key | CHAR | varchar | 255 | Used for rollups. Holds the path from top to the current territory in the hierarchy of territories. Reserved; obsolete. Replaced by ter_rol_itm | Search (5) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (11) | ||
| start_date | CLK_TIME | datetime | The starting date of the territory | |||||
| terr_id | CHAR | varchar | 80 | User-specified ID number of the territory | Search (8) | |||
| type | CHAR | varchar | 40 | The territory type. This is a user-defined pop up with default name Territory Type |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| prospect2bus_org | OTM | bus_org | prospect2territory | Organizations assigned to the territory | |||
| terr2emp_ter_role | OTM | emp_ter_role | emp_ter_role2territory | Employees involved with the territory. Reserved; obsolete, replaced by terr2usr_ter_role | |||
| include2filterset | OTOP | filterset | include2territory | Filterset which selects business organizations for the territory. Reserved; future | |||
| terr2frcst_itm | OTM | frcst_itm | frcst_itm2territory | Related forecast items | |||
| terr2frcst_target | OTM | frcst_target | frcst2territory | Forecast target for the territory. Reserved obsolete. Object usr_ter_role now links the frcst_target to its territory | |||
| terr2opportunity | OTM | opportunity | opp2territory | Opportunities assigned to the territory | |||
| terr2org_ter_role | OTM | org_ter_role | org_ter_role2territory | Roles that territories and business organization play for one another. Reserved; future | |||
| terr2per_ter_role | OTM | per_ter_role | per_role2territory | Persons involved with the territory | |||
| parent2ter_rol_itm | OTM | ter_rol_itm | rol_parent2territory | Related parent rollup items | |||
| child2ter_rol_itm | OTM | ter_rol_itm | rol_child2territory | Related child rollup items | |||
| territory2terr_defn | OTM | terr_defn | terr_defn2territory | Descriptions of the territory | |||
| parent2territory | OTM | territory | child2territory | Directly subordinate territories. Reserved; obsolete. Replaced by ter_rol_itm | |||
| child2territory | MTO | territory | parent2territory | Territory the current territory reports to. Reserved; obsolete. Replaced by ter_rol_itm | |||
| terr2usr_ter_role | OTM | usr_ter_role | user_role2territory | Employees involved with the territory |
| Index Name | Fields | Flags |
|---|---|---|
| id_index | terr_id | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| id_index | terr_id | nonclustered, unique located on PRIMARY |
| ind_child2territory | child2territory | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5092 | terr_empl_view | emp_ter_role, employee, territory, user |
| 5158 | frtrgt_view | currency, frcst_target, territory, user |
| 5159 | frcstitem_view | currency, frcst_itm, opportunity, territory, user |
| 5189 | v_frcstitem | currency, frcst_itm, opportunity, territory, user |
| 5230 | oppempl_view | cycle_stage, employee, opportunity, territory, user |
| 5344 | sfa_frcst_v | bus_org, currency, frcst_itm, opportunity, territory, user |
| 5347 | sfa_target | bus_org, currency, frcst_target, gbst_elm, territory, user |
| 5349 | sfa_terr_tm | contact, employee, territory, user, usr_ter_role |
| 5353 | sfa_ter_rol | rollup, ter_rol_itm, territory |
| 5357 | sfa_opp_mto_v | currency, cycle_stage, lead_source, life_cycle, opportunity, territory |
| 5742 | opp_summary_v | currency, cycle_stage, lead_source, life_cycle, opportunity, territory |
| territory | |||