ERP Production Export

Last modified by Theib Sawaf on 2018/10/07 12:48

Format

Text file, tab-separated values. Numer of columns is 22.

Contents

The export file contains order products and stock items with status Produced.

After the export elements are signed as exported (IMP_CAST_PLANNING.IsReported1 = 1)

Configuration

    <!-- Exported file directories -->
    <add key="ERPProductionDirectory" value="C:\IMPACT\StruSoft\ERPProduction\Out" />

Details

When the export function is triggered, it generate1 file per production factory.

The table IMP_ELEMENT_GRP_STD contains the units e.g. M2, TO, ST

Here is an example of how the file looks like.

File name: INT_SE97GoodsRcptDld_20150814_144811.txt

1220030000-311000        SZZZ    2521    1370    1370    KG        V77    1220030000    2015-08-17    2015-08-17    1000    521        4.94    M2    3.7    X    SE97    01    SL010
1220030000-311000        SZZZ    2521    1370    1370    KG        V77    1220030000    2015-08-17    2015-08-17    1000    521        4.94    M2    3.7    X    SE97    01    SL010
 

Here is an example in table form to show individual columns:

12345678910111213141516171819202122
1220050000-312000 SYYY1146549814981KG V6112200500002018-09-262018-09-261000521 15.40M213.8XSE971SL010
1220050000-312000 SYYY504314851485KG V4312200500002018-09-262018-09-261000521 04.37M27.0XSE971SL010
1220050000-312000 SYYY748923172317KG V24512200500002018-09-262018-09-261000521 08.14M210.0XSE971SL010
1220050000-332000 SYYY837829172917KG W1212200500002018-09-262018-09-261000521 07.12M210.1XSE971SL010
1220050000-332000 SYYY1081122672267KG W6312200500002018-09-262018-09-261000521 06.23M213.5XSE971SL010
1220050000-332000 SYYY927743404340KG W1212200500002018-09-262018-09-261000521 12.31M211.0XSE971SL010
1220050000-332000 SYYY927743404340KG W1212200500002018-09-262018-09-261000521 12.31M211.0XSE971SL010
1220050000-332000 SYYY970738583858KG W2012200500002018-09-262018-09-261000521 11.21M212.4XSE971SL010
1220054957-312000 SYYY1353269396939KG V1212200549572018-09-262018-09-261000521 19.43M213.5XSE971SL010
1220054957-332000 SYYY1632570057005KG W1712200549572018-09-262018-09-261000521 19.43M217.6XSE971SL010
1220054957-332000 SYYY1710669956995KG W1812200549572018-09-262018-09-261000521 19.40M219.1XSE971SL010
1220054957-332000 SYYY1798378437843KG W1212200549572018-09-262018-09-261000521 22.11M219.6XSE971SL010
1220055036-332000 SYYY1761472197219KG W1212200550362018-09-262018-09-261000521 19.39M219.6XSE971SL010
1220055036-332000 SYYY1840779067906KG W1512200550362018-09-262018-09-261000521 22.30M220.3XSE971SL010
213015 SYYY000KG LLG 3 2018-09-262018-09-261000521 2ST0    
213020 SYYY000KG LLG 3X 2018-09-262018-09-261000521 8ST0    
214015 SYYY000KG LLG 4 2018-09-262018-09-261000521 3ST0    
214065 SYYY000KG LLG 4X 2018-09-262018-09-261000521 7ST0    
222135 SYYY000KG F302 2018-09-262018-09-261000521 1ST0    
224301 SYYY000KG PV4-3M-LLC 2018-09-262018-09-261000521 1ST0    
241504 SYYY000KG SF16-150 2018-09-262018-09-261000521 6ST0    
242404 SYYY000KG SF16-240 2018-09-262018-09-261000521 132ST0    
271215 SYYY000KG HG12/15 2018-09-262018-09-261000521 20ST0    

Column Description

Column NoNameOrdered ProductsStock Items
1Old MaterialSales Order Name + "-" + Element Group + "000"Sales Order Name
2MaterialEmptyEmpty
3PlantExterna Factory Name (RM/Settings/Factories)Externa Factory Name (RM/Settings/Factories)
4PricePrice0
5Gross WeightElement Mass (KG)0
6Net WeightElement Mass (KG)0
7Unit Of WeightKGKG
8Wbs ElementEmptyEmpty
9PositionElement MarkElement Mark
10ERP Order NbrSales Order Name (PM/Properties)Sales Order Name (PM/Properties)
11Posting DateExport DateExport Date
12Document DateExport DateExport Date
13Storage Location1000 (Hard coded)1000 (Hard coded)
14Move TypeCODE 521: Element is neither rejected not reported
CODE 551: Element  is reported ans rejected but not reported as rejected
521 (Hard coded)
15Spec StockEmptyEmpty
16Entry QuantitySee table belowCount
17Unit Of EntryIMP_ELEMENT_GRP_STD.UNITST (Hard coded)
18Max Lot SizeProduction Time (Cost.ElementTotalTime.TotalTime)Production Time (Cost.ElementTotalTime.TotalTime)
19Zzlit1XEmpty
20Sales OrganisationSE97Empty
21Distribution Channel01Empty
22ProcessSL010Empty

Unit Quantity Table

The element group unit defined in the database (IMP_ELEMENT_GRP_STD) decides what element quantity should be used, see the table below.

UNITQuantity
M2,Area
TOMass
STCount
Tags:
Created by Theib Sawaf on 2018/09/26 15:57
Copyright 2018 StruSoft AB
Impact Documentation