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 |