<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="06/20/2009 22:40:42" ReportInfo.Modified="12/31/2021 11:59:25" ReportInfo.CreatorVersion="2014.3.6.0">
  <Dictionary>
    <MsSqlDataConnection Name="Connection" ConnectionString="rijcmlqM7gJFg/iaLrqMhRfGy5lGrVuw6Tg04t8NUSLOzyta9CLRSistRieXYw6KSHADfSLIlw4bbPInuH0a2zGIwl+0r0XLsNhOsmW40ZKqETFtaw/GJFPhzLCpkflx4dCWDAGEUK6mO1YGVxGi1SxoABFw40R1MiEuSQ4Gfy/26PtfKFsDjF69fzr5aRsvsqOIy2BSlJIaefphassYCjZH3ZXFg==">
      <TableDataSource Name="LIGNE_EFFET" DataType="System.Int32" Enabled="true" TableName="LIGNE_EFFET">
        <Column Name="num_effet" DataType="System.String"/>
        <Column Name="num" DataType="System.Int32"/>
        <Column Name="id_article" DataType="System.Int32"/>
        <Column Name="reference" DataType="System.String"/>
        <Column Name="Designation" DataType="System.String"/>
        <Column Name="Quantite" DataType="System.Double"/>
        <Column Name="prix_u" DataType="System.Double"/>
        <Column Name="tva" DataType="System.Double"/>
        <Column Name="ris" DataType="System.Double"/>
        <Column Name="montant_ht" DataType="System.Double"/>
        <Column Name="marge" DataType="System.Double"/>
        <Column Name="pourcentage_marge" DataType="System.Double"/>
        <Column Name="Poids" DataType="System.Double"/>
        <Column Name="Carton" DataType="System.Double"/>
        <Column Name="UNITE" DataType="System.String"/>
        <Column Name="CodeBarre" DataType="System.String"/>
        <Column Name="Palette" DataType="System.Double"/>
        <Column Name="PMP" DataType="System.Double"/>
        <Column Name="U_carton" DataType="System.Double"/>
        <Column Name="Cart_Palet" DataType="System.Double"/>
        <Column Name="U_Poids" DataType="System.Double"/>
        <Column Name="Last_Qte" DataType="System.Double"/>
        <Column Name="Last_Qte_theor" DataType="System.Double"/>
        <Column Name="ID" DataType="System.Int32"/>
        <Column Name="EFFETID" DataType="System.Int32"/>
        <Column Name="TTC" DataType="System.Double"/>
        <Column Name="MONTANT_TVA" DataType="System.Double"/>
        <Column Name="RIS_CHIFFRE" DataType="System.Double"/>
        <Column Name="PREPARER" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="LOTID" DataType="System.Int32"/>
        <Column Name="DATEPEREMP" DataType="System.DateTime"/>
        <Column Name="LOTCODE" DataType="System.String"/>
        <Column Name="QT_DELIVERED" DataType="System.Double"/>
        <Column Name="QT_INVOICED" DataType="System.Double"/>
      </TableDataSource>
      <TableDataSource Name="EFFET_TYPE" DataType="System.Int32" Enabled="true" TableName="EFFET_TYPE">
        <Column Name="id" DataType="System.Int32"/>
        <Column Name="libelle" DataType="System.String"/>
        <Column Name="Type_operation" DataType="System.String"/>
        <Column Name="observation" DataType="System.String"/>
        <Column Name="OPERSTOCKSENS" DataType="System.Int32"/>
        <Column Name="OPERSOLDESENS" DataType="System.Int32"/>
      </TableDataSource>
      <TableDataSource Name="ENTREPRISE" DataType="System.Int32" Enabled="true" TableName="ENTREPRISE">
        <Column Name="ID" DataType="System.Int32"/>
        <Column Name="Nom" DataType="System.String"/>
        <Column Name="Adresse" DataType="System.String"/>
        <Column Name="RC" DataType="System.String"/>
        <Column Name="IF" DataType="System.String"/>
        <Column Name="AI" DataType="System.String"/>
        <Column Name="NIS" DataType="System.String"/>
        <Column Name="CB" DataType="System.String"/>
        <Column Name="capital" DataType="System.String"/>
        <Column Name="activite" DataType="System.String"/>
        <Column Name="rib" DataType="System.String"/>
        <Column Name="email" DataType="System.String"/>
        <Column Name="siteweb" DataType="System.String"/>
        <Column Name="tel" DataType="System.String"/>
        <Column Name="fax" DataType="System.String"/>
        <Column Name="logo" DataType="System.Byte[]" BindableControl="Picture"/>
        <Column Name="raison_2" DataType="System.String"/>
        <Column Name="Adresse_2" DataType="System.String"/>
        <Column Name="RC_2" DataType="System.String"/>
        <Column Name="IF_2" DataType="System.String"/>
        <Column Name="AI_2" DataType="System.String"/>
        <Column Name="NIS_2" DataType="System.String"/>
        <Column Name="CB_2" DataType="System.String"/>
        <Column Name="capital_2" DataType="System.String"/>
        <Column Name="activite_2" DataType="System.String"/>
        <Column Name="rib_2" DataType="System.String"/>
        <Column Name="email_2" DataType="System.String"/>
        <Column Name="siteweb_2" DataType="System.String"/>
        <Column Name="tel_2" DataType="System.String"/>
        <Column Name="fax_2" DataType="System.String"/>
        <Column Name="logo_2" DataType="System.Byte[]" BindableControl="Picture"/>
      </TableDataSource>
      <TableDataSource Name="EFFET" DataType="System.Int32" Enabled="true" TableName="EFFET">
        <Column Name="associe" DataType="System.String"/>
        <Column Name="type_effet" DataType="System.String"/>
        <Column Name="num_effet" DataType="System.String"/>
        <Column Name="date_effet" DataType="System.DateTime"/>
        <Column Name="id_tiers" DataType="System.Int32"/>
        <Column Name="tiers" DataType="System.String"/>
        <Column Name="montant_ht" DataType="System.Double"/>
        <Column Name="net_payer" DataType="System.Double"/>
        <Column Name="net_lettres" DataType="System.String"/>
        <Column Name="mode" DataType="System.String"/>
        <Column Name="payement" DataType="System.Double"/>
        <Column Name="reste" DataType="System.Double"/>
        <Column Name="ancien_solde" DataType="System.Double"/>
        <Column Name="timbre" DataType="System.Double"/>
        <Column Name="TVA" DataType="System.Double"/>
        <Column Name="ris_pourcentage" DataType="System.Double"/>
        <Column Name="ris_chiffre" DataType="System.Double"/>
        <Column Name="observation" DataType="System.String"/>
        <Column Name="num_cheque" DataType="System.String"/>
        <Column Name="marge" DataType="System.Double"/>
        <Column Name="tauxchange" DataType="System.Double"/>
        <Column Name="Kilometrage" DataType="System.Int32"/>
        <Column Name="RoueSecours" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="cric" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="manivelle" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="posteRadio" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="antenne" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="DiversEquipement" DataType="System.String"/>
        <Column Name="EtatCarosserie" DataType="System.String"/>
        <Column Name="Matricule" DataType="System.String"/>
        <Column Name="Serie" DataType="System.String"/>
        <Column Name="Marque" DataType="System.String"/>
        <Column Name="Type" DataType="System.String"/>
        <Column Name="VidangeMoteur" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="Vidange Boite" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="FiltreAir" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="FiltreGas" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="FiltreHuile" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="Plaquettes" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="KitEmbrayage" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="KitDistribution" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="Bougies" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="Scanner" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="Filtre Clim" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="AutreServices" DataType="System.String"/>
        <Column Name="TravauxUtiles" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="Mecanicien" DataType="System.String"/>
        <Column Name="TypeHuile" DataType="System.String"/>
        <Column Name="Valider" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="USERCR" DataType="System.String"/>
        <Column Name="USERUPD" DataType="System.String"/>
        <Column Name="DATEUPD" DataType="System.DateTime"/>
        <Column Name="PrixTTC" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="ID" DataType="System.Int32"/>
        <Column Name="ENATTENTE" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="DATE_ECHEANCE" DataType="System.DateTime"/>
      </TableDataSource>
      <TableDataSource Name="TIERS" DataType="System.Int32" Enabled="true" TableName="TIERS">
        <Column Name="TypeTiers" DataType="System.String"/>
        <Column Name="codeAnalytique" DataType="System.String"/>
        <Column Name="codeCompta" DataType="System.String"/>
        <Column Name="nom" DataType="System.String"/>
        <Column Name="adresse" DataType="System.String"/>
        <Column Name="code_postal" DataType="System.String"/>
        <Column Name="pays" DataType="System.String"/>
        <Column Name="ville" DataType="System.String"/>
        <Column Name="mobile" DataType="System.String"/>
        <Column Name="telephone" DataType="System.String"/>
        <Column Name="fax" DataType="System.String"/>
        <Column Name="email" DataType="System.String"/>
        <Column Name="site_web" DataType="System.String"/>
        <Column Name="nom_contact" DataType="System.String"/>
        <Column Name="observation" DataType="System.String"/>
        <Column Name="adresseLivraison" DataType="System.String"/>
        <Column Name="Solde" DataType="System.Double"/>
        <Column Name="SoldeInitiale" DataType="System.Double"/>
        <Column Name="rc" DataType="System.String"/>
        <Column Name="nif" DataType="System.String"/>
        <Column Name="ai" DataType="System.String"/>
        <Column Name="ComptBan" DataType="System.String"/>
        <Column Name="RIB" DataType="System.String"/>
        <Column Name="Nis" DataType="System.String"/>
        <Column Name="ID" DataType="System.Int32"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <TableDataSource Name="Employees" ReferenceName="Data.Employees" DataType="System.Int32" Enabled="true">
      <Column Name="ID" DataType="System.Int32"/>
      <Column Name="Name" DataType="System.String"/>
    </TableDataSource>
  </Dictionary>
  <ReportPage Name="Page1">
    <PageHeaderBand Name="PageHeader1" Width="718.2" Height="207.9">
      <PictureObject Name="Picture1" Left="633.15" Top="9.45" Width="75.6" Height="75.6" DataColumn="ENTREPRISE.logo"/>
      <RichObject Name="Rich1" Top="151.2" Width="595.35" Height="37.8" Text="{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Arial;}{\f2\fnil Tahoma;}}&#13;&#10;{\*\generator Riched20 10.0.19041}\viewkind4\uc1 &#13;&#10;\pard\b\f0\fs22 [EFFET.type_effet] N\'b0 [EFFET.num_effet]\b0\f1\fs20\par&#13;&#10;\f0 Date: [EFFET.date_effet]\f2\fs17\par&#13;&#10;}&#13;&#10;">
        <Formats>
          <GeneralFormat/>
          <GeneralFormat/>
          <DateFormat/>
        </Formats>
      </RichObject>
      <RichObject Name="Rich2" Top="9.45" Width="623.7" Height="66.15" Text="{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}}&#13;&#10;{\*\generator Riched20 10.0.19041}\viewkind4\uc1 &#13;&#10;\pard\f0\fs18 [\b ENTREPRISE.Nom]\par&#13;&#10;\b0 T\'e9l:[ENTREPRISE.tel] / [ENTREPRISE.fax]\par&#13;&#10;[ENTREPRISE.Adresse]\par&#13;&#10;[ENTREPRISE.email]\par&#13;&#10;}&#13;&#10;"/>
      <TableObject Name="Table2" Top="189" Width="718.2" Height="18.9">
        <TableColumn Name="Column5" Width="30.24"/>
        <TableColumn Name="Column6" Width="132.3"/>
        <TableColumn Name="Column7" Width="275.94"/>
        <TableColumn Name="Column8" Width="56.7"/>
        <TableColumn Name="Column12" Width="45.36"/>
        <TableColumn Name="Column13" Width="68.04"/>
        <TableColumn Name="Column15" Width="37.8"/>
        <TableColumn Name="Column16" Width="71.82"/>
        <TableRow Name="Row2">
          <TableCell Name="Cell5" Border.Lines="All" Fill.Color="WhiteSmoke" Text="N°" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TableCell Name="Cell6" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Référence" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TableCell Name="Cell7" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Désignation" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TableCell Name="Cell8" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Qte" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TableCell Name="Cell12" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Carton" HorzAlign="Center" Font="Times New Roman, 9pt, style=Bold"/>
          <TableCell Name="Cell13" Border.Lines="All" Fill.Color="WhiteSmoke" Text="P.U TTC" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TableCell Name="Cell15" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Ris%" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TableCell Name="Cell16" Border.Lines="All" Fill.Color="WhiteSmoke" Text="TTC" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
        </TableRow>
      </TableObject>
      <RichObject Name="Rich4" Top="94.5" Width="718.2" Height="56.7" Border.Lines="All" Text="{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}}&#13;&#10;{\*\generator Riched20 10.0.19041}\viewkind4\uc1 &#13;&#10;\pard\b\f0\fs20 [TIERS.TypeTiers] \b0 : [TIERS.nom]\par&#13;&#10;\b T\'e9l: \b0 [TIERS.telephone]\par&#13;&#10;\b Adresse\b0 : [TIERS.adresse]\fs18\par&#13;&#10;}&#13;&#10;" Padding="5, 5, 5, 5"/>
    </PageHeaderBand>
    <DataBand Name="Data1" Top="209.9" Width="718.2" Height="18.9" DataSource="LIGNE_EFFET">
      <TableObject Name="Table1" Width="718.2" Height="18.9" Border.Lines="All">
        <TableColumn Name="Column1" Width="30.24"/>
        <TableColumn Name="Column2" Width="132.3"/>
        <TableColumn Name="Column3" Width="275.94"/>
        <TableColumn Name="Column4" Width="56.7"/>
        <TableColumn Name="Column9" Width="45.36"/>
        <TableColumn Name="Column10" Width="68.04"/>
        <TableColumn Name="Column11" Width="37.8"/>
        <TableColumn Name="Column14" Width="71.82"/>
        <TableRow Name="Row1">
          <TableCell Name="Cell1" Border.Lines="All" Text="[LIGNE_EFFET.num]" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
          <TableCell Name="Cell2" Border.Lines="All" Text="[LIGNE_EFFET.reference]" Font="Times New Roman, 10pt"/>
          <TableCell Name="Cell3" Border.Lines="All" Text="[LIGNE_EFFET.Designation]" Font="Times New Roman, 10pt"/>
          <TableCell Name="Cell4" Border.Lines="All" Text="[LIGNE_EFFET.Quantite]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
          <TableCell Name="Cell9" Border.Lines="All" Text="[LIGNE_EFFET.Carton]" HideZeros="true" HideValue="-" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
          <TableCell Name="Cell10" Border.Lines="All" Text="[[LIGNE_EFFET.prix_u]* (1+[LIGNE_EFFET.tva]/100)]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
          <TableCell Name="Cell11" Border.Lines="All" Text="[LIGNE_EFFET.ris]" HideZeros="true" HideValue="-" NullValue="-" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
          <TableCell Name="Cell14" Border.Lines="All" Text="[LIGNE_EFFET.TTC]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
        </TableRow>
      </TableObject>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary1" Top="230.8" Width="718.2" Height="103.95">
      <RichObject Name="Rich5" Top="9.45" Width="718.2" Height="47.25" Border.Lines="All" Text="{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}}&#13;&#10;{\*\generator Riched20 10.0.19041}\viewkind4\uc1 &#13;&#10;\pard\f0\fs20 Ancien Solde: [EFFET.ancien_solde]\par&#13;&#10;Versement:      [EFFET.payement]\par&#13;&#10;}&#13;&#10;" Padding="5, 5, 5, 5">
        <Formats>
          <NumberFormat UseLocale="false" DecimalSeparator="," GroupSeparator=" " NegativePattern="1"/>
          <NumberFormat UseLocale="false"/>
        </Formats>
      </RichObject>
      <TextObject Name="Text1" Left="538.65" Top="56.7" Width="179.55" Height="18.9" Text="Vendeur : [EFFET.USERCR]" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <RichObject Name="Rich6" Left="529.2" Top="18.9" Width="179.55" Height="37.8" Text="{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Arial;}}&#13;&#10;{\*\generator Riched20 10.0.19041}\viewkind4\uc1 &#13;&#10;\pard\f0\fs22 Total :              \b [FormatNumber([EFFET.net_payer],2)]\b0\f1\fs20\par&#13;&#10;\f0 Nouveau solde : \b\fs22 [FormatNumber(\fs20  [EFFET.net_payer]+[EFFET.ancien_solde]-[EFFET.payement]\fs22 ,2)]\f1\fs20\par&#13;&#10;\b0\f0\par&#13;&#10;}&#13;&#10;" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1"/>
      <TextObject Name="Text2" Top="56.7" Width="434.7" Height="18.9" Text="Observation: [EFFET.observation]" VertAlign="Center" Font="Times New Roman, 8pt"/>
    </ReportSummaryBand>
  </ReportPage>
</Report>
