Commerce

ARContact2

PX.Commerce.ObjectsRelease 2025.2

DAC Extension of ARContact to add additional properties.

Select a row for its description 29 of 29 fields

	Field Name	Type	Display Name	Foreign Key
	`Attention`	`nvarchar`	Attention	-
Description:The attention for this contact.
	`ContactID`	`int`	Contact ID	-
Description:The unique integer identifier of the record. This field is the primary key field.
	`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`	Email	-
Description:The email address of the contact.
	`Fax`	`nvarchar`	Fax	-
Description:The fax number for this contact.
	`FaxType`	`nvarchar(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`	Account Name	-
Description:The full name for 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	`bool?`	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`	`nvarchar`	Phone 1	-
Description:The primary phone for this contact.
	`Phone1Type`	`nvarchar(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`	`nvarchar`	Phone 2	-
Description:The secondary phone for this contact.
	`Phone2Type`	`nvarchar(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`	`nvarchar`	Phone 3	-
Description:The tertiary phone for this contact.
	`Phone3Type`	`nvarchar(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`	Job Title	-
Description:The salutation to use with this contact.
	`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