ERP Price Import

Format

XML file.

Contents

The xml file contains CIM time and cost that are to be imported into IMPACT database.

Configuration

    <add key="SourceDirectory" value="C:\IMPACT\StruSoft\In" />
    <add key="ErrorDirectory" value="C:\IMPACT\StruSoft\Error" />
    <add key="ProcessedDirectory" value="C:\IMPACT\StruSoft\Processed" />

    <!-- Price List parameters  -->
    <add key="PROJECT" value="1100" />
    <add key="PRICE_LIST" value="100002" />

Details

Here is an example of the imported file.

<?xml version="1.0" encoding="utf-8"?>
<ZMM_COST_PRICE>
    <MTPOS_MARA>Test</MTPOS_MARA>
    <BISMT>TestCIM</BISMT>
    <PRICE>2000</PRICE>
    <BSTMA>120</BSTMA>
</ZMM_COST_PRICE>

The following table contains the data mapping from the XML file to the table TIMELIST_CIM_STD in the IMPACT database. 

The following table contains the data mapping from the XML file to the table PRICELIST_CIM_STD in the IMPACT database.