E9.2 The Adventures of a JDE 1099 Text File


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

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

The Noble Developer
A simplification from the story telling is what does each 18 sets of 12 zeros represent in
within the JDE IRSTAX.txt?

Specifically the column names or perhaps the box that the 1099's are associated with?