<?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 Ofx LBP</stName>
  <stExtension>ofx</stExtension>
  <oDateOrder>YMD</oDateOrder>
  <stDateDelimiter />
  <bYear4Digits>true</bYear4Digits>
  <oFieldSeparator>PointVirgule</oFieldSeparator>
  <stDecimalSeparator>.</stDecimalSeparator>
  <stTimeSeparator>:</stTimeSeparator>
  <stTextSeparator>"</stTextSeparator>
  <bStartRow>false</bStartRow>
  <strListOfRules>
    <Rules>
      <stDescription>Chèque émis / Mise à jour de l'opération</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Chèque émis</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Débit Divers</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Divers</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Chèque reçu / Mise à jour de l'opération</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Chèque reçu</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Crédit Divers</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Divers</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>.*([0-9]{2})/([0-9]{2})/([0-9]{4})$~$3$2$1</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Prélèvemen / Mise à jour de l'opération</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Prélèvement</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Débit Divers</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Divers</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Versemen / Mise à jour de l'opération</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Versement</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Crédit Divers</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Divers</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Carte Bancaire / Mise à jour de l'opération</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Carte Bancaire</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Débit Divers</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Divers</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>.*([0-9]{2})\.([0-9]{2})\.([0-9]{2})$~20$3$2$1</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Retrait Espèce par Carte / Mise à jour de l'opération</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Retrait Espèce par Carte</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Débit divers</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Retrait d'espèces</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>.*([0-9]{2})/([0-9]{2})/([0-9]{2})~20$3$2$1</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Frais bancaire</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>FRAIS DE|COTISATION</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Débit Divers</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Frais bancaires</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Carte bancaire / Compte 1</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Carte Bancaire</stValueText>
        </RulesCondition>
        <RulesCondition>
          <oFieldReference>TCIdImport</oFieldReference>
          <oOperator>StartsWith</oOperator>
          <oValueColumn />
          <stValueText>PR9S</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>CB</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Retrait Espèce par Carte / Compte 1</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Retrait Espèce par Carte</stValueText>
        </RulesCondition>
        <RulesCondition>
          <oFieldReference>TCIdImport</oFieldReference>
          <oOperator>StartsWith</oOperator>
          <oValueColumn />
          <stValueText>PR9S</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>CB</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Carte bancaire / Compte 2</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Carte bancaire</stValueText>
        </RulesCondition>
        <RulesCondition>
          <oFieldReference>TCIdImport</oFieldReference>
          <oOperator>StartsWith</oOperator>
          <oValueColumn />
          <stValueText>PNQM</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>CB</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Retrait Espèce par Carte / Compte 2</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Retrait Espèce par Carte</stValueText>
        </RulesCondition>
        <RulesCondition>
          <oFieldReference>TCIdImport</oFieldReference>
          <oOperator>StartsWith</oOperator>
          <oValueColumn />
          <stValueText>PNQM</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>CB</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
  </strListOfRules>
</FormatImport>