{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Type","Layout"],"read":"whole","date_system":"1900"}

{"sheet":"Type","index":0,"n_rows":17,"n_cols":11,"rows_kept":17}
["System IDs for batch Interface"]
[]
["System ","Doc Seq ","COAS ","One Time","ACH ","MA Addr ","1099 Rept","Income","Grouping","Pymt","Batch used as "]
["ID","Number","Code","Vendor ","Override","Allowed",null,"Type","Ind","Category","follows"]
["APPAYROL","FM","U","N","N","Y","N","N/A",1,"K8","Payroll Tax Shelters & Garnishments"]
["APAYROL1","FM","U","N","Y","Y","N","N/A",1,"K8","Payroll Tax Shelters & Garnishments"]
["APVNDPMT","FI","U","N","Y","Y","Y","NC",1,"KK","Vendor Payment - No ACH"]
["APVDPTNO","FI","U","N","N","Y","Y","NC",1,"KK","Vendor Payment - ACH Available"]
["APCKPKUP","FI","U","N","Y","Y","N","N/A",1,"K1","RHF/Athletic/Band Trips"]
["APDDPYMT","FI","U","N","N","Y","N","N/A",1,"K1","RHF/Athletic/Band Trips"]
["APREFUND","FM","U","N","N","Y","N","N/A",1,"K2","Refunds "]
["APRENTPY","FM","U","N","N","Y","Y","RE","M","K7","Rent Pymt"]
["APCHKHON","FI","U","N","Y","Y","Y","NC",1,"H4","Honoraria"]
["APACHHON","FM","U","N","N","Y","Y","NC",1,"H4","Honoraria"]
["APHPVPMT","FM","U","N","N","Y","Y",99,1,"K2","Hokiepassport"]
["APVDPTOT","FI","U","N","Y","Y","Y","OT",1,"KK","Human Subject Payments, Awards, Prizes - No ACH"]
["APVPOTNO","FI","U","N","N","Y","Y","OT",1,"KK","Human Subject Payments, Awards, Prizes - ACH Available"]

{"sheet":"Layout","index":1,"n_rows":2,"n_cols":30,"rows_kept":2}
[{"$f":"IF(MAX(LEN(A3:A936))>8,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(B3:B936))>9,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(C3:C936))>25,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(D3:D936))>15,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(E3:E936))>12,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(F3:F936))>8,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(G3:G936))>8,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(H3:H936))>6,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(I3:I936))>6,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(J3:J936))>8,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(K3:K936))>2,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(L3:L936))>2,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(M3:M936))>30,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(N3:N936))>30,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(O3:O936))>30,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(P3:P936))>20,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(Q3:Q936))>3,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(R3:R936))>10,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(S3:S936))>3,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(T3:T936))>8,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(U3:U936))>15,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(V3:V936))>15,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(W3:W936))>50,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(X3:X936))>8,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(Y3:Y936))>8,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(Z3:Z936))>6,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(AA3:AA936))>6,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(AB3:AB936))>6,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(AC3:AC936))>6,\"Too Many\",\" \")","v":" "},{"$f":"IF(MAX(LEN(AD3:AD936))>6,\"Too Many\",\" \")","v":" "}]
["System Id(8)","Banner ID(9)","Last Name(25)","First Name(15)","Trans Amt(12)","Trans Date","Pymt Due","Index(6)","Acct(6)","Invoice Date","Atyp(2)","Seq(2)","Street Line1(30)","Street Line2(30)","Street Line3(30)","City(20)","State Code(3)","Zip(10)","Nation(3)","Invoice Rcvd Date","Vendor Invoice(15)","Cust Acct Num(15)","Commodity Desc(50)","Services Begin Date","Goods Rcvd Date","Fund(6)","Orgn(6)","Prog(6)","Actv(6)","Locn(6)"]