{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SET UP FORM","Required Fields","CUST TYPE"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":2,"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":"SET UP FORM","index":0,"n_rows":38,"n_cols":35,"rows_kept":38,"cut":false,"hidden":false,"merged":[[7,22,7,35],[8,23,8,35],[8,18,8,22],[15,39,15,56],[16,39,16,45],[16,46,16,56],[17,39,17,56],[16,18,16,22],[16,33,16,35],[40,18,40,26],[37,24,37,31],[37,32,37,35],[37,20,37,23],[37,17,37,19],[6,38,6,41],[9,18,9,19],[9,20,9,25],[9,26,9,27],[9,28,9,29],[9,31,9,35],[10,18,10,20],[10,21,10,35],[11,18,11,21],[11,22,11,35],[12,18,12,19],[12,20,12,35],[13,18,13,21],[13,22,13,35],[14,18,14,22],[14,23,14,35],[35,20,35,23],[38,0,38,35],[35,5,35,7],[35,15,35,18],[13,0,13,5],[35,0,35,3],[17,0,17,17],[12,4,12,17],[15,0,15,3],[15,5,15,6],[15,9,15,17],[26,1,26,2],[32,8,32,12],[32,16,32,21],[32,13,32,15],[30,19,30,23],[32,23,32,25],[32,0,32,7],[33,20,33,25],[35,31,36,31],[12,0,12,3],[8,0,8,1],[8,2,8,9],[11,0,11,1],[34,32,35,33],[32,31,32,35],[26,4,26,5],[26,7,26,10],[26,12,26,16],[10,3,10,17],[11,2,11,17],[28,23,28,35],[14,0,14,3],[32,28,32,30],[35,29,36,29],[33,32,33,35],[35,34,35,35],[33,28,33,31],[33,8,33,10],[33,3,33,7],[24,21,25,35],[30,0,30,2],[35,9,35,13],[37,0,37,3],[37,5,37,6],[20,2,20,9],[22,1,22,3],[22,5,22,6],[22,8,22,11],[20,18,20,26],[22,18,22,26],[13,6,13,17],[32,26,32,27],[35,24,35,25],[14,4,14,17],[31,19,31,35],[33,18,33,19],[33,0,33,2],[30,4,31,10],[30,12,31,18],[17,18,17,35],[16,0,16,17],[26,21,26,28],[26,29,26,35],[15,18,15,35],[33,13,33,17],[33,11,33,12],[0,0,0,31],[7,0,7,3],[9,0,9,1],[7,4,7,17],[8,10,8,11],[8,12,8,13],[8,15,8,17],[3,27,3,28],[3,0,3,3],[3,4,3,9],[3,10,3,13],[1,22,1,25],[3,14,3,25],[3,29,3,35],[9,2,9,17],[6,18,6,23],[6,24,6,35],[5,0,5,8],[5,9,5,17],[6,0,6,3],[5,18,5,22],[5,23,5,35],[7,18,7,20]]}
["ORACLE SETUP/CHANGE FORM"]
[null,null,null,"  NEW CUSTOMER SET-UP",null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER CHANGE"]
[]
["REQUESTED BY:",null,null,null,null,null,null,null,null,null,"LOCATION:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
["BILL-TO ACCOUNT # (leave blank for new):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHIP-TO ACCOUNT #"]
["CUSTOMER NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUSTOMER LEGAL NAME:"]
["BILL-TO ADDRESS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STORE #:"]
["CITY:",null,null,null,null,null,null,null,null,null,"STATE:",null," ",null,"ZIP:",null,null,null,"SHIP-TO ADDRESS:"]
["COUNTY:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CITY:",null,null,null,null,null,null,null,"STATE:",null,null,null,"ZIP:"]
["TELEPHONE #:                                    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY:"]
["FAX #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TELEPHONE #:"]
["OWNER'S NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAX #:"]
["OWNER'S EMAIL ADDRESS: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A/P CONTACT:"]
["OWNER CELL #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A/P EMAIL ADDRESS:"]
["TAXABLE*:",null,null,null,null,"YES",null,null,"NO","(*SEE BELOW)",null,null,null,null,null,null,null,null,"Account will be setup as COD -Payment to be collected at time of order until Credit is approved."]
["*IF NO, RESALE CERTIFICATE MUST BE ATTACHED OR TAX WILL BE CHARGED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAYMENT TERMS:",null,null,null,null,null,"COD;",null,"TERMS*  & Credit Line Requested:    $"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"**A CREDIT APPLICATION MUST BE SUBMITTED FOR REVIEW IF CREDIT LINE IS REQUESTED"]
["Taxpayer Identification Number (TIN)  (Please provide W-9)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preference for Receiving Invoices, Statements & Acknowledgements: If blank, forms will be mailed."]
["(for individuals, this is your social security number)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAX # / EMAIL ADDRESS",null,null,null,null,null,"INVOICES",null,null,"ACK",null,null,"STATEMENTS"]
["TIN/EIN:",null,null,null,null,null,null,null,null,null,"(Include W-9)"]
[null,null,null,null,"OR"]
["SS:"]
[]
["OPERATING UNIT(S) CUSTOMER WISHES TO PURCHASE FROM:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WD PLANT REGIONAL"]
[]
[null,"TODCO",null,null,"GENIE",null,null,"WD PLANTS",null,null,null,null,"SALES CENTER",null,null,null,null,null,"OHD Parts",null,null,"SALES MANAGER/RSD/DSM: APPROVAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature"]
["Customer may buy ASD Factory Direct:",null,null,null,null,null,null,null,null,null,"No,",null,null,"YES*",null,"{please specify location(s)}: "]
[null,null,null,null,null,null,null,null,null,null,null,null,"*(If YES,  must have Regional Sales Director/DSM sign ABOVE)"]
["GENIE ONLY: ",null,null,null,"STANDARD - RESI PRTS/ACC \n& COMM PREPKG HDS/RLS ",null,null,null,null,null,null,null,"FACTORY DIRECT \nALL PRODUCTS",null,null,null,null,null,null,"OPENER STRUCTURE",null,null,null,null,null,"N/A",null,"YLW*",null,"RED*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   *EXCEPTION DOCUMENTATION REQUIRED FOR MARKETING"]
["SELECT ITEMS FROM DROP DOWN      ",null,null,null,null,null,null,null,"ASD PRIMARY RS PLANT:",null,null,null,null,null,null,null,"ASD SECONDARY PLANT:",null,null,null,null,null,null,"ORDER TYPE:",null,null,null,null,"PRICE LIST:"]
["CUST TYPE:",null,null,null,null,null,null,null,"GL CHNL:",null,null,null,null,"VOLUME CLASS:",null,null,null,null,null,null,"QUOTE EXPIRATON PERIOD:",null,null,null,null,null,null,null,"WAREHOUSE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other:"]
["FREIGHT TERMS:",null,null,null,null,"PREPAID",null,null,null,"PREPAID & ADD",null,null,null,null,null,"COLLECT",null,null,null,null,"3RD PARTY BILLING",null,null,null,null,null,"FOB:",null,null,"JDE Zone"]
[]
["ODC RIBBON CO-OP:",null,null,null,null,"YES",null,"x","NO","* DEFAULT IS NO",null,null,null,null,null,null,null,"EDI ID #:",null,null,null,null,null,null,"SALES REP  (IF BLANK-NO SALES CREDIT):"]

{"sheet":"Required Fields","index":1,"n_rows":40,"n_cols":38,"rows_kept":40,"cut":false,"hidden":true,"merged":[[5,0,5,3],[5,4,5,17],[5,18,5,23],[5,24,5,35],[6,0,6,7],[6,8,6,17],[6,18,6,23],[6,24,6,35],[0,0,0,31],[1,22,1,25],[3,0,3,3],[3,4,3,9],[3,10,3,13],[3,14,3,25],[3,27,3,28],[3,29,3,35],[7,0,7,3],[7,4,7,17],[7,18,7,22],[7,23,7,35],[8,0,8,1],[8,2,8,9],[8,10,8,11],[8,12,8,13],[8,15,8,17],[8,18,8,19],[10,3,10,17],[10,18,10,21],[10,22,10,35],[11,0,11,1],[11,2,11,17],[11,18,11,19],[11,20,11,35],[8,20,8,25],[8,26,8,27],[8,28,8,29],[8,31,8,35],[9,0,9,1],[9,2,9,17],[9,18,9,20],[9,21,9,35],[31,19,31,23],[32,19,32,35],[25,21,26,35],[27,1,27,2],[27,4,27,5],[27,7,27,10],[27,12,27,16],[27,21,27,26],[27,27,27,35],[12,0,12,3],[12,4,12,17],[12,18,12,21],[12,22,12,35],[13,0,13,5],[13,6,13,17],[13,18,13,23],[13,24,13,35],[36,0,36,3],[36,5,36,7],[36,9,36,13],[36,15,36,18],[36,20,36,23],[36,24,36,25],[34,18,34,19],[34,20,34,25],[34,26,34,27],[34,0,34,2],[34,3,34,7],[34,8,34,10],[34,11,34,12],[34,28,34,31],[34,32,34,35],[35,32,36,33],[16,0,16,17],[16,18,16,24],[16,25,16,35],[17,0,17,3],[17,5,17,6],[17,9,17,17],[17,18,17,35],[14,0,14,3],[14,4,14,17],[14,18,14,26],[14,27,14,35],[15,0,15,3],[15,5,15,6],[15,9,15,17],[15,18,15,35],[39,0,39,3],[39,5,39,6],[39,9,39,17],[38,0,38,35],[18,0,18,17],[21,2,21,9],[21,18,21,26],[23,1,23,3],[23,5,23,6],[23,8,23,11],[23,18,23,26],[36,29,37,29],[36,31,37,31],[36,34,36,35],[33,17,33,19],[33,20,33,22],[33,26,33,27],[33,28,33,30],[33,31,33,35],[34,13,34,17],[29,23,29,35],[31,0,31,2],[31,4,32,10],[31,12,32,18]]}
["ORACLE SETUP/CHANGE FORM"]
[null,null,null,"  NEW CUSTOMER SET-UP",null,null,null,null,null,null,null,null,null,null,null,"  CUSTOMER CHANGE"]
[]
["REQUESTED BY:",null,null,null,null,null,null,null,null,null,"LOCATION:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
["CUSTOMER NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUSTOMER LEGAL NAME:"]
["BILL-TO ACCOUNT # (leave blank for new):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHIP-TO ACCOUNT #"]
["BILL-TO ADDRESS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHIP-TO ADDRESS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Requirement Prioritys:"]
["CITY:",null,null,null,null,null,null,null,null,null,"STATE:",null," ",null,"ZIP:",null,null,null,"CITY:",null,null,null,null,null,null,null,"STATE:",null,null,null,"ZIP:",null,null,null,null,null,null,"Mandatory Level 1: Will not let me move forward in order to create an account. "]
["COUNTY:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mandatory Level 2: Important information for collectors "]
["TELEPHONE #:                                    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TELEPHONE #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mandatory Level 3: Important information, if not listed will put N/A or my understanding of Standard Information and who the request is from"]
["FAX #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAX #:"]
["OWNER'S NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A/P CONTACT:"]
["OWNER'S EMAIL ADDRESS: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A/P EMAIL ADDRESS:"]
["OWNER CELL #:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALES REP - IF BLANK-NO SALES CREDIT:"]
["TAXABLE*:",null,null,null,null,"YES",null,null,"NO","(SEE BELOW)",null,null,null,null,null,null,null,null,"Account will be setup as COD -Payment to be collected at time of order"]
["*IF NO, RESALE CERTIFICATE MUST BE ATTACHED OR TAX WILL BE CHARGED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CREDIT LIMIT REQUESTED**: "]
["ODC RIBBON CO-OP:",null,null,null,null,"YES",null,"x","NO","* DEFAULT IS NO",null,null,null,null,null,null,null,null,"**A CREDIT APPLICATION MUST BE SUBMITTED FOR REVIEW IF CREDIT LIMIT REQUESTED"]
[]
["Taxpayer Identification Number (TIN) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preference for Receiving Invoices, Statements & Acknowledgements: If blank, forms will be mailed."]
["(for individuals, this is your social security number)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAX # / EMAIL ADDRESS",null,null,null,null,null,"INVOICES",null,null,"ACK",null,null,"STATEMENTS"]
["TIN/EIN:",null,null,null,null,null,null,null,null,null,null,"Or"]
[]
["SS:"]
[]
["OPERATING UNIT(S) CUSTOMER WISHES TO PURCHASE FROM:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WD PLANT REGIONAL"]
[]
[null,"TODCO",null,null,"GENIE",null,null,"WD PLANTS",null,null,null,null,"SALES CENTER",null,null,null,null,null,"OHD Parts",null,null,"SALES MANAGER/RSD/DSM: APPROVAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature"]
["Customer may buy ASD Factory Direct:",null,null,null,null,null,null,null,null,null,"No,",null,null,"YES*",null,"{please specify location(s)}: "]
[null,null,null,null,null,null,null,null,null,null,null,null,"*(If YES,  must have Regional Sales Director/DSM sign ABOVE)"]
["GENIE ONLY: ",null,null,null,"STANDARD - RESI PRTS/ACC \n& COMM PREPKG HDS/RLS ",null,null,null,null,null,null,null,"FACTORY DIRECT \nALL PRODUCTS",null,null,null,null,null,null,"OPENER STRUCTURE",null,null,null,null,null,"N/A",null,"YLW*",null,"RED*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   *EXCEPTION DOCUMENTATION REQUIRED FOR MARKETING"]
["SELECT ITEMS FROM DROP DOWN      ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Order Type:",null,null,"PRICE LIST:"]
["**CUST TYPE:",null,null,null,null,null,null,null,"GL CHNL:",null,null,null,null,"VOLUME CLASS:",null,null,null,null,null,null,"QUOTE EXPIRATION PERIOD:",null,null,null,null,null,null,null,"WAREHOUSE:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other:"]
["FREIGHT TERMS:",null,null,null,null,"PREPAID",null,null,null,"PREPAID & ADD",null,null,null,null,null,"COLLECT",null,null,null,null,"3RD PARTY BILLING",null,null,null,null,null,"FOB:",null,null,"JDE Zone"]
[]
[]
["ODC RIBBON CO-OP:",null,null,null,null,"YES",null,"x","NO","* DEFAULT IS NO",null,null,null,null,null,null,null,null,"OFFICE USE ONLY",null,null,null,"EDI ID #:",null,null,null,null,null,null,"STORE #:"]

{"sheet":"CUST TYPE","index":2,"n_rows":107,"n_cols":29,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["TOD-AFT-Aftermarket",null,null,"Free On Board Point",null,null,null,"GL CHANNEL",null,null,null,"Freight Zone",1,null,"Price List",null,"Only or most used out of 268 options to use",null,"Order Types",null,null,"Warehouse",null,null,null,"Primary RS Plant:",null,null,"Secondary Plant:"]
["TOD-TBD-Truck Body Distributor",null,null,"Buyer",null,null,null,"21-Ribbon-Regular",null,null,null,null,2,null,null,"ASD: ","WD Primary USD",null,"ASD Standard",null,null,"10-TODCO Headquarters",null,null,null,"101: Lewistown Plant",null,null,"101: Lewistown Plant"]
["TOD-TBO-Truck Body OEM",null,null,"Cost and Freight",null,null,null,"22-Ribbon-Builder",null,null,null,null,3,null,null,null,null,null,"ASD Sales Center",null,null,"11-TODCO Marion",null,null,null,"102: Williamsport Plant",null,null,"102: Williamsport Plant"]
["TOD-TRD-Trailer Distributor",null,null,"cost, Insurance & Frieght",null,null,null,"31-Dealer - Regular",null,null,null,null,4,null,null,"OHD PARTS","GOLD",null,"ASD Furnish and Install",null,null,"12-TODCO Tecate ",null,null,null,"103: Grand Island Plant",null,null,"103: Grand Island Plant"]
["TOD-TRO-Trailer OEM",null,null,"Customer Site",null,null,null,"32-Dealer-Builder",null,null,null,null,5,null,null,null,"GOLD+",null,"ASD WDSC FI Intercompany",null,null,"20-Horton Headquarters",null,null,null,"104: Centralia Plant",null,null,"104: Centralia Plant"]
["TOD-T06-Todco-Doors",null,null,"DB FOT Ridderkerk",null,null,null,"41-eCommerce ",null,null,null,null,6,null,null,null,"SILVER",null,"Genie Standard",null,null,"21-Horton Corpus Christi",null,null,null,"105: Conneaut Plant",null,null,"105: Conneaut Plant"]
["TOD-T99-Todco Unknown",null,null,"Ex- Factory",null,null,null,"42-Independent Installer",null,null,null,null,7,null,null,null,"SILVER+",null,"HP Standard",null,null,"22-Horton Matamoros",null,null,null,"106: Dalton Plant",null,null,"106: Dalton Plant"]
["HOR-HCO-Contract",null,null,"Ex-Works",null,null,null,"44-Contractor",null,null,null,null,8,null,null,null,"PLATINUM",null,"Todco Standard",null,null,"24-Horton Shipping ",null,null,null,"107: Mount Hope Plant",null,null,"107: Mount Hope Plant"]
["HOR-HDE-Dealer",null,null,"Free of Charge",null,null,null,"45-Transit",null,null,null,null,9,null,null,null,"PLATINUM+",null,"ASD Interim- MXP",null,null,"30-Door Service Headquarters",null,null,null,"108: Pensacola Plant",null,null,"108: Pensacola Plant"]
["HOR-HDI-Distributor",null,null,"Free on Board",null,null,null,"46-OEM Truck Body",null,null,null,null,10,null,null,null,"CANADIAN",null,"ASD Internal",null,null,"31-Door Service-ADE",null,null,null,"109: Portland Plant",null,null,"109: Portland Plant"]
["HOR-HNA-National Account",null,null,"Factory",null,null,null,"47-OEM Trailer",null,null,null,null,11,null,null,null,"CANADIAN+",null,"ASD International",null,null,"32-Door Service-Allegheny",null,null,null,"110: Trail Plant",null,null,"110: Trail Plant"]
["HOR-HIC-Intercompany",null,null,"Loading Dock",null,null,null,"48-Leasing",null,null,null,null,12,null,null,null,"DIAMOND",null,"ASD OHD Parts Order",null,null,"33-Door Service-ADS",null,null,null,"150: China Other",null,null,"150: China Other"]
["HOR-HUK-Horton Unknown",null,null,"Seller",null,null,null,"49-Export",null,null,null,null,null,null,null,null,"DIAMOND+",null,"ASD OHD Parts RMA",null,null,"34-Door Service-Del Mar",null,null,null,"151: Lewisville National Accounts",null,null,"151: Lewisville National Accounts"]
["GEN50-OHD-Dealer-Ribbon (approved by Sendar to buy Ribbon Branded Product) ",null,null,"Shipping Point",null,null,null,"50-Builder Direct-National",null,null,null,null,null,null,null,"Genie:","Genie-Genie Comm Pre-Packaged Heads and Rails",null,"ASD OHD Parts Web Order",null,null,"35-Door Service-Keystone",null,null,null,"152: OHDParts.com Grand Prairie",null,null,"152: OHDParts.com Grand Prairie"]
["GEN50-LSS-Large Business, Runs Sales and Service out of One Location",null,null,null,null,null,null,"51-OEM-Specialty",null,null,null,null,null,null,null,null,"Genie-Genie Res Accessories and Parts",null,"ASD RMA ",null,null,"36-Door Service-EDS",null,null,null,"153: DFW TREQ Center",null,null,"153: DFW TREQ Center"]
["GEN50-LSM-Large Business, Runs Sales and Service out of Multiple Locations",null,null,null,null,null,null,"52-Builder Direct-Non National",null,null,null,null,null,null,null,null,"Genie-Genie Res Heads",null,"ASD RMA JDE",null,null,"37-Door Service-Door Controls",null,null,null,"154: Netherlands",null,null,"154: Netherlands"]
["GEN50-0LW-Large Wholesale Business, One Location",null,null,null,null,null,null,"71-Home Depot",null,null,null,"Freight Other","Customer Arranged Carrier Will Call",null,null,null,"Genie-OHD Res and Comm Accessories and Parts",null,"ASD RMA MXP",null,null,"38-Door Service-ADA",null,null,null,"155: ASD Commercial Solutions",null,null,"155: ASD Commercial Solutions"]
["GEN50-LWM-Large Wholesaler Business with Multiple Locations",null,null,null,null,null,null,"72-Lowes",null,null,null,null,"WDSC-TL-Door to Door",null,null,"Genie Retail:","Genie Retail 84 Lumber USD",null,"ASD Replacement",null,null,"39-Door Service-TAC Houston",null,null,null,"158: ASD Division Elimination",null,null,"158: ASD Division Elimination"]
["GEN50-MAN-Original Equipment Manufacturer (OEM)",null,null,null,null,null,null,"73-Menards",null,null,null,null,"Will Call TL",null,null,null,"Genie Retail Ace-D/S USD",null,"ASD FI Direct Sale",null,null,"40-Door Service-TAC-San Antonio",null,null,null,"159: Closed Locations - ASD",null,null,"159: Closed Locations - ASD"]
["GEN35-SSS-Small Business, Runs Sales and Service out of One Location",null,null,null,null,null,null,"74-Canadian Tire Corp",null,null,null,null,null,null,null,null,"Genie Retail Amazon USD",null,"ASD Sales Center RMA",null,null,"41-Door Service-TAC-Dallas",null,null,null,"201: OHDParts.com Lewistown",null,null,"201: OHDParts.com Lewistown"]
["GEN-AHR-Retailer-Ace RSC",null,null,null,null,null,null,"75-Other Retail",null,null,null,null,null,null,null,null,"Genie Retail Autozone USD",null,"ASD Conv Sales Center",null,null,"43-Door Service-Baltimore",null,null,null,"202: OHDParts.com Reno",null,null,"202: OHDParts.com Reno"]
["GEN-AHD-Retailer-Ace DS",null,null,null,null,null,null,"76-Amazon",null,null,null,null,null,null,null,null,"Genie Retail Bj's Wholesale Club USD",null,"ASD Freight Ibkt",null,null,"44-Door Service-Roanoke"]
["GEN-AMZ-Retailer-Amazon",null,null,null,null,null,null,"91-Overhead Door Plants",null,null,null,null,null,null,null,null,"Genie Retail Costco USD",null,"ASD WDSC FI SHIP ONLY",null,null,"45-Door Service-Atlanta"]
["GEN-BMZ-Retailer-Blish-Mize",null,null,null,null,null,null,"92-Wyane-Dalton Plants",null,null,null,null,null,null,null,null,"Genie Retail Do It Best D/S USD",null,"ASD Warranty",null,null,"46-Door Service-DC "]
["GEN-CRL-Retailer-Carter",null,null,null,null,null,null,"93-OHD Parts",null,null,null,null,null,null,null,null,"Genie Retail Sams Club In Store - USD",null,"Genie Cost",null,null,"47-Door Service-Charlotte"]
["GEN-CIM-Retailer-Cimarron",null,null,null,null,null,null,"94-ASD Sales Centers",null,null,null,null,null,null,null,null,"Genie Retail Sams Club USD",null,"Genie FI Installation ",null,null,"75-Won Door"]
["GEN-DTB-Retailer-Direct Buy",null,null,null,null,null,null,"95-Nationserve",null,null,null,null,null,null,null,null,"Genie Retail THD Quote Center USD",null,"Genie FI RMA",null,null,"90-Genie"]
["GEN-DBW-Retailer-DIB WHS",null,null,null,null,null,null,"98-Conversion",null,null,null,null,null,null,null,null,null,null,"Genie Furnish and Install",null,null,"91-Genie-Baltic"]
["GEN-DBD-Retailer-DIB DS",null,null,null,null,null,null,"99-Intercompany",null,null,null,null,null,null,null,"Ribbon DLR / ODC: ","OHD Primary USD",null,"Genie Inspecition",null,null,"92-Genie-Matamoras"]
["GEN-GET-Retailer-Global Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Inspecition & Install",null,null,"93-Genie-Brownsville"]
["GEN-HNL-Retailer-Hayneedle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco: ","Todco Product USD",null,"Genie Intercompany",null,null,"94-Genie F&I"]
["GEN-JER-Retailer-Jerry's",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Interim-JDE",null,null,"95-Genie-Treq"]
["GEN-LMC-Retailer-LMC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Interim- MXP",null,null,"100-ASD-Headquarters"]
["GEN-MEN-Retailer-Menards",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Internal",null,null,"101-ASD-Lewistown"]
["GEN-MIL-Retailer-Mills Fleet Farm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Manual Intercompany",null,null,"102-ASD-Williamsport"]
["GEN-OVK-Retailer-Overstock.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Prev. Maintenance",null,null,"103-ASD-Grand Island"]
["GEN-PAL-Retailer-PAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Price Adj",null,null,"104-ASD-Centrailia"]
["GEN-PET-Retailer-Petra",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Projects",null,null,"105-ASD-Conneaut"]
["GEN-POW-Retailer-Power Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geine RMA",null,null,"106-ASD-Dalton"]
["GEN-UNB-Retailer-Unbeatablesale.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie RMA - Intercompany",null,null,"107-ASD-Mt Hope"]
["GEN-TVD-Retailer-True Value DS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie RMA-JDE",null,null,"108-ASD Pensacola"]
["GEN-CTC-Retailer-CTC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie RMA-MXP",null,null,"109-ASD-Portland"]
["GEN-HDU-Retailer-THD-USA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie RMA FI Cancellations",null,null,"110-ASD-Trail"]
["GEN-HDO-Retailer-THD.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie RMA FI Installation",null,null,"140-ASD F&I"]
["GEN-HDC-Retailer-THD-Canada",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Service",null,null,"151-ASD-Lewisville National Accts"]
["GEN-RSV-Retailer-Svc Parts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ASD FI RMA",null,null,"152-ASD-OHDParts Grand Prairie"]
["GEN-MEC-Retailer-Menards.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Warranty",null,null,"153-ASD-DFW Treq"]
["GEN-DIC-Retailer-Do it Center",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Warranty - JDE",null,null,"154-Netherlands"]
["GEN-LRD-Retailer-Lowes RDC Collect",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genie Warranty - Consumer",null,null,"160-Sales Center Headquarters"]
["GEN-L48-Retailer-Lowes and .com L48 PPD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD Cost",null,null,"161-ASD-Atlanta"]
["GEN-LAH-Retailer-Lowes and .com AKHI PPD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD Internal",null,null,"162-ASD- Balitmore"]
["GEN-LCO-Retailer-Lowes.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD International",null,null,"163-ASD-Bay Area"]
["GEN-SRS-Retailer-Sears",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD New Installation",null,null,"164-ASD-Boise"]
["GEN-ORG-Retailer-Orgill",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD Prev Maintenance",null,null,"165-ASD-Chatsworth"]
["GEN-YOW-Retailer-THD Your Other Warehouse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD Projects",null,null,"166-ASD-Chicago"]
["GEN-84L-Retailer-84 Lumber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD RMA",null,null,"167-ASD-Chino"]
["ASD-WDD-Wayne-Dalton Dealer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD SVC Fire Door",null,null,"168-ASD-Cleveland"]
["ASD-ICO - Intercompany",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD SVC Installation",null,null,"169-ASD-Columbus"]
["ASD-OHD-Dealer - Ribbon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD SVC Maual Door",null,null,"170-ASD-Dallas"]
["ASD-OHP-Ribbon OHD Plants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD Service",null,null,"171-ASD-Detroit"]
["ASD-WDP-Wayne-Dalton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD Standard",null,null,"172-ASD-Greenville"]
["ASD-DLR-Dealer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD Warranty",null,null,"173-ASD-Hartford"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP Cost",null,null,"174-ASD-Houston Sales Center"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP Intercompany",null,null,"175-ASD-Jackson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP Intercompany RMA",null,null,"176-ASD-Lansing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP Internal",null,null,"177-ASD-Little Rock"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP International",null,null,"178-ASD-Long Island"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ASD Intercompany",null,null,"179-ASD-New England Auborn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ASD Interim- JDE",null,null,"180-ASD-New England Walpole"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP Prev Maintenance",null,null,"181-ASD-New Orleans"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP Projects",null,null,"182-ASD-Oklahoma City"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP RMA",null,null,"183-ASD-Orlando"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP Service",null,null,"184-ASD-Pensacola"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HP Warranty",null,null,"185-ASD-Philadelphia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horton Freight Only",null,null,"186-ASD-Pittsburgh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco Cost",null,null,"187-ASD-Sacramento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco Intercompany",null,null,"188-ASD-Salt Lake City"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco Interim - JDE",null,null,"189-ASD-San Antonio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco Internal",null,null,"190-ASD-San Diego"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco International",null,null,"191-ASD-Santa Ana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco Prev Maintenance",null,null,"192-ASD-Seattle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco Projects",null,null,"193-ASD-St Louis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco RMA",null,null,"194-ASD-Tinley Park"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco Service",null,null,"195-ASD-Toledo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todco Warranty",null,null,"196-ASD-Twin Cities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201-ASD-OHDparts Lewistown"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"202-ASD-OHDparts Reno"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"203-ASD-Louisville"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"204-ASD-Memphis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"300-Creative Door"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"310-ASD-Akron/Canton "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"311-ASD-Albuquerque"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"312-ASD-Charlotte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"313-ASD-Cincinati"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"314-ASD-Coeur D'Alene"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"315-ASD-Columbus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"317-ASD-Houston North"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"318-ASD-Kennewick"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"319-ASD-Lewiston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"321-ASD-Missoula"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"326-ASD-Peoria"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"327-ASD-Pueblo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"328-ASD-Quad Cities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"329-ASD-Raleigh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"330-ASD-Spokane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"331-ASD-Tempe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"332-ASD-Tuscan"]