{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Overview","Grid Sample","Flat Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":170,"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":180,"n_cols":7,"rows_kept":180,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"Service Receivables - 11-2 Work Orders/Invoices Credits"]
[]
[null,"The following template should be used to import Service Work Orders into Sage 100 Contractor.  "]
[]
[null,"File Layout Specification"]
[]
[null,"Header Layout"]
[]
[null,"Field","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required",null,null,"SRWO","(File Type Code)"]
[null,"linetype","Required",null,null,"H","(Header Record)"]
[null,"clnnum","Required [*] **","Numeric","Header",null,"Client No"]
[null,"ordnum","Required [*] **","String (20)","Header",null,"Order No"]
[null,"invnum","Required (I)","String (20)","Header",null,"Invoice No"]
[null,"orddte","Required (I)","Date","Header","yyyy-mm-dd","Order Date"]
[null,"dscrpt","Required (I)","String (75)","Header",null,"Order Description"]
[null,"status","Required (I) ** (1)","Numeric","Header","6-Quote; 7-Work Order; 8-Completed; 9-Route; 10-Contact; { 5-Void }","Order Status"]
[null,"invtyp","Required (I) **","Numeric","Header",null,"Order Type"]
[null,"schdte","Required (I)","Date","Dispatch","yyyy-mm-dd","Scheduled Date"]
[null,"jobnum","**","Numeric","Header",null,"Job No"]
[null,"lckedt",null,"Numeric","Header","0=No; 1=Yes","Lock Edit"]
[null,"shpnte",null,"Text","Header",null,"Work Order Note"]
[null,"ntetxt",null,"Text","Header",null,"General Note"]
[null,"dscavl",null,"Numeric (8,4)","Footer",25,"Discount Available Percent"]
[null,"depost","(2)","Numeric (8,4)","Footer",null,"Deposit Amount"]
[null,"locnum","**","Numeric","Location",null,"Location No"]
[null,"ctcnme","(3)","String (50)","Location",null,"Location Contact"]
[null,"phnnum","(3)","String (14)","Location",null,"Location Phone"]
[null,"addrs1","(3)","String (50)","Location",null,"Location Address 1"]
[null,"addrs2","(3)","String (50)","Location",null,"Location Address 2"]
[null,"ctynme","(3)","String (50)","Location",null,"Location City"]
[null,"state_","(3)","String (2)","Location",null,"Location State"]
[null,"zipcde","(3)","String (10)","Location",null,"Location Zip"]
[null,"srvgeo","**","Numeric","Location",null,"Service Area"]
[null,"crsstr","(3)","String (50)","Location",null,"Cross Street"]
[null,"maploc","(3)","String (10)","Location",null,"Map Location"]
[null,"rutnum","(4) **","Numeric","Location",null,"Service Route"]
[null,"usrdf1",null,"String (50)","Location",null,"User Def 1"]
[null,"usrdf2",null,"String (50)","Location",null,"User Def 2"]
[null,"clldte",null,"Date","Dispatch","yyyy-mm-dd","Call Date"]
[null,"clltim",null,"Time","Dispatch","hh:mm:ss","Call Time"]
[null,"dspdte",null,"Date","Dispatch","yyyy-mm-dd","Dispatch Date"]
[null,"dsptim",null,"Time","Dispatch","hh:mm:ss","Dispatch Time"]
[null,"schtim",null,"Time","Dispatch","hh:mm:ss","Scheduled Time"]
[null,"schhrs",null,"Numeric (5,2)","Dispatch",null,"Estimated Hours"]
[null,"strdte",null,"Date","Dispatch","yyyy-mm-dd","Start Date"]
[null,"strtim",null,"Time","Dispatch","hh:mm:ss","Start Time"]
[null,"findte",null,"Date","Dispatch","yyyy-mm-dd","Complete Date"]
[null,"fintim",null,"Time","Dispatch","hh:mm:ss","Complete Time"]
[null,"acthrs",null,"Numeric (5,2)","Dispatch",null,"Actual Hours"]
[null,"priort","**","Numeric","Dispatch","[1-8]","Priority Level"]
[null,"empnum","**","Numeric","Dispatch",null,"Technician"]
[null,"invdte",null,"Date","Billing","yyyy-mm-dd","Invoice Date"]
[null,"duedte",null,"Date","Billing","yyyy-mm-dd","Due Date"]
[null,"dscdte",null,"Date","Billing","yyyy-mm-dd","Discount Date"]
[null,"refnum",null,"String (20)","Billing",null,"Reference No"]
[null,"invsrc","**","Numeric","Billing",null,"Invoice Source"]
[null,"pchord",null,"String (20)","Billing",null,"Client PO No"]
[null,"exmnum",null,"String (30)","Billing",null,"Resale No"]
[null,"slspsn","**","Numeric","Billing",null,"Salesperson"]
[null,"taxdst","**","Numeric","Billing","0=Default from Client; -1=Default from Client Location","Tax District"]
[null,"pmttyp","**","Numeric","Billing","1-Cash; 2-Check; 3-Credit Card; 4-Bill; 5-Insurance; 6-Other","Payment Type"]
[null,"crdnum","(5)","String (64)","Billing",null,"Ref 1/ Credit Card No"]
[null,"crdnme",null,"String (30)","Billing",null,"Ref 2/Credit Card Name"]
[null,"expdte",null,"Date","Billing","yyyy-mm-dd","Ref Date / Card Exp Date"]
[null,"constd","(6)","Date","Billing","yyyy-mm-dd","Route Contract Start Date"]
[null,"conend","(6)","Date","Billing","yyyy-mm-dd","Route Contract Exp Date"]
[null,"bildte","(6)(7)","Date","Billing","yyyy-mm-dd","Route Next Bill Date"]
[null,"bilcyc","(6)(7) **","Numeric","Billing","1-Weekly; 2-Bi-weekly; 3-Monthly; 4-Bi-monthly; 5-Quarterly; 6-Semi-annually; 7-Annually","Route Billing Cycle"]
[null,"taxmrt",null,"decimal","Invoice Details",null,"Taxable Markup %"]
[null,"txadmk",null,"decimal","Invoice Details",null,"Taxable Markup $"]
[null,"taxovr",null,"decimal","Invoice Details",null,"Taxable Billing Amount"]
[null,"taxlck",null,"Numeric","Invoice Details","0=No;1=Yes","Taxable Locked"]
[null,"ntxmrt",null,"Numeric (10,2)","Invoice Details",null,"Non-Taxable Markup %"]
[null,"ntadmk",null,"Numeric (10,2)","Invoice Details",null,"Non-Taxable Markup $"]
[null,"ntxovr",null,"Numeric (10,2)","Invoice Details",null,"Non-Taxable Billing Amount"]
[null,"ntxlck",null,"Numeric","Invoice Details","0=No;1=Yes","Non-Taxable Locked"]
[null,"plcnum",null,"String (30)","Insurance",null,"Policy No"]
[null,"plcnme",null,"String (50)","Insurance",null,"Policy Holder"]
[null,"plcad1",null,"String (50)","Insurance",null,"Policy Address 1"]
[null,"plcad2",null,"String (50)","Insurance",null,"Policy Address 2"]
[null,"plccty",null,"String (60)","Insurance",null,"Policy City,State, Zip"]
[null,"plcphn",null,"String (30)","Insurance",null,"Policy Phone"]
[null,"plctyp",null,"String (50)","Insurance",null,"Policy Type"]
[null,"dedabl",null,"Numeric (10,2)","Insurance",null,"Policy Deductible Amt"]
[null,"cmpnme",null,"String (50)","Insurance",null,"Policy Company Name"]
[null,"adjnme",null,"String (50)","Insurance",null,"Policy Adjuster Name"]
[null,"adjad1",null,"String (50)","Insurance",null,"Policy Adjuster Address 1"]
[null,"adjad2",null,"String (50)","Insurance",null,"Policy Adjuster Address 2"]
[null,"adjcty",null,"String (60)","Insurance",null,"Policy Adjuster City, State, Zip"]
[null,"adjphn",null,"String (14)","Insurance",null,"Policy Adjuster Phone"]
[]
[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) Updating to 'Void' status is only allowed when an order already exists in Sage and has a status of 6, 7 or 10"]
[null,"(2) Deposit Amount - creates a credit invoice"]
[null,"(3) If null or left out of header mapping the field will be derived from the [locnum] and if the [locnum] is blank then it will be derived from the [clientno]"]
[null,"(4) Service Route is only available when the Order Status is [9-Route]"]
[null,"(5) Field Encryption - this field is encrypted by default, in order to import a value into this field, Encryption must be turned OFF"]
[null,"a) Go To 7-1 Company Information"]
[null,"b) Click Options, then Database Security Encryption"]
[null,"c) Select \"OFF\""]
[null,"(6) Field is required when the Order Status [9-Route]"]
[null,"(7) Field is required when the Order Status is [10-Contract]"]
[]
[]
[null,"Invoice Details"]
[null,"filetype","Required",null,null,"SRWO","(File Type Code)"]
[null,"linetype","Required",null,null,"D","(Detail Record)"]
[null,"clnnum","Required [*] **","Numeric","Header",null,"Client No"]
[null,"ordnum","Required [*]","String (20)","Header",12345,"Order No"]
[null,"linnum","[*] (1)","Numeric","Invoice Details",1,"Line No"]
[null,"asmnum","** (2)","Numeric","Invoice Details",null,"Assembly No"]
[null,"asmchk","** (3)","String (1)","Invoice Details","L=Assembly; R=Assembly Labor; P=Part; A=Assembly; or Blank","Assembly Checkmark"]
[null,"prtnum","** (2)","Numeric","Invoice Details",null,"Part No"]
[null,"dscrpt","Required (4)","String (75)","Invoice Details",null,"Item Description"]
[null,"untdsc","(4)","String (10)","Invoice Details",null,"Unit of Measure"]
[null,"prtqty",null,"Numeric (8,4)","Invoice Details",null,"Quantity"]
[null,"prtprc","(4)","Numeric (9,6)","Invoice Details",null,"Price"]
[null,"tktnum",null,"String (20)","Invoice Details",null,"Ticket No"]
[null,"curbll",null,"Numeric (10,2)","Invoice Details",null,"Current Billed Amount"]
[null,"csttyp","(4) **","Numeric","Invoice Details","1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Udf-6; 7-Udf-7; 8-Udf-8; 9-Udf-9","Cost Type"]
[null,"slstax","**","String (1)","Invoice Details","Y-Yes; N-No (Default = 'No')","Taxable"]
[null,"actnum","**","Numeric","Invoice Details",null,"Account"]
[null,"subact","**","Numeric","Invoice Details",null,"Subaccount"]
[null,"invloc","**","Numeric","Invoice Details","0 = Default Part Location","Inventory Location"]
[null,"sernum",null,"String (30)","Invoice Details",null,"Serial Number"]
[null,"sitloc",null,"String (50)","Invoice Details",null,"Site Location"]
[null,"eqpnum","**","Numeric","Invoice Details",null,"Equipment"]
[null,"usrdf1",null,"String (50)","Invoice Details",null,"User Defined"]
[null,"shpnte",null,"Text","Invoice Details",null,"Shop Notes"]
[null,"ntetxt",null,"Text","Invoice Details",null,"Owner 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) Null/Empty = line no will be automatically derived; Specified line no must be unique based on the Key pair"]
[null,"(2) Assembly No must be blank if Part No is provided; Part No must be blank if Assembly No is provided"]
[null,"(3) Only P or A are allowed if an Assembly No is provided"]
[null,"(4) Null/Empty = If null or excluded from mapping and a Part No is entered, the field value will default from the Part No record"]
[]
[]
[null,"Dispatch Schedule"]
[null,"filetype","Required",null,null,"SRWO","(File Type Code)"]
[null,"linetype","Required",null,null,"DS","(Detail Record)"]
[null,"clnnum","Required [*]","String (20)","Header",12345,"Client No"]
[null,"ordnum","Required [*]","String (20)","Header",12345,"Order No"]
[null,"linnum","[*] (1)","Numeric","Dispatch",1,"Line No"]
[null,"empnum","Required [*] (2) **","Numeric","Dispatch",null,"Employee No"]
[null,"eqpnum","Required (2) **","Numeric","Dispatch",null,"Equipment No"]
[null,"vndnum","Required (2) **","Numeric","Dispatch",null,"Vendor No"]
[null,"priort","Required **","Numeric","Dispatch","[1-8]","Priority"]
[null,"schdte",null,"Date","Dispatch","yyyy-mm-dd","Scheduled Date"]
[null,"schstr",null,"Time","Dispatch","hh:mm:ss","Scheduled Start"]
[null,"schfin",null,"Time","Dispatch","hh:mm:ss","Scheduled Finish"]
[null,"esthrs",null,"decimal (5,2)","Dispatch",null,"Scheduled Hours"]
[null,"tvltim",null,"String (4)","Dispatch",null,"Travel Time"]
[null,"actstr",null,"Time","Dispatch","hh:mm:ss","Actual Start Time"]
[null,"findte",null,"Date","Dispatch","yyyy-mm-dd","Actual Finish Date"]
[null,"actfin",null,"Time","Dispatch","hh:mm:ss","Actual Finish Time"]
[null,"acthrs",null,"decimal (5,2)","Dispatch",null,"Actual Hours"]
[null,"bildte",null,"Date","Dispatch","yyyy-mm-dd","Billed Date"]
[null,"usrdf1",null,"String (50)","Dispatch",null,"User Defined"]
[]
[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) Blank = line no will be automatically derived; If specified line no must be unique based on the Key pair"]
[null,"(2) Either an employee, equipment or vendor number must be specified"]
[]
[]
[]
[null,"File Example:"]
[null,"!SRWO,H,clnnum,ordnum,invnum,orddte,dscrpt,status,invtyp,schdte,jobnum,lckedt,shpnte,ntetxt,dscavl,depost,locnum,ctcnme,phnnum,addrs1,addrs2,ctynme,state_,zipcde,srvgeo,crsstr,maploc,rutnum,usrdf1,usrdf2,clldte,clltim,dspdte,dsptim,schtim,schhrs,strdte,strtim,findte,fintim,acthrs,priort,empnum,invdte,duedte,dscdte,refnum,invsrc,pchord,exmnum,slspsn,taxdst,pmttyp,crdnum,crdnme,expdte,constd,conend,bildte,bilcyc,taxmrt,txadmk,taxovr,taxlck,ntxmrt,ntadmk,ntxovr,ntxlck,plcnum,plcnme,plcad1,plcad2,plccty,plcphn,plctyp,dedabl,cmpnme,adjnme,adjad1,adjad2,adjcty,adjphn"]
[null,"!SRWO,D,clnnum,ordnum,linnum,asmnum,asmchk,prtnum,dscrpt,untdsc,prtqty,prtprc,tktnum,curbll,csttyp,slstax,actnum,subact,invloc,sernum,sitloc,eqpnum,usrdf1,shpnte,ntetxt"]
[null,"!SRWO,DS,clnnum,ordnum,linnum,empnum,eqpnum,vndnum,priort,schdte,schstr,schfin,esthrs,tvltim,actstr,findte,actfin,acthrs,bildte,usrdf1"]
[null,"SRWO,H,123,\"InvABC\",\"2\",\"5/20/2017\",\"Test Order\",7,1,\"5/20/2017\",,,\"\",\"\",,,,\"Jim Ray\",\"777-888-9595\",\"GE Corp Services\",\"45 Willow Park Ln\",\"Torrence\",\"CA\",\"92254\",,\"\",\"\",,\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"\",\"\",\"\",,,,\"\",\"\",\"\",\"\",,\"\",\"\",,,,\"\",\"\",\"\",\"\",\"\",\"\",,,,125,1,100,50,,,\"\",\"\",\"\",\"\",\"\",\"\",\"\",,\"\",\"\",\"\",\"\",\"\",\"\""]
[null,"SRWO,D,123,\"InvABC\",1,,\"\",,\"test line 1\",\"ea\",1,250.00,\"\",,,\"N\",4010,,,\"\",\"\",,\"\",\"\",\"notes line 1\""]
[null,"SRWO,D,123,\"InvABC\",2,,\"\",,\"test line 2\",\"ea\",3,50.00,\"\",,,\"N\",4010,,,\"\",\"\",,\"\",\"\",\"notes line 2\""]

{"sheet":"Grid Sample","index":1,"n_rows":14,"n_cols":83,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Sample Template"]
[]
[]
[]
[null,"SRWO","H","clnnum","ordnum","invnum","orddte","dscrpt","status","invtyp","schdte","jobnum","lckedt","shpnte","ntetxt","dscavl","depost","locnum","ctcnme","phnnum","addrs1","addrs2","ctynme","state_","zipcde","srvgeo","crsstr","maploc","rutnum","usrdf1","usrdf2","clldte","clltim","dspdte","dsptim","schtim","schhrs","strdte","strtim","findte","fintim","acthrs","priort","empnum","invdte","duedte","dscdte","refnum","invsrc","pchord","exmnum","slspsn","taxdst","pmttyp","crdnum","crdnme","expdte","constd","conend","bildte","bilcyc","taxmrt","txadmk","taxovr","taxlck","ntxmrt","ntadmk","ntxovr","ntxlck","plcnum","plcnme","plcad1","plcad2","plccty","plcphn","plctyp","dedabl","cmpnme","adjnme","adjad1","adjad2","adjcty","adjphn"]
[null,null,null,"String (20)","String (20)","Numeric","Date","String (75)","Numeric","Numeric","Date","Numeric","Numeric","Text","Text","Numeric (8,4)","Numeric (8,4)","Numeric","String (50)","String (14)","String (50)","String (50)","String (50)","String (2)","String (10)","Numeric","String (50)","String (10)","Numeric","String (50)","String (50)","Date","Time","Date","Time","Time","Numeric (5,2)","Date","Time","Date","Time","Numeric (5,2)","Numeric","Numeric","Date","Date","Date","String (20)","Numeric","String (20)","String (30)","Numeric","Numeric","Numeric","String (64)","String (30)","Date","Date","Date","Date","Numeric","decimal","decimal","decimal","Numeric","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric","String (30)","String (50)","String (50)","String (50)","String (60)","String (30)","String (50)","Numeric (10,2)","String (50)","String (50)","String (50)","String (50)","String (60)","String (14)"]
[null,"SRWO","D","clnnum","ordnum","linnum","asmnum","asmchk","prtnum","dscrpt","untdsc","prtqty","prtprc","tktnum","curbll","csttyp","slstax","actnum","subact","invloc","eqpnum","usrdf1","shpnte","ntetxt"]
[null,null,null,"String (20)","String (20)","Numeric","Numeric","String (1)","Numeric","String (75)","String (10)","Numeric (8,4)","Numeric (9,6)","String (20)","Numeric (10,2)","Numeric","String (1)","Numeric","Numeric","Numeric","Numeric","String (50)","Text","Text"]
[null,"SRWO","DS","clnnum","ordnum","linnum","empnum","eqpnum","vndnum","priort","schdte","schstr","schfin","esthrs","tvltim","actstr","findte","actfin","acthrs","bildte","usrdf1"]
[null,null,null,"String (20)","String (20)","Numeric","Numeric","Numeric","Numeric","Numeric","Date","Time","Time","decimal (5,2)","String (4)","Time","Date","Time","decimal (5,2)","Date","String (50)"]
[]
[null,"SRWO","H",123,"InvABC",2,"2017-05-20","Test Order",7,1,"2017-05-20",null,null,null,null,null,null,null,"Jim Ray","777-888-9595","GE Corp Services","45 Willow Park Ln","Torrence","CA",92254,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,null,null,null,null,null,null,null,null,null,null,125,1,100,50]
[null,"SRWO","D",123,"InvABC",null,null,null,null,"test line 1","ea",1,250,null,null,null,"N",4010]
[null,"SRWO","D",123,"InvABC",null,null,null,null,"test line 2","ea",1,40,null,null,null,"Y",4010]

{"sheet":"Flat Template","index":2,"n_rows":12,"n_cols":118,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,1,4,80],[4,81,4,101],[4,102,4,117]]}
["Sample 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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dispatch Schedule"]
[null,"Client No","Order No","Invoice No","Order Date","Order Description","Order Status","Order Type","Scheduled Date","Job No","Lock Edit","Work Order Note","General Note","Discount Available Percent","Deposit Amount","Location No","Location Contact","Location Phone","Location Address 1","Location Address 2","Location City","Location State","Location Zip","Service Area","Cross Street","Map Location","Service Route","User Def 1","User Def 2","Call Date","Call Time","Dispatch Date","Dispatch Time","Scheduled Time","Estimated Hours","Start Date","Start Time","Complete Date","Complete Time","Actual Hours","Priority Level","Technician","Invoice Date","Due Date","Discount Date","Reference No","Invoice Source","Client PO No","Resale No","Salesperson","Tax District","Payment Type","Ref 1/ Credit Card No","Ref 2/Credit Card Name","Ref Date / Card Exp Date","Route Contract Start Date","Route Contract Exp Date","Route Next Bill Date","Route Billing Cycle","Taxable Markup %","Taxable Markup $","Taxable Billing Amount","Taxable Locked","Non-Taxable Markup %","Non-Taxable Markup $","Non-Taxable Billing Amount","Non-Taxable Locked","Policy No","Policy Holder","Policy Address 1","Policy Address 2","Policy City,State, Zip","Policy Phone","Policy Type","Policy Deductible Amt","Policy Company Name","Policy Adjuster Name","Policy Adjuster Address 1","Policy Adjuster Address 2","Policy Adjuster City, State, Zip","Policy Adjuster Phone","Line No","Assembly No","Check Arrow Direction","Part No","Item Description","Unit of Measure","Quantity","Price","Ticket No","Current Billed Amount","Cost Type","Taxable","Account","Subaccount","Inventory Location","Serial Number","Site Location","Equipment","User Defined","Shop Notes","Owner Notes","Line No","Employee No","Equipment No","Vendor No","Priority","Scheduled Date","Scheduled Start","Scheduled Finish","Scheduled Hours","Travel Time","Actual Start Time","Actual Finish Date","Actual Finish Time","Actual Hours","Billed Date","User Defined"]
[null,"Numeric","String (20)","String (20)","Date","String (75)","Numeric","Numeric","Date","Numeric","Numeric","Text","Text","Numeric (8,4)","Numeric (8,4)","Numeric","String (50)","String (14)","String (50)","String (50)","String (50)","String (2)","String (10)","Numeric","String (50)","String (10)","Numeric","String (50)","String (50)","Date","Time","Date","Time","Time","Numeric (5,2)","Date","Time","Date","Time","Numeric (5,2)","Numeric","Numeric","Date","Date","Date","String (20)","Numeric","String (20)","String (30)","Numeric","Numeric","Numeric","String (64)","String (30)","Date","Date","Date","Date","Numeric","decimal","decimal","decimal","Numeric","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric","String (30)","String (50)","String (50)","String (50)","String (60)","String (30)","String (50)","Numeric (10,2)","String (50)","String (50)","String (50)","String (50)","String (60)","String (14)","Numeric","Numeric","String (1)","Numeric","String (75)","String (10)","Numeric (8,4)","Numeric (9,6)","String (20)","Numeric (10,2)","Numeric","String (1)","Numeric","Numeric","Numeric","String (30)","String (50)","Numeric","String (50)","Text","Text","Numeric","Numeric","Numeric","Numeric","Numeric","Date","Time","Time","decimal (5,2)","String (4)","Time","Date","Time","decimal (5,2)","Date","String (50)"]
[null,"Header","Header","Header","Header","Header","Header","Header","Dispatch","Header","Header","Header","Header","Footer","Footer","Location","Location","Location","Location","Location","Location","Location","Location","Location","Location","Location","Location","Location","Location","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Billing","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Insurance","Insurance","Insurance","Insurance","Insurance","Insurance","Insurance","Insurance","Insurance","Insurance","Insurance","Insurance","Insurance","Insurance","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Invoice Details","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch","Dispatch"]
[]
[null,"clnnum","ordnum","invnum","orddte","dscrpt","status","invtyp","schdte","jobnum","lckedt","shpnte","ntetxt","dscavl","depost","locnum","ctcnme","phnnum","addrs1","addrs2","ctynme","state_","zipcde","srvgeo","crsstr","maploc","rutnum","usrdf1","usrdf2","clldte","clltim","dspdte","dsptim","schtim","schhrs","strdte","strtim","findte","fintim","acthrs","priort","empnum","invdte","duedte","dscdte","refnum","invsrc","pchord","exmnum","slspsn","taxdst","pmttyp","crdnum","crdnme","expdte","constd","conend","bildte","bilcyc","taxmrt","txadmk","taxovr","taxlck","ntxmrt","ntadmk","ntxovr","ntxlck","plcnum","plcnme","plcad1","plcad2","plccty","plcphn","plctyp","dedabl","cmpnme","adjnme","adjad1","adjad2","adjcty","adjphn","linnum","asmnum","asmchk","prtnum","dscrpt","untdsc","prtqty","prtprc","tktnum","curbll","csttyp","slstax","actnum","subact","invloc","sernum","sitloc","eqpnum","usrdf1","shpnte","ntetxt","linnum","empnum","eqpnum","vndnum","priort","schdte","schstr","schfin","esthrs","tvltim","actstr","findte","actfin","acthrs","bildte","usrdf1"]
["First Line of File ==>",123,"InvABC",2,"2017-05-20","Test Order",7,1,"2017-05-20",null,null,null,null,null,null,null,"Jim Ray","777-888-9595","GE Corp Services","45 Willow Park Ln","Torrence","CA",92254,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,null,null,null,null,null,null,null,null,null,null,125,1,100,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test line 1","ea",1,250,null,null,null,"N",4010]
[null,123,"InvABC",2,"2017-05-20","Test Order",7,1,"2017-05-20",null,null,null,null,null,null,null,"Jim Ray","777-888-9595","GE Corp Services","45 Willow Park Ln","Torrence","CA",92254,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,null,null,null,null,null,null,null,null,null,null,125,1,100,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test line 2","ea",1,40,null,null,null,"Y",4010]