Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Planned Volume.

<table-config>
   <table name="SO_PLANNED_VOLUME" transaction-type="INSERT" primary-key="PLNVOL_ID">
      <fields>
         <field index="1" db-field="SKDGRP_ID">
            <reference table-name="SO_SCHEDULE_GROUP" supplied-value="SKDGRP_CLIENTKEY" resolve-to-field="SKDGRP_ID"/>
         </field>
         <field index="2" db-field="PLNVOL_DATE" date-format="yyyy-MM-dd HH:mm:ss" default-value="!SYSTEM_DATE"/>
         <field index="3" db-field="PLNVOL_TIME" date-format="yyyy-MM-dd HH:mm:ss"/>
         <field index="4" db-field="PLNVOL_VOLUME"/>
         <field index="5" db-field="INVTYP_ID">
            <reference table-name="SO_INTERVAL_TYPE" supplied-value="INVTYP_ID" resolve-to-field="INVTYP_ID"/>
        </field>
      </fields>
   </table>
</table-config>

1093,2022-09-05 00:00:00,2022-09-05 00:00:00,1000.000,1