Table: dbo.Complete_Forms_Output_Session_Client_Detail
This table stores the client detail associated with a complete forms output session.
Columns
Name | Type | Constraints | Description
complete_forms_output_session_client_detail_KEY | int (4) | NOT NULL | Primary key for this table.
complete_forms_output_session_KEY | int (4) | NOT NULL | Foreign key to the parent table Complete_Forms_Output_Session.
client_KEY | int (4) | NOT NULL | A client we are processing inside this complete forms output session.
liability_adjustment_threshold | decimal (9, 2) |  | The client level liability adjustment threshold used, NULL if the firm level threshold was used.
details | nvarchar (-1) |  | Details, if any, of what happened in the session. Nonscalar data stored using JSON. Can include error messages as well as basic processing information.
exclude_withholding_forms | bit (1) | NOT NULL | A bool flag to indicate if a Complete Forms Output Client Detail Session should exclude withholding forms from liability adjustment threshold.

Primary key
Name | Columns | Description
PK_Complete_Forms_Output_Session_Client_Detail | complete_forms_output_session_client_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Complete_Forms_Output_Session_Client_Detail__Complete_Forms_Output_Session__complete_forms_output_session_KEY | complete_forms_output_session_KEY | Complete_Forms_Output_Session (complete_forms_output_session_KEY) |
FK_Complete_Forms_Output_Session_Client_Detail__Client__client_KEY | client_KEY | Client (client_KEY) |