Address

Type: Tessitura.Service.Client.CRM.Address

Property Name Data Type Length Required Readonly Notes
Id integer N Unique key for Address.
AffiliatedConstituent Entity N Constituent which is linked to this address through an Affiliation.
AltSalutationType SalutationTypeSummary N Overriding salutation type to be used when this address is chosen.
FK: TR_SIGNOR.id   Resource: SalutationTypes
AddressType AddressTypeSummary N Categorizing of address along business requirements or address use.
FK: TR_ADDRESS_TYPE.id   Resource: AddressTypes
City string N Required if Country has city required (ReqCity = true).
CreatedDateTime date N readonly
CreateLocation string N readonly
CreatedBy string N readonly
Constituent Entity N Owning constituent of the address. If the constituent is a household, primary affiliates may inherit the address. The constituent will not always be the same as the requesting constituent.
FK: T_CUSTOMER.customer_no   Resource: Constituents
DeliveryPoint string N
EndDate date N Optional date to mark when an address is no longer in use.
GeoArea integer N Optional classification of an address to a geographical region. Backed by a reference DB table TR_GEO_AREA which is user defined.
Inactive boolean N Inactive addresses are not available for output and cannot be primary for a constituent.
Label boolean N Whether this address can be used for Label output.
UpdatedDateTime date N readonly
UpdatedBy string N readonly
Months string N String consisting of 12 'Y' or 'N' characters indicating the availability of this address based on each calendar month, January being position 1 and December being position 12. An address available only for summer months (June, July, August) would be sent as "NNNNNYYYNNNN".
NcoaAction integer N NCOA Processing flag indicating the current action.
NcoaSession integer N NCOA unique session id for utility run.
PostalCode string N Postal code, zip code, locale code. The usage, format, and edit mask is determined by Country settings.
PostalCodeFormatted string N readonly Formatted postal code based on country formatting.
PrimaryIndicator boolean N Every constituent who has an address (depending on system default rules) must have a primary address.
StartDate date N The date the address begins being active.
State StateSummary N State, locale, or province for this address. Usage requirement determined by Country settings.
FK: TR_STATE.id   Resource: States
Street1 string N Required line for address. Order of Street properties determined by system defaults (ADDRESS_STREET_ORDER).
Street1Address StreetAddress N readonly Street1 parsed into its street and number components. For internal use.
Street2 string N Optional line for address. Order of Street properties determined by system defaults (ADDRESS_STREET_ORDER).
Street3 string N Optional line for address. Order of Street properties determined by system defaults (ADDRESS_STREET_ORDER). Ability to use street3 determined by System Default: ADDRESS_USE_STREET3.
Country CountrySummary N Not required for system default country.
FK: TR_COUNTRY.id   Resource: Countries
EditIndicator boolean N readonly Readonly property indicating edit rights based on AddressType control group.
IsFromAffiliation boolean N readonly Indicates that this address is returned because of a constituent's affiliation.