select supcust_no,supcust_flag,sup_name,region_no,sup_type,sup_man,sup_addr,zip,sup_email,sup_tel,sup_fax,sup_acct_back,sup_acct_no,sup_tax_no,display_flag,check_out_flag,check_out_date,check_out_day,credit_amt,other1,other2,other3,sub_no,pay_flag,order_flag,purchase_day,po_cycle,acc_level,reg_type,oper_id,purchase_week,sale_way,shopcard,modify_date,settle_branch,com_flag,mobile,sup_ly_amt,cust_clsno from #SDB..t_bd_supcust_info