Table: dbo.OnBalance_GL_Account
Table to store the mapping data information of chart of accounts for OnBalance.
Columns
NameTypeConstraintsDescription
onbalance_gl_account_KEYint (4)NOT NULLKey which uniquely identify each row of the table.
client_KEYint (4)NOT NULLClient key for which we are importing the OnBalance data.
account_numbernvarchar (120)NOT NULLAccount number provided in OnBalance.
descriptionnvarchar (318)NOT NULLDescription for the chart of account from OnBalance.
gl_account_KEYint (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
NameColumnsDescription
PK_OnBalance_GL_Accountonbalance_gl_account_KEY
Unique constraints
NameColumnsDescription
UK_OnBalance_GL_Account$client_KEY$descriptionclient_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_OnBalance_GL_Account__Client__client_KEYclient_KEYClient (client_KEY)
FK_OnBalance_GL_Account__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)

Schema diagram