{"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":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Estimating - 9-2 Parts"]
[]
[null,"The following template should be used to import one or more equipment items into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","ESPART",null,"ESPART","ESPART"]
[null,"recnum","Required","Numeric","Header",null,"Part No"]
[null,"prtnme","Required(I)","String (75)","Header",null,"Part Description"]
[null,"prtunt","Required(I)","String (10)","Header","i.e. ea, sf, lf, lb","Unit Type"]
[null,"alpnum",null,"String (50)","Header",null,"Alpha Part No"]
[null,"prtcls","**","Numeric","Header",null,"Part Class"]
[null,"cstcde","**","Numeric (12,3)","Header",null,"Cost Code"]
[null,"csttyp","**","Numeric","Header","1-Mat,2-Lab,3-equip,4-sub,5-oth,6-udf,7-udf,8-udf,9-udf","Cost Type"]
[null,"prttsk","**","Numeric (11,3)","Header",null,"Task No"]
[null,"mannme",null,"String (50)","Header",null,"Manufacturer"]
[null,"mannum",null,"String (30)","Header",null,"Manufacturer Part No"]
[null,"msdsnm",null,"String (30)","Header",null,"MSDS No"]
[null,"usrdf1",null,"String (50)","Header",null,"User Def1"]
[null,"usrdf2",null,"String (50)","Header",null,"User Def2"]
[null,"prtcst",null,"Numeric (9,6)","Cost Bill Order",null,"Default Cost"]
[null,"lstupd",null,"Date","Cost Bill Order","yyyy-mm-dd","Last Updated"]
[null,"mrkupr",null,"Numeric (4,2)","Cost Bill Order",null,"Markup Pct"]
[null,"prtbil",null,"Numeric (9,6)","Cost Bill Order",null,"Billing Amount"]
[null,"minord",null,"Numeric (10,2)","Cost Bill Order",null,"Min Order Qty"]
[null,"pkgqty",null,"Numeric (10,2)","Cost Bill Order",null,"Package Qty"]
[null,"prtwgt",null,"Numeric (10,2)","Cost Bill Order",null,"Unit Weight"]
[null,"labnum","**","Numeric","Labor",null,"Labor Part No"]
[null,"labunt",null,"Numeric (9,6)","Labor",null,"Labor Qty"]
[null,"stkitm",null,"Numeric","Inventory","1=Yes;0=No","Stock Item"]
[null,"serinv",null,"Numeric","Inventory","1=Yes;0=No","Serialized Item"]
[null,"reqivt",null,"Numeric","Inventory","1=Yes;0=No","Required From Inv."]
[null,"dftloc","**","Numeric","Inventory",null,"Default Location No"]
[null,"binnum",null,"String (10)","Inventory",null,"Bin No"]
[null,"reordr",null,"Numeric (10,2)","Inventory",null,"Reorder Qty"]
[null,"srvprt",null,"Numeric","Service Equip","1=Yes;0=No","Service Equip Item"]
[null,"oemdur",null,"Numeric","Service Equip",null,"OEM Warranty Duration"]
[null,"ntetxt",null,"Text","Header",null,"Notes"]
[]
[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,prtnme,prtunt,alpnum,prtcls,cstcde,csttyp,prttsk"]
[null,"PART,19101,\"Part #1\",\"ea\",\"\",1,2120.000,,"]
[null,"PART,19102,\"Part #2\",\"ea\",\"\",1,2120.000,,"]
[null,"PART,19103,\"Part #3\",\"ea\",\"\",1,2120.000,,"]

{"sheet":"Template","index":1,"n_rows":11,"n_cols":33,"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,"File Type","Part No","Part Description","Unit Type","Alpha Part No","Part Class **","Cost Code **","Cost Type **","Task No **","Manufacturer","Manufacturer Part No","MSDS No","User Def1","User Def2","Default Cost","Last Updated","Markup Pct","Billing Amount","Min Order Qty","Package Qty","Unit Weight","Labor Part No **","Labor Qty","Stock Item","Serialized Item","Required From Inv.","Default Location No **","Bin No","Reorder Qty","Service Equip Item","OEM Warranty Duration","Notes"]
[null,"ESPART","Numeric","String (75)","String (10)","String (50)","Numeric","Numeric (12,3)","Numeric","Numeric (11,3)","String (50)","String (30)","String (30)","String (50)","String (50)","Numeric (9,6)","Date","Numeric (4,2)","Numeric (9,6)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric","Numeric (9,6)","Numeric","Numeric","Numeric","Numeric","String (10)","Numeric (10,2)","Numeric","Numeric","Text"]
[null,null,"Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Cost Bill Order","Cost Bill Order","Cost Bill Order","Cost Bill Order","Cost Bill Order","Cost Bill Order","Cost Bill Order","Labor","Labor","Inventory","Inventory","Inventory","Inventory","Inventory","Inventory","Service Equip","Service Equip","Header"]
[]
["First Line of File==>","filetype","recnum","prtnme","prtunt","alpnum","prtcls","cstcde","csttyp","prttsk","mannme","mannum","msdsnm","usrdf1","usrdf2","prtcst","lstupd","mrkupr","prtbil","minord","pkgqty","prtwgt","labnum","labunt","stkitm","serinv","reqivt","dftloc","binnum","reordr","srvprt","oemdur","ntetxt"]
[null,"ESPART",19101,"Part #1","ea",null,null,"2120.000",1]
[null,"ESPART",19102,"Part #2","ea",null,null,"2120.000",1]
[null,"ESPART",19103,"Part #3","ea",null,null,"2120.000",1]