{"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":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,1,26,6]]}
[null,null,null,null,"version: 2023-04-11"]
[]
[null,"Accounts Receivable - 3-5 Job Contacts"]
[]
[null,"The following template should be used to import one or more Jobs into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","ARJOBCONT",null,"ARJOBCONT","ARJOBCONT"]
[null,"recnum","Required **","Numeric","Contacts",2019021,"Job No"]
[null,"cntnme","Required **","String (50)","Contacts","John Doe","Contact Name"]
[null,"jobttl",null,"String (50)","Contacts","President","Job Title"]
[null,"phnnum",null,"String (14)","Contacts",null,"Phone No"]
[null,"phnext",null,"String (6)","Contacts",null,"Phone Ext"]
[null,"e_mail",null,"String (75)","Contacts","jdoe@gmail.com","Email"]
[null,"cllphn",null,"String (14)","Contacts",null,"Cell Phone"]
[null,"faxnum",null,"String (14)","Contacts",null,"Fax No"]
[null,"othphn",null,"String (14)","Contacts",null,"Other Phone"]
[null,"othdsc",null,"String (50)","Contacts",null,"Other Description"]
[null,"ntetxt",null,"Text","Contacts",null,"Notes"]
[null,"linnum","(1)","Numeric","Contacts",null,"Line Number"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"(1) If a line number is specified the record will either update the existing line number if it exists or it will be inserted as this line no. If no line number is specified then the record will be auto assigned a line number or the combination of the recnum and the contact name will be evaluated to determine if the record exists"]
[]
[null,"File Example:"]
[null,"filetype,recnum,cntnme,jobttl"]
[null,"ARJOBCONT,2017504,\"Steve Harold\",\"President\""]
[null,"ARJOBCONT,2017504,\"Mark Rice\",\"Manager\""]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":14,"rows_kept":10,"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","Job No","Contact Name","Job Title","Phone No","Phone Ext","Email","Cell Phone","Fax No","Other Phone","Other Description","Notes","Line No"]
[null,"ARJOBCONT","Numeric","String (50)","String (50)","String (14)","String (6)","String (75)","String (14)","String (14)","String (14)","String (50)","Text","Numeric"]
[]
["First Line of File==>","filetype","recnum","cntnme","jobttl","phnnum","phnext","e_mail","cllphn","faxnum","othphn","othdsc","ntetxt","linnum"]
[null,"ARJOBCONT",2017504,"Joe Doe","Owner",null,null,null,null,null,null,null,null,1]
[null,"ARJOBCONT",2017504,"Jane Doe","Project Manager",null,null,null,null,null,null,null,null,2]
[null,"ARJOBCONT",2017504,"Mia Doe","Accountant",null,null,null,null,null,null,null,null,3]