|
Id
|
integer
|
|
Y
|
|
Unique key for Address.Non-updatable
|
|
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
|
|
Y
|
|
Categorizing of address along business requirements or address use.
|
| FK: TR_ADDRESS_TYPE.id Resource: AddressTypes |
|
City
|
string
|
30
|
N
|
|
Required if Country has city required (ReqCity = true).
|
|
CreatedDateTime
|
date
|
|
N
|
readonly
|
Non-updatable
|
|
CreateLocation
|
string
|
|
N
|
readonly
|
Non-updatable
|
|
CreatedBy
|
string
|
|
N
|
readonly
|
Non-updatable
|
|
Constituent
|
Entity
|
|
Y
|
|
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
|
8
|
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
|
|
Y
|
|
Inactive addresses are not available for output and cannot be primary for a constituent.
|
|
Label
|
boolean
|
|
Y
|
|
Whether this address can be used for Label output.
|
|
UpdatedDateTime
|
date
|
|
Y
|
readonly
|
Auto-assigned
|
|
UpdatedBy
|
string
|
|
N
|
readonly
|
Auto-assigned
|
|
Months
|
string
|
12
|
Y
|
|
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
|
10
|
Y
|
|
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
|
|
Y
|
|
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
|
|
Y
|
|
State, locale, or province for this address. Usage requirement determined by Country settings.
|
| FK: TR_STATE.id Resource: States |
|
Street1
|
string
|
64
|
Y
|
|
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
|
64
|
N
|
|
Optional line for address. Order of Street properties determined by system defaults (ADDRESS_STREET_ORDER).
|
|
Street3
|
string
|
64
|
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.Whether address is assigned based on an affiliation.
|