Commerce

SOShipmentAddress

PX.Commerce.ObjectsRelease 2025.2

DAC extension of SOAddress to use alias in query

Select a row for its description 37 of 37 fields

	Field Name	Type	Display Name	Foreign Key
	`AddressID`	`int`	Address ID	-
Description:The identifier of the address.
	`AddressLine1`	`nvarchar`	Address Line 1	-
Description:The first line of the address.
	`AddressLine2`	`nvarchar`	Address Line 2	-
Description:The second line of the address.
	`AddressLine3`	`nvarchar`	Address Line 3	-
Description:The third line of the address.
	`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`	City	-
Description:The city of the address.
	`CountryID`Default Navigation	`nvarchar`	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
	`CustomerAddressID`	`int`		ARAddress
Description:The identifier of the customer address. The field is included in FK.CustomerAddress. The value of this field corresponds to the value of the ARAddress.addressID field.
	`CustomerID`	`int`		Customer
Description:The identifier of the customer. The field is included in FK.Customer. The value of this field corresponds to the value of the Customer.bAccountID field.
	`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`	Default Customer Address	-
Description:Specifies (if set to true) that the address is default. 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.
	`IsEncrypted`	`bit`		-
Description:Indicates if Personally identifiable Information fields (example AddressLine1 , AddressLine2 etc.) are encrypted or not.
	`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 Address	-
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`	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 sales order or in the overridden address in an existed sales order.
	`Room`	`nvarchar(70)`	Room	-
Description:Floor or storey within a building (ISO 20022).
	`State`Default Navigation	`nvarchar`	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