Table: dbo.Form_1099_Int_Option | |||
Detailed options for 1099-INT form | |||
Columns | |||
Name | Type | Constraints | Description |
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_Option table |
payers_rtn | nvarchar (256) | Form 1099-INT option: payer's RTN | |
foreign_country_or_us_posession | nvarchar (256) | Form 1099-INT option: foreign country/US posession | |
is_second_irs_notification_incorrect_recipient_tin | bit (1) | NOT NULL | Form 1099-INT option: second irs notification incorrect recipiant tin |
payers_rtn_override | nvarchar (256) | The override for the recipient's routing number. | |
foreign_country_or_us_possession_override | nvarchar (256) | The override for the recipient's foreign country. | |
is_second_irs_notification_incorrect_recipient_tin_override | bit (1) | The override for whether the IRS should be notified about a recipient's second TIN. | |
cusip_number | nvarchar (128) | Form 1099-INT option: CUSIP Number | |
cusip_number_override | nvarchar (128) | The override for the Form 1099-INT option: CUSIP Number | |
payers_rtn_original_override | nvarchar (256) | Original override of payers rtn. | |
foreign_country_or_us_possession_original_override | nvarchar (256) | Original override of foreign country or us prossession. | |
is_second_irs_notification_incorrect_recipient_tin_original_override | bit (1) | Original override of whether it is the second irs notification of incorrect recipent tin. | |
cusip_number_original_override | nvarchar (128) | Original override of the cusip number. | |
payers_rtn_corrected_override | nvarchar (256) | Corrected override of payers rtn. | |
foreign_country_or_us_possession_corrected_override | nvarchar (256) | Corrected override of foreign country or us prossession. | |
is_second_irs_notification_incorrect_recipient_tin_corrected_override | bit (1) | Corrected override of whether it is the second irs notification of incorrect recipent tin. | |
cusip_number_corrected_override | nvarchar (128) | Corrected override of the cusip number. | |
fatca_filing_requirement | bit (1) | NOT NULL | Whether or not the foreign account tax compliance act flag is set. |
fatca_filing_requirement_override | bit (1) | User override to the fatca_filing_requirement column. Null indicates not overridden. | |
fatca_filing_requirement_original_override | bit (1) | Original override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden. | |
fatca_filing_requirement_corrected_override | bit (1) | Corrected override to the fatca_filing_requirement column for corrected 1099s. Null indicates not overridden. | |
bond_percent | decimal (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_override | decimal (5, 2) | This contains an override value for column bond_percent. If its null,then column bond_percent isnt override |
Primary key | |||
Name | Columns | Description | |
PK_Form_1099_Int_Option$form_1099_KEY | form_1099_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Form_1099_Int_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |