Table: dbo.Form_1099_Int_Option
Detailed options for 1099-INT form
Columns
NameTypeConstraintsDescription
form_1099_KEYint (4)NOT NULLPrimary key and foreign key to the Form_1099_Option table
payers_rtnnvarchar (256)Form 1099-INT option: payer's RTN
foreign_country_or_us_posessionnvarchar (256)Form 1099-INT option: foreign country/US posession
is_second_irs_notification_incorrect_recipient_tinbit (1)NOT NULLForm 1099-INT option: second irs notification incorrect recipiant tin
payers_rtn_overridenvarchar (256)The override for the recipient's routing number.
foreign_country_or_us_possession_overridenvarchar (256)The override for the recipient's foreign country.
is_second_irs_notification_incorrect_recipient_tin_overridebit (1)The override for whether the IRS should be notified about a recipient's second TIN.
cusip_numbernvarchar (128)Form 1099-INT option: CUSIP Number
cusip_number_overridenvarchar (128)The override for the Form 1099-INT option: CUSIP Number
payers_rtn_original_overridenvarchar (256)Original override of payers rtn.
foreign_country_or_us_possession_original_overridenvarchar (256)Original override of foreign country or us prossession.
is_second_irs_notification_incorrect_recipient_tin_original_overridebit (1)Original override of whether it is the second irs notification of incorrect recipent tin.
cusip_number_original_overridenvarchar (128)Original override of the cusip number.
payers_rtn_corrected_overridenvarchar (256)Corrected override of payers rtn.
foreign_country_or_us_possession_corrected_overridenvarchar (256)Corrected override of foreign country or us prossession.
is_second_irs_notification_incorrect_recipient_tin_corrected_overridebit (1)Corrected override of whether it is the second irs notification of incorrect recipent tin.
cusip_number_corrected_overridenvarchar (128)Corrected override of the cusip number.
fatca_filing_requirementbit (1)NOT NULLWhether or not the foreign account tax compliance act flag is set.
fatca_filing_requirement_overridebit (1)User override to the fatca_filing_requirement column. Null indicates not overridden.
fatca_filing_requirement_original_overridebit (1)Original override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
fatca_filing_requirement_corrected_overridebit (1)Corrected override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden.
bond_percentdecimal (5, 2)Percent of bond issued by MA, PR, VI, and Guam. If its null,then column has no value for bond_percent
bond_percent_overridedecimal (5, 2)This contains an override value for column bond_percent. If its null,then column bond_percent isnt override
Primary key
NameColumnsDescription
PK_Form_1099_Int_Option$form_1099_KEYform_1099_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1099_Int_Option__Form_1099__form_1099_KEYform_1099_KEYForm_1099 (form_1099_KEY)

Schema diagram