Table: dbo.Client_GL_Setup
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | The primary key for this table and foreign key to the client
gl_period_type_KEY | int (4) | NOT NULL | The foreign key to the general ledger period type
gl_accounting_method_KEY | int (4) | NOT NULL | The foreign key to the general ledger accounting method
ultra_tax_entity_type_KEY | int (4) | NOT NULL | The foreign key to the ultra_tax_entity_type_key table.
payroll_check__journal_KEY | int (4) | NOT NULL | Foreign key to Journal table. The default journal used for both payroll checks and the summary payroll journal entry created from payroll checks
disable_gl_period_constraint | bit (1) | NOT NULL | This column is used to temporarily turn off GL period DAL constraints when GL period foreign keys are being remapped. This is a temporary fix; the real solution will involve re-working some of the DAL constraint logic in Common at which time this column can go away. Note that a value of 1 for this column is never actually committed to the database.
asset_rounding__gl_account_KEY | int (4) |  | Foreign Key to GL_Account table with account type A, this account will be used as a plug for rounding Assets.This will be null if the Balance Definition rounding option is false for the client.
liability_rounding__gl_account_KEY | int (4) |  | Foreign Key to GL_Account table with account type L, this account will be used as a plug for rounding Liablities.This will be null if the Balance Definition rounding option is false for the client.
revenue_expense_rounding__gl_account_KEY | int (4) |  | Foreign Key to GL_Account table with account type R and E, this account will be used as a plug for rounding Income statement accounts.This will be null if the Balance Definition rounding option is false for the client.
round_by_segment | bit (1) | NOT NULL | True if we are rounding by segments
account_activity__journal_KEY | int (4) | NOT NULL | Foreign key to Journal table. The default journal used when data is entered into a client that is not supported by a specific transaction.
account_activity_reference | nvarchar (32) | NOT NULL | The reference number used for account activity transactions default journal.
firm_vendor_liability__journal_KEY | int (4) | NOT NULL | Foreign key to Journal table. The default journal used for firm vendor liability transactions.
firm_vendor_liability_reference | nvarchar (32) | NOT NULL | The reference number used for firm vendor liabilities transactions default journal.
fixed_asset_cs_integration__journal_KEY | int (4) | NOT NULL | Foreign key to Journal table. The default journal used for fixed assets cs integration transactionis.
fixed_asset_cs_integration_reference | nvarchar (32) | NOT NULL | The reference number used for fixed assets cs integration transactions default journal.
impound_withdrawal__journal_KEY | int (4) | NOT NULL | Foreign key to Journal table. The default journal used for impound withdrawal transactions.
impound_withdrawal_reference | nvarchar (32) | NOT NULL | The reference number used for impound withdrawals transactions default journal.
payroll_check_reference | nvarchar (32) | NOT NULL | The reference number used for payroll checks transactions default journal.
practice_cs_integration__journal_KEY | int (4) | NOT NULL | Foreign key to Journal table. The default journal used for practice cs integration transactions.
practice_cs_integration_reference | nvarchar (32) | NOT NULL | The reference number used for practice cs integration transactions default journal.
unprinted_check_accrual__journal_KEY | int (4) | NOT NULL | Foreign key to Journal table. The default journal used for unprinted checks accrual transactions.
unprinted_check_accrual_reference | nvarchar (32) | NOT NULL | The reference number used for unprinted checks accrual transactions default journal.
vendor_payment__journal_KEY | int (4) | NOT NULL | Foreign key to Journal table. The default journal used for vendor payments transactions.
accountant__current__gl_period_KEY | int (4) | NOT NULL | This foreign key defines both the current period and current fiscal year that the staff from the accountant's office is working in.
accountant__latest_selected__gl_period_KEY | int (4) | NOT NULL | This foreign key defines the most future period a staff from the accountant's office has moved into.
client__current__gl_period_KEY | int (4) | NOT NULL | This foreign key defines both the current period and current fiscal year that the staff from the client's office is working in.
client__latest_selected__gl_period_KEY | int (4) | NOT NULL | This foreign key defines the most future period a staff from the client's office has moved into.
allow_leading_zero | bit (1) | NOT NULL | If true, segment codes must be padded with leading zeroes to the full size of the segment pattern. If false, leading zeroes are not allowed on segment codes.
accountant__earliest_open__gl_period_KEY | int (4) | NOT NULL | The gl period key for the accountant's earliest opened gl period.
client__earliest_open__gl_period_KEY | int (4) | NOT NULL | The gl period key for the client's earliest opened gl period.
disable_close_posting_periods_for_accounting_cs | bit (1) | NOT NULL | Is close posting periods disabled for accounting cs?
disable_close_posting_periods_for_client_access | bit (1) | NOT NULL | Is close posting periods disabled for client access?
use_transaction_date_to_default_posting_period | bit (1) | NOT NULL | Indicates the gl period that the transaction date falls in should be used as a default for the gl period when adding new transactions or when modifying the transaction date on existing ones. This does not occur if is_posting_period_overridden is set to true, signifying the user has overridden the posting period for the transaction.
post_payroll_transactions | bit (1) | NOT NULL | This column will store the boolean value that determines whether or not payroll transactions from the selected effective period through the most future fiscal year will post to the General Ledger. A value of true meaning the transactions will post, and false meaning they won’t post. When new fiscal years are created the post_payroll_transactions flag will be used to determine whether or not to add the gl periods of the new fiscal year to the Non_Posting_Payroll_Transactions_GL_Period table.
post_automatic_journal_entries | bit (1) | NOT NULL | This should be set to true if we know that we want to post automatic journal entries in situations where posting them is conditional, such as before printing reports.
post_to_core_general_ledger_accounts | bit (1) | NOT NULL | Post to core general ledger accounts, this will provide the user the flexibility to disallow ["BR"] posting to core accounts when more than one segment exists.

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

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_GL_Setup__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_GL_Setup__GL_Account__asset_rounding__gl_account_KEY | asset_rounding__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_GL_Setup__GL_Account__liability_rounding__gl_account_KEY | liability_rounding__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_GL_Setup__GL_Account__revenue_expense_rounding__gl_account_KEY | revenue_expense_rounding__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Client_GL_Setup__GL_Accounting_Method__gl_accounting_method_KEY | gl_accounting_method_KEY | GL_Accounting_Method (gl_accounting_method_KEY) |
FK_Client_GL_Setup__GL_Period__accountant__current__gl_period_KEY | accountant__current__gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Client_GL_Setup__GL_Period__accountant__earliest_open__gl_period_KEY | accountant__earliest_open__gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Client_GL_Setup__GL_Period__accountant__latest_selected__gl_period_KEY | accountant__latest_selected__gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Client_GL_Setup__GL_Period__client__current__gl_period_KEY | client__current__gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Client_GL_Setup__GL_Period__client__earliest_open__gl_period_KEY | client__earliest_open__gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Client_GL_Setup__GL_Period__client__latest_selected__gl_period_KEY | client__latest_selected__gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Client_GL_Setup__GL_Period_Type__gl_period_type_KEY | gl_period_type_KEY | GL_Period_Type (gl_period_type_KEY) |
FK_Client_GL_Setup__Journal__account_activity__journal_KEY | account_activity__journal_KEY | Journal (journal_KEY) |
FK_Client_GL_Setup__Journal__firm_vendor_liability__journal_KEY | firm_vendor_liability__journal_KEY | Journal (journal_KEY) |
FK_Client_GL_Setup__Journal__fixed_asset_cs_integration__journal_KEY | fixed_asset_cs_integration__journal_KEY | Journal (journal_KEY) |
FK_Client_GL_Setup__Journal__impound_withdrawal__journal_KEY | impound_withdrawal__journal_KEY | Journal (journal_KEY) |
FK_Client_GL_Setup__Journal__payroll_check__journal_KEY | payroll_check__journal_KEY | Journal (journal_KEY) |
FK_Client_GL_Setup__Journal__practice_cs_integration__journal_KEY | practice_cs_integration__journal_KEY | Journal (journal_KEY) |
FK_Client_GL_Setup__Journal__unprinted_check_accrual__journal_KEY | unprinted_check_accrual__journal_KEY | Journal (journal_KEY) |
FK_Client_GL_Setup__Journal__vendor_payment__journal_KEY | vendor_payment__journal_KEY | Journal (journal_KEY) |
FK_Client_GL_Setup__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEY | ultra_tax_entity_type_KEY | Ultra_Tax_Entity_Type (ultra_tax_entity_type_KEY) |