Account Territory
Account territory table from Align. This table is joined to the Territory and Account table for additional attributes joined together. Mappings are delivered disabled by default. If appropriate objects are brought into Nitro from Align, this mapping table can be enabled in the Align connector.
| Global ODS Field | Field Type |
Source Data Connector: Align Table: account_territory_ods__aln |
|---|---|---|
| composite_key__v | varchar(18) |
|source_connector_name__v|vault_account_territory_id__v|start_date__v| |
| source_system_id__v | varchar(18) | Extracted from Internal Admin Console |
| native_id__v | varchar(125) | vault_account_territory_id__v |
| source_connector_name__v | varchar(100) | Extracted from Internal Admin Console |
| source_table_name__v | varchar(100) | account_territory_ods__aln |
| territory_id__v | varchar(1000) | territory__aln |
| territory_name__v | varchar(384) | territory_ods__aln.territory_name__v |
| territory_description__v | varchar(3000) | territory_ods__aln.description__aln |
| hierarchy_level__v | varchar(1280) | hierarchy_level__aln |
| field_force_name__v | varchar(384) | field_force_ods__aln.field_force_name__v |
| account_territory_start_date__v | date | start_date__aln |
| account_territory_end_date__v | date | end_date__aln |
| send_to_crm__v | boolean | send_to_crm__aln |
| acct_terr_status__v | varchar(1280) | status__aln |
| acct_unique_id__v | varchar(100) | account_ods__aln.vault_account_id__v |
| acct_crm_record_id__v | varchar(384) | account_ods__aln.crm_record_id__aln |
| acct_entity_type__v | varchar(240) | account_ods__aln.crm_record_type__aln |
| source__v | varchar(1280) | source__aln |
| acct_name__V | varchar(384) | account_ods__aln.account_name__v |
| account_territory_external_id__v | varchar(360) | external_id__aln |
| start_date__v | timestamp | start_date__v |
| end_date__v | timestamp | end_date__v |
| last_modified_date__v | timestamp | modified_date__v |
