Table: dbo.Payroll_Journal_Entry_Option
Table to hold information specified in the Payroll Journal Entry Options Dialog
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | Primary key of the table and foreign key to Client table
export_journal_entry_to_csa_format_KEY | int (4) | NOT NULL | foreign key to the Export_Journal_Entry_To_Csa_Format table
journal_KEY | int (4) | NOT NULL | foreign key to the Journal Table
payroll_journal_entry_option_date_type_KEY | int (4) | NOT NULL | foreign key to the Payroll_Journal_Entry_Option_Date_Type Table
consolidate_entries_per_gl_period | bit (1) | NOT NULL | whether or not to consolidate the entries per GL period
reference_number_increment | int (4) | NOT NULL | How much to increment the reference number by, 0 if not specified
reset_reference_number_per_gl_period | bit (1) | NOT NULL | whether or not to reset the reference number to the base every GL period
description | nvarchar (240) | NOT NULL | description of the journal entry that is created
reference_number | nvarchar (32) | NOT NULL | reference number of the journal entry created

Primary key
Name | Columns | Description
PK_Payroll_Journal_Entry_Option$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Journal_Entry_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Payroll_Journal_Entry_Option__Export_Journal_Entry_To_Csa_Format__export_journal_entry_to_csa_format_KEY | export_journal_entry_to_csa_format_KEY | Export_Journal_Entry_To_Csa_Format (export_journal_entry_to_csa_format_KEY) |
FK_Payroll_Journal_Entry_Option__Journal__journal_KEY | journal_KEY | Journal (journal_KEY) |
FK_Payroll_Journal_Entry_Option__Payroll_Journal_Entry_Option_Date_Type__payroll_journal_entry_option_date_type_KEY | payroll_journal_entry_option_date_type_KEY | Payroll_Journal_Entry_Option_Date_Type (payroll_journal_entry_option_date_type_KEY) |