{"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":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"Project Management - 6-3 Job Costs"]
[]
[null,"The following template should be used to import one or more PJ Job Costs into Sage 100 Contractor.  "]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","PJJC","Header","PJJC","PJJC"]
[null,"jobnum","Required [*] **","Numeric","Header",null,"Job Number"]
[null,"trndte","Required","Date","Header","yyyy-mm-dd","Transaction Date"]
[null,"actgdte","Required","Date","Header","yyyy-mm-dd","Accounting Posting Period"]
[null,"dscrpt","Required","String(50)","Header",null,"Description"]
[null,"trnnum","Required [*]","String(20)","Header",null,"Transaction Number"]
[null,"cstcde","Required **","Numeric","Header",null,"Cost Code"]
[null,"csttyp","Required **","Numeric","Header","1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=UDF6; 7=UDF7; 8=UDF8; 9=UDF9","Cost Type"]
[null,"cstamt",null,"Numeric (9,2)","Header",null,"Cost Amount"]
[null,"phsnum","[*] **","Numeric","Header",null,"Phase"]
[null,"wrkord","**","String(20)","Header",null,"Work Order Number"]
[null,"empnum","**","Numeric","Employee / Vendor / Equipment",null,"Employee Number"]
[null,"paytyp","**","Numeric","Employee / Vendor / Equipment",null,"Pay Type"]
[null,"payrec","**","Numeric","Employee / Vendor / Equipment"]
[null,"csthrs",null,"Numeric (5,2)","Employee / Vendor / Equipment",null,"Hours"]
[null,"pieces",null,"Numeric (9,2)","Employee / Vendor / Equipment",null,"Pieces"]
[null,"grswge",null,"Numeric (9,2)","Employee / Vendor / Equipment",null,"Gross Wage"]
[null,"vndnum","**","Numeric","Employee / Vendor / Equipment",null,"Vendor Number"]
[null,"eqpnum","**","Numeric","Employee / Vendor / Equipment",null,"Equipment Number"]
[null,"eqptyp","**","Numeric","Employee / Vendor / Equipment","0-None;1-Operated;2-Standby;3-Idle","Equipment Type"]
[null,"eqpunt","**","Numeric","Employee / Vendor / Equipment","0-None;1-Hours;2-Days;3-Weeks;4-Months;5-Miles","Equipment Unit"]
[null,"eqpqty",null,"Numeric (5,2)","Employee / Vendor / Equipment",null,"Equipment Quantity"]
[null,"bllsts","Required **","Numeric","Time and Materials Billing","1-Open;2-Not Billable;3-Billed","Billing Status"]
[null,"blgunt","**","Numeric","Time and Materials Billing","0-None;1-Hours;2-Days;3-Weeks;4-Months;5-Miles;6-Mobilization;7-Not Billable","Billing Equipment Unit"]
[null,"blgqty",null,"Numeric (5,2)","Time and Materials Billing",null,"Billing Quantity"]
[null,"blgamt","(1)","Numeric (9,2)","Time and Materials Billing",null,"Billing Amount (1)"]
[null,"ovrrde",null,"Numeric","Time and Materials Billing","1=Yes;0=No","Override Billing Amount"]
[null,"taxabl",null,"Numeric","Time and Materials Billing","1=Yes;0=No","Subject to Sales Tax"]
[null,"ntetxt",null,"Text","Header",null,"Notes"]
[]
[null,"[*] Key Fields - the combination of theses fields must be unique"]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"(1) Override Billing Amount (ovrrde) must be set to 1 in order to set Billing Amount (blgamt)"]
[]
[]
[null,"File Example:"]
[null,"filetype,jobnum,trndte,dscrpt,trnnum,cstcde,csttyp,cstamt,phsnum,wrkord,empnum,paytyp,payrec,csthrs,pieces,grswge,vndnum,eqpnum,eqptyp,eqpunt,eqpqty,bllsts,blgunt,blgqty,blgamt,ovrrde,taxabl"]
[null,"PJJC,2015034,2020-10-10,\"test2\",\"1234\",2050.000,4,6500,0,\"123\",6,1,193,8,1,30,231,19103,1,1,4,1,0,4,4444,1,1"]
[null,"PJJC,150,2020-10-05,\"Medtronics description\",\"ABC123\",3030.000,1,3000,0,\"123\",6,1,54,10,15,10,9,19102,1,1,17,1,1,10,3000,1,1"]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":30,"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,"PJJC","Job Number","Transaction Date","Accounting Date","Description","Transaction Number","Cost Code","Cost Type","Cost Amount","Phase","Work Order Number","Employee Number","Pay Type","Pay Record Number","Hours","Pieces","Gross Wage","Vendor Number","Equipment Number","Equipment Type","Equipment Unit","Equipment Quantity","Billing Status","Billing Equipment Unit","Billing Quantity","Billing Amount (1)","Override Billing Amount","Subject to Sales Tax","Notes"]
[null,"PJJC","Numeric","Date","Date","String(50)","String(20)","Numeric","Numeric","Numeric (9,2)","Numeric","String(20)","Numeric","Numeric","Numeric","Numeric (5,2)","Numeric (9,2)","Numeric (9,2)","Numeric","Numeric","Numeric","Numeric","Numeric (5,2)","Numeric","Numeric","Numeric (5,2)","Numeric (9,2)","Numeric","Numeric","String"]
[]
[]
["First Line of File==>","filetype","jobnum","trndte","actgdte","dscrpt","trnnum","cstcde","csttyp","cstamt","phsnum","wrkord","empnum","paytyp","payrec","csthrs","pieces","grswge","vndnum","eqpnum","eqptyp","eqpunt","eqpqty","bllsts","blgunt","blgqty","blgamt","ovrrde","taxabl","ntetxt"]
[null,"PJJC",2015034,"2020-10-10","2020-10-10","\"test2\"","\"1234a\"","2050.000",4,6500,0,"\"123\"",6,1,193,8,1,30,231,19103,1,1,4,1,0,4,4444,1,1]
[null,"PJJC",150,"2020-10-05","2020-10-05","\"Medtronics description\"","\"ABC123b\"","3030.000",1,3000,0,"\"123\"",6,1,54,10,15,10,9,19102,1,1,17,1,1,10,3000,1,1]