Table: dbo.OnBalance_GL_Account
Table to store the mapping data information of chart of accounts for OnBalance.
Columns
Name | Type | Constraints | Description
onbalance_gl_account_KEY | int (4) | NOT NULL | Key which uniquely identify each row of the table.
client_KEY | int (4) | NOT NULL | Client key for which we are importing the OnBalance data.
account_number | nvarchar (120) | NOT NULL | Account number provided in OnBalance.
description | nvarchar (318) | NOT NULL | Description for the chart of account from OnBalance.
gl_account_KEY | int (4) |  | gl_account_key of GL_Account table to which the account number in the OnBalance is mapped to, a null value indicates that it was mapped as Do not import.

Primary key
Name | Columns | Description
PK_OnBalance_GL_Account | onbalance_gl_account_KEY |
Unique constraints
Name | Columns | Description
UK_OnBalance_GL_Account$client_KEY$description | client_KEY, description |

Foreign keys
Name | Columns | Referenced table | Description
FK_OnBalance_GL_Account__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_OnBalance_GL_Account__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |