<?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 csv Wise</stName>
  <stExtension>csv</stExtension>
  <oDateOrder>DMY</oDateOrder>
  <stDateDelimiter>-</stDateDelimiter>
  <bYear4Digits>true</bYear4Digits>
  <oFormatMonth>Numerical</oFormatMonth>
  <oFieldSeparator>Virgule</oFieldSeparator>
  <stDecimalSeparator>.</stDecimalSeparator>
  <stTimeSeparator>:</stTimeSeparator>
  <stTextSeparator />
  <bStartRow>true</bStartRow>
  <oListOfColumns>
    <FormatColumn>TCCheque</FormatColumn>
    <FormatColumn>TCDateValue</FormatColumn>
    <FormatColumn>TCAmount</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCThirdParty</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCCB</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
  </oListOfColumns>
  <strListOfRules>
    <FormatRule>
      <stDescription>Type Versement</stDescription>
      <bFromServer>false</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCheque</oFieldReference>
          <oOperator>StartsWith</oOperator>
          <oValueColumn />
          <stValueText>TRANSFER</stValueText>
        </FormatItemCondition>
        <FormatItemCondition>
          <oFieldReference>TCAmount</oFieldReference>
          <oOperator>GreaterThanOrEqual</oOperator>
          <oValueColumn />
          <stValueText>0</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>FieldAdd</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Versement</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Type Prélèvement</stDescription>
      <bFromServer>false</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCCheque</oFieldReference>
          <oOperator>StartsWith</oOperator>
          <oValueColumn />
          <stValueText>TRANSFER</stValueText>
        </FormatItemCondition>
        <FormatItemCondition>
          <oFieldReference>TCAmount</oFieldReference>
          <oOperator>LessThan</oOperator>
          <oValueColumn />
          <stValueText>0</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>FieldAdd</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
  </strListOfRules>
</FormatImport>