<?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>AnteaGroup</stName>
  <stExtension>csv</stExtension>
  <oDateOrder>DMY</oDateOrder>
  <stDateDelimiter>/</stDateDelimiter>
  <bYear4Digits>true</bYear4Digits>
  <oFormatMonth>Numerical</oFormatMonth>
  <oFieldSeparator>PointVirgule</oFieldSeparator>
  <stDecimalSeparator>.</stDecimalSeparator>
  <stTimeSeparator>:</stTimeSeparator>
  <stTextSeparator>"</stTextSeparator>
  <bStartRow>true</bStartRow>
  <oListOfColumns>
    <FormatColumn>TCDateReal</FormatColumn>
    <FormatColumn>TCThirdParty</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCAmount</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>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>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>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
  </oListOfColumns>
  <strListOfRules>
    <FormatRule>
      <stDescription>Transformation du champ "Montant" positif en champ "Débit" négatif</stDescription>
      <bFromServer>false</bFromServer>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCAmount</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(\d+)~-$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCAmount</oFieldSource>
          <oAction>SolveOperation</oAction>
          <oResultColumn />
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>Paiement</stDescription>
      <bFromServer>false</bFromServer>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Carte Bancaire</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>CBPremier Olivier</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Avances</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCMarker</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Antea France</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Avance frais professionnels</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateValue</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCDateReal</oResultColumn>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
  </strListOfRules>
</FormatImport>