| objid | con_lsc_role | objid | Contact role internal record number | 3 (UNIQUE) |
| con_objid | contact | objid | Contact internal record number | |
| lsc_objid | lead_source | objid | lead_source internal record number | |
| role_name | con_lsc_role | role_name | Name of the role | |
| focus_type | con_lsc_role | focus_type | Object type ID of the role player; i.e., 5017=a lead source's role for the contact, 45=a contact's role for the lead source | |
| active | con_lsc_role | active | Indicates whether the role is currently being used; i.e., 0=inactive, 1=active, default=1 | |
| first_name | contact | first_name | Contact first name | 15 |
| last_name | contact | last_name | Contact last name | 14 |
| phone | contact | phone | Contact phone number which includes area code, number, and extension | |
| e_mail | contact | e_mail | Contact's e-mail address | |
| title | contact | title | Contact's professional title | |
| status | contact | status | Status of contact; i.e., active/inactive/obsolete | |
| src_id | lead_source | id | Unique identifier of the lead source | |
| src_name | lead_source | name | Name of the lead source | |
| description | lead_source | description | Description of the lead source | |
| src_type | lead_source | type | Type of source; e.g., seminar, trade show, etc. This is a user-defined pop up with default name Lead Source Type | |
| src_status | lead_source | status | Status of the lead source. This is a user-defined pop up with default name Lead Source Status | |
| start_date | lead_source | start_date | The date the lead source became active | |
| end_date | lead_source | end_date | The date the lead source ends | |
| is_default | lead_source | is_default | Indicates whether the object is the default lead source; i.e., 0=no, 1=yes. Used for auto-generated opportunities, which must be related to a lead_source | |