locked
Actuals Deliveries Vs Expected Deliveries RRS feed

  • Question

  • Hello Everyone,


    I have ETD and ATD in my table, where i have to calculate PO's.

    ETD = Expected time of Delivery

    ATD = Actual time of Delivery

    Please find my find columns below and do let me know if i can calculate any others.

    Below data is not in structred.

    In Shipment Type Fedex column is structed.

    Shipment Type  StatusCode Seq ShipmentRef ProjectNr  PONumber Modality ETD Date ETA Date   ATD Date ATA Date ShipmentDate  Totalweight    
    Weightbase  ShipperCountry  ShipperPostCode 
    ShipperType  Totalunitamount
    Normal ASSIGNED 673734 190093354 AF19073       3505 ROAD 11/14/2019    
    11/15/2019  11/13/2019   66 KG                                    
    United States of America 43054 ORG 14350
    Normal READY2SHIP  673730  190093352 103.06.1403.01  8000148663 ROAD 11/17/2019 11/20/2019  11/13/2019    
    2320.05 LBS United States of America 43068 CUSTOMER 277247.36
    Normal READY2SHIP  673728  190093351 103.06.1403.01  
    8000149434 ROAD 11/15/2019 11/19/2019  11/13/2019 120 LBS United States of America 43068 CUSTOMER 43875
    Normal READY2SHIP 
    673726 190093350 103.06.1403.01 8000148669 ROAD 11/15/2019 11/19/2019  11/13/2019 390 KG United States of America 43068 CUSTOMER 78416.13
    Out of Whs READY2SHIP 673723 190093348 AF19082 ASTCN0000002173 
    ROAD 11/13/2019 11/13/2019   11/13/2019 512 LBS United States of America 43054 ORG 12355.25
    Normal ASSIGNED 673721 190093347 AF20022 167 DEEPSEA 11/14/2019 11/21/2019  
     11/12/2019 
    4386 KG United States of America 43054 ORG 0
    Normal ASSIGNED 673719 190093346 AF20022 165 DEEPSEA 11/14/2019 11/21/2019 11/12/2019 422 KG United States of America 43054 ORG 7534
    Normal ASSIGNED 673715 190093344 AF20022 164 DEEPSEA  11/14/2019 11/21/2019 11/12/2019 195 KG United States of America 43054 ORG 8266
    FEDEX ARRIVED 673711 190093342 AF19074 40818 SUPPLIER  11/14/2019 11/15/2019 11/14/2019  11/15/2019  11/12/2019 236.4 LBS United States of America 43228 VENDOR 4459.49
    Normal ASSIGNED 673709 190093341 AF19080 2124 AIR 11/15/2019 11/26/2019 11/12/2019 164 KG United States of America 43054 ORG 9789.4













    Weightbase ShipperCountry ShipperPostCode ShipperType Totalunitamount

    Awating for the response....

    Thanks in advance











    KG United States of America 43054 ORG 14350











    LBS United States of America 43068 CUSTOMER 277247.36











    LBS United States of America 43068 CUSTOMER 43875











    KG United States of America 43068 CUSTOMER 78416.13











    LBS United States of America 43054 ORG 12355.25











    KG United States of America 43054 ORG 0











    KG United States of America 43054 ORG 7534









    11/12/2019 195 KG United States of America 43054 ORG 8266



    Wednesday, December 4, 2019 1:20 PM

All replies