Table: dbo.Tax_System_Bridged_Federal_Carry_Over
The carryover amounts from one system to another. Example: 941-X credit amount carryovers to 941 for the quarter/year the error was discovered. Also tracks carryover amounts within the same tax systems. Example: 941 Line 10 amounts
Columns
Name | Type | Constraints | Description
tax_system_bridged_federal_carry_over_KEY | int (4) | NOT NULL | primary key
client_KEY | int (4) | NOT NULL | client this tax system carryover is for
tax_system_bridged_carry_over_source_KEY | int (4) | NOT NULL | System description that generated this carry over. Example: 941-X
form_year | int (4) | NOT NULL | For amended returns this is the year that should receive this carry over. For 941 returns it is the year of the form the amount came from.
form_quarter | int (4) |  | For amended returns this is the quarter that should receive this carry over. For 941 returns it is the quarter of the form the amount came from.
amount | decimal (9, 2) | NOT NULL | Amount to carry over
corrected_year | int (4) | NOT NULL | Year that the carryover is correcting.
corrected_quarter | int (4) | NOT NULL | Quarter that the carryover is correcting.

Primary key
Name | Columns | Description
PK_Tax_System_Bridged_Federal_Carry_Over | tax_system_bridged_federal_carry_over_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_System_Bridged_Federal_Carry_Over$client_KEY$tax_system_bridged_carry_over_source_KEY$form_year$form_quarter | client_KEY, tax_system_bridged_carry_over_source_KEY, form_year, form_quarter |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_System_Bridged_Federal_Carry_Over__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Tax_System_Bridged_Federal_Carry_Over__Tax_System_Bridged_Carry_Over_Source__tax_system_bridged_carry_over_source_KEY | tax_system_bridged_carry_over_source_KEY | Tax_System_Bridged_Carry_Over_Source (tax_system_bridged_carry_over_source_KEY) |