POAddress

PX.Objects.PORelease 2025.2

Represents an address that is used in purchase order management.

Select a row for its description 36 of 36 fields

	Field Name	Type	Display Name	Foreign Key
	`AddressID`	`int`		-
Description:The identifier of the address.
	`AddressLine1`	`nvarchar(70)`	Address Line 1	-
Description:The first line of the address.
	`AddressLine2`	`nvarchar(70)`	Address Line 2	-
Description:The second line of the address.
	`AddressLine3`	`nvarchar(70)`	Address Line 3	-
Description:The third line of the address.
	`BAccountAddressID`	`int`		Address
Description:The identifier of the business account address. The field is included in FK.BAccountAddress. The value of this field corresponds to the value of the Address.addressID field.
	`BAccountID`	`int`		BAccount
Description:The identifier of the business account. The field is included in FK.BAccount. The value of this field corresponds to the value of 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`	`nvarchar(50)`	City	-
Description:The city of the address.
	`CountryID`Default Navigation	`nvarchar(100)`	Country	Country
Description:The identifier of the country. The field is included in FK.Country and FK.State. The value of this field corresponds to the value of 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).
	`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).
	`IsDefaultAddress`	`bit`	Is Default Address	-
Description:If the value is false, the address has been overridden or the original address has been copied with the revision related to the moment of creation.
	`IsValidated`	`bit`	Validated	-
Description:Specifies (if set to true) that the address has been validated with a third-party specialized software or service.
	`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`	Latitude	-
Description:The latitude of the address location.
	`Longitude`	`decimal`	Longitude	-
Description:The longitude of the address location.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OverrideAddress`Nonexistent in DB	`bool?`	Override	-
Description:Specifies (if set to true) that the address is overriden. If the value of the isDefaultAddress field is null, the value of this field is null. If the value of the isDefaultAddress field is true, the value of this field is false. If the value of the isDefaultAddress field is false, the value of this field is true.
	`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).
	`PostalCode`	`nvarchar(20)`	Postal Code	-
Description:The postal code of the address.
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`RevisionID`	`int`		-
Description:The identifier of the revision address. Each modification to the original address leads to the generation of a new revision of the address, which is used in the new purchase order or in the overridden address in an existed purchase order.
	`Room`	`nvarchar(70)`	Room	-
Description:Floor or storey within a building (ISO 20022).
	`State`Default Navigation	`nvarchar(50)`	State	State
Description:The identifier of the state. The field is included in FK.State. The value of this field corresponds to the value of 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).
	`TownLocationName`	`nvarchar(35)`	Town Location Name	-
Description:Specific location name within the town (ISO 20022).
	`UnitNumber`	`nvarchar(16)`	Unit Number	-
Description:Identifies a flat or dwelling within the building (ISO 20022).
	`tstamp`	`timestamp`		-
Description:No description available