Table: dbo.Client_GL_Setup
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLThe primary key for this table and foreign key to the client
gl_period_type_KEYint (4)NOT NULLThe foreign key to the general ledger period type
gl_accounting_method_KEYint (4)NOT NULLThe foreign key to the general ledger accounting method
ultra_tax_entity_type_KEYint (4)NOT NULLThe foreign key to the ultra_tax_entity_type_key table.
payroll_check__journal_KEYint (4)NOT NULLForeign 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_constraintbit (1)NOT NULLThis 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_KEYint (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_KEYint (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_KEYint (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_segmentbit (1)NOT NULLTrue if we are rounding by segments
account_activity__journal_KEYint (4)NOT NULLForeign 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_referencenvarchar (32)NOT NULLThe reference number used for account activity transactions default journal.
firm_vendor_liability__journal_KEYint (4)NOT NULLForeign key to Journal table. The default journal used for firm vendor liability transactions.
firm_vendor_liability_referencenvarchar (32)NOT NULLThe reference number used for firm vendor liabilities transactions default journal.
fixed_asset_cs_integration__journal_KEYint (4)NOT NULLForeign key to Journal table. The default journal used for fixed assets cs integration transactionis.
fixed_asset_cs_integration_referencenvarchar (32)NOT NULLThe reference number used for fixed assets cs integration transactions default journal.
impound_withdrawal__journal_KEYint (4)NOT NULLForeign key to Journal table. The default journal used for impound withdrawal transactions.
impound_withdrawal_referencenvarchar (32)NOT NULLThe reference number used for impound withdrawals transactions default journal.
payroll_check_referencenvarchar (32)NOT NULLThe reference number used for payroll checks transactions default journal.
practice_cs_integration__journal_KEYint (4)NOT NULLForeign key to Journal table. The default journal used for practice cs integration transactions.
practice_cs_integration_referencenvarchar (32)NOT NULLThe reference number used for practice cs integration transactions default journal.
unprinted_check_accrual__journal_KEYint (4)NOT NULLForeign key to Journal table. The default journal used for unprinted checks accrual transactions.
unprinted_check_accrual_referencenvarchar (32)NOT NULLThe reference number used for unprinted checks accrual transactions default journal.
vendor_payment__journal_KEYint (4)NOT NULLForeign key to Journal table. The default journal used for vendor payments transactions.
accountant__current__gl_period_KEYint (4)NOT NULLThis 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_KEYint (4)NOT NULLThis foreign key defines the most future period a staff from the accountant's office has moved into.
client__current__gl_period_KEYint (4)NOT NULLThis 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_KEYint (4)NOT NULLThis foreign key defines the most future period a staff from the client's office has moved into.
allow_leading_zerobit (1)NOT NULLIf 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_KEYint (4)NOT NULLThe gl period key for the accountant's earliest opened gl period.
client__earliest_open__gl_period_KEYint (4)NOT NULLThe gl period key for the client's earliest opened gl period.
disable_close_posting_periods_for_accounting_csbit (1)NOT NULLIs close posting periods disabled for accounting cs?
disable_close_posting_periods_for_client_accessbit (1)NOT NULLIs close posting periods disabled for client access?
use_transaction_date_to_default_posting_periodbit (1)NOT NULLIndicates 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_transactionsbit (1)NOT NULLThis 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_entriesbit (1)NOT NULLThis 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_accountsbit (1)NOT NULLPost 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
NameColumnsDescription
PK_Client_GL_Setup$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_GL_Setup__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_GL_Setup__GL_Account__asset_rounding__gl_account_KEYasset_rounding__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_GL_Setup__GL_Account__liability_rounding__gl_account_KEYliability_rounding__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_GL_Setup__GL_Account__revenue_expense_rounding__gl_account_KEYrevenue_expense_rounding__gl_account_KEYGL_Account (gl_account_KEY)
FK_Client_GL_Setup__GL_Accounting_Method__gl_accounting_method_KEYgl_accounting_method_KEYGL_Accounting_Method (gl_accounting_method_KEY)
FK_Client_GL_Setup__GL_Period__accountant__current__gl_period_KEYaccountant__current__gl_period_KEYGL_Period (gl_period_KEY)
FK_Client_GL_Setup__GL_Period__accountant__earliest_open__gl_period_KEYaccountant__earliest_open__gl_period_KEYGL_Period (gl_period_KEY)
FK_Client_GL_Setup__GL_Period__accountant__latest_selected__gl_period_KEYaccountant__latest_selected__gl_period_KEYGL_Period (gl_period_KEY)
FK_Client_GL_Setup__GL_Period__client__current__gl_period_KEYclient__current__gl_period_KEYGL_Period (gl_period_KEY)
FK_Client_GL_Setup__GL_Period__client__earliest_open__gl_period_KEYclient__earliest_open__gl_period_KEYGL_Period (gl_period_KEY)
FK_Client_GL_Setup__GL_Period__client__latest_selected__gl_period_KEYclient__latest_selected__gl_period_KEYGL_Period (gl_period_KEY)
FK_Client_GL_Setup__GL_Period_Type__gl_period_type_KEYgl_period_type_KEYGL_Period_Type (gl_period_type_KEY)
FK_Client_GL_Setup__Journal__account_activity__journal_KEYaccount_activity__journal_KEYJournal (journal_KEY)
FK_Client_GL_Setup__Journal__firm_vendor_liability__journal_KEYfirm_vendor_liability__journal_KEYJournal (journal_KEY)
FK_Client_GL_Setup__Journal__fixed_asset_cs_integration__journal_KEYfixed_asset_cs_integration__journal_KEYJournal (journal_KEY)
FK_Client_GL_Setup__Journal__impound_withdrawal__journal_KEYimpound_withdrawal__journal_KEYJournal (journal_KEY)
FK_Client_GL_Setup__Journal__payroll_check__journal_KEYpayroll_check__journal_KEYJournal (journal_KEY)
FK_Client_GL_Setup__Journal__practice_cs_integration__journal_KEYpractice_cs_integration__journal_KEYJournal (journal_KEY)
FK_Client_GL_Setup__Journal__unprinted_check_accrual__journal_KEYunprinted_check_accrual__journal_KEYJournal (journal_KEY)
FK_Client_GL_Setup__Journal__vendor_payment__journal_KEYvendor_payment__journal_KEYJournal (journal_KEY)
FK_Client_GL_Setup__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYUltra_Tax_Entity_Type (ultra_tax_entity_type_KEY)

Schema diagram