{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["CIR Voucher Form","Test Data","XML Staging","XML Data","Created Data","Trading Partner Reference Data","Option Choices"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":231,"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":"CIR Voucher Form","index":0,"n_rows":103,"n_cols":5,"rows_kept":103,"cut":false,"hidden":false,"merged":[[70,1,70,2],[96,1,96,2],[61,1,61,2],[30,1,30,2],[50,1,50,2],[85,1,85,2],[0,0,0,3],[1,0,1,1],[1,2,1,3],[5,1,5,2],[10,1,10,2]]}
["Commercial Voucher Entry Form"]
["Version:",null,"1.0.0"]
[]
[]
[]
[null,"BATCH INFORMATION"]
[null,"Trading Partner"]
[null,"Deposit Date"]
[]
[]
[null,"GENERAL VOUCHER INFORMATION"]
[null,"Source Voucher ID"]
[null,"Voucher Date"]
[null,{"$f":"IF(TradingPartnerIsOTCNetTGA,\"Voucher Number (or Deposit Ticket)\",\"Voucher Number\")","v":"Voucher Number"}]
[null,"Voucher Type"]
[null,"Voucher Amount"]
[null,"IRS Tax Collection "]
[null,"ALC"]
[null,"A/C/R Indicator"]
[null,"Bank Acct #"]
[null,"RTN"]
[null,"FI Comments"]
[null,"Agency Comments"]
[null,"Receipts From Date"]
[null,"Receipts To Date"]
[null,"Classification"]
[null,"Reporting Program/Subprogram"]
[null,"CAN"]
[]
[]
[null,"ADDITIONAL VOUCHER INFORMATION"]
[null,{"$f":"IF(TradingPartnerIsPayGovDigitalWallet,\"ALC+2\",\"Cash Flow ID\")","v":"Cash Flow ID"}]
[null,{"$f":"IF(TradingPartnerIsPayGovDigitalWallet,\"Application Name\",\"Cash Flow Name\")","v":"Cash Flow Name"}]
[null,{"$f":"IF(TradingPartnerIsPayGovDigitalWallet,\"Agency Identifier\",IF(TradingPartnerIsNavyCash,\"Ship Name\",\"Agency Account ID\"))","v":"Agency Account ID"}]
[null,"Trace ID"]
[null,"FAID"]
[null,{"$f":"IF(TradingPartnerIsOTCNetTGA,\"OTC Endpoint (short name)\",\"Initial Location\")","v":"Initial Location"}]
[null,"Receipt Mechanism"]
[null,"Channel Type"]
[null,"Source Processing Program"]
[null,"Source Subprogram"]
[null,"Initiation Date"]
[null,{"$f":"IF(TradingPartnerIsOTCNetTGA,\"Deposit Created Date\",\"Channel Receipt Date\")","v":"Channel Receipt Date"}]
[null,"Confirmed Date"]
[null,"Is Intragovernmental?"]
[null,"Number of Transactions in Voucher"]
[null,"Is Non Domestic?"]
[null,"PARS Code"]
[]
[]
[null,"TAX INFORMATION"]
[null,"1 - Withheld and FICA",null,null,{"$f":"IF(AND(NOT(Is_Tax),NOT(ISBLANK($C52))),\"Warning: value will be ignored since this is not a Tax Voucher\",\"\")","v":""}]
[null,"2 - Individual",null,null,""]
[null,"3 - Corporate",null,null,""]
[null,"4 - Excise",null,null,""]
[null,"5 - Estate and Gift",null,null,""]
[null,"7 - CTA",null,null,""]
[null,"8 - FUTA",null,null,""]
[null,"9 - Misc. Receipts",null,null,""]
[]
[]
[null,"ADJUSTMENTS / CORRECTION / RESCINDS (ACR)"]
[null,"Original Voucher Date",null,null,{"$f":"IF(AND(ACR_Indicator=\"No\",NOT(ISBLANK($C63))),\"Warning: value will be ignored since this is not an ACR Voucher\",\"\")","v":""}]
[null,"Original Voucher Number",null,null,""]
[null,"Original Deposit Date",null,null,""]
[null,"A/C/R Type",null,null,""]
[null,"Reason Code",null,null,""]
[null,"Reason Text",null,null,""]
[]
[]
[null,"CLASSIFICATION INFORMATION"]
[null,"Classification Amount",null,null,{"$f":"IF(AND(Classification=\"Unknown\",NOT(ISBLANK($C72))),\"Warning: value will be ignored since the Classification for this Voucher is 'Unknown'\",\"\")","v":""}]
[null,"Agency ID",null,null,{"$f":"IF(AND(Classification<>\"TAS/BETC\",NOT(ISBLANK($C73))),\"Warning: value will be ignored since the Classification for this Voucher is 'Unknown' or 'Ckey'\",\"\")","v":""}]
[null,"Allocation Transfer ID",null,null,""]
[null,"Availability Type Code",null,null,""]
[null,"Beginning Period of Availability",null,null,""]
[null,"Ending Period of Availability",null,null,""]
[null,"Main Account Code",null,null,""]
[null,"Sub Account Code",null,null,""]
[null,"Sub Level Prefix Code",null,null,""]
[null,"Business Event Type Code",null,null,""]
[null,"Class Name",null,null,{"$f":"IF(AND(Classification<>\"C-Key\",NOT(ISBLANK($C82))),\"Warning: value will be ignored since the Classification for this Voucher is not 'C-Key'\",\"\")","v":""}]
[null,"Class Value",null,null,{"$f":"IF(AND(Classification<>\"C-Key\",NOT(ISBLANK($C83))),\"Warning: value will be ignored since the Classification for this Voucher is not 'C-Key'\",\"\")","v":""}]
[]
[]
[null,"COMMERCIAL / FRB ACCOUNT INFORMATION"]
[null,"FRB District Code"]
[null,"FRB Office Code"]
[null,"FRB Account Key Code"]
[null,"Cost Center Work Unit Code"]
[null,"Treasury RTN"]
[null,"Depositary Detail RTN"]
[null,"Transfer Mechanism Code"]
[null,"Funds Available Date"]
[]
[]
[null,"PROGRAM AND USER DATA"]
[null,"Program Data ID"]
[null,"Program Data Description"]
[null,"Agency Label"]
[null,"Field ID"]
[null,"User Data Value"]
[null,"Has Privacy Data"]

{"sheet":"Test Data","index":1,"n_rows":103,"n_cols":42,"rows_kept":103,"cut":false,"hidden":true,"merged":[[70,1,70,41],[85,1,85,41],[96,1,96,41],[5,1,5,41],[10,1,10,41],[30,1,30,41],[50,1,50,41],[61,1,61,41]]}
[null,null,null,null,null,null,null,null,"Missing Info, cannot save.",null,null,null,null,null,null,null,null,null,"Missing Info, cannot save.",null,null,null,null,null,null,null,null,null,"**Fail Info Missing- OK",null,null,null,null,null,"***Should not save mismatch amnts",null,null,null,"***SHOULD NOT BE ABLE TO BE SAVED"]
[]
[null,null,"CAS_Ex1_CR_Unk_Ntax","CAS_Ex2_DB_Unk_NTax","CAS__Ex3_CR_Ckey_Tax1","CAS_Ex4_CR_Ckey_NTax","CAS_Ex5_DB_Ckey_ALL","CAS_Ex6_CR_ACR_Recind_ErSub_Ckey_Ntax","CAS_Ex7_DB_ACR_Other_Ckey_Ntax_MissReq","CAS_Ex8_CR_ACR_Add_TASB_Tax_PII","CAS_Ex9_ACR_CR_Adj_Unk_Ntax_TaxInfo","CAS_Ex10_DB_ACR_CORR_Unk_Ntax","NVYCSH_Ex1_CR_Unk_NTax","NVYCSH_Ex2_DB_Unk_NTax","NVYCSH_Ex3_CRA_Unk_Ntaxinfo","NVYCSH_Ex4_CR_Ckey_Tax","NVYCSH_Ex5_DB_Ckey_ALL","NVYCSH_Ex6_CR_ACR_Recind_ErSub_Ckey_Ntax","NVYCSH_Ex7_DB_ACR_Other_Ckey_Ntax_MissReq","NVYCSH_Ex8_CR_ACR_Add_TASB_Tax_PII","NVYCSH_Ex9_ACR_CR_Adj_Unk_Ntax_TaxInfo","NVYCSH_Ex10_DB_ACR_CORR_Unk_Ntax","TGA_Ex1_CR_Ckey_NTx","TGA_Ex2_DB_Cky_NTx_Cmts","TGA_Ex3_CR_Ckey_Tax1","TGA_Ex4_CR_Ckey_Tax2","TGA_Ex5_DB_Ckey_ALL","TGA_Ex6_CR_ACR_Recind_ErSub_CKey_Ntax","TGA_Ex7_DB_ACR_Other_Ckey_Ntax_MissReq","TGA_Ex8_CR_ACR_Add_TASB_Tax_PII","TGA_Ex9_ACR_CR_Adj_Unk_Ntax_TaxInfo","TGA_Ex10_DB_ACR_CORR_Unk_Ntax","PG_Ex1_CR_Ckey_NTx","PG_Ex2_DB_Cky_NTx_Cmts","PG_Ex3_CR_Ckey_Tax1","PG_Ex4_CR_Ckey_Tax2","PG_Ex5_DB_Ckey_ALL","PG_Ex6_CR_ACR_Recind_ErSub_Unk_Ntax","PG_Ex7_DB_ACR_Other_Unk_Ntax_MissReq","PG_Ex8_CR_ACR_Add_TASB_Tax_PII","PG_Ex9_ACR_CR_Adj_Unk_Ntax_TaxInfo","PG_Ex10_DB_ACR_CORR_Unk_Ntax"]
[]
[]
[null,"BATCH INFORMATION"]
[null,"Trading Partner","CAS","CAS","CAS","CAS","CAS","CAS","CAS","CAS","CAS","CAS","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","OTC-Net TGA","OTC-Net TGA","OTC-Net TGA","OTC-Net TGA","OTC-Net TGA","OTC-Net TGA","OTC-Net TGA","OTC-Net TGA","OTC-Net TGA","OTC-Net TGA","Pay.gov (Digital Wallet)","Pay.gov (Digital Wallet)","Pay.gov (Digital Wallet)","Pay.gov (Digital Wallet)","Pay.gov (Digital Wallet)","Pay.gov (Digital Wallet)","Pay.gov (Digital Wallet)","Pay.gov (Digital Wallet)","Pay.gov (Digital Wallet)","Pay.gov (Digital Wallet)"]
[null,"Deposit Date",{"$f":"TODAY()","v":"2018-12-19"},"2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19","2018-12-19"]
[]
[]
[null,"GENERAL VOUCHER INFORMATION"]
[null,"Source Voucher ID","1","1","1234567","1","1234567","1","1","1","1","1","DSSN","DSSN","DSSN","DSSN","DSSN","DSSN","MAFLWR123456788909","5793066","MFLR5793066","FLOWER","1","1","1","1","1","1","1","1","1","1","001008","029556","938281","938281","111234","987678","33333333","77777777","98765","2233446"]
[null,"Voucher Date",{"$f":"TODAY()","v":"2018-12-19"},{"$f":"TODAY()-7","v":"2018-12-12"},{"$f":"TODAY()-42","v":"2018-11-07"},"2018-11-07",{"$f":"TODAY()-14","v":"2018-12-05"},"2018-11-07","2018-11-07","2018-11-07","2018-11-07",{"$f":"TODAY()-42","v":"2018-11-07"},{"$f":"TODAY()","v":"2018-12-19"},{"$f":"TODAY()-7","v":"2018-12-12"},{"$f":"TODAY()-42","v":"2018-11-07"},"2018-11-07",{"$f":"TODAY()-14","v":"2018-12-05"},"2018-11-07","2018-11-07","2018-11-07","2018-11-07","2018-11-07",{"$f":"TODAY()","v":"2018-12-19"},{"$f":"TODAY()-7","v":"2018-12-12"},"2018-11-07","2018-11-07",{"$f":"TODAY()-14","v":"2018-12-05"},"2018-11-07","2018-11-07","2018-11-07","2018-11-07","2018-11-07",{"$f":"TODAY()","v":"2018-12-19"},{"$f":"TODAY()-7","v":"2018-12-12"},"2018-11-07","2018-11-07",{"$f":"TODAY()-14","v":"2018-12-05"},"2018-11-07","2018-11-07","2018-11-07","2018-11-07","2018-11-07"]
[null,{"$f":"IF(TradingPartnerIsOTCNetTGA,\"Voucher Number (or Deposit Ticket)\",\"Voucher Number\")","v":"Voucher Number"},2,2,3,1,5,6,454545,657876,987987,10,100,200,300,400,500,600,700,800,900,1000,111111,1,2,3,4,5,7,8,9,10,1008,129556,938281,938281,111234,234,333333,143567,444444,987555]
[null,"Voucher Type","215 (Credit)","5515 (Debit)","215 (Credit)","215 (Credit)","215 (Credit)","215 (Credit)","5515 (Debit)","215 (Credit)","215 (Credit)","5515 (Debit)","215 (Credit)","5515 (Debit)","215A (Credit)","215A (Credit)","5515 (Debit)","215 (Credit)","5515 (Debit)","215A (Credit)","215 (Credit)","5515 (Debit)","215 (Credit)","5515 (Debit)","215A (Credit)","215A (Credit)","215A (Credit)","5515 (Debit)","5515 (Debit)","215 (Credit)","215 (Credit)","5515 (Debit)","215 (Credit)","5515 (Debit)","215 (Credit)","215 (Credit)","5515 (Debit)","215 (Credit)","5515 (Debit)","215 (Credit)","215 (Credit)","5515 (Debit)"]
[null,"Voucher Amount",2,3,4,1,5.50,6.60,7.70,8.8000000000000007,9.90,10.10,10.01,20.20,30.30,40.40,50.50,60.60,70.70,80.80,90.90,10.10,100.01,200.02,300.02999999999997,400.04,500.05,600.05999999999995,700.07,800.08,900.09,1000.10,210.44,35.99,1999,1100.8800000000001,2200,9999999999999.9902,1000.56,578.88,5000.1000000000004,800.77]
[null,"IRS Tax Collection ","Non-Tax","Non-Tax","Tax","Non-Tax","Tax","Non-Tax","Non-Tax","Tax","Non-Tax","Non-Tax","Non-Tax","Non-Tax","Non-Tax","Tax","Non-Tax","Non-Tax","Non-Tax","Tax","Non-Tax","Non-Tax","Non-Tax","Non-Tax","Tax","Tax","Tax","Non-Tax","Non-Tax","Tax","Non-Tax","Non-Tax","Non-Tax","Non-Tax","Tax","Tax","Tax","Non-Tax","Non-Tax","Tax","Non-Tax","Non-Tax"]
[null,"ALC","14100099","14100099","14100099","14100099","14100099","00000303","00000303","00000303","00003801","00003801","00003801","00008778","00008778","00008778","00008778","00008770","00000303","00000303","00000303","00000303","00000303","00000303","00000303","00000303","00000303","00000303","00000303","00000303","00000303","00003808","73000001","14100099","70050098","70050098","70050098","70050098","70050098","70050098","70050098","70050098"]
[null,"A/C/R Indicator","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes","No","No","No","No","No","Yes","Yes","Yes","Yes","Yes","No","No","No","No","Yes","Yes","Yes","Yes","Yes","Yes"]
[null,"Bank Acct #","123456789098","123456789098",null,null,"3434343434",null,null,null,null,null,"53036168833","53036168833","53036168833","53036168833","53036168833",null,null,null,null,"1234567899",null,null,null,null,"999999999",null,null,null,"222222222","12345",null,null,null,null,"2222222222",null,null,null,"897654"]
[null,"RTN",72000096,72000096,72000096,72000096,72000096,72000096,4100001,4100001,4100001,4100001,54000030,231371579,123456789,231371579,231371579,54000030,54000030,54000030,54000030,54000030,41000001,41000001,41000001,41000001,41000001,41000001,41000001,41000001,41000001,41000001,121000248,121000248,121000248,121000248,121000248,121000248,null,41010003,41010003,121000248]
[null,"FI Comments","n/a","!@#$%^*()_+ =-0987654321 QWERTYUIOP{}| ][poiuytrewq ASDFGHJKL:“ ’;lkjhgfdsa ZXCVBNM?., rc mnbvcxz It was 7:45 we were all in line 2 greet the teacher Miss Cathleen First was Kevin, then came Lucy, third in line was me.  All of us were ordinary compared to Cynthia Rose, she always stood at the back of the line a smile beneath her nose.  Her favorite number was 20 and every single day i THIS is 400",null,null,"N/A",null,null,null,null,null,null,"Test manual adjustment to balance error.",null,null,"!@#$%^*()_+ =-0987654321 QWERTYUIOP{}| ][poiuytrewq ASDFGHJKL:“ ’;lkjhgfdsa ZXCVBNM?., rc mnbvcxz It was 7:45 we were all in line 2 greet the teacher Miss Cathleen First was Kevin, then came Lucy, third in line was me.  All of us were ordinary compared to Cynthia Rose, she always stood at the back of the line a smile beneath her nose.  Her favorite number was 20 and every single day i THIS is 400",null,null,"N/A","N/A",null,null,"!@#$%^*()_+ =-0987654321 QWERTYUIOP{}| ][poiuytrewq ASDFGHJKL:“ ’;lkjhgfdsa ZXCVBNM?., rc mnbvcxz It was 7:45 we were all in line 2 greet the teacher Miss Cathleen First was Kevin, then came Lucy, third in line was me.  All of us were ordinary compared to Cynthia Rose, she always stood at the back of the line a smile beneath her nose.  Her favorite number was 20 and every single day i THIS is 400","N/A","N/A","All Fields filled in.",null,null,null,null,"None","Reversing Debit voucher 001008. Pay.gov tracking ID 263V6146 was refunded on 08/01/17 due to the deposit ticket not being to CIR due to the form failing in Pay.gov","!@#$%^*()_+ =-0987654321 QWERTYUIOP{}| ][poiuytrewq ASDFGHJKL:“ ’;lkjhgfdsa ZXCVBNM?., rc mnbvcxz It was 7:45 we were all in line 2 greet the teacher Miss Cathleen First was Kevin, then came Lucy, third in line was me.  All of us were ordinary compared to Cynthia Rose, she always stood at the back of the line a smile beneath her nose.  Her favorite number was 20 and every single day i THIS is 400","Test Comments","Test Comments","Test Comments",null,null,"n/a"]
[null,"Agency Comments",null,"!@#$%^*()_+=- 0987654321 {}|][“:;’? ,. 1234567890 QWERTYUIOP 567 lkjhgfdsazxcvbnmXYZ_100 Characters","1234567890 QWERTYUIOP lkjhgfdsazxcvbnmXYZ_100 Characters",null,"!@#$%^*()_+=- 0987654321 {}|][“:;’? ,. 1234567890 QWERTYUIOP fguH lkjhgfdsazxcvbnmXYZ_100 Characters",null,null,null,null,null,"Manual adjustments balance failed items.  Test",null,null,null,"!@#$%^*()_+=- 0987654321 {}|][“:;’? ,. 1234567890 QWERTYUIOP 567 lkjhgfdsazxcvbnmXYZ_100 Characters",null,null,null,"N/A","N/A",null,"!@#$%^*()_+=- 0987654321 {}|][“:;’? ,. 1234567890 QWERTYUIOP 567 lkjhgfdsazxcvbnmXYZ_100 Characters",null,null,"Testing every field filled out.",null,null,null,null,"Testing with various scenarios.",null,"!@#$%^*()_+=- 0987654321 {}|][“:;’? ,. 1234567890 QWERTYUIOP 567 lkjhgfdsazxcvbnmXYZ_100 Characters","Test Comments","Test Comments","Test Comments",null,null,"Test DVS forms","Test DVS forms"]
[null,"Receipts From Date",null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"}]
[null,"Receipts To Date",null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"}]
[null,"Classification","Unknown","Unknown","C-Key","C-Key","C-Key","C-Key","C-Key","TAS/BETC","Unknown","Unknown","Unknown","Unknown","Unknown","C-Key","C-Key","C-Key","C-Key","TAS/BETC","Unknown","Unknown","C-Key","C-Key","C-Key","C-Key","C-Key","C-Key","C-Key","TAS/BETC","Unknown","Unknown","C-Key","C-Key","C-Key","C-Key","TAS/BETC","Unknown","Unknown","TAS/BETC","Unknown","Unknown"]
[null,"Reporting Program/Subprogram","Card Acquiring Service","Card Acquiring Service","Card Acquiring Service","Card Acquiring Service","Card Acquiring Service","Card Acquiring Service","Card Acquiring Service","Card Acquiring Service","Card Acquiring Service","Card Acquiring Service","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Navy Cash","Bank Deposit","Bank Deposit","Bank Deposit","Bank Deposit","Bank Deposit","Bank Deposit","Bank Deposit","Bank Deposit","Bank Deposit","Bank Deposit","Pay.gov","Pay.gov","Pay.gov","Pay.gov","Pay.gov","Pay.gov","Pay.gov","DwollaResolutionCenter","PayPalResolutionCenter","AmazonResolutionCenter"]
[null,"CAN",10121,10121,10121,10121,10121,656,null,888,999,1010,10052,10052,10052,10052,10052,10052,10052,5123,5123,5123,111,111,111,111,111,111,111,111,111,111,10058,10058,10058,10058,10058,888,888,876876,222222,889933]
[]
[]
[null,"ADDITIONAL VOUCHER INFORMATION"]
[null,{"$f":"IF(TradingPartnerIsPayGovDigitalWallet,\"ALC+2\",\"Cash Flow ID\")","v":"Cash Flow ID"},null,null,null,null,"876876876",null,null,null,null,null,null,null,null,null,"1234",null,null,null,null,null,null,null,null,null,"00000303",null,null,null,null,null,null,null,null,null,"7005009802",null,null,null,"7005009801"]
[null,{"$f":"IF(TradingPartnerIsPayGovDigitalWallet,\"Application Name\",\"Cash Flow Name\")","v":"Cash Flow Name"},null,null,null,null,"DVS TEST",null,null,null,null,null,null,null,null,null,"Navy Cash",null,null,null,null,null,null,null,null,null,"Test Cashflow Name",null,null,null,null,null,null,null,null,null,"Pay Gov Did Wallet",null,null,null,null,"PayGov"]
[null,{"$f":"IF(TradingPartnerIsPayGovDigitalWallet,\"Agency Identifier\",IF(TradingPartnerIsNavyCash,\"Ship Name\",\"Agency Account ID\"))","v":"Agency Account ID"},null,null,null,null,"123",null,null,null,null,null,null,null,null,null,"USS Ship",null,null,null,null,null,null,null,null,null,"Account ID",null,null,null,null,null,null,null,null,null,"987hj"]
[null,"Trace ID",null,null,null,null,1234567,null,null,null,null,null,null,null,null,null,33445,null,null,null,null,null,null,null,null,null,"Trace ID",null,null,null,null,null,null,null,null,null,77665544]
[null,"FAID"]
[null,{"$f":"IF(TradingPartnerIsOTCNetTGA,\"OTC Endpoint (short name)\",\"Initial Location\")","v":"Initial Location"},null,null,null,null,"NONE",null,null,null,null,null,null,null,null,null,"USA",null,null,null,null,null,null,null,null,null,"OTC",null,null,null,null,null,null,null,null,null,"Cleveland"]
[null,"Settlement Mechanism","Card",null,null,null,"Card",null,null,"Card",null,null,null,null,null,null,"SVC",null,"SVC",null,null,null,null,null,null,null,"Check",null,null,null,null,null,null,null,null,null,"Other"]
[null,"Channel Type","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","OTC","Internet","Internet","Internet","Internet","Internet","Internet","Internet","Internet","Internet","Internet"]
[null,"Source Processing Program","Card Acquiring Service",null,null,null,"Card Acquiring Service",null,null,"Card Acquiring Service",null,null,null,null,null,null,"SVC",null,"SVC",null,null,"SVC",null,null,null,null,"TGA Networks","TGA Networks",null,null,null,"TGA Networks",null,null,null,null,"E-Commerce"]
[null,"Source Subprogram","empty",null,null,null,"BLANK",null,null,"BLANK",null,null,null,null,null,null,"Navy Cash",null,"Navy Cash",null,null,"Navy Cash",null,null,null,null,"TGA","TGA",null,null,null,"TGA",null,null,null,null,"PayPal"]
[null,"Initiation Date",null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-357","v":"2017-12-27"}]
[null,{"$f":"IF(TradingPartnerIsOTCNetTGA,\"Deposit Created Date\",\"Channel Receipt Date\")","v":"Channel Receipt Date"},null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-294","v":"2018-02-28"}]
[null,"Confirmed Date",null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-329","v":"2018-01-24"}]
[null,"Is Intragovernmental?"]
[null,"Number of Transactions in Voucher",null,null,null,null,3,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,1,1,null,null,null,null,null,null,null,null,3]
[null,"Is Non Domestic?",null,"Yes",null,null,"Yes",null,null,null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,"Yes","Yes",null,null,null,null,null,null,null,null,"Yes",null,null,null,"Yes","No"]
[null,"PARS Code",null,"035",null,null,"222",null,null,null,null,null,null,null,null,null,"123",null,null,null,null,null,null,null,null,null,"034",null,null,null,null,null,null,null,null,null,"098",null,null,null,"045"]
[]
[]
[null,"TAX INFORMATION"]
[null,"1 - Withheld and FICA",null,null,0,null,1,null,7.70,8.8000000000000007,8.8000000000000007,null,null,null,null,0,0,null,null,80.80,90,null,null,null,0,100,100.05,null,null,100,200.01,null,null,null,0,0,1000,null,null,500,5000.1000000000004]
[null,"2 - Individual",null,null,0,null,1,null,0,0,0,null,null,null,null,0,0,null,null,0,0.90,null,null,null,300.02999999999997,100,0,null,null,100,100,null,null,null,0,0,50,null,null,0]
[null,"3 - Corporate",null,null,0,null,1,null,0,0,0,null,null,null,null,0,0,null,null,0,0,null,null,null,0,50,200,null,null,100,100,null,null,null,0,0,25,null,null,78]
[null,"4 - Excise",null,null,4,null,0.50,null,0,0,1.1000000000000001,null,null,null,null,0,0,null,null,0,0,null,null,null,0,50,0,null,null,100,100,null,null,null,1999,0,25,null,null,0.88]
[null,"5 - Estate and Gift",null,null,0,null,0.50,null,0,0,0,null,null,null,null,0,0,null,null,0,0,null,null,null,0,50,0,null,null,100,100,null,null,null,0,0,25,null,null,0]
[null,"7 - CTA",null,null,0,null,0.25,null,0,0,0,null,null,null,null,0,0,null,null,0,0,null,null,null,0,50,200,null,null,100,100,null,null,null,0,1000.88,1000,null,null,0]
[null,"8 - FUTA",null,null,0,null,0.25,null,0,0,0,null,null,null,null,0,0,null,null,0,0,null,null,null,0,0.02,0,null,null,100,100,null,null,null,0,100,25,null,null,0]
[null,"9 - Misc. Receipts",null,null,0,null,1,null,0,0,0,null,null,null,null,40.40,40.40,null,null,0,0,null,null,null,0,0.02,0,null,null,100.08,100.08,null,null,null,0,0,50,null,null,0]
[]
[]
[null,"ADJUSTMENTS / CORRECTION / RESCINDS (ACR)"]
[null,"Original Voucher Date",null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,{"$f":"TODAY()-1820","v":"2013-12-25"}]
[null,"Original Voucher Number",null,null,null,null,111111,null,null,null,null,null,null,null,null,null,345678,null,null,null,null,null,null,null,null,null,123456,222222,null,null,null,null,null,null,null,null,222222]
[null,"Original Deposit Date",null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,{"$f":"TODAY()-1820","v":"2013-12-25"}]
[null,"A/C/R Type",null,null,null,null,"Additional","Rescind","Other","Other","Adjustment","Correction",null,null,null,null,"Additional","Rescind","Other","Additional","Adjustment","Correction",null,null,null,null,"Adjustment","Rescind","Other","Additional","Adjustment","Correction",null,null,null,null,"Correction","Rescind","Other","Additional","Adjustment","Correction"]
[null,"Reason Code",null,null,null,null,"Other","Erroneous Submission","Other","Other","Amount Exception","Incorrect Data/Reporting Exception",null,null,null,null,"Other","Erroneous Submission","Other","Other","Return Item","Incorrect Data/Reporting Exception",null,null,null,null,"Other","Erroneous Submission","Other","Other","ENC - Encoding Exception","Incorrect Data/Reporting Exception",null,null,null,null,"Incorrect Data/Reporting Exception","Erroneous Submission","Other","Other","Return Item","Missing Information"]
[null,"Reason Text",null,null,null,null,"DVS ACR Test","Correct entry.","Testing CAS Worksheet","Testing CAS Worksheet","Testing CAS Worksheet again","n/a",null,null,null,null,"Correct Error, testing comment field","Resinding voucher, entered in error.",null,"N/A","N/A",null,null,null,null,null,"Sample Text","Sample Text",null,null,"Test document encoded incorrectly asking for a CR adjustment of $900.09.","Testing comments being entered.",null,"1234567890 -=+_)(*&^%$#@!  ASDFGHJKL:\"';lkjhgfdsa  ZXCVBNM< >?/.,mnbvcxzj This is 100 Chaaracters","1234567890 -=+_)(*&^%$#@!  ASDFGHJKL:\"';lkjhgfdsa  ZXCVBNM< >?/.,mnbvcxzj This is 100 Chaaracters",null,"N/A",null,null,"Test DVS form",null,"Entered incorrectly"]
[]
[]
[null,"CLASSIFICATION INFORMATION"]
[null,"Classification Amount",null,null,4,1,5.50,6.60,null,8.8000000000000007,null,null,null,null,null,40.40,50.50,60.60,null,80.80,null,null,100.01,200.02,300.02999999999997,400.04,500.05,600.05999999999995,700.07,800.08,800.08,null,210.44,35.99,35.99,1100.8800000000001,2200,9999999999999.9902,null,578.88]
[null,"Agency ID",null,null,null,null,"444",null,null,"999",null,null,null,null,null,null,"123",null,null,"111",null,null,null,null,null,null,"111",null,null,"123","123",null,null,null,null,null,"123",null,null,"888"]
[null,"Allocation Transfer ID"]
[null,"Availability Type Code"]
[null,"Beginning Period Of Availability"]
[null,"Ending Period Of Availability"]
[null,"Main Account Code",null,null,null,null,"2222",null,null,"9999",null,null,null,null,null,null,"9876",null,null,"1234",null,null,null,null,null,null,"1234",null,null,"1234","1234",null,null,null,null,null,"2222",null,null,"4444"]
[null,"Sub Account Code",null,null,null,null,"555",null,null,"888",null,null,null,null,null,null,"675",null,null,"222",null,null,null,null,null,null,"111",null,null,"234","234",null,null,null,null,null,"333",null,null,"333"]
[null,"Sub Level Prefix Code"]
[null,"Business Event Type Code",null,null,null,null,"test",null,null,"CAS",null,null,null,null,null,null,"test",null,null,"NVYCSH",null,null,null,null,null,null,"Code",null,null,"TASBETC","TASBETC","TGA",null,null,null,null,"44444",null,null,"099"]
[null,"Class Name",null,null,"DVS-TEST3","LOWELL NHP-BCMM","DVS-TEST","Testing","Test DVS",null,null,null,null,null,null,"Navy Cash","Navy Cash","Test  Navy Cash","MFLWR",null,null,null,"DVS Test Name","DVS Test Name DB","Test Name","Test Name","Test Name","Test Name",null,null,null,"OTC TGA Test","Pay Gov","Pay Gov","Pay Gov","Pay Gov","Pay Gov",null,null,null,"DVS"]
[null,"Class Value",null,null,999999999999,4445025526608,55555555555555,123456789987,1.23443215678998E+17,null,null,null,null,null,null,"Test","Test","Test  ","Test  ",null,null,null,"DVS Test Value","DVS Test Value DB","Test Value","Test Value","Test Value","Test Value",null,null,null,null,"Test DVS","Test DVS","Test DVS","Test DVS","Test DVS",null,null,null,"Test"]
[]
[]
[null,"COMMERCIAL / FRB ACCOUNT INFORMATION"]
[null,"FRB District Code",null,null,null,null,"04",null,null,null,null,null,null,null,null,null,"06",null,null,null,null,null,null,null,null,null,"04",null,null,null,null,null,null,null,null,null,"04"]
[null,"FRB Office Code",null,null,null,null,2,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,2]
[null,"FRB Account Key Code",null,null,null,null,"623",null,null,null,null,null,null,null,null,null,"632",null,null,null,null,null,null,null,null,null,"250",null,null,null,null,null,null,null,null,null,"432"]
[null,"Cost Center Work Unit Code",null,null,null,null,"1505",null,null,null,null,null,null,null,null,null,"5800",null,null,null,null,null,null,null,null,null,"1505",null,null,null,null,null,null,null,null,null,"1509"]
[null,"Treasury RTN",null,null,null,null,410003,null,null,null,null,null,null,null,null,null,21345678,null,null,null,null,null,null,null,null,null,400041,null,null,null,null,null,null,null,null,null,400019]
[null,"Depositary Detail RTN",null,null,null,null,1111,null,null,null,null,null,null,null,null,null,6100002,null,null,null,null,41000019,null,null,null,null,100023,null,null,null,null,41000049,null,null,null,null,111111111]
[null,"Transfer Mechanism Code",null,null,null,null,"Card",null,null,null,null,null,null,null,null,null,"NSS",null,null,null,null,"NSS",null,null,null,null,"Check",null,null,null,null,"Cash/Und Check",null,null,null,null,"ACH"]
[null,"Funds Available Date",null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-42","v":"2018-11-07"},null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-12-19"}]
[]
[]
[null,"PROGRAM AND USER DATA"]
[null,"Program Data ID",null,null,null,null,"875098DVSCAS",null,null,null,null,null,null,null,null,null,"test nvy csh",null,null,null,null,null,null,null,null,null,"DVS",null,null,null,null,null,null,null,null,null,"thy76"]
[null,"Program Data Description",null,null,null,null,"DVS CAS Test",null,null,null,null,null,null,null,null,null,"Navy Cash",null,null,null,null,null,null,null,null,null,"Test",null,null,null,null,null,null,null,null,null,"test data"]
[null,"Agency Label",null,null,null,null,"TEST CAS",null,null,null,null,null,null,null,null,null,"tests",null,"MFLWR",null,null,null,null,null,null,null,"No idea",null,null,null,null,null,null,null,null,null,"label"]
[null,"Field ID",null,null,null,null,98767,null,null,null,null,null,null,null,null,null,"this one",null,null,null,null,null,null,null,null,null,"again, no idea",null,null,null,null,null,null,null,null,null,"iuh789"]
[null,"User Data Value",null,"Bob's Big Break",null,null,"Unknown",null,null,"<?xml version=\"1.0\" encoding=\"utf-8\"?><Transmission ID=\"2018-01-03T11:08:070011\" TransmissionTimestamp=\"2018-01-03T11:08:07\" BusinessTransmissionCategory=\"Payments\" InputSystem=\"DVS\" SequenceNumber=\"0011\" IsEndOfDay=\"1\" TotalAmount=\"0.00\" TotalCount=\"0\" xmlns=\"urn:us:gov:treas:fms:BusinessTransaction:v4.6.1\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"urn:us:gov:treas:fms:BusinessTransaction:v4.6.1 Transmission.xsd\"></Transmission>",null,null,null,null,null,null,"test values",null,null,"No comment.  No, really.  No comment.","OK.  Put whatever you want…",null,null,null,null,null,"Testing what I can for now.",null,null,"Bob Loblaw","N/A",null,null,"1234567890 -=+_)(*&^%$#@!  ASDFGHJKL:\"';lkjhgfdsa  ZXCVBNM< >?/.,mnbvcxzj This is 100 Chaaracters","1234567890 -=+_)(*&^%$#@!  ASDFGHJKL:\"';lkjhgfdsa  ZXCVBNM< >?/.,mnbvcxzj This is 100 Chaaracters",null,"test notes for the worksheet",null,null,"Testing form"]
[null,"Has Privacy Data",null,"Does not contain PII Data",null,null,"Does not contain PII Data",null,null,"Contains PII Data",null,null,null,null,null,null,"Does not contain PII Data",null,null,"Contains PII Data","Does not contain PII Data",null,null,null,null,null,"Contains PII Data",null,null,"Contains PII Data","Does not contain PII Data","Does not contain PII Data",null,null,null,"Contains PII Data","Contains PII Data",null,null,"Contains PII Data"]

{"sheet":"XML Staging","index":2,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Voucher Type",{"$f":"SUBSTITUTE(SUBSTITUTE(Voucher_Type_Selected,\" (Credit)\",\"\"),\" (Debit)\",\"\")","v":""}]
["Is Credit?",{"$f":"IF(OR(Voucher_Type=\"215\",Voucher_Type=\"215A\"),1,IF(OR(Voucher_Type=\"5515\",Voucher_Type=\"5515A\"),0,\"\"))","v":""}]
["Is Tax?",{"$f":"IF(IRS_Tax_Collection=\"Tax\",TRUE,FALSE)","v":false}]
["Trading Partner Is CAS",{"$f":"Trading_Partner=TradingPartnerCAS","v":false}]
["Trading Partner Is Credit Gateway (ACH)",{"$f":"Trading_Partner=TradingPartnerCreditGatewayACH","v":false}]
["Trading Partner Is Credit Gateway (Fedwire)",{"$f":"Trading_Partner=TradingPartnerCreditGatewayFedwire","v":false}]
["Trading Partner Is EFTPS (ACH)",{"$f":"Trading_Partner=TradingPartnerEFTPSACH","v":false}]
["Trading Partner Is EFTPS (AGYTX)",{"$f":"Trading_Partner=TradingPartnerEFTPSAGYTX","v":false}]
["Trading Partner Is EFTPS (WIRE)",{"$f":"Trading_Partner=TradingPartnerEFTPSWIRE","v":false}]
["Trading Partner Is Navy Cash",{"$f":"Trading_Partner=TradingPartnerNavyCash","v":false}]
["Trading Partner Is OTCNetTGA",{"$f":"Trading_Partner=TradingPartnerOTCNetTGA","v":false}]
["Trading Partner Is Pay.gov Digitial Wallet",{"$f":"Trading_Partner=TradingPartnerPayGovDigitalWallet","v":false}]
["Date Format","yyyy-mm-dd"]
["Timestamp Format","yyyy-mm-ddThh:mm:ss"]
["Show <AccountClassification>",{"$f":"Classification<>\"Unknown\"","v":true}]
["Show <TreasuryAccountSymbol>",{"$f":"AND(Classification=\"TAS/BETC\",OR(NOT(ISBLANK(Agency_ID)),NOT(ISBLANK(Main_Account_Code)),NOT(ISBLANK(Sub_Account_Code))))","v":false}]
["Show <BusinessEventType>",{"$f":"AND(Classification=\"TAS/BETC\",NOT(ISBLANK(Business_Event_Type_Code)))","v":false}]
["Show <Ckey>",{"$f":"AND(Classification=\"C-Key\",OR(NOT(ISBLANK(Classification_Name)),NOT(ISBLANK(Classification_Value))))","v":false}]
["Show <CashFlowReference>",{"$f":"OR(LEN(Cash_Flow_ID)>0,LEN(Cash_Flow_Name)>0)","v":false}]
["Show <TreasuryAccountDetail>",{"$f":"LEN(Treasury_Routing_Number)>0","v":false}]
["Show <DepositaryDetail>",{"$f":"OR(LEN(Depositary_Detail_Routing_Number)>0,LEN(Transfer_Mechanism_Code)>0)","v":false}]
["Show <FinancialReportingDetail>",{"$f":"OR(LEN(Financial_Institution_Text)>0,LEN(Agency_Comment_Text)>0,LEN(Funds_Available_Date)>0,LEN(Receipts_From_Date)>0,LEN(Receipts_To_Date)>0,ShowOriginalSummaryReferenceElement,ShowTreasurySecuritiesInputDetailElement)","v":false}]
["Show <OriginalSummaryReference>",{"$f":"AND(ACR_Indicator=\"Yes\",OR(LEN(Original_Deposit_Date)>0,LEN(Original_Voucher_Date)>0,LEN(Original_Voucher_Number)>0))","v":false}]
["Show <TreasurySecuritiesInputDetail>",{"$f":"LEN(PARS_Code)>0","v":false}]
["Show <AccountableDetail>",{"$f":"OR(ShowOriginalSummaryReferenceElement,ShowTreasurySecuritiesInputDetailElement)","v":false}]
["Show <UserDataContent>",{"$f":"LEN(User_Data_Content)>0","v":false}]
["Show <UserData>",{"$f":"OR(LEN(Custom_Field_ID)>0,LEN(Agency_Label)>0,LEN(Has_Privacy_Data)>0)","v":false}]
["Show <Program_Data>",{"$f":"OR(LEN(Program_Data_ID)>0,LEN(Program_Data_Description)>0,ShowUserDataContentElement,ShowUserDataElement)","v":false}]

{"sheet":"XML Data","index":3,"n_rows":113,"n_cols":4,"rows_kept":113,"cut":false,"hidden":true,"merged":[]}
["XML Opening Element","XML Attribute","XML Attribute Value","XML Closing Element"]
["<Transmission","@ID",{"$f":"LOOKUP(Trading_Partner,FileProfileList,BaseFileList)&XMLTransmissionTimestamp&XMLSequenceNumber","v":{"$error":"#N/A"}}]
[null,"@TransmissionTimestamp",{"$f":"TEXT(NOW(),FormatOfTimestamp)","v":"2018-12-19T13:35:07"}]
[null,"@BusinessTransmissionCategory",{"$f":"LOOKUP(Trading_Partner,FileProfileList,BusinessTransmissionCategoryList)","v":{"$error":"#N/A"}}]
[null,"@InputSystem",{"$f":"LOOKUP(Trading_Partner,FileProfileList,InputSystemList)","v":{"$error":"#N/A"}}]
[null,"@SequenceNumber","#ID#"]
[null,"@IsEndOfDay",0]
[null,"@TotalAmount",{"$f":"Voucher_Amount","v":0}]
[null,"@TotalCount",1]
[null,"xmlns","urn:us:gov:treas:fms:BusinessTransaction:v4.6.1"]
[null,"xmlns:xsi","http://www.w3.org/2001/XMLSchema-instance"]
[null,"xsi:schemaLocation","urn:us:gov:treas:fms:BusinessTransaction:v4.6.1 Transmission.xsd",">"]
["<Summary","@ID",{"$f":"Source_Voucher_ID","v":0}]
[null,"@SummaryDate",{"$f":"TEXT(RemoveBlanks(Voucher_Date),FormatOfDate)","v":{"$error":"#NAME?"}}]
[null,"@SummaryNumber",{"$f":"TEXT(Voucher_Number,\"000000\")","v":"000000"}]
[null,"@SummaryType",{"$f":"\"Voucher\"","v":"Voucher"}]
[null,"@TotalAmount",{"$f":"Voucher_Amount","v":0}]
[null,"@TotalCount",0]
[null,"@DepositDate",{"$f":"TEXT(RemoveBlanks(Deposit_Date),FormatOfDate)","v":{"$error":"#NAME?"}}]
[null,"@IsCredit",{"$f":"Is_Credit","v":""}]
[null,"@SourceSubProgramText",{"$f":"RemoveBlanks(Source_Subprogram)","v":{"$error":"#NAME?"}}]
[null,"@SourceProcessingProgramText",{"$f":"RemoveBlanks(Source_Processing_Program)","v":{"$error":"#NAME?"}}]
[null,"@ReportingSubProgramText",{"$f":"IF(AND(TradingPartnerIsPayGovDigitalWallet,RemoveBlanks(Reporting_Program_Subprogram)=\"Pay.gov\"),\"\",RemoveBlanks(Reporting_Program_Subprogram))","v":{"$error":"#NAME?"}}]
[null,"@AgencyAccountIdentifier",{"$f":"RemoveBlanks(Agency_Account_ID)","v":{"$error":"#NAME?"}}]
[null,"@InitialLocation",{"$f":"RemoveBlanks(Initial_Location)","v":{"$error":"#NAME?"}}]
[null,"@FinancialAgentInitialIdentifier",{"$f":"RemoveBlanks(Financial_Agent_Initial_ID)","v":{"$error":"#NAME?"}}]
[null,"@InitiationDate",{"$f":"TEXT(RemoveBlanks(Initiation_Date),FormatOfDate)","v":{"$error":"#NAME?"}}]
[null,"@ChannelReceiptDate",{"$f":"TEXT(RemoveBlanks(Channel_Receipt_Date),FormatOfDate)","v":{"$error":"#NAME?"}}]
[null,"@ConfirmedDate",{"$f":"TEXT(RemoveBlanks(Confirmed_Date),FormatOfDate)","v":{"$error":"#NAME?"}}]
[null,"@IsIntragovernmental",{"$f":"IF(Is_Intragovernmental=\"Yes\",1,IF(Is_Intragovernmental=\"No\",0,\"\"))","v":""}]
[null,"@IsChannelElectronic",{"$f":"LOOKUP(Trading_Partner,FileProfileList,IsChannelElectronicList)","v":{"$error":"#N/A"}}]
[null,"@CorrectiveTypeCode",{"$f":"IF(ACR_Indicator=\"Yes\",RemoveBlanks(Corrective_Type_Code),\"\")","v":""}]
[null,"@IsTax",{"$f":"IF(Is_Tax,1,IF(IRS_Tax_Collection=\"Non-Tax\",0,\"\"))","v":""}]
[null,"@AgentTraceIdentifier",{"$f":"RemoveBlanks(Trace_ID)","v":{"$error":"#NAME?"}}]
[null,"@SettlementMechanism",{"$f":"RemoveBlanks(Settlement_Mechanism)","v":{"$error":"#NAME?"}}]
[null,"@ReceiptMechanismCode",{"$f":"IF(TradingPartnerIsCAS,\"\",RemoveBlanks(Settlement_Mechanism))","v":{"$error":"#NAME?"}}]
[null,"@ChannelType",{"$f":"RemoveBlanks(Channel_Type)","v":{"$error":"#NAME?"}}]
[null,"@ReasonText",{"$f":"IF(ACR_Indicator=\"Yes\",RemoveBlanks(Reason_Text),\"\")","v":""}]
[null,"@ReasonCode",{"$f":"IF(ACR_Indicator=\"Yes\",RemoveBlanks(Reason_Code),\"\")","v":""}]
[null,"@VoucherFormCode",{"$f":"RemoveBlanks(Voucher_Type)","v":{"$error":"#NAME?"}}]
[null,"@TaxBreakdownCount",{"$f":"IF(OR(TradingPartnerIsCAS,TradingPartnerIsCreditGatewayACH,TradingPartnerIsCreditGatewayFedwire),0,IF(AND([0]!Is_Tax,OR(TradingPartnerIsOTCNetTGA,TradingPartnerIsEFTPSACH,TradingPartnerIsEFTPSAGYTX,TradingPartnerIsEFTPSWIRE)),COUNTIF('CIR Voucher Form'!$C52:$C59,\"<>0\"),\"\"))","v":""}]
[null,"@SummarizedDetailCount",{"$f":"IF(ISBLANK(Summarized_Detail_Count),0,Summarized_Detail_Count)","v":0}]
[null,"@IsNonDomestic",{"$f":"IF(Is_Non_Domestic=\"Yes\",1,IF(Is_Non_Domestic=\"No\",0,\"\"))","v":""},">"]
[{"$f":"IF(ShowAccountClassificationElement,\"<AccountClassification\",\"\")","v":"<AccountClassification"},"@ID",{"$f":"IF(ShowAccountClassificationElement,1,\"\")","v":1}]
[null,"@IsCredit",{"$f":"IF(ShowAccountClassificationElement,Is_Credit,\"\")","v":""},{"$f":"IF(ShowAccountClassificationElement,\">\",\"\")","v":">"}]
[{"$f":"IF(ShowTreasuryAccountSymbolElement,\"<TreasuryAccountSymbol\",\"\")","v":""},"@AgencyIdentifier",{"$f":"IF(ShowTreasuryAccountSymbolElement,RemoveBlanks(Agency_ID),\"\")","v":""}]
[null,"@AllocationTransferAgencyIdentifier",{"$f":"IF(ShowTreasuryAccountSymbolElement,RemoveBlanks(Allocation_Transfer_ID),\"\")","v":""}]
[null,"@AvailabilityTypeCode",{"$f":"IF(ShowTreasuryAccountSymbolElement,RemoveBlanks(Availability_Type_Code),\"\")","v":""}]
[null,"@BeginningPeriodOfAvailability",{"$f":"IF(ShowTreasuryAccountSymbolElement,RemoveBlanks(Beginning_Period_Of_Availability),\"\")","v":""}]
[null,"@EndingPeriodOfAvailability",{"$f":"IF(ShowTreasuryAccountSymbolElement,RemoveBlanks(Ending_Period_Of_Availability),\"\")","v":""}]
[null,"@MainAccountCode",{"$f":"IF(ShowTreasuryAccountSymbolElement,RemoveBlanks(Main_Account_Code),\"\")","v":""}]
[null,"@Sub-accountCode",{"$f":"IF(ShowTreasuryAccountSymbolElement,RemoveBlanks(Sub_Account_Code),\"\")","v":""}]
[null,"@Sub-levelPrefixCode",{"$f":"IF(ShowTreasuryAccountSymbolElement,RemoveBlanks(Sub_Level_Prefix_Code),\"\")","v":""},{"$f":"IF(ShowTreasuryAccountSymbolElement,\"/>\",\"\")","v":""}]
[{"$f":"IF(ShowBusinessEventTypeElement,\"<BusinessEventType\",\"\")","v":""},"@BusinessEventTypeCode",{"$f":"UPPER(IF(ShowBusinessEventTypeElement,RemoveBlanks(Business_Event_Type_Code),\"\"))","v":""},{"$f":"IF(ShowBusinessEventTypeElement,\"/>\",\"\")","v":""}]
[{"$f":"IF(ShowCkeyElement,\"<Ckey\",\"\")","v":""},"@ClassName",{"$f":"IF(ShowCkeyElement,RemoveBlanks(Classification_Name),\"\")","v":""}]
[null,"@ClassValue",{"$f":"IF(ShowCkeyElement,RemoveBlanks(Classification_Value),\"\")","v":""},{"$f":"IF(ShowCkeyElement,\"/>\",\"\")","v":""}]
[{"$f":"IF(ShowAccountClassificationElement,\"<Classification\",\"\")","v":"<Classification"},"@Amount",{"$f":"IF(Classification<>\"Unknown\",RemoveBlanks(Classification_Amount),\"\")","v":{"$error":"#NAME?"}},{"$f":"IF(ShowAccountClassificationElement,\"/>\",\"\")","v":"/>"}]
[{"$f":"IF(ShowAccountClassificationElement,\"</AccountClassification>\",\"\")&\"<Agency\"","v":"</AccountClassification><Agency"},"@AgencyLocationCode",{"$f":"TEXT(RemoveBlanks(ALC),\"00000000\")","v":{"$error":"#NAME?"}}]
[null,"@OfficeLocationCode",{"$f":"IF(TradingPartnerIsOTCNetTGA,RemoveBlanks(Initial_Location),IF(TradingPartnerIsPayGovDigitalWallet,RemoveBlanks(Cash_Flow_ID),\"\"))","v":""},">"]
[{"$f":"IF(ShowCashFlowReferenceElement,\"<CashFlowReference\",\"\")","v":""},"@ProgramCashFlowName",{"$f":"RemoveBlanks(Cash_Flow_Name)","v":{"$error":"#NAME?"}}]
[null,"@ProgramCashFlowIdentifier",{"$f":"RemoveBlanks(Cash_Flow_ID)","v":{"$error":"#NAME?"}},{"$f":"IF(ShowCashFlowReferenceElement,\"/>\",\"\")&\"</Agency>\"","v":"</Agency>"}]
["<BankDetail><GovernmentDepositAccount","@FRB_DistrictCode",{"$f":"RemoveBlanks(FRB_District_Code)","v":{"$error":"#NAME?"}}]
[null,"@FRB_OfficeCode",{"$f":"RemoveBlanks(FRB_Office_Code)","v":{"$error":"#NAME?"}}]
[null,"@FRB_AccountKeyCode",{"$f":"RemoveBlanks(FRB_Account_Key_Code)","v":{"$error":"#NAME?"}}]
[null,"@CustomerAccountsReceivableSystemNumber",{"$f":"TEXT(RemoveBlanks(CAN),\"000000\")","v":{"$error":"#NAME?"}}]
[null,"@CostCenterWorkUnitCode",{"$f":"RemoveBlanks(Cost_Center_Work_Unit_Code)","v":{"$error":"#NAME?"}}]
[null,"@IsCommercialBank",{"$f":"IF(OR(TradingPartnerIsCAS,TradingPartnerIsNavyCash,TradingPartnerIsOTCNetTGA,TradingPartnerIsPayGovDigitalWallet),1,0)","v":0},"/>"]
["<AgentBank","@RoutingNumber",{"$f":"TEXT(RemoveBlanks(Routing_Number),\"000000000\")","v":{"$error":"#NAME?"}}]
[null,"@AccountNumber",{"$f":"RemoveBlanks(Bank_Account_Number)","v":{"$error":"#NAME?"}},"/>"]
[{"$f":"IF(ShowTreasuryAccountDetailElement,\"<TreasuryAccountDetail\",\"\")","v":""},"@RoutingNumber",{"$f":"TEXT(RemoveBlanks(Treasury_Routing_Number),\"000000000\")","v":{"$error":"#NAME?"}},{"$f":"IF(ShowTreasuryAccountDetailElement,\"/>\",\"\")","v":""}]
[{"$f":"IF(ShowDepositaryDetailElement,\"<DepositaryDetail\",\"\")","v":""},"@RoutingNumber",{"$f":"TEXT(RemoveBlanks(Depositary_Detail_Routing_Number),\"000000000\")","v":{"$error":"#NAME?"}}]
[null,"@TransferMechanismCode",{"$f":"RemoveBlanks(Transfer_Mechanism_Code)","v":{"$error":"#NAME?"}},{"$f":"IF(ShowDepositaryDetailElement,\"/>\",\"\")&\"</BankDetail>\"","v":"</BankDetail>"}]
[{"$f":"IF(ShowFinancialReportingDetailElement,\"<FinancialReportingDetail\",\"\")","v":""},"@FinancialInstitutionText",{"$f":"RemoveBlanks(Financial_Institution_Text)","v":{"$error":"#NAME?"}}]
[null,"@AgencyCommentText",{"$f":"RemoveBlanks(Agency_Comment_Text)","v":{"$error":"#NAME?"}}]
[null,"@FundsAvailableDate",{"$f":"TEXT(RemoveBlanks(Funds_Available_Date),FormatOfDate)","v":{"$error":"#NAME?"}}]
[null,"@ReceiptsFromDate",{"$f":"TEXT(RemoveBlanks(Receipts_From_Date),FormatOfDate)","v":{"$error":"#NAME?"}}]
[null,"@ReceiptsToDate",{"$f":"TEXT(RemoveBlanks(Receipts_To_Date),FormatOfDate)","v":{"$error":"#NAME?"}},{"$f":"IF(ShowFinancialReportingDetailElement,\">\",\"\")","v":""}]
[{"$f":"IF(ShowOriginalSummaryReferenceElement,\"<OriginalSummaryReference\",\"\")","v":""},"@SummaryDate",{"$f":"IF(ACR_Indicator=\"Yes\",TEXT(RemoveBlanks(Original_Voucher_Date),FormatOfDate),\"\")","v":""}]
[null,"@SummaryNumber",{"$f":"IF(ACR_Indicator=\"Yes\",TEXT(RemoveBlanks(Original_Voucher_Number),\"000000\"),\"\")","v":""}]
[null,"@DepositDate",{"$f":"IF(ACR_Indicator=\"Yes\",TEXT(RemoveBlanks(Original_Deposit_Date),FormatOfDate),\"\")","v":""},{"$f":"IF(ShowOriginalSummaryReferenceElement,\"/>\",\"\")","v":""}]
[{"$f":"IF(ShowTreasurySecuritiesInputDetailElement,\"<TreasurySecuritiesInputDetail\",\"\")","v":""},"@FinancialReportingEntityCode",{"$f":"RemoveBlanks(PARS_Code)","v":{"$error":"#NAME?"}},{"$f":"IF(ShowTreasurySecuritiesInputDetailElement,\"/>\",\"\")","v":""}]
[{"$f":"IF(ShowAccountableDetailElement,\"<AccountableDetail\",\"\")","v":""},"@BusinessTransmissionCategory",{"$f":"IF(ShowAccountableDetailElement,LOOKUP(Trading_Partner,FileProfileList,BusinessTransmissionCategoryDetailList),\"\")","v":""},{"$f":"IF(ShowAccountableDetailElement,\"/>\",\"\")&IF(ShowFinancialReportingDetailElement,\"</FinancialReportingDetail>\",\"\")","v":""}]
[{"$f":"IF(AND(Is_Tax,Tax_Amount_1<>0),\"<TaxBreakdown\",\"\")","v":""},"@ChannelType",{"$f":"IF(AND(Is_Tax,Tax_Amount_1>0,OR(TradingPartnerIsOTCNetTGA,TradingPartnerIsEFTPSACH,TradingPartnerIsEFTPSAGYTX,TradingPartnerIsEFTPSWIRE)),ChannelType,\"\")","v":""}]
[null,"@Amount",{"$f":"IF(AND(Is_Tax,Tax_Amount_1>0),Tax_Amount_1,\"\")","v":""}]
[null,"@IsCredit",{"$f":"IF(AND(Is_Tax,Tax_Amount_1>0),Is_Credit,\"\")","v":""},{"$f":"IF(AND(Is_Tax,Tax_Amount_1<>0),\" FMS_TaxClassCode='1' />\",\"\")","v":""}]
[{"$f":"IF(AND(Is_Tax,Tax_Amount_2<>0),\"<TaxBreakdown\",\"\")","v":""},"@ChannelType",{"$f":"IF(AND(Is_Tax,Tax_Amount_2>0,OR(TradingPartnerIsOTCNetTGA,TradingPartnerIsEFTPSACH,TradingPartnerIsEFTPSAGYTX,TradingPartnerIsEFTPSWIRE)),ChannelType,\"\")","v":""}]
[null,"@Amount",{"$f":"IF(AND(Is_Tax,Tax_Amount_2>0),Tax_Amount_2,\"\")","v":""}]
[null,"@IsCredit",{"$f":"IF(AND(Is_Tax,Tax_Amount_2>0),Is_Credit,\"\")","v":""},{"$f":"IF(AND(Is_Tax,Tax_Amount_2<>0),\" FMS_TaxClassCode='2' />\",\"\")","v":""}]
[{"$f":"IF(AND(Is_Tax,Tax_Amount_3<>0),\"<TaxBreakdown\",\"\")","v":""},"@ChannelType",{"$f":"IF(AND(Is_Tax,Tax_Amount_3>0,OR(TradingPartnerIsOTCNetTGA,TradingPartnerIsEFTPSACH,TradingPartnerIsEFTPSAGYTX,TradingPartnerIsEFTPSWIRE)),ChannelType,\"\")","v":""}]
[null,"@Amount",{"$f":"IF(AND(Is_Tax,Tax_Amount_3>0),Tax_Amount_3,\"\")","v":""}]
[null,"@IsCredit",{"$f":"IF(AND(Is_Tax,Tax_Amount_3>0),Is_Credit,\"\")","v":""},{"$f":"IF(AND(Is_Tax,Tax_Amount_3<>0),\" FMS_TaxClassCode='3' />\",\"\")","v":""}]
[{"$f":"IF(AND(Is_Tax,Tax_Amount_4<>0),\"<TaxBreakdown\",\"\")","v":""},"@ChannelType",{"$f":"IF(AND(Is_Tax,Tax_Amount_4>0,OR(TradingPartnerIsOTCNetTGA,TradingPartnerIsEFTPSACH,TradingPartnerIsEFTPSAGYTX,TradingPartnerIsEFTPSWIRE)),ChannelType,\"\")","v":""}]
[null,"@Amount",{"$f":"IF(AND(Is_Tax,Tax_Amount_4>0),Tax_Amount_4,\"\")","v":""}]
[null,"@IsCredit",{"$f":"IF(AND(Is_Tax,Tax_Amount_4>0),Is_Credit,\"\")","v":""},{"$f":"IF(AND(Is_Tax,Tax_Amount_4<>0),\" FMS_TaxClassCode='4' />\",\"\")","v":""}]
[{"$f":"IF(AND(Is_Tax,Tax_Amount_5<>0),\"<TaxBreakdown\",\"\")","v":""},"@ChannelType",{"$f":"IF(AND(Is_Tax,Tax_Amount_5>0,OR(TradingPartnerIsOTCNetTGA,TradingPartnerIsEFTPSACH,TradingPartnerIsEFTPSAGYTX,TradingPartnerIsEFTPSWIRE)),ChannelType,\"\")","v":""}]
[null,"@Amount",{"$f":"IF(AND(Is_Tax,Tax_Amount_5>0),Tax_Amount_5,\"\")","v":""}]
[null,"@IsCredit",{"$f":"IF(AND(Is_Tax,Tax_Amount_5>0),Is_Credit,\"\")","v":""},{"$f":"IF(AND(Is_Tax,Tax_Amount_5<>0),\" FMS_TaxClassCode='5' />\",\"\")","v":""}]
[{"$f":"IF(AND(Is_Tax,Tax_Amount_7<>0),\"<TaxBreakdown\",\"\")","v":""},"@ChannelType",{"$f":"IF(AND(Is_Tax,Tax_Amount_7>0,OR(TradingPartnerIsOTCNetTGA,TradingPartnerIsEFTPSACH,TradingPartnerIsEFTPSAGYTX,TradingPartnerIsEFTPSWIRE)),ChannelType,\"\")","v":""}]
[null,"@Amount",{"$f":"IF(AND(Is_Tax,Tax_Amount_7>0),Tax_Amount_7,\"\")","v":""}]
[null,"@IsCredit",{"$f":"IF(AND(Is_Tax,Tax_Amount_7>0),Is_Credit,\"\")","v":""},{"$f":"IF(AND(Is_Tax,Tax_Amount_7<>0),\" FMS_TaxClassCode='7' />\",\"\")","v":""}]
[{"$f":"IF(AND(Is_Tax,Tax_Amount_8<>0),\"<TaxBreakdown\",\"\")","v":""},"@ChannelType",{"$f":"IF(AND(Is_Tax,Tax_Amount_8>0,OR(TradingPartnerIsOTCNetTGA,TradingPartnerIsEFTPSACH,TradingPartnerIsEFTPSAGYTX,TradingPartnerIsEFTPSWIRE)),ChannelType,\"\")","v":""}]
[null,"@Amount",{"$f":"IF(AND(Is_Tax,Tax_Amount_8>0),Tax_Amount_8,\"\")","v":""}]
[null,"@IsCredit",{"$f":"IF(AND(Is_Tax,Tax_Amount_8>0),Is_Credit,\"\")","v":""},{"$f":"IF(AND(Is_Tax,Tax_Amount_8<>0),\" FMS_TaxClassCode='8' />\",\"\")","v":""}]
[{"$f":"IF(AND(Is_Tax,Tax_Amount_9<>0),\"<TaxBreakdown\",\"\")","v":""},"@ChannelType",{"$f":"IF(AND(Is_Tax,Tax_Amount_9>0,OR(TradingPartnerIsOTCNetTGA,TradingPartnerIsEFTPSACH,TradingPartnerIsEFTPSAGYTX,TradingPartnerIsEFTPSWIRE)),ChannelType,\"\")","v":""}]
[null,"@Amount",{"$f":"IF(AND(Is_Tax,Tax_Amount_9>0),Tax_Amount_9,\"\")","v":""}]
[null,"@IsCredit",{"$f":"IF(AND(Is_Tax,Tax_Amount_9>0),Is_Credit,\"\")","v":""},{"$f":"IF(AND(Is_Tax,Tax_Amount_9<>0),\" FMS_TaxClassCode='9' />\",\"\")","v":""}]
[{"$f":"IF(ShowProgramDataElement,\"<TradingPartnerExtensions><TradingPartnerExtension><TRS_TradingPartner_Agreement><Program_Data\",\"\")","v":""},"@ID",{"$f":"RemoveBlanks(Program_Data_ID)","v":{"$error":"#NAME?"}}]
[null,"@Description",{"$f":"RemoveBlanks(Program_Data_Description)","v":{"$error":"#NAME?"}}]
[null,"@UserDataCount",{"$f":"IF(ShowUserDataContentElement,\"1\",\"\")","v":""},{"$f":"IF(ShowProgramDataElement,\">\",\"\")","v":""}]
[{"$f":"IF(ShowUserDataElement,\"<UserData\",\"\")","v":""},"@CustomFieldID",{"$f":"RemoveBlanks(Custom_Field_ID)","v":{"$error":"#NAME?"}}]
[null,"@AgencyLabel",{"$f":"RemoveBlanks(Agency_Label)","v":{"$error":"#NAME?"}}]
[null,"@HasPrivacyData",{"$f":"IF(Has_Privacy_Data=\"Contains PII Data\",\"1\",IF(Has_Privacy_Data=\"Does not contain PII Data\",\"0\",\"\"))","v":""},{"$f":"IF(ShowUserDataElement,\">\",\"\")","v":""}]
[{"$f":"IF(ShowUserDataContentElement,\"<![CDATA[\",\"\")","v":""},null,{"$f":"RemoveBlanks(User_Data_Content)","v":{"$error":"#NAME?"}},{"$f":"IF(ShowUserDataContentElement,\"]]>\",\"\")&IF(ShowUserDataElement,\"</UserData>\",\"\")&IF(ShowProgramDataElement,\"</Program_Data></TRS_TradingPartner_Agreement></TradingPartnerExtension></TradingPartnerExtensions>\",\"\")&\"</Summary></Transmission>\"","v":"</Summary></Transmission>"}]

{"sheet":"Created Data","index":4,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Created By:"]
["Created On:"]
["Version:",{"$f":"WorkbookVersion","v":"1.0.0"}]

{"sheet":"Trading Partner Reference Data","index":5,"n_rows":46,"n_cols":28,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["File Profile","Base File",null,"Business Transmission Category",null,"Business Transmission Category (Detail)",null,"Input System",null,"Source Processing Program",null,"Source Subprogram",null,"Reporting Program / Subprogram",null,"Is Channel Electronic",null,"Settlement Mechanism",null,"Channel Type",null,"Voucher Form Code",null,"Transfer Mechanism Code",null,"Is Intragovernmental?",null,"Is Non Domestic"]
["CAS","CASGUI",null,"Collections",null,"Collections",null,"CAS",null,"SourceProcessingProgramListCAS",null,"SourceSubprogramListCAS",null,"ReportingProgramSubprogramListCAS",null,{"$f":"\"1\"","v":"1"},null,"SettlementMechanismListCAS",null,"ChannelTypeListCAS",null,"VoucherFormCodeListCAS",null,"TransferMechanismCodeListCAS",null,"IsIntragovernmentalListCAS",null,"IsNonDomesticListCAS"]
["Credit Gateway (ACH)","CGACHOLBP",null,"Collections",null,"Collections",null,"CGACH",null,"SourceProcessingProgramListCGACH",null,"SourceSubprogramListCGACH",null,"ReportingProgramSubprogramListCGACH",null,"1",null,"SettlementMechanismListCGACH",null,"ChannelTypeListCGACH",null,"VoucherFormCodeListCGACH",null,"TransferMechanismCodeListCGACH",null,"IsIntragovernmentalListCGACH",null,"IsNonDomesticListCGACH"]
["Credit Gateway (Fedwire)","CGFWGUI",null,"Collections",null,"Collections",null,"CGFEDWIRE",null,"SourceProcessingProgramListCGFedwire",null,"SourceSubprogramListCGFedwire",null,"ReportingProgramSubprogramListCGFedwire",null,"1",null,"SettlementMechanismListCGFedwire",null,"ChannelTypeListCGFedwire",null,"VoucherFormCodeListCGFedwire",null,"TransferMechanismCodeListCGFedwire",null,"IsIntragovernmentalListCGFedwire",null,"IsNonDomesticListCGFedwire"]
["EFTPS (ACH)","EFTPSACHGUI",null,"Collections",null,"Collections",null,"EFTPS",null,"SourceProcessingProgramListEFTPSACH",null,"SourceSubprogramListEFTPSACH",null,"ReportingProgramSubprogramListEFTPSACH",null,"1",null,"SettlementMechanismListEFTPSACH",null,"ChannelTypeListEFTPSACH",null,"VoucherFormCodeListEFTPSACH",null,"TransferMechanismCodeListEFTPSACH",null,"IsIntragovernmentalListEFTPSACH",null,"IsNonDomesticListEFTPSACH"]
["EFTPS (AGYTX)","AGYTXGUI",null,"Collections",null,"Intragovernmental",null,"EFTPSAGYTAX",null,"SourceProcessingProgramListEFTPSAGYTX",null,"SourceSubprogramListEFTPSAGYTX",null,"ReportingProgramSubprogramListEFTPSAGYTX",null,"1",null,"SettlementMechanismListEFTPSAGYTX",null,"ChannelTypeListEFTPSAGYTX",null,"VoucherFormCodeListEFTPSAGYTX",null,"TransferMechanismCodeListEFTPSAGYTX",null,"IsIntragovernmentalListEFTPSAGYTX",null,"IsNonDomesticListEFTPSAGYTX"]
["EFTPS (WIRE)","EFTPSWIREGUI",null,"Collections",null,"Collections",null,"EFTPS",null,"SourceProcessingProgramListEFTPSWIRE",null,"SourceSubprogramListEFTPSWIRE",null,"ReportingProgramSubprogramListEFTPSWIRE",null,"1",null,"SettlementMechanismListEFTPSWIRE",null,"ChannelTypeListEFTPSWIRE",null,"VoucherFormCodeListEFTPSWIRE",null,"TransferMechanismCodeListEFTPSWIRE",null,"IsIntragovernmentalListEFTPSWIRE",null,"IsNonDomesticListEFTPSWIRE"]
["Navy Cash","FRBNAVYCASHGUI",null,"Payments",null,"Payments",null,"NAVYCASH",null,"SourceProcessingProgramListNavyCash",null,"SourceSubprogramListNavyCash",null,"ReportingProgramSubprogramListNavyCash",null,"1",null,"SettlementMechanismListNavyCash",null,"ChannelTypeListNavyCash",null,"VoucherFormCodeListNavyCash",null,"TransferMechanismCodeListNavyCash",null,"IsIntragovernmentalListNavyCash",null,"IsNonDomesticListNavyCash"]
["OTC-Net TGA","OTCNETTGAGUI",null,"Collections",null,"Collections",null,"OTCNET-TGA",null,"SourceProcessingProgramListOTCNet",null,"SourceSubprogramListOTCNet",null,"ReportingProgramSubprogramListOTCNet",null,{"$f":"\"0\"","v":"0"},null,"SettlementMechanismListOTCNet",null,"ChannelTypeListOTCNet",null,"VoucherFormCodeListOTCNet",null,"TransferMechanismCodeListOTCNet",null,"IsIntragovernmentalListOTCNet",null,"IsNonDomesticListOTCNet"]
["Pay.gov (Digital Wallet)","PAYGOVCCGUI",null,"Collections",null,"Collections",null,"PAYGOV",null,"SourceProcessingProgramListPayGov",null,"SourceSubprogramListPayGov",null,"ReportingProgramSubprogramListPayGov",null,{"$f":"\"1\"","v":"1"},null,"SettlementMechanismListPayGov",null,"ChannelTypeListPayGov",null,"VoucherFormCodeListPayGov",null,"TransferMechanismCodeListPayGov",null,"IsIntragovernmentalListPayGov",null,"IsNonDomesticListPayGov"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Card Acquiring Service|",null,null,null,"Card",null,"OTC",null,"215 (Credit)",null,"ACH",null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5515 (Debit)",null,"Book Entry",null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,"ACH",null,"Pay.gov ACH Credit",null,"ACH",null,null,null,"ACH",null,"Bank",null,null,null,"Card",null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"OLBP",null,null,null,null,null,null,null,null,null,"215 (Credit)",null,"Cash",null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,"Fedwire",null,null,null,"Fedwire",null,null,null,"Wire",null,"Bank",null,"5515 (Debit)",null,"Cash/Und Check",null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bulk Provider",null,null,null,"ACH",null,"Internet",null,"215 (Credit)",null,"IAS",null,"Yes",null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DDIA",null,null,null,null,null,"Bank",null,"5515 (Debit)",null,"NSS",null,"No",null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"eFile",null,null,null,"Book Entry",null,"Phone",null,null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"215 (Credit)",null,"SVC",null,"Yes",null,"Yes"]
[null,null,null,null,null,null,null,null,null,"Credit Gateway",null,null,null,"Federal Agency Taxes",null,null,null,"Wire",null,"Internet",null,"215A (Credit)",null,"Wire",null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"Wire",null,null,null,null,null,null,null,null,null,"5515 (Debit)",null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,"SVC",null,null,null,"Bulk/Wire",null,null,null,"SVC",null,"Internet",null,null,null,null,null,"No",null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"Navy Cash",null,"Single Taxpayer/Wire",null,null,null,null,null,"Bank",null,"215 (Credit)"]
[null,null,null,null,null,null,null,null,null,"TGA Networks",null,null,null,null,null,null,null,"Cash",null,"Phone",null,"215A (Credit)",null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,"TGA",null,"Navy Cash",null,null,null,"Cash/Und Check",null,null,null,"5515 (Debit)",null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,"E-Commerce",null,null,null,null,null,null,null,"Check",null,"OTC",null,null,null,"NSS"]
[null,null,null,null,null,null,null,null,null,"Mobile",null,"Card Present",null,"Bank Deposit",null,null,null,null,null,null,null,"215 (Credit)",null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,"PayPal",null,null,null,null,null,"Card",null,"OTC",null,"215A (Credit)",null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,"SDK",null,"Pay.gov",null,null,null,"Other",null,null,null,"5515 (Debit)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Adapter",null,null,null,null,null,"Internet",null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AmazonResolutionCenter",null,null,null,null,null,null,null,"215 (Credit)",null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Billing Agreement",null,null,null,null,null,null,null,"5515 (Debit)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Collection Control Panel",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DwollaResolutionCenter",null,null,null,null,null,null,null,"215 (Credit)",null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hosted Bill (web)",null,null,null,null,null,null,null,"5515 (Debit)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hosted Form (web)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OCI-I",null,null,null,null,null,null,null,"215 (Credit)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OCI-NIB",null,null,null,null,null,null,null,"5515 (Debit)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OCI-NIS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OCI-Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PayPalResolutionCenter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TCS Batch"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TCS Online"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TCS Single"]

{"sheet":"Option Choices","index":6,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Blank List",null,"Yes/No Choice",null,"A/C/R Type",null,"Adjustment Reason Code",null,"Correction Reason Code",null,"Rescind Reason Code",null,"Other Reason Code",null,"Is Tax?",null,"Has Privacy Data",null,"District Code",null,"Classification",null,"Availability Type Code"]
[null,null,"Yes",null,"Additional",null,"ENC - Encoding Exception",null,"Missing Information",null,"Duplicate",null,"Other",null,"Non-Tax",null,"Contains PII Data",null,"01",null,"C-Key",null,"A"]
[null,null,"No",null,"Adjustment",null,"Return Item",null,"Incorrect Data/Reporting Exception",null,"Erroneous Submission",null,null,null,"Tax",null,"Does not contain PII Data",null,"02",null,"TAS/BETC",null,"F"]
[null,null,null,null,"Correction",null,"Amount Exception",null,"Other",null,"Other",null,null,null,null,null,null,null,"03",null,"Unknown",null,"M"]
[null,null,null,null,"Rescind",null,"Other",null,null,null,null,null,null,null,null,null,null,null,"04",null,null,null,"X"]
[null,null,null,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,"05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12"]