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