Stores address information for each constituent.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
ISPRIMARY
|
bit
|
false
|
|
Indicates this address is the primary address.
|
|
DONOTMAIL
|
bit
|
false
|
|
Indicates this address should not recieve mailings.
|
|
STARTDATE
|
UDT_MONTHDAY
|
false
|
|
For seasonal address types only; DD/MM start date of when this address should be considered for mailings.
|
|
ENDDATE
|
UDT_MONTHDAY
|
false
|
|
For seasonal address types only; DD/MM end date of when this address should be considered for mailings.
|
|
ADDRESSBLOCK
|
nvarchar(150)
|
false
|
|
Contains the address lines.
|
|
CITY
|
nvarchar(50)
|
false
|
|
Contains the address city.
|
|
POSTCODE
|
nvarchar(12)
|
false
|
|
Contains the address post code.
|
|
CART
|
nvarchar(10)
|
false
|
|
Contains the address carrier route (CART).
|
|
DPC
|
nvarchar(8)
|
false
|
|
Contains the address delivery point code
|
|
LOT
|
nvarchar(5)
|
false
|
|
Contains the address LOT.
|
|
SEQUENCE
|
int
|
false
|
|
Stores the user-defined sequence for addresses on a constituent.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
DESCRIPTION
|
nvarchar(300) (Computed)
|
true
|
|
Provides a translation field for the address record
|
|
HISTORICALSTARTDATE
|
date
|
true
|
|
Indicates the date that the constituent started using this address.
|
|
HISTORICALENDDATE
|
date
|
true
|
|
Indicates the date that the constituent stopped using this address.
|
|
ISCONFIDENTIAL
|
bit
|
false
|
|
Indicates this address is confidential.
|
