805184e8-d158-4212-b5af-9559baa5c3ba KCRW 2. Preneur/Prospect - Contrat - Objet de risque - Garanties NEW BSR P Tabular true juPe SELECT DISTINCT (select case when convert(varchar(7),party.dossier) <> '0' and convert(varchar(2),party.sub_dossier) <> '' then convert(varchar(7),party.dossier) + "/" + Right ( '00' + convert(varchar(2),party.sub_dossier) , 2) else '' end from party where p_party = v_takerSeR_11.p_party) as C1, v_takerSeR_11.firstnm as C2, v_takerSeR_11.lastnm as C3, v_takerSeR_11.street as C4, v_takerSeR_11.house_no as C5, v_takerSeR_11.box_no as C6, v_takerSeR_11.zip as C7, v_takerSeR_11.city as C8, v_takerSeR_11.c_country as C60, v_takerSeR_11.c_country as C61, v_takerSeR_11.phone_1 as C9, v_takerSeR_11.phone_2 as C10, v_takerSeR_11.phone_3 as C46, v_takerSeR_11.elctrnc_mail as C11, v_takerSeR_11.bank_account as C12, v_takerSeR_11.vat_no as C13, v_takerSeR_11.c_social_statute as C14, v_takerSeR_11.c_fiscal_statute as C15, (select user_name from sys_users a where a.user_id = v_takerSeR_11.manager_id) as C16, v_takerSeR_11.c_send_docmnt as C17, v_takerSeR_11.c_portfl as C18, v_takerSeR_11.c_office as C19, v_takerSeR_11.c_alarm as C20, v_takerSeR_11.d_birth as C21, v_takerSeR_11.c_civil_statute as C22, v_takerSeR_11.c_sex as C23, v_takerSeR_11.revenue_amount as C24, v_takerSeR_11.c_profssn as C25, (select c_licence from v_licence_max where v_licence_max.p_party = v_takerSeR_11.p_party) as C26, v_takerSeR_11.d_licence as C27, ((case when exists (select 1 from doc_blob_desc, bac, par_type WHERE doc_blob_desc.p_doc_blob = bac.p_doc_blob AND bac.p_party_taker = par_type.p_party AND doc_blob_desc.c_doc_type = '006' AND bac.c_doc_origin = '1' AND par_type.p_par_type = v_takerSeR_11.p_par_type ) Then '1'Else '2'End)) as C28, v_takerSeR_11.c_physcl_moral as C29, v_takerSeR_11.c_physcl_moral as C30, v_takerSeR_11.c_title as C31, v_takerSeR_11.c_title as C32, v_takerSeR_11.c_langg as C33, v_takerSeR_11.c_bank_account as C34, v_takerSeR_11.c_fiscal_sta_cmplt as C37, v_takerSeR_11.c_fiscal_sta_cmplt as C38, v_takerSeR_11.f_exprtn as C39, v_takerSeR_11.c_civil_statute as C40, v_takerSeR_11.c_civil_statute as C41, v_takerSeR_11.c_profssn as C42, v_takerSeR_11.c_profssn as C43, v_takerSeR_11.f_pers_pol_exposed as C44, v_takerSeR_11.eid_d_end_valid as C45, v_takerSeR_11.c_cash_term as C47, v_takerSeR_11.c_cash_term as C48, v_takerSeR_11.c_cash_compt as C49, v_takerSeR_11.c_cash_compt as C50, v_takerSeR_11.f_e_fact_refused as C51, v_takerSeR_11.elctrnc_mail_e_fact as C52, v_takerSeR_11.c_send_docmnt as C53, v_takerSeR_11.c_send_docmnt as C54, v_takerSeR_11.c_cash_in as C56, v_takerSeR_11.c_cash_in as C58, v_takerSeR_11.c_cash_in_compt as C57, v_takerSeR_11.c_cash_in_compt as C59, v_takerSeR_11.p_par_type as C62 FROM v_takerSeR_11 WHERE 1=1 (((( v_takerSeR_11.c_physcl_moral = '1') AND ( v_takerSeR_11.f_archivage = '2')) AND ( EXISTS (SELECT null FROM v_contract_21 WHERE (v_takerSeR_11.p_party=v_contract_21.p_party_taker) AND ((( v_contract_21.cc_state_contract = '0') AND ( v_contract_21.c_type_version = '2'))))) AND ( EXISTS (SELECT null FROM v_contract_21 WHERE (v_takerSeR_11.p_party=v_contract_21.p_party_taker) AND ((( v_contract_21.c_exprtn = '1') OR ( v_contract_21.c_exprtn = '9') OR ( v_contract_21.c_exprtn = '5'))))) AND ( v_takerSeR_11.p_par_type IS NOT NULL ))) <selection description="Liste avec des informations preneur/prospect ..."><criterias><group name="group_1" description="Preneur/Prospect" view_name="v_takerSeR_11" entity_id="11" context_id="KCRW" subcontext_id="" existance="" key_name="p_party" sql_from=""><criteria name="v_takerSeR_11.c_physcl_moral_29" column_name="v_takerSeR_11.c_physcl_moral" description="Physique/Morale - Libellé" tooltip="Physique/Morale - Libellé (.......)" operand="Est égal à " operand_code="=" value="1" datatype="System.String.Code" var_trt="C" table_no="56" MaxLength="1" Prompt="false" entity_id="11" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" aggregate="" aggregate_params="" scheduling="False" value_scheduling="" add_entity_id="" /><logical_operand>AND</logical_operand><criteria name="v_takerSeR_11.f_archivage_1" column_name="v_takerSeR_11.f_archivage" description="Archivage" tooltip="Archivage (.......)" operand="Est égal à " operand_code="=" value="2" datatype="System.String.Code" var_trt="C" table_no="912" MaxLength="55" Prompt="false" entity_id="11" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" aggregate="" aggregate_params="" scheduling="False" value_scheduling="" add_entity_id="" /><logical_operand name="logical_group_group_1">AND</logical_operand><group name="group_1" description="Contrat" view_name="v_contract_21" entity_id="21" context_id="KCRW" subcontext_id="" existance="" key_name="p_vcontract" sql_from="v_contract_21"><criteria name="v_contract_21.cc_state_contract_2" column_name="v_contract_21.cc_state_contract" description="Situation - Libellé" tooltip="Situation - Libellé (.......)" operand="Est égal à " operand_code="=" value="0" datatype="System.String.Code" var_trt="C" table_no="910" MaxLength="1" Prompt="false" entity_id="21" view_name="v_contract_21" context_id="KCRW" subcontext_id="" aggregate="" aggregate_params="" scheduling="False" value_scheduling="" add_entity_id="" /><logical_operand>AND</logical_operand><criteria name="v_contract_21.c_type_version_3" column_name="v_contract_21.c_type_version" description="Version - Libellé" tooltip="Version - Libellé (.......)" operand="Est égal à " operand_code="=" value="2" datatype="System.String.Code" var_trt="C" table_no="111" MaxLength="1" Prompt="false" entity_id="21" view_name="v_contract_21" context_id="KCRW" subcontext_id="" aggregate="" aggregate_params="" scheduling="False" value_scheduling="" add_entity_id="" /></group><logical_operand name="logical_group_group_2">AND</logical_operand><group name="group_2" description="Contrat" view_name="v_contract_21" entity_id="21" context_id="KCRW" subcontext_id="" existance="" key_name="p_vcontract" sql_from="v_contract_21"><criteria name="v_contract_21.c_exprtn_8" column_name="v_contract_21.c_exprtn" description="Etat contrat - Libellé" tooltip="Etat contrat - Libellé (.......)" operand="Est égal à " operand_code="=" value="1" datatype="System.String.Code" var_trt="C" table_no="114" MaxLength="1" Prompt="false" entity_id="21" view_name="v_contract_21" context_id="KCRW" subcontext_id="" aggregate="" aggregate_params="" scheduling="False" value_scheduling="" add_entity_id="" /><logical_operand>OR</logical_operand><criteria name="v_contract_21.c_exprtn_9" column_name="v_contract_21.c_exprtn" description="Etat contrat - Libellé" tooltip="Etat contrat - Libellé (.......)" operand="Est égal à " operand_code="=" value="9" datatype="System.String.Code" var_trt="C" table_no="114" MaxLength="1" Prompt="false" entity_id="21" view_name="v_contract_21" context_id="KCRW" subcontext_id="" aggregate="" aggregate_params="" scheduling="False" value_scheduling="" add_entity_id="" /><logical_operand>OR</logical_operand><criteria name="v_contract_21.c_exprtn_10" column_name="v_contract_21.c_exprtn" description="Etat contrat - Libellé" tooltip="Etat contrat - Libellé (.......)" operand="Est égal à " operand_code="=" value="5" datatype="System.String.Code" var_trt="C" table_no="114" MaxLength="1" Prompt="false" entity_id="21" view_name="v_contract_21" context_id="KCRW" subcontext_id="" aggregate="" aggregate_params="" scheduling="False" value_scheduling="" add_entity_id="" /></group><logical_operand>AND</logical_operand><criteria name="v_takerSeR_11.p_par_type_1" column_name="v_takerSeR_11.p_par_type" description="PT_p_par_type" tooltip="PT_p_par_type (.......)" operand="Est complété" operand_code="IS NOT NULL" value="" datatype="System.Int32" var_trt="N" table_no="0" MaxLength="4" Prompt="false" entity_id="11" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" aggregate="" aggregate_params="" scheduling="False" value_scheduling="" add_entity_id="" /></group></criterias><fields><field column_id="v_takerSeR_11.p_party_1" column_name="v_takerSeR_11.p_party" column_description="Dossier" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.firstnm_2" column_name="v_takerSeR_11.firstnm" column_description="Prénom" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.lastnm_3" column_name="v_takerSeR_11.lastnm" column_description="Nom" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.street_4" column_name="v_takerSeR_11.street" column_description="Rue" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.house_no_5" column_name="v_takerSeR_11.house_no" column_description="No rue" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.box_no_6" column_name="v_takerSeR_11.box_no" column_description="Boîte" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.zip_7" column_name="v_takerSeR_11.zip" column_description="Code postal" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.city_8" column_name="v_takerSeR_11.city" column_description="Localité" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.phone_1_9" column_name="v_takerSeR_11.phone_1" column_description="Téléphone 1" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.phone_2_10" column_name="v_takerSeR_11.phone_2" column_description="Téléphone 2" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.elctrnc_mail_11" column_name="v_takerSeR_11.elctrnc_mail" column_description="E-mail" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.bank_account_12" column_name="v_takerSeR_11.bank_account" column_description="Compte financier" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.vat_no_13" column_name="v_takerSeR_11.vat_no" column_description="Numéro TVA" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_social_statute_14" column_name="v_takerSeR_11.c_social_statute" column_description="Statut social - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_fiscal_statute_15" column_name="v_takerSeR_11.c_fiscal_statute" column_description="Statut fiscal - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.manager_id_16" column_name="v_takerSeR_11.manager_id" column_description="Gestionnaire (nom)" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_send_docmnt_17" column_name="v_takerSeR_11.c_send_docmnt" column_description="Mode communication - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_portfl_18" column_name="v_takerSeR_11.c_portfl" column_description="Portefeuille - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_office_19" column_name="v_takerSeR_11.c_office" column_description="Bureau - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_alarm_20" column_name="v_takerSeR_11.c_alarm" column_description="Alerte - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.d_birth_21" column_name="v_takerSeR_11.d_birth" column_description="Date de naissance" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_civil_statute_22" column_name="v_takerSeR_11.c_civil_statute" column_description="Etat civil - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_sex_23" column_name="v_takerSeR_11.c_sex" column_description="Sexe - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.revenue_amount_24" column_name="v_takerSeR_11.revenue_amount" column_description="Revenus" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_profssn_25" column_name="v_takerSeR_11.c_profssn" column_description="Profession - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.cc_licence_26" column_name="v_takerSeR_11.cc_licence" column_description="Type permis - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.d_licence_28" column_name="v_takerSeR_11.d_licence" column_description="Date validité du" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.p_par_type_1" column_name="v_takerSeR_11.p_par_type" column_description="Fiche client" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_physcl_moral_2" column_name="v_takerSeR_11.c_physcl_moral" column_description="Physique/Morale - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_physcl_moral_3" column_name="v_takerSeR_11.c_physcl_moral" column_description="Physique/Morale - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_title_4" column_name="v_takerSeR_11.c_title" column_description="Titre - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_title_5" column_name="v_takerSeR_11.c_title" column_description="Titre - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_langg_6" column_name="v_takerSeR_11.c_langg" column_description="Langue - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_bank_account_7" column_name="v_takerSeR_11.c_bank_account" column_description="Type de compte financier - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_fiscal_sta_cmplt_10" column_name="v_takerSeR_11.c_fiscal_sta_cmplt" column_description="Statut fiscal complémentaire - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_fiscal_sta_cmplt_11" column_name="v_takerSeR_11.c_fiscal_sta_cmplt" column_description="Statut fiscal complémentaire - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.f_exprtn_12" column_name="v_takerSeR_11.f_exprtn" column_description="Décédé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_civil_statute_13" column_name="v_takerSeR_11.c_civil_statute" column_description="Etat civil - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_civil_statute_14" column_name="v_takerSeR_11.c_civil_statute" column_description="Etat civil - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_profssn_15" column_name="v_takerSeR_11.c_profssn" column_description="Profession - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_profssn_16" column_name="v_takerSeR_11.c_profssn" column_description="Profession - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.f_pers_pol_exposed_4" column_name="v_takerSeR_11.f_pers_pol_exposed" column_description="Personne politiquement exposée" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.eid_d_end_valid_5" column_name="v_takerSeR_11.eid_d_end_valid" column_description="Carte identité valide au" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.phone_3_1" column_name="v_takerSeR_11.phone_3" column_description="Téléphone 3" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_cash_term_2" column_name="v_takerSeR_11.c_cash_term" column_description="Mode de facturation terme - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_cash_term_3" column_name="v_takerSeR_11.c_cash_term" column_description="Mode de facturation terme - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_cash_compt_4" column_name="v_takerSeR_11.c_cash_compt" column_description="Mode de facturation comptant - Valeur " entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_cash_compt_5" column_name="v_takerSeR_11.c_cash_compt" column_description="Mode de facturation comptant - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.f_e_fact_refused_6" column_name="v_takerSeR_11.f_e_fact_refused" column_description="Refus e-facturation" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.elctrnc_mail_e_fact_7" column_name="v_takerSeR_11.elctrnc_mail_e_fact" column_description="E-mail e-facturation" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_send_docmnt_1" column_name="v_takerSeR_11.c_send_docmnt" column_description="Mode communication - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_send_docmnt_2" column_name="v_takerSeR_11.c_send_docmnt" column_description="Mode communication - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_cash_in_4" column_name="v_takerSeR_11.c_cash_in" column_description="Encaissement terme - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_cash_in_compt_5" column_name="v_takerSeR_11.c_cash_in_compt" column_description="Encaissement comptant - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_cash_in_6" column_name="v_takerSeR_11.c_cash_in" column_description="Encaissement terme - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_cash_in_compt_7" column_name="v_takerSeR_11.c_cash_in_compt" column_description="Encaissement comptant - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_country_1" column_name="v_takerSeR_11.c_country" column_description="Pays - Valeur" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.c_country_2" column_name="v_takerSeR_11.c_country" column_description="Pays - Libellé" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /><field column_id="v_takerSeR_11.p_par_type_1" column_name="v_takerSeR_11.p_par_type" column_description="PT_p_par_type" entity_id="11" entity_description="Preneur/Prospect" view_name="v_takerSeR_11" context_id="KCRW" subcontext_id="" /></fields></selection> 0 2020-04-28T08:35:38.6253496+02:00 2020-04-28T08:35:38.6253496+02:00 juPe juPe DB52328 BEBRIO29_05 false 2020-04-28T06:00:00+02:00 W pdf 1 false 11 p_party Dossier Dossier 2 14 S System.String 20 11122 1 1 v_takerSeR_11.p_party_1 KCRW v_takerSeR_11 Preneur/Prospect select case when convert(varchar(7),party.dossier) <> '0' and convert(varchar(2),party.sub_dossier) <> '' then convert(varchar(7),party.dossier) + "/" + Right ( '00' + convert(varchar(2),party.sub_dossier) , 2) else '' end from party where p_party = v_takerSeR_11.p_party 3 C1 false 0 false false false false 11 firstnm Prénom Voornaam 2 0 N System.String 35 11008 2 2 v_takerSeR_11.firstnm_2 KCRW v_takerSeR_11 Preneur/Prospect 5.5 C2 false 0 false false false false 11 lastnm Nom Naam 2 0 N System.String 35 11007 3 3 v_takerSeR_11.lastnm_3 KCRW v_takerSeR_11 Preneur/Prospect 5.5 C3 false 0 false false false false 11 street Rue Straat 2 0 N System.String 30 11041 4 4 v_takerSeR_11.street_4 KCRW v_takerSeR_11 Preneur/Prospect 4.9 C4 false 0 false false false false 11 house_no No rue Huisnr 2 0 N System.String 5 11042 5 5 v_takerSeR_11.house_no_5 KCRW v_takerSeR_11 Preneur/Prospect 1.9 C5 false 0 false false false false 11 box_no Boîte Bus 2 0 N System.String 4 11043 6 6 v_takerSeR_11.box_no_6 KCRW v_takerSeR_11 Preneur/Prospect 1.8 C6 false 0 false false false false 11 zip Code postal Postcode 2 0 N System.String 10 11046 7 7 v_takerSeR_11.zip_7 KCRW v_takerSeR_11 Preneur/Prospect 2.5 C7 false 0 false false false false 11 city Localité Plaats 2 0 N System.String 40 11047 8 8 v_takerSeR_11.city_8 KCRW v_takerSeR_11 Preneur/Prospect 6.1 C8 false 0 false false false false 11 phone_1 Téléphone 1 Telefoon 1 2 0 N System.String 35 11019 11 11 v_takerSeR_11.phone_1_9 KCRW v_takerSeR_11 Preneur/Prospect 5.5 C9 false 0 false false false false 11 phone_2 Téléphone 2 Telefoon 2 2 0 N System.String 35 11022 12 12 v_takerSeR_11.phone_2_10 KCRW v_takerSeR_11 Preneur/Prospect 5.5 C10 false 0 false false false false 11 elctrnc_mail E-mail E-mail 2 0 N System.String 70 11037 14 14 v_takerSeR_11.elctrnc_mail_11 KCRW v_takerSeR_11 Preneur/Prospect 9.7 C11 false 0 false false false false 11 bank_account Compte financier Financiële rekening 2 0 N System.String 37 11031 15 15 v_takerSeR_11.bank_account_12 KCRW v_takerSeR_11 Preneur/Prospect 5.7 C12 false 0 false false false false 11 vat_no Numéro TVA BTW-nummer 2 0 N System.String 35 11032 16 16 v_takerSeR_11.vat_no_13 KCRW v_takerSeR_11 Preneur/Prospect 5.5 C13 false 0 false false false false 11 c_social_statute Statut social - Libellé Sociaal statuut - Omschrijving 2 13 C System.String.Code 2 11121 17 17 v_takerSeR_11.c_social_statute_14 KCRW v_takerSeR_11 Preneur/Prospect 3 C14 false 0 false false false false 11 c_fiscal_statute Statut fiscal - Libellé Fiscaal statuut - Omschrijving 2 71 C System.String.Code 2 11142 18 18 v_takerSeR_11.c_fiscal_statute_15 KCRW v_takerSeR_11 Preneur/Prospect 3 C15 false 0 false false false false 11 manager_id Gestionnaire (nom) Naam beheerder 2 9 S System.String 4 11105 19 19 v_takerSeR_11.manager_id_16 KCRW v_takerSeR_11 Preneur/Prospect select user_name from sys_users a where a.user_id = v_takerSeR_11.manager_id 3 C16 false 0 false false false false 11 c_send_docmnt Mode communication - Libellé Communicatie middel - Omschrijving 2 449 C System.String.Code 2 11034 20 20 v_takerSeR_11.c_send_docmnt_17 KCRW v_takerSeR_11 Preneur/Prospect 3 C17 false 0 false false false false 11 c_portfl Portefeuille - Libellé Portefeuille - Omschrijving 2 17 C System.String.Code 4 11081 21 21 v_takerSeR_11.c_portfl_18 KCRW v_takerSeR_11 Preneur/Prospect 3 C18 false 0 false false false false 11 c_office Bureau - Libellé Kantoor - Omschrijving 2 59 C System.String.Code 4 11083 22 22 v_takerSeR_11.c_office_19 KCRW v_takerSeR_11 Preneur/Prospect 3 C19 false 0 false false false false 11 c_alarm Alerte - Libellé Alarm - Omschrijving 2 12 C System.String.Code 1 11114 23 23 v_takerSeR_11.c_alarm_20 KCRW v_takerSeR_11 Preneur/Prospect 3 C20 false 0 false false false false 11 d_birth Date de naissance Geboortedatum 2 0 N System.DateTime 8 11063 24 24 v_takerSeR_11.d_birth_21 KCRW v_takerSeR_11 Preneur/Prospect 2 C21 false 0 false false false false 11 c_civil_statute Etat civil - Libellé Burgelijke staat - Omschrijving 2 37 C System.String.Code 1 11068 25 25 v_takerSeR_11.c_civil_statute_22 KCRW v_takerSeR_11 Preneur/Prospect 3 C22 false 0 false false false false 11 c_sex Sexe - Libellé Geslacht - Omschrijving 2 36 C System.String.Code 1 11066 26 26 v_takerSeR_11.c_sex_23 KCRW v_takerSeR_11 Preneur/Prospect 3 C23 false 0 false false false false 11 revenue_amount Revenus Inkomsten 2 0 N System.Double 8 11071 27 27 v_takerSeR_11.revenue_amount_24 KCRW v_takerSeR_11 Preneur/Prospect N2 2 C24 false 0 false false false false 11 c_profssn Profession - Libellé Beroep - Omschrijving 2 38 C System.String.Code 500 11070 28 28 v_takerSeR_11.c_profssn_25 KCRW v_takerSeR_11 Preneur/Prospect 3 C25 false 0 false false false false 11 cc_licence Type permis - Libellé Soort rijbewijs - Omschrijving 2 41 C System.String.Code 5 706649 29 29 v_takerSeR_11.cc_licence_26 KCRW v_takerSeR_11 Preneur/Prospect select c_licence from v_licence_max where v_licence_max.p_party = v_takerSeR_11.p_party 3 C26 false 0 false false false false 11 d_licence Date validité du Geldigheid van 2 0 N System.DateTime 8 11107 30 30 v_takerSeR_11.d_licence_28 KCRW v_takerSeR_11 Preneur/Prospect 2 C27 false 0 false false false false 11 p_par_type Fiche client Klantenfiche 2 912 C System.String.Code 1 70629 31 31 v_takerSeR_11.p_par_type_1 KCRW v_takerSeR_11 Preneur/Prospect (case when exists (select 1 from doc_blob_desc, bac, par_type WHERE doc_blob_desc.p_doc_blob = bac.p_doc_blob AND bac.p_party_taker = par_type.p_party AND doc_blob_desc.c_doc_type = '006' AND bac.c_doc_origin = '1' AND par_type.p_par_type = v_takerSeR_11.p_par_type ) Then '1'Else '2'End) 3 C28 false 0 false false false false 11 c_physcl_moral Physique/Morale - Valeur Natuurlijk/Rechtsp - Waarde 2 0 N System.String 1 11013 32 32 v_takerSeR_11.c_physcl_moral_2 KCRW v_takerSeR_11 Preneur/Prospect 1.4 C29 false 0 false false false false 11 c_physcl_moral Physique/Morale - Libellé Natuurlijk/Rechtsp - Omschrijving 2 56 C System.String.Code 1 11014 33 33 v_takerSeR_11.c_physcl_moral_3 KCRW v_takerSeR_11 Preneur/Prospect 3 C30 false 0 false false false false 11 c_title Titre - Libellé Titel - Omschrijving 2 1 C System.String.Code 3 11011 34 34 v_takerSeR_11.c_title_4 KCRW v_takerSeR_11 Preneur/Prospect 3 C31 false 0 false false false false 11 c_title Titre - Valeur Titel - Waarde 2 0 N System.String 3 11010 37 37 v_takerSeR_11.c_title_5 KCRW v_takerSeR_11 Preneur/Prospect 1.6 C32 false 0 false false false false 11 c_langg Langue - Libellé Taal - Omschrijving 2 6 C System.String.Code 1 11018 38 38 v_takerSeR_11.c_langg_6 KCRW v_takerSeR_11 Preneur/Prospect 3 C33 false 0 false false false false 11 c_bank_account Type de compte financier - Libellé Soort financiële rekening - Omschrijving 2 198 C System.String.Code 2 700043 39 39 v_takerSeR_11.c_bank_account_7 KCRW v_takerSeR_11 Preneur/Prospect 3 C34 false 0 false false false false 11 c_fiscal_sta_cmplt Statut fiscal complémentaire - Libellé Aanvullend fiscaal statuut - Omschrijving 2 72 C System.String.Code 2 11144 40 40 v_takerSeR_11.c_fiscal_sta_cmplt_10 KCRW v_takerSeR_11 Preneur/Prospect 3 C37 false 0 false false false false 11 c_fiscal_sta_cmplt Statut fiscal complémentaire - Valeur Aanvullend fiscaal statuut - Waarde 2 0 N System.String 2 11143 41 41 v_takerSeR_11.c_fiscal_sta_cmplt_11 KCRW v_takerSeR_11 Preneur/Prospect 1.5 C38 false 0 false false false false 11 f_exprtn Décédé Overleden 2 912 C System.String.Code 8 706610 42 42 v_takerSeR_11.f_exprtn_12 KCRW v_takerSeR_11 Preneur/Prospect 3 C39 false 0 false false false false 11 c_civil_statute Etat civil - Libellé Burgelijke staat - Omschrijving 2 37 C System.String.Code 1 11068 43 43 v_takerSeR_11.c_civil_statute_13 KCRW v_takerSeR_11 Preneur/Prospect 3 C40 false 0 false false false false 11 c_civil_statute Etat civil - Valeur Burgelijke staat - Waarde 2 0 N System.String 1 11067 44 44 v_takerSeR_11.c_civil_statute_14 KCRW v_takerSeR_11 Preneur/Prospect 1.4 C41 false 0 false false false false 11 c_profssn Profession - Libellé Beroep - Omschrijving 2 38 C System.String.Code 500 11070 45 45 v_takerSeR_11.c_profssn_15 KCRW v_takerSeR_11 Preneur/Prospect 3 C42 false 0 false false false false 11 c_profssn Profession - Valeur Beroep - Waarde 2 0 N System.String 5 11069 46 46 v_takerSeR_11.c_profssn_16 KCRW v_takerSeR_11 Preneur/Prospect 1.9 C43 false 0 false false false false 11 f_pers_pol_exposed Personne politiquement exposée Politiek prominente persoon 2 912 C System.String.Code 55 707217 47 47 v_takerSeR_11.f_pers_pol_exposed_4 KCRW v_takerSeR_11 Preneur/Prospect 3 C44 false 0 false false false false 11 eid_d_end_valid Carte identité valide au Identiteitsk. geldig tot 2 0 N System.DateTime 8 700657 48 48 v_takerSeR_11.eid_d_end_valid_5 KCRW v_takerSeR_11 Preneur/Prospect 2 C45 false 0 false false false false 11 phone_3 Téléphone 3 Telefoon 3 2 0 N System.String 35 11025 13 13 v_takerSeR_11.phone_3_1 KCRW v_takerSeR_11 Preneur/Prospect 5.5 C46 false 0 false false false false 11 c_cash_term Mode de facturation terme - Valeur Facturatiewijze termijn - Waarde 2 0 N System.String 1 702447 49 49 v_takerSeR_11.c_cash_term_2 KCRW v_takerSeR_11 Preneur/Prospect 1.4 C47 false 0 false false false false 11 c_cash_term Mode de facturation terme - Libellé Facturatiewijze termijn - Omschrijving 2 423 C System.String.Code 1 702448 50 50 v_takerSeR_11.c_cash_term_3 KCRW v_takerSeR_11 Preneur/Prospect 3 C48 false 0 false false false false 11 c_cash_compt Mode de facturation comptant - Valeur Facturatiewijze contanten - Waarde 2 0 N System.String 1 702449 51 51 v_takerSeR_11.c_cash_compt_4 KCRW v_takerSeR_11 Preneur/Prospect 1.4 C49 false 0 false false false false 11 c_cash_compt Mode de facturation comptant - Libellé Facturatiewijze contanten - Omschrijving 2 423 C System.String.Code 1 702450 52 52 v_takerSeR_11.c_cash_compt_5 KCRW v_takerSeR_11 Preneur/Prospect 3 C50 false 0 false false false false 11 f_e_fact_refused Refus e-facturation Weigering e-facturatie 2 912 C System.String.Code 55 707673 53 53 v_takerSeR_11.f_e_fact_refused_6 KCRW v_takerSeR_11 Preneur/Prospect 3 C51 false 0 false false false false 11 elctrnc_mail_e_fact E-mail e-facturation E-mail e-facturatie 2 0 N System.String 70 707679 54 54 v_takerSeR_11.elctrnc_mail_e_fact_7 KCRW v_takerSeR_11 Preneur/Prospect 9.7 C52 false 0 false false false false 11 c_send_docmnt Mode communication - Valeur Communicatie middel - Waarde 2 0 N System.String 2 11033 55 55 v_takerSeR_11.c_send_docmnt_1 KCRW v_takerSeR_11 Preneur/Prospect 1.5 C53 false 0 false false false false 11 c_send_docmnt Mode communication - Libellé Communicatie middel - Omschrijving 2 449 C System.String.Code 2 11034 57 57 v_takerSeR_11.c_send_docmnt_2 KCRW v_takerSeR_11 Preneur/Prospect 3 C54 false 0 false false false false 11 c_cash_in Encaissement terme - Valeur Termijn-inningswijze - Waarde 2 0 N System.String 1 11158 58 58 v_takerSeR_11.c_cash_in_4 KCRW v_takerSeR_11 Preneur/Prospect 1.4 C56 false 0 false false false false 11 c_cash_in_compt Encaissement comptant - Libellé Contante-inningswijze - Omschrijving 2 9 C System.String.Code 1 11161 60 60 v_takerSeR_11.c_cash_in_compt_5 KCRW v_takerSeR_11 Preneur/Prospect 3 C57 false 0 false false false false 11 c_cash_in Encaissement terme - Libellé Termijn-inningswijze - Omschrijving 2 9 C System.String.Code 1 11159 59 59 v_takerSeR_11.c_cash_in_6 KCRW v_takerSeR_11 Preneur/Prospect 3 C58 false 0 false false false false 11 c_cash_in_compt Encaissement comptant - Valeur Contante-inningswijze - Waarde 2 0 N System.String 1 11160 61 61 v_takerSeR_11.c_cash_in_compt_7 KCRW v_takerSeR_11 Preneur/Prospect 1.4 C59 false 0 false false false false 11 c_country Pays - Valeur Land - Waarde 2 0 N System.String 3 11044 9 9 v_takerSeR_11.c_country_1 KCRW v_takerSeR_11 Preneur/Prospect 1.6 C60 false 0 false false false false 11 c_country Pays - Libellé Land - Omschrijving 2 34 C System.String.Code 3 11045 10 10 v_takerSeR_11.c_country_2 KCRW v_takerSeR_11 Preneur/Prospect 3 C61 false 0 false false false false 11 p_par_type PT_p_par_type PT_p_par_type 2 0 N System.Int32 4 703675 62 62 v_takerSeR_11.p_par_type_1 KCRW v_takerSeR_11 Preneur/Prospect 1.6 C62 false 0 false false false false