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 |