Table: dbo.Client_1099_Override
The table used to store Client overrides for the 1099s.
Columns
NameTypeConstraintsDescription
client_1099_override_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)NOT NULLForeign key into the Client table.
client_idnvarchar (22)The override for the client's id.
client_einnvarchar (22)The override for the client's ein.
final_returnbit (1)The override for whether or not this is the client's final return.
payroll_namenvarchar (100)The override for the client's payroll name.
address_1nvarchar (80)The override for the client's address line 1.
address_2nvarchar (80)The override for the client's address line 2.
citynvarchar (60)The override for the client's city.
state_abbreviationnvarchar (4)The override for the client's state.
postal_codenvarchar (20)The override for the client's postal code.
employer_type_KEYint (4)The override for the client's employer type.
establishment_numbernvarchar (8)The override for the client's establishment number.
contact_namenvarchar (100)The override for the client's contact name.
contact_emailnvarchar (80)The override for the client's contact email.
contact_phonenvarchar (50)The override for the client's contact phone.
contact_faxnvarchar (50)The override for the client's contact fax.
titlenvarchar (40)The override for the client's title.
signature_datedatetime (8, 3)The override for the client's signature date.
Primary key
NameColumnsDescription
PK_Client_1099_Overrideclient_1099_override_KEY
Unique constraints
NameColumnsDescription
UK_Client_1099_Override$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_1099_Override__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_1099_Override__Employer_Type__employer_type_KEYemployer_type_KEYEmployer_Type (employer_type_KEY)

Schema diagram