Table: dbo.Print_Filing_Instruction
Stores the filing instruction for a particular federal/state/local collation item for a particular processing period.
Columns
NameTypeConstraintsDescription
print_filing_instruction_KEYint (4)NOT NULLUnique value for this filing instruction for a given federal/state/local collation item for a given processing period.
user_session_guiduniqueidentifier (16)NOT NULLThe user session for the person printing the forms. We note user session (as opposed to user) because the application allows a user to log in more than once. In turn, this permits a user to print from more than one session at the same time.
client_KEYint (4)NOT NULLForeign key to client table to indicate which client this filing instruction is for.
tax_form_KEYint (4)NOT NULLForeign key to tax form table to indicate which collation item this filing instruction is for.
period_end_datesmalldatetime (4)NOT NULLPeriod end date that these filing instruction are for.
penalty_and_interest_duedecimal (9, 2)NOT NULLPenalty and interest total for this period for this collation item.
amount_duedecimal (9, 2)NOT NULLAmount due for this collation item.
due_datesmalldatetime (4)NOT NULLDue date of this collation item.
tax_agent_KEYint (4)NOT NULLTax agent for this collation item.
tax_agent_form_filing_address_scenario_KEYint (4)NOT NULLWhich filing address should be used for this filing instruction
signature_requiredbit (1)NOT NULLIs a signature required for this collation item?
tax_form_filing_method_KEYint (4)NOT NULLThe tax form filing method type of the filing instruction being printed
Primary key
NameColumnsDescription
PK_Print_Filing_Instructionprint_filing_instruction_KEY
Unique constraints
NameColumnsDescription
UK_Print_Filing_Instruction$client_KEY$tax_form_KEY$user_session_guid$tax_agent_form_filing_address_scenario_KEYclient_KEY, tax_form_KEY, user_session_guid, tax_agent_form_filing_address_scenario_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Print_Filing_Instruction__Tax_Form_Filing_Method__tax_form_filing_method_KEYtax_form_filing_method_KEYTax_Form_Filing_Method (tax_form_filing_method_KEY)
FK_Print_Filing_Instruction__Client__client_KEYclient_KEYClient (client_KEY)
FK_Print_Filing_Instruction__Tax_Agent__tax_agent_KEYtax_agent_KEYTax_Agent (tax_agent_KEY)
FK_Print_Filing_Instruction__Tax_Agent_Form_Filing_Address_Scenario__tax_agent_form_filing_address_scenario_KEYtax_agent_form_filing_address_scenario_KEYTax_Agent_Form_Filing_Address_Scenario (tax_agent_form_filing_address_scenario_KEY)
FK_Print_Filing_Instruction__Tax_Form__tax_form_KEYtax_form_KEYTax_Form (tax_form_KEY)

Schema diagram