Understanding the Flat File Generation for the Declaration Reports

After you review the records that you report in the 401 and 403 declaration reports and change the status of the records to Y, you generate the flat file that you send to the government. You run version XJDE0001 to generate a flat file from the records in the F75T401 table for the 401 Declaration report and run version XJDE0002 to generate a flat file from the records in the F75T403 table for the 403 Declaration report. Both versions also use the data in the GUI/VAT Declaration Site (F75T001) table.

You use the Declaration Site processing option to specify the declaration site for which you populate the flat file. When you specify a declaration site that is designated as a headquarters site (HQ) in the GUI/VAT Declaration Site program (P75T001), the system populates the flat file with the records for the headquarters site and all of the individual units that are associated with the same company. When you specify a declaration site that is designated as an individual unit (IU), the system populates the flat file with records for only the individual unit that you specify.

When you run each version of Declaration Report - Media Flat File - R75T401 program, the system generates a flat file with a maximum of 1080 bytes per record. Some fields in the flat file require that the last character in a value be changed.

For positive values that require a change in the last digit, the system changes the value according to this table:

Original Positive Value	New Value
0	{
1	A
2	B
3	C
4	D
5	E
6	F
7	G
8	H
9	I

For negative values that require a change in the last digit, the system changes the value according to this table:

Original Negative Character	New Value
0	}
1	J
2	K
3	L
4	M
5	N
6	O
7	P
8	Q
9	R