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
)