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
Name | Type | Constraints | Description
processed_tax_form_liability_KEY | int (4) | NOT NULL | The primary key, assigned by ACS.
client_KEY | int (4) | NOT NULL | The client the liability adjustment was processed for.
tax_form_KEY | int (4) | NOT NULL | The tax form the liability adjustment was processed for.
period_end_date | smalldatetime (4) | NOT NULL | The period end date for the tax form.
processed_date | smalldatetime (4) | NOT NULL | The most recent date within this period the liability adjustment was processed.

Primary key
Name | Columns | Description
PK_Processed_Tax_Form_Liability | processed_tax_form_liability_KEY |
Unique constraints
Name | Columns | Description
UK_Processed_Tax_Form_Liability$client_KEY$tax_form_KEY$period_end_date | client_KEY, tax_form_KEY, period_end_date |

Foreign keys
Name | Columns | Referenced table | Description
FK_Processed_Tax_Form_Liability__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Processed_Tax_Form_Liability__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form (tax_form_KEY) |