ASN Data Load Sheet

Document Sample
ASN Data Load Sheet Powered By Docstoc
					v2.2



SUPPLIER ADVANCED SHIPPING NOTICE

                                                                                           EXPECTED DELIVERY DATE:
                                                                                                         02/01/2007
       SUPPLIER NUMBER:      w ols                                                                      SHIPPED DATE:
                                                                                                         11/04/2007

 BOOKING ASN NUMBER:                         nm123


           Only the yellow highlighted fields can be modified

           Leave no blank fields on an entry line - all are required for valid processing - Line complete = TRUE
           DAN Number          Purchase Ord No            PO Line No:        Item Number       Quantity     Line Complete
           nm22              p123456                                  1 b45222                        2         TRUE
                             p012345                                                                            FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
                                                                                                                FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
Instructions to Complete a Wolseley UK Advanced Shipping Notification

An Advanced Shipping Notice details exactly what is being delivered on this particular delivery
ASNs can contain multiple Delivery Advice Note (DAN) numbers
ASNs can contain multiple purchase orders and their lines
ASNs can contain part of a purchase order
ASN Number is the delivery booking reference allocated to you by Wolseley D&SP
Supplier Number is the supplier number you are given by Wolseley UK
Purchase order number references the Wolseley UK purchase order that this shipping notice relates to.
Supplier Advice note number is your Delivery Advice Note (DAN) Number.

1. Ensure that the item number entered is the Wolseley UK specific item number as found on the related Purchase order number
2. Complete the documentation fully with all required fields - do not adjust the format on any of the fields
3. Email the completed spreadsheet to NDC.ASN@Wolseley.co.uk




Data Load Directory
C:\ASN\Load\

XLS Save Directory
C:\ASN\Save\
Record Type ASN Whse ID ASN Number     ASN Carrier ID     ASN Date Expected

Record Type ASN Number   ASN PO Number ASN PO Line Number ASN Item Number


M          NDC           NM123         WOLS                02/01/2007
D          NM123         P123456                         1 B45222
D          NM123         P012345
ASN Date Shipped
                                        Create Load File
ASN Expected Qty    ASN Advice Notice


11/04/2007
                   2 NM22

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:11/9/2012
language:Unknown
pages:57