SELECT orders_id FROM fhlmc_bpo_rpt WHERE orders_id = #form.orders_id# ; INSERT INTO fhlmc_bpo_rpt( orders_id, bpo_id, bpo_type_cd, bpo_dt, ext_curb_side, insp_date, int_insp, int_denied, int_denied_reason, cur_listed, listing_info, listing_phone, prpty_type, condo_assn_fee, occupant_type, int_painting_val, int_structual_val, int_appliances_val, int_utilities_val, int_carpet_floors_val, int_other_val, int_cleaning_val, ext_painting_val, ext_structual_val, ext_landscaping_val, ext_roof_val, ext_windows_val, ext_other_val, recommed_repairs_cd, repair_tot_val, overall_prpty_cond_cd, imm_action_cd, title_issues_cd, environ_issues_cd, explain_issues, neigh_prpty_val_cd, neigh_occ_cd, neigh_mkt_time_cd, neigh_vac_rate_cd, neigh_active_list, neigh_active_from, neigh_active_to, neigh_comments, asis_90_val, asis_120_val, asis_180_val, asrep_90_val, asrep_120_val, asrep_180_val, prpty_listed_as_cd, anticipated_seller_cost, bpo_comments, prepared_by, prepared_by_date, comp_list_comments, sales_list_comments, upd_id, upd_dtm) VALUES( #form.orders_id#, #variables.rtn_id#, '#form.bpo_type_cd#', '#DateFormat(variables.createdate,"mm/dd/yyyy")#', #variables.ext_curb_side#, '#form.insp_date#', #variables.int_insp#, #variables.int_denied#, '#form.int_denied_reason#', #variables.cur_listed#, '#form.listing_info#', '#form.listing_phone#', #variables.prpty_type#, '#form.condo_assn_fee#', #variables.occupant_type#, '#form.int_painting_val#', '#form.int_structual_val#', '#form.int_appliances_val#', '#form.int_utilities_val#', '#form.int_carpet_floors_val#', '#form.int_other_val#', '#form.int_cleaning_val#', '#form.ext_painting_val#', '#form.ext_structual_val#', '#form.ext_landscaping_val#', '#form.ext_roof_val#', '#form.ext_windows_val#', '#form.ext_other_val#', #variables.recommed_repairs_cd#, '#form.repair_tot_val#', #variables.overall_prpty_cond_cd#, #variables.imm_action_cd#, #variables.title_issues_cd#, #variables.environ_issues_cd#, '#form.explain_issues#', #variables.neigh_prpty_val_cd#, #variables.neigh_occ_cd#, #variables.neigh_mkt_time_cd#, #variables.neigh_vac_rate_cd#, '#form.neigh_active_list#', '#form.neigh_active_from#', '#form.neigh_active_to#', '#form.neigh_comments#', '#form.asis_90_val#', '#form.asis_120_val#', '#form.asis_180_val#', '#form.asrep_90_val#', '#form.asrep_120_val#', '#form.asrep_180_val#', #variables.prpty_listed_as_cd#, '#form.anticipated_seller_cost#', '#form.bpo_comments#', '#form.comp_by_agent#', '#form.prepared_by_date#', '#form.comp_list_comments#', '#form.sales_list_comments#', '#client.user_id#', #variables.createdate#) ; UPDATE orders SET ord_comp_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' SET fr_report_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' WHERE orders_id = #form.orders_id# ; INSERT INTO fhlmc_comp_sales_list( csl_id, orders_id, csl_type_cd, csl_type_col_no, csl_addr, csl_proximity, csl_cur_list_price, csl_cur_list_date, csl_orig_list_price, csl_orig_list_date, csl_total_rooms, csl_bdrm, csl_baths, csl_sqft, csl_location, csl_location_adj, csl_lot_size, csl_lot_size_adj, csl_design, csl_design_adj, csl_age, csl_age_adj, csl_overall_cond, csl_overall_cond_adj, csl_garage, csl_garage_adj, csl_porch, csl_porch_adj, csl_overall_rate, csl_overall_rate_adj, csl_prpty_most, csl_days_on_mkt, csl_sales_fin, csl_sales_fin_adj, csl_landscaping, csl_landscaping_adj, csl_list_when_sold, csl_sales_price, csl_sales_date, upd_id, upd_dtm) VALUES (#variables.rtn_id#, #form.orders_id#, '1', 1, '#form.sub_address#', 'SUBJECT', '#form.sub_cur_list_price#', '#form.sub_cur_list_date#', '#form.sub_orig_list_price#', '#form.sub_orig_list_date#', '#form.sub_total_rooms#', '#form.sub_bdrm#', '#form.sub_baths#', '#form.sub_sqft#', '#form.sub_location#', '', '#form.sub_lot_size#', '', '#form.sub_design#', '', '#form.sub_age#', '', '#form.sub_overall_cond#', '', '#form.sub_garage#', '', '#form.sub_porch#', '', '#form.sub_overall_rate#', '', 0, '#form.lsub_days_on_mkt#', '#form.lsub_sales_fin#', '', '#form.lsub_landscaping#', '', '#form.lsub_list_when_sold#', '#form.lsub_sales_price#', '#form.lsub_sales_date#', '#client.user_id#', #variables.createdate#) ; INSERT INTO fhlmc_comp_sales_list( csl_id, orders_id, csl_type_cd, csl_type_col_no, csl_addr, csl_proximity, csl_orig_list_price, csl_list_when_sold, csl_sales_price, csl_sales_date, csl_cur_list_price, csl_cur_list_date, csl_orig_list_date, csl_total_rooms, csl_bdrm, csl_baths, csl_sqft, csl_location, csl_location_adj, csl_lot_size, csl_lot_size_adj, csl_design, csl_design_adj, csl_age, csl_age_adj, csl_overall_cond, csl_overall_cond_adj, csl_garage, csl_garage_adj, csl_porch, csl_porch_adj, csl_overall_rate, csl_overall_rate_adj, csl_prpty_most, csl_days_on_mkt, csl_sales_fin, csl_sales_fin_adj, csl_landscaping, csl_landscaping_adj, upd_id, upd_dtm) VALUES (#variables.rtn_id#, #form.orders_id#, '#cd_idx#', #col_idx#, '#evaluate("form.#coltype##col_idx#_#coldesc#address")#', '#evaluate("form.#coltype##col_idx#_#coldesc#proximity_to")#', '#evaluate("form.#coltype##col_idx#_#coldesc#orig_list_price")#', '#evaluate("form.#coltype##col_idx#_#coldesc#list_when_sold")#', '#evaluate("form.#coltype##col_idx#_#coldesc#sales_price")#', '#evaluate("form.#coltype##col_idx#_#coldesc#sales_date")#', '#evaluate("form.#coltype##col_idx#_#coldesc#cur_list_price")#', '#evaluate("form.#coltype##col_idx#_#coldesc#cur_list_date")#', '#evaluate("form.#coltype##col_idx#_#coldesc#orig_list_date")#', '#evaluate("form.#coltype##col_idx#_#coldesc#total_rooms")#', '#evaluate("form.#coltype##col_idx#_#coldesc#bdrm")#', '#evaluate("form.#coltype##col_idx#_#coldesc#baths")#', '#evaluate("form.#coltype##col_idx#_#coldesc#sqft")#', '#evaluate("form.#coltype##col_idx#_#coldesc#location")#', '#evaluate("form.#coltype##col_idx#_#coldesc#location_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#lot_size")#', '#evaluate("form.#coltype##col_idx#_#coldesc#lot_size_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#design")#', '#evaluate("form.#coltype##col_idx#_#coldesc#design_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#age")#', '#evaluate("form.#coltype##col_idx#_#coldesc#age_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#overall_cond")#', '#evaluate("form.#coltype##col_idx#_#coldesc#overall_cond_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#garage")#', '#evaluate("form.#coltype##col_idx#_#coldesc#garage_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#porch")#', '#evaluate("form.#coltype##col_idx#_#coldesc#porch_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#overall_rate")#', '#evaluate("form.#coltype##col_idx#_#coldesc#overall_rate_adj")#', #variables.prpty_most#, '#evaluate("form.#coltype##col_idx#_#coldesc#days_on_mkt")#', '#evaluate("form.#coltype##col_idx#_#coldesc#sales_fin")#', '#evaluate("form.#coltype##col_idx#_#coldesc#sales_fin_adj")#', '#evaluate("form.#coltype##col_idx#_#coldesc#landscaping")#', '#evaluate("form.#coltype##col_idx#_#coldesc#landscaping_adj")#', '#client.user_id#', #variables.createdate#) ; UPDATE fhlmc_bpo_rpt SET ext_curb_side = #variables.ext_curb_side#, insp_date = '#form.insp_date#', int_insp = #variables.int_insp#, int_denied = #variables.int_denied#, int_denied_reason = '#form.int_denied_reason#', cur_listed = #variables.cur_listed#, listing_info = '#form.listing_info#', listing_phone = '#form.listing_phone#', prpty_type = #variables.prpty_type#, condo_assn_fee ='#form.condo_assn_fee#', occupant_type = #variables.occupant_type#, int_painting_val = '#form.int_painting_val#', int_structual_val = '#form.int_structual_val#', int_appliances_val = '#form.int_appliances_val#', int_utilities_val = '#form.int_utilities_val#', int_carpet_floors_val = '#form.int_carpet_floors_val#', int_other_val = '#form.int_other_val#', int_cleaning_val = '#form.int_cleaning_val#', ext_painting_val = '#form.ext_painting_val#', ext_structual_val = '#form.ext_structual_val#', ext_landscaping_val = '#form.ext_landscaping_val#', ext_roof_val = '#form.ext_roof_val#', ext_windows_val = '#form.ext_windows_val#', ext_other_val = '#form.ext_other_val#', recommed_repairs_cd = #variables.recommed_repairs_cd#, repair_tot_val = '#form.repair_tot_val#', overall_prpty_cond_cd = #variables.overall_prpty_cond_cd#, imm_action_cd = #variables.imm_action_cd#, title_issues_cd = #variables.title_issues_cd#, environ_issues_cd = #variables.environ_issues_cd#, explain_issues = '#form.explain_issues#', neigh_prpty_val_cd = #variables.neigh_prpty_val_cd#, neigh_occ_cd = #variables.neigh_occ_cd#, neigh_mkt_time_cd = #variables.neigh_mkt_time_cd#, neigh_vac_rate_cd = #variables.neigh_vac_rate_cd#, neigh_active_list = '#form.neigh_active_list#', neigh_active_from = '#form.neigh_active_from#', neigh_active_to = '#form.neigh_active_to#', neigh_comments = '#form.neigh_comments#', asis_90_val = '#form.asis_90_val#', asis_120_val = '#form.asis_120_val#', asis_180_val = '#form.asis_180_val#', asrep_90_val = '#form.asrep_90_val#', asrep_120_val = '#form.asrep_120_val#', asrep_180_val = '#form.asrep_180_val#', prpty_listed_as_cd = #variables.prpty_listed_as_cd#, anticipated_seller_cost = '#form.anticipated_seller_cost#', bpo_comments = '#form.bpo_comments#', prepared_by = '#form.comp_by_agent#', prepared_by_date = '#form.prepared_by_date#', comp_list_comments = '#form.comp_list_comments#', sales_list_comments = '#form.sales_list_comments#', upd_id = '#client.user_id#', upd_dtm = #variables.createdate# WHERE orders_id = #form.orders_id# ; UPDATE orders SET ord_comp_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' SET fr_report_dt = '#dateFormat(variables.createdate,"mm/dd/yyyy")#' WHERE orders_id = #form.orders_id# ; UPDATE fhlmc_comp_sales_list SET csl_addr = '#form.sub_address#', csl_cur_list_price = '#form.sub_cur_list_price#', csl_cur_list_date = '#form.sub_cur_list_date#', csl_orig_list_price = '#form.sub_orig_list_price#', csl_orig_list_date = '#form.sub_orig_list_date#', csl_total_rooms = '#form.sub_total_rooms#', csl_bdrm = '#form.sub_bdrm#', csl_baths = '#form.sub_baths#', csl_sqft = '#form.sub_sqft#', csl_location = '#form.sub_location#', csl_lot_size = '#form.sub_lot_size#', csl_design = '#form.sub_design#', csl_age = '#form.sub_age#', csl_overall_cond = '#form.sub_overall_cond#', csl_garage = '#form.sub_garage#', csl_porch = '#form.sub_porch#', csl_overall_rate = '#form.sub_overall_rate#', csl_days_on_mkt = '#form.lsub_days_on_mkt#', csl_sales_fin = '#form.lsub_sales_fin#', csl_landscaping = '#form.lsub_landscaping#', csl_list_when_sold = '#form.lsub_list_when_sold#', csl_sales_price = '#form.lsub_sales_price#', csl_sales_date = '#form.lsub_sales_date#', upd_id = '#client.user_id#', upd_dtm = #variables.createdate# WHERE csl_id = #form.sub_csl_id# ; UPDATE fhlmc_comp_sales_list SET csl_addr = '#evaluate("form.#coltype##col_idx#_#coldesc#address")#', csl_proximity = '#evaluate("form.#coltype##col_idx#_#coldesc#proximity_to")#', csl_orig_list_price = '#evaluate("form.#coltype##col_idx#_#coldesc#orig_list_price")#', csl_total_rooms = '#evaluate("form.#coltype##col_idx#_#coldesc#total_rooms")#', csl_bdrm = '#evaluate("form.#coltype##col_idx#_#coldesc#bdrm")#', csl_baths = '#evaluate("form.#coltype##col_idx#_#coldesc#baths")#', csl_sqft = '#evaluate("form.#coltype##col_idx#_#coldesc#sqft")#', csl_location = '#evaluate("form.#coltype##col_idx#_#coldesc#location")#', csl_location_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#location_adj")#', csl_lot_size = '#evaluate("form.#coltype##col_idx#_#coldesc#lot_size")#', csl_lot_size_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#lot_size_adj")#', csl_design = '#evaluate("form.#coltype##col_idx#_#coldesc#design")#', csl_design_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#design_adj")#', csl_age = '#evaluate("form.#coltype##col_idx#_#coldesc#age")#', csl_age_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#age_adj")#', csl_overall_cond = '#evaluate("form.#coltype##col_idx#_#coldesc#overall_cond")#', csl_overall_cond_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#overall_cond_adj")#', csl_garage = '#evaluate("form.#coltype##col_idx#_#coldesc#garage")#', csl_garage_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#garage_adj")#', csl_porch = '#evaluate("form.#coltype##col_idx#_#coldesc#porch")#', csl_porch_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#porch_adj")#', csl_overall_rate = '#evaluate("form.#coltype##col_idx#_#coldesc#overall_rate")#', csl_overall_rate_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#overall_rate_adj")#', csl_prpty_most = #variables.prpty_most#, csl_days_on_mkt = '#evaluate("form.#coltype##col_idx#_#coldesc#days_on_mkt")#', csl_sales_fin = '#evaluate("form.#coltype##col_idx#_#coldesc#sales_fin")#', csl_sales_fin_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#sales_fin_adj")#', csl_landscaping = '#evaluate("form.#coltype##col_idx#_#coldesc#landscaping")#', csl_landscaping_adj = '#evaluate("form.#coltype##col_idx#_#coldesc#landscaping_adj")#', csl_list_when_sold = '#evaluate("form.#coltype##col_idx#_#coldesc#list_when_sold")#', csl_sales_price = '#evaluate("form.#coltype##col_idx#_#coldesc#sales_price")#', csl_sales_date = '#evaluate("form.#coltype##col_idx#_#coldesc#sales_date")#', csl_cur_list_price = '#evaluate("form.#coltype##col_idx#_#coldesc#cur_list_price")#', csl_cur_list_date = '#evaluate("form.#coltype##col_idx#_#coldesc#cur_list_date")#', csl_orig_list_date = '#evaluate("form.#coltype##col_idx#_#coldesc#orig_list_date")#', upd_id = '#client.user_id#', upd_dtm = #variables.createdate# WHERE csl_id = #evaluate("form.#coltype##col_idx#_csl_id")# ;