ARContact

PX.Objects.AR

29 of 29 fields

	Field Name	Type	Display Name	Foreign Key
	`ContactID`	`int`	Contact ID	-
Description:The unique integer identifier of the record. This field is the primary key field.
	`Attention`	`nvarchar(2500)`	Attention	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CustomerContactID`	`int`		Contact
Description:The identifier of the Contact record from which the contact was originally created. Corresponds to the Contact.ContactID field.
	`CustomerID`	`int`		Vendor
Description:The identifier of the Customer record, which is specified in the document to which the contact belongs. Corresponds to the Customer.BAccountID field.
	`Email`	`nvarchar(2500)`	Email	-
Description:The e-mail address of the contact.
	`Fax`	`varchar(2500)`	Fax	-
Description:The fax number of the contact.
	`FaxType`	`varchar(3)`	Fax	-
Description:The type of the fax number of the contact. This field can have one of the values defined by PhoneTypesAttribute.
	`FullName`	`nvarchar(2500)`	Account Name	-
Description:The business name or the company name of the contact.
	`IsDefaultContact`	`bit`	Default Customer Contact	-
Description:If set to "true", indicates that the contact record is identical to the original Contact record referenced by the CustomerContactID field.
	`IsEncrypted`	`bit`		-
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OverrideContact`Nonexistent in DB	`bit`	Override Contact	-
Description:If set to "true", indicates that the contact overrides the default Contact record referenced by the CustomerContactID field. This field is the inverse of IsDefaultContact.
	`Phone1`	`varchar(2500)`	Phone 1	-
Description:The first phone number of the contact.
	`Phone1Type`	`varchar(3)`	Phone 1	-
Description:The type of the first phone number of the contact. This field can have one of the values defined by PhoneTypesAttribute.
	`Phone2`	`varchar(2500)`	Phone 2	-
Description:The second phone number of the contact.
	`Phone2Type`	`varchar(3)`	Phone 2	-
Description:The type of the second phone number of the contact. This field can have one of the values defined by PhoneTypesAttribute.
	`Phone3`	`varchar(2500)`	Phone 3	-
Description:The third phone number of the contact.
	`Phone3Type`	`varchar(3)`	Phone 3	-
Description:The type of the third phone number of the contact. This field can have one of the values defined by PhoneTypesAttribute.
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`RevisionID`	`int`		-
Description:The revision ID of the original Contact record from which the record originates. Corresponds to the Contact.RevisionID field.
	`Salutation`	`nvarchar(2500)`	Job Title	-
Description:The name of the contact person. This field is usually used in email templates, as shown in the following example: "Dear {Contact.Salutation}!".
	`Title`	`nvarchar(50)`	Title	-
Description:The contact's title. This field can have one of the values defined by TitlesAttribute.
	`tstamp`	`timestamp`		-
Description:No description available