<?xml version="1.0" encoding="utf-8"?>
<FormatImport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <oKind>TransactionCurrent</oKind>
  <stName>Format qif ING</stName>
  <stExtension>qif</stExtension>
  <oDateOrder>DMY</oDateOrder>
  <stDateDelimiter>/</stDateDelimiter>
  <bYear4Digits>true</bYear4Digits>
  <oFieldSeparator>PointVirgule</oFieldSeparator>
  <stDecimalSeparator>.</stDecimalSeparator>
  <stTimeSeparator>:</stTimeSeparator>
  <stTextSeparator>"</stTextSeparator>
  <bStartRow>false</bStartRow>
  <strListOfRules>
    <FormatRule>
      <stDescription>Création d'un FITID =&gt; Virement effectué après importation pas pris en compte</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCIdImport</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCDateReal</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCIdImport</oFieldSource>
          <oAction>FieldConcatRight</oAction>
          <oResultColumn>TCAmount</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCIdImport</oFieldSource>
          <oAction>FieldConcatRight</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Transfert du champ Tiers (P en Qif) vers le champ Notes (M en Qif)</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type PAIEMENT PAR CARTE</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^PAIEMENT\sPAR\sCARTE.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Carte Bancaire</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>{12}</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateValue</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCDateReal</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^PAIEMENT\sPAR\sCARTE\s(\d{2}/\d{2}/\d{4})\s.+~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^PAIEMENT\sPAR\sCARTE\s\d{2}/\d{2}/\d{4}\s(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type RETRAIT DAB EN EURO ZONE EURO</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^RETRAIT\sDAB\sEN\sEURO\sZONE\sEURO.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Retrait Espèce par Carte</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>{12}</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateValue</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCDateReal</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^RETRAIT\sDAB\sEN\sEURO\sZONE\sEURO\s(\d{2}/\d{2}/\d{4})\s.+~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^RETRAIT\sDAB\sEN\sEURO\sZONE\sEURO\s\d{2}/\d{2}/\d{4}\s(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type RETRAIT DAB</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^RETRAIT\sDAB.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Retrait Espèce par carte</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>{12}</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateValue</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCDateReal</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^RETRAIT\sDAB\s(\d{2}/\d{2}/\d{4})\s.+~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^RETRAIT\sDAB\s\d{2}/\d{2}/\d{4}\s(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type PAIEMENT D'UN CHÈQUE</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^PAIEMENT\sD'UN\sCHÈQUE.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Chèque émis</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^PAIEMENT\sD'UN\sCHÈQUE\s(.*)~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type PRLV SEPA</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^PRLV\sSEPA.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^PRLV\sSEPA.+:\s(.+)\sDE.*~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^PRLV\sSEPA\s(.+?):.+~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type VIREMENT SEPA EMIS VERS</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIREMENT\sSEPA\sEMIS\sVERS.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VIREMENT\sSEPA\sEMIS\sVERS(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type VIREMENT EMIS VERS</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIREMENT\sEMIS\sVERS.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Virement Intercomptes</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VIREMENT\sEMIS\sVERS(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type VIREMENT VERS</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIREMENT\sVERS.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Virement Intercomptes</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VIREMENT\sVERS(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type AVOIR CARTE</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^AVOIR\sCARTE.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Crédit par carte</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>{12}</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^AVOIR\sCARTE(.+)~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Avoir</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type REMISE CHEQUE(S)</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^REMISE\sCHEQUE\(S\).+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Chèque reçu</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^REMISE\sCHEQUE\(S\)\s(.*)~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type REMISE DE CHÈQUE(S)</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^REMISE\sDE\sCHÈQUE\(S\).+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Chèque reçu</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^REMISE\sDE\sCHÈQUE\(S\)\s(.*)~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type VIREMENT SEPA RECU</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIREMENT\sSEPA\sRECU.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VIREMENT\sSEPA\sRECU(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type VIREMENT RECU</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIREMENT\sRECU.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Virement Intercomptes</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VIREMENT\sRECU(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type VIREMENT DE, DU</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIREMENT\sD[E,U]\s.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Virement Intercomptes</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VIREMENT\sD[E,U]\s(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type VIRMENT DES</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIREMENT\sDES.+</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VIREMENT\sDES(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Versement depuis Paypal</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Versement</stValueText>
        </FormatItemCondition>
        <FormatItemCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>.+\sPAYPAL</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(.+)\sPAYPAL~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Paypal</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Mise au format du tiers</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>\s+~ </stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^Remise\sDe\sChèque\(S\)~Remise de Chèque(s)</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^Compte\sÀ\sCompte\s~</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>Trim</oAction>
          <oResultColumn />
          <stResultText> </stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
  </strListOfRules>
</FormatImport>