ContactExtAddress

PX.Objects.CR

72 of 72 fields

	Field Name	Type	Display Name	Foreign Key
	`ContactBAccountID`	`int`	Business Account ID	-
Description:No description available
	`ContactID`	`int`	ContactID	-
Description:No description available
	`AddressID`	`int`	Address ID	-
Description:No description available
	`AddressLine1`	`nvarchar(70)`	Address Line 1	-
Description:No description available
	`AddressLine2`	`nvarchar(70)`	Address Line 2	-
Description:No description available
	`AddressLine3`	`nvarchar(70)`	Address Line 3	-
Description:No description available
	`AddressType`	`char(2)`	AddressType	-
Description:No description available
	`BAccountID`	`int`	Business Account ID	BAccount
Description:No description available
	`BuildingName`	`nvarchar(35)`	Building Name	-
Description:No description available
	`BuildingNumber`	`nvarchar(16)`	Building Number	-
Description:No description available
	`City`	`nvarchar(50)`	City	-
Description:No description available
	`ContactCreatedByID`Default Navigation	`uniqueidentifier`	Created By	-
Description:No description available
	`ContactCreatedByScreenID`	`varchar(8)`		-
Description:No description available
	`ContactCreatedDateTime`	`datetime`		-
Description:No description available
	`ContactDisplayName`Default Navigation	`nvarchar(255)`	Name	Contact
Description:No description available
	`ContactLastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	-
Description:No description available
	`ContactLastModifiedByScreenID`	`varchar(8)`		-
Description:No description available
	`ContactLastModifiedDateTime`	`datetime`		-
Description:No description available
	`ContactNoteID`	`uniqueidentifier`		-
Description:No description available
	`ContactType`	`char(2)`		-
Description:No description available
	`CountryID`Default Navigation	`nvarchar(100)`	Country	Country
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`varchar(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`DateOfBirth`	`datetime2`	Date Of Birth	-
Description:No description available
	`DefAddressID`	`int`	Default Address	Address
Description:No description available
	`Department`	`nvarchar(70)`	Department	-
Description:No description available
	`DisplayName`	`nvarchar(MAX)`	Address	-
Description:No description available
	`DistrictName`	`nvarchar(35)`	District Name	-
Description:No description available
	`EMail`	`nvarchar(255)`	Email	-
Description:No description available
	`Fax`	`nvarchar(50)`	Fax	-
Description:No description available
	`FaxType`	`varchar(3)`	Fax	-
Description:No description available
	`FirstName`	`nvarchar(50)`	First Name	-
Description:No description available
	`Floor`	`nvarchar(70)`	Floor	-
Description:No description available
	`FullName`	`nvarchar(255)`		-
Description:No description available
	`IsActive`	`bit`	Active	-
Description:No description available
	`IsAddressSameAsMain`Nonexistent in DB	`bit`	Same as Main	-
Description:No description available
	`IsDefault`Nonexistent in DB	`bit`	Is Default	-
Description:No description available
	`IsValidated`	`bit`	Validated	-
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`varchar(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`LastName`	`nvarchar(100)`	Last Name	-
Description:No description available
	`Latitude`	`decimal`	Latitude	-
Description:No description available
	`Longitude`	`decimal`	Longitude	-
Description:No description available
	`MidName`	`nvarchar(50)`	Middle Name	-
Description:No description available
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`Phone1`	`nvarchar(50)`	Phone 1	-
Description:No description available
	`Phone1Type`	`varchar(3)`	Phone 1	-
Description:No description available
	`Phone2`	`nvarchar(50)`	Phone 2	-
Description:No description available
	`Phone2Type`	`varchar(3)`	Phone 2	-
Description:No description available
	`Phone3`	`nvarchar(50)`	Phone 3	-
Description:No description available
	`Phone3Type`	`varchar(3)`	Phone 3	-
Description:No description available
	`PostalCode`	`varchar(20)`	Postal Code	-
Description:No description available
	`PostBox`	`nvarchar(16)`	Post Box	-
Description:No description available
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`RevisionID`	`int`		-
Description:No description available
	`Room`	`nvarchar(70)`	Room	-
Description:No description available
	`Salutation`	`nvarchar(255)`	Job Title	-
Description:No description available
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`State`Default Navigation	`nvarchar(50)`	State	State
Description:No description available
	`StreetName`	`nvarchar(70)`	Street Name	-
Description:No description available
	`SubDepartment`	`nvarchar(70)`	Subdepartment	-
Description:No description available
	`TaxLocationCode`	`nvarchar(30)`	Tax Location Code	-
Description:No description available
	`TaxLocationCodeFull`	`nvarchar(70)`	Full Tax Location Code	-
Description:No description available
	`TaxMunicipalCode`	`nvarchar(30)`	Tax Municipal Code	-
Description:No description available
	`TaxSchoolCode`	`nvarchar(30)`	Tax School Code	-
Description:No description available
	`Title`	`nvarchar(50)`	Position	-
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
	`WebSite`	`nvarchar(255)`	Web	-
Description:No description available