Skip to main content
CR

Address

PX.Objects.CRRelease 2025.2

Represents an address of the business account, the contact or the lead.

Field NameTypeDisplay NameForeign Key
AddressID
intAddress ID-
Description:The unique integer identifier of the record. This field is the key field.
AddressLine1 API
nvarchar(70)Address Line 1-
Description:The first line of the street address.
AddressLine2 API
nvarchar(70)Address Line 2-
Description:The second line of the street address.
AddressLine3
nvarchar(70)Address Line 3-
Description:The third line of the street address.
AddressType
char(2)AddressType-
Description:The type of the address. The field can have one of the values described in the AddressTypes class. The default value is AddressTypes.BusinessAddress.
BAccountID
intBusiness Account ID-
Description:The identifier of the BAccount record that is specified in the business account to which the address belongs. Corresponds to the BAccount.BAccountID field.
BuildingName API
nvarchar(35)Building Name-
Description:Name of the building or house (ISO 20022).
BuildingNumber API
nvarchar(16)Building Number-
Description:Number that identifies the position of a building on a street (ISO 20022).
City API
nvarchar(50)City-
Description:The name of the city or inhabited locality.
CountryID API Default Navigation
nvarchar(100)CountryCountry
Description:The identifier of the Country record. Corresponds to the Country.CountryID field.
County
nvarchar(255)County-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetime-
Description:No description available
Department API
nvarchar(70)Department-
Description:Identification of a division of a large organization or building (ISO 20022).
DisplayNameNonexistent in DB
stringAddress-
Description:The display name of the address as a concatenation of address lines (AddressLine1, AddressLine2 and AddressLine2 fields).
DistrictName API
nvarchar(35)District Name-
Description:Identifies a subdivision within a country sub-division (ISO 20022).
Floor API
nvarchar(70)Floor-
Description:Floor or storey within a building (ISO 20022).
IsValidated
bitValidated-
Description:If set to true, this field indicates that the address has been successfully validated by Acumatica ERP.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime
datetime-
Description:No description available
Latitude
decimalLatitude-
Description:The latitude coordinates that are entered for a location if the location does not contain the postal address or the postal address cannot be validated. The field value is filled using the Google or Bing lookup.
Longitude
decimalLongitude-
Description:The longitude coordinates that are entered for a location if the location does not contain the postal address or the postal address cannot be validated. The field value is filled using the Google or Bing lookup.
NoteID
uniqueidentifier-
Description:No description available
PostBox API
nvarchar(16)Post Box-
Description:Numbered box in a post office, assigned to a person or organisation, where letters are kept until called for (ISO 20022).
PostalCode API
nvarchar(20)Postal Code-
Description:The postal code part of the address.
PsdCode
nvarchar(30)PSD Code-
Description:No description available
PseudonymizationStatus
intPseudonymized-
Description:No description available
RevisionID
int-
Description:The revision ID of the original record.
Room API
nvarchar(70)Room-
Description:Floor or storey within a building (ISO 20022).
SelectedNonexistent in DB
bool?Selected-
Description:No description available
State API Default Navigation
nvarchar(50)StateState
Description:The string identifier of the state or province part of the address. Corresponds to the State.StateID field.
StreetName API
nvarchar(70)Street Name-
Description:Name of a street or thoroughfare (ISO 20022).
SubDepartment API
nvarchar(70)Subdepartment-
Description:Identification of a sub-division of a large organization or building (ISO 20022).
TaxLocationCode
nvarchar(30)Tax Location Code-
Description:The code of the location tax that is used in reports.
TaxLocationCodeFull
nvarchar(70)Full Tax Location Code-
Description:The tax location code according to Symmetry Location Service specifications.
TaxMunicipalCode
nvarchar(30)Tax Municipal Code-
Description:The code of the municipal tax that is used in reports.
TaxSchoolCode
nvarchar(30)Tax School Code-
Description:The code of the school tax that is used in reports.
TownLocationName API
nvarchar(35)Town Location Name-
Description:Specific location name within the town (ISO 20022).
UnitNumber API
nvarchar(16)Unit Number-
Description:Identifies a flat or dwelling within the building (ISO 20022).
tstamp
timestamp-
Description:No description available