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.
Source | Destination | Comments |
<add key="PROJECT" value="1100" /> | cost.TIMELIST_CIM_STD.Factory | |
<add key="PROJECT" value="1100" /> | cost.TIMELIST_CIM_STD.Project | |
BISMT | cost.TIMELIST_CIM_STD.Cim | |
BSTMA | cost.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.
Source | Destination | Comments |
<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 | |
BISMT | cost.PRICELIST_CIM_STD.Cim | |
PRICE | cost.PRICELIST_CIM_STD.Cost |