{"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":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"Payroll - 5-5-1 Daily Payroll"]
[]
[null,"The following template should be used to import Daily Payroll Entries into Sage 100 Contractor.  "]
[]
[null,"File Layout Specification"]
[]
[null,"Field","Reference","Data Type","Example","Description"]
[null,"filetype","Required","PRDAILY","PRDAILY","(File Type Code)"]
[null,"paydte",null,"Date","yyyy-mm-dd","Time Entry Date"]
[null,"empnum","**","Numeric",null,"Employee No"]
[null,"dscrpt",null,"String (50)",null,"Description"]
[null,"wrkord","**","String (20)",null,"Service WO Recnum"]
[null,"jobnum","**","Numeric","Blank=derived from Service WO","Job No"]
[null,"loctax","**","Numeric",null,"Local Payroll Tax"]
[null,"crtfid",null,"String (1)","Y=yes;N=no;Blank=derived from Job","Certified Payroll"]
[null,"phsnum","**","Numeric",null,"Phase No"]
[null,"cstcde","**","Numeric (12,3)","Blank=derived from Service WO type's corresponding Cost Code","Cost Code"]
[null,"paytyp","**","Numeric",null,"Pay Type"]
[null,"paygrp","**","Numeric","Blank=derived from Employee","Pay Group"]
[null,"payrte",null,"Numeric (6,4)","Blank=derived from Employee based on pay type","Pay Rate"]
[null,"payhrs",null,"Numeric (5,2)",null,"Pay Hours"]
[null,"pcerte",null,"Numeric (6,4)",null,"Pieces Rate"]
[null,"pieces",null,"Numeric (8,2)",null,"Pieces Units"]
[null,"cmpcde","**","Numeric","Blank=derived from Employee","Workers Comp Code"]
[null,"dptmnt","**","Numeric","Blank=derived from Job","Department"]
[null,"eqpnum","**","Numeric",null,"Equip Repaired No"]
[null,"opreqp","**","Numeric",null,"Operated Equipment"]
[null,"eqpunt",null,"Numeric","1=Hours; 2=Days; 3=Weeks; 4=Months; 5=Miles","Equip Cost Unit Type"]
[null,"oprhrs",null,"Numeric (5,2)",null,"Equip Operated Cost Units"]
[null,"stdhrs",null,"Numeric (5,2)",null,"Equip Standby Cost Units"]
[null,"idlhrs",null,"Numeric (5,2)",null,"Equip Idle Cost Units"]
[null,"bllunt",null,"Numeric","1=Hours; 2=Days; 3=Weeks; 4=Months; 5=Miles","Equip Rental Unit Type"]
[null,"oprbll",null,"Numeric (6,2)",null,"Equip Operated Rental Units"]
[null,"stdbll",null,"Numeric (6,2)",null,"Equip Standby Rental Units"]
[null,"idlbll",null,"Numeric (6,2)",null,"Equip Idle Rental Units"]
[null,"usrdf1",null,"String (50)",null,"User Defined"]
[null,"absnce","**","Numeric",null,"Absence"]
[null,"ntetxt",null,"Text",null,"Notes"]
[null,"ntetxt",null,"Text",null,"Notes"]
[]
[null,"** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor"]
[]
[null,"File Example:"]
[null,"filetype,paydte,empnum,dscrpt,paytyp,paygrp,payrte,payhrs,cmpcde"]
[null,"PRDAILY,\"2019-06-23\",8547,\"import time\",1,1,20,8,5606"]
[null,"PRDAILY,\"2019-06-23\",8548,\"import time\",1,1,20,8,5606"]

{"sheet":"Template","index":1,"n_rows":11,"n_cols":32,"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 Code","Time Entry Date","Employee No","Description","Service WO Recnum","Job No","Local Payroll Tax","Certified Payroll","Phase No","Cost Code","Pay Type","Pay Group","Pay Rate","Pay Hours","Pieces Rate","Pieces Units","Workers Comp Code","Department","Equip Repaired No","Operated Equipment","Equip Cost Unit Type","Equip Operated Cost Units","Equip Standby Cost Units","Equip Idle Cost Units","Equip Rental Unit type","Equip Operated Rental Units","Equip Standby Rental Units","Equip Idle Rental Units","User Defined","Absence","Notes"]
[null,"PRDAILY","Date","Numeric","String (50)","String (20)","Numeric","Numeric","String (1)","Numeric","Numeric (12,3)","Numeric","Numeric","Numeric (6,4)","Numeric (5,2)","Numeric (6,4)","Numeric (8,2)","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric (5,2)","Numeric (5,2)","Numeric (5,2)","Numeric","Numeric (6,2)","Numeric (6,2)","Numeric (6,2)","String (50)","Numeric","Text"]
[]
[]
["First Line of File==>","filetype","paydte","empnum","dscrpt","wrkord","jobnum","loctax","crtfid","phsnum","cstcde","paytyp","paygrp","payrte","payhrs","pcerte","pieces","cmpcde","dptmnt","eqpnum","opreqp","eqpunt","oprhrs","stdhrs","idlhrs","bllunt","oprbll","stdbll","idlbll","usrdf1","absnce","ntetxt"]
[null,"PRDAILY","2019-07-16",11,null,null,null,null,null,null,null,1,null,20,8,null,null,8810]
[null,"PRDAILY","2019-07-15",11,null,null,null,null,null,null,null,1,null,22,8,null,null,8810]
[null,"PRDAILY","2019-07-14",11,null,null,null,null,null,null,null,1,null,24,8,null,null,8810]