| Table: dbo.Form_W2G_Option | |||
| Table to set various options on the W-2G form. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| form_1099_KEY | int (4) | NOT NULL | Primary key and foreign key into the Form_1099 table |
| date_won | smalldatetime (4) | Date the gambling winnings were won | |
| date_won_override | smalldatetime (4) | Override for the date the gambling winnings were won | |
| form_W2G_wager_type_KEY | int (4) | Type of wager made | |
| override__form_W2G_wager_type_KEY | int (4) | Override to the type of wager made | |
| transaction_description | nvarchar (128) | Ticket number, card number, machine serial number, or any other information to identify the winning transaction. | |
| transaction_description_override | nvarchar (128) | Override for the ticket number, card number, machine serial number, or any other information to identify the winning transaction. | |
| other_type_of_wager | nvarchar (128) | Description of the other type of wager | |
| other_type_of_wager_override | nvarchar (128) | Override for the description of the other type of wager | |
| cashier | nvarchar (128) | Cashier that paid out the winnings | |
| cashier_override | nvarchar (128) | Override for the cashier that paid out the winnings | |
| race | nvarchar (128) | Race | |
| race_override | nvarchar (128) | Override for the race | |
| first_id | nvarchar (128) | First form of ID | |
| first_id_override | nvarchar (128) | Override for the first form of ID | |
| window | nvarchar (128) | Location of the person paying out the winnings. | |
| window_override | nvarchar (128) | Override for the location of the person paying out the winnings. | |
| second_id | nvarchar (128) | Second form of ID | |
| second_id_override | nvarchar (128) | Override for the second form of ID | |
| date_won_original_override | smalldatetime (4) | Original override date won. | |
| original_override__form_W2G_wager_type_KEY | int (4) | Original override form w2g wager type. | |
| transaction_description_original_override | nvarchar (128) | Original override transaction description. | |
| other_type_of_wager_original_override | nvarchar (128) | Original override other type of wager. | |
| cashier_original_override | nvarchar (128) | Original override cashier. | |
| race_original_override | nvarchar (128) | Original override race. | |
| first_id_original_override | nvarchar (128) | Original override first id. | |
| window_original_override | nvarchar (128) | Original override window. | |
| second_id_original_override | nvarchar (128) | Original override second id. | |
| date_won_corrected_override | smalldatetime (4) | Corrected override date won. | |
| corrected_override__form_W2G_wager_type_KEY | int (4) | Corrected override form w2g wager type. | |
| transaction_description_corrected_override | nvarchar (128) | Corrected override transaction description. | |
| other_type_of_wager_corrected_override | nvarchar (128) | Corrected override other type of wager. | |
| cashier_corrected_override | nvarchar (128) | Corrected override cashier. | |
| race_corrected_override | nvarchar (128) | Corrected override race. | |
| first_id_corrected_override | nvarchar (128) | Corrected override first id. | |
| window_corrected_override | nvarchar (128) | Corrected override window. | |
| second_id_corrected_override | nvarchar (128) | Corrected override second id. | |
| Primary key | |||
| Name | Columns | Description | |
| PK_Form_W2G_Option$form_1099_KEY | form_1099_KEY | ||