Table: dbo.Form_1099_Original_Efile_Transmission_Information
Table that holds the values of previous e-file transmission information for relevant 1099 recepients. In a chain of of three or more filings (for two or more rounds of correction) this holds data about the most recent version being corrected.
Columns
Name | Type | Constraints | Description
form_1099_KEY | int (4) | NOT NULL | Primary key to Form_1099_Original_Efile_Transmission_Information and foreign key to the Form_1099 table
receipt_id | nvarchar (52) |  | Transmission receipt identification that includes the recepient's record information that is being corrected
submission_id | int (4) | NOT NULL | Submission identification that includes the recipient's record information that is being corrected
record_id | int (4) | NOT NULL | Record identification for the recipient being corrected

Primary key
Name | Columns | Description
PK_Form_1099_Original_Efile_Transmission_Information$form_1099_KEY | form_1099_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1099_Original_Efile_Transmission_Information__Form_1099_form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) | FOREIGN KEY constraint of form_1099_KEY for the Form_1099 table.