| magnetic_media_file_KEY | int (4) | NOT NULL | Key for the magnetic media file |
| period_end_date | smalldatetime (4) | NOT NULL | Period end date for the file. |
| magnetic_media_file_status_KEY | int (4) | NOT NULL | Key for the status of the magnetic media file. |
| creation_date | datetime (8, 3) | NOT NULL | The date and time that the file was created. |
| tax_form_KEY | int (4) | NOT NULL | Foreign key to the tax form this file is for. |
| staff_KEY | int (4) | | The staff member that created or queued the file, or null if files aren't being saved by staff |
| magnetic_media_file_guid | uniqueidentifier (16) | NOT NULL | A unique identifer for each magnetic media file row. |
| is_corrected | bit (1) | NOT NULL | Whether or not the file is a corrected 1099 file. |
| last_modified | datetime (8, 3) | NOT NULL | The date and time that the file was last modified. |
| batch_number | int (4) | | The assigned file batch number if it exists, null if it doesn't exist. |
| separate_client_files | bit (1) | NOT NULL | Column is dependent on the value present in magnetic_media_file_status_KEY column. For Queued status - It indicates that whether or not separate internet files will be created for each client. 1 means that separate internet files will be created for each client; 0 means that a single internet file (bulk file) will be created for selected clients. For Completed or Created status - It indicates that whether or not separate internet files were created for each client. 1 means that separate internet files were created for each client; 0 means that a single internet file (bulk file) was created for selected clients. For Deleted status - This column is ignored for Deleted status. |