- Contents
Exchange Manager Help
Address Table
The Address table contains addresses for accounts. Each account can have multiple address records. You can import addresses for new business only. To import addresses, add the Address table to Exchange. For more information, see Add Address Table.
|
Field Name |
Description |
Length |
Data Type |
Parent Table and Field |
Import Types |
|
FakeID |
Relationship field. Don't map this field. |
4 |
Integer |
|
NB |
|
AddressID |
Code that Latitude assigns to identify an address record. Don't map this field. |
4 |
Integer |
|
NB |
|
DebtorAssociationID |
Code that Latitude assigns to identify a customer on an account. Don't map this field. |
4 |
Integer |
|
NB |
|
TypeCD |
Code that identifies the address type, such as home or work. You must have already created this code in Latitude. |
10 |
VarChar |
None |
NB |
|
StatusCD |
Code that identifies the status of the address, such as good, bad, or unknown. You must have already created this code in Latitude. |
10 |
VarChar |
None |
NB |
|
Active |
Flag that indicates whether the address is active. 1 = Yes, address is active 0 = No, address is not active |
1 |
Bit |
None |
NB |
|
Primary |
Flag that indicates whether the address is the customer's primary (main) address. 1 = Yes, address is primary 0 = No, address is not primary |
1 |
Bit |
None |
NB |
|
Correspondence |
Flag that indicates whether you can send correspondence to this address. 1 = Yes, you can send correspondence to this address 0 = No, you can't send correspondence to this address |
1 |
Bit |
None |
NB |
|
CultureCode |
Code that indicates the region where the customer is located. For example, "en-US" indicates that the customer is in an English-speaking country, and the country is the United States of America. |
10 |
VarChar |
None |
NB |
|
Source |
Source who provided the address, such as customer, client, or credit bureau. |
255 |
VarChar |
None |
NB |
|
ConfirmationSource |
Source who confirmed the validity of the address. |
255 |
VarChar |
None |
NB |
|
ConfirmationDate |
Date the source confirmed the validity of the address. |
8 |
DateTime |
None |
NB |
|
Street1 |
Customer's address line 1. |
128 |
VarChar |
None |
NB |
|
Street2 |
Customer's address line 2. |
128 |
VarChar |
None |
NB |
|
City |
Customer's city. |
30 |
VarChar |
None |
NB |
|
County |
Customer's county. |
50 |
VarChar |
None |
NB |
|
Country |
Customer's country. |
50 |
VarChar |
None |
NB |
|
StateCode |
Code that identifies the customer's state. |
3 |
VarChar |
None |
NB |
|
PostalCode |
Customer's postal code. |
10 |
VarChar |
None |
NB |
|
ActiveBy |
Code that identifies the user who flagged the address as active. You must have already created this code in Latitude. |
255 |
VarChar |
None |
NB |
|
ActiveDate |
Date the user flagged the address as active. |
8 |
DateTime |
None |
NB |
|
PrimaryBy |
Code that identifies the user who flagged the address as primary. You must have already created this code in Latitude. |
255 |
VarChar |
None |
NB |
|
PrimaryDate |
Date the user flagged the address as primary. |
8 |
DateTime |
None |
NB |
|
CorrespondenceBy |
Code that identifies the user who flagged the address as correspondence. You must have already created this code in Latitude. |
255 |
VarChar |
None |
NB |
|
CorrespondenceDate |
Date the user flagged the address as correspondence. |
8 |
DateTime |
None |
NB |
|
CreatedWhen |
Date the user created the address record. You must set the value to @DATE(). |
8 |
DateTime |
None |
NB |
|
CreatedBy |
Code that identifies the user who created the address record. You must have already created this code in Latitude. |
255 |
VarChar |
None |
NB |
|
ModifiedWhen |
Date the user modified the address record. You must set the value to @DATE(). |
8 |
DateTime |
None |
NB |
|
ModifiedBy |
Code that identifies the user who modified the address record. You must have already created this code in Latitude. |
255 |
VarChar |
None |
NB |