Changes for page Inventory Export

Last modified by Theib Sawaf on 2018/10/03 20:41

From empty
To version 22.1
edited by Theib Sawaf
on 2018/10/03 20:41
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +Inventory Export
Parent
... ... @@ -1,0 +1,1 @@
1 +IMPACT Applications.Sync.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.XWikiGuest
1 +XWiki.TheibSawaf
Content
... ... @@ -1,0 +1,75 @@
1 +(% id="HFormat" %)
2 +== Format ==
3 +
4 +Text file, ".csv".
5 +
6 +(% id="HContents" %)
7 +== Contents ==
8 +
9 +The export file contains element in the storage, ie. produced but still not delivered yet.
10 +
11 +(% id="HConfiguration" %)
12 +== Configuration ==
13 +
14 + <add key="InventoryDirectory" value="C:\IMPACT\StruSoft\Inventory\Out" />
15 +
16 +(% id="HDetails" %)
17 +== Details ==
18 +
19 +(% class="wikigeneratedid" id="HHeader" %)
20 +There is 1 file for all the factories.
21 +
22 +(% class="wikigeneratedid" %)
23 +Filename = "Inventory_" + DateTime.Now.ToString( "yyyMMdd" ) + "_" + DateTime.Now.ToString( "HHmmss" ) + ".csv";
24 +The content of the export file is as follows (note that the line is a title row):
25 +
26 +|(% colspan="9" height="20" style="border-style:none; border-width:0px; height:15.0pt; padding-left:1px; padding-right:1px; padding-top:1px; vertical-align:bottom; white-space:nowrap; width:432pt" width="576" %)(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %)Standard;Project;ElementMark;ElementId;ElementType;Description;Area;Cost;Group;Product;ItemNo1;ItemNo2;PlannedDeliveryDate;ProductionDate;ProductionDivision;ProductionFactory;Stock;Type;
27 +|(% colspan="9" height="20" style="border-style:none; border-width:0px; height:15.0pt; padding-left:1px; padding-right:1px; padding-top:1px; vertical-align:bottom; white-space:nowrap" %)(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %)1101; 41446; W008;35;Sandwich;;1.615;(%%)20000(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %);331;W20;;;2018-04-02 00:00:00;2018-02-12 00:00:00;STR2_Hall2;(%%)StruFactory2(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %);;Order Product;
28 +|(% colspan="9" height="20" style="border-style:none; border-width:0px; height:15.0pt; padding-left:1px; padding-right:1px; padding-top:1px; vertical-align:bottom; white-space:nowrap" %)(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %)1101; 41446; W013;40;Sandwich;;1.955;30000;331;W20;;;2018-04-02 00:00:00;2018-02-09 00:00:00;STR2_Hall2;(%%)StruFactory2(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %);;Order Product;
29 +|(% colspan="9" height="20" style="border-style:none; border-width:0px; height:15.0pt; padding-left:1px; padding-right:1px; padding-top:1px; vertical-align:bottom; white-space:nowrap" %)(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %)1101; 41446; W005;43;Sandwich;;2.176;30000;331;W20;;;2018-04-02 00:00:00;2018-02-14 00:00:00;STR2_Hall2;(%%)StruFactory2(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %);;Order Product;
30 +|(% colspan="9" height="20" style="border-style:none; border-width:0px; height:15.0pt; padding-left:1px; padding-right:1px; padding-top:1px; vertical-align:bottom; white-space:nowrap" %)(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %)1101; 41446; W015;42;Sandwich;;4.4115;30000;331;W20;;;2018-04-02 00:00:00;2018-02-15 00:00:00;STR2_Hall2;(%%)StruFactory2(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %);;Order Product;
31 +|(% colspan="9" height="20" style="border-style:none; border-width:0px; height:15.0pt; padding-left:1px; padding-right:1px; padding-top:1px; vertical-align:bottom; white-space:nowrap" %)(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %)1101; 41446; W009;16;Sandwich;;5.1;30000;331;W20;;;2018-04-02 00:00:00;2018-02-19 00:00:00;STR2_Hall2;(%%)StruFactory2(% style="color:black; font-family:Calibri,sans-serif; font-size:11pt; font-style:normal; font-weight:400; text-decoration:none" %);;Order Product;
32 +
33 +(% class="wikigeneratedid" %)
34 +**Columns:**
35 +
36 +(% class="wikigeneratedid" %)
37 +Factory, Project, Element Mark, ElementId, Element Type, Description, Area, Cost, Element Group, Product, ItemNo1, ItemNo2, Planned Delivery Date, Production Date, Production Division, Production Factory, Storage Location, Order Type.
38 +
39 +(% class="wikigeneratedid" %)
40 +Below is an example in table form to show individual columns:
41 +
42 +|(% 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}" style="width:126px" %)14|(% data-sheets-value="{~"1~":3,~"3~":16}" style="width:80px" %)16|17|18|(% style="width:109px" %)19
43 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6018~"}" %)VI6018|(% data-sheets-value="{~"1~":3,~"3~":1013}" %)1013|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":69.1}" %)02.24|(% data-sheets-value="{~"1~":3,~"3~":20292}" %)20292|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-12 16:00~"}" %)2018-09-12 16:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-28 00:00~"}" style="width:126px" %)2018-08-28 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall2~"}" style="width:80px" %)Stru_Hall2|StruFactory| |(% style="width:109px" %)Order Product
44 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6009~"}" %)VI6009|(% data-sheets-value="{~"1~":3,~"3~":1018}" %)1018|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":7.510416666666667}" %)12.15|(% data-sheets-value="{~"1~":3,~"3~":20273}" %)20273|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-11 07:00~"}" %)2018-09-11 07:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-18 00:00~"}" style="width:126px" %)2018-08-18 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4 B~"}" style="width:80px" %)Stru_Hall4 B|StruFactory| |(% style="width:109px" %)Order Product
45 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6042~"}" %)VI6042|(% data-sheets-value="{~"1~":3,~"3~":1156}" %)1156|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"[hh].mm.ss~",1]" data-sheets-value="{~"1~":3,~"3~":4.045138888888889}" %)97.05.00|(% data-sheets-value="{~"1~":3,~"3~":24380}" %)24380|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-20 07:00~"}" %)2018-09-20 07:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-04 00:00~"}" style="width:126px" %)2018-09-04 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall2~"}" style="width:80px" %)Stru_Hall2|StruFactory| |(% style="width:109px" %)Order Product
46 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6004~"}" %)VI6004|(% data-sheets-value="{~"1~":3,~"3~":1021}" %)1021|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"[hh].mm.ss~",1]" data-sheets-value="{~"1~":3,~"3~":38.27708333333333}" %)918.39.00|(% data-sheets-value="{~"1~":3,~"3~":19324}" %)19324|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-10 16:00~"}" %)2018-09-10 16:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-21 00:00~"}" style="width:126px" %)2018-08-21 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4~"}" style="width:80px" %)Stru_Hall4|StruFactory| |(% style="width:109px" %)Order Product
47 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6016~"}" %)VI6016|(% data-sheets-value="{~"1~":3,~"3~":1015}" %)1015|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":4.741666666666666}" %)17.48|(% data-sheets-value="{~"1~":3,~"3~":21521}" %)21521|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-12 16:00~"}" %)2018-09-12 16:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-23 00:00~"}" style="width:126px" %)2018-08-23 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall2~"}" style="width:80px" %)Stru_Hall2|StruFactory| |(% style="width:109px" %)Order Product
48 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6011~"}" %)VI6011|(% data-sheets-value="{~"1~":3,~"3~":1016}" %)1016|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":4.741666666666666}" %)17.48|(% data-sheets-value="{~"1~":3,~"3~":21602}" %)21602|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-11 10:00~"}" %)2018-09-11 10:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-23 00:00~"}" style="width:126px" %)2018-08-23 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4~"}" style="width:80px" %)Stru_Hall4|StruFactory| |(% style="width:109px" %)Order Product
49 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6023~"}" %)VI6023|(% data-sheets-value="{~"1~":3,~"3~":1030}" %)1030|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":56.359722222222224}" %)08.38|(% data-sheets-value="{~"1~":3,~"3~":22023}" %)22023|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-18 09:30~"}" %)2018-09-18 09:30|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-31 00:00~"}" style="width:126px" %)2018-08-31 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4~"}" style="width:80px" %)Stru_Hall4|StruFactory| |(% style="width:109px" %)Order Product
50 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6002~"}" %)VI6002|(% data-sheets-value="{~"1~":3,~"3~":1023}" %)1023|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":6.322916666666667}" %)07.45|(% data-sheets-value="{~"1~":3,~"3~":21921}" %)21921|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-10 16:00~"}" %)2018-09-10 16:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-25 00:00~"}" style="width:126px" %)2018-08-25 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4 B~"}" style="width:80px" %)Stru_Hall4 B|StruFactory| |(% style="width:109px" %)Order Product
51 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6038~"}" %)VI6038|(% data-sheets-value="{~"1~":3,~"3~":1151}" %)1151|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.9347222222222222}" %)22.26|(% data-sheets-value="{~"1~":3,~"3~":22493}" %)22493|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-20 07:00~"}" %)2018-09-20 07:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-31 00:00~"}" style="width:126px" %)2018-08-31 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall2~"}" style="width:80px" %)Stru_Hall2|StruFactory| |(% style="width:109px" %)Order Product
52 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6026~"}" %)VI6026|(% data-sheets-value="{~"1~":3,~"3~":1003}" %)1003|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":21.424305555555556}" %)10.11|(% data-sheets-value="{~"1~":3,~"3~":21102}" %)21102|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000| |(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-18 11:00~"}" %)2018-09-18 11:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-06 00:00~"}" style="width:126px" %)2018-09-06 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4~"}" style="width:80px" %)Stru_Hall4|StruFactory| |(% style="width:109px" %)Order Product
53 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6022~"}" %)VI6022|(% data-sheets-value="{~"1~":3,~"3~":1029}" %)1029|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":10.519444444444444}" %)12.28|(% data-sheets-value="{~"1~":3,~"3~":24832}" %)24832|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-18 09:30~"}" %)2018-09-18 09:30|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-29 00:00~"}" style="width:126px" %)2018-08-29 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4~"}" style="width:80px" %)Stru_Hall4|StruFactory| |(% style="width:109px" %)Order Product
54 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6015~"}" %)VI6015|(% data-sheets-value="{~"1~":3,~"3~":1028}" %)1028|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":10.597916666666666}" %)14.21|(% data-sheets-value="{~"1~":3,~"3~":25008}" %)25008|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-12 14:00~"}" %)2018-09-12 14:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-27 00:00~"}" style="width:126px" %)2018-08-27 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall2~"}" style="width:80px" %)STR_Hall2|StruFactory| |(% style="width:109px" %)Order Product
55 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6001~"}" %)VI6001|(% data-sheets-value="{~"1~":3,~"3~":1022}" %)1022|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"[hh].mm.ss~",1]" data-sheets-value="{~"1~":3,~"3~":54.24444444444445}" %)1301.52.00|(% data-sheets-value="{~"1~":3,~"3~":25546}" %)25546|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-10 16:00~"}" %)2018-09-10 16:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-19 00:00~"}" style="width:126px" %)2018-08-19 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4 B~"}" style="width:80px" %)STR_Hall4 B|StruFactory| |(% style="width:109px" %)Order Product
56 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6013~"}" %)VI6013|(% data-sheets-value="{~"1~":3,~"3~":1026}" %)1026|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"[hh].mm.ss~",1]" data-sheets-value="{~"1~":3,~"3~":60.233333333333334}" %)1445.36.00|(% data-sheets-value="{~"1~":3,~"3~":28040}" %)28040|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-12 14:00~"}" %)2018-09-12 14:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-30 00:00~"}" style="width:126px" %)2018-08-30 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall2~"}" style="width:80px" %)STR_Hall2|StruFactory| |(% style="width:109px" %)Order Product
57 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6024~"}" %)VI6024|(% data-sheets-value="{~"1~":3,~"3~":1031}" %)1031|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":3.984722222222222}" %)23.38|(% data-sheets-value="{~"1~":3,~"3~":30157}" %)30157|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-18 09:30~"}" %)2018-09-18 09:30|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-02 00:00~"}" style="width:126px" %)2018-09-02 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4 B~"}" style="width:80px" %)STR_Hall4 B|StruFactory| |(% style="width:109px" %)Order Product
58 +|(% data-sheets-value="{~"1~":2,~"2~":~"AB01~"}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P74051903~"}" %)STR666555|(% data-sheets-value="{~"1~":2,~"2~":~"VI6003~"}" %)VI6003|(% data-sheets-value="{~"1~":3,~"3~":1024}" %)1024|(% data-sheets-value="{~"1~":2,~"2~":~"InsulatedWall~"}" %)InsulatedWall| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":55.52708333333333}" %)12.39|(% data-sheets-value="{~"1~":3,~"3~":30878}" %)30878|(% data-sheets-value="{~"1~":3,~"3~":336}" %)336|(% data-sheets-value="{~"1~":2,~"2~":~"VI29~"}" %)VI29|(% data-sheets-value="{~"1~":2,~"2~":~"1220051903-336000~"}" %)777788888-336000|(% data-sheets-value="{~"1~":3,~"3~":90326192}" %)90326192|(% data-sheets-value="{~"1~":2,~"2~":~"2018-09-10 16:00~"}" %)2018-09-10 16:00|(% data-sheets-value="{~"1~":2,~"2~":~"2018-08-17 00:00~"}" style="width:126px" %)2018-08-17 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"KVS_Hall4~"}" style="width:80px" %)STR_Hall4|StruFactory| |(% style="width:109px" %)Order Product
59 +|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P75037297~"}" %)STR33444|(% data-sheets-value="{~"1~":2,~"2~":~"P31501~"}" %)P31501|(% data-sheets-value="{~"1~":3,~"3~":3001}" %)3001|(% data-sheets-value="{~"1~":2,~"2~":~"Column~"}" %)Column| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.00625}" %)00.09|(% data-sheets-value="{~"1~":2,~"2~":~"3493.9~"}" %)3493.9|(% data-sheets-value="{~"1~":3,~"3~":321}" %)321|(% data-sheets-value="{~"1~":2,~"2~":~"RP 30/30~"}" %)RP 30/30| | |(% data-sheets-value="{~"1~":2,~"2~":~"2016-04-25 00:00~"}" %)2016-04-25 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"2016-04-07 00:00~"}" style="width:126px" %)2016-04-07 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"JST_Hall1~"}" style="width:80px" %)STR2_Hall1|StruFactory2| |(% style="width:109px" %)Order Product
60 +|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P75037297~"}" %)STR33444|(% data-sheets-value="{~"1~":2,~"2~":~"P31502~"}" %)P31502|(% data-sheets-value="{~"1~":3,~"3~":3002}" %)3002|(% data-sheets-value="{~"1~":2,~"2~":~"Column~"}" %)Column| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.00625}" %)00.09|(% data-sheets-value="{~"1~":2,~"2~":~"3493.9~"}" %)3493.9|(% data-sheets-value="{~"1~":3,~"3~":321}" %)321|(% data-sheets-value="{~"1~":2,~"2~":~"RP 30/30~"}" %)RP 30/30| | |(% data-sheets-value="{~"1~":2,~"2~":~"2016-04-25 00:00~"}" %)2016-04-25 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"2016-04-07 00:00~"}" style="width:126px" %)2016-04-07 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"JST_Hall1~"}" style="width:80px" %)STR2_Hall1|StruFactory2| |(% style="width:109px" %)Order Product
61 +|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P75037297~"}" %)STR33444|(% data-sheets-value="{~"1~":2,~"2~":~"P31301~"}" %)P31301|(% data-sheets-value="{~"1~":3,~"3~":2904}" %)2904|(% data-sheets-value="{~"1~":2,~"2~":~"Column~"}" %)Column| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.00625}" %)00.09|(% data-sheets-numberformat="[null,6,~"[hh].mm.ss~",1]" data-sheets-value="{~"1~":3,~"3~":149.21666666666667}" %)3581.12.00|(% data-sheets-value="{~"1~":3,~"3~":321}" %)321|(% data-sheets-value="{~"1~":2,~"2~":~"RP 30/30~"}" %)RP 30/30| | |(% data-sheets-value="{~"1~":2,~"2~":~"2016-03-21 00:00~"}" %)2016-03-21 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"2016-03-18 00:00~"}" style="width:126px" %)2016-03-18 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"JST_Hall1~"}" style="width:80px" %)STR2_Hall1|StruFactory2| |(% style="width:109px" %)Order Product
62 +|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P75037297~"}" %)STR33444|(% data-sheets-value="{~"1~":2,~"2~":~"P31302~"}" %)P31302|(% data-sheets-value="{~"1~":3,~"3~":2935}" %)2935|(% data-sheets-value="{~"1~":2,~"2~":~"Column~"}" %)Column| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.00625}" %)00.09|(% data-sheets-numberformat="[null,6,~"[hh].mm.ss~",1]" data-sheets-value="{~"1~":3,~"3~":149.21666666666667}" %)3581.12.00|(% data-sheets-value="{~"1~":3,~"3~":321}" %)321|(% data-sheets-value="{~"1~":2,~"2~":~"RP 30/30~"}" %)RP 30/30| | |(% data-sheets-value="{~"1~":2,~"2~":~"2016-03-21 00:00~"}" %)2016-03-21 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"2016-03-17 00:00~"}" style="width:126px" %)2016-03-17 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"JST_Hall1~"}" style="width:80px" %)STR2_Hall1|StruFactory2| |(% style="width:109px" %)Order Product
63 +|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P75037297~"}" %)STR33444|(% data-sheets-value="{~"1~":2,~"2~":~"E0012~"}" %)E0012|(% data-sheets-value="{~"1~":3,~"3~":560}" %)560|(% data-sheets-value="{~"1~":2,~"2~":~"Linked~"}" %)Linked| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.3388888888888889}" %)08.08|(% data-sheets-numberformat="[null,6,~"[hh].mm.ss~",1]" data-sheets-value="{~"1~":3,~"3~":294.475}" %)7067.24.00|(% data-sheets-value="{~"1~":3,~"3~":342}" %)342|(% data-sheets-value="{~"1~":2,~"2~":~"E~"}" %)E| | |(% data-sheets-value="{~"1~":2,~"2~":~"2015-09-22 00:00~"}" %)2015-09-22 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"2015-09-16 00:00~"}" style="width:126px" %)2015-09-16 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"JST_Hall1~"}" style="width:80px" %)STR2_Hall1|StruFactory2| |(% style="width:109px" %)Order Product
64 +|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P75037297~"}" %)STR33444|(% data-sheets-value="{~"1~":2,~"2~":~"E0002~"}" %)E0002|(% data-sheets-value="{~"1~":3,~"3~":117}" %)117|(% data-sheets-value="{~"1~":2,~"2~":~"Linked~"}" %)Linked| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.4152777777777778}" %)09.58|(% data-sheets-value="{~"1~":3,~"3~":8192}" %)8192|(% data-sheets-value="{~"1~":3,~"3~":342}" %)342| | | |(% data-sheets-value="{~"1~":2,~"2~":~"2015-06-29 00:00~"}" %)2015-06-29 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"2015-06-23 00:00~"}" style="width:126px" %)2015-06-23 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"JST_Hall1~"}" style="width:80px" %)STR2_Hall1|StruFactory2| |(% style="width:109px" %)Order Product
65 +|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P75037297~"}" %)STR33444|(% data-sheets-value="{~"1~":2,~"2~":~"E0003~"}" %)E0003|(% data-sheets-value="{~"1~":3,~"3~":118}" %)118|(% data-sheets-value="{~"1~":2,~"2~":~"Linked~"}" %)Linked| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.4152777777777778}" %)09.58|(% data-sheets-value="{~"1~":3,~"3~":8204}" %)8204|(% data-sheets-value="{~"1~":3,~"3~":342}" %)342| | | |(% data-sheets-value="{~"1~":2,~"2~":~"2015-06-29 00:00~"}" %)2015-06-29 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"2015-06-25 00:00~"}" style="width:126px" %)2015-06-25 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"JST_Hall1~"}" style="width:80px" %)STR2_Hall1|StruFactory2| |(% style="width:109px" %)Order Product
66 +|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P75037297~"}" %)STR33444|(% data-sheets-value="{~"1~":2,~"2~":~"E0001~"}" %)E0001|(% data-sheets-value="{~"1~":3,~"3~":113}" %)113|(% data-sheets-value="{~"1~":2,~"2~":~"Linked~"}" %)Linked| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.4152777777777778}" %)09.58|(% data-sheets-value="{~"1~":3,~"3~":9145}" %)9145|(% data-sheets-value="{~"1~":3,~"3~":342}" %)342| | | |(% data-sheets-value="{~"1~":2,~"2~":~"2015-06-29 00:00~"}" %)2015-06-29 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"2015-06-18 00:00~"}" style="width:126px" %)2015-06-18 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"JST_Hall1~"}" style="width:80px" %)STR2_Hall1|StruFactory2| |(% style="width:109px" %)Order Product
67 +|(% data-sheets-value="{~"1~":3,~"3~":8201}" %)1101|(% data-sheets-value="{~"1~":2,~"2~":~"P75037297~"}" %)STR33444|(% data-sheets-value="{~"1~":2,~"2~":~"E0001~"}" %)E0001|(% data-sheets-value="{~"1~":3,~"3~":114}" %)114|(% data-sheets-value="{~"1~":2,~"2~":~"Linked~"}" %)Linked| |(% data-sheets-numberformat="[null,6,~"hh.mm~",1]" data-sheets-value="{~"1~":3,~"3~":0.4152777777777778}" %)09.58|(% data-sheets-value="{~"1~":3,~"3~":9145}" %)9145|(% data-sheets-value="{~"1~":3,~"3~":342}" %)342| | | |(% data-sheets-value="{~"1~":2,~"2~":~"2015-06-29 00:00~"}" %)2015-06-29 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"2015-06-19 00:00~"}" style="width:126px" %)2015-06-19 00:00|(% data-sheets-value="{~"1~":2,~"2~":~"JST_Hall1~"}" style="width:80px" %)STR2_Hall1|StruFactory2| |(% style="width:109px" %)Order Product
68 +
69 +Inventory (Storage) in IMPACT Resource Managet
70 +
71 +Note that lines count in the RM/Storage should be the same as the IMPACT Sync Inventory export file.
72 +
73 +
74 +[[image:1538301321171-350.png]]
75 +
1537972109577-903.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.TheibSawaf
Size
... ... @@ -1,0 +1,1 @@
1 +175.0 KB
Content
1537972239527-551.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.TheibSawaf
Size
... ... @@ -1,0 +1,1 @@
1 +175.0 KB
Content
1537972557973-433.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.TheibSawaf
Size
... ... @@ -1,0 +1,1 @@
1 +97.7 KB
Content
1537972170154-897.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.TheibSawaf
Size
... ... @@ -1,0 +1,1 @@
1 +175.0 KB
Content
1537972224793-917.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.TheibSawaf
Size
... ... @@ -1,0 +1,1 @@
1 +175.0 KB
Content
1537972523603-244.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.TheibSawaf
Size
... ... @@ -1,0 +1,1 @@
1 +97.7 KB
Content
1537972180554-904.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.TheibSawaf
Size
... ... @@ -1,0 +1,1 @@
1 +175.0 KB
Content
1538301321171-350.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.TheibSawaf
Size
... ... @@ -1,0 +1,1 @@
1 +76.1 KB
Content
Copyright 2018 StruSoft AB
Impact Documentation