PO
POContact
PX.Objects.PO28 of 28 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ContactID | int | Contact ID | - | |
Description:The identifier of the contact. | ||||
Attention | nvarchar(255) | Attention | - | |
Description:The field that is used in the contact's business letters to direct the letter to the proper person if the letter is not addressed to any specific person. | ||||
BAccountContactID | int | Contact | ||
Description:The identifier of the business contact. The field is included in FK.BAccountContact. The value of this field corresponds to the value of the Contact.contactID field. | ||||
BAccountID | int | BAccount | ||
Description:The identifier of the business account. The field is included in FK.BAccount. The value of this field corresponds to the value of the BAccount.bAccountID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
Email | nvarchar(255) | - | ||
Description:The email of the contact. | ||||
Fax | varchar(50) | 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(255) | Account Name | - | |
Description:The account name of the contact. | ||||
IsDefaultContact | bit | Vendor Default | - | |
Description: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. | ||||
LastModifiedByID | 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 | ||||
OverrideContactNonexistent in DB | bit | Override | - | |
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(50) | 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(50) | 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(50) | 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 purchase order or in the overridden contact in an existed purchase order. | ||||
Salutation | nvarchar(255) | 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 | ||||