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