COMPANY

Company ID for which the contact works.

COMPANY_NAME

Name of the company for which the contact works.

CONTACT_ID

Contact ID (defined in the table KCRT_CONTACTS).

CREATED_BY

ID of the user who created the contact.

CREATION_DATE

Date the contact was created.

EMAIL_ADDRESS

Email address of the contact.

FIRST_NAME

First name of the contact.

FULL_NAME

Full name of the contact.

LAST_NAME

Last name of the contact.

LAST_UPDATED_BY

ID of the user who last updated the contact.

LAST_UPDATE_DATE

Date the contact was last updated.

PHONE_NUMBER

Phone number of the contact.

USERNAME

Contact username (if applicable). This can be the username for an external system, and not PPM.

USER_ID

UserID of the contact, if the contact is a PPM user.