<?xml version="1.0" encoding="utf-8"?>
<FormatImport xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <oKind>TransactionCurrent</oKind>
  <stName>Format ofx BPCA</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>MEMO = PAIEMENT PAR CARTE</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>POS</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Carte bancaire</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>FieldAdd</oAction>
          <oResultColumn />
          <stResultText>Visa</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = RETRAIT AU DISTRIBUTEUR</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>RETRAIT AU DISTRIBUTEUR</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Retrait espèce par carte</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>FieldAdd</oAction>
          <oResultColumn />
          <stResultText>Mastercard</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = VIREMENT EN VOTRE FAVEUR</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>CREDIT</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Versement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = VIREMENT EMIS</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>VIREMENT EMIS</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Virement Intercomptes</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = PRELEVEMENT</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>DEBIT</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = CHEQUE EMIS</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>CHEQUE EMIS</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Chèque émis</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = REMISE DE CHEQUE</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Remise De Cheque</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Chèque reçu</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>NAME = PRELEVMNT</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>PRELEVMNT</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>NAME = VIREMENT EMIS</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>VIREMENT EMIS</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>FITID contient la Date de valeur pour les cartes bancaires à débit différé</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Carte bancaire</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCIdImport</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^([0-9]{4})([0-9]{2})([0-9]{2})[0-9]*~$1$2$3</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCIdImport</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Carte bancaire</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Visa</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCDateValue</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Minuscule / Majuscule</stDescription>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ToUpper</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Nettoyage des champs</stDescription>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>TrimEnd</oAction>
          <oResultColumn />
          <stResultText>0123456789 /</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>\s+~ </stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>\s+~ </stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Purge des identifiants d'importation en doublon</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCIdImport</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>0000000000000</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCIdImport</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Suppression Total Carte Débit Différé</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>PRELEVEMENT CARTE</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
  </strListOfRules>
</FormatImport>