Table: dbo.Numeric_GL_Account_Number_Metrics
This table contains metrics calculated across a client's Chart of Accounts. It's used by the GL_Account_Sort_View to build a padded string that can be used to sort the chart such that numeric account numbers (all digits with at most one decimal point) will appear to sort numerically (ex. 10, 20, 100) instead of alphanumerically (10, 100, 20).
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLThe client that the numeric GL account number metrics belong to.
max_digits_to_left_of_decimalint (4)NOT NULLThis column contains the maximum number of digits found to the left of the decimal point after looking across all numeric account numbers (all digits with at most one decimal point) in the given client's chart of accounts. A decimal is implied at the end of any numeric account number that doesn't have a decimal point. If this value is 0, then the client only has alphanumeric account numbers; it doesn't contain any numeric account numbers.
max_digits_to_right_of_decimalint (4)NOT NULLThis column contains the maximum number of digits found to the right of the decimal point after looking across all numeric account numbers (all digits with at most one decimal point) in the given client's chart of accounts. A decimal is implied at the end of any numeric account number that doesn't have a decimal point. If this value is 0, then the client either has only alphanumeric account numbers or none of the numeric account numbers have an embedded decimal point.
Primary key
NameColumnsDescription
PK_Numeric_GL_Account_Number_Metrics$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Numeric_GL_Account_Number_Metrics__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram