<?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 CIC</stName>
  <stExtension>ofx</stExtension>
  <oDateOrder>YMD</oDateOrder>
  <stDateDelimiter />
  <bYear4Digits>true</bYear4Digits>
  <oFieldSeparator>PointVirgule</oFieldSeparator>
  <stDecimalSeparator>.</stDecimalSeparator>
  <stTimeSeparator>:</stTimeSeparator>
  <stTextSeparator>"</stTextSeparator>
  <bStartRow>false</bStartRow>
  <strListOfRules>
    <FormatRule>
      <stDescription>Type = POS pour un débit - Ajout du nom de la carte bancaire</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Carte Bancaire</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>FieldAdd</oAction>
          <oResultColumn />
          <stResultText>&lt;Indiquer le nom de la CB dans le format&gt;</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateValue</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type = POS pour un crédit - Ajout du nom de la carte bancaire</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCKind</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>Crédit par carte bancaire</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>FieldAdd</oAction>
          <oResultColumn />
          <stResultText>&lt;Indiquer le nom de la CB dans le format&gt;</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateValue</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>NAME = RETRAIT DAB</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^RETRAIT\sDAB</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Retrait espèce par carte</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>FieldAdd</oAction>
          <oResultColumn />
          <stResultText>&lt;Indiquer le nom de la CB dans le format&gt;</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>.+\s[0-9]{4}\s(.+)~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>NAME = VIR SEPA</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIR\sSEPA</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VIR\sSEPA\s(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>NAME = PRLV SEPA</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^PRLV\sSEPA</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^PRLV\sSEPA\s(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>NAME = VIR</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VIR</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Versement</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VIR\s(.+)~$1</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>NAME = VRST</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^VRST</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Versement</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^VRST\s(.+)~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>NAME = CHEQUE</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>^CHEQUE</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <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>^CHEQUE\s(.*)~$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Minuscule / Majuscule</stDescription>
      <bFromServer>true</bFromServer>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ToUpper</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
  </strListOfRules>
</FormatImport>