Field | Type | Null | Key | Default | Extra |
la_agent_id | text | | MUL | | |
la_agent_add_cell_area | text | YES | | NULL | |
la_agent_add_cell_exchange | text | YES | | NULL | |
la_agent_add_cell_ext | text | YES | | NULL | |
la_agent_add_cell_number | text | YES | | NULL | |
la_agent_add_city | text | YES | | NULL | |
la_agent_add_comments | text | YES | | NULL | |
la_agent_add_country | text | YES | | NULL | |
la_agent_add_direction | text | YES | | NULL | |
la_agent_add_direction_other | text | YES | | NULL | |
la_agent_add_email | text | YES | | NULL | |
la_agent_add_fax_area | text | YES | | NULL | |
la_agent_add_fax_exchange | text | YES | | NULL | |
la_agent_add_fax_ext | text | YES | | NULL | |
la_agent_add_fax_number | text | YES | | NULL | |
la_agent_add_land_area | text | YES | | NULL | |
la_agent_add_land_exchange | text | YES | | NULL | |
la_agent_add_land_ext | text | YES | | NULL | |
la_agent_add_land_number | text | YES | | NULL | |
la_agent_add_name | text | YES | | NULL | |
la_agent_add_number | text | YES | | NULL | |
la_agent_add_other_area | text | YES | | NULL | |
la_agent_add_other_exchange | text | YES | | NULL | |
la_agent_add_other_ext | text | YES | | NULL | |
la_agent_add_other_number | text | YES | | NULL | |
la_agent_add_pager_area | text | YES | | NULL | |
la_agent_add_pager_exchange | text | YES | | NULL | |
la_agent_add_pager_ext | text | YES | | NULL | |
la_agent_add_pager_number | text | YES | | NULL | |
la_agent_add_state | text | YES | | NULL | |
la_agent_add_type | text | YES | | NULL | |
la_agent_add_type_other | text | YES | | NULL | |
la_agent_add_unit | text | YES | | NULL | |
la_agent_add_unit_number | text | YES | | NULL | |
la_agent_add_unit_other | text | YES | | NULL | |
la_agent_add_website | text | YES | | NULL | |
la_agent_add_zip1 | text | YES | | NULL | |
la_agent_add_zip2 | text | YES | | NULL | |
la_doc_received_date_day | tinyint(4) | YES | | NULL | |
la_doc_received_date_month | tinyint(4) | YES | | NULL | |
la_doc_received_date_year | int(11) | YES | | NULL | |
la_doc_walk_date_day | tinyint(4) | YES | | NULL | |
la_doc_walk_date_month | tinyint(4) | YES | | NULL | |
la_doc_walk_date_year | int(11) | YES | | NULL | |
la_leads_per_month | int(11) | YES | | NULL | |
la_pass_code | text | YES | | NULL | |
la_reload_amount | bigint(20) | YES | | NULL | |
la_ship_date_day | tinyint(4) | YES | | NULL | |
la_ship_date_month | tinyint(4) | YES | | NULL | |
la_ship_date_year | int(11) | YES | | NULL | |
la_what_bought | text | YES | | NULL | |
la_what_reloaded | text | YES | | NULL | |
la_purchase_promise_details | text | YES | | NULL | |
la_agent_add_city_code | int(11) | YES | | NULL | |
la_agent_add_country_code | int(11) | YES | | NULL | |
la_name_prefix | text | YES | | NULL | |
la_name_first | text | YES | | NULL | |
la_name_middle | text | YES | | NULL | |
la_name_last | text | YES | | NULL | |
la_name_suffix | text | YES | | NULL | |
la_leads_remaining_this_month | bigint(20) | YES | | NULL | |
la_purchase_date_day | tinyint(3) unsigned | YES | | NULL | |
la_purchase_date_month | tinyint(3) unsigned | YES | | NULL | |
la_leads_date_fulfilled_day | tinyint(3) unsigned | YES | | NULL | |
la_leads_date_fulfilled_mo | tinyint(3) unsigned | YES | | NULL | |
la_leads_date_received_day | tinyint(3) unsigned | YES | | NULL | |
la_leads_date_received_mo | tinyint(3) unsigned | YES | | NULL | |
la_leads_date_shipped_day | tinyint(3) unsigned | YES | | NULL | |
la_leads_date_shipped_mo | tinyint(3) unsigned | YES | | NULL | |
la_train_date_fulfilled_day | tinyint(3) unsigned | YES | | NULL | |
la_train_date_fulfilled_mo | tinyint(3) unsigned | YES | | NULL | |
la_train_date_received_day | tinyint(3) unsigned | YES | | NULL | |
la_train_date_received_mo | tinyint(3) unsigned | YES | | NULL | |
la_train_date_shipped_day | tinyint(3) unsigned | YES | | NULL | |
la_train_date_shipped_mo | tinyint(3) unsigned | YES | | NULL | |
la_web_date_fulfilled_day | tinyint(3) unsigned | YES | | NULL | |
la_web_date_fulfilled_mo | tinyint(3) unsigned | YES | | NULL | |
la_web_date_received_day | tinyint(3) unsigned | YES | | NULL | |
la_web_date_received_mo | tinyint(3) unsigned | YES | | NULL | |
la_web_date_shipped_day | tinyint(3) unsigned | YES | | NULL | |
la_web_date_shipped_mo | tinyint(3) unsigned | YES | | NULL | |
la_web_date_shipped_year | int(10) unsigned | YES | | NULL | |
la_web_date_received_year | int(10) unsigned | YES | | NULL | |
la_web_date_fulfilled_year | int(10) unsigned | YES | | NULL | |
la_train_date_shipped_year | int(10) unsigned | YES | | NULL | |
la_train_date_received_year | int(10) unsigned | YES | | NULL | |
la_train_date_fulfilled_year | int(10) unsigned | YES | | NULL | |
la_leads_date_shipped_year | int(10) unsigned | YES | | NULL | |
la_leads_date_received_year | int(10) unsigned | YES | | NULL | |
la_leads_date_fulfilled_year | int(10) unsigned | YES | | NULL | |
la_purchase_date_year | int(10) unsigned | YES | | NULL | |
la_leads_qty | bigint(20) unsigned | YES | | NULL | |
la_train_qty | bigint(20) unsigned | YES | | NULL | |
la_web_qty | bigint(20) unsigned | YES | | NULL | |
la_web_dollars | bigint(20) unsigned | YES | | NULL | |
la_train_dollars | bigint(20) unsigned | YES | | NULL | |
la_leads_dollars | bigint(20) unsigned | YES | | NULL | |
la_best_time1_hour | tinyint(3) unsigned | YES | | NULL | |
la_best_time1_minute | tinyint(3) unsigned | YES | | NULL | |
la_best_time2_hour | tinyint(3) unsigned | YES | | NULL | |
la_best_time2_minute | tinyint(3) unsigned | YES | | NULL | |
la_type_leads_plan | text | YES | | NULL | |
la_participating_agent | text | YES | | NULL | |
la_best_day_mon | text | YES | | NULL | |
la_best_day_tue | text | YES | | NULL | |
la_best_day_wed | text | YES | | NULL | |
la_best_day_thu | text | YES | | NULL | |
la_best_day_fri | text | YES | | NULL | |
la_best_day_sat | text | YES | | NULL | |
la_best_day_sun | text | YES | | NULL | |
la_best_time1_ampm | text | YES | | NULL | |
la_best_time2_ampm | text | YES | | NULL | |
la_best_time_comments | text | YES | | NULL | |
la_eps_agent_id_num | text | YES | | NULL | |
la_who_walked_thru_docs | text | YES | | NULL | |
la_web_fulfilment | text | YES | | NULL | |
la_web_tracking_no | text | YES | | NULL | |
la_train_fulfilment | text | YES | | NULL | |
la_train_tracking_no | text | YES | | NULL | |
la_leads_fulfilment | text | YES | | NULL | |
la_leads_tracking_no | text | YES | | NULL | |
la_leads_leads_type | text | YES | | NULL | |
la_sales_rep_name | int(10) unsigned | | | 0 | |
la_bad_passwords_entered | int(11) | | | 0 | |
la_bad_passwords_allowed | int(11) | | | 0 | |
la_front_end_purchase | decimal(12,2) | | | 0.00 | |