This entity represents address records associated with clients or other relationship types. The attached contains the required format for the IAddress.CSV with a sample record.
The Type defines how the sample file handles the data type to produce the correct delimiters for each field. Make sure to change the custom field format if any fields noted as "integer" contain alphanumeric data.
Fields
Field Name | Required | Type | Description |
RelationshipID | Y | nvarchar(4000) | Unique ID normally concatenated with Relationship Type. Example 5467|Client |
RelationshipPmsID | Y | nvarchar(MAX) | Matches Iclient.PmsID |
RelationshipType | Y | nvarchar(4000) | Defaults to Client |
Type |
| nvarchar(MAX) |
|
Line1 | Y | nvarchar(MAX) | Street address |
Line2 |
| nvarchar(MAX) |
|
City | Y | nvarchar(MAX) |
|
State | Y | nvarchar(MAX) |
|
PostalCode | Y | nvarchar(MAX) |
|
County |
| nvarchar(MAX) |
|
Country |
| nvarchar(MAX) |
|
DoNotContact |
| bit | Default is 0 |
IsPrimary |
| bit | Default is 1 |
Sequence |
| bit | Default is 1 |
[Key] |
| nvarchar(4000) | Unique record ID |
PmsID |
| nvarchar(MAX) | Unique record ID -can be the same as the [Key] |