paul1204
Member
Once upon a time, business has the requirements to outsource the 1099 filings to a 3rd party. But the poor JDE IRSTAX.txt is hardily readable to the human eye and is processed by a Developer to transform the format into the format requested by the 3rd party.
Fear not! Says the Developer, I will use Python to process such data.
The developer stumbles across this within the JDE IRSTAX.txt
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Fear not! Says the Developer, Oracle should have documentation regarding this.
Upon reading the documentation (url is below) the Developer does not see anything regarding the formatting of this file.
Fear not! Says the noble Developer, I will consult the IRS documentation regarding this.
Upon reading the IRS documents, there are 18 columns of max length of 12 (216 which is that amount of 0's). The IRS doc however says "Payment Amount 1" for each of the columns. Where as the 3rd party format says something such as "Rents" for the first column.
The concern of the developer is, when mapping those 18 columns to the 3rd party, it only matches 15 . There are no spots for the other 3.
In the 3rd party format, the 12th position (of the 0's) map to a column name that our Business Analyst is not familiar with. The Business Analyst is suggesting that 12th position should be mapped to the 10th position.
To be sure 100% does anyone know what those 216 zero's represent in the IRSTAX.txt? Furthermore, does anyone know the exact structure of that entire file? The main reason I ask is because there is only 1 set of columns that we have values for. The other 17 sets of values in that long string is zeros. I am writing code to handle each set to the appropriate meaning. Essentially, I am trying to map the right value to the right box in the 1099.
Could not find it in the docs
Best,
The Noble Developer
Fear not! Says the Developer, I will use Python to process such data.
The developer stumbles across this within the JDE IRSTAX.txt
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Fear not! Says the Developer, Oracle should have documentation regarding this.
Upon reading the documentation (url is below) the Developer does not see anything regarding the formatting of this file.
Fear not! Says the noble Developer, I will consult the IRS documentation regarding this.
Upon reading the IRS documents, there are 18 columns of max length of 12 (216 which is that amount of 0's). The IRS doc however says "Payment Amount 1" for each of the columns. Where as the 3rd party format says something such as "Rents" for the first column.
The concern of the developer is, when mapping those 18 columns to the 3rd party, it only matches 15 . There are no spots for the other 3.
In the 3rd party format, the 12th position (of the 0's) map to a column name that our Business Analyst is not familiar with. The Business Analyst is suggesting that 12th position should be mapped to the 10th position.
To be sure 100% does anyone know what those 216 zero's represent in the IRSTAX.txt? Furthermore, does anyone know the exact structure of that entire file? The main reason I ask is because there is only 1 set of columns that we have values for. The other 17 sets of values in that long string is zeros. I am writing code to handle each set to the appropriate meaning. Essentially, I am trying to map the right value to the right box in the 1099.
Could not find it in the docs
1099 Year-End Processing Guide
After you export 1099 data to a text file, correct any records, if necessary, and verify that the file contains the information that you intend to submit to the IRS. For electronic filing, you submit the text file electronically by using the Internet through the IRS FIRE system. The text file...
docs.oracle.com
Best,
The Noble Developer