Table: dbo.Ledger_Entry
Columns
Name | Type | Constraints | Description
ledger_entry_KEY | int (4) | NOT NULL |
gl_transaction_KEY | int (4) | NOT NULL |
ledger_entry_type_KEY | tinyint (1) | NOT NULL |
bank_transaction_distribution_KEY | int (4) |  |
payroll_check_payroll_item_distribution_KEY | int (4) |  |
payroll_check_tax_item_distribution_KEY | int (4) |  |
payroll_bank_transaction_worker_compensation_item_distribution_KEY | int (4) |  |
journal_entry_distribution_KEY | int (4) |  |
payable_transaction_distribution_KEY | int (4) |  |
payable_payment_application_payment_distribution_KEY | int (4) |  |
payable_payment_application_payable_distribution_KEY | int (4) |  |
ar_transaction_item_gl_account_KEY | int (4) |  |
ar_payment_application_distribution_KEY | int (4) |  |
client_KEY | int (4) | NOT NULL |
journal_KEY | int (4) | NOT NULL |
gl_period_KEY | int (4) | NOT NULL |
gl_account_KEY | int (4) |  |
gl_accounting_method_KEY | tinyint (1) |  |
gl_balance_effect_KEY | tinyint (1) | NOT NULL |
gl_transaction_type_KEY | int (4) | NOT NULL |
transaction_status_KEY | tinyint (1) | NOT NULL |
gl_transaction_date | smalldatetime (4) |  |
gl_transaction_amount | decimal (9, 2) | NOT NULL |
gl_transaction_description | nvarchar (240) | NOT NULL |
gl_transaction_detail_description | nvarchar (240) | NOT NULL |
gl_transaction_reference_number | nvarchar (32) | NOT NULL |
gl_transaction_reference_number_sortable | nvarchar (160) | NOT NULL |
gl_transaction_source_expression_KEY | tinyint (1) | NOT NULL | OBSOLETE: Prefer use of gl_transaction_source_KEY if at all possible
gl_transaction_source_KEY | int (4) | NOT NULL |
is_activity_journal_entry | bit (1) |  |
journal_entry_type_KEY | tinyint (1) | NOT NULL |
source_was_a_distribution | bit (1) | NOT NULL |
sequence_number | int (4) | NOT NULL |
workpaper_reference | nvarchar (50) | NOT NULL |
distribution_workpaper_reference | nvarchar (50) | NOT NULL |
checkbook_KEY | int (4) |  |
vendor_KEY | int (4) |  |
bank_transaction_KEY | int (4) |  |
first__w2_1099_box_type_KEY | tinyint (1) |  |
second__w2_1099_box_type_KEY | tinyint (1) |  |
journal_entry_KEY | int (4) |  |
auto_reversing | bit (1) |  |
journal_entry_misstatement_type_KEY | tinyint (1) |  |
schedule_m3_tax_code_attribute_KEY | tinyint (1) |  |
gl_balancing_entry_KEY | int (4) |  |
payable_transaction_KEY | int (4) |  |
payment__gl_transaction_KEY | int (4) |  |
customer_KEY | int (4) |  |
ar_transaction_item_KEY | int (4) |  |
ledger_row_version | timestamp (8) | NOT NULL | The version of this row.

Primary key
Name | Columns | Description
PK_Ledger_Entry | ledger_entry_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Ledger_Entry__Client__client_KEY | client_KEY | Client (client_KEY) |