{"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":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"Accounts Receivable - 3-6 Receivable Clients"]
[]
[null,"The following template should be used to import one or more clients into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","ARCL",null,"ARCL","ARCL"]
[null,"recnum","Required","Numeric","Header",null,"Client Number"]
[null,"clnnme","Required","String (75)","Header",null,"Full Client Name"]
[null,"shtnme","Required","String (30)","Header",null,"Short Name"]
[null,"status","Required(I) **","Numeric","Header",null,"Status"]
[null,"clntyp","**","Numeric","Header",null,"Client Type"]
[null,"addrs1",null,"String (50)","General",null,"General Addr 1"]
[null,"addrs2",null,"String (50)","General",null,"General Addr 2"]
[null,"ctynme",null,"String (50)","General",null,"General City"]
[null,"state_",null,"String (2)","General",null,"General State"]
[null,"zipcde",null,"String (10)","General",null,"General Zip"]
[null,"taxdst","**","Numeric","General",null,"Tax District"]
[null,"duetrm",null,"String (5)","General","##DY,##TH or ##MO","Due Terms"]
[null,"dsctrm",null,"String (5)","General","##DY,##TH or ##MO","Discount Terms"]
[null,"dscrte",null,"Numeric (3,2)","General",2,"Discount Rate"]
[null,"finrte",null,"Numeric (3,2)","General",2,"Finance Rate"]
[null,"crsstr",null,"String (50)","General",null,"Cross Street"]
[null,"maploc",null,"String (10)","General",null,"Map Location"]
[null,"bilad1",null,"String (50)","Other",null,"Billing Addr 1"]
[null,"bilad2",null,"String (50)","Other",null,"Billing Addr 2"]
[null,"bilcty",null,"String (50)","Other",null,"Billing City"]
[null,"bilste",null,"String (2)","Other",null,"Billing State"]
[null,"bilzip",null,"String (10)","Other",null,"Billing Zip"]
[null,"shpad1",null,"String (50)","Other",null,"Shipping Addr 1"]
[null,"shpad2",null,"String (50)","Other",null,"Shipping Addr 2"]
[null,"shpcty",null,"String (50)","Other",null,"Shipping City"]
[null,"shpste",null,"String (2)","Other",null,"Shipping State"]
[null,"shpzip",null,"String (10)","Other",null,"Shipping Zip"]
[null,"stmeml",null,"String (75)","Other",null,"Statement Email"]
[null,"bilbas","**","Numeric","Billing","1=Last Cost;2=Avg Cost;3=BillAmt","Billing Basis"]
[null,"clndsc",null,"Numeric (4,2)","Billing",null,"Discount"]
[null,"pchnum",null,"String (30)","Billing",null,"PO#"]
[null,"exmnum",null,"String (15)","Billing",null,"Sales Tax Exempt#"]
[null,"crdtyp",null,"String (30)","Billing",null,"Reference 1"]
[null,"crdnum","***","String (64)","Billing","[Encrypted Field]","Reference 2"]
[null,"crdnme",null,"String (30)","Billing",null,"Reference 3"]
[null,"expdte",null,"Date","Billing",null,"Reference Date"]
[null,"nvrvlt",null,"Numeric","Billing","0=False;1=True","Never use Sage Exchange Vault"]
[null,"pchdte",null,"Date","Sales","yyyy-mm-dd","Purchase Date"]
[null,"dtercv",null,"Date","Sales","yyyy-mm-dd","Date Received"]
[null,"cllbck",null,"Date","Sales","yyyy-mm-dd","Call Back"]
[null,"lstctc",null,"Date","Sales","yyyy-mm-dd","Contact"]
[null,"refdte",null,"Date","Sales","yyyy-mm-dd","Reference Date"]
[null,"grting",null,"String (50)","Sales",null,"Greeting"]
[null,"lstmal",null,"String (30)","Sales",null,"Mail Piece"]
[null,"lstdte",null,"Date","Sales","yyyy-mm-dd","Date Mailed"]
[null,"prdnum","**","Numeric","Sales",null,"Product Type"]
[null,"ledsrc","**","Numeric","Sales",null,"Source"]
[null,"region","**","Numeric","Sales",null,"Area"]
[null,"cmpsze","**","Numeric","Sales",null,"Size"]
[null,"mallst","**","Numeric","Sales",null,"Mail List"]
[null,"mannum","**","Numeric","Sales",null,"Manager"]
[null,"empnum","**","Numeric","Sales",null,"Salesperson"]
[null,"usrdf1",null,"String (50)","Sales",null,"User Def 1"]
[null,"usrdf2",null,"String (50)","Sales",null,"User Def 2"]
[null,"usrdf3",null,"String (50)","Sales",null,"User Def 3"]
[null,"usrdf4",null,"String (50)","Sales",null,"User Def 4"]
[null,"usrdf5",null,"String (50)","Sales",null,"User Def 5"]
[null,"usrdf6",null,"Numeric","Sales","0=False;1=True","User Def 6 (Checkbox)"]
[null,"usrdf7",null,"Numeric","Sales","0=False;1=True","User Def 7 (Checkbox)"]
[null,"usrdf8",null,"Numeric","Sales","0=False;1=True","User Def 8 (Checkbox)"]
[null,"usrdf9",null,"Numeric","Sales","0=False;1=True","User Def 9 (Checkbox)"]
[null,"ntetxt",null,"Text","Header",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor "]
[null,"*** Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF "]
[null,"1) Go To 7-1 Company Information"]
[null,"2) Click Options, then Database Security Encryption"]
[null,"3) Select \"OFF\" "]
[]
[null,"File Example:"]
[null,"filetype,recnum,clnnme,shtnme,status,addrs1,ctynme,state_"]
[null,"ARCL,101,\"ABC Company\",\"ABC Co\",1,\"123 Silver Creek\",\"Newport Beach\",\"CA\""]
[null,"ARCL,102,\"AJ Construction\",\"AJ Const\",1,\"34 Dover Shores\",\"Costa Mesa\",\"CA\""]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":64,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sample Template",null,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","Full Client Name","Short Name","Status","Client Type","General Addr 1","General Addr 2","General City","General State","General Zip","Tax District","Due Terms","Discount Terms","Discount Rate","Finance Rate","Cross Street","Map Location","Billing Addr 1","Billing Addr 2","Billing City","Billing State","Billing Zip","Shipping Addr 1","Shipping Addr 2","Shipping City","Shipping State","Shipping Zip","Statement Email","Billing Basis","Discount","PO#","Sales Tax Exempt#","Reference 1","Reference 2 ***","Reference 3","Reference Date","Never use Sage Exchange Vault","Purchase Date","Date Received","Call Back","Contact","Reference Date","Greeting","Mail Piece","Date Mailed","Product Type","Source","Area","Size","Mail List","Manager","Salesperson","User Def 1","User Def 2","User Def 3","User Def 4","User Def 5","User Def 6 (Checkbox)","User Def 7 (Checkbox)","User Def 8 (Checkbox)","User Def 9 (Checkbox)","Notes"]
[null,"ARCL","Numeric","String (75)","String (30)","Numeric","Numeric","String (50)","String (50)","String (50)","String (2)","String (10)","Numeric","String (5)","String (5)","Numeric (3,2)","Numeric (3,2)","String (50)","String (10)","String (50)","String (50)","String (50)","String (2)","String (10)","String (50)","String (50)","String (50)","String (2)","String (10)","String (75)","Numeric","Numeric (4,2)","String (30)","String (15)","String (30)","String (64)","String (30)","Date","Numeric","Date","Date","Date","Date","Date","String (50)","String (30)","Date","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","String (50)","String (50)","String (50)","String (50)","String (50)","Numeric","Numeric","Numeric","Numeric","Text"]
[null,null,"Header","Header","Header","Header","Header","General","General","General","General","General","General","General","General","General","General","General","General","Other","Other","Other","Other","Other","Other","Other","Other","Other","Other","Other","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Sales","Header"]
[]
["First Line of File==>","filetype","recnum","clnnme","shtnme","status","clntyp","addrs1","addrs2","ctynme","state_","zipcde","taxdst","duetrm","dsctrm","dscrte","finrte","crsstr","maploc","bilad1","bilad2","bilcty","bilste","bilzip","shpad1","shpad2","shpcty","shpste","shpzip","stmeml","bilbas","clndsc","pchnum","exmnum","crdtyp","crdnum","crdnme","expdte","nvrvlt","pchdte","dtercv","cllbck","lstctc","refdte","grting","lstmal","lstdte","prdnum","ledsrc","region","cmpsze","mallst","mannum","empnum","usrdf1","usrdf2","usrdf3","usrdf4","usrdf5","usrdf6","usrdf7","usrdf8","usrdf9","ntetxt"]
[null,"ARCL",991,"ABC Company","ABC Co",1,null,null,null,null,null,null,null,null,null,null,null,"cs 1","ml 1",null,null,null,null,null,null,null,null,null,null,"email1@gmail.com"]
[null,"ARCL",992,"Gen Contractor Supreme","Gen Cont Sup",1,null,null,null,null,null,null,null,null,null,null,null,"cs 2","ml 2",null,null,null,null,null,null,null,null,null,null,"email2@gmail.com"]