{"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":91,"n_cols":7,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"version: 2024-01-08"]
[]
[null,"Accounts Receivable - 3-5 Jobs"]
[]
[null,"The following template should be used to import one or more Jobs into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Field","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","ARJOB",null,"ARJOB","(File Type Code)"]
[null,"recnum","Required","Numeric","Header",2019001,"Job No"]
[null,"jobnme","Required(I)","String (75)","Header","Newtown Apartments","Job Name"]
[null,"shtnme","Required(I)","String (30)","Header","Newtown Apts","Short Name"]
[null,"status","Required(I)","Numeric","Header","1-Bid;2-Refused;3-Contract;4-Current;5-Complete;6-Closed","Job Status"]
[null,"jobtyp","**","Numeric","Header",null,"Job Type No"]
[null,"clnnum","**","Numeric","General",null,"Client No"]
[null,"addrs1",null,"String (50)","General",null,"Job Addr1"]
[null,"addrs2",null,"String (50)","General",null,"Job Addr2"]
[null,"ctynme",null,"String (50)","General",null,"Job City"]
[null,"state_",null,"String (2)","General",null,"Job State"]
[null,"zipcde",null,"String (10)","General",null,"Job Zip"]
[null,"slstax","**","Numeric","General",null,"Sales Tax District"]
[null,"lcltax","**","Numeric","General",null,"Payroll Locale"]
[null,"dscdte",null,"String (6)","General",null,"Discount Terms"]
[null,"duedte",null,"String (6)","General",null,"Due Terms"]
[null,"dsccnt",null,"Numeric (3,2)","General",null,"Discount Rate"]
[null,"finchg",null,"Numeric (3,2)","General",null,"Finance Rate"]
[null,"retain",null,"Numeric (3,2)","General",null,"Retainage Rate"]
[null,"cntrct",null,"Numeric (10,2)","General",null,"Contract Amount"]
[null,"lgract","**","Numeric","General",4000,"Income Account"]
[null,"dptmnt","**","Numeric","General",null,"Department"]
[null,"connum",null,"String (30)","General",null,"Contract No"]
[null,"pchord",null,"String (30)","General",null,"Client PO No"]
[null,"pstwip",null,"Numeric","General","1=Yes;0=No","Post Expenses to WIP asset Account"]
[null,"crtfid",null,"Numeric","General","1=Yes;0=No","Requires Certified Payroll Reporting"]
[null,"fedsck",null,"Numeric","General","1=Yes;0=No","Requires Federal sick leave accrual"]
[null,"achtct","**","Numeric","Contacts",null,"Architect"]
[null,"lender","**","Numeric","Contacts",null,"Lender"]
[null,"sprvsr","**","Numeric","Contacts",null,"Supervisor"]
[null,"slsemp","**","Numeric","Contacts",null,"Salesperson"]
[null,"estemp","**","Numeric","Contacts",null,"Estimator"]
[null,"usrdf1",null,"String (50)","Contacts",null,"User Def 1"]
[null,"usrdf2",null,"String (50)","Contacts",null,"User Def 2"]
[null,"stmeml",null,"String (75)","Contacts",null,"Statement Email"]
[null,"ncrtck",null,"Numeric","Contacts","1=Yes;0=No","Do not check job for missing vendor certs"]
[null,"biddte",null,"Date","Project Dates","yyyy-mm-dd","Bid Opening Date"]
[null,"plnrcv",null,"Date","Project Dates","yyyy-mm-dd","Plan Received Date"]
[null,"actbid",null,"Date","Project Dates","yyyy-mm-dd","Bid Completed Date"]
[null,"ctcdte",null,"Date","Project Dates","yyyy-mm-dd","Contract Signed Date"]
[null,"prelen",null,"Date","Project Dates","yyyy-mm-dd","Pre-Lien Filed Date"]
[null,"sttdte",null,"Date","Project Dates","yyyy-mm-dd","Project Started Date"]
[null,"cmpdte",null,"Date","Project Dates","yyyy-mm-dd","Project Completed Date"]
[null,"lenfld",null,"Date","Project Dates","yyyy-mm-dd","Lien Filed Date"]
[null,"lenrls",null,"Date","Project Dates","yyyy-mm-dd","Lien Released Date"]
[null,"lotclr",null,"String (30)","Project Dates",null,"Color Scheme"]
[null,"lotprm",null,"Numeric (10,2)","Project Dates",null,"Lot Premium"]
[null,"plnprc",null,"Numeric (10,2)","Project Dates",null,"Est Sales Price"]
[null,"actprc",null,"Numeric (10,2)","Project Dates",null,"Actual Sales Price"]
[null,"estdte",null,"Date","Project Dates","yyyy-mm-dd","Estimated Closing Date"]
[null,"actdte",null,"Date","Project Dates","yyyy-mm-dd","Actual Closing Date"]
[null,"lotnum",null,"String (10)","Project Dates",null,"Lot Number"]
[null,"modnme",null,"String (30)","Project Dates",null,"Model Name"]
[null,"sqarft",null,"Numeric","Project Dates",null,"Square Feet"]
[null,"ntetxt",null,"Text","Header",null,"Notes"]
[null,"county",null,"String (50)","Certified Payroll",null,"Project County"]
[null,"fednum",null,"String (25)","Certified Payroll",null,"Federal Project#"]
[null,"stenum",null,"String (25)","Certified Payroll",null,"State Project#"]
[null,"typwrk",null,"String (50)","Certified Payroll",null,"Type of Work"]
[null,"awddte",null,"Date","Certified Payroll","yyyy-mm-dd","Award Date"]
[null,"strdte",null,"Date","Certified Payroll","yyyy-mm-dd","First Payroll Ending Date"]
[null,"dtecmp",null,"Date","Certified Payroll","yyyy-mm-dd","Completion Date"]
[null,"pctcmp",null,"Numeric","Certified Payroll","0 - 100","Percent Complete"]
[null,"subcnt",null,"Numeric","Certified Payroll","1=Yes;0=No","Working as Subcontractor"]
[null,"prmnme",null,"String (50)","Certified Payroll",null,"Prime Contractor Name"]
[null,"prmadd",null,"String (50)","Certified Payroll",null,"Prime Contractor Address"]
[null,"prmcty",null,"String (50)","Certified Payroll",null,"Prime Contractor City"]
[null,"prmste",null,"String (2)","Certified Payroll",null,"Prime Contractor State"]
[null,"prmzip",null,"String (10)","Certified Payroll",null,"Prime Contractor Zip"]
[null,"prmphn",null,"String (14)","Certified Payroll",null,"Prime Contractor Phone#"]
[null,"prmeml",null,"String (75)","Certified Payroll",null,"Prime Contractor Email"]
[null,"inactv",null,"Numeric","Menu","1=Yes;0=No","Inactive Record"]
[]
[null,"Required(I) - required for inserts only"]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[]
[null,"File Example:"]
[null,"filetype,recnum,jobnme,shtnme,status,lgract"]
[null,"ARJOB,2019021,\"ACE Apartments\",\"ACE Apt\",4,4000"]
[null,"ARJOB,2019021,\"34 Walkway Place\",\"Walkwayt\",4,4000"]

{"sheet":"Template","index":1,"n_rows":11,"n_cols":73,"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","Job No","Job Name","Short Name","Job Status","Job Type No","Client No","Job Addr1","Job Addr2","Job City","Job State","Job Zip","Sales Tax District","Payroll Locale","Discount Terms","Due Terms","Discount Rate","Finance Rate","Retainage Rate","Contract Amount","Income Account","Department","Contract No","Client PO No","Post Expenses to WIP asset Account","Requires Certified Payroll Reporting","Requires Federal sick leave accrual","Architect","Lender","Supervisor","Salesperson","Estimator","User Def 1","User Def 2","Statement Email","Do not check job for missing vendor certs","Bid Opening Date","Plan Received Date","Bid Completed Date","Contract Signed Date","Pre-Lien Filed Date","Project Started Date","Project Completed Date","Lien Filed Date","Lien Released Date","Color Scheme","Lot Premium","Est Sales Price","Actual Sales Price","Estimated Closing Date","Actual Closing Date","Lot Number","Model Name","Square Feet","Notes","Project County","Federal Project#","State Project#","Type of Work","Award Date","First Payroll Ending Date","Completion Date","Percent Complete","Working as Subcontractor","Prime Contractor Name","Prime Contractor Address","Prime Contractor City","Prime Contractor State","Prime Contractor Zip","Prime Contractor Phone#","Prime Contractor Email","Inactive Record"]
[null,"ARJOB","Numeric","String (75)","String (30)","Numeric","Numeric","Numeric","String (50)","String (50)","String (50)","String (2)","String (10)","Numeric","Numeric","String (6)","String (6)","Numeric (3,2)","Numeric (3,2)","Numeric (3,2)","Numeric (10,2)","Numeric","Numeric","String (30)","String (30)","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","String (50)","String (50)","String (75)","Numeric","Date","Date","Date","Date","Date","Date","Date","Date","Date","String (30)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Date","Date","String (10)","String (30)","Numeric","Text","String (50)","String (25)","String (25)","String (50)","Date","Date","Date","Numeric","Numeric","String (50)","String (50)","String (50)","String (2)","String (10)","String (14)","String (75)","Numeric"]
[null,null,"Header","Header","Header","Header","Header","General","General","General","General","General","General","General","General","General","General","General","General","General","General","General","General","General","General","General","General","General","Contacts","Contacts","Contacts","Contacts","Contacts","Contacts","Contacts","Contacts","Contacts","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Project Dates","Header","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Certified Payroll","Menu"]
[]
["First Line of File==>","filetype","recnum","jobnme","shtnme","status","jobtyp","clnnum","addrs1","addrs2","ctynme","state_","zipcde","slstax","lcltax","dscdte","duedte","dsccnt","finchg","retain","cntrct","lgract","dptmnt","connum","pchord","pstwip","crtfid","fedsck","achtct","lender","sprvsr","slsemp","estemp","usrdf1","usrdf2","stmeml","ncrtck","biddte","plnrcv","actbid","ctcdte","prelen","sttdte","cmpdte","lenfld","lenrls","lotclr","lotprm","plnprc","actprc","estdte","actdte","lotnum","modnme","sqarft","ntetxt","county","fednum","stenum","typwrk","awddte","strdte","dtecmp","pctcmp","subcnt","prmnme","prmadd","prmcty","prmste","prmzip","prmphn","prmeml","inactv"]
[null,"ARJOB",2019008,"Test Job 1","TJ1",4]
[null,"ARJOB",2019009,"Test Job 2","TJ2",4]
[null,"ARJOB",2019010,"Test Job 3","TJ3",4]