gl_account_KEY | int (4) | NOT NULL | Primary key for this table. |
client_KEY | int (4) | NOT NULL | Key of client that owns the account. |
description | nvarchar (240) | NOT NULL | Account description. |
gl_account_number | nvarchar (120) | NOT NULL | The GL account number constructed from releveant account segments and their seperators. |
segment1 | nvarchar (120) | NOT NULL | Account segment 1. |
segment2 | nvarchar (120) | NOT NULL | Account segment 2. |
segment3 | nvarchar (120) | NOT NULL | Account segment 3. |
segment4 | nvarchar (120) | NOT NULL | Account segment 4. |
segment5 | nvarchar (120) | NOT NULL | Account segment 5. |
segment6 | nvarchar (120) | NOT NULL | Account segment 6. |
segment7 | nvarchar (120) | NOT NULL | Account segment 7. |
segment8 | nvarchar (120) | NOT NULL | Account segment 8. |
segment9 | nvarchar (120) | NOT NULL | Account segment 9. |
segment10 | nvarchar (120) | NOT NULL | Account segment 10. |
segment11 | nvarchar (120) | NOT NULL | Account segment 11. |
segment12 | nvarchar (120) | NOT NULL | Account segment 12. |
segment13 | nvarchar (120) | NOT NULL | Account segment 13. |
segment14 | nvarchar (120) | NOT NULL | Account segment 14. |
segment15 | nvarchar (120) | NOT NULL | Account segment 15. |
segment16 | nvarchar (120) | NOT NULL | Account segment 16. |
segment17 | nvarchar (120) | NOT NULL | Account segment 17. |
segment18 | nvarchar (120) | NOT NULL | Account segment 18. |
segment19 | nvarchar (120) | NOT NULL | Account segment 19. |
segment20 | nvarchar (120) | NOT NULL | Account segment 20. |
is_active | bit (1) | NOT NULL | |
gl_account_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row. |
export__quick_books_account_KEY | int (4) | | A foreign key to the Quick_Books_Account table, this is the quickbooks side of the mapping during the Acs to Quickbooks export data mapping process. This will be used to map Accounting CS gl accounts to QuickBooks GL accounts. This key will be null if no export mapping has been done. |
gl_account_number_sortable | nvarchar (244) | NOT NULL | A padded GL account number that allows the Chart of Accounts to be ordered numerically. This computed column will be kept up-to-date with changes made to the GL account number. |
restrict_from_client_access | bit (1) | NOT NULL | To restrict GL Account from Client Access. By default it will not restrict.["BR"] When column restrict_from_client_access is true then the GL account will not appear["BR"] on the Chart of Accounts screen and in any GL account dropdowns for client access. |