SOContact

PX.Objects.SO

29 of 29 fields

	Field Name	Type	Display Name	Foreign Key
	`ContactID`	`int`	Contact ID	-
Description:The identifier of the contact.
	`Attention`	`nvarchar(2500)`	Attention	-
Description:The field is used in the contacts business letters, which would be used to direct the letter to the proper person if the letter is not addressed to any specific person.
	`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`		ARContact
Description:The identifier of the customer contact. The field is included in FK.CustomerContact. The value of this field corresponds to the value of the ARContact.contactID 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.
	`Email`	`varchar(2500)`	Email	-
Description:The email 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. The field can have one of the values described in CR.PhoneTypesAttribute.
	`FullName`	`nvarchar(2500)`	Account Name	-
Description:The account name of the contact.
	`IsDefaultContact`	`bit`	Default Customer Contact	-
Description:Specifies (if set to ) that the contact is default. If the value is , the contact has been overridden or the original contact has been copied with the revision related to the moment of creation.
	`IsEncrypted`	`bit`		-
Description:Indicates if Personally identifiable Information fields (example Email , Phone1, Fax etc.) are encrypted or not
	`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:Specifies (if set to ) that the contact is overriden. If the value of the isDefaultContact field is , the value of this field is . If the value of the isDefaultContact field is , the value of this field is . If the value of the isDefaultContact field is , the value of this field is .
	`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. The field can have one of the values described in CR.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. The field can have one of the values described in CR.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. The field can have one of the values described in CR.PhoneTypesAttribute.
	`PseudonymizationStatus`	`int`	Pseudonymized	-
Description:No description available
	`RevisionID`	`int`	RevisionID	-
Description:The identifier of the revision contact. Each modification to the original contact leads to the generation of a new revision of the contact, which is used in the new sales order or in the overridden contact in an existed sales order.
	`Salutation`	`nvarchar(2500)`	Job Title	-
Description:The job title of the contact.
	`Title`	`nvarchar(50)`	Title	-
Description:The name title of the contact.
	`tstamp`	`timestamp`		-
Description:No description available