The parent table for the print options of all the myriad 1099 forms. Each of the forms have a unique set of options so this parent table provides a common foreign key that all schema referencing 1099 print options can use. |
form_1099_KEY | int (4) | NOT NULL | Primary key. |
form_year | int (4) | NOT NULL | The calendar year of the 1099 form that these print options apply to. |
w2_1099_type_KEY | int (4) | NOT NULL | Foreign key to the type of 1099 form these print options apply to. |
vendor_KEY | int (4) | | Foreign key to the vendor this 1099 applies to. Will be null if this is for an independent contractor 1099. |
bank_transaction_KEY | int (4) | | Foreign key to the parent bank transaction (if transactional). |
is_one_1099_per_transaction | bit (1) | NOT NULL | Indicator used to determine if a 1099 should be printed per transaction or not.? |
employee_KEY | int (4) | | Foreign key to the employee this 1099 applies to. Will be null if this is not for an independent contractor 1099. |