Show last authors
1 == Format ==
2
3 Text file, tab-separated values. Numer of columns is 22.
4
5 == Contents ==
6
7 The export file contains order products and stock items with status Produced.
8
9 After the export elements are signed as exported (IMP_CAST_PLANNING.Is_Reported1 = 1)
10
11 == Configuration ==
12
13 <!~-~- Exported file directories ~-~->
14 <add key="ERPProductionDirectory" value="C:\IMPACT\StruSoft\ERPProduction\Out" />
15
16 == Signing Exported Elements ==
17
18 After the production export, the following tables are updated
19
20 * IMP_CAST_PLANNING.IsReported1 is set to 1 (which means that the element is exported to SAP)
21 * IMP_ERRAND.Is_Reported1 is set to 1 if the element is rejected
22 * IMP_ELEMENT.ITEM_NR_1 is updated with the value: ProjectExternalName + "-" + IMP_ELEMENT.Element_Grp + "000"
23
24 == Details ==
25
26 When the export function is triggered, it generates 1 file per production factory.
27
28 The table IMP_ELEMENT_GRP_STD contains the units e.g. M2, TO, ST
29
30 Here is an example of how the file looks like.
31
32 File name: INT_SE97GoodsRcptDld_20150814_144811.txt
33
34 |(((
35 1220052979-37000   SEYE   1046   470   470   KG   PL2160   1220052979   2021-01-13   2021-01-13   1000   521   4.47   M2   0.7   X   SE97   01   SL010   P6000-764   1   0
36 1220052979-37000   SEYE   1076   510   510   KG   PL2149   1220052979   2021-01-13   2021-01-13   1000   521   5.02   M2   0.7   X   SE97   01   SL010   P6000-753   0   0
37 1220052979-37000   SEYE   1083   440   440   KG   PL2151   1220052979   2021-01-13   2021-01-13   1000   521   3.82   M2   0.7   X   SE97   01   SL010   P6000-755   0   0
38 1220052979-37000   SEYE   1134   490   490   KG   PL2146   1220052979   2021-01-13   2021-01-13   1000   521   4.18   M2   0.8   X   SE97   01   SL010   P6000-750   1   0
39 )))
40
41 Here is an example in table form to show individual columns:
42
43 |(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":3,~"3~":2}" %)2|(% data-sheets-value="{~"1~":3,~"3~":3}" %)3|(% data-sheets-value="{~"1~":3,~"3~":4}" %)4|(% data-sheets-value="{~"1~":3,~"3~":5}" %)5|(% data-sheets-value="{~"1~":3,~"3~":6}" %)6|(% data-sheets-value="{~"1~":3,~"3~":7}" %)7|(% data-sheets-value="{~"1~":3,~"3~":8}" %)8|(% data-sheets-value="{~"1~":3,~"3~":9}" %)9|(% data-sheets-value="{~"1~":3,~"3~":10}" %)10|(% data-sheets-value="{~"1~":3,~"3~":11}" %)11|(% data-sheets-value="{~"1~":3,~"3~":12}" %)12|(% data-sheets-value="{~"1~":3,~"3~":13}" %)13|(% data-sheets-value="{~"1~":3,~"3~":14}" %)14|(% data-sheets-value="{~"1~":3,~"3~":15}" %)15|(% data-sheets-value="{~"1~":3,~"3~":16}" %)16|(% data-sheets-value="{~"1~":3,~"3~":17}" %)17|(% data-sheets-value="{~"1~":3,~"3~":18}" %)18|(% data-sheets-value="{~"1~":3,~"3~":19}" %)19|(% data-sheets-value="{~"1~":3,~"3~":20}" %)20|(% data-sheets-value="{~"1~":3,~"3~":21}" %)21|(% data-sheets-value="{~"1~":3,~"3~":22}" %)22|(% data-sheets-value="{~"1~":3,~"3~":22}" %)23|(% data-sheets-value="{~"1~":3,~"3~":22}" %)24|(% data-sheets-value="{~"1~":3,~"3~":22}" %)25
44 |(% data-sheets-value="{~"1~":2,~"2~":~"1220052743-312000~"}" %)1220050000-312000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":11465}" %)11465|(% data-sheets-value="{~"1~":3,~"3~":4981}" %)4981|(% data-sheets-value="{~"1~":3,~"3~":4981}" %)4981|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"V61~"}" %)V61|(% data-sheets-value="{~"1~":3,~"3~":1220052743}" %)1220050000|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.6527777777777778}" %)15.40|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"13.8~"}" %)13.8|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
45 |(% data-sheets-value="{~"1~":2,~"2~":~"1220052743-312000~"}" %)1220050000-312000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":5043}" %)5043|(% data-sheets-value="{~"1~":3,~"3~":1485}" %)1485|(% data-sheets-value="{~"1~":3,~"3~":1485}" %)1485|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"V43~"}" %)V43|(% data-sheets-value="{~"1~":3,~"3~":1220052743}" %)1220050000|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.19236111111111112}" %)04.37|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"7.0~"}" %)7.0|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
46 |(% data-sheets-value="{~"1~":2,~"2~":~"1220052743-312000~"}" %)1220050000-312000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":7489}" %)7489|(% data-sheets-value="{~"1~":3,~"3~":2317}" %)2317|(% data-sheets-value="{~"1~":3,~"3~":2317}" %)2317|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"V245~"}" %)V245|(% data-sheets-value="{~"1~":3,~"3~":1220052743}" %)1220050000|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.34305555555555556}" %)08.14|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"10.0~"}" %)10.0|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
47 |(% data-sheets-value="{~"1~":2,~"2~":~"1220054859-332000~"}" %)1220050000-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":8378}" %)8378|(% data-sheets-value="{~"1~":3,~"3~":2917}" %)2917|(% data-sheets-value="{~"1~":3,~"3~":2917}" %)2917|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W12~"}" %)W12|(% data-sheets-value="{~"1~":3,~"3~":1220054859}" %)1220050000|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.3}" %)07.12|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"10.1~"}" %)10.1|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
48 |(% data-sheets-value="{~"1~":2,~"2~":~"1220054871-332000~"}" %)1220050000-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":10811}" %)10811|(% data-sheets-value="{~"1~":3,~"3~":2267}" %)2267|(% data-sheets-value="{~"1~":3,~"3~":2267}" %)2267|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W63~"}" %)W63|(% data-sheets-value="{~"1~":3,~"3~":1220054871}" %)1220050000|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.2659722222222222}" %)06.23|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"13.5~"}" %)13.5|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
49 |(% data-sheets-value="{~"1~":2,~"2~":~"1220054871-332000~"}" %)1220050000-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":9277}" %)9277|(% data-sheets-value="{~"1~":3,~"3~":4340}" %)4340|(% data-sheets-value="{~"1~":3,~"3~":4340}" %)4340|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W12~"}" %)W12|(% data-sheets-value="{~"1~":3,~"3~":1220054871}" %)1220050000|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.5215277777777778}" %)12.31|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"11.0~"}" %)11.0|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
50 |(% data-sheets-value="{~"1~":2,~"2~":~"1220054871-332000~"}" %)1220050000-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":9277}" %)9277|(% data-sheets-value="{~"1~":3,~"3~":4340}" %)4340|(% data-sheets-value="{~"1~":3,~"3~":4340}" %)4340|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W12~"}" %)W12|(% data-sheets-value="{~"1~":3,~"3~":1220054871}" %)1220050000|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.5215277777777778}" %)12.31|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"11.0~"}" %)11.0|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
51 |(% data-sheets-value="{~"1~":2,~"2~":~"1220054871-332000~"}" %)1220050000-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":9707}" %)9707|(% data-sheets-value="{~"1~":3,~"3~":3858}" %)3858|(% data-sheets-value="{~"1~":3,~"3~":3858}" %)3858|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W20~"}" %)W20|(% data-sheets-value="{~"1~":3,~"3~":1220054871}" %)1220050000|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.47291666666666665}" %)11.21|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"12.4~"}" %)12.4|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
52 |(% data-sheets-value="{~"1~":2,~"2~":~"1220054957-312000~"}" %)1220054957-312000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":13532}" %)13532|(% data-sheets-value="{~"1~":3,~"3~":6939}" %)6939|(% data-sheets-value="{~"1~":3,~"3~":6939}" %)6939|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"V12~"}" %)V12|(% data-sheets-value="{~"1~":3,~"3~":1220054957}" %)1220054957|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.8215277777777777}" %)19.43|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"13.5~"}" %)13.5|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
53 |(% data-sheets-value="{~"1~":2,~"2~":~"1220054957-332000~"}" %)1220054957-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":16325}" %)16325|(% data-sheets-value="{~"1~":3,~"3~":7005}" %)7005|(% data-sheets-value="{~"1~":3,~"3~":7005}" %)7005|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W17~"}" %)W17|(% data-sheets-value="{~"1~":3,~"3~":1220054957}" %)1220054957|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.8215277777777777}" %)19.43|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"17.6~"}" %)17.6|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
54 |(% data-sheets-value="{~"1~":2,~"2~":~"1220054957-332000~"}" %)1220054957-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":17106}" %)17106|(% data-sheets-value="{~"1~":3,~"3~":6995}" %)6995|(% data-sheets-value="{~"1~":3,~"3~":6995}" %)6995|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W18~"}" %)W18|(% data-sheets-value="{~"1~":3,~"3~":1220054957}" %)1220054957|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.8194444444444444}" %)19.40|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"19.1~"}" %)19.1|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
55 |(% data-sheets-value="{~"1~":2,~"2~":~"1220054957-332000~"}" %)1220054957-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":17983}" %)17983|(% data-sheets-value="{~"1~":3,~"3~":7843}" %)7843|(% data-sheets-value="{~"1~":3,~"3~":7843}" %)7843|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W12~"}" %)W12|(% data-sheets-value="{~"1~":3,~"3~":1220054957}" %)1220054957|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.9243055555555556}" %)22.11|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"19.6~"}" %)19.6|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
56 |(% data-sheets-value="{~"1~":2,~"2~":~"1220055036-332000~"}" %)1220055036-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":17614}" %)17614|(% data-sheets-value="{~"1~":3,~"3~":7219}" %)7219|(% data-sheets-value="{~"1~":3,~"3~":7219}" %)7219|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W12~"}" %)W12|(% data-sheets-value="{~"1~":3,~"3~":1220055036}" %)1220055036|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.81875}" %)19.39|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"19.6~"}" %)19.6|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
57 |(% data-sheets-value="{~"1~":2,~"2~":~"1220055036-332000~"}" %)1220055036-332000| |(% data-sheets-value="{~"1~":2,~"2~":~"SEYA~"}" %)SYYY|(% data-sheets-value="{~"1~":3,~"3~":18407}" %)18407|(% data-sheets-value="{~"1~":3,~"3~":7906}" %)7906|(% data-sheets-value="{~"1~":3,~"3~":7906}" %)7906|(% data-sheets-value="{~"1~":2,~"2~":~"KG~"}" %)KG| |(% data-sheets-value="{~"1~":2,~"2~":~"W15~"}" %)W15|(% data-sheets-value="{~"1~":3,~"3~":1220055036}" %)1220055036|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-numberformat="[null,5,~"yyyy-mm-dd~",1]" data-sheets-value="{~"1~":3,~"3~":43369}" %)2018-09-26|(% data-sheets-value="{~"1~":3,~"3~":1000}" %)1000|(% data-sheets-value="{~"1~":3,~"3~":521}" %)521| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.9375}" %)22.30|(% data-sheets-value="{~"1~":2,~"2~":~"M2~"}" %)M2|(% data-sheets-value="{~"1~":2,~"2~":~"20.3~"}" %)20.3|(% data-sheets-value="{~"1~":2,~"2~":~"X~"}" %)X|(% data-sheets-value="{~"1~":2,~"2~":~"SE97~"}" %)SE97|(% data-sheets-value="{~"1~":3,~"3~":1}" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)SL010|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)P6000-764|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0|(% data-sheets-value="{~"1~":2,~"2~":~"SL010~"}" %)0
58
59 == Column Description ==
60
61 (% border="1" cellpadding="0" cellspacing="0" dir="ltr" style="width:1074px" %)
62 |(% data-sheets-value="{~"1~":2,~"2~":~"Column No~"}" style="width:112px" %)Column No|(% data-sheets-value="{~"1~":2,~"2~":~"Name~"}" style="width:145px" %)Name|(% data-sheets-value="{~"1~":2,~"2~":~"Comments~"}" style="width:389px" %)Ordered Products|(% data-sheets-value="{~"1~":2,~"2~":~"Comments~"}" style="width:389px" %) |(% data-sheets-value="{~"1~":2,~"2~":~"Comments~"}" style="width:433px" %)Stock Items
63 |(% data-sheets-value="{~"1~":3,~"3~":1}" style="width:112px" %)1|(% data-sheets-value="{~"1~":2,~"2~":~"Old Material~"}" style="width:145px" %)Old Material|(% style="width:389px" %)Sales Order Name + "-" + Element Group + "000"|(% style="width:389px" %) |(% style="width:433px" %)Sales Order Name
64 |(% data-sheets-value="{~"1~":3,~"3~":2}" style="width:112px" %)2|(% data-sheets-value="{~"1~":2,~"2~":~"Material~"}" style="width:145px" %)Material|(% style="width:389px" %)Empty|(% style="width:389px" %) |(% style="width:433px" %)Empty
65 |(% data-sheets-value="{~"1~":3,~"3~":3}" style="width:112px" %)3|(% data-sheets-value="{~"1~":2,~"2~":~"Plant~"}" style="width:145px" %)Plant|(% style="width:389px" %)Externa Factory Name (RM/Settings/Factories)|(% style="width:389px" %) |(% style="width:433px" %)Externa Factory Name (RM/Settings/Factories)
66 |(% data-sheets-value="{~"1~":3,~"3~":4}" style="width:112px" %)4|(% data-sheets-value="{~"1~":2,~"2~":~"Price~"}" style="width:145px" %)Price|(% style="width:389px" %)Price|(% style="width:389px" %) |(% style="width:433px" %)0
67 |(% data-sheets-value="{~"1~":3,~"3~":5}" style="width:112px" %)5|(% data-sheets-value="{~"1~":2,~"2~":~"Gross Weight~"}" style="width:145px" %)Gross Weight|(% style="width:389px" %)Element Mass (KG)|(% style="width:389px" %) |(% style="width:433px" %)0
68 |(% data-sheets-value="{~"1~":3,~"3~":6}" style="width:112px" %)6|(% data-sheets-value="{~"1~":2,~"2~":~"Net Weight~"}" style="width:145px" %)Net Weight|(% style="width:389px" %)Element Mass (KG)|(% style="width:389px" %) |(% style="width:433px" %)0
69 |(% data-sheets-value="{~"1~":3,~"3~":7}" style="width:112px" %)7|(% data-sheets-value="{~"1~":2,~"2~":~"Unit Of Weight~"}" style="width:145px" %)Unit Of Weight|(% style="width:389px" %)KG|(% style="width:389px" %) |(% style="width:433px" %)KG
70 |(% data-sheets-value="{~"1~":3,~"3~":8}" style="width:112px" %)8|(% data-sheets-value="{~"1~":2,~"2~":~"Wbs Element~"}" style="width:145px" %)Wbs Element|(% style="width:389px" %)Empty|(% style="width:389px" %) |(% style="width:433px" %)Empty
71 |(% data-sheets-value="{~"1~":3,~"3~":9}" style="width:112px" %)9|(% data-sheets-value="{~"1~":2,~"2~":~"Postition1~"}" style="width:145px" %)Position|(% style="width:389px" %)Element Mark|(% style="width:389px" %) |(% style="width:433px" %)Element Mark
72 |(% data-sheets-value="{~"1~":3,~"3~":10}" style="width:112px" %)10|(% data-sheets-value="{~"1~":2,~"2~":~"SAP Order Nbr~"}" style="width:145px" %)ERP Order Nbr|(% style="width:389px" %)Sales Order Name (PM/Properties)|(% style="width:389px" %) |(% style="width:433px" %)Sales Order Name (PM/Properties)
73 |(% data-sheets-value="{~"1~":3,~"3~":11}" style="width:112px" %)11|(% data-sheets-value="{~"1~":2,~"2~":~"Posting Date~"}" style="width:145px" %)Posting Date|(% style="width:389px" %)Export Date|(% style="width:389px" %) |(% style="width:433px" %)Export Date
74 |(% data-sheets-value="{~"1~":3,~"3~":12}" style="width:112px" %)12|(% data-sheets-value="{~"1~":2,~"2~":~"Document Date~"}" style="width:145px" %)Document Date|(% style="width:389px" %)Export Date|(% style="width:389px" %) |(% style="width:433px" %)Export Date
75 |(% data-sheets-value="{~"1~":3,~"3~":13}" style="width:112px" %)13|(% data-sheets-value="{~"1~":2,~"2~":~"Storage Location~"}" style="width:145px" %)Storage Location|(% style="width:389px" %)1000 (Hard coded)|(% style="width:389px" %) |(% style="width:433px" %)1000 (Hard coded)
76 |(% data-sheets-value="{~"1~":3,~"3~":14}" style="width:112px" %)14|(% data-sheets-value="{~"1~":2,~"2~":~"Move Type~"}" style="width:145px" %)Move Type|(% style="width:389px" %)CODE 521: Element is neither rejected not reported
77 CODE 551: Element is reported ans rejected but not reported as rejected|(% style="width:389px" %) |(% style="width:433px" %)521 (Hard coded)
78 |(% data-sheets-value="{~"1~":3,~"3~":15}" style="width:112px" %)15|(% data-sheets-value="{~"1~":2,~"2~":~"Spec Stock~"}" style="width:145px" %)Spec Stock|(% style="width:389px" %)Empty|(% style="width:389px" %) |(% style="width:433px" %)Empty
79 |(% data-sheets-value="{~"1~":3,~"3~":16}" style="width:112px" %)16|(% data-sheets-value="{~"1~":2,~"2~":~"Entry Quntity~"}" style="width:145px" %)Entry Quantity|(% style="width:389px" %)See table below|(% style="width:389px" %) |(% style="width:433px" %)Count
80 |(% data-sheets-value="{~"1~":3,~"3~":17}" style="width:112px" %)17|(% data-sheets-value="{~"1~":2,~"2~":~"Unit Of Entry~"}" style="width:145px" %)Unit Of Entry|(% style="width:389px" %)IMP_ELEMENT_GRP_STD.UNIT|(% style="width:389px" %) |(% style="width:433px" %)ST (Hard coded)
81 |(% data-sheets-value="{~"1~":3,~"3~":18}" style="width:112px" %)18|(% data-sheets-value="{~"1~":2,~"2~":~"Max Lot Size~"}" style="width:145px" %)Max Lot Size|(% style="width:389px" %)Production Time (Cost.ElementTotalTime.TotalTime)|(% style="width:389px" %) |(% style="width:433px" %)Production Time (Cost.ElementTotalTime.TotalTime)
82 |(% data-sheets-value="{~"1~":3,~"3~":19}" style="width:112px" %)19|(% data-sheets-value="{~"1~":2,~"2~":~"Zzlit1~"}" style="width:145px" %)Zzlit1|(% style="width:389px" %)X|(% style="width:389px" %) |(% style="width:433px" %)Empty
83 |(% data-sheets-value="{~"1~":3,~"3~":20}" style="width:112px" %)20|(% data-sheets-value="{~"1~":2,~"2~":~"Sales Orgasition~"}" style="width:145px" %)Sales Organisation|(% style="width:389px" %)SE97|(% style="width:389px" %) |(% style="width:433px" %)Empty
84 |(% data-sheets-value="{~"1~":3,~"3~":21}" style="width:112px" %)21|(% data-sheets-value="{~"1~":2,~"2~":~"Distribution Channel~"}" style="width:145px" %)Distribution Channel|(% style="width:389px" %)01|(% style="width:389px" %) |(% style="width:433px" %)Empty
85 |(% data-sheets-value="{~"1~":3,~"3~":22}" style="width:112px" %)22|(% data-sheets-value="{~"1~":2,~"2~":~"Process~"}" style="width:145px" %)Process|(% style="width:389px" %)SL010|(% style="width:389px" %) |(% style="width:433px" %)Empty
86 |(% data-sheets-value="{~"1~":3,~"3~":22}" style="width:112px" %)23|(% data-sheets-value="{~"1~":2,~"2~":~"Process~"}" style="width:145px" %)Identifier|(% style="width:389px" %) |(% style="width:389px" %) |(% style="width:433px" %)
87 |(% data-sheets-value="{~"1~":3,~"3~":22}" style="width:112px" %)24|(% data-sheets-value="{~"1~":2,~"2~":~"Process~"}" style="width:145px" %)Main Reinforcement above limit|(% style="width:389px" %)KG|(% style="width:389px" %) |(% style="width:433px" %)KG
88 |(% data-sheets-value="{~"1~":3,~"3~":22}" style="width:112px" %)25|(% data-sheets-value="{~"1~":2,~"2~":~"Process~"}" style="width:145px" %)Lattice Girder above limit|(% style="width:389px" %)KG|(% style="width:389px" %) |(% style="width:433px" %)KG
89
90 == Unit Quantity Table ==
91
92 The element group unit defined in the database (IMP_ELEMENT_GRP_STD) decides what element quantity should be used, see the table below.
93
94 (% style="width:294px" %)
95 |(% style="width:93px" %)UNIT|(% style="width:200px" %)Quantity
96 |(% style="width:93px" %)M2,|(% style="width:200px" %)Area
97 |(% style="width:93px" %)TO|(% style="width:200px" %)Mass
98 |(% style="width:93px" %)ST|(% style="width:200px" %)Count
Copyright 2020 StruSoft AB
IMPACT Documentation