Table: dbo.Payroll_Journal_Entry_Option
Table to hold information specified in the Payroll Journal Entry Options Dialog
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary key of the table and foreign key to Client table
export_journal_entry_to_csa_format_KEYint (4)NOT NULLforeign key to the Export_Journal_Entry_To_Csa_Format table
journal_KEYint (4)NOT NULLforeign key to the Journal Table
payroll_journal_entry_option_date_type_KEYint (4)NOT NULLforeign key to the Payroll_Journal_Entry_Option_Date_Type Table
consolidate_entries_per_gl_periodbit (1)NOT NULLwhether or not to consolidate the entries per GL period
reference_number_incrementint (4)NOT NULLHow much to increment the reference number by, 0 if not specified
reset_reference_number_per_gl_periodbit (1)NOT NULLwhether or not to reset the reference number to the base every GL period
descriptionnvarchar (240)NOT NULLdescription of the journal entry that is created
reference_numbernvarchar (32)NOT NULLreference number of the journal entry created
Primary key
NameColumnsDescription
PK_Payroll_Journal_Entry_Option$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Journal_Entry_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_Payroll_Journal_Entry_Option__Export_Journal_Entry_To_Csa_Format__export_journal_entry_to_csa_format_KEYexport_journal_entry_to_csa_format_KEYExport_Journal_Entry_To_Csa_Format (export_journal_entry_to_csa_format_KEY)
FK_Payroll_Journal_Entry_Option__Journal__journal_KEYjournal_KEYJournal (journal_KEY)
FK_Payroll_Journal_Entry_Option__Payroll_Journal_Entry_Option_Date_Type__payroll_journal_entry_option_date_type_KEYpayroll_journal_entry_option_date_type_KEYPayroll_Journal_Entry_Option_Date_Type (payroll_journal_entry_option_date_type_KEY)

Schema diagram