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
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | The client that the numeric GL account number metrics belong to.
max_digits_to_left_of_decimal | int (4) | NOT NULL | This 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_decimal | int (4) | NOT NULL | This 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
Name | Columns | Description
PK_Numeric_GL_Account_Number_Metrics$client_KEY | client_KEY |

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