{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Entry Form","APIO_FILE","Tools","Fund List","Substitution Rules"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Entry Form","index":0,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[[10,4,10,7],[9,5,9,6],[14,4,14,8],[26,4,26,8],[0,2,0,4],[0,5,0,7],[3,5,3,7],[4,5,4,7],[13,4,13,8],[11,4,11,8],[68,4,68,7],[46,4,46,7],[12,4,12,7],[64,4,64,7],[52,4,52,7],[51,4,51,8],[56,4,56,8],[65,4,65,8],[63,4,63,8],[44,4,44,8],[47,4,47,8],[0,9,1,10],[3,9,6,10],[8,9,9,10],[5,5,5,7],[6,5,6,7]]}
["Fund",501,"County Clerk-Special",null,null,"Running Totals:  APIO_FILE (New) ",null,null,null,"Pay Alone"]
["Obligation Date (Default)",null,null,null,null,"Invoice Count","Line Count","Total Amount"]
["Payee",null,null,40000,null,0,0,0]
["Address Line 1",null,null,null,null,"Biztalk Folder or Network folder where file will be saved",null,null,null,"Put Yes into this field ONLY if you need to Force individual checks to the same Payee. The DISTRICT CLERK has this requirement."]
["Address Line 2",null,null,null,null,"K:\\1 COUNTY CLERK APIO\\Fund 501\\APIO_Files"]
["Address Line 3",null,null,null,null,"Filename"]
["City ",null,null,null,null,"501SpecFund.csv"]
["State Zipcode"]
["Invoice Number (On Check)",null,null,null,null,null,null,null,null,"If you want to reduce the address lines you have to tab through  you can change your protected  prefereces on the Fund List tab."]
["Invoice Description (Does not display on check can be searched)",null,null,null,null,"FUSION TEMPLATE",null,"Last SpecFund_Entry Enhancement: 04/20/2023"]
[{"$f":"SUM(A13:A1217)","v":0}]
["Amount ","Invoice Line Description (Displays on check Stub)","Obligation Date",null,"QUICK NOTES"]
[null,null,null,null,"Settings: New Entry Form, testing or want to change protected fields)) R=Row C=Column"]
[null,null,null,null,"* Select Your Fund:  Click in the Cell (R1 CB)  and look for the drop down icon that will appear on the right of cell to"]
[null,null,null,null,"     select your fund.   This function also sets your protected fields see Fund List for more instructions."]
[null,null,null,null,"* Click Change Biztalk  Folder or Filename or Pay Alone button to allow editing of these fields.  "]
[null,null,null,null,"   Double click to the right of existng text in the cell you want to change.  It is often easier to edit in the text box above "]
[null,null,null,null,"   the grid where the cell contents are displayed."]
[null,null,null,null,"    - You can personlize the Filename by adding your initials.  Please keep your fund number and avoid using spaces "]
[null,null,null,null,"       or special characters."]
[null,null,null,null,"    - You can change the BizTalk folder to another location to review the file before movng to the BizTalk folder"]
[null,null,null,null,"    - Set Pay Alone to \"Yes\"   "]
[null,null,null,null,"   When done click the 6. Send APIO_File... button but Do Not send the file when prompted this will reset protections"]
[]
[null,null,null,null,"FYI: BizTalk moves the file to Oracle and creates a copy with the date and time  in the Archive folder within this folder."]
[]
[null,null,null,null,"HOW TO USE Entry Form  (Don'y forget to scroll back up when done.) "]
[null,null,null,null,"CLICK Start New File button - Clears prior work.  Must click between sends."]
[null,null,null,null,"1. ENTER YOUR DATA - Check Level Information in this section will be repeated for each detail line."]
[null,null,null,null,"Fund:   Pick from List and save.  It will remember as you reuse the template.  "]
[null,null,null,null,"Obligation Dates:  If paying entities outside Dallas County you must identify when the funds were obligated"]
[null,null,null,null,"  to be return or distributed.   i.e. Restitution:  Date receipted,   Cash Bond: Presenting of Receipt for refund and"]
[null,null,null,null,"  for payments to other Dallas County department use the current date.   "]
[null,null,null,null,"  TIP: On line 2 enter the most common date for your batch and on rows > 12"]
[null,null,null,null,"          Enter the Obligation Date only for the amounts where the Obligation date falls in a prior month."]
[null,null,null,null,"Address:  CPU= Customer Pick Up, C/O + Name will not require additional address entry"]
[null,null,null,null,"Invoice Number:  Blank = Auto Number or enter unique value (i.e. Check Number/Receipt from another System)"]
[null,null,null,null,"  The resulting invoice number will always begin with the Fund."]
[null,null,null,null,"Invoice Description:  Great for internal documentation available on reports.  "]
[null,null,null,null,"2. ENTER YOUR DATA - Line level - Appears on Check Stub one or more lines as needed"]
[null,null,null,null,"Amount:  The amount associated with the case or other county business"]
[null,null,null,null,"Invoice Line Description:  Describe purpose of the detail amount and each line will  display on the stub.  "]
[null,null,null,null,"Obligation Date:  Enter a date here only if the Obligation  date is different than the Obligation Date (Default)."]
[null,null,null,null,"4.  Is this a Pay Alone situation? Change the Pay Alone Setting (Instructions Above)"]
[null,null,null,null,"5.  Click 3. Validate Single Payment & Post to APIO_File Tab  button"]
[null,null,null,null,"6. Repeat 1-4 until all payments are addressed on the APIO_FILE tab"]
[null,null,null,null,"6. Review APIO_File tab (You can unprotect and delete rows for re-entry)"]
[null,null,null,null,"7.  Click 6. Send APIO_File to BizTalk Folder Using Filename button."]
[null,null,null,null,"-","Creates File using the Filename provided into the Biztalk Folder designated."]
[null,null,null,null,"-","Check Archive Folder within Biztalk Folder for backup and submission history"]
[null,null,null,null,"-","Notification should be received every 10 minutes from the top of the hour.  "]
[]
[null,null,null,null,"Approvals are Manual"]
[null,null,null,null,"Notifications are sent out every 10 minutes starting at the top of the hour.  "]
[null,null,null,null,"Both requestors will receive the Approval notification. (Authorized Signers maybe placed here in smaller offices as backup.)"]
[null,null,null,null,"Follow email instructions.  If the Authorized Signers are not available department heads can approve and forward."]
[null,null,null,null,"It is important that the words \"Approve\" or \"Reject\" are present on each approver."]
[]
[null,null,null,null,"Note Requester 1 and the Final Notification will receive a status email at the end of the day.  "]
[]
[null,null,null,null,"To Request Notification Changes:  Requests should be sent to APImport@dallascounty.org  "]
[null,null,null,null,null,"This is in addition to your Authorized Signer forms."]
[]
[null,null,null,null,"Training, How To and Updated Entry Forms can be found on the APIO Training link at this web page."]
[null,null,null,null,"https://www.dallascounty.org/departments/auditor/training-new.php"]
[null,null,null,null,"  Hover over URL above until you see a website prompt, then click to go to the website."]

{"sheet":"APIO_FILE","index":1,"n_rows":1,"n_cols":55,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Invoice Type","Invoice Number","Invoice Date","Vendor Lookup Method","Vendor Lookup Value","Vendor Name","Pay Site","Invoice Amount","Invoice Description","Line Type","Line Amount","Line Description","Service Start","Obligation Date","Requestor","Quantity","Unit Price","UOM","PO Number","PO Line No","PO Line Search","Ship To","Serial Number","Manufacturer","Model Number","Source","Source Group","Created by User","Pay Group","Received","Distribution Set","Charge Account","Payee Name","Address Line 1","Address Line 2","Address Line 3","City","State","Zip Code","Project Number","Task Number","Expenditure Date","Expentiture Type","Expenditure Org","Contract Number","Funding Source","Filename","Request ID","TBD49","TBD50","TBD51","TBD52","TBD53","TBD45","TBD55"]

{"sheet":"Tools","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[9,1,9,4],[9,10,9,16],[14,10,14,16],[15,10,15,16],[10,10,10,16],[11,10,11,16],[12,10,12,16],[13,10,13,16],[0,1,0,7],[5,10,5,16],[1,10,1,16],[0,10,0,16],[2,10,2,16],[3,10,3,16],[4,10,4,16]]}
[null,"APPEND TOOL: Adds up to 5 other templates or APIO files (Archived from previouse sends) to this template's APIO_Files Tab.   Review Tips and Tricks to right for more information.",null,null,null,null,null,null,null,null,"Tips and Tricks"]
[1," Open Y/N","Network Path of files to add to this template: Use Windows File Explorer (Windows Key + E will open)  The path is located above the navigation panes to the right of the arrows (<- ->)  When you mouse click into the next field after the verbiage it will change and you can copy this for your Network Path. This works best if you are using a mapped network drive. J: K: G:","Filename  \nTarget to Consolidate. File must be closed.  Filename should end with .txt, .csv or .xlsx indicating the file type.","APIO Template Filename will have an .xlsx extension. (Y/N)","APIO File\nFilename will have .txt or .csv extension\n (Y/N)","Rows Appended","Amount Appended","When",null,"Want to review or change the APIO File that went to Oracle?  \n-Click Start New button on the Entry form \n-Using Tool #1\n-Verify/Enter the Network Path and Filename for the APIO File you want to review in your APIO Archive folder.  \n-Make sure Y/N and APIO File columns = Y\nClick the Grey button with #1 to start the process. Column A Row 2."]
["A","Y","K:\\SYSTEMS\\PROJECTS\\APAUTOMATION\\APIO\\SPECIAL FUNDS\\ENTRY TEMPLATES\\","501_SECTION1.CSV",null,"Y",2,14,"2023-04-26T10:23:00",null,"Use the Y/N column to switch off what is to be consolidated.  "]
["B","Y","K:\\SYSTEMS\\PROJECTS\\APAUTOMATION\\APIO\\SPECIAL FUNDS\\ENTRY TEMPLATES\\","501_SECTION3.CSV",null,"Y",1,10,"2023-04-26T10:23:00",null,"Reusing the same Paths and Filenames can be an reduce the need to change every time the tool is used."]
["C","Y","K:\\SYSTEMS\\PROJECTS\\APAUTOMATION\\APIO\\SPECIAL FUNDS\\ENTRY TEMPLATES\\","501_SECTION2.CSV",null,"Y",1,2,"2023-04-26T10:23:00",null,"File Not Found error check your entered information also if your drive on Windows File Explorer has an X you will have to activate it by clicking in Windows Explorer and try again."]
["D","N",null,null,null,null,null,null,null,null,"Remember you can make copies of your template and use them for different purposes."]
["E","N"]
[null,null,null,null,null,"Initial Total",1,10]
[null,null,null,null,null,"Final Total",{"$f":"SUM(G3:G8)","v":5},{"$f":"SUM(H3:H8)","v":36}]
[null,"CONVERT TO EXCEL:  Converts and opens up to five  .txt or .csv file with a delimiter other than comma and saves to excel.  There are tips and tricks to the right please review",null,null,null,null,null,null,null,null,"Convert to Excel with Special character field seperators."]
[2,"Y/N","Network Path","Filename.  File must be closed.","Delimited By special  character | = Pipe",null,null,null,null,null,"Enter or copy and paste the Network path and enter the file name.  "]
["A","Y","K:\\SYSTEMS\\PROJECTS\\APAUTOMATION\\APIO\\SPECIAL FUNDS\\ENTRY TEMPLATES","501PROBATE.CSV","|",null,null,null,null,null,"Make sure Y/N = Y and the delimiter is notated in comun E"]
["B","N","ENTER FILE PATH HERE","ENTER FILENAME AND EXTENSION","|",null,null,null,null,null,"Click the #2 button.  "]
["C","N",null,null,"|",null,null,null,null,null,"If you are prompted with a  message that file name already exits   click yes to override  and continue or no to stop and you can adjust as needed."]
["D","N",null,null,"|",null,null,null,null,null," The new file is the  same path as before but with .xlsx at the end.  It is also opened for review."]
["E","N",null,null,"|"]

{"sheet":"Fund List","index":3,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Fund","Fund Name","Protect Invoice Number","Protect Invoice Description","Protect Address  Line 2","Protect Address  Line 3","Production Biztak Folder:  Do not change this is your default Folder to \"send\" files to Oracle. ","Test Biztalk Folder - Copy to Entry Form to test","Function"]
[501,"County Clerk-Special","Yes","Yes","Yes","Yes","K:\\1 COUNTY CLERK APIO\\Fund 501\\APIO_Files","K:\\1 County Clerk APIO TEST ONLY\\Fund 501\\APIO_Files",40000]
[502,"County Clerk-Trust","Yes","Yes","Yes","Yes","K:\\1 COUNTY CLERK APIO\\Fund 502\\APIO_Files","K:\\1 County Clerk APIO TEST ONLY\\Fund 502\\APIO_Files",40000]
["503T","District Clerk SF-Trust","Yes",null,null,null,"K:\\DISTRICT CLERK SPECIAL FUND 503\\APIO\\PRODUCTION\\APIO_Files","K:\\DISTRICT CLERK SPECIAL FUND 503\\APIO\\TEST_ORATBS\\APIO_Files",40000]
["503J","District Clerk SF-Juvenile","Yes",null,null,null,"K:\\DISTRICT CLERK SPECIAL FUND 503\\APIO\\PRODUCTION\\APIO_Files","K:\\DISTRICT CLERK SPECIAL FUND 503\\APIO\\TEST_ORATBS\\APIO_Files",40000]
["504B","District Clerk-Criminal Bonds","Yes","Yes",null,null,"K:\\TRUST DEPT APIO\\APIO\\PRODUCTION\\APIO_Files","K:\\TEST TRUST DEPT APIO\\TEST_ORATBS\\APIO_Files",40000]
["504T","District Clerk-Trust","Yes",null,null,null,"K:\\TRUST DEPT APIO\\APIO\\PRODUCTION\\APIO_Files","K:\\TEST TRUST DEPT APIO\\TEST_ORATBS\\APIO_Files",40000]
["505B","Sheriff-Special Bonds","Yes",null,null,null,"G:\\FMS\\Fiscal\\Fiscal\\APIO\\Production\\APIO_Files","G:\\FMS\\Fiscal\\Fiscal\\APIO\\TEST\\APIO_Files",30000]
["505O","Sheriff-Special Office","Yes",null,null,null,"G:\\FMS\\Fiscal\\Fiscal\\APIO\\Production\\APIO_Files","G:\\FMS\\Fiscal\\Fiscal\\APIO\\TEST\\APIO_Files",30000]
[506,"County Clerk SF-Trust","Yes",null,null,null,"K:\\1 COUNTY CLERK APIO\\Fund 506\\APIO_Files","K:\\1 County Clerk APIO TEST ONLY\\Fund 506\\APIO_Files",40000]
["534","DA Restitution","Yes",null,null,null,"G:\\Budget\\Accounting\\APIO_Files\\PRODUCTION","G:\\Budget\\Accounting\\APIO_Files\\TEST_ORATBS",40000]
[538,"DA Check Processing Fees","Yes",null,null,null,"G:\\Budget\\Accounting\\APIO_Files\\PRODUCTION","G:\\Budget\\Accounting\\APIO_Files\\TEST_ORATBS",40000]
[543,"Adult Probation-Restitution","Yes",null,null,null,"G:\\CSCDRESTITUTION\\APIO\\PRODUCTION\\APIO_FILES","G:\\CSCDRESTITUTION\\APIO\\TEST\\APIO_FILES",40000]
[544,"DA Forfeitures - Attorney General","Yes",null,null,null,"G:\\Budget\\Accounting\\APIO_Files\\PRODUCTION","G:\\Budget\\Accounting\\APIO_Files\\TEST_ORATBS",40000]
[545,"DA Unajudicated-Gambling Statues","Yes",null,null,null,"G:\\Budget\\Accounting\\APIO_Files\\PRODUCTION","G:\\Budget\\Accounting\\APIO_Files\\TEST_ORATBS",40000]
[546,"DA Forfeitures-Narcotics","Yes",null,null,null,"G:\\Budget\\Accounting\\APIO_Files\\PRODUCTION","G:\\Budget\\Accounting\\APIO_Files\\TEST_ORATBS",40000]
[547,"DA-State Forfeiture Fees Other","Yes",null,null,null,"G:\\Budget\\Accounting\\APIO_Files\\PRODUCTION","G:\\Budget\\Accounting\\APIO_Files\\TEST_ORATBS",40000]
[550,"Justice of the Peace 1-1 ","Yes",null,null,null,"G:\\JP11\\APIO_Files","K:\\APIO_TEST\\APIO_Files",40000]
[551,"Justice of the Peace 1-2 ","Yes",null,null,null,"G:\\JP12\\APIO_Files","K:\\APIO_TEST\\APIO_Files",40000]
[553,"Justice of the Peace 3-3 ","Yes",null,null,null,"G:\\JP32\\APIO_Files","K:\\APIO_TEST\\APIO_Files",40000]
[554,"Justice of the Peace 2-1 ","Yes",null,null,null,"G:\\JP21\\APIO_Files","K:\\APIO_TEST\\APIO_Files",40000]
[555,"Justice of the Peace 2-2 ","Yes",null,null,null,"G:\\JP22\\APIO_Files","K:\\APIO_TEST\\APIO_Files",40000]
[556,"Justice of the Peace 3-1 ","Yes",null,null,null,"G:\\JP31\\APIO_Files","K:\\APIO_TEST\\APIO_Files",40000]
[557,"Justice of the Peace 3-2 ","Yes",null,null,null,"G:\\JP32\\APIO_Files","K:\\APIO_TEST\\APIO_Files",40000]
[559,"Justice of the Peace 4-1 ","Yes",null,null,null,"G:\\JP41\\APIO_Files","K:\\APIO_TEST\\APIO_Files",40000]
[560,"Justice of the Peace 4-2 ","Yes",null,null,null,"G:\\JP42\\APIO_Files","K:\\APIO_TEST\\APIO_Files",40000]
[561,"Justice of the Peace 5-1 ","Yes",null,null,null,"G:\\JP51\\APIO_Files ","K:\\APIO_TEST\\APIO_Files",40000]
[562,"Justice of the Peace 5-2 ","Yes",null,null,null,"G:\\JP51_52\\APIO_Files ","K:\\APIO_TEST\\APIO_Files",40000]
[580,"Constable 1 Special Fund","Yes",null,null,null,"G:\\Constable Precinct\\APIO_Files","K:\\APIO_TEST\\APIO_Files",30000]
[581,"Constable 2 Special Fund","Yes",null,null,null,"G:\\Const2\\APIO_Files","K:\\APIO_TEST\\APIO_Files",30000]
[582,"Constable 3 Special Fund","Yes",null,null,null,"G:\\Const3\\APIO_Files_Production","K:\\APIO_TEST\\APIO_Files",30000]
[584,"Constable 4 Special Fund","Yes",null,null,null,"G:\\Omni_Forms\\APIO_Files","K:\\APIO_TEST\\APIO_Files",30000]
[586,"Constable 5 Special Fund","Yes",null,null,null,"G:\\Constable Precinct 5\\Bookkeeping\\APIO\\PRODUCTION\\APIO_Files","K:\\APIO_TEST\\APIO_Files",30000]

{"sheet":"Substitution Rules","index":4,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Fund","Code","Parrent Code","Field Count","Description/ Purpose of Code","Substitute Payee Name  (6)","Substitute Address","Substiture Invoice Description (1.00 [GL String] is used for automated deposit preparation. 1.00 = 100% of the line amount will be applied to the GL Account Combination.)","Substitute Line Description (New Code [rule name] fields in expected order. ","Verify Check Total","Invoice Code"]
[502,"SB",null,4,"Surety CB Return  - Cash Bond owed ",null,null,null,"CB [DSO Receipt] Receipt,Case,Defendant Name","Yes"]
[502,"SA","SB",1,"SuretyCB Return - Administrative Fee","120 GENERAL FUND","APIO Deposit","1.00 100.12000.0000.45510.40000.0000","CC [DSO Receipt] Receipt,Case,Defendant Name",null,"AF"]
[502,"SF","SB",1,"Surety CB Return - To be applied to fees and costs of the defendant.","DALLAS COUNTY CLERK CRIMINAL-CT COST","DO NOT MAIL",null,"CC [DSO Receipt] Receipt,Case,Defendant Name",null,"CC"]
[502,"SP","SB",1,"Stop Payment","120 GENERAL FUND","APIO Deposit","1.00 100.12000.0000.45153.10000.0000","CC [DSO Receipt] Receipt,Case,Defendant Name",null,"SP"]
[502,"CF",null,4,"Couty CB Return - To be applied to fees and costs of the defendant.","DALLAS COUNTY CLERK CRIMINAL-CT COST","DO NOT MAIL",null,"CC [DSO Receipt] Receipt,Case,Defendant Name","Yes","CC"]
[502,"CA","CF",4,"County CB Return - Administrative Fee","120 GENERAL FUND","APIO Deposit","1.00 100.12000.0000.45510.40000.0000","CC [DSO Receipt] Receipt,Case,Defendant Name",null,"AF"]
[502,"BF",null,4,"CB applied to Bond Forf Fee","DALLAS COUNTY CLERK CRIMINAL BOND FORFEITURE COST","DO NOT MAIL",null,"BF [DSO Receipt] Receipt,Case,Defendant Name",null,"BF"]
[502,"US",null,2,"Unclaimed Funds","882 WIRE TRANSFER","APIO Deposit","1.00 100.88200.0000.10010.00000.0000","Unclaimed Property to State",null,"WR"]
[502,"UC",null,2,"Unclaimed Property < 100","120 GENERAL FUND","APIO Deposit","1.00 100.12000.0000.46030.10000.0000","Unclaimed Property to Dallas County",null,"UC"]
[502,"XX",null,2,"Does not substitue anything "]
["504B","CB",null,4,"Felony CashBond",null,null,null,"CB [DC DSO Receipt] Receipt,Case,Defendant Name"]
["504B","AF","CB",1,"Felony Administrative Fee","120 GENERAL FUND","APIO Deposit","1.00 100.12000.0000.44410.10000.0000","AF [DC DSO Receipt] Receipt,Case,Defendant Name",null,"AF"]
["504B","DC","CB",1,"Return to District Clerk to be applied to  costs and fines of the defendant","DISTRICT CLERK CT COST & FINES","CPU",null,"DC [DC DSO Receipt] Receipt,Case,Defendant Name",null,"DC"]
["504B","SF",null,4,"Surety Forfieture: Surety portion",null,null,null,"SF [DC DSO Receipt] Receipt,Case,Defendant Name"]
["504B","SC","SF",1,"Surety Forfieture: County portion","District Clerk Special Fund ","CPU",null,"BF [DC DSO Receipt] Receipt,Case,Defendant Name",null,"BF"]
["504B","BF",null,4,"Felony Bond Forfieture","District Clerk Special Fund ","CPU",null,"BF [DC DSO Receipt] Receipt,Case,Defendant Name",null,"BF"]
["504B","XX",null,2,"Does not substitue anything "]