ERP Production Export
Version 17.1 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:
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 1220050000-312000 | SYYY | 11465 | 4981 | 4981 | KG | V61 | 1220050000 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 15.40 | M2 | 13.8 | X | SE97 | 1 | SL010 | |||
| 1220050000-312000 | SYYY | 5043 | 1485 | 1485 | KG | V43 | 1220050000 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 04.37 | M2 | 7.0 | X | SE97 | 1 | SL010 | |||
| 1220050000-312000 | SYYY | 7489 | 2317 | 2317 | KG | V245 | 1220050000 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 08.14 | M2 | 10.0 | X | SE97 | 1 | SL010 | |||
| 1220050000-332000 | SYYY | 8378 | 2917 | 2917 | KG | W12 | 1220050000 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 07.12 | M2 | 10.1 | X | SE97 | 1 | SL010 | |||
| 1220050000-332000 | SYYY | 10811 | 2267 | 2267 | KG | W63 | 1220050000 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 06.23 | M2 | 13.5 | X | SE97 | 1 | SL010 | |||
| 1220050000-332000 | SYYY | 9277 | 4340 | 4340 | KG | W12 | 1220050000 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 12.31 | M2 | 11.0 | X | SE97 | 1 | SL010 | |||
| 1220050000-332000 | SYYY | 9277 | 4340 | 4340 | KG | W12 | 1220050000 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 12.31 | M2 | 11.0 | X | SE97 | 1 | SL010 | |||
| 1220050000-332000 | SYYY | 9707 | 3858 | 3858 | KG | W20 | 1220050000 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 11.21 | M2 | 12.4 | X | SE97 | 1 | SL010 | |||
| 1220054957-312000 | SYYY | 13532 | 6939 | 6939 | KG | V12 | 1220054957 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 19.43 | M2 | 13.5 | X | SE97 | 1 | SL010 | |||
| 1220054957-332000 | SYYY | 16325 | 7005 | 7005 | KG | W17 | 1220054957 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 19.43 | M2 | 17.6 | X | SE97 | 1 | SL010 | |||
| 1220054957-332000 | SYYY | 17106 | 6995 | 6995 | KG | W18 | 1220054957 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 19.40 | M2 | 19.1 | X | SE97 | 1 | SL010 | |||
| 1220054957-332000 | SYYY | 17983 | 7843 | 7843 | KG | W12 | 1220054957 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 22.11 | M2 | 19.6 | X | SE97 | 1 | SL010 | |||
| 1220055036-332000 | SYYY | 17614 | 7219 | 7219 | KG | W12 | 1220055036 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 19.39 | M2 | 19.6 | X | SE97 | 1 | SL010 | |||
| 1220055036-332000 | SYYY | 18407 | 7906 | 7906 | KG | W15 | 1220055036 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 22.30 | M2 | 20.3 | X | SE97 | 1 | SL010 | |||
| 213015 | SYYY | 0 | 0 | 0 | KG | LLG 3 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 2 | ST | 0 | ||||||||
| 213020 | SYYY | 0 | 0 | 0 | KG | LLG 3X | 2018-09-26 | 2018-09-26 | 1000 | 521 | 8 | ST | 0 | ||||||||
| 214015 | SYYY | 0 | 0 | 0 | KG | LLG 4 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 3 | ST | 0 | ||||||||
| 214065 | SYYY | 0 | 0 | 0 | KG | LLG 4X | 2018-09-26 | 2018-09-26 | 1000 | 521 | 7 | ST | 0 | ||||||||
| 222135 | SYYY | 0 | 0 | 0 | KG | F302 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 1 | ST | 0 | ||||||||
| 224301 | SYYY | 0 | 0 | 0 | KG | PV4-3M-LLC | 2018-09-26 | 2018-09-26 | 1000 | 521 | 1 | ST | 0 | ||||||||
| 241504 | SYYY | 0 | 0 | 0 | KG | SF16-150 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 6 | ST | 0 | ||||||||
| 242404 | SYYY | 0 | 0 | 0 | KG | SF16-240 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 132 | ST | 0 | ||||||||
| 271215 | SYYY | 0 | 0 | 0 | KG | HG12/15 | 2018-09-26 | 2018-09-26 | 1000 | 521 | 20 | ST | 0 |
Column Description
| Column No | Name | Ordered Products | Stock Items |
| 1 | Old Material | Sales Order Name + "-" + Element Group + "000" | Sales Order Name |
| 2 | Material | Empty | Empty |
| 3 | Plant | Externa Factory Name (RM/Settings/Factories) | Externa Factory Name (RM/Settings/Factories) |
| 4 | Price | Price | 0 |
| 5 | Gross Weight | Element Mass (KG) | 0 |
| 6 | Net Weight | Element Mass (KG) | 0 |
| 7 | Unit Of Weight | KG | KG |
| 8 | Wbs Element | Empty | Empty |
| 9 | Position | Element Mark | Element Mark |
| 10 | ERP Order Nbr | Sales Order Name (PM/Properties) | Sales Order Name (PM/Properties) |
| 11 | Posting Date | Export Date | Export Date |
| 12 | Document Date | Export Date | Export Date |
| 13 | Storage Location | 1000 (Hard coded) | 1000 (Hard coded) |
| 14 | Move Type | CODE 521: Element is neither rejected not reported CODE 551: Element is reported ans rejected but not reported as rejected | 521 (Hard coded) |
| 15 | Spec Stock | Empty | Empty |
| 16 | Entry Quantity | See table below | Count |
| 17 | Unit Of Entry | IMP_ELEMENT_GRP_STD.UNIT | ST (Hard coded) |
| 18 | Max Lot Size | Production Time (Cost.ElementTotalTime.TotalTime) | Production Time (Cost.ElementTotalTime.TotalTime) |
| 19 | Zzlit1 | X | Empty |
| 20 | Sales Organisation | SE97 | Empty |
| 21 | Distribution Channel | 01 | Empty |
| 22 | Process | SL010 | Empty |
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.
| UNIT | Quantity |
| M2, | Area |
| TO | Mass |
| ST | Count |