ERP Price Import

Last modified by Theib Sawaf on 2018/09/30 12:02

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. 

SourceDestinationComments
<add key="PROJECT" value="1100" />cost.TIMELIST_CIM_STD.Factory 
<add key="PROJECT" value="1100" />cost.TIMELIST_CIM_STD.Project 
BISMTcost.TIMELIST_CIM_STD.Cim 
BSTMAcost.TIMELIST_CIM_STD.Duration 

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

SourceDestinationComments
<add key="PROJECT" value="1100" />cost.PRICELIST_CIM_STD.Factory 
<add key="PROJECT" value="1100" />cost.PRICELIST_CIM_STD.Project 
<add key="PRICE_LIST" value="100002" />cost.PRICELIST_CIM_STD.Pricelist_Id 
BISMTcost.PRICELIST_CIM_STD.Cim 
PRICEcost.PRICELIST_CIM_STD.Cost 

 

Tags:
Created by Theib Sawaf on 2018/09/27 11:24
Copyright 2018 StruSoft AB
Impact Documentation