Lookup table of boxes available on 1099 forms |
w2_1099_box_type_KEY | int (4) | NOT NULL | Primary key |
w2_1099_type_KEY | int (4) | NOT NULL | Foreign key to the 1099 form the box can be found on |
box_number | nvarchar (6) | NOT NULL | The box number |
description | varchar (125) | NOT NULL | The box description |
is_active | bit (1) | NOT NULL | Is this box type is active or has it become obsolete. If it is obsolete it can no longer be used moving forward, but it can still be associated to existing data. |
sequence_number | int (4) | NOT NULL | The sequence number used to determine the order by w2 1099 types. |