{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Warrant Data Entry","ACH Data Entry","Voucher Approval","Vendors","Configuration","KC Use Only"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":64,"comments":3,"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":"Warrant Data Entry","index":0,"n_rows":9,"n_cols":44,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Scheduled Payment Date:",null,null,null,null,"Email Address:",{"$f":"EMAIL_ADDRESS","v":"a@kingcounty.gov"},null,null,null,"File Name:"]
["Fund:",null,null,null,null,"District Name:",{"$f":"ORGANIZATION_NAME","v":0},null,null,null,"Import Folder:",{"$f":"SOURCE_FOLDER","v":"C:\\temp-files"}]
["Payment Method:",null,null,null,"WARRANT","Source Name:",{"$f":"SOURCE_NAME","v":0},null,null,null,"Export Folder:",{"$f":"TARGET_FOLDER","v":0}]
["Total Amount:",null,null,null,{"$f":"SUM(G10:G65536)","v":0},"Use Vendor Tab:",{"$f":"WARRANT_VENDOR_LOOKUP_FLAG","v":"No"}]
["Control Total:",null,null,null,{"$f":"COUNTA(A10:A65536)","v":0}]
[]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44]
["PAYEE (VENDOR NAME)","VENDOR NUMBER","VENDOR SITE CODE","INVOICE TYPE LOOKUP CODE","INVOICE (VOUCHER) NUMBER","INVOICE (VOUCHER) DATE","INVOICE (VOUCHER) AMOUNT","PAY GROUP","EXCLUSIVE PAYMENT FLAG","ADDRESS LINE1","ADDRESS LINE2","ADDRESS LINE3","ADDRESS LINE4","CITY","STATE","ZIP (POSTAL) CODE","COUNTY","PROVINCE","COUNTRY","DESCRIPTION","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","SOURCE","PAYMENT METHOD LOOKUP CODE","LINE NUMBER","LINE TYPE LOOKUP CODE","AMOUNT","PROJECT NUMBER","TASK NUMBER","EXPENDITURE TYPE","EXPENDITURE ITEM DATE","EXPENDITURE ORGANIZATION NAME","AWARD NUMBER","TYPE 1099","SHIP TO LOCATION CODE","WORK ORDER SIDE SYSTEM NAME","FUND","PROJECT","COST CENTER","ACCOUNT","BARS","FUTURE","SCHEDULED PAYMENT DATE"]

{"sheet":"ACH Data Entry","index":1,"n_rows":9,"n_cols":45,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Scheduled Payment Date:",null,"Email Address:",null,{"$f":"EMAIL_ADDRESS","v":"a@kingcounty.gov"},null,"File Name:"]
["Fund:",null,"District Name:",null,{"$f":"ORGANIZATION_NAME","v":0},null,"Import Folder:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SOURCE_FOLDER","v":"C:\\temp-files"}]
["Payment Method:","ACH","Source Name:",null,{"$f":"SOURCE_NAME","v":0},null,"Export Folder:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TARGET_FOLDER","v":0}]
["Total Amount:",{"$f":"SUM(G10:G65536)","v":0},"Use Vendor Tab:",null,{"$f":"ACH_VENDOR_LOOKUP_FLAG","v":0}]
["Control Total:",{"$f":"COUNTA(A10:A64988)","v":0}]
[]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45]
["PAYEE (VENDOR NAME)","VENDOR NUMBER","VENDOR SITE CODE","INVOICE TYPE LOOKUP CODE","INVOICE (VOUCHER) NUMBER","INVOICE (VOUCHER) DATE","INVOICE (VOUCHER) AMOUNT","PAY GROUP","EXCLUSIVE PAYMENT FLAG","ADDRESS LINE1","ADDRESS LINE2","ADDRESS LINE3","ADDRESS LINE4","CITY","STATE","ZIP","COUNTY","PROVINCE","COUNTRY","DESCRIPTION","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","SOURCE","PAYMENT METHOD LOOKUP CODE","LINE NUMBER","LINE TYPE LOOKUP CODE","AMOUNT","PROJECT NUMBER","TASK NUMBER","EXPENDITURE TYPE","EXPENDITURE ITEM DATE","EXPENDITURE ORGANIZATION NAME","AWARD NUMBER","TYPE 1099","SHIP TO LOCATION CODE","WORK ORDER SIDE SYSTEM NAME","FUND","PROJECT","COST CENTER","ACCOUNT","BARS","FUTURE","SCHEDULED PAYMENT DATE","KC CONVERTED PAYEE (Vendor Name)"]

{"sheet":"Voucher Approval","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[15,0,15,6],[30,1,30,3]]}
[]
[null,"Scheduled Payment Date:",null,null,"District Name:",{"$f":"ORGANIZATION_NAME","v":0}]
[null,"Total Amount:",null,null,"File Name:"]
[null,"Control Total:",null,null,"Fund #:"]
[null,"Payment Method:"]
[]
["CONTACT INFORMATION"]
[]
["Preparer's Name: _________________________________________________________",null,null,null,"Email Address:",{"$f":"EMAIL_ADDRESS","v":"a@kingcounty.gov"}]
[]
[]
[]
[]
["PAYMENT CERTIFICATION",null,null,null,null,null,"RCW  (42.24.080)"]
[]
["I, the undersigned, do hereby certify under penalty of perjury, that the materials have been furnished, the services rendered, the labor performed as described, or that any advance payment is due and payable pursuant to a contract or is available as an option for full or partial fulfillment of a contractual obligation, and that the claim(s) is(are) just, due and unpaid obligation against the above-named governmental unit, that I am authorized to authenticate and certify to said claim(s)."]
[]
["Authorized District Signature(s) for Payment of Claims (Auditing Officer(s) or Board Member(s)):"]
[]
["_______________________________________________________     ______________________",null,null,null,"_______________________________________________________     _____________________"]
["                             Authorized District Signature",null,"Date",null,null,"   Authorized District Signature-------------------------------------------Date"]
[]
["_______________________________________________________     ______________________",null,null,null,"_______________________________________________________     _____________________"]
["                             Authorized District Signature",null,"Date",null,null,"   Authorized District Signature-------------------------------------------Date"]
[]
["_______________________________________________________     ______________________",null,null,null,"_______________________________________________________     _____________________"]
["                             Authorized District Signature",null,"Date",null,null,"   Authorized District Signature-------------------------------------------Date"]
[]
[]
[" SUBMIT SIGNED DOCUMENT TO:",null,null,null,null,null," KING COUNTY FINANCE USE ONLY:"]
["King County Accounts Payable\nAttn:  Special Districts\n401 5th Avenue, Room 323\nSeattle, WA  98104\n","Email: SpecialDist.AP@kingcounty.gov\nFax: (206) 263-3767",null,null,null,null," \nBatch Processed By:                   ___________________\n \nDate Processed:                          ___________________\n "]
[]
[]
[]
["District Name:",{"$f":"ORGANIZATION_NAME","v":0},null,null,"File Name:",{"$f":"VOUCHER_FILENAME","v":0}]
[]
["Payee (Vendor Name)","Vendor No.","Vendor Site","Invoice No.","Invoice Date","Inv. Amount","Description"]

{"sheet":"Vendors","index":3,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["PAYEE (VENDOR NAME)","KC Converted Payee (Vendor Name)","VENDOR NUMBER","VENDOR SITE CODE","ADDRESS LINE1","ADDRESS LINE2","ADDRESS LINE3","ADDRESS LINE4","CITY","STATE","ZIP","COUNTY","PROVINCE","COUNTRY"]

{"sheet":"Configuration","index":4,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Static Field Configuration (One Time Setup)"]
[]
[null,"Legend:"]
[null,"Dark Grey","Label Information. Locked Field."]
[null,"Light Grey","User Input Field. Unlocked field."]
[null,"* Required & Optional","Designations denote the information is either Required or Optional on this worksheet only."]
[]
[]
[null,"Organization Name:",null,"Required"]
[null,"Source (Short) Name:",null,"Required"]
[null,"Email Address:","a@kingcounty.gov","Required"]
[null,"Import Folder:","C:\\temp-files","Optional"]
[null,"Export Folder:",null,"Required"]
[null,"Backup Folder:",null,"Required"]
[null,"Country:","US","Optional"]
[null,null,"Note: This option is only applicable for transaction lines where the Country field is left blank."]
[null,"Exclusive Payment Flag Default:","Yes","Required"]
[]
[null,"Print Vendor Address on Warrants?","Yes","Required"]
[null,"Address Line1:","<BLANK>"]
[null,"City:","<BLANK>"]
[null,"State:","<BLANK>"]
[null,"Zip:","<BLANK>"]
[null,null,"Note: If the \"No\" option is selected, the above values will be populated into address fields.  A single period will be printed on warrants in place of <BLANK>, and addresses from the Vendors tab will not be used.  This option is only applicable for transaction lines where ALL address fields are left blank.  The Country abbreviation will be printed."]
[]
[null,"Use Vendor Tab for Warrant Data Entry?","No","Required"]
[null,"Use Vendor Tab for ACH Data Entry?",null,"Required"]
[null,null,"Note: Select \"Yes\" to use the Vendors tab to look up values based on the Vendor Name when doing data entry.  Select \"No\" to NOT use the Vendors tab.  If \"No\" is selected, you are required to provide all the vendor data at the time of data entry for the Warrant Data Entry tab.  If you select \"No\", the Vendor Tab will be hidden."]
[]
[null,"Data Entry - CSV Import File Structure: \n(Columns to Import)","Note: The column numbers and order listed below reference column numbers shown in Row 8 of the Warrant Data Entry tab. Additional data beyond the fields shown below will not be imported. Please do not include header rows when creating CSV files for importing into the Data Entry tab."]
[null,"Warrant Data Entry (Use Vendor Tab = No)","VendorName,InvoiceNumber,InvoiceDate,InvoiceAmount, AddressLine1, AddressLine2, AddressLine3, AddressLine4, City, State, Zip, Province, Country, Description \n(Columns 1,5,6,7,10,11,12,13,14,15,16,18,19,20)","Optional"]
[null,"Warrant Data Entry (Use Vendor Tab = Yes)","VendorName,InvoiceNumber,InvoiceDate,InvoiceAmount,Description \n(Columns 1,5,6,7,20)","Optional"]
[null,"ACH Data Entry (Use Vendor Tab = No)","VendorName,VendorNumber,VendorSiteCode, InvoiceNumber, InvoiceDate,InvoiceAmount, Description, KCConvertedVendorName \n(Columns 1,2,3,5,6,7,20,45)","Optional"]
[null,"ACH Data Entry (Use Vendor Tab = Yes)","VendorName,InvoiceNumber,InvoiceDate,InvoiceAmount,Description \n(Columns 1,5,6,7,20)","Optional"]

{"sheet":"KC Use Only","index":5,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Static Fields"]
[null,null,null,4,26,27,36,39,40,41,42,43]
["AP SS Version","TRANSACTION TYPE","Department/District","INVOICE TYPE LOOKUP CODE","LINE NUMBER","LINE TYPE LOOKUP CODE","SHIP TO LOCATION CODE","PROJECT","COST CENTER","ACCOUNT","BARS","FUTURE"]
["KC v2.0","APSUPINV","DES","STANDARD",1,"ITEM","NTX-KC-0001","0000000","000000",24217,"0000000","00000"]
[]
["Lists"]
[]
["YES/ NO"]
["Yes"]
["No"]