Table: dbo.Processed_Tax_Form_Liability
Any tax forms in this table have had their liability adjustments processed. Liability adjustments are considered processed when the associated form has been processed and no adjustment is required, or the liability adjustment has been written off.
Columns
NameTypeConstraintsDescription
processed_tax_form_liability_KEYint (4)NOT NULLThe primary key, assigned by ACS.
client_KEYint (4)NOT NULLThe client the liability adjustment was processed for.
tax_form_KEYint (4)NOT NULLThe tax form the liability adjustment was processed for.
period_end_datesmalldatetime (4)NOT NULLThe period end date for the tax form.
processed_datesmalldatetime (4)NOT NULLThe most recent date within this period the liability adjustment was processed.
Primary key
NameColumnsDescription
PK_Processed_Tax_Form_Liabilityprocessed_tax_form_liability_KEY
Unique constraints
NameColumnsDescription
UK_Processed_Tax_Form_Liability$client_KEY$tax_form_KEY$period_end_dateclient_KEY, tax_form_KEY, period_end_date
Foreign keys
NameColumnsReferenced tableDescription
FK_Processed_Tax_Form_Liability__Client__client_KEYclient_KEYClient (client_KEY)
FK_Processed_Tax_Form_Liability__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)

Schema diagram