Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Budget Pay Cost.

<table-config>
    <table name="SO_BUDG_PAY_COST" transaction-type="INSERT" primary-key="BDGPAY_ID">
        <fields>
            <field index="1" db-field="SKDGRP_ID">
                <reference table-name="SO_SCHEDULE_GROUP" supplied-value="SKDGRP_NAME" resolve-to-field="SKDGRP_ID"/>
            </field>
            <field index="2" db-field="BDGPAY_DATE" date-format="MM/dd/yyyy" default-value="!SYSTEM_DATE"/>
            <field index="3" db-field="BDGPAY_AMOUNT"/>
        </fields>
    </table>
</table-config>

1093,09/07/2022,1000