{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","Purchase Order Form","Flat Template","Grid Sample","misc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":79,"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":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"Project Management - 6-6-1 Purchase Orders"]
[]
[null,"The following template should be used to import Purchase Orders into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","String (4)",null,"PJPO","(File Type Code)"]
[null,"linetype","Required","String (1)",null,"H","Header Record"]
[null,"ordnum","Required [*]","String (20)","Header",null,"PO Number"]
[null,"vndnum","Required [*] **","Numeric","Header",null,"Vendor No"]
[null,"orddte","Required (I)","Date","Header","yyyy-mm-dd","PO Date"]
[null,"dscrpt","Required (I)","String (50)","Header",null,"Description"]
[null,"status","Required (I) **","Numeric","Header","1-Open, 2-Review, 3-Dispute, 4-Closed, 5-Void, 6-Master","Status"]
[null,"ordtyp","** (1)","Numeric","Header",null,"PO Type"]
[null,"attion",null,"String (50)","Header",null,"Attention"]
[null,"wrkord","** (2)","String (20)","Header",null,"Work Order No"]
[null,"jobnum","** (2)","Numeric","Header",null,"Job No"]
[null,"phsnum","**","Numeric","Header",null,"Phase No"]
[null,"eqpmnt","**","Numeric","Header",null,"Equipment No"]
[null,"tsknum",null,"Numeric (11,3)","Header",null,"Task No"]
[null,"taxdst",null,"Numeric","Header",null,"Tax District"]
[null,"appdte",null,"Date","Header","yyyy-mm-dd","Approved Date"]
[null,"schdte",null,"Date","Header","yyyy-mm-dd","Scheduled Date"]
[null,"deldte",null,"Date","Header","yyyy-mm-dd","Delivery Date"]
[null,"delvia",null,"String (60)","Header",null,"Via"]
[null,"ordtrm",null,"String (6)","Header","##DY,##TH or ##MO","Terms"]
[null,"odrdby","**","Numeric","Header",null,"Ordered By"]
[null,"addrs1",null,"String (50)","Header",null,"Address 1"]
[null,"addrs2",null,"String (50)","Header",null,"Address 2"]
[null,"ctynme",null,"String (50)","Header",null,"City"]
[null,"state_",null,"String (2)","Header",null,"State"]
[null,"zipcde",null,"String (10)","Header",null,"Zip Code"]
[null,"usrdf1",null,"String (50)","Header",null,"User Def 1"]
[null,"usrdf2",null,"String (50)","Header",null,"User Def 2"]
[null,"hotlst",null,"Numeric","Header",null,"Hot List"]
[null,"lckedt",null,"Numeric","Header",null,"Lock Edit"]
[null,"ntetxt",null,"Text","Header",null,"Notes"]
[]
[null,"Required (I) - required for Inserts only"]
[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) Leave blank for '0 - None'"]
[null,"(2) If a Work Order No is specified, Job No should be left blank as it will be derived from the Work Order"]
[]
[null,"Purchase Order Details"]
[null,"filetype","Required","String (4)",null,"PJPO","PJPO"]
[null,"linetype","Required","String (1)",null,"D","Detail Record"]
[null,"ordnum","Required [*]","String (20)","Header",null,"PO Number"]
[null,"vndnum","Required [*] **","Numeric","Header",null,"Vendor No"]
[null,"linnum","[*] (1)","Numeric","Detail",1,"Line No"]
[null,"prtnum","**","Numeric","Detail",0,"Part No"]
[null,"prtdsc","Required (I)","String (75)","Detail",null,"Line Description"]
[null,"untdsc",null,"String (10)","Detail",null,"Unit of Measure"]
[null,"linqty",null,"Numeric (8,4)","Detail",null,"Quantity"]
[null,"linprc","(2)","Numeric (9,6)","Detail",null,"Price"]
[null,"currnt",null,"Numeric (8,4)","Detail",null,"Current"]
[null,"cancel",null,"Numeric (8,4)","Detail",null,"Canceled"]
[null,"cstcde","**","Numeric (12,3)","Detail",null,"Cost Code"]
[null,"csttyp","**","Numeric","Detail",null,"Cost Type"]
[null,"invloc","**","Numeric","Detail",null,"Inventory Location"]
[null,"lgract","**","Numeric","Detail",null,"Account"]
[null,"subact","**","Numeric","Detail",null,"Subaccount"]
[null,"usrdf1",null,"String (50)","Detail",null,"User Defined"]
[null,"ntetxt",null,"Text","Detail",null,"Notes"]
[null,"taxabl",null,"String (1)","Detail","Y-Yes, N-No or blank","Taxable"]
[]
[null,"Required (I) - required for Inserts only"]
[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) Null/Empty = line no will be automatically derived; Specified line no must be unique based on the Key pair"]
[null,"(2) Price may not be a negative value. If the line amount is negative you must make the \"Quantity\" negative"]
[]
[]
[null,"File Example:"]
[null,"!PJPO,H,ordnum,vndnum,orddte,dscrpt,status,ordtyp,attion,wrkord,jobnum,phsnum,eqpmnt,tsknum,taxdst,appdte,schdte,deldte,delvia,ordtrm,odrdby,addrs1,addrs2,ctynme,state_,zipcde,usrdf1,usrdf2,hotlst,lckedt,ntetxt"]
[null,"!PJPO,D,ordnum,vndnum,linnum,prtnum,prtdsc,untdsc,linqty,linprc,currnt,cancel,cstcde,csttyp,invloc,lgract,subact,usrdf1,ntetxt,taxabl"]
[null,"PJPO,H,\"PO 2\",231,\"2019-07-13\",\"PO Test 2\",1,,\"\",\"\",2017008,,,,,\"\",\"\",\"\",\"\",\"\",,\"\",\"\",\"\",\"\",\"\",\"\",\"\",,,\"\""]
[null,"PJPO,D,\"PO 2\",231,,,\"poline 1\",\"\",10,50,75,1,2120.000,1,,1211,,\"\",\"\",\"Y\""]
[null,"PJPO,D,\"PO 2\",231,,,\"poline 2\",\"\",10,75,20,,,,,,,\"\",\"\",\"N\""]

{"sheet":"Purchase Order Form","index":1,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[14,2,14,3],[7,7,7,8],[8,7,8,8],[9,7,9,8],[13,7,13,8],[12,7,12,8]]}
["Sample Purchase Order Form"]
[]
[]
[null,"Order No: *","PO Test #1","Approved  Date: ",null,null,"Status: *",1]
[null,"Order Date: *","07/20/2019","Scheduled Date: ",null,null,"Type: "]
[null,"Vendor: *",231,"Delivery Date: ",null,null,"Orderd By: "]
[null,"Attention: ",null,"Via: "]
[null,"Description: *","PO Test #1","Terms: ",null,null,"Addr 1: "]
[null,"Job: ",2017008,null,null,null,"Addr 2: "]
[null,"Phase: ",null,null,null,false,"City: "]
[null,"Equipment: ",null,"","",false,"State: "]
[null,"Task: ",null,null,null,null,"Zip: "]
[null,"Tax District: ",null,null,null,null,"User Def 1: "]
[null,null,null,null,null,null,"User Def 2: "]
[null,"Notes:",null,null,null,null,false]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F20:F6002)","v":5},{"$f":"SUM(G20:G6002)","v":125}]
[null,null,"Part No","Line Description *","Unit","Quantity","Price","Current","Canceled","Cost Code","Cost Type","Inventory\nLocation","Account","Subaccount","User Defined","Notes","Taxable"]
[null,null,null,"PO Line 1",null,2,50,null,null,"2020.000",null,4,null,null,null,null,"Y"]
[null,null,null,"PO Line2",null,3,75,null,null,"2010.000",null,4,null,null,null,null,"N"]

{"sheet":"Flat Template","index":2,"n_rows":12,"n_cols":46,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,1,4,29],[4,30,4,45]]}
["Sample Flat Template",null,"Note: you may delete any column from this template that is not used or needed other than the Required Columns"]
[]
[]
[]
[null,"Header",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order Details"]
[null,"PO Number","Vendor No","PO Date","Description","Status","PO Type","Attention","Work Order No","Job No","Phase No","Equipment No","Task No","Tax District","Approved Date","Scheduled Date","Delivery Date","Via","Terms","Ordered By","Address 1","Address 2","City","State","Zip Code","User Def 1","User Def 2","Hot List","Lock Edit","Notes","Line No","Part No","Line Description","Unit of Measure","Quantity","Price","Current","Canceled","Cost Code","Cost Type","Inventory Location","Account","Subaccount","User Defined","Notes","Taxable"]
[null,"String (20)","Numeric","Date","String (50)","Numeric","Numeric","String (50)","String (20)","Numeric","Numeric","Numeric","Numeric (11,3)","Numeric","Date","Date","Date","String (60)","String (10)","Numeric","String (50)","String (50)","String (50)","String (2)","String (10)","String (50)","String (50)","Numeric","Numeric","Text","Numeric","Numeric","String (75)","String (10)","Numeric (8,4)","Numeric (9,6)","Numeric (8,4)","Numeric (8,4)","Numeric (12,3)","Numeric","Numeric","Numeric","Numeric","String (50)","Text","String(1)"]
[null,"Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Header","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail","Detail"]
[]
[null,"ordnum","vndnum","orddte","dscrpt","status","ordtyp","attion","wrkord","jobnum","phsnum","eqpmnt","tsknum","taxdst","appdte","schdte","deldte","delvia","ordtrm","odrdby","addrs1","addrs2","ctynme","state_","zipcde","usrdf1","usrdf2","hotlst","lckedt","ntetxt","linnum","prtnum","prtdsc","untdsc","linqty","linprc","currnt","cancel","cstcde","csttyp","invloc","lgract","subact","usrdf1","ntetxt","taxabl"]
["First Line of File ==>","PO 2",231,"2019-07-13","PO Test 2",1,null,null,null,2017008,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1","123","poline 1",null,10,50,75,1,"2120.000",1,null,1211,null,null,null,"Y"]
[null,"PO 2",231,"2019-07-13","PO Test 2",1,null,null,null,2017008,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2","456","poline 2",null,10,75,20,null,null,null,null,null,null,null,null,"N"]

{"sheet":"Grid Sample","index":3,"n_rows":11,"n_cols":32,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Sample Grid Template"]
[]
[]
[null,"COL1","COL2","COL3","COL4","COL5","COL6","COL7","COL8","COL9","COL10","COL11","COL12","COL13","COL14","COL15","COL16","COL17","COL18","COL19","COL20","COL21","COL22","COL23","COL24","COL25","COL26","COL27","COL28","COL29","COL30","COL31"]
[null,"PJPO","H","ordnum","vndnum","orddte","dscrpt","status","ordtyp","attion","wrkord","jobnum","phsnum","eqpmnt","tsknum","taxdst","appdte","schdte","deldte","delvia","ordtrm","odrdby","addrs1","addrs2","ctynme","state_","zipcde","usrdf1","usrdf2","hotlst","lckedt","ntetxt"]
[null,"PJPO","D","ordnum","vndnum","linnum","prtnum","prtdsc","untdsc","linqty","linprc","currnt","cancel","cstcde","csttyp","invloc","lgract","subact","usrdf1","ntetxt"]
[]
[]
[null,"PJPO","H","PO 246",231,"2019-07-23","PO 246",1]
[null,"PJPO","D","PO 246",231,null,null,"Line 1 Desc",null,10,30]
[null,"PJPO","D","PO 246",231,null,null,"Line 2 Desc",null,20,25]

{"sheet":"misc","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["1 - Open",null,null,"1 - Mat"]
["2 - Review",null,null,"2 - Lab"]
["3 - Dispute",null,null,"3 - Equip"]
["4 - Closed",null,null,"4 - Sub"]
["5 - Void",null,null,"5 - Other"]
["6 - Master",null,null,"6 - Udf 6"]
[null,null,null,"7 - Udf 7"]
[null,null,null,"8 - Udf 8"]
[null,null,null,"9 - Udf 9"]