ERP Delivery Export

Version 22.1 by Theib Sawaf on 2018/10/05 15:50

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
1Main10IssueERPDeliveryDirectoryDeliveryBoundingBoxArea,Mass,elementGroups,Mark, ItemNr1
Additional Items
Stock Items: ItemNr1, Count, ST,ElementMark
CIM Items: cimName, Count
Other Items: Count,ST, plant
 
2Cim And Other Items22RcptERPProductionDirectoryProductionAdditionalItems: Cim and other Items (Mass, Count, ST, Name/Description)
3Special Delivery Export (HHA)10IssueERPDeliveryDirectoryDeliveryBoundingBoxArea, 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.

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 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.

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:
Copyright 2024 StruSoft AB
IMPACT Wiki