ERP Delivery Export
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" />
<add key="ERPDeliveryDirectory" value="C:\IMPACT\StruSoft\ERPDelivery\Out" />
Details
Export Files Generated
Here is an example.
File name: INT_SE97GoodsIssueDld_20180928_152457.txt
1220040000 1220040000-314000 SEZS 10.26 M2 STRU55566 VS100804 7010628506 2018-09-28 1220040000 1220040000-314000 SEZS 10.27 M2 STRU55566 VS100811 7010628506 2018-09-28 1220040000 1220040000-314000 SEZS 10.61 M2 STRU55566 VS100803 7010628506 2018-09-28 1220040000 1220040000-314000 SEZS 11.32 M2 STRU55566 VS100908 7010631831 2018-09-28 |
The table below shows the files generated
No | Name | No Of Columns | Symbol | Directory | Type | Contents |
1 | Main | 10 | Issue | ERPDeliveryDirectory | Delivery | BoundingBoxArea,Mass,elementGroups,Mark, ItemNr1 Additional Items Stock Items: ItemNr1, Count, ST,ElementMark CIM Items: cimName, Count Other Items: Count,ST, plant |
2 | Cim And Other Items | 22 | Rcpt | ERPProductionDirectory | Production | AdditionalItems: Cim and other Items (Mass, Count, ST, Name/Description) |
3 | Special Delivery Export (HHA) | 10 | Issue | ERPDeliveryDirectory | Delivery | BoundingBoxArea, ReinforcementMass, cimData.ItemNr1, Quantity, Hole Count,therItems(Mass, Count, ST, Description) |
Main Delivery Export To ERP System
Below is an example in table form to show individual columns.
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
1220040000 | 1220040000-37000 | SXXX | 11.03 | M2 | S888666 | PL13006 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-37000 | SXXX | 17.04 | M2 | S888666 | PL13012 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-37000 | SXXX | 17.04 | M2 | S888666 | PL13013 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-37000 | SXXX | 18.07 | M2 | S888666 | PL13007 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-37000 | SXXX | 18.15 | M2 | S888666 | PL13008 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-37000 | SXXX | 06.26 | M2 | S888666 | PL13011 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-37000 | SXXX | 07.00 | M2 | S888666 | PL13005 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-37000 | SXXX | 08.09 | M2 | S888666 | PL13010 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-37000 | SXXX | 08.02 | M2 | S888666 | PL13009 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-37000 | SXXX | 09.30 | M2 | S888666 | PL13014 | 7010640000 | 2018-09-28 | |
1220040000 | 1220040000-550000 | SXXX | 7 | ST | S888666 | Other Item | 7010640000 | 2018-09-28 | |
1220040000 | FLX4107 | SXXX | 1 | ST | S888666 | FLX4107 | 7010640000 | 2018-09-28 | |
1220040000 | FLX4108 | SXXX | 1 | ST | S888666 | FLX4108 | 7010640000 | 2018-09-28 |
Column Description
Column No | Value Name | Stock Item | Other Items | CIM |
1 | Sales Order Name | |||
2 | Sales Order Name "-" + Group | ItemNr1 | Sales Order Name + "-550000" | CimName |
3 | Empty | |||
4 | Factory (e.g. SXXX) | |||
5 | Quantity | |||
6 | Unit | |||
7 | Project | |||
8 | Element Mark/ItemNr1 | Description | Empty | |
9 | Delivery Note Id | |||
10 | Current Date |
Cim And Other Items
Below 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 |
0103B | SXXX | 0 | 0 | 0 | KG | 0103B | 5556660000 | 2018-09-28 | 2018-09-28 | 1000 | 521 | 1 | ST | 0 | |||||||
0103C | SXXX | 0 | 0 | 0 | KG | 0103C | 5556660000 | 2018-09-28 | 2018-09-28 | 1000 | 521 | 1 | ST | 0 | |||||||
0104C | SXXX | 0 | 0 | 0 | KG | 0104C | 2018-09-28 | 2018-09-28 | 1000 | 521 | 1 | ST | 0 | ||||||||
0104D | SXXX | 0 | 0 | 0 | KG | 0104D | 2018-09-28 | 2018-09-28 | 1000 | 521 | 1 | ST | 0 | ||||||||
5556660000-550000 | SXXX | 400 | 2000 | 2000 | KG | Skarvnät RF1 | 5556660000 | 2018-09-28 | 2018-09-28 | 1000 | 521 | 4 | ST | 0 | X | SE97 | 01 | SL010 | |||
5556660000-550000 | SXXX | 500 | 3000 | 3000 | KG | Skarvnät typ1 | 5556660000 | 2018-09-28 | 2018-09-28 | 1000 | 521 | 4 | ST | 0 | X | SE97 | 01 | SL010 | |||
5556660000-550000 | SXXX | 600 | 3000 | 3000 | KG | Skarvnät RF2 | 5556660000 | 2018-09-28 | 2018-09-28 | 1000 | 521 | 5 | ST | 0 | X | SE97 | 01 | SL010 | |||
5556660000-550000 | SXXX | 800 | 4000 | 4000 | KG | Skarvnät typ2 | 5556660000 | 2018-09-28 | 2018-09-28 | 1000 | 521 | 5 | ST | 0 | X | SE97 | 01 | SL010 | |||
5556660000-550000 | SXXX | 900 | 2000 | 2000 | KG | Skarvnät typ3 | 5556660000 | 2018-09-28 | 2018-09-28 | 1000 | 521 | 7 | ST | 0 | X | SE97 | 01 | SL010 |
Column Description
Below is the export of CIM items and other items
Filename = "INT_SE97GoodsRcptDld_" + DateTime.Now.ToString( "yyyMMdd" ) + "_" + DateTime.Now.ToString( "HHmmss" ) + ".txt";
Example: INT_SE97GoodsRcptDld_20180928_105603.txt
Column No | Name | CIM | Other 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 | CIM Name | Description |
10 | SAP Order Nbr | Empty | 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 | 0 | 0 |
19 | Zzlit1 | X | Empty |
20 | Sales Organisation | SE97 | Empty |
21 | Distribution Channel | 01 | Empty |
22 | Process | SL010 | Empty |
Special Delivery Export To ERP System
The following export contains information about elements on transports:
- CIM information
- Number of holes
- Additional Items/Other Items
The lengths (imp_cim.cim_length is always in mm) are presented in m in the IMPACT Sync Special delivery export to ERP. This means they are divided by 1000.
For girders the total length in m is divided by the mass per meter (imp_cim_std.mass)
For girders “SB” the value is expressed in “KG”
Below is an example in table form to show individual columns.
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
5556660000 | ST666777-4 | 7010653652 | 2018-09-28 | ||||||
5556660000 | 5556660000-37000 | SXXX | 14.27 | M2 | ST666777 | 7010653652 | 2018-09-28 | ||
5556660000 | ARM | SXXX | 64.01 | KG | ST666777 | ARM | 7010653652 | 2018-09-28 | |
5556660000 | SB | SXXX | 1.7 | KG | ST666777 | SB | 7010653652 | 2018-09-28 | |
5556660000 | EG | SXXX | 3 | ST | ST666777 | EG | 7010653652 | 2018-09-28 | |
5556660000 | ED | SXXX | 1 | ST | ST666777 | ED | 7010653652 | 2018-09-28 | |
5556660000 | RF | SXXX | 1 | ST | ST666777 | RF | 7010653652 | 2018-09-28 | |
5556660000 | ST666777-3 | 7010647357 | 2018-09-28 | ||||||
5556660000 | 5556660000-37000 | SXXX | 163.32 | M2 | ST666777 | 7010647357 | 2018-09-28 | ||
5556660000 | ARM | SXXX | 599.34 | KG | ST666777 | ARM | 7010647357 | 2018-09-28 | |
5556660000 | SB | SXXX | 20.6 | KG | ST666777 | SB | 7010647357 | 2018-09-28 | |
5556660000 | RF | SXXX | 62 | ST | ST666777 | RF | 7010647357 | 2018-09-28 | |
5556660000 | ED | SXXX | 21 | ST | ST666777 | ED | 7010647357 | 2018-09-28 | |
5556660000 | VMUF | SXXX | 3 | ST | ST666777 | VMUF | 7010647357 | 2018-09-28 | |
5556660000 | EG | SXXX | 14 | ST | ST666777 | EG | 7010647357 | 2018-09-28 | |
5556660000 | KF | SXXX | 2 | ST | ST666777 | KF | 7010647357 | 2018-09-28 | |
5556660000 | LB | SXXX | 12 | ST | ST666777 | LB | 7010647357 | 2018-09-28 | |
5556660000 | AD | SXXX | 5 | ST | ST666777 | AD | 7010647357 | 2018-09-28 | |
5556660000 | UM | SXXX | 5 | ST | ST666777 | UM | 7010647357 | 2018-09-28 | |
5556660000 | ELM | SXXX | 1 | ST | ST666777 | ELM | 7010647357 | 2018-09-28 | |
5556660000 | UFORM | SXXX | 1 | ST | ST666777 | UFORM | 7010647357 | 2018-09-28 | |
5556660000 | HY | SXXX | 19 | ST | ST666777 | HY | 7010647357 | 2018-09-28 | |
5556660000 | Skarvnät typ1 | SXXX | 4 | ST | ST666777 | Skarvnät typ1 | 7010647357 | 2018-09-28 | |
5556660000 | Skarvnät typ2 | SXXX | 5 | ST | ST666777 | Skarvnät typ2 | 7010647357 | 2018-09-28 | |
5556660000 | Skarvnät typ3 | SXXX | 7 | ST | ST666777 | Skarvnät typ3 | 7010647357 | 2018-09-28 | |
5556660000 | ST666777-2 | 7010646946 | 2018-09-28 | ||||||
5556660000 | 5556660000-37000 | SXXX | 170.19.00 | M2 | ST666777 | 7010646946 | 2018-09-28 | ||
5556660000 | ARM | SXXX | 843.54.00 | KG | ST666777 | ARM | 7010646946 | 2018-09-28 | |
5556660000 | SB | SXXX | 26.9 | KG | ST666777 | SB | 7010646946 | 2018-09-28 | |
5556660000 | UFORM | SXXX | 2 | ST | ST666777 | UFORM | 7010646946 | 2018-09-28 | |
5556660000 | LB | SXXX | 14 | ST | ST666777 | LB | 7010646946 | 2018-09-28 | |
5556660000 | RF | SXXX | 39 | ST | ST666777 | RF | 7010646946 | 2018-09-28 | |
5556660000 | AD | SXXX | 6 | ST | ST666777 | AD | 7010646946 | 2018-09-28 | |
5556660000 | BK | SXXX | 525 | M | ST666777 | BK | 7010646946 | 2018-09-28 | |
5556660000 | ED | SXXX | 2 | ST | ST666777 | ED | 7010646946 | 2018-09-28 | |
5556660000 | EG | SXXX | 5 | ST | ST666777 | EG | 7010646946 | 2018-09-28 | |
5556660000 | UM | SXXX | 4 | ST | ST666777 | UM | 7010646946 | 2018-09-28 | |
5556660000 | HY | SXXX | 13 | ST | ST666777 | HY | 7010646946 | 2018-09-28 | |
5556660000 | Skarvnät RF1 | SXXX | 4 | ST | ST666777 | Skarvnät RF1 | 7010646946 | 2018-09-28 | |
5556660000 | Skarvnät RF2 | SXXX | 5 | ST | ST666777 | Skarvnät RF2 | 7010646946 | 2018-09-28 | |
5556660000 | ST666777-1 | 7010641095 | 2018-09-28 | ||||||
5556660000 | 5556660000-37000 | SXXX | 265.11 | M2 | ST666777 | 7010641095 | 2018-09-28 | ||
5556660000 | ARM | SXXX | 1211.26 | KG | ST666777 | ARM | 7010641095 | 2018-09-28 | |
5556660000 | SB | SXXX | 39 | KG | ST666777 | SB | 7010641095 | 2018-09-28 | |
5556660000 | RF | SXXX | 52 | ST | ST666777 | RF | 7010641095 | 2018-09-28 | |
5556660000 | LB | SXXX | 19 | ST | ST666777 | LB | 7010641095 | 2018-09-28 | |
5556660000 | UFORM | SXXX | 5 | ST | ST666777 | UFORM | 7010641095 | 2018-09-28 | |
5556660000 | ED | SXXX | 6 | ST | ST666777 | ED | 7010641095 | 2018-09-28 | |
5556660000 | KF | SXXX | 4 | ST | ST666777 | KF | 7010641095 | 2018-09-28 | |
5556660000 | HY | SXXX | 40 | ST | ST666777 | HY | 7010641095 | 2018-09-28 |
Column Description
SAPOrderNbr, "ARM", string.Empty, plant, rcSumStr, "KG", transportProject, "ARM", deliveryNote, DateTime.Today.ToString( "yyyy-MM-dd" ) );
Transport Row
Sales Order Name, Empty, Empty, Empty, Empty, Empty, Empty, Project + "-" + Transport No, deliveryNote, DateTime.Today.ToString( "yyyy-MM-dd" ) );
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Sales Order Name | Empty | Empty | Empty | Empty | Empty | Empty | Project + "-" + Transport No | Delivery Note Id | Current Date |
Other Rows
Column No | Value Name | Alternative Value Name | Other Items | Comments |
1 | Sales Order Name "-" + Group + "000" | ItemNr1 | Description | Alternative is used if Sales Order Name is missing |
2 | ItemNr1 | Description | Empty | |
3 | Empty | |||
4 | External Factory Name (e.g. SXXX) | Defined in RM/Settings/Factories | ||
5 | Quantity | |||
6 | Unit | |||
7 | Project | |||
8 | ItemNr1 | Description | Empty | |
9 | Delivery Note Id | |||
10 | Current Date |
CIM Items for form slab (HHA) | |||||
Standard | Name | Description Impact | Description ERP - Sync | ||
1100 | 1121C | Bole-F 2/12/210 | |||
1100 | 1122B | RF_01 | RF | st | |
1100 | 1123B | RFP_02 | RFP | st | |
1100 | 1151A | LB_07 | LB | st | |
1100 | 1151B | LB_15 | LB | st | |
1100 | 1151D | LB_97 | LB | st | |
1100 | 1171B | SB-90 | SB | m | Converted to KG using IMP_CIM_STD.MASS (mass per meter) |
1100 | 1171C | SB-110 | SB | m | Converted to KG using IMP_CIM_STD.MASS (mass per meter) |
1100 | 1171D | SB-130 | SB | m | Converted to KG using IMP_CIM_STD.MASS (mass per meter) |
1100 | 1171E | SB-150 | SB | m | Converted to KG using IMP_CIM_STD.MASS (mass per meter) |
1100 | 1171F | SB-170 | SB | m | Converted to KG using IMP_CIM_STD.MASS (mass per meter) |
1100 | 1171G | SB-190 | SB | m | Converted to KG using IMP_CIM_STD.MASS (mass per meter) |
1100 | 1181A | ELM01 | ELM | st | |
1100 | 1181D | ELM03 | ELM | st | |
1100 | 1182A | ELD01 | ED | st | |
1100 | 1182B | ELD10 | ED | st | |
1100 | 1183A | ELD02 | ED | st | |
1100 | 1184A | DLB175-H | DLB | st | |
1100 | 1184B | DLB175 | DLB | st | |
1100 | 1185A | LB_01 | EG | st | |
1100 | 1185B | LB_01 | EG | st | |
1100 | 1185C | BAM16 | EG | st | |
1100 | 1185D | BAM16 | EG | st | |
1100 | 1192A | VR_01 | UM | st | |
1100 | 1192B | DR_01 | DR | st | |
1100 | 1192C | KBK1 | BK | st | |
1100 | 1192D | TB_01 | BK | st | |
1100 | 1192E | TB_02 | SX | st | |
1100 | 1192F | H-BAND | H-BAND | st | |
1100 | 1193A | HTH20 | HTH | st | |
1100 | 1193B | Schindler | HTH | st | |
1100 | 1194A | VS_04 | VS | st | |
1100 | 1194B | VS_05 | VS | st | |
1100 | 1195A | VS_10 | VMUF | st | |
1100 | 1195B | VS_06 | VMUF | st | |
1100 | 1195C | VS_07 | VMUF | st | |
1100 | 1195D | VS_08 | UFORM | st | |
1100 | 1195E | VS_09 | UFORM | st | |
1100 | 1195F | VS_11 | VMUF | st | |
1100 | 1197A | KFN-180 | KF | m | |
1100 | 1197B | KFN-190 | KF | m | |
1100 | 1197C | KFN-200 | KF | m | |
1100 | 1197D | KFN-210 | KF | m | |
1100 | 1197E | KFN-220 | KF | m | |
1100 | 1197F | KFN-230 | KF | m | |
1100 | 1197G | KFN-240 | KF | m | |
1100 | 1197H | KFN-250 | KF | m | |
1100 | 1197I | KFN-260 | KF | m | |
1100 | 1197J | KFN-270 | KF | m | |
1100 | 1197K | KFN-280 | KF | m | |
1100 | 1197L | KFN-290 | KF | m | |
1100 | 1197M | KFN-300 | KF | m | |
1100 | 1198A | KFT-250 | KF | m | |
1100 | 1199A | BA-180 | BA | m | |
1100 | 1199B | BA-200 | BA | m | |
1100 | 1199C | BA-220 | BA | m | |
1100 | 1199D | BA-240 | BA | m | |
1100 | 1199E | BA-250 | BA | m | |
1100 | 1199F | BA-280 | BA | m | |
1100 | 1199G | BA-300 | BA | m | |
Holes | HY | st |