Skip to main content
CR

CRAddress

PX.Objects.CRRelease 2025.2

Represents an address that is specified in the document, such as an opportunity's contact address. A CRAddress record is as a copy of the default location Address of the business account and can be used to override the address specified in the document. A CRAddress record is independent from changes to the original Address record.

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.
BAccountAddressID
intAddress
Description:The identifier of the Address record from the referenced BAccountID record. This field corresponds to the BAccount.DefAddressID field.
BAccountID
intBAccount
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.
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).
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).
IsDefaultAddress
bitDefault Customer Address-
Description:If set to true, the field indicates that the address record is identical to the original Address record that is referenced by BAccountAddressID. The default value is false.
IsValidated
bitValidated-
Description:If set to true, the 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
OverrideAddressNonexistent in DB
bool?Override Address-
Description:If set to true, the field indicates that the address overrides the default Address record, that is referenced by BAccountAddressID. This field is the inverse of IsDefaultAddress.
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.
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).
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).
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