{"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":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"Accounts Payable - 4-4 Vendor Certificates"]
[]
[null,"The following template should be used to import one or more Vendor Certificates into Sage 100 Contractor.  "]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","APVENDCERT",null,"APVENDCERT","APVENDCONT"]
[null,"recnum","Required","Numeric","Certificates",231,"Vendor No"]
[null,"dscrpt","Required (1)","String (50)","Certificates","General Liability","Certificate Description"]
[null,"expdte","Required","Date","Certificates","YYYY-MM-DD","Expires"]
[null,"jobnum","**","Numeric","Certificates",null,"Job No"]
[null,"dtercv",null,"Date","Certificates","YYYY-MM-DD","Date Received"]
[null,"cntwrn",null,"String (1)","Certificates","Y=Yes; N=No","Warning"]
[null,"stppay",null,"String (1)","Certificates","Y=Yes; N=No","Stop Pay"]
[null,"ntetxt",null,"Text","Certificates",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"(1) The description field is treated as a key field and therefore considered to be unique and not used more than once. When updating records the \"Description\" is used in determining which row to update. If the description is not found then a new record will be created if \"Inserts\" are allowed."]
[]
[]
[null,"File Example:"]
[null,"filetype,recnum,dscrpt,expdte,jobnum,dtercv,cntwrn,stppay,ntetxt"]
[null,"APVENDCERT,231,\"General Liability\",\"12/31/2020\",,\"\",\"\",\"\",\"\""]
[null,"APVENDCERT,231,\"Workers Compensation\",\"11/30/2020\",,\"\",\"\",\"\",\"\""]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":10,"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 Code","Vendor No","Certificate Description (1)","Expires","Job No","Date Received","Warning","Stop Pay","Notes"]
[null,"APVENDCERT","Numeric","String (50)","Date","Numeric","Date","String (1)","String (1)","Text"]
[null,null,"Certificates","Certificates","Certificates","Certificates","Certificates","Certificates","Certificates","Certificates"]
[]
["First Line of File==>","filetype","recnum","dscrpt","expdte","jobnum","dtercv","cntwrn","stppay","ntetxt"]
[null,"APVENDCERT",231,"General Liability","2020-12-31"]
[null,"APVENDCERT",231,"Workers Compensation","2020-11-30"]