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
NameTypeConstraintsDescription
tax_system_bridged_federal_carry_over_KEYint (4)NOT NULLprimary key
client_KEYint (4)NOT NULLclient this tax system carryover is for
tax_system_bridged_carry_over_source_KEYint (4)NOT NULLSystem description that generated this carry over. Example: 941-X
form_yearint (4)NOT NULLFor 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_quarterint (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.
amountdecimal (9, 2)NOT NULLAmount to carry over
corrected_yearint (4)NOT NULLYear that the carryover is correcting.
corrected_quarterint (4)NOT NULLQuarter that the carryover is correcting.
Primary key
NameColumnsDescription
PK_Tax_System_Bridged_Federal_Carry_Overtax_system_bridged_federal_carry_over_KEY
Unique constraints
NameColumnsDescription
UK_Tax_System_Bridged_Federal_Carry_Over$client_KEY$tax_system_bridged_carry_over_source_KEY$form_year$form_quarterclient_KEY, tax_system_bridged_carry_over_source_KEY, form_year, form_quarter
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_System_Bridged_Federal_Carry_Over__Client__client_KEYclient_KEYClient (client_KEY)
FK_Tax_System_Bridged_Federal_Carry_Over__Tax_System_Bridged_Carry_Over_Source__tax_system_bridged_carry_over_source_KEYtax_system_bridged_carry_over_source_KEYTax_System_Bridged_Carry_Over_Source (tax_system_bridged_carry_over_source_KEY)

Schema diagram