| 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 | ||