{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["EDI Setup Information","Lists"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"EDI Setup Information","index":0,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,1,0,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[15,1,15,3],[2,0,2,3],[1,0,1,3],[3,0,3,3],[7,0,7,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[16,1,16,3],[17,1,17,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[18,1,18,3],[21,1,21,3],[22,1,22,3],[23,0,23,3],[24,0,24,3],[27,1,27,3],[25,0,26,0],[25,2,25,3],[26,2,26,3],[19,1,19,3]]}
[]
["Setting up EDI with UNFI"]
["UNFI continues to look for ways to improve its interaction with Suppliers.  The purpose of this document is to provide information to our suppliers related to getting EDI setup quickly and as smoothly as possible in an effort to help ensure no POs are missed and invoices are received. \n\nElectronic Data Interchange (EDI) is an electronic confirmation process proven to be efficient and accurate for sending and receiving data   In the .zip file you'll find UNFI Natural Specifications for EDI 850, 855, 810, 856, 824 along with sample EDI files and our warehouse and duns number list.\nPlease provide these spec sheets and sample files to your EDI team or your 3rd Party EDI Provider (VAN).\nIf you have any questions please reach out to supplieredi@unfi.com.\n\nUNFI connects with our vendors via two different third party providers. Please reach out to either and tell them that you’re looking to establish a connection with UNFI (Natural or Conventional)\n \nEdict Systems: 800-443-3428 / hubservices@edictsystems.com\n \nSPS Commerce: clientservices@spscommerce.com \n \nIf you're using a different third party EDI provider (other than the ones above) Reach out to EDICT inquiring about an interconnect between EDICT and your third party provider to complete testing and certification.\nIf you have in House EDI capabilities, please reach out to EDICT and complete Testing & Certification. "]
["Supplier EDI Setup Process"]
["STEP 1.  Based on the above contact the appropriate EDI provider for your EDI business needs"]
["STEP 2. Complete Testing and Certification, you should receive an email notice with \"Testing Passed\" / \"Production Notice\" in the subject"]
["STEP 3. Fill out the Tab below labeled \"EDI\" in this Excel and send to supplieredi@unfi.com once Testing and Certification is completed "]
["EDI Form"]
[]
["Supplier Legal Name"]
["Supplier DBA\n (if applicable)"]
["Duns #"]
["EDI Contact"]
["EDI Email Address"]
["EDI Phone Number"]
["ISA Qualifier"]
["ISA ID"]
["GS ID"]
["Direct AS2 / Supplier VAN  (Third Party EDI Provider)"]
["UNFI UCS Vendor Number\n (7 digit number) Supplier doing business with UNFI Conventional (Supervalu)"]
["UNFI Natural East Vendor #",null,"UNFI Natural West vendor #"]
["Conventional","If your VAN is different than the two listed below, please email supplieredi@unfi.com"]
["Natural","If your VAN is different than the two listed below, please contact EDICT to complete Testing and Certifcation.\n- Edict Systems: 800-443-3428 / hubservices@edictsystems.com"]
["Any Questions please email supplieredi@unfi.com which will create a ticket for the EDI team"]
["UNFI EDI Information"]
["EDI Transactions being traded\n","UNFI Sending","850 PO, 824 AA, 997 FA"]
[null,"Supplier Sending","810 Invoices, 855 POA, 856 ASN's, 997 FA"]
["Standard Version","4010 X12"]
["UNFI Conventional VAN","EDICT Systems","IBM Sterling","SPS Commerce"]
["ISA QUAL/ID","08 / 925141CORP","08 / 925141CORP","08 / 925141CORP"]
["GS ID",6128284044,6128284044,6128284044]
["UNFI Natural VAN","EDICT Systems"," IBM Sterling","SPS Commerce"]
["ISA QUAL/ID","01 / 943556183 ","01 / 943556183S","ZZ / UNFISPS"]
["GS ID",943556183,"943556183S","UNFISPS"]

{"sheet":"Lists","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Payment Method","Factor Agreement"]
["Select:","Select:","Select:"]
["Check\n(Default payment method upon new vendor setup)","No","Yes"]
["ACH/EFT Payment \n(Form will be provided)","Yes-submit copy of agreement","No"]
["Credit Card \n(Supplier is responsible for any processing fees)"]
[]
[]
[]
["(Add'l form will be provided & approved)"]