SOAddress

PX.Objects.SO

37 of 37 fields

	Field Name	Type	Display Name	Foreign Key
	`AddressID`	`int`	Address ID	-
Description:The identifier of the address.
	`AddressLine1`	`nvarchar(2500)`	Address Line 1	-
Description:The first line of the address.
	`AddressLine2`	`nvarchar(2500)`	Address Line 2	-
Description:The second line of the address.
	`AddressLine3`	`nvarchar(2500)`	Address Line 3	-
Description:The third line of the address.
	`BuildingName`	`nvarchar(35)`	Building Name	-
Description:No description available
	`BuildingNumber`	`nvarchar(16)`	Building Number	-
Description:No description available
	`City`	`nvarchar(2500)`	City	-
Description:The city of the address.
	`CountryID`Default Navigation	`nvarchar(2500)`	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:No description available
	`DistrictName`	`nvarchar(35)`	District Name	-
Description:No description available
	`Floor`	`nvarchar(70)`	Floor	-
Description:No description available
	`IsDefaultAddress`	`bit`	Default Customer Address	-
Description:Specifies (if set to ) that the address is default. If the value is , 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 ) 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(10, 6)`	Latitude	-
Description:The latitude of the address location.
	`Longitude`	`decimal(10, 6)`	Longitude	-
Description:The longitude of the address location.
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OverrideAddress`Nonexistent in DB	`bit`	Override Address	-
Description:Specifies (if set to ) that the address is overriden. If the value of the isDefaultAddress field is , the value of this field is . If the value of the isDefaultAddress field is , the value of this field is . If the value of the isDefaultAddress field is , the value of this field is .
	`PostalCode`	`varchar(2500)`	Postal Code	-
Description:The postal code of the address.
	`PostBox`	`nvarchar(16)`	Post Box	-
Description:No description available
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`RevisionID`	`int`	RevisionID	-
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:No description available
	`State`Default Navigation	`nvarchar(2500)`	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:No description available
	`SubDepartment`	`nvarchar(70)`	Subdepartment	-
Description:No description available
	`TownLocationName`	`nvarchar(35)`	Town Location Name	-
Description:No description available
	`tstamp`	`timestamp`		-
Description:No description available
	`UnitNumber`	`nvarchar(16)`	Unit Number	-
Description:No description available