Inventory Export
Format
Text file, ".csv".
Contents
The export file contains element in the storage, ie. produced but still not delivered yet.
Configuration
<add key="InventoryDirectory" value="C:\IMPACT\StruSoft\Inventory\Out" />
Details
There is 1 file for all the factories.
Filename = "Inventory_" + DateTime.Now.ToString( "yyyMMdd" ) + "_" + DateTime.Now.ToString( "HHmmss" ) + ".csv";
The content of the export file is as follows (note that the line is a title row):
Standard;Project;ElementMark;ElementId;ElementType;Description;Area;Cost;Group;Product;ItemNo1;ItemNo2;PlannedDeliveryDate;ProductionDate;ProductionDivision;ProductionFactory;Stock;Type; | ||||||||
1101; 41446; W008;35;Sandwich;;1.615;20000;331;W20;;;2018-04-02 00:00:00;2018-02-12 00:00:00;STR2_Hall2;StruFactory2;;Order Product; | ||||||||
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;;Order Product; | ||||||||
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;;Order Product; | ||||||||
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;;Order Product; | ||||||||
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;;Order Product; |
Columns:
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.
Below is an example in table form to show individual columns:
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 16 | 17 | 18 | 19 |
1101 | STR666555 | VI6018 | 1013 | InsulatedWall | 02.24 | 20292 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-12 16:00 | 2018-08-28 00:00 | Stru_Hall2 | StruFactory | Order Product | ||
1101 | STR666555 | VI6009 | 1018 | InsulatedWall | 12.15 | 20273 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-11 07:00 | 2018-08-18 00:00 | Stru_Hall4 B | StruFactory | Order Product | ||
1101 | STR666555 | VI6042 | 1156 | InsulatedWall | 97.05.00 | 24380 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-20 07:00 | 2018-09-04 00:00 | Stru_Hall2 | StruFactory | Order Product | ||
1101 | STR666555 | VI6004 | 1021 | InsulatedWall | 918.39.00 | 19324 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-10 16:00 | 2018-08-21 00:00 | Stru_Hall4 | StruFactory | Order Product | ||
1101 | STR666555 | VI6016 | 1015 | InsulatedWall | 17.48 | 21521 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-12 16:00 | 2018-08-23 00:00 | Stru_Hall2 | StruFactory | Order Product | ||
1101 | STR666555 | VI6011 | 1016 | InsulatedWall | 17.48 | 21602 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-11 10:00 | 2018-08-23 00:00 | Stru_Hall4 | StruFactory | Order Product | ||
1101 | STR666555 | VI6023 | 1030 | InsulatedWall | 08.38 | 22023 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-18 09:30 | 2018-08-31 00:00 | Stru_Hall4 | StruFactory | Order Product | ||
1101 | STR666555 | VI6002 | 1023 | InsulatedWall | 07.45 | 21921 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-10 16:00 | 2018-08-25 00:00 | Stru_Hall4 B | StruFactory | Order Product | ||
1101 | STR666555 | VI6038 | 1151 | InsulatedWall | 22.26 | 22493 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-20 07:00 | 2018-08-31 00:00 | Stru_Hall2 | StruFactory | Order Product | ||
1101 | STR666555 | VI6026 | 1003 | InsulatedWall | 10.11 | 21102 | 336 | VI29 | 777788888-336000 | 2018-09-18 11:00 | 2018-09-06 00:00 | Stru_Hall4 | StruFactory | Order Product | |||
1101 | STR666555 | VI6022 | 1029 | InsulatedWall | 12.28 | 24832 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-18 09:30 | 2018-08-29 00:00 | Stru_Hall4 | StruFactory | Order Product | ||
1101 | STR666555 | VI6015 | 1028 | InsulatedWall | 14.21 | 25008 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-12 14:00 | 2018-08-27 00:00 | STR_Hall2 | StruFactory | Order Product | ||
1101 | STR666555 | VI6001 | 1022 | InsulatedWall | 1301.52.00 | 25546 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-10 16:00 | 2018-08-19 00:00 | STR_Hall4 B | StruFactory | Order Product | ||
1101 | STR666555 | VI6013 | 1026 | InsulatedWall | 1445.36.00 | 28040 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-12 14:00 | 2018-08-30 00:00 | STR_Hall2 | StruFactory | Order Product | ||
1101 | STR666555 | VI6024 | 1031 | InsulatedWall | 23.38 | 30157 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-18 09:30 | 2018-09-02 00:00 | STR_Hall4 B | StruFactory | Order Product | ||
1101 | STR666555 | VI6003 | 1024 | InsulatedWall | 12.39 | 30878 | 336 | VI29 | 777788888-336000 | 90326192 | 2018-09-10 16:00 | 2018-08-17 00:00 | STR_Hall4 | StruFactory | Order Product | ||
1101 | STR33444 | P31501 | 3001 | Column | 00.09 | 3493.9 | 321 | RP 30/30 | 2016-04-25 00:00 | 2016-04-07 00:00 | STR2_Hall1 | StruFactory2 | Order Product | ||||
1101 | STR33444 | P31502 | 3002 | Column | 00.09 | 3493.9 | 321 | RP 30/30 | 2016-04-25 00:00 | 2016-04-07 00:00 | STR2_Hall1 | StruFactory2 | Order Product | ||||
1101 | STR33444 | P31301 | 2904 | Column | 00.09 | 3581.12.00 | 321 | RP 30/30 | 2016-03-21 00:00 | 2016-03-18 00:00 | STR2_Hall1 | StruFactory2 | Order Product | ||||
1101 | STR33444 | P31302 | 2935 | Column | 00.09 | 3581.12.00 | 321 | RP 30/30 | 2016-03-21 00:00 | 2016-03-17 00:00 | STR2_Hall1 | StruFactory2 | Order Product | ||||
1101 | STR33444 | E0012 | 560 | Linked | 08.08 | 7067.24.00 | 342 | E | 2015-09-22 00:00 | 2015-09-16 00:00 | STR2_Hall1 | StruFactory2 | Order Product | ||||
1101 | STR33444 | E0002 | 117 | Linked | 09.58 | 8192 | 342 | 2015-06-29 00:00 | 2015-06-23 00:00 | STR2_Hall1 | StruFactory2 | Order Product | |||||
1101 | STR33444 | E0003 | 118 | Linked | 09.58 | 8204 | 342 | 2015-06-29 00:00 | 2015-06-25 00:00 | STR2_Hall1 | StruFactory2 | Order Product | |||||
1101 | STR33444 | E0001 | 113 | Linked | 09.58 | 9145 | 342 | 2015-06-29 00:00 | 2015-06-18 00:00 | STR2_Hall1 | StruFactory2 | Order Product | |||||
1101 | STR33444 | E0001 | 114 | Linked | 09.58 | 9145 | 342 | 2015-06-29 00:00 | 2015-06-19 00:00 | STR2_Hall1 | StruFactory2 | Order Product |
Inventory (Storage) in IMPACT Resource Managet
Note that lines count in the RM/Storage should be the same as the IMPACT Sync Inventory export file.