| Table Name: | lead |
| Table Number: | 5312 |
| Group: | Sales Mgr |
| Description: | Individual who is a sales lead for user |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | LONG | tinyint | 0 | DIRECT, CHANGE_FIELD | Indicates whether the lead is currently active; i.e., 0=active, 1=inactive, 2=obsolete, default=0 | Search (1) | ||
| active_stamp | CLK_TIME | datetime | 48 | CHANGE_DATE | The date and time when field 'active' last change | |||
| address | CHAR | varchar | 200 | Line one of the lead's address | Search (1) | |||
| address_2 | CHAR | varchar | 200 | Line two of the lead's address | Search (1) | |||
| arch_ind | LONG | tinyint | DIRECT, ALLOW_NULL | When set to 1, indicates the object is ready for purge/archive | ||||
| city | CHAR | varchar | 30 | City of the address | Search (1) | |||
| company_name | CHAR | varchar | 80 | Name of the lead's company | Search (1) | |||
| country | CHAR | varchar | 40 | Country of the address | Search (1) | |||
| create_date | CLK_TIME | datetime | The create date for the lead | |||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| e_mail | CHAR | varchar | 80 | Lead's e-mail address | Search (1) | |||
| email_contact | LONG | smallint | 1 | DIRECT | Gives constraints on contacting the lead by email; e.g., 0=do not email, 1=unrestricted email. Default=1 | Search (1) | ||
| fax | CHAR | varchar | 20 | Lead's fax number which includes area code, number, and extension | Search (1) | |||
| first_name | CHAR | varchar | 30 | Lead's first name | Search (3) | |||
| followup_date | CLK_TIME | datetime | The date and time that a follow up should happen | |||||
| followup_note | CHAR | varchar | 255 | Note for the followup | ||||
| last_name | CHAR | varchar | 30 | Lead's last name | Search (3) | |||
| last_update | CLK_TIME | datetime | 46 | Datetime of last update to the lead | ||||
| mail_stop | CHAR | varchar | 30 | Lead's internal company mail stop/location/building | Search (1) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) | ||
| owner_init | CHAR | varchar | 40 | Full name of the initial owner of the lead | ||||
| phone | CHAR | varchar | 20 | Lead's phone number which includes area code, number, and extension | Search (2) | |||
| phone_contact | LONG | smallint | 1 | DIRECT | Gives constraints on contacting the lead by phone; e.g., 0=do not call, 1=unrestricted calling. Default=1 | Search (1) | ||
| postal_code | CHAR | varchar | 20 | The zip or other postal code for the specified address | Search (1) | |||
| rating | CHAR | varchar | 40 | How hot the lead is; from a user-defined popup with name Lead Status | Search (1) | |||
| role_name | CHAR | varchar | 2 | 80 | Role that lead plays in his/her organization. Default role_name that is propagated to object contact_role.role name when the lead is promoted to a contact | Search (1) | ||
| salutation | CHAR | varchar | 20 | A form of address; e.g., Mr., Miss, Mrs | ||||
| sic_code | CHAR | varchar | 25 | Industry (sic) code or equivalent | ||||
| site_name | CHAR | varchar | 80 | Lead's site or location name | Search (1) | |||
| state | CHAR | varchar | 40 | State or province of the address | Search (1) | |||
| status | LONG | tinyint | DIRECT | Lead's status; i.e., 0=not yet promoted to a contact, 1=promoted to a contact | Search (1) | |||
| time_zone | CHAR | varchar | 20 | Time zone name in which an address is located | Search (1) | |||
| title | CHAR | varchar | 30 | Lead's professional title | Search (1) | |||
| type | CHAR | varchar | 20 | Characterizes the lead as a business opportunity or a consumer opportunity | Search (1) | |||
| web_site | CHAR | varchar | 255 | The lead's URL | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| lead2alert | OTM | alert | alert2lead | Alerts on the lead | ||||||
| lead2bus_led_role | OTM | bus_led_role | led_role2lead | Bus_org roles involving the lead | ||||||
| lead2contact_role | MTO | contact_role | con_role2lead | If the lead is promoted to a contact, the related contact_role object. This gives some indication of what the business context for the promotion | ||||||
| lead2doc_inst | OTM | doc_inst | doc_inst2lead | Attachments for the lead | ||||||
| lead2lead_extn | OTM | lead_extn | lead_extn2lead | Extension fields for the lead object | ||||||
| lead2lead_source | MTO | lead_source | source2lead | Lead source which generated the lead | Search (1) | |||||
| lead2lit_ship_req | OTM | lit_ship_req | lit_ship_req2lead | Related literature shipment request | ||||||
| lead2mod_level | MTM | mod_level | mod_level2lead | Part interest for the lead | mtm_mod_level50_ lead15 | Search (1) | ||||
| lead2part_num | MTM | part_num | part_num2lead | Part interest for the lead. Reserved; obsolete. Replaced by lead2mod_level | mtm_part_num6_ lead10 | |||||
| lead2proc_inst | OTM | proc_inst | proc_inst2lead | Process/script run conacted to a lead | ||||||
| lead2scr_run | OTM | scr_run | scr_run2lead | Call script runs for the lead | ||||||
| lead2task | OTM | task | task2lead | Action items for the lead | ||||||
| lead_orig2user | MTO | user | lead_orig2lead | User who created the lead | ||||||
| lead_owner2user | MTO | user | lead_owner2lead | User who currently owns the lead | Search (1) | |||||
| lead_modifier2user | MTO | user | lead_modifier2lead | User who last modified the lead | ||||||
| lead2user_touch | OTM | user_touch | user_touch2lead | Last user touches for the lead | touched_by | source_type | source_lowid | |||
| lead2web_user | OTM | web_user | web_user2lead | Web_users for the lead. Available for custom use | ||||||
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_lead_city | city, lead_owner2user | nonclustered located on PRIMARY |
| ind_lead_first_name | first_name, last_name, lead_owner2user | nonclustered located on PRIMARY |
| ind_lead_last_name | last_name, first_name, lead_owner2user | nonclustered located on PRIMARY |
| ind_lead_phone | phone, lead_owner2user | nonclustered located on PRIMARY |
| ind_lead2contact_role | lead2contact_role, lead_owner2user | nonclustered located on PRIMARY |
| lo2u5208 | lead2lead_source, lead_owner2user | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| ph5312 | phone | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5324 | lead_view | lead, lead_source, user |
| 5359 | sfa_tsk_mto_v | bus_org, contact, lead, lit_req, opportunity, task |
| 5487 | sfa_busled_v | bus_led_role, bus_org, lead |
| 5502 | lead_part_num_view | lead, mod_level, part_num |
| lead | |||