{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Overview","Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Overview","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Accounts Receivable - 3-6 Client Locations"]
[]
[null,"The following template should be used to import one or more client locations into Sage 100 Contractor.  "]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","ARCLLOC",null,"ARCLLOC","ARCLLOC"]
[null,"recnum","Required **","Numeric","Locations",123,"Client No"]
[null,"locnum","Required","Numeric","Locations",null,"Location No"]
[null,"locnme","Required (I)","String (50)","Locations","jdoe@gmail.com","Location Name"]
[null,"addrs1",null,"String (50)","Locations",null,"Address 1"]
[null,"addrs2",null,"String (50)","Locations",null,"Address 2"]
[null,"ctynme",null,"String (50)","Locations",null,"City"]
[null,"state",null,"String (2)","Locations",null,"State"]
[null,"zipcde",null,"String (10)","Locations",null,"Zipcode"]
[null,"phnnum",null,"String (14)","Locations",null,"Phone"]
[null,"contct",null,"String (50)","Locations",null,"Contact"]
[null,"srvgeo","**","Numeric","Locations",null,"Service Area"]
[null,"maploc",null,"String (10)","Locations",null,"Map Location"]
[null,"crsstr",null,"String (50)","Locations",null,"Cross Street"]
[null,"taxdst","**","Numeric","Locations",null,"Tax District"]
[null,"usrdf1",null,"String (50)","Locations",null,"User Defined"]
[null,"ntetxt",null,"Text","Locations",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[]
[]
[null,"File Example:"]
[null,"filetype,recnum,locnum,locnme,addrs1,addrs2,ctynme,state,zipcde,phnnum,contct,srvgeo,maploc,crsstr,taxdst,usrdf1,ntetxt"]
[null,"ARCLLOC,123,1,\"Location 1\",\"111 Blueberry St.\",\"\",\"Carson\",\"CA\",\"92526\",\"\",\"\",,\"\",\"\",,\"\",\"\""]
[null,"ARCLLOC,123,2,\"Location 2\",\"222 Curry Ln\",\"\",\"Oakland\",\"CA\",\"92687\",\"\",\"\",,\"\",\"\",,\"\",\"\""]
[null,"ARCLLOC,123,3,\"Location 3\",\"333 Fairmore St.\",\"\",\"Fairmore\",\"CA\",\"92102\",\"\",\"\",,\"\",\"\",,\"\",\"\""]

{"sheet":"Template","index":1,"n_rows":11,"n_cols":18,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Sample Template",null,"Note: you may delete any column from this template that is not used or needed other than the Required Columns"]
[]
[]
[null,"Filetype Code","Client No","Location No","Location Name","Address 1","Address 2","City","State","Zipcode","Phone","Contact","Service Area","Map Location","Cross Street","Tax District","User Defined","Notes"]
[null,"ARCLLOC","Numeric","Numeric","String (50)","String (50)","String (50)","String (50)","String (2)","String (10)","String (14)","String (50)","Numeric","String (10)","String (50)","Numeric","String (50)","Text"]
[null,null,"Locations","Locations","Locations","Locations","Locations","Locations","Locations","Locations","Locations","Locations","Locations","Locations","Locations","Locations","Locations","Locations"]
[]
["First Line of File==>","filetype","recnum","locnum","locnme","addrs1","addrs2","ctynme","state","zipcde","phnnum","contct","srvgeo","maploc","crsstr","taxdst","usrdf1","ntetxt"]
[null,"ARCLLOC",123,1,"Location 1","111 Blueberry St.",null,"Carson","CA",92526]
[null,"ARCLLOC",123,2,"Location 2","222 Curry Ln",null,"Oakland","CA",92687]
[null,"ARCLLOC",123,3,"Location 3","333 Fairmore St.",null,"Fairmore","CA",92102]