Territory Account Roster
Account Territory table from Align. This table is joined with Terrtory, Account and Roster Member tables for additional data points. 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(125) |
|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(18) | vault_account_territory_id__v |
| source_connector_name__v | varchar(100) | Extracted from Internal Admin Console |
| source_table_name__v | varchar(100) | account_territory__v |
| 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) | territory_ods__aln.hierarchy_level__aln |
| field_force_name__v | varchar(384) | field_force_ods__aln.field_force_name__v |
| send_to_crm__v | boolean | send_to_crm__aln |
| acct_terr_status__v | varchar(1280) | status__v |
| 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 |
| account_name__v | varchar(384) | account_ods__aln.account_name__v |
| roster_id__v | varchar(100) |
roster_member_territory_ods__aln.vault_ roster_member_territory_id__v |
| address_liine_1__v | varchar(384) |
roster_member_ods__aln.address_line_1__aln |
| full_name__v | varchar(360) |
roster_member_ods__aln.first_name__aln roster_member_ods__aln.last_name__aln |
| state__v | varchar(765) | roster_member_ods__aln.state__aln |
| city__v | varchar(384) | roster_member_ods__aln.city__aln |
| status__v | varchar(1280) | roster_member_ods__aln.status__aln |
| email_id__v | varchar(384) | roster_member_ods__aln.email__aln |
| title__v | varchar(240) | roster_member_ods__aln.title__aln |
| roster_external_id__v | varchar(360) | account_territory_ods__aln.external_id__aln |
| last_name__v | varchar(240) | roster_member_ods__aln.last_name__aln |
| first_name__v | varchar(120) | roster_member_ods__aln.first_name__aln |
| postal_code__v | varchar(60) | roster_member_ods__aln.postal_code__aln |
| start_date__v | timestamp | start_date__v |
| end_date__v | timestamp | end_date__v |
| last_modified_date__v | timestamp | modified_date__v |
