Table: dbo.Ledger_Entry
Columns
NameTypeConstraintsDescription
ledger_entry_KEYint (4)NOT NULL
gl_transaction_KEYint (4)NOT NULL
ledger_entry_type_KEYtinyint (1)NOT NULL
bank_transaction_distribution_KEYint (4)
payroll_check_payroll_item_distribution_KEYint (4)
payroll_check_tax_item_distribution_KEYint (4)
payroll_bank_transaction_worker_compensation_item_distribution_KEYint (4)
journal_entry_distribution_KEYint (4)
payable_transaction_distribution_KEYint (4)
payable_payment_application_payment_distribution_KEYint (4)
payable_payment_application_payable_distribution_KEYint (4)
ar_transaction_item_gl_account_KEYint (4)
ar_payment_application_distribution_KEYint (4)
client_KEYint (4)NOT NULL
journal_KEYint (4)NOT NULL
gl_period_KEYint (4)NOT NULL
gl_account_KEYint (4)
gl_accounting_method_KEYtinyint (1)
gl_balance_effect_KEYtinyint (1)NOT NULL
gl_transaction_type_KEYint (4)NOT NULL
transaction_status_KEYtinyint (1)NOT NULL
gl_transaction_datesmalldatetime (4)
gl_transaction_amountdecimal (9, 2)NOT NULL
gl_transaction_descriptionnvarchar (240)NOT NULL
gl_transaction_detail_descriptionnvarchar (240)NOT NULL
gl_transaction_reference_numbernvarchar (32)NOT NULL
gl_transaction_reference_number_sortablenvarchar (160)NOT NULL
gl_transaction_source_expression_KEYtinyint (1)NOT NULLOBSOLETE: Prefer use of gl_transaction_source_KEY if at all possible
gl_transaction_source_KEYint (4)NOT NULL
is_activity_journal_entrybit (1)
journal_entry_type_KEYtinyint (1)NOT NULL
source_was_a_distributionbit (1)NOT NULL
sequence_numberint (4)NOT NULL
workpaper_referencenvarchar (50)NOT NULL
distribution_workpaper_referencenvarchar (50)NOT NULL
checkbook_KEYint (4)
vendor_KEYint (4)
bank_transaction_KEYint (4)
first__w2_1099_box_type_KEYtinyint (1)
second__w2_1099_box_type_KEYtinyint (1)
journal_entry_KEYint (4)
auto_reversingbit (1)
journal_entry_misstatement_type_KEYtinyint (1)
schedule_m3_tax_code_attribute_KEYtinyint (1)
gl_balancing_entry_KEYint (4)
payable_transaction_KEYint (4)
payment__gl_transaction_KEYint (4)
customer_KEYint (4)
ar_transaction_item_KEYint (4)
ledger_row_versiontimestamp (8)NOT NULLThe version of this row.
Primary key
NameColumnsDescription
PK_Ledger_Entryledger_entry_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ledger_Entry__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram