ERP Delivery Export

Version 17.1 by Theib Sawaf on 2018/09/30 12:24

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

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.7MST666777SB70106536522018-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.6MST666777SB70106473572018-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.9MST666777SB70106469462018-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 SXXX39MST666777SB70106410952018-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
1Project   
2Sales Order Name "-" + Group + "000"ItemNr1DescriptionAlternative is used if Sales Order Name is missing
3Empty   
4Factory (e.g. SXXX)   
5Quantity   
6Unit   
7Project   
8ItemNr1 DescriptionEmpty
9Delivery Note Id   
10Current Date   
Tags:
Copyright 2024 StruSoft AB
IMPACT Wiki