Sample XML and CSV files
This section contains sample XML mapping definition and sample CSV files for Calc Group Rate.
Sample XML mapping definition
<table-config>
<table name="CALC_GROUP_RATE" transaction-type="INSERT_UPDATE" key-fields="CGR_NAME" primary-key="CGR_ID">
<fields>
<field index="1" db-field="CGR_NAME"/>
<field index="2" db-field="CALCGRP_ID">
<reference table-name="CALC_GROUP" supplied-value="CALCGRP_ID" resolve-to-field="CALCGRP_ID"/>
</field>
<field index="3" db-field="CGR_PRIORITY"/>
<field index="4" db-field="CGR_EFFECTIVE_DATE" date-format="yyyy-MM-dd" default-value="!SYSTEM_DATE"/>
<field index="5" db-field="CGR_RATE_TYPE"/>
</fields>
</table>
</table-config>
Sample CSV file
TEST CALC GROUP RATE,9999,10,2022-10-01,ABSOLUTE