Table: dbo.GL_Account_Segment_Code_Rounding_Account
Table to hold different type of account keys we will use for rounding on the financial statement, Report and Trial balance grid.
Columns
NameTypeConstraintsDescription
gl_account_segment_code_KEYint (4)NOT NULLPrimary key and foreign key to the GL_Account_Segment_code table
asset__gl_account_KEYint (4)NOT NULLForeign 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__gl_account_KEYint (4)NOT NULLForeign Key to GL_Account table with account type L, this account will be used as a plug for rounding Liblilites. This will be null if the Balance Definition rounding option is false for the client.
revenue_expense__gl_account_KEYint (4)NOT NULLForeign 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.
Primary key
NameColumnsDescription
PK_GL_Account_Segment_Code_Rounding_Account$gl_account_segment_code_KEYgl_account_segment_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Segment_Code_Rounding_Account__GL_Account__asset__gl_account_KEYasset__gl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_Segment_Code_Rounding_Account__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_Segment_Code_Rounding_Account__GL_Account__revenue_expense__gl_account_KEYrevenue_expense__gl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_Segment_Code_Rounding_Account__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYGL_Account_Segment_Code (gl_account_segment_code_KEY)

Schema diagram