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. |