{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RunQuery","QueryResults","Loader"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"RunQuery","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[[26,0,26,1],[14,0,14,1],[0,0,0,1],[4,0,4,1],[11,0,11,1],[13,0,13,1],[6,0,6,1],[32,0,32,1],[15,0,15,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[27,0,27,1],[16,0,16,1],[17,0,17,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1]]}
["2024 1042v2.0 BusRules"]
["Query URL:","https://clm.jrs.hq.irs.gov:9443/rs/query/69518/dataservice?limit=-1&report=69535&basicAuthenticationEnabled=true"]
["Description:",""]
[]
["See the QueryResults sheet for the initial query results.\n"]
[]
["To refresh the results of the query:"]
[]
["Step 1:","If there is a protected view warning in the command bar, click Enable Editing. To fix a subsequent security warning about disabled macros, click Enable Content."]
[]
["Step 2:","The first time that you open this workbook, create a data source for the live query.\n\n\n\n"]
[]
["Step 3:","See updated results on the QueryResults sheet.\n\n\n\nYou can also click Data > Refresh All in any sheet of the workbook."]
[]
[]
[]
[]
["What else can I do with this data?"]
[]
["• Create a pivot table or chart."]
[]
["• Add this query to an existing workbook by using the query URL at the top \n  of this sheet."]
[]
["Note:"]
["• Do not delete 'Loader' sheet. It is required to refresh the results of the query."]

{"sheet":"QueryResults","index":1,"n_rows":126,"n_cols":5,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
["Rule Number","Rule Text","Error Category","Severity","Rule Status"]
["F1042-001","If Form 1042, [ 'SupersededReturnInd' or 'AmendedReturnInd' ] is checked, then [ReasonableCauseStatement] must be present in the return.","Missing Document","Reject","Active"]
["F1042-002","If Form 1042, 'TotalGrossReportedAmt' has a value greater than zero, then at least one of the following must have a value greater than zero: 'TotChap4USSrceFDAPIncmWthldAmt' or 'Chap4NoWHRqdRcpntIncmPdAmt' or 'ExcludedNonfinancialPymtAmt' or 'GrandfatheredObligIncmPdAmt' or 'USBusinessOrTradeECIAmt'.","Missing Data","Reject","Active"]
["F1042-003","If Form 1042, 'TotalNetTaxLiabilityAmt' is greater than 'TotalPaymentsAmt', then 'BalanceDueAmt' must be equal to [ 'TotalNetTaxLiabilityAmt' minus (-) 'TotalPaymentsAmt' ].","Math Error","Reject","Active"]
["F1042-004","If Form 1042, 'TotalPaymentsAmt' is greater than 'TotalNetTaxLiabilityAmt', then [ 'TotalPaymentsAmt' minus (-) 'TotalNetTaxLiabilityAmt' ] must be equal to [ 'USSrceIncmOverWHOvpmtAmt' plus (+) 'FedPrcmntPymtExciseTaxOvpmtAmt' ].","Math Error","Reject","Active"]
["F1042-005","If Form 1042, [ 'TotalUSSourceFDAPIncmAmt' or 'TotalUSSrceSubstDivPymtRptAmt' or 'TotUSSrceSubstPymtRptNonDivAmt' ] has a value greater than zero, then their sum must be equal to 'TotalGrossReportedAmt'.","Math Error","Reject","Active"]
["F1042-006","If Form 1042, [ 'WithholdingAgentTaxWthldAmt' or 'SubstDivOtherPymtAmt' or 'SubstituteDivWthldTaxAmt' or 'OverwithholdingAdjAmt' or 'UnderwithholdingAdjAmt' or 'WithholdingAgentTaxPaidAmt' ] has a non-zero value, then 'TotalTaxWithheldOrPaidAmt' must be equal to the sum of the following: [ 'WithholdingAgentTaxWthldAmt' and 'SubstDivOtherPymtAmt' and 'SubstituteDivWthldTaxAmt' and 'UnderwithholdingAdjAmt' and 'WithholdingAgentTaxPaidAmt' ] minus (-) 'OverwithholdingAdjAmt'.","Math Error","Reject","Active"]
["F1042-007","If Form 1042, [ 'TotalNetTaxLiabilityAdjAmt' or 'TotalNetTaxLiabUnderChap3Amt' or 'TotalNetTaxLiabUnderChap4Amt' or 'FedPrcmntPaymentExciseTaxAmt' ] has a value greater than zero, then their sum must be equal to 'TotalNetTaxLiabilityAmt'.","Math Error","Reject","Active"]
["F1042-008","Form 1042, 'TotalPaymentsAmt' must be equal to the sum of the following : [ 'TotalEFTPaidDuringCYAmt' and 'TotalEFTPaidDuringSubsqYrAmt' and 'Form1042OvpmtCreditAmt' and 'OtherNonSubstDivPaymentsCrAmt' and 'SubstDivPaymentsCreditAmt' ].","Math Error","Reject","Active"]
["F1042-009","Form 1042, 'TotUSSrceFDAPNotWthldChap4Amt' must be equal to the sum of the following: [ 'Chap4NoWHRqdRcpntIncmPdAmt' and 'ExcludedNonfinancialPymtAmt' and 'GrandfatheredObligIncmPdAmt' and 'USBusinessOrTradeECIAmt' ].","Math Error","Reject","Active"]
["F1042-010","Form 1042, 'TotUSSrceFDAPChap4IncmAmt' must be equal to 'TotChap4USSrceFDAPIncmWthldAmt' plus (+) 'TotUSSrceFDAPNotWthldChap4Amt'.","Math Error","Reject","Active"]
["F1042-011","If Form 1042, 'TotUSSrceFDAP1042SRptIncmAmt' has a value greater than zero, then it must be equal to 'TotalGrossReportedAmt'.","Incorrect Data","Reject","Active"]
["F1042-012","Form 1042, 'TotalVarianceAmt' must be equal to 'TotUSSrceFDAP1042SRptIncmAmt' minus (-) 'TotUSSrceFDAPChap4IncmAmt'.","Math Error","Reject","Active"]
["F1042-013","If Form 1042, 'FutureFilingNotRequiredInd' is checked, then 'FinalIncomePaidDt' must be before [ 'TaxPeriodEndDt' in the Return Header ].","Incorrect Data","Reject","Deleted"]
["F1042-013-01","If Form 1042, 'FutureFilingNotRequiredInd' is checked, then 'FinalIncomePaidDt' must be before [ 'TaxPeriodEndDt' in the Return Header ].","Incorrect Data","Reject","New"]
["F1042-014","Form 1042, 'JanPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Jan7PeriodEndingTaxLiabAmt' and 'Jan15PeriodEndingTaxLiabAmt' and 'Jan22PeriodEndingTaxLiabAmt' and 'Jan31PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-016","Form 1042, 'FebPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Feb7PeriodEndingTaxLiabAmt' and 'Feb15PeriodEndingTaxLiabAmt' and 'Feb22PeriodEndingTaxLiabAmt' and 'FebLastDayPrdEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-018","Form 1042, 'MarPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Mar7PeriodEndingTaxLiabAmt' and 'Mar15PeriodEndingTaxLiabAmt' and 'Mar22PeriodEndingTaxLiabAmt' and 'Mar31PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-020","Form 1042, 'AprPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Apr7PeriodEndingTaxLiabAmt' and 'Apr15PeriodEndingTaxLiabAmt' and 'Apr22PeriodEndingTaxLiabAmt' and 'Apr30PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-022","Form 1042, 'MayPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'May7PeriodEndingTaxLiabAmt' and 'May15PeriodEndingTaxLiabAmt' and 'May22PeriodEndingTaxLiabAmt' and 'May31PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-024","Form 1042, 'JunPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Jun7PeriodEndingTaxLiabAmt' and 'Jun15PeriodEndingTaxLiabAmt' and 'Jun22PeriodEndingTaxLiabAmt' and 'Jun30PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-026","Form 1042, 'JulPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Jul7PeriodEndingTaxLiabAmt' and 'Jul15PeriodEndingTaxLiabAmt' and 'Jul22PeriodEndingTaxLiabAmt' and 'Jul31PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-028","Form 1042, 'AugPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Aug7PeriodEndingTaxLiabAmt' and 'Aug15PeriodEndingTaxLiabAmt' and 'Aug22PeriodEndingTaxLiabAmt' and 'Aug31PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-030","Form 1042, 'SepPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Sep7PeriodEndingTaxLiabAmt' and 'Sep15PeriodEndingTaxLiabAmt' and 'Sep22PeriodEndingTaxLiabAmt' and 'Sep30PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-032","Form 1042, 'OctPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Oct7PeriodEndingTaxLiabAmt' and 'Oct15PeriodEndingTaxLiabAmt' and 'Oct22PeriodEndingTaxLiabAmt' and 'Oct31PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-034","Form 1042, 'NovPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Nov7PeriodEndingTaxLiabAmt' and 'Nov15PeriodEndingTaxLiabAmt' and 'Nov22PeriodEndingTaxLiabAmt' and 'Nov30PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1042-036","Form 1042, 'DecPeriodEndingTotalAmt' must be equal to the sum of the following: [ 'Dec7PeriodEndingTaxLiabAmt' and 'Dec15PeriodEndingTaxLiabAmt' and 'Dec22PeriodEndingTaxLiabAmt' and 'Dec31PeriodEndingTaxLiabAmt' ].","Math Error","Reject","Active"]
["F1099DIV-001","Form 1099-DIV, 'CalendarYr' must be the same as 'TaxYr' in the ReturnHeader.","Data Mismatch","Reject","Active"]
["F1099G-001","If Form 1099-G, 'RefundCreditOffsetTaxYr' has a value, then it must not be earlier than 'TaxYr' in the Return Header minus 20 years.","Incorrect Data","Reject","Active"]
["F1099G-002","Form 1099-G, 'CalendarYr' must be the same as 'TaxYr' in the ReturnHeader.","Data Mismatch","Reject","Active"]
["F1099INT-001","Form 1099-INT, 'CalendarYr' must be the same as 'TaxYr' in the ReturnHeader.","Data Mismatch","Reject","Active"]
["F1099K-001","Form 1099-K, 'CalendarYr' must be the same as 'TaxYr' in the ReturnHeader.","Data Mismatch","Reject","Active"]
["F1099MISC-001","Form 1099-MISC, 'CalendarYr' must be the same as 'TaxYr' in the ReturnHeader.","Data Mismatch","Reject","Active"]
["F1099NEC-001","Form 1099-NEC, 'CalendarYr' must be the same as 'TaxYr' in the ReturnHeader.","Data Mismatch","Reject","Active"]
["F1099OID-001","Form 1099-OID, 'CalendarYr' must be the same as 'TaxYr' in the ReturnHeader.","Data Mismatch","Reject","Active"]
["F1099PATR-001","Form 1099-PATR, 'CalendarYr' must be the same as 'TaxYr' in the ReturnHeader.","Data Mismatch","Reject","Active"]
["FPYMT-057-03","In IRS Payment Record or IRS ES Payment Record or IRS 965 Payment Record, 'PaymentAmt' must be greater than zero, but less than or equal to $99,999,999.","Incorrect Data","Reject","Active"]
["FPYMT-071-01","RequestedPaymentDt' in the IRS Payment Record must not be more than 5 days prior to the received date.","Incorrect Data","Reject","Active"]
["FPYMT-072-01","If the return is received on or before the due date of the return, then the 'RequestedPaymentDt' in the IRS Payment Record must be on the due date or before the due date.","Incorrect Data","Reject","Active"]
["FPYMT-074-01","If the return is received after the due date of the return, then the 'RequestedPaymentDt' in the IRS Payment Record must not be later than the date the return was received.","Incorrect Data","Reject","Active"]
["R0000-003","The return version (attribute 'returnVersion' of the Return element) must be specified for each return in the return header.","Missing Data","Reject and Stop","Active"]
["R0000-004-01","ReturnTypeCd' (specified in the Return Header) and the return version (specified by the 'returnVersion' attribute of the 'Return' element) of the return must match the return type and the version supported by the Modernized e-File system.","Data Mismatch","Reject and Stop","Active"]
["R0000-007-02","For US Addresses, the first five digits of 'ZipCd' of the Filer's address in the Return Header must be within the valid ranges of zip codes for the corresponding 'StateAbbreviationCd'. See Publication 4164.","Incorrect Data","Reject","Active"]
["R0000-014-01","SSN of the Preparer in the Return Header cannot be all zeros or all nines.","Incorrect Data","Reject","Active"]
["R0000-015-01","If 'PreparerFirmEIN' in the Return Header has a value, then it must not be \"999999999\".","Incorrect Data","Reject","Active"]
["R0000-018-01","The PTIN of the Preparer in the Return Header must not have the value \"P00000000\" or \"P99999999\".","Incorrect Data","Reject","Active"]
["R0000-019","The number of return documents (forms, schedules, and supporting documents) included in the return must be equal to the value of the 'documentCnt' attribute of the ReturnData.","Data Mismatch","Reject","Active"]
["R0000-021","The Employer Identification Number (EIN) of the Filer in the Return Header must not equal all nines.","Incorrect Data","Reject","Active"]
["R0000-023-01","If the Filer has a US address in the Return Header and if the value of City is \"APO\" or \"FPO\", then the value of State must equal \"AA\", \"AE\" or \"AP\".","Incorrect Data","Reject","Active"]
["R0000-029","If the Signature Option \"PIN Number\" is selected (the element \"SignatureOption\" in the Return Header has a value of \"PIN Number\") then the following fields must have a value in the Return Header:  \"PractitionerPIN\", \"TaxpayerPIN\", \"Name\" of the \"Officer\", \"Title\" of the \"Officer\", \"DateSigned\" and \"PINEnteredBy\" Indicator.","Missing Data","Reject","Active"]
["R0000-030-01","If 'PractitionerPINGrp' in the Return Header has a value, then 'EFIN' in 'PractitionerPINGrp' must be the same as 'EFIN' in 'OriginatorGrp'.","Data Mismatch","Reject","Active"]
["R0000-031","Taxpayer PIN in the Return Header cannot equal all zeros.","Incorrect Data","Reject","Active"]
["R0000-034-01","If the Filer has a US address in the Return Header and State Abbreviation has the value \"AA\", \"AE\" or \"AP\" then the City must be \"APO\" OR \"FPO\".","Incorrect Data","Reject","Active"]
["R0000-035-01","The 'TaxPeriodEndDt' in the Return Header must be less than the Received Date.","Incorrect Data","Reject","Active"]
["R0000-044-01","The CUSIP Number cannot equal all zeros.","Incorrect Data","Reject","Active"]
["R0000-046-01","For US Addresses, the fourth and fifth digit of the 'ZipCd' of the Filer's address in the Return Header cannot both be zeros (\"00\"), except when the 'ZipCd' is 00800, 20500, 34000, 00600, 96100, 96900.","Incorrect Data","Reject","Active"]
["R0000-051-01","FederalSubmissionTypeCd' in the IRS Submission Manifest must match 'ReturnTypeCd' indicated in the Return Header.","Data Mismatch","Reject and Stop","Active"]
["R0000-052-01","TaxYr' specified in the IRS Submission Manifest must match 'TaxYr' in the Return Header.","Data Mismatch","Reject and Stop","Active"]
["R0000-054-01","The 'EFIN' in the IRS Submission Manifest must match 'EFIN' in the 'OriginatorGrp' in the Return Header.","Data Mismatch","Reject and Stop","Active"]
["R0000-055-02","If 'SignatureOptionCd' in the Return Header has the value \"Binary Attachment 8453 Signature Document\", then a binary attachment with description \"8453 Signature Document\" must be present in the return.","Missing Document","Reject","Active"]
["R0000-057-01","Every attached file (i.e. binary attachment) must be referenced by the XML document that represents it.","Missing Data","Reject","Active"]
["R0000-058-01","An XML document that represents a binary attachment must have a valid reference to an attached file.","Missing Data","Reject","Active"]
["R0000-060","First six digits in the Submission ID must match the EFIN in the Submission Manifest.","Incorrect Data","Reject and Stop","Active"]
["R0000-067","The attached files (i.e. binary attachments) in a submission zip archive must have distinct names.","Incorrect Data","Reject and Stop","Active"]
["R0000-075-02","RoutingTransitNum' (RTN) must conform to the banking industry RTN algorithm.","Incorrect Data","Reject","Active"]
["R0000-079","The TIN present in the IRS Submission Manifest must match the EIN provided in the Return Header.","Data Mismatch","Reject and Stop","Active"]
["R0000-080-01","TaxPeriodBeginDt' present in the IRS Submission Manifest must match 'TaxPeriodBeginDt' provided in the Return Header.","Data Mismatch","Reject and Stop","Active"]
["R0000-081-01","TaxPeriodEndDt' present in the IRS Submission Manifest must match 'TaxPeriodEndDt' provided in the Return Header.","Data Mismatch","Reject and Stop","Active"]
["R0000-082","TaxPeriodBeginDt' and 'TaxPeriodEndDt' must be provided in the IRS Submission Manifest.","Missing Data","Reject and Stop","Active"]
["R0000-114","The Submission Manifest's 'TaxPeriodBeginDt' value for month and day should be January 1.","Incorrect Data","Reject","Active"]
["R0000-115","The Submission Manifest's 'TaxPeriodEndDt' value for month and day should be December 31.","Incorrect Data","Reject","Active"]
["R0000-118-01","If first two digits of the EFIN in the IRS Submission Manifest are 10, 21, 32, 44 or 53, then 'OriginatorTypeCd' in the Return Header must have the value \"OnlineFiler\".","Incorrect Data","Reject and Stop","Active"]
["R0000-119-01","If 'OriginatorTypeCd' in the Return Header has the value \"OnlineFiler\", then the first two digits of the EFIN in the IRS Submission Manifest must be 10 or 21 or 32 or 44 or 53.","Incorrect Data","Reject and Stop","Active"]
["R0000-120","The IRS Submission type that was filed is not being accepted by Modernized e-File (MeF) at this time.  Please check the MeF web page under irs.gov for more information.  The submission type filed was <type>.","Unsupported","Reject and Stop","Active"]
["R0000-142-01","If you are a paid tax return preparer, you must use a Preparer Tax Identification Number (PTIN) issued by the Internal Revenue Service (IRS) to identify yourself in the paid preparer section of the tax return. In future years, tax returns may be rejected if an SSN, or any number that is not a valid PTIN, is included in this field.","Incorrect Data","Alert","Active"]
["R0000-143","TaxYr' in the IRS Submission Manifest must have a value.","Missing Data","Reject and Stop","Active"]
["R0000-148","EIN' of the Filer in the Return Header must begin with \"00\" for submissions transmitted to the Assurance Testing System (ATS).","Incorrect Data","Reject","Active"]
["R0000-180","TaxYr' specified in the Submission Manifest must equal the year of the schema version ('YYYY' digits of the attribute 'returnVersion' of the Return) that is being used to file the return.","Incorrect Data","Reject and Stop","Active"]
["R0000-192","Phone Number provided in the return must not be all zeros.","Incorrect Data","Reject","Active"]
["R0000-193","Bank Account Number provided in the return must not be all zeros.","Incorrect Data","Reject","Active"]
["R0000-194","Submission must not be a duplicate of a previously accepted submission.","Duplicate Condition","Reject and Stop","Active"]
["R0000-201","The 'TaxPeriodEndDt' in the Return Header must not be prior to the 'TaxPeriodBeginDt'.","Incorrect Data","Reject","Active"]
["R0000-221","The ETIN associated with the Business submission is not a participating transmitter. Please check the Modernized e-File (MeF) web page under irs.gov for more information on participation rules.","Unsupported","Reject and Stop","Active"]
["R0000-222","PersonFirstNm' and 'PersonLastNm' in 'SigningOfficerGrp' in the Return Header must have a value.","Missing Data","Alert","Active"]
["R0000-223","SSN' in 'SigningOfficerGrp' in the Return Header must have a value.","Missing Data","Alert","Active"]
["R0000-225","This submission contains a form or schedule that is not currently supported for electronic filing.","Unsupported","Reject and Stop","Active"]
["R0000-228","TaxYr' must equal the year of the 'TaxPeriodBeginDt' (\"YYYY\" digits) in the Submission Manifest.","Incorrect Data","Reject and Stop","Active"]
["R0000-229","TaxYr' must equal the year of the 'TaxPeriodEndDt' (\"YYYY\" digits) in the Submission Manifest.","Incorrect Data","Reject and Stop","Active"]
["R0000-232","IRSResponsiblePrtyInfoCurrInd' in the Return Header does not have a choice of \"Yes\" indicated. Therefore, (1) 'Form8822BAttachedInd' must be checked in the Return Header and (2) a binary attachment with description containing \"Form 8822-B\" must be present in the return. This return does not satisfy both conditions (1) and (2). IRS regulations require any entity with an EIN to update the Responsible Party information within 60 days of any change by filing Form 8822-B, Change of Address or Responsible Party - Business. For additional information on Form 8822-B, visit the IRS website at: https://www.irs.gov/forms-pubs/about-form-8822-b. It is critical that the IRS have accurate Responsible Party information in cases of identity theft or other fraud issues related to EINs or business accounts. For additional information on Responsible Parties, visit the IRS website at: https://www.irs.gov/businesses/small-businesses-self-employed/responsible-parties-and-nominees.","Missing Document","Alert","Active"]
["R0000-233","EIN' of the Filer in the Return Header must be within the valid range of an EIN.","Incorrect Data","Reject","Active"]
["R0000-236","This submission contains a form or schedule which MeF is not accepting as a binary attachment. Please verify whether it is valid for your submission to include the form or schedule. If valid, complete the form or schedule in XML format and resubmit.","Unsupported","Reject and Stop","Active"]
["R0000-900-01","The return type indicated in the return header must match the return type established with the IRS for the EIN.","Database Validation Error","Reject","Active"]
["R0000-901-01","Filer's EIN and Name Control in the Return Header must match data in the e-File database.","Database Validation Error","Reject","Active"]
["R0000-904-03","Software ID in the Return Header must have passed testing for the form family and 'TaxYr'.","Database Validation Error","Reject and Stop","Active"]
["R0000-905-01","Electronic Filing Identification Number (EFIN) in the Return Header must be listed in the e-File database and in accepted status.","Database Validation Error","Reject and Stop","Active"]
["R0000-906-02","Routing Transit Number (RTN) included in the return must be present in the e-File database.","Database Validation Error","Reject","Active"]
["R0000-932-02","If \"Amended Return\" or (Superseded for 1120/1120S/1120-F/1041/1042/1065) checkbox is not checked, then taxpayer TIN in the Return Header must not be the same as a TIN of a previously accepted electronic return for the return type and tax period indicated in the tax return.","Duplicate Condition","Reject","Active"]
["R0000-933-02","If \"Amended Return\" or (Superseded for 1120/1120S/1120-F/1041/1042/1065) checkbox is not checked, then taxpayer TIN in the Return Header must not be the same as a TIN of a previously accepted paper return for the return type and tax period indicated in the tax return.","Duplicate Condition","Reject","Active"]
["SQ-F1042-001","Schedule Q (Form1042), 'QDDScheduleNum' must not be greater than 'TotalQDDScheduleNum'.","Incorrect Data","Reject","Active"]
["SQ-F1042-002","Schedule Q (Form 1042), 'TotalQDDScheduleNum' must be equal to the total number of Schedule Q (Form 1042) present in the return.","Data Mismatch","Reject","Active"]
["STATE-012","The State Submission category that was filed is not being accepted by Modernized e-File (MeF) at this time.  Please check the MeF web page under irs.gov for more information.  The submission category filed was <category>.","Unsupported","Reject and Stop","Active"]
["STATE-020","The IRS Submission ID referenced in the State Submission Manifest must not correspond to a Federal return for one of the following submission types: 990T or 4720 or 8038CP or 5330 or 5227 or 1042 or 943-X or 945-X or 941-X.","Incorrect Data","Reject and Stop","Active"]
["STATE-221","The ETIN associated with the Business submission is not a participating transmitter. Please check the Modernized e-File (MeF) web page under irs.gov for more information on participation rules.","Unsupported","Reject and Stop","Active"]
["T0000-013","The Message ID must be globally unique.","Incorrect Data","Reject and Stop","Active"]
["T0000-014","The Submission ID must be globally unique.","Incorrect Data","Reject and Stop","Active"]
["T0000-015","The ETIN in the Message ID (the first five digits) must match the ETIN provided with the request.","Incorrect Data","Reject and Stop","Active"]
["T0000-016","The Message ID must be 20 positions in length and conform to the following format: 12 digits followed by 8 alphanumeric characters (only lower case alphabetic characters allowed).","Incorrect Data","Reject and Stop","Active"]
["T0000-017","The Submission ID must be 20 characters in length.","Incorrect Data","Reject and Stop","Active"]
["X0000-005","The XML data has failed schema validation.","XML Error","Reject and Stop","Active"]
["X0000-008","The namespace declarations in the root element of the return ('Return' element) must be as follows:The default namespace shall be set to \"http://www.irs.gov/efile\" (xmlns= \"http://www.irs.gov/efile\").The namespace prefix \"efile\" shall be bound to the namespace \"http://www.irs.gov\" (xmlns:efile=\"http://www.irs.gov/efile\").","XML Error","Reject and Stop","Active"]
["X0000-010","For each SubmissionID provided in the transmission manifest there must be a submission zip archive entry present in the Attachment Zip file whose name (without the \".zip\" extension) matches the SubmissionID.","Incorrect Data","Reject and Stop","Active"]
["X0000-011","All entries in the submission zip archive (zip file that is the submission) must begin with \"manifest/\" or \"/manifest/\" or \"xml/\" or \"/xml/\" or \"attachment/\" or  \"/attachment/\" (all lower case characters).","Incorrect Data","Reject and Stop","Active"]
["X0000-012","The name of a binary attachment file must be less than or equal to 64 bytes.","Incorrect Data","Reject and Stop","Active"]
["X0000-015","Each zip entry in the Attachment Zip file must end with \".zip\" extension.","Data Mismatch","Reject and Stop","Active"]
["X0000-018","A submission zip archive (zip file that is the submission) must contain exactly one entry that begins with  \"manifest/\" or \"/manifest/\" and is followed by the file name \"manifest.xml\".  The entry name must use lower case characters ('a' through 'z') only and the separator must be the forward slash character.","Incorrect Data","Reject and Stop","Active"]
["X0000-019","A submission zip archive (zip file that is the submission) must contain exactly one entry that consists of \"xml/\" or \"/xml/\" (all lower case characters) followed by a file name.","Incorrect Data","Reject and Stop","Active"]
["X0000-020","A submission zip archive (zip file that is the submission) may contain zero or more entries that begin with \"attachment/\" or \"/attachment/\" and each is followed by a file name.  The entry name must use lower case characters ('a' through 'z') only and the separator must be the forward slash character.","Incorrect Data","Reject and Stop","Active"]
["X0000-024","Unable to read a binary attachment in the Submission Zip Archive.","Incorrect Data","Reject and Stop","Active"]
["X0000-025","Unable to read XML data from the Submission Zip Archive.","Incorrect Data","Reject and Stop","Active"]
["X0000-027","Year (YYYY) in the SubmissionID must be processing year.","Incorrect Data","Reject","Active"]
["X0000-028","A single PDF file must not exceed 60MB in size.","Incorrect Data","Reject","Active"]
["X0000-029","A binary attachment submitted in the PDF format must begin with the file header \"%PDF-\".","Incorrect Data","Reject and Stop","Active"]
["X0000-030","The size and CRC32 checksum value must be provided for the submission XML file (i.e. xml data file that starts with \"xml/\" or \"/xml/\").","Incorrect Data","Reject and Stop","Active"]
["X0000-031","Zip Entry names must conform to the guidelines in Publication 4164.","Incorrect Data","Reject and Stop","Active"]
["X0000-032","Unable to extract submission Zip Archive from the Message Attachment zip file.","Incorrect Data","Reject and Stop","Active"]
["X0000-033","Modernized e-File (MeF) accepts submissions only in the Unicode Transformation Format-8 (UTF-8) format.","Incorrect Data","Reject and Stop","Active"]

{"sheet":"Loader","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}