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 first line is a title row):
Standard;Project;ElementMark;ElementId;ElementType;Description;Area;Cost;Group;Product;ItemNo1;ItemNo2;PlannedDeliveryDate;ProductionDate;ProductionDivision;ProductionFactory;Stock;Type
1101;Stru100000; W1044;66;Linked;;19,3;25090;331;;;;2016-05-02 00:00;2016-04-08 00:00;JST_Hall1;StruSoft;2011-03-01;Order Product
1101;Stru100001; W1093;91;Linked;;7,71421;10028,473;331;;;;2016-05-24 00:00;2016-04-21 00:00;JST_Hall1;StruSoft;2011-03-01;Order Product
1101;Stru100002; W1103;134;Linked;;18,2;23459,8;331;;;;2016-06-09 00:00;2016-05-06 00:00;JST_Hall1;StruSoft;D-09;Order Product
1101;Stru100003; W1104;135;Linked;;18,2;23459,8;331;;;;2016-06-21 00:00;2016-05-23 00:00;JST_Hall1;StruSoft;D-09;Order Product
1101;666; YP5;5;Linked;ANLÄGGNING STORPLAN;12,15;31150;417;;391015;90003556;;;;StruSoft;;Stock Item
1101;666; YP6;18;Linked;ANLÄGGNING STORPLAN;46,72;113056;417;;391016;90003557;;;;StruSoft;;Stock Item
1101;666; Y6P7;2;Linked;ANLÄGGNING STORPLAN;6,82;17896;417;;391920;90003585;;;;StruSoft;;Stock Item
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 | Stru100000 | W1044 | 66 | Linked | 19,3 | 25090 | 331 | 2016-05-02 00:00 | 2016-04-08 00:00 | JST_Hall1 | StruSoft | 2011-03-01 | Order Product | |||||
| 1101 | Stru100001 | W1093 | 91 | Linked | 7,71421 | 10028,47 | 331 | 2016-05-24 00:00 | 2016-04-21 00:00 | JST_Hall1 | StruSoft | 2011-03-01 | Order Product | |||||
| 1101 | Stru100002 | W1103 | 134 | Linked | 18,2 | 23459,8 | 331 | 2016-06-09 00:00 | 2016-05-06 00:00 | JST_Hall1 | StruSoft | D-09 | Order Product | |||||
| 1101 | Stru100003 | W1104 | 135 | Linked | 18,2 | 23459,8 | 331 | 2016-06-21 00:00 | 2016-05-23 00:00 | JST_Hall1 | StruSoft | D-09 | Order Product | |||||
| 8201 | 417 | MPN6 | 20 | Linked | ANLÄGGNING STORPLAN | 109,2 | 328940 | 417 | 391004 | 90003564 | StruSoft | Stock Item | ||||||
| 8201 | 417 | UB10 | 3 | Linked | ANLÄGGNING STORPLAN | 9,75 | 15222 | 417 | 391034 | 90003547 | StruSoft | Stock Item | ||||||
| 8201 | 417 | YP4 | 6 | Linked | ANLÄGGNING STORPLAN | 11,7 | 32652 | 417 | 391014 | 90003555 | StruSoft | Stock Item | ||||||
Inventory (Storage) in IMPACT Resource Manager
Note that lines count in the RM/Storage should be the same as the IMPACT Sync Inventory export file.
The inventory export contains both ordered products (i.e. with element ids) and stock items (without element id but have balance).
The last column (number 19) contains the type of the current row. It can be either Order Product or Stock Item.
The value presented in column 4 (ElementId) is the element id for order product or balance for stock items.
