Inventory Export

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

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:

123456789101112131416171819
1101STR666555VI60181013InsulatedWall 02.2420292336VI29777788888-336000903261922018-09-12 16:002018-08-28 00:00Stru_Hall2StruFactory Order Product
1101STR666555VI60091018InsulatedWall 12.1520273336VI29777788888-336000903261922018-09-11 07:002018-08-18 00:00Stru_Hall4 BStruFactory Order Product
1101STR666555VI60421156InsulatedWall 97.05.0024380336VI29777788888-336000903261922018-09-20 07:002018-09-04 00:00Stru_Hall2StruFactory Order Product
1101STR666555VI60041021InsulatedWall 918.39.0019324336VI29777788888-336000903261922018-09-10 16:002018-08-21 00:00Stru_Hall4StruFactory Order Product
1101STR666555VI60161015InsulatedWall 17.4821521336VI29777788888-336000903261922018-09-12 16:002018-08-23 00:00Stru_Hall2StruFactory Order Product
1101STR666555VI60111016InsulatedWall 17.4821602336VI29777788888-336000903261922018-09-11 10:002018-08-23 00:00Stru_Hall4StruFactory Order Product
1101STR666555VI60231030InsulatedWall 08.3822023336VI29777788888-336000903261922018-09-18 09:302018-08-31 00:00Stru_Hall4StruFactory Order Product
1101STR666555VI60021023InsulatedWall 07.4521921336VI29777788888-336000903261922018-09-10 16:002018-08-25 00:00Stru_Hall4 BStruFactory Order Product
1101STR666555VI60381151InsulatedWall 22.2622493336VI29777788888-336000903261922018-09-20 07:002018-08-31 00:00Stru_Hall2StruFactory Order Product
1101STR666555VI60261003InsulatedWall 10.1121102336VI29777788888-336000 2018-09-18 11:002018-09-06 00:00Stru_Hall4StruFactory Order Product
1101STR666555VI60221029InsulatedWall 12.2824832336VI29777788888-336000903261922018-09-18 09:302018-08-29 00:00Stru_Hall4StruFactory Order Product
1101STR666555VI60151028InsulatedWall 14.2125008336VI29777788888-336000903261922018-09-12 14:002018-08-27 00:00STR_Hall2StruFactory Order Product
1101STR666555VI60011022InsulatedWall 1301.52.0025546336VI29777788888-336000903261922018-09-10 16:002018-08-19 00:00STR_Hall4 BStruFactory Order Product
1101STR666555VI60131026InsulatedWall 1445.36.0028040336VI29777788888-336000903261922018-09-12 14:002018-08-30 00:00STR_Hall2StruFactory Order Product
1101STR666555VI60241031InsulatedWall 23.3830157336VI29777788888-336000903261922018-09-18 09:302018-09-02 00:00STR_Hall4 BStruFactory Order Product
1101STR666555VI60031024InsulatedWall 12.3930878336VI29777788888-336000903261922018-09-10 16:002018-08-17 00:00STR_Hall4StruFactory Order Product
1101STR33444P315013001Column 00.093493.9321RP 30/30  2016-04-25 00:002016-04-07 00:00STR2_Hall1StruFactory2 Order Product
1101STR33444P315023002Column 00.093493.9321RP 30/30  2016-04-25 00:002016-04-07 00:00STR2_Hall1StruFactory2 Order Product
1101STR33444P313012904Column 00.093581.12.00321RP 30/30  2016-03-21 00:002016-03-18 00:00STR2_Hall1StruFactory2 Order Product
1101STR33444P313022935Column 00.093581.12.00321RP 30/30  2016-03-21 00:002016-03-17 00:00STR2_Hall1StruFactory2 Order Product
1101STR33444E0012560Linked 08.087067.24.00342E  2015-09-22 00:002015-09-16 00:00STR2_Hall1StruFactory2 Order Product
1101STR33444E0002117Linked 09.588192342   2015-06-29 00:002015-06-23 00:00STR2_Hall1StruFactory2 Order Product
1101STR33444E0003118Linked 09.588204342   2015-06-29 00:002015-06-25 00:00STR2_Hall1StruFactory2 Order Product
1101STR33444E0001113Linked 09.589145342   2015-06-29 00:002015-06-18 00:00STR2_Hall1StruFactory2 Order Product
1101STR33444E0001114Linked 09.589145342   2015-06-29 00:002015-06-19 00:00STR2_Hall1StruFactory2 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.

1538301321171-350.png

Tags:
Created by Theib Sawaf on 2018/09/26 16:28
Copyright 2018 StruSoft AB
Impact Documentation