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
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key to Form_1099_Original_Efile_Transmission_Information and foreign key to the Form_1099 table
receipt_idnvarchar (52)Transmission receipt identification that includes the recepient's record information that is being corrected
submission_idint (4)NOT NULLSubmission identification that includes the recipient's record information that is being corrected
record_idint (4)NOT NULLRecord identification for the recipient being corrected
Primary key
NameColumnsDescription
PK_Form_1099_Original_Efile_Transmission_Information$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_Original_Efile_Transmission_Information__Form_1099_form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)FOREIGN KEY constraint of form_1099_KEY for the Form_1099 table.

Schema diagram