git.roojs.org Git - xtuple/blob - foundation-database/public/tables/bankrecimport.xml

   1 <!DOCTYPE openCSVAtlasDef>
   2 <CSVAtlas>
   3  <CSVMap>
   4   <Name>bankrec</Name>
   5   <Table>public.bankrecimport</Table>
   6   <Action>Insert</Action>
   7   <PreSQL>DELETE FROM bankrecimport;</PreSQL>
   8   <PostSQL>SELECT importBankrecCleared(-1);</PostSQL>
   9   <CSVMapField>
  10    <Name>bankrecimport_reference</Name>
  11    <Type>QString</Type>
  12    <Column>8</Column>
  13   </CSVMapField>
  14   <CSVMapField>
  15    <Name>bankrecimport_descrip</Name>
  16    <Type>QString</Type>
  17    <Column>4</Column>
  18   </CSVMapField>
  19   <CSVMapField>
  20    <Name>bankrecimport_comment</Name>
  21    <Type>QString</Type>
  22    <Column>9</Column>
  23   </CSVMapField>
  24   <CSVMapField>
  25    <Name>bankrecimport_debit_amount</Name>
  26    <Type>double</Type>
  27    <Column>5</Column>
  28   </CSVMapField>
  29   <CSVMapField>
  30    <Name>bankrecimport_credit_amount</Name>
  31    <Type>double</Type>
  32    <Column>6</Column>
  33   </CSVMapField>
  34   <CSVMapField>
  35    <Name>bankrecimport_effdate</Name>
  36    <Type>QDate</Type>
  37    <Column>1</Column>
  38   </CSVMapField>
  39  </CSVMap>
  40 </CSVAtlas>