Table: dbo.Form_1098_C_Option | |||
This table stores the detailed options for 1098 C form. | |||
Columns | |||
Name | Type | Constraints | Description |
form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key to the Form_1099_C_Option table. |
contribution_date | date (3) | The date the donor contributed the vehicle to the donee. NULL is allowed because of a special requirement to allow a blank date. | |
contribution_date_override | date (3) | User override to the contribution date column. Null indicates not overridden. | |
contribution_date_original_override | date (3) | Original override to the contribution date column for corrected 1098Cs. Null indicates not overridden. | |
contribution_date_corrected_override | date (3) | Corrected override to the contribution date column for corrected 1098Cs. Null indicates not overridden. | |
odometer_mileage | int (4) | NOT NULL | The odometer mileage of the donated motor vehicle. |
odometer_mileage_override | int (4) | User override to the odometer mileage column. Null indicates not overridden. | |
odometer_mileage_original_override | int (4) | Original override to the odometer mileage column for corrected 1098Cs. Null indicates not overridden. | |
odometer_mileage_corrected_override | int (4) | Corrected override to the odometer mileage column for corrected 1098Cs. Null indicates not overridden. | |
year_of_vehicle | smallint (2) | The year the donated vehicle was manufactured. NULL is allowed because of a special requirement to allow a blank year. | |
year_of_vehicle_override | smallint (2) | User override to the year of vehicle column. Null indicates not overridden. | |
year_of_vehicle_original_override | smallint (2) | Original override to the year of vehicle column for corrected 1098Cs. Null indicates not overridden. | |
year_of_vehicle_corrected_override | smallint (2) | Corrected override to the year of vehicle column for corrected 1098Cs. Null indicates not overridden. | |
make_of_vehicle | nvarchar (256) | The make of the vehicle. | |
make_of_vehicle_override | nvarchar (256) | User override to the make of vehicle column. Null indicates not overridden. | |
make_of_vehicle_original_override | nvarchar (256) | Original override to the make of vehicle column for corrected 1098Cs. Null indicates not overridden. | |
make_of_vehicle_corrected_override | nvarchar (256) | Corrected override to the make of vehicle column for corrected 1098Cs. Null indicates not overridden. | |
model_of_vehicle | nvarchar (256) | The model of the vehicle. | |
model_of_vehicle_override | nvarchar (256) | User override to the model of vehicle column. Null indicates not overridden. | |
model_of_vehicle_original_override | nvarchar (256) | Original override to the model of vehicle column for corrected 1098Cs. Null indicates not overridden. | |
model_of_vehicle_corrected_override | nvarchar (256) | Corrected override to the model of vehicle column for corrected 1098Cs. Null indicates not overridden. | |
vehicle_id | nvarchar (50) | The vehicle identification number. | |
vehicle_id_override | nvarchar (50) | User override to the vehicle id column. Null indicates not overridden. | |
vehicle_id_original_override | nvarchar (50) | Original override to the vehicle id column for corrected 1098Cs. Null indicates not overridden. | |
vehicle_id_corrected_override | nvarchar (50) | Corrected override to the vehicle id column for corrected 1098Cs. Null indicates not overridden. | |
sold_to_unrelated_party | bit (1) | NOT NULL | The vehicle was sold to an unrelated party. |
sold_to_unrelated_party_override | bit (1) | User override to the sold to unrelated party column. Null indicates not overridden. | |
sold_to_unrelated_party_original_override | bit (1) | Original override to the sold to unrelated party column for corrected 1098Cs. Null indicates not overridden. | |
sold_to_unrelated_party_corrected_override | bit (1) | Corrected override to the sold to unrelated party column for corrected 1098Cs. Null indicates not overridden. | |
date_sold | date (3) | The date that the donee sold the donated vehicle. Null indicates that they did not sell the vehicle to an unrelated party. | |
date_sold_override | date (3) | User override to the date sold column. Null indicates not overridden. | |
date_sold_original_override | date (3) | Original override to the date sold column for corrected 1098Cs. Null indicates not overridden. | |
date_sold_corrected_override | date (3) | Corrected override to the date sold column for corrected 1098Cs. Null indicates not overridden. | |
vehicle_not_transferred_for_money_other_property_or_services | bit (1) | NOT NULL | The vehicle will not be transferred for money, other property or services before completion of material improvements or significant intervening use. |
vehicle_not_transferred_for_money_other_property_or_services_override | bit (1) | User override to the vehicle not transferred for money other property or services column. Null indicates not overridden. | |
vehicle_not_transferred_for_money_other_property_or_services_original_override | bit (1) | Original override to the vehicle not transferred for money other property or services column for corrected 1098Cs. Null indicates not overridden. | |
vehicle_not_transferred_for_money_other_property_or_services_corrected_override | bit (1) | Corrected override to the vehicle not transferred for money other property or services column for corrected 1098Cs. Null indicates not overridden. | |
vehicle_transferred_below_fair_market_value | bit (1) | NOT NULL | The vehicle is to be transferred to a needy person for significantly below fair market value. |
vehicle_transferred_below_fair_market_value_override | bit (1) | User override to the vehicle transferred below fair market value column. Null indicates not overridden. | |
vehicle_transferred_below_fair_market_value_original_override | bit (1) | Original override to the vehicle transferred below fair market value column for corrected 1098Cs. Null indicates not overridden. | |
vehicle_transferred_below_fair_market_value_corrected_override | bit (1) | Corrected override to the vehicle transferred below fair market values column for corrected 1098Cs. Null indicates not overridden. | |
detailed_description | nvarchar (256) | The detailed description of material improvements or significant intervening use and duration of use. | |
detailed_description_override | nvarchar (256) | User override to the detailed description column. Null indicates not overridden. | |
detailed_description_original_override | nvarchar (256) | Original override to the detailed description column for corrected 1098Cs. Null indicates not overridden. | |
detailed_description_corrected_override | nvarchar (256) | Corrected override to the detailed description column for corrected 1098Cs. Null indicates not overridden. | |
goods_or_services_in_exchange_for_vehicle | bit (1) | NOT NULL | Goods or services were provided in exchange for the donated vehicle. |
goods_or_services_in_exchange_for_vehicle_override | bit (1) | User override to the goods or services in exchange for vehicle column. Null indicates not overridden. | |
goods_or_services_in_exchange_for_vehicle_original_override | bit (1) | Original override to the goods or services in exchange for vehicle column for corrected 1098Cs. Null indicates not overridden. | |
goods_or_services_in_exchange_for_vehicle_corrected_override | bit (1) | Corrected override to the goods or services in exchange for vehicle column for corrected 1098Cs. Null indicates not overridden. | |
goods_and_services_solely_intangible_religious_benefits | bit (1) | NOT NULL | Were goods and services that were provided solely of intangible religious benefits. |
goods_and_services_solely_intangible_religious_benefits_override | bit (1) | User override to the goods and services solely intangible religious benefits column. Null indicates not overridden. | |
goods_and_services_solely_intangible_religious_benefits_original_override | bit (1) | Original override to the goods and services solely intangible religious benefits column for corrected 1098Cs. Null indicates not overridden. | |
goods_and_services_solely_intangible_religious_benefits_corrected_override | bit (1) | Corrected override to the goods and services solely intangible religious benefits column for corrected 1098Cs. Null indicates not overridden. | |
goods_and_services_description | nvarchar (256) | The description of the goods and services provided by the donee to the donor for the donated vehicle. | |
goods_and_services_description_override | nvarchar (256) | User override to the goods and services description column. Null indicates not overridden. | |
goods_and_services_description_original_override | nvarchar (256) | Original override to the goods and services description column for corrected 1098Cs. Null indicates not overridden. | |
goods_and_services_description_corrected_override | nvarchar (256) | Corrected override to the goods and services description column for corrected 1098Cs. Null indicates not overridden. | |
may_not_claim_deduction_more_than_five_hundred_dollars | bit (1) | NOT NULL | The donor may not claim a deduction of more than $500.00 for the donated vehicle. |
may_not_claim_deduction_more_than_five_hundred_dollars_override | bit (1) | User override to the may not claim deduction more than five hundred dollars column. Null indicates not overridden. | |
may_not_claim_deduction_more_than_five_hundred_dollars_original_override | bit (1) | Original override to the may not claim deduction more than five hundred dollars column for corrected 1098Cs. Null indicates not overridden. | |
may_not_claim_deduction_more_than_five_hundred_dollars_corrected_override | bit (1) | Corrected override to the may not claim deduction more than five hundred dollars column for corrected 1098Cs. Null indicates not overridden. |
Primary key | |||
Name | Columns | Description | |
PK_Form_1098_C_Option$form_1099_KEY | form_1099_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Form_1098_C_Option__Form_1099__form_1099_KEY | form_1099_KEY | Form_1099 (form_1099_KEY) |