ERP Delivery Export

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

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

NoNameNo Of ColumnsSymbolDirectoryTypeContents
1Main10IssueERPDeliveryDirectoryDeliveryBounding Box Area, Mass, Element groups, Element Mark, ItemNr1, Additional Items
Stock Items: ItemNr1, Count, ST, Element Mark
CIM Items: Cim Name, Count
Other Items: Count, ST, Production Factory External Name
 
2Cim And Other Items22RcptERPProductionDirectoryProductionAdditional Items: Cim and other Items (Mass, Count, ST, Name/Description)
3Special Delivery Export (HHA)10IssueERPDeliveryDirectoryDeliveryBounding Box Area, Reinforcement Mass, ItemNr1, Quantity, Hole Count, other Items (Mass, Count, ST, Description)

Main Delivery Export To ERP System

Below is an example in table form to show individual columns.

12345678910
12200400001220040000-37000 SXXX11.03M2S888666PL1300670106400002018-09-28
12200400001220040000-37000 SXXX17.04M2S888666PL1301270106400002018-09-28
12200400001220040000-37000 SXXX17.04M2S888666PL1301370106400002018-09-28
12200400001220040000-37000 SXXX18.07M2S888666PL1300770106400002018-09-28
12200400001220040000-37000 SXXX18.15M2S888666PL1300870106400002018-09-28
12200400001220040000-37000 SXXX06.26M2S888666PL1301170106400002018-09-28
12200400001220040000-37000 SXXX07.00M2S888666PL1300570106400002018-09-28
12200400001220040000-37000 SXXX08.09M2S888666PL1301070106400002018-09-28
12200400001220040000-37000 SXXX08.02M2S888666PL1300970106400002018-09-28
12200400001220040000-37000 SXXX09.30M2S888666PL1301470106400002018-09-28
12200400001220040000-550000 SXXX7STS888666Other Item70106400002018-09-28
1220040000FLX4107 SXXX1STS888666FLX410770106400002018-09-28
1220040000FLX4108 SXXX1STS888666FLX410870106400002018-09-28

Column Description

Column NoValue NameStock ItemOther ItemsCIM
1Sales Order Name   
2Sales Order Name "-" + GroupItemNr1Sales Order Name + "-550000"CimName
3Empty   
4Factory (e.g. SXXX)   
5Quantity   
6Unit   
7Project   
8Element Mark/ItemNr1 DescriptionEmpty
9Delivery Note Id   
10Current Date   

Cim And Other Items

Below is an example in table form to show individual columns.

12345678910111213141516171819202122
0103B SXXX000KG 0103B55566600002018-09-282018-09-281000521 1ST0    
0103C SXXX000KG 0103C55566600002018-09-282018-09-281000521 1ST0    
0104C SXXX000KG 0104C 2018-09-282018-09-281000521 1ST0    
0104D SXXX000KG 0104D 2018-09-282018-09-281000521 1ST0    
5556660000-550000 SXXX40020002000KG Skarvnät RF155566600002018-09-282018-09-281000521 4ST0XSE9701SL010
5556660000-550000 SXXX50030003000KG Skarvnät typ155566600002018-09-282018-09-281000521 4ST0XSE9701SL010
5556660000-550000 SXXX60030003000KG Skarvnät RF255566600002018-09-282018-09-281000521 5ST0XSE9701SL010
5556660000-550000 SXXX80040004000KG Skarvnät typ255566600002018-09-282018-09-281000521 5ST0XSE9701SL010
5556660000-550000 SXXX90020002000KG Skarvnät typ355566600002018-09-282018-09-281000521 7ST0XSE9701SL010

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 NoNameCIMOther 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
9PositionCIM NameDescription
10SAP Order NbrEmptySales 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 Size00
19Zzlit1XEmpty
20Sales OrganisationSE97Empty
21Distribution Channel01Empty
22ProcessSL010Empty

Special Delivery Export To ERP System

The exported file contains the following information for each transport:

  • 1 transport row
  • 1 transport elements bounding box area (M2) row
  • 1 transport elements reinforcement mass (KG) row
  • CIM information rows
  • Number of holes (ST) row
  • Additional Items/Other Items rows

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.

12345678910
5556660000      ST666777-470106536522018-09-28
5556660000

5556660000-37000

 SXXX14.27M2

ST666777

 70106536522018-09-28
5556660000

ARM

 SXXX64.01KGST666777ARM70106536522018-09-28
5556660000SB SXXX1.7KGST666777SB70106536522018-09-28
5556660000EG SXXX3STST666777EG70106536522018-09-28
5556660000ED SXXX1STST666777ED70106536522018-09-28
5556660000RF SXXX1STST666777RF70106536522018-09-28
5556660000      ST666777-370106473572018-09-28
5556660000

5556660000-37000

 SXXX163.32M2

ST666777

 70106473572018-09-28
5556660000

ARM

 SXXX599.34KGST666777ARM70106473572018-09-28
5556660000SB SXXX20.6KGST666777SB70106473572018-09-28
5556660000RF SXXX62STST666777RF70106473572018-09-28
5556660000ED SXXX21STST666777ED70106473572018-09-28
5556660000

VMUF

 SXXX3STST666777VMUF70106473572018-09-28
5556660000EG SXXX14STST666777EG70106473572018-09-28
5556660000KF SXXX2STST666777KF70106473572018-09-28
5556660000LB SXXX12STST666777LB70106473572018-09-28
5556660000AD SXXX5STST666777AD70106473572018-09-28
5556660000

UM

 SXXX5STST666777UM70106473572018-09-28
5556660000

ELM

 SXXX1STST666777ELM70106473572018-09-28
5556660000

UFORM

 SXXX1STST666777UFORM70106473572018-09-28
5556660000HY SXXX19STST666777HY70106473572018-09-28
5556660000

Skarvnät typ1

 SXXX4STST666777Skarvnät typ170106473572018-09-28
5556660000

Skarvnät typ2

 SXXX5STST666777Skarvnät typ270106473572018-09-28
5556660000

Skarvnät typ3

 SXXX7STST666777Skarvnät typ370106473572018-09-28
5556660000      ST666777-270106469462018-09-28
5556660000

5556660000-37000

 SXXX170.19.00M2

ST666777

 70106469462018-09-28
5556660000

ARM

 SXXX843.54.00KGST666777ARM70106469462018-09-28
5556660000SB SXXX26.9KGST666777SB70106469462018-09-28
5556660000

UFORM

 SXXX2STST666777UFORM70106469462018-09-28
5556660000LB SXXX14STST666777LB70106469462018-09-28
5556660000RF SXXX39STST666777RF70106469462018-09-28
5556660000AD SXXX6STST666777AD70106469462018-09-28
5556660000BK SXXX525MST666777BK70106469462018-09-28
5556660000ED SXXX2STST666777ED70106469462018-09-28
5556660000EG SXXX5STST666777EG70106469462018-09-28
5556660000

UM

 SXXX4STST666777UM70106469462018-09-28
5556660000HY SXXX13STST666777HY70106469462018-09-28
5556660000

Skarvnät RF1

 SXXX4STST666777Skarvnät RF170106469462018-09-28
5556660000

Skarvnät RF2

 SXXX5STST666777Skarvnät RF270106469462018-09-28
5556660000      ST666777-170106410952018-09-28
5556660000

5556660000-37000

 SXXX265.11M2

ST666777

 70106410952018-09-28
5556660000

ARM

 SXXX1211.26KGST666777ARM70106410952018-09-28
5556660000SB SXXX39KGST666777SB70106410952018-09-28
5556660000RF SXXX52STST666777RF70106410952018-09-28
5556660000LB SXXX19STST666777LB70106410952018-09-28
5556660000

UFORM

 SXXX5STST666777UFORM70106410952018-09-28
5556660000ED SXXX6STST666777ED70106410952018-09-28
5556660000KF SXXX4STST666777KF70106410952018-09-28
5556660000HY SXXX40STST666777HY70106410952018-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" ) );

12345678910
Sales Order NameEmptyEmptyEmptyEmptyEmptyEmptyProject + "-" + Transport NoDelivery Note IdCurrent Date 

Other Rows

Column NoValue NameAlternative Value NameOther ItemsComments
1Sales Order Name "-" + Group + "000"ItemNr1DescriptionAlternative is used if Sales Order Name is missing
2ItemNr1 DescriptionEmpty
3Empty   
4External Factory Name (e.g. SXXX)  Defined in RM/Settings/Factories
5Quantity   
6Unit   
7Project   
8ItemNr1 DescriptionEmpty
9Delivery Note Id   
10Current Date   
CIM Items for form slab (HHA)     
StandardNameDescription ImpactDescription ERP - Sync  
11001121CBole-F 2/12/210   
11001122BRF_01RFst 
11001123BRFP_02RFPst 
11001151ALB_07LBst 
11001151BLB_15LBst 
11001151DLB_97LBst 
11001171BSB-90SBmConverted to KG using IMP_CIM_STD.MASS (mass per meter)
11001171CSB-110SBmConverted to KG using IMP_CIM_STD.MASS (mass per meter)
11001171DSB-130SBmConverted to KG using IMP_CIM_STD.MASS (mass per meter)
11001171ESB-150SBmConverted to KG using IMP_CIM_STD.MASS (mass per meter)
11001171FSB-170SBmConverted to KG using IMP_CIM_STD.MASS (mass per meter)
11001171GSB-190SBmConverted to KG using IMP_CIM_STD.MASS (mass per meter)
11001181AELM01ELMst 
11001181DELM03ELMst 
11001182AELD01EDst 
11001182BELD10EDst 
11001183AELD02EDst 
11001184ADLB175-HDLBst 
11001184BDLB175DLBst 
11001185ALB_01EGst 
11001185BLB_01EGst 
11001185CBAM16EGst 
11001185DBAM16EGst 
11001192AVR_01UMst 
11001192BDR_01DRst 
11001192CKBK1BKst 
11001192DTB_01BKst 
11001192ETB_02SXst 
11001192FH-BANDH-BANDst 
11001193AHTH20HTHst 
11001193BSchindlerHTHst 
11001194AVS_04VSst 
11001194BVS_05VSst 
11001195AVS_10VMUFst 
11001195BVS_06VMUFst 
11001195CVS_07VMUFst 
11001195DVS_08UFORMst 
11001195EVS_09UFORMst 
11001195FVS_11VMUFst 
11001197AKFN-180KFm 
11001197BKFN-190KFm 
11001197CKFN-200KFm 
11001197DKFN-210KFm 
11001197EKFN-220KFm 
11001197FKFN-230KFm 
11001197GKFN-240KFm 
11001197HKFN-250KFm 
11001197IKFN-260KFm 
11001197JKFN-270KFm 
11001197KKFN-280KFm 
11001197LKFN-290KFm 
11001197MKFN-300KFm 
11001198AKFT-250KFm 
11001199ABA-180BAm 
11001199BBA-200BAm 
11001199CBA-220BAm 
11001199DBA-240BAm 
11001199EBA-250BAm 
11001199FBA-280BAm 
11001199GBA-300BAm 
  HolesHYst 
Tags:
Created by Theib Sawaf on 2018/09/28 08:34
Copyright 2018 StruSoft AB
Impact Documentation