Address

PX.Objects.CR

View API Entity: Address/entity/Default/24.200.001/Address

40 of 40 fields

	Field Name	Type	Display Name	Foreign Key
	`AddressID`	`int`	Address 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`	`int`	Business Account ID	BAccount
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`	`nvarchar(35)`	Building Name	-
Description:Name of the building or house (ISO 20022).
	`BuildingNumber`	`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`Default Navigation	`nvarchar(2)`	Country	Country
Description:The identifier of the Country record. Corresponds to the Country.CountryID field.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`Department`	`nvarchar(70)`	Department	-
Description:Identification of a division of a large organization or building (ISO 20022).
	`DisplayName`	`nvarchar(MAX)`	Address	-
Description:No description available
	`DistrictName`	`nvarchar(35)`	District Name	-
Description:Identifies a subdivision within a country sub-division (ISO 20022).
	`Floor`	`nvarchar(70)`	Floor	-
Description:Floor or storey within a building (ISO 20022).
	`IsValidated`	`bit`	Validated	-
Description:If set to , this field indicates that the address has been successfully validated by Acumatica ERP.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`Latitude`	`decimal(10, 6)`	Latitude	-
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`	`decimal(10, 6)`	Longitude	-
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
	`PostalCode` API	`varchar(20)`	Postal Code	-
Description:The postal code part of the address.
	`PostBox`	`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).
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`RevisionID`	`int`		-
Description:The revision ID of the original record.
	`Room`	`nvarchar(70)`	Room	-
Description:Floor or storey within a building (ISO 20022).
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`State` API Default Navigation	`nvarchar(50)`	State	State
Description:The string identifier of the state or province part of the address. Corresponds to the State.StateID field.
	`StreetName`	`nvarchar(70)`	Street Name	-
Description:Name of a street or thoroughfare (ISO 20022).
	`SubDepartment`	`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:No description available
	`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`	`nvarchar(35)`	Town Location Name	-
Description:Specific location name within the town (ISO 20022).
	`tstamp`	`timestamp`		-
Description:No description available
	`UnitNumber`	`nvarchar(16)`	Unit Number	-
Description:Identifies a flat or dwelling within the building (ISO 20022).