Table: dbo.GL_Balancing_Entry
This table stores the balancing entry for one or more bank transactions. In the land of GL, bank transactions are created as unbalanced journal entries until such time as the user chooses to balance them. Balancing entails creating a GL balancing entry row that sums to the total of the selected bank transactions. These bank transaction must always belong to the same checkbook and said checkbook's GL account number is used to create a journal entry that balances the selected unbalanced bank transactions.
Columns
NameTypeConstraintsDescription
gl_balancing_entry_KEYint (4)NOT NULLPrimary key.
reference_numbernvarchar (32)NOT NULLA user defined alphnumeric reference number for the balancing entry.
transaction_datesmalldatetime (4)A user defined date for the balancing entry.
descriptionnvarchar (240)NOT NULLA description for the balancing entry.
gl_balancing_entry_type_KEYint (4)NOT NULLThe type of each balancing entry.
reference_number_sortablenvarchar (160)NOT NULLA representation of the reference_number column that sorts in natural order. A trigger keeps this field synchronized with the content of reference_number.
creation_datedatetime (8, 3)NOT NULLThe date on which the application created the balancing entry.
staff_KEYint (4)NOT NULLThe key of the staff member who created the balancing entry.
Primary key
NameColumnsDescription
PK_GL_Balancing_Entrygl_balancing_entry_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Balancing_Entry__GL_Balancing_Entry_Type__gl_balancing_entry_type_KEYgl_balancing_entry_type_KEYGL_Balancing_Entry_Type (gl_balancing_entry_type_KEY)
FK_GL_Balancing_Entry__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_GL_Transaction_N_GL_Balancing_Entry__GL_Balancing_Entry__gl_balancing_entry_KEYgl_balancing_entry_KEYGL_Transaction_N_GL_Balancing_Entry
FK_GL_Balancing_Entry_N_Bank_Transaction__GL_Balancing_Entry__gl_balancing_entry_KEYgl_balancing_entry_KEYGL_Balancing_Entry_N_Bank_Transaction

Schema diagram