Budgeting Application Procedures

Budgeting Application Procedures

ProcedureDescription
dbo27.xl_actions_set_doc_role_permissionsThis procedure sets the permissions of user roles for the Database Help Framework.
dbo27.xl_actions_set_log_role_permissionsThis procedure sets the permissions of user roles for the Change Tracking Framework.
dbo27.xl_actions_set_role_permissionsThis procedure sets the default permissions of user roles.
xls27.usp_actual_balancesThis procedure is a form of editing actual opening balances.
xls27.usp_actual_balances_deleteThis procedure deletes rows of xls27.usp_actual_balances.
xls27.usp_actual_balances_insertThis procedure inserts rows of xls27.usp_actual_balances.
xls27.usp_actual_balances_updateThis procedure updates rows of xls27.usp_actual_balances.
xls27.usp_actual_closed_periodsThis procedure is a form to close actual periods for changes.
xls27.usp_actual_closed_periods_changeThis procedure updates a database on cell changes of xls27.usp_actual_closed_periods.
xls27.usp_actual_currency_ratesThis procedure is a form of editing actual currency rates.
xls27.usp_actual_currency_rates_deleteThis procedure deletes rows of xls27.usp_actual_currency_rates.
xls27.usp_actual_currency_rates_insertThis procedure inserts rows of xls27.usp_actual_currency_rates.
xls27.usp_actual_currency_rates_updateThis procedure updates rows of xls27.usp_actual_currency_rates.
xls27.usp_actual_reportsThis procedure selects actual built-in reports.
xls27.usp_balance_sheet_trialThis procedure is a trial balance sheet form.
xls27.usp_budget_balancesThis procedure is a form of editing budget opening balances.
xls27.usp_budget_balances_deleteThis procedure deletes rows of xls27.usp_budget_balances.
xls27.usp_budget_balances_insertThis procedure inserts rows of xls27.usp_budget_balances.
xls27.usp_budget_balances_updateThis procedure updates rows of xls27.usp_budget_balances.
xls27.usp_budget_closed_periodsThis procedure is a form to close budget periods for changes.
xls27.usp_budget_closed_periods_changeThis procedure updates a database on cell changes of xls27.usp_budget_closed_periods.
xls27.usp_budget_currency_ratesThis procedure is a form of editing budget currency rates.
xls27.usp_budget_currency_rates_deleteThis procedure deletes rows of xls27.usp_budget_currency_rates.
xls27.usp_budget_currency_rates_insertThis procedure inserts rows of xls27.usp_budget_currency_rates.
xls27.usp_budget_currency_rates_updateThis procedure updates rows of xls27.usp_budget_currency_rates.
xls27.usp_budget_dataThis procedure selects pivot data of budget requests.
xls27.usp_budget_journalThis procedure selects data of budget requests in a journal form.
xls27.usp_budget_reportsThis procedure selects built-in budget reports.
xls27.usp_budget_reports_rawThis procedure selects built-in budget reports based on budgeting accounts.
xls27.usp_budget_request1This procedure is a budget request form.
xls27.usp_budget_request1_deleteThis procedure deletes rows of xls27.usp_budget_request1.
xls27.usp_budget_request1_insertThis procedure inserts rows of xls27.usp_budget_request1.
xls27.usp_budget_request1_updateThis procedure updates rows of xls27.usp_budget_request1.
xls27.usp_budget_request2This procedure is a budget request form with rearranged columns.
xls27.usp_budget_request2_deleteThis procedure deletes rows of xls27.usp_budget_request2.
xls27.usp_budget_request2_insertThis procedure inserts rows of xls27.usp_budget_request2.
xls27.usp_budget_request2_updateThis procedure updates rows of xls27.usp_budget_request2.
xls27.usp_budget_requestsThis procedure selects a list of budget requests.
xls27.usp_budget_requests_totalsThis procedure selects totals by budgeting accounts in a simple form.
xls27.usp_budgeting_accountsThis procedure is a form of editing budgeting accounts.
xls27.usp_budgeting_accounts_deleteThis procedure deletes rows of xls27.usp_budgeting_accounts.
xls27.usp_budgeting_accounts_insertThis procedure inserts rows of xls27.usp_budgeting_accounts.
xls27.usp_budgeting_accounts_updateThis procedure updates rows of xls27.usp_budgeting_accounts.
xls27.usp_companiesThis procedure is a form of editing companies.
xls27.usp_companies_deleteThis procedure deletes rows of xls27.usp_companies.
xls27.usp_companies_insertThis procedure inserts rows of xls27.usp_companies.
xls27.usp_companies_updateThis procedure updates rows of xls27.usp_companies.
xls27.usp_dimensionsThis procedure is a form of editing dimensions.
xls27.usp_entry_sidesThis procedure is a form of editing entry sides.
xls27.usp_journalThis procedure is a journal form.
xls27.usp_journal_deleteThis procedure deletes rows of xls27.usp_journal.
xls27.usp_journal_insertThis procedure inserts rows of xls27.usp_journal.
xls27.usp_journal_updateThis procedure updates rows of xls27.usp_journal.
xls27.usp_ledger_account_special_typesThis procedure is a form of editing ledger account special types.
xls27.usp_ledger_account_typesThis procedure is a form of editing ledger account types.
xls27.usp_ledger_accountsThis procedure is a form of editing ledger accounts.
xls27.usp_ledger_accounts_deleteThis procedure deletes rows of xls27.usp_ledger_accounts.
xls27.usp_ledger_accounts_insertThis procedure inserts rows of xls27.usp_ledger_accounts.
xls27.usp_ledger_accounts_updateThis procedure updates rows of xls27.usp_ledger_accounts.
xls27.usp_member_permissionsThis procedure is a form to manage user permissions.
xls27.usp_member_permissions_changeThis procedure updates a database on cell changes of xls27.usp_member_permissions.
xls27.usp_member_relationsThis procedure is a form of editing member relations.
xls27.usp_member_relations_changeThis procedure updates a database on cell changes of xls27.usp_member_relations.
xls27.usp_member_typesThis procedure is a form of editing member types.
xls27.usp_membersThis procedure is a form of editing members.
xls27.usp_members_deleteThis procedure deletes rows of xls27.usp_members.
xls27.usp_members_insertThis procedure inserts rows of xls27.usp_members.
xls27.usp_members_updateThis procedure updates rows of xls27.usp_members.
xls27.usp_report_section_accountsThis procedure is a form of editing report section accounts.
xls27.usp_report_section_total_typesThis procedure is a form of editing report section total types.
xls27.usp_report_section_typesThis procedure is a form of editing report section types.
xls27.usp_report_section_value_typesThis procedure is a form of editing report section value types.
xls27.usp_report_sectionsThis procedure is a form of editing report sections.
xls27.usp_report_sections_deleteThis procedure deletes rows of xls27.usp_report_sections.
xls27.usp_report_sections_insertThis procedure inserts rows of xls27.usp_report_sections.
xls27.usp_report_sections_updateThis procedure updates rows of xls27.usp_report_sections.
xls27.usp_report_typesThis procedure is a form of editing report types.
xls27.usp_role_membersThis procedure is a form for managing user roles.
xls27.usp_role_members_changeThis procedure updates a role membership on cell changes of xls27.usp_role_members.
xls27.usp_saved_report_typesThis procedure is a form of editing saved report types.
xls27.usp_saved_report_types_deleteThis procedure deletes rows of xls27.usp_saved_report_types.
xls27.usp_saved_report_types_insertThis procedure inserts rows of xls27.usp_saved_report_types.
xls27.usp_saved_report_types_updateThis procedure updates rows of xls27.usp_saved_report_types.
xls27.usp_saved_reportsThis procedure selects a single saved report.
xls27.usp_saved_reports_deleteThis procedure deletes rows of xls27.usp_budget_report.
xls27.usp_saved_reports_insertThis procedure inserts rows of xls27.usp_budget_report.
xls27.usp_saved_reports_updateThis procedure updates rows of xls27.usp_budget_report.
xls27.usp_subsidiary_accountsThis procedure is a form of editing subsidiary accounts.
xls27.usp_subsidiary_accounts_deleteThis procedure deletes rows of xls27.usp_subsidiary_accounts.
xls27.usp_subsidiary_accounts_insertThis procedure inserts rows of xls27.usp_subsidiary_accounts.
xls27.usp_subsidiary_accounts_updateThis procedure updates rows of xls27.usp_subsidiary_accounts.
xls27.usp_subsidiary_groupsThis procedure is a form of editing subsidiary groups.
xls27.usp_subsidiary_groups_deleteThis procedure deletes rows of xls27.usp_subsidiary_groups.
xls27.usp_subsidiary_groups_insertThis procedure inserts rows of xls27.usp_subsidiary_groups.
xls27.usp_subsidiary_groups_updateThis procedure updates rows of xls27.usp_subsidiary_groups.
xls27.usp_translationsThis procedure is a form of editing company-related translations.
xls27.usp_translations_changeThis procedure updates an element translation on cell changes of xls27.usp_translations.
xls27.usp_translations_commonThis procedure is a form of editing application-level element translations.
xls27.usp_translations_xlsThis procedure is a form of editing actual application-level element translations.
xls27.usp_translations_xls_changeThis procedure updates an application element translation on cell changes of xls27.usp_translations_xls.
xls27.usp_unitsThis procedure is a form of editing units.
xls27.usp_units_deleteThis procedure deletes rows of xls27.usp_units.
xls27.usp_units_insertThis procedure inserts rows of xls27.usp_units.
xls27.usp_units_updateThis procedure updates rows of xls27.usp_units.
xls27.usp_usersThis procedure is a form of editing users.
xls27.usp_users_deleteThis procedure deletes rows of xls27.usp_users.
xls27.usp_users_insertThis procedure inserts rows of xls27.usp_users.
xls27.usp_users_updateThis procedure updates rows of xls27.usp_users.
xls27.usp_vat_ratesThis procedure is a form of editing VAT rates.
xls27.usp_vat_rates_deleteThis procedure deletes rows of xls27.usp_vat_rates.
xls27.usp_vat_rates_insertThis procedure inserts rows of xls27.usp_vat_rates.
xls27.usp_vat_rates_updateThis procedure updates rows of xls27.usp_vat_rates.
xls27.xl_actions_actual_report_cell_dataThis procedure selects underlying data for a reporting cell of actual reports.
xls27.xl_actions_add_languageThis procedure adds a new language for company-related elements.
xls27.xl_actions_auto_calc_allThis procedure creates automatic journal entries using all automation rules.
xls27.xl_actions_auto_close_accountsThis procedure creates automatic journal entries to close accounts at the end of the month.
xls27.xl_actions_auto_currency_transactionsThis procedure creates automatic journal entries related to currency transactions.
xls27.xl_actions_auto_currency_translationThis procedure creates automatic journal entries related to currency translation at the end of the month.
xls27.xl_actions_budget_report_cell_dataThis procedure selects underlying data for a reporting cell of budget reports.
xls27.xl_actions_select_membersThis procedure selects a list of members available to a user.
xls27.xl_parameter_values_category_idThis procedure selects a list of categories for Excel ribbon parameters.
xls27.xl_parameter_values_category_id_not_nullThis procedure selects a list of categories for Excel ribbon parameters except for NULL.
xls27.xl_parameter_values_company_idThis procedure selects a list of companies for Excel ribbon parameters.
xls27.xl_parameter_values_currency_idThis procedure selects a list of currencies for Excel ribbon parameters.
xls27.xl_parameter_values_dayThis procedure selects a list of days for Excel ribbon parameters.
xls27.xl_parameter_values_dimension_idThis procedure selects a list of dimensions for Excel ribbon parameters.
xls27.xl_parameter_values_dimension_id_not_nullThis procedure selects a list of dimensions for Excel ribbon parameters.
xls27.xl_parameter_values_entity_idThis procedure selects a list of entities for Excel ribbon parameters.
xls27.xl_parameter_values_entity_id_not_nullThis procedure selects a list of entities for Excel ribbon parameters except for NULL.
xls27.xl_parameter_values_entry_side_idThis procedure selects a list of entry sides for Excel ribbon parameters.
xls27.xl_parameter_values_ledger_account_id_codeThis procedure selects a list of ledger accounts for Excel ribbon parameters.
xls27.xl_parameter_values_member_type_idThis procedure selects a list of member types for Excel ribbon parameters.
xls27.xl_parameter_values_monthThis procedure selects a list of months for Excel ribbon parameters.
xls27.xl_parameter_values_report_type_idThis procedure selects a list of built-in budget reports for Excel ribbon parameters.
xls27.xl_parameter_values_report_type_id_codeThis procedure selects a list of report types for Excel ribbon parameters.
xls27.xl_parameter_values_saved_report_type_idThis procedure selects a list of saved report types for Excel ribbon parameters.
xls27.xl_parameter_values_subsidiary_account_idThis procedure selects a list of subsidiary accounts for Excel ribbon parameters.
xls27.xl_parameter_values_subsidiary_group_idThis procedure selects a list of subsidiary groups for Excel ribbon parameters.
xls27.xl_parameter_values_time_idThis procedure selects a list of periods for Excel ribbon parameters.
xls27.xl_parameter_values_time_id_not_nullThis procedure selects a list of periods for Excel ribbon parameters except for NULL.
xls27.xl_parameter_values_usernameThis procedure selects a list of usernames for Excel ribbon parameters.
xls27.xl_parameter_values_yearThis procedure selects a list of years for Excel ribbon parameters.
xls27.xl_validation_list_budgeting_account_id_codeThis procedure selects budgeting accounts to use as an Excel validation list source.
xls27.xl_validation_list_budgeting_account_type_idThis procedure selects budgeting account types to use as an Excel validation list source.
xls27.xl_validation_list_budgeting_parent_id_codeThis procedure selects accounts to use as an Excel validation list source of an account parent.
xls27.xl_validation_list_credit_account_id_codeThis procedure selects ledger accounts to use as an Excel validation list source of a credit account.
xls27.xl_validation_list_credit_subsidiary_account_idThis procedure selects subsidiary accounts to use as an Excel validation list source of a credit subsidiary account.
xls27.xl_validation_list_currency_idThis procedure selects currencies to use as an Excel validation list source.
xls27.xl_validation_list_currency_id_codeThis procedure selects currencies to use as an Excel validation list source.
xls27.xl_validation_list_debit_account_id_codeThis procedure selects ledger accounts to use as an Excel validation list source of a debit account.
xls27.xl_validation_list_debit_subsidiary_account_idThis procedure selects subsidiary accounts to use as an Excel validation list source of a debit subsidiary account.
xls27.xl_validation_list_dimension_idThis procedure selects dimensions to use as an Excel validation list source.
xls27.xl_validation_list_entity_idThis procedure selects entities to use as an Excel validation list source.
xls27.xl_validation_list_entity_id_codeThis procedure selects entities to use as an Excel validation list source.
xls27.xl_validation_list_entry_side_idThis procedure selects entry sides to use as an Excel validation list source.
xls27.xl_validation_list_ledger_account_idThis procedure selects ledger accounts to use as an Excel validation list source.
xls27.xl_validation_list_ledger_account_id_codeThis procedure selects ledger accounts to use as an Excel validation list source.
xls27.xl_validation_list_ledger_account_special_type_idThis procedure selects ledger account special types to use as an Excel validation list source.
xls27.xl_validation_list_ledger_account_type_idThis procedure selects ledger account types to use as an Excel validation list source.
xls27.xl_validation_list_member_type_idThis procedure selects member types to use as an Excel validation list source.
xls27.xl_validation_list_product_idThis procedure selects products to use as an Excel validation list source.
xls27.xl_validation_list_product_id_codeThis procedure selects products to use as an Excel validation list source.
xls27.xl_validation_list_region_idThis procedure selects regions to use as an Excel validation list source.
xls27.xl_validation_list_region_id_codeThis procedure selects regions to use as an Excel validation list source.
xls27.xl_validation_list_report_section_idThis procedure selects report sections to use as an Excel validation list source.
xls27.xl_validation_list_report_section_total_type_idThis procedure selects report section total types to use as an Excel validation list source.
xls27.xl_validation_list_report_section_type_idThis procedure selects report section types to use as an Excel validation list source.
xls27.xl_validation_list_report_section_value_type_idThis procedure selects report section value types to use as an Excel validation list source.
xls27.xl_validation_list_report_type_id_codeThis procedure selects reports to use as an Excel validation list source.
xls27.xl_validation_list_subsidiary_account_idThis procedure selects subsidiary accounts to use as an Excel validation list source.
xls27.xl_validation_list_subsidiary_account_id_codeThis procedure selects subsidiary accounts to use as an Excel validation list source.
xls27.xl_validation_list_subsidiary_group_idThis procedure selects subsidiary account groups to use as an Excel validation list source.
xls27.xl_validation_list_unit_idThis procedure selects units to use as an Excel validation list source.
xls27.xl_validation_list_unit_id_codeThis procedure selects units to use as an Excel validation list source.
xls27.xl_validation_list_vat_rate_idThis procedure selects vat_rates to use as an Excel validation list source.

dbo27.xl_actions_set_doc_role_permissions

This procedure sets the permissions of user roles for the Database Help Framework.

Execute this procedure after installation of the Database Help Framework.

dbo27.xl_actions_set_log_role_permissions

This procedure sets the permissions of user roles for the Change Tracking Framework.

Execute this procedure after installation of the Change Tracking Framework.

dbo27.xl_actions_set_role_permissions

This procedure sets the default permissions of user roles.

Execute this procedure if you recreated any table of the dbo27 schema.

xls27.usp_actual_balances

This procedure is a form of editing actual opening balances.

ParameterDataTypeModeComment
@company_idintINdbo27.actual_balances.company_id
@data_languagevarchar(10)INContext data language

Source table: dbo27.actual_balances

xls27.usp_actual_balances_delete

This procedure deletes rows of xls27.usp_actual_balances.

ParameterDataTypeModeComment
@account_idintINdbo27.actual_balances.account_id
@subsidiary_account_idintINdbo27.actual_balances.subsidiary_account_id
@data_languagevarchar(10)INContext data language

xls27.usp_actual_balances_insert

This procedure inserts rows of xls27.usp_actual_balances.

ParameterDataTypeModeComment
@account_idintINdbo27.actual_balances.account_id
@subsidiary_account_idintINdbo27.actual_balances.subsidiary_account_id
@debitfloatINdbo27.actual_balances.debit
@creditfloatINdbo27.actual_balances.credit

xls27.usp_actual_balances_update

This procedure updates rows of xls27.usp_actual_balances.

ParameterDataTypeModeComment
@account_idintINdbo27.actual_balances.account_id
@subsidiary_account_idintINdbo27.actual_balances.subsidiary_account_id
@debitfloatINdbo27.actual_balances.debit
@creditfloatINdbo27.actual_balances.credit
@data_languagevarchar(10)INContext data language

xls27.usp_actual_closed_periods

This procedure is a form to close actual periods for changes.

ParameterDataTypeModeComment
@company_idintINdbo27.actual_closed_periods.company_id

Source table: dbo27.actual_closed_periods

xls27.usp_actual_closed_periods_change

This procedure updates a database on cell changes of xls27.usp_actual_closed_periods.

ParameterDataTypeModeComment
@column_namenvarchar(128)INThe value must be is_closed
@cell_number_valueintIN1 - close the period
0 - open the period
@company_idintINdbo27.actual_closed_periods.company_id
@datedateINdbo27.actual_closed_periods.date

xls27.usp_actual_currency_rates

This procedure is a form of editing actual currency rates.

ParameterDataTypeModeComment
@company_idintINdbo27.actual_currency_rates.company_id
@currency_idintINdbo27.actual_currency_rates.currency_id

Source table: dbo27.actual_currency_rates

xls27.usp_actual_currency_rates_delete

This procedure deletes rows of xls27.usp_actual_currency_rates.

ParameterDataTypeModeComment
@currency_idtinyintINdbo27.actual_currency_rates.currency_id
@datedateINdbo27.actual_currency_rates.date
@data_languagevarchar(10)INContext data language

xls27.usp_actual_currency_rates_insert

This procedure inserts rows of xls27.usp_actual_currency_rates.

ParameterDataTypeModeComment
@currency_idintINdbo27.actual_currency_rates.currency_id
@datedateINdbo27.actual_currency_rates.date
@ratesmallmoneyINdbo27.actual_currency_rates.rate

xls27.usp_actual_currency_rates_update

This procedure updates rows of xls27.usp_actual_currency_rates.

ParameterDataTypeModeComment
@currency_idintINdbo27.actual_currency_rates.currency_id
@datedateINdbo27.actual_currency_rates.date
@ratesmallmoneyINdbo27.actual_currency_rates.rate
@data_languagevarchar(10)INContext data language

xls27.usp_actual_reports

This procedure selects actual built-in reports.

ParameterDataTypeModeComment
@company_idintINdbo27.companies.id
@yearintINYear
@entity_idintINdbo27.journals.entity_id
@report_idintINdbo27.report_types.id
@unitintIN1 - actual figures
1000 - in thousands
1000000 - in millions
@data_languagevarchar(10)INContext data language

This reports use data from dbo27.journals, dbo27.actual_balances, and dbo27.actual_currency_rates and the configuration from dbo27.ledger_accounts, dbo27.ledger_account_types, and dbo27.members.

xls27.usp_balance_sheet_trial

This procedure is a trial balance sheet form.

ParameterDataTypeModeComment
@start_yearintINStart year
@start_monthintINStart month
@start_dayintINStart day
@end_yearintINEnd year
@end_monthintINEnd month
@end_dayintINEnd day
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

We recommend creating different table views in Excel to customize the required views.

xls27.usp_budget_balances

This procedure is a form of editing budget opening balances.

ParameterDataTypeModeComment
@company_idintINdbo27.budget_balances.company_id
@category_idintINdbo27.budget_balances.category_id
@time_idintINdbo27.budget_balances.time_id
@data_languagevarchar(10)INContext data language

Source table: dbo27.budget_balances

xls27.usp_budget_balances_delete

This procedure deletes rows of xls27.usp_budget_balances.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_balances.category_id
@time_idintINdbo27.budget_balances.time_id
@account_idintINdbo27.budget_balances.account_id

xls27.usp_budget_balances_insert

This procedure inserts rows of xls27.usp_budget_balances.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_balances.category_id
@time_idintINdbo27.budget_balances.time_id
@account_idintINdbo27.budget_balances.account_id
@debitmoneyINdbo27.budget_balances.debit
@creditmoneyINdbo27.budget_balances.credit

xls27.usp_budget_balances_update

This procedure updates rows of xls27.usp_budget_balances.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_balances.category_id
@time_idintINdbo27.budget_balances.time_id
@account_idintINdbo27.budget_balances.account_id
@debitmoneyINdbo27.budget_balances.debit
@creditmoneyINdbo27.budget_balances.credit

xls27.usp_budget_closed_periods

This procedure is a form to close budget periods for changes.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id

Source table: dbo27.member_relations

xls27.usp_budget_closed_periods_change

This procedure updates a database on cell changes of xls27.usp_budget_closed_periods.

ParameterDataTypeModeComment
@column_namenvarchar(128)INdbo27.members.code used to find dbo27.member_relations.partner_id
@cell_number_valueintINdbo25.member_relations.update_permission: 0 or 1
@idintINdbo27.member_relations.member_id
@data_languagevarchar(10)INContext data language

xls27.usp_budget_currency_rates

This procedure is a form of editing budget currency rates.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_currency_rates.category_id
@time_idintINdbo27.budget_currency_rates.time_id
@data_languagevarchar(10)INContext data language

Source table: dbo27.budget_currency_rates

xls27.usp_budget_currency_rates_delete

This procedure deletes rows of xls27.usp_budget_currency_rates.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_currency_rates.category_id
@time_idintINdbo27.budget_currency_rates.time_id
@unit_idintINdbo27.budget_currency_rates.unit_id

xls27.usp_budget_currency_rates_insert

This procedure inserts rows of xls27.usp_budget_currency_rates.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_currency_rates.category_id
@time_idintINdbo27.budget_currency_rates.time_id
@unit_idintINdbo27.budget_currency_rates.unit_id
@balance00smallmoneyINdbo27.budget_currency_rates.balance00
@period01smallmoneyINdbo27.budget_currency_rates.period01
@balance01smallmoneyINdbo27.budget_currency_rates.balance01
@period02smallmoneyINdbo27.budget_currency_rates.period02
@balance02smallmoneyINdbo27.budget_currency_rates.balance02
@period03smallmoneyINdbo27.budget_currency_rates.period03
@balance03smallmoneyINdbo27.budget_currency_rates.balance03
@period04smallmoneyINdbo27.budget_currency_rates.period04
@balance04smallmoneyINdbo27.budget_currency_rates.balance04
@period05smallmoneyINdbo27.budget_currency_rates.period05
@balance05smallmoneyINdbo27.budget_currency_rates.balance05
@period06smallmoneyINdbo27.budget_currency_rates.period06
@balance06smallmoneyINdbo27.budget_currency_rates.balance06
@period07smallmoneyINdbo27.budget_currency_rates.period07
@balance07smallmoneyINdbo27.budget_currency_rates.balance07
@period08smallmoneyINdbo27.budget_currency_rates.period08
@balance08smallmoneyINdbo27.budget_currency_rates.balance08
@period09smallmoneyINdbo27.budget_currency_rates.period09
@balance09smallmoneyINdbo27.budget_currency_rates.balance09
@period10smallmoneyINdbo27.budget_currency_rates.period10
@balance10smallmoneyINdbo27.budget_currency_rates.balance10
@period11smallmoneyINdbo27.budget_currency_rates.period11
@balance11smallmoneyINdbo27.budget_currency_rates.balance11
@period12smallmoneyINdbo27.budget_currency_rates.period12
@balance12smallmoneyINdbo27.budget_currency_rates.balance12
@row_formulasnvarchar(max)INdbo27.budget_currency_rates.row_formulas

xls27.usp_budget_currency_rates_update

This procedure updates rows of xls27.usp_budget_currency_rates.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_currency_rates.category_id
@time_idintINdbo27.budget_currency_rates.time_id
@unit_idintINdbo27.budget_currency_rates.unit_id
@balance00smallmoneyINdbo27.budget_currency_rates.balance00
@period01smallmoneyINdbo27.budget_currency_rates.period01
@balance01smallmoneyINdbo27.budget_currency_rates.balance01
@period02smallmoneyINdbo27.budget_currency_rates.period02
@balance02smallmoneyINdbo27.budget_currency_rates.balance02
@period03smallmoneyINdbo27.budget_currency_rates.period03
@balance03smallmoneyINdbo27.budget_currency_rates.balance03
@period04smallmoneyINdbo27.budget_currency_rates.period04
@balance04smallmoneyINdbo27.budget_currency_rates.balance04
@period05smallmoneyINdbo27.budget_currency_rates.period05
@balance05smallmoneyINdbo27.budget_currency_rates.balance05
@period06smallmoneyINdbo27.budget_currency_rates.period06
@balance06smallmoneyINdbo27.budget_currency_rates.balance06
@period07smallmoneyINdbo27.budget_currency_rates.period07
@balance07smallmoneyINdbo27.budget_currency_rates.balance07
@period08smallmoneyINdbo27.budget_currency_rates.period08
@balance08smallmoneyINdbo27.budget_currency_rates.balance08
@period09smallmoneyINdbo27.budget_currency_rates.period09
@balance09smallmoneyINdbo27.budget_currency_rates.balance09
@period10smallmoneyINdbo27.budget_currency_rates.period10
@balance10smallmoneyINdbo27.budget_currency_rates.balance10
@period11smallmoneyINdbo27.budget_currency_rates.period11
@balance11smallmoneyINdbo27.budget_currency_rates.balance11
@period12smallmoneyINdbo27.budget_currency_rates.period12
@balance12smallmoneyINdbo27.budget_currency_rates.balance12
@row_formulasnvarchar(max)INdbo27.budget_currency_rates.row_formulas

xls27.usp_budget_data

This procedure selects pivot data of budget requests.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id

Use this procedure to get data for custom reports.

xls27.usp_budget_journal

This procedure selects data of budget requests in a journal form.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@subsidiary_account_idintINdbo27.budget_requests.subsidiary_account_id
@region_idintINdbo27.budget_requests.region_id
@product_idintINdbo27.budget_requests.product_id
@first_monthintINFirst month
@last_monthintINLast month

To use this form, customize ledger and budgeting accounts using the xls27.usp_ledger_accounts and xls27.usp_budgeting_accounts procedures.

xls27.usp_budget_reports

This procedure selects built-in budget reports.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@report_idintINdbo27.reports.id
@unitintIN1 - actual figures
1000 - in thousands
1000000 - in millions
@data_languagevarchar(10)INContext data language

To use this form, customize ledger and budgeting accounts using the xls27.usp_ledger_accounts and xls27.usp_budgeting_accounts procedures.

xls27.usp_budget_reports_raw

This procedure selects built-in budget reports based on budgeting accounts.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@subsidiary_account_idintINdbo27.budget_requests.subsidiary_account_id
@region_idintINdbo27.budget_requests.region_id
@product_idintINdbo27.budget_requests.product_id
@report_idintINNot used
@leveltinyintINBudgeting account level
@unitintIN1 - actual figures
1000 - in thousands
1000000 - in millions
@data_languagevarchar(10)INContext data language

Contrary to xls27.usp_budget_reports, this procedure does not use settings of budgeting accounts.

xls27.usp_budget_request1

This procedure is a budget request form.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@rowsintINdbo27.budget_requests.rows
@data_languagevarchar(10)INContext data language

Note that users may use Excel formulas in the form.

xls27.usp_budget_request1_delete

This procedure deletes rows of xls27.usp_budget_request1.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@rownumintINdbo27.budget_requests.row_index
@row_indexintINdbo27.budget_requests.row_index
@transaction_start_timedatetimeINdbo27.budget_requests.transaction_start_time

xls27.usp_budget_request1_insert

This procedure inserts rows of xls27.usp_budget_request1.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@rownumintINdbo27.budget_requests.row_index
@row_indexintINdbo27.budget_requests.row_index
@row_formatintINdbo27.budget_requests.row_format
@descriptionnvarchar(255)INdbo27.budget_requests.comment
@account_idintINdbo27.budget_requests.account_id
@subsidiary_account_idintINdbo27.budget_requests.subsidiary_account_id
@region_idintINdbo27.budget_requests.region_id
@product_idintINdbo27.budget_requests.product_id
@vat_rate_idintINdbo27.budget_requests.vat_rate_id
@unit_idintINdbo27.budget_requests.unit_id
@total_paymentsmoneyINdbo27.budget_requests.total_payments
@total_chargesmoneyINdbo27.budget_requests.total_charges
@balance00moneyINdbo27.budget_requests.balance00
@payments01moneyINdbo27.budget_requests.payments01
@charges01moneyINdbo27.budget_requests.charges01
@balance01moneyINdbo27.budget_requests.balance01
@payments02moneyINdbo27.budget_requests.payments02
@charges02moneyINdbo27.budget_requests.charges02
@balance02moneyINdbo27.budget_requests.balance02
@payments03moneyINdbo27.budget_requests.payments03
@charges03moneyINdbo27.budget_requests.charges03
@balance03moneyINdbo27.budget_requests.balance03
@payments04moneyINdbo27.budget_requests.payments04
@charges04moneyINdbo27.budget_requests.charges04
@balance04moneyINdbo27.budget_requests.balance04
@payments05moneyINdbo27.budget_requests.payments05
@charges05moneyINdbo27.budget_requests.charges05
@balance05moneyINdbo27.budget_requests.balance05
@payments06moneyINdbo27.budget_requests.payments06
@charges06moneyINdbo27.budget_requests.charges06
@balance06moneyINdbo27.budget_requests.balance06
@payments07moneyINdbo27.budget_requests.payments07
@charges07moneyINdbo27.budget_requests.charges07
@balance07moneyINdbo27.budget_requests.balance07
@payments08moneyINdbo27.budget_requests.payments08
@charges08moneyINdbo27.budget_requests.charges08
@balance08moneyINdbo27.budget_requests.balance08
@payments09moneyINdbo27.budget_requests.payments09
@charges09moneyINdbo27.budget_requests.charges09
@balance09moneyINdbo27.budget_requests.balance09
@payments10moneyINdbo27.budget_requests.payments10
@charges10moneyINdbo27.budget_requests.charges10
@balance10moneyINdbo27.budget_requests.balance10
@payments11moneyINdbo27.budget_requests.payments11
@charges11moneyINdbo27.budget_requests.charges11
@balance11moneyINdbo27.budget_requests.balance11
@payments12moneyINdbo27.budget_requests.payments12
@charges12moneyINdbo27.budget_requests.charges12
@balance12moneyINdbo27.budget_requests.balance12
@row_formulasnvarchar(max)INdbo27.budget_requests.row_formulas
@row_commentsnvarchar(max)IN
@transaction_start_timedatetimeINdbo27.budget_requests.transaction_start_time

xls27.usp_budget_request1_update

This procedure updates rows of xls27.usp_budget_request1.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@rownumintINdbo27.budget_requests.row_index
@row_indexintINdbo27.budget_requests.row_index
@row_formatintINdbo27.budget_requests.row_format
@descriptionnvarchar(255)INdbo27.budget_requests.comment
@account_idintINdbo27.budget_requests.account_id
@subsidiary_account_idintINdbo27.budget_requests.subsidiary_account_id
@region_idintINdbo27.budget_requests.region_id
@product_idintINdbo27.budget_requests.product_id
@vat_rate_idtinyintINdbo27.budget_requests.vat_rate_id
@unit_idintINdbo27.budget_requests.unit_id
@total_paymentsfloatINdbo27.budget_requests.total_payments
@total_chargesfloatINdbo27.budget_requests.total_charges
@balance00floatINdbo27.budget_requests.balance00
@payments01floatINdbo27.budget_requests.payments01
@charges01floatINdbo27.budget_requests.charges01
@balance01floatINdbo27.budget_requests.balance01
@payments02floatINdbo27.budget_requests.payments02
@charges02floatINdbo27.budget_requests.charges02
@balance02floatINdbo27.budget_requests.balance02
@payments03floatINdbo27.budget_requests.payments03
@charges03floatINdbo27.budget_requests.charges03
@balance03floatINdbo27.budget_requests.balance03
@payments04floatINdbo27.budget_requests.payments04
@charges04floatINdbo27.budget_requests.charges04
@balance04floatINdbo27.budget_requests.balance04
@payments05floatINdbo27.budget_requests.payments05
@charges05floatINdbo27.budget_requests.charges05
@balance05floatINdbo27.budget_requests.balance05
@payments06floatINdbo27.budget_requests.payments06
@charges06floatINdbo27.budget_requests.charges06
@balance06floatINdbo27.budget_requests.balance06
@payments07floatINdbo27.budget_requests.payments07
@charges07floatINdbo27.budget_requests.charges07
@balance07floatINdbo27.budget_requests.balance07
@payments08floatINdbo27.budget_requests.payments08
@charges08floatINdbo27.budget_requests.charges08
@balance08floatINdbo27.budget_requests.balance08
@payments09floatINdbo27.budget_requests.payments09
@charges09floatINdbo27.budget_requests.charges09
@balance09floatINdbo27.budget_requests.balance09
@payments10floatINdbo27.budget_requests.payments10
@charges10floatINdbo27.budget_requests.charges10
@balance10floatINdbo27.budget_requests.balance10
@payments11floatINdbo27.budget_requests.payments11
@charges11floatINdbo27.budget_requests.charges11
@balance11floatINdbo27.budget_requests.balance11
@payments12floatINdbo27.budget_requests.payments12
@charges12floatINdbo27.budget_requests.charges12
@balance12floatINdbo27.budget_requests.balance12
@row_formulasnvarchar(max)INdbo27.budget_requests.row_formulas
@row_commentsnvarchar(max)IN
@transaction_start_timedatetimeINdbo27.budget_requests.transaction_start_time
@is_insertbitINdbo27.budget_requests.is_insert

xls27.usp_budget_request2

This procedure is a budget request form with rearranged columns.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@rowsintINdbo27.budget_requests.rows
@data_languagevarchar(10)INContext data language

Note that users may use Excel formulas in the form.

xls27.usp_budget_request2_delete

This procedure deletes rows of xls27.usp_budget_request2.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@rownumintINdbo27.budget_requests.row_index
@row_indexintINdbo27.budget_requests.row_index
@transaction_start_timedatetimeINdbo27.budget_requests.transaction_start_time

xls27.usp_budget_request2_insert

This procedure inserts rows of xls27.usp_budget_request2.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@rownumintINdbo27.budget_requests.row_index
@row_indexintINdbo27.budget_requests.row_index
@row_formatintINdbo27.budget_requests.row_format
@descriptionnvarchar(255)INdbo27.budget_requests.comment
@account_idintINdbo27.budget_requests.account_id
@subsidiary_account_idintINdbo27.budget_requests.subsidiary_account_id
@region_idintINdbo27.budget_requests.region_id
@product_idintINdbo27.budget_requests.product_id
@vat_rate_idintINdbo27.budget_requests.vat_rate_id
@unit_idintINdbo27.budget_requests.unit_id
@total_paymentsmoneyINdbo27.budget_requests.total_payments
@total_chargesmoneyINdbo27.budget_requests.total_charges
@balance00moneyINdbo27.budget_requests.balance00
@payments01moneyINdbo27.budget_requests.payments01
@charges01moneyINdbo27.budget_requests.charges01
@balance01moneyINdbo27.budget_requests.balance01
@payments02moneyINdbo27.budget_requests.payments02
@charges02moneyINdbo27.budget_requests.charges02
@balance02moneyINdbo27.budget_requests.balance02
@payments03moneyINdbo27.budget_requests.payments03
@charges03moneyINdbo27.budget_requests.charges03
@balance03moneyINdbo27.budget_requests.balance03
@payments04moneyINdbo27.budget_requests.payments04
@charges04moneyINdbo27.budget_requests.charges04
@balance04moneyINdbo27.budget_requests.balance04
@payments05moneyINdbo27.budget_requests.payments05
@charges05moneyINdbo27.budget_requests.charges05
@balance05moneyINdbo27.budget_requests.balance05
@payments06moneyINdbo27.budget_requests.payments06
@charges06moneyINdbo27.budget_requests.charges06
@balance06moneyINdbo27.budget_requests.balance06
@payments07moneyINdbo27.budget_requests.payments07
@charges07moneyINdbo27.budget_requests.charges07
@balance07moneyINdbo27.budget_requests.balance07
@payments08moneyINdbo27.budget_requests.payments08
@charges08moneyINdbo27.budget_requests.charges08
@balance08moneyINdbo27.budget_requests.balance08
@payments09moneyINdbo27.budget_requests.payments09
@charges09moneyINdbo27.budget_requests.charges09
@balance09moneyINdbo27.budget_requests.balance09
@payments10moneyINdbo27.budget_requests.payments10
@charges10moneyINdbo27.budget_requests.charges10
@balance10moneyINdbo27.budget_requests.balance10
@payments11moneyINdbo27.budget_requests.payments11
@charges11moneyINdbo27.budget_requests.charges11
@balance11moneyINdbo27.budget_requests.balance11
@payments12moneyINdbo27.budget_requests.payments12
@charges12moneyINdbo27.budget_requests.charges12
@balance12moneyINdbo27.budget_requests.balance12
@row_formulasnvarchar(max)INdbo27.budget_requests.row_formulas
@row_commentsnvarchar(max)IN
@transaction_start_timedatetimeINdbo27.budget_requests.transaction_start_time

xls27.usp_budget_request2_update

This procedure updates rows of xls27.usp_budget_request2.

ParameterDataTypeModeComment
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@rownumintINdbo27.budget_requests.row_index
@row_indexintINdbo27.budget_requests.row_index
@row_formatintINdbo27.budget_requests.row_format
@descriptionnvarchar(255)INdbo27.budget_requests.comment
@account_idintINdbo27.budget_requests.account_id
@subsidiary_account_idintINdbo27.budget_requests.subsidiary_account_id
@region_idintINdbo27.budget_requests.region_id
@product_idintINdbo27.budget_requests.product_id
@vat_rate_idtinyintINdbo27.budget_requests.vat_rate_id
@unit_idintINdbo27.budget_requests.unit_id
@total_paymentsmoneyINdbo27.budget_requests.total_payments
@total_chargesmoneyINdbo27.budget_requests.total_charges
@balance00moneyINdbo27.budget_requests.balance00
@payments01moneyINdbo27.budget_requests.payments01
@charges01moneyINdbo27.budget_requests.charges01
@balance01moneyINdbo27.budget_requests.balance01
@payments02moneyINdbo27.budget_requests.payments02
@charges02moneyINdbo27.budget_requests.charges02
@balance02moneyINdbo27.budget_requests.balance02
@payments03moneyINdbo27.budget_requests.payments03
@charges03moneyINdbo27.budget_requests.charges03
@balance03moneyINdbo27.budget_requests.balance03
@payments04moneyINdbo27.budget_requests.payments04
@charges04moneyINdbo27.budget_requests.charges04
@balance04moneyINdbo27.budget_requests.balance04
@payments05moneyINdbo27.budget_requests.payments05
@charges05moneyINdbo27.budget_requests.charges05
@balance05moneyINdbo27.budget_requests.balance05
@payments06moneyINdbo27.budget_requests.payments06
@charges06moneyINdbo27.budget_requests.charges06
@balance06moneyINdbo27.budget_requests.balance06
@payments07moneyINdbo27.budget_requests.payments07
@charges07moneyINdbo27.budget_requests.charges07
@balance07moneyINdbo27.budget_requests.balance07
@payments08moneyINdbo27.budget_requests.payments08
@charges08moneyINdbo27.budget_requests.charges08
@balance08moneyINdbo27.budget_requests.balance08
@payments09moneyINdbo27.budget_requests.payments09
@charges09moneyINdbo27.budget_requests.charges09
@balance09moneyINdbo27.budget_requests.balance09
@payments10moneyINdbo27.budget_requests.payments10
@charges10moneyINdbo27.budget_requests.charges10
@balance10moneyINdbo27.budget_requests.balance10
@payments11moneyINdbo27.budget_requests.payments11
@charges11moneyINdbo27.budget_requests.charges11
@balance11moneyINdbo27.budget_requests.balance11
@payments12moneyINdbo27.budget_requests.payments12
@charges12moneyINdbo27.budget_requests.charges12
@balance12moneyINdbo27.budget_requests.balance12
@row_formulasnvarchar(max)INdbo27.budget_requests.row_formulas
@row_commentsnvarchar(max)IN
@transaction_start_timedatetimeINdbo27.budget_requests.transaction_start_time
@is_insertbitINdbo27.budget_requests.is_insert

xls27.usp_budget_requests

This procedure selects a list of budget requests.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@data_languagevarchar(10)INContext data language

Use this form to check and manage budget requests.

xls27.usp_budget_requests_totals

This procedure selects totals by budgeting accounts in a simple form.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@subsidiary_account_idintINdbo27.budget_requests.subsidiary_account_id
@region_idintINdbo27.budget_requests.region_id
@product_idintINdbo27.budget_requests.product_id
@first_monthintINFirst month
@last_monthintINLast month
@unitintIN1 - actual figures
1000 - in thousands
1000000 - in millions
@data_languagevarchar(10)INContext data language

Contrary to budget reports, this form shows all data on one page.

Use it to check and drill-down data of budget requests.

xls27.usp_budgeting_accounts

This procedure is a form of editing budgeting accounts.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@account_type_idtinyintINdbo27.members.account_type_id
@is_in_budgetbitIN1 - select accounts shown in budget requests
0 - select accounts that are not shown in budget requests
NULL - select all accounts
@is_activebitINdbo27.members.is_active
@data_languagevarchar(10)INContext data language

The application stores budgeting accounts in the dbo27.members table with dimension_id = 1.

Contrary to xls27.usp_members, this form selects fields specific for budgeting accounts.

Source table: dbo27.members

xls27.usp_budgeting_accounts_delete

This procedure deletes rows of xls27.usp_budgeting_accounts.

ParameterDataTypeModeComment
@idintINdbo27.members.id

xls27.usp_budgeting_accounts_insert

This procedure inserts rows of xls27.usp_budgeting_accounts.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@codenvarchar(50)INdbo27.members.code
@namenvarchar(100)INdbo27.members.name
@translated_namenvarchar(100)INdbo27.translations.name
@parent_idintINdbo27.members.parent_id
@unit_idintINdbo27.members.unit_id
@vat_rate_idintINdbo27.members.vat_rate_id
@account_type_idintINdbo27.members.account_type_id
@payment_debit_idintINdbo27.members.payment_debit_id
@payment_credit_idintINdbo27.members.payment_credit_id
@charge_debit_idintINdbo27.members.charge_debit_id
@charge_credit_idintINdbo27.members.charge_credit_id
@vat_debit_idintINdbo27.members.vat_debit_id
@vat_credit_idintINdbo27.members.vat_credit_id
@is_activebitINdbo27.members.is_active
@data_languagevarchar(10)INContext data language

xls27.usp_budgeting_accounts_update

This procedure updates rows of xls27.usp_budgeting_accounts.

ParameterDataTypeModeComment
@idintINdbo27.members.id
@codenvarchar(50)INdbo27.members.code
@namenvarchar(100)INdbo27.members.name
@translated_namenvarchar(100)INdbo27.translations.name
@parent_idintINdbo27.members.parent_id
@unit_idintINdbo27.members.unit_id
@vat_rate_idintINdbo27.members.vat_rate_id
@account_type_idintINdbo27.members.account_type_id
@payment_debit_idintINdbo27.members.payment_debit_id
@payment_credit_idintINdbo27.members.payment_credit_id
@charge_debit_idintINdbo27.members.charge_debit_id
@charge_credit_idintINdbo27.members.charge_credit_id
@vat_debit_idintINdbo27.members.vat_debit_id
@vat_credit_idintINdbo27.members.vat_credit_id
@is_activebitINdbo27.members.is_active
@data_languagevarchar(10)INContext data language

xls27.usp_companies

This procedure is a form of editing companies.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Source table: dbo27.companies

xls27.usp_companies_delete

This procedure deletes rows of xls27.usp_companies.

ParameterDataTypeModeComment
@idintINdbo27.companies.id

xls27.usp_companies_insert

This procedure inserts rows of xls27.usp_companies.

ParameterDataTypeModeComment
@codenvarchar(50)INdbo27.companies.code
@namenvarchar(100)INdbo27.companies.name
@translated_namenvarchar(100)INdbo27.translations.name
@default_languagevarchar(10)INdbo27.companies.default_language
@sort_orderintINdbo27.companies.sort_order
@data_languagevarchar(10)INContext data language

xls27.usp_companies_update

This procedure updates rows of xls27.usp_companies.

ParameterDataTypeModeComment
@idintINdbo27.companies.id
@codenvarchar(50)INdbo27.companies.code
@namenvarchar(100)INdbo27.companies.name
@translated_namenvarchar(100)INdbo27.translations.name
@default_languagevarchar(10)INdbo27.companies.default_language
@sort_orderintINdbo27.companies.sort_order
@data_languagevarchar(10)INContext data language

xls27.usp_dimensions

This procedure is a form of editing dimensions.

Source table: dbo27.dimensions

xls27.usp_entry_sides

This procedure is a form of editing entry sides.

Source table: dbo27.entry_sides

xls27.usp_journal

This procedure is a journal form.

ParameterDataTypeModeComment
@start_yearintINStart year
@start_monthintINStart month
@start_dayintINStart day
@end_yearintINEnd year
@end_monthintINEnd month
@end_dayintINEnd day
@company_idintINdbo27.journals.company_id
@account_idintINdbo27.journals.debit_account_id or dbo27.journals.credit_account_id
@subsidiary_account_idintINdbo27.journals.debit_subsidiary_account_id or dbo27.journals.credit_subsidiary_account_id
@entity_idintINdbo27.journals.entity_id
@region_idintINdbo27.journals.region_id
@product_idintINdbo27.journals.product_id

Source table: dbo27.journals

xls27.usp_journal_delete

This procedure deletes rows of xls27.usp_journal.

ParameterDataTypeModeComment
@idintINdbo27.journals.id
@data_languagevarchar(10)INContext data language

xls27.usp_journal_insert

This procedure inserts rows of xls27.usp_journal.

ParameterDataTypeModeComment
@company_idintINdbo27.journals.company_id
@datedateINdbo27.journals.date
@amountmoneyINdbo27.journals.amount
@descriptionnvarchar(255)INdbo27.journals.description
@debit_account_idintINdbo27.journals.debit_account_id
@debit_subsidiary_account_idintINdbo27.journals.debit_subsidiary_account_id
@credit_account_idintINdbo27.journals.credit_account_id
@credit_subsidiary_account_idintINdbo27.journals.credit_subsidiary_account_id
@entity_idintINdbo27.journals.entity_id
@account_idintINdbo27.journals.account_id
@region_idintINdbo27.journals.region_id
@product_idintINdbo27.journals.product_id
@is_draftbitINdbo27.journals.is_draft

xls27.usp_journal_update

This procedure updates rows of xls27.usp_journal.

ParameterDataTypeModeComment
@idintINdbo27.journals.id
@company_idintINdbo27.journals.company_id
@datedateINdbo27.journals.date
@amountmoneyINdbo27.journals.amount
@descriptionnvarchar(255)INdbo27.journals.description
@debit_account_idintINdbo27.journals.debit_account_id
@debit_subsidiary_account_idintINdbo27.journals.debit_subsidiary_account_id
@credit_account_idintINdbo27.journals.credit_account_id
@credit_subsidiary_account_idintINdbo27.journals.credit_subsidiary_account_id
@entity_idintINdbo27.journals.entity_id
@account_idintINdbo27.journals.account_id
@region_idintINdbo27.journals.region_id
@product_idintINdbo27.journals.product_id
@is_draftbitINdbo27.journals.is_draft
@data_languagevarchar(10)INContext data language

xls27.usp_ledger_account_special_types

This procedure is a form of editing ledger account special types.

Source table: dbo27.ledger_account_special_types

xls27.usp_ledger_account_types

This procedure is a form of editing ledger account types.

Source table: dbo27.ledger_account_types

xls27.usp_ledger_accounts

This procedure is a form of editing ledger accounts.

ParameterDataTypeModeComment
@company_idintINdbo27.ledger_accounts.company_id
@data_languagevarchar(10)INContext data language

Source table: dbo27.ledger_accounts

xls27.usp_ledger_accounts_delete

This procedure deletes rows of xls27.usp_ledger_accounts.

ParameterDataTypeModeComment
@idintINdbo27.ledger_accounts.id

xls27.usp_ledger_accounts_insert

This procedure inserts rows of xls27.usp_ledger_accounts.

ParameterDataTypeModeComment
@company_idintINdbo27.ledger_accounts.company_id
@codenvarchar(50)INdbo27.ledger_accounts.code
@namenvarchar(100)INdbo27.ledger_accounts.name
@translated_namenvarchar(100)INdbo27.translations.name
@parent_idintINdbo27.ledger_accounts.parent_id
@account_type_idtinyintINdbo27.ledger_accounts.account_type_id
@subsidiary_group_idintINdbo27.ledger_accounts.subsidiary_group_id
@closing_child_account_idintINdbo27.ledger_accounts.closing_child_account_id
@closing_debit_account_idintINdbo27.ledger_accounts.closing_debit_account_id
@closing_credit_account_idintINdbo27.ledger_accounts.closing_credit_account_id
@ref_numberintINdbo27.ledger_accounts.ref_number
@data_languagevarchar(10)INContext data language

xls27.usp_ledger_accounts_update

This procedure updates rows of xls27.usp_ledger_accounts.

ParameterDataTypeModeComment
@idintINdbo27.ledger_accounts.id
@codenvarchar(50)INdbo27.ledger_accounts.code
@namenvarchar(100)INdbo27.ledger_accounts.name
@translated_namenvarchar(100)INdbo27.translations.name
@parent_idintINdbo27.ledger_accounts.parent_id
@account_type_idtinyintINdbo27.ledger_accounts.account_type_id
@subsidiary_group_idintINdbo27.ledger_accounts.subsidiary_group_id
@closing_child_account_idintINdbo27.ledger_accounts.closing_child_account_id
@closing_debit_account_idintINdbo27.ledger_accounts.closing_debit_account_id
@closing_credit_account_idintINdbo27.ledger_accounts.closing_credit_account_id
@ref_numberintINdbo27.ledger_accounts.ref_number
@data_languagevarchar(10)INContext data language

xls27.usp_member_permissions

This procedure is a form to manage user permissions.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@dimension_idtinyintINdbo27.dimensions.id to filter members
@usernamenvarchar(128)INA username to filter columns
@data_languagevarchar(10)INContext data language

Source table: dbo27.member_permissions

xls27.usp_member_permissions_change

This procedure updates a database on cell changes of xls27.usp_member_permissions.

ParameterDataTypeModeComment
@column_namenvarchar(128)INdbo27.member_permissions.username
@cell_valuenvarchar(255)IND - deny (select_permission = 0, update_permission = 0)
R - read (select_permission = 1, update_permission = 0)
W - write (select_permission = 1, update_permission = 1)
@idintINdbo27.member_permissions.member_id
@data_languagevarchar(10)INContext data language

xls27.usp_member_relations

This procedure is a form of editing member relations.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@member_dimension_idintINdbo27.dimensions.id to filter row members
@partner_dimension_idintINdbo27.dimensions.id to filter column members
@data_languagevarchar(10)INContext data language

Source table: dbo27.member_relations

xls27.usp_member_relations_change

This procedure updates a database on cell changes of xls27.usp_member_relations.

ParameterDataTypeModeComment
@column_namenvarchar(128)INThe code used to find dbo27.member_relations.partner_id
@cell_number_valueintINdbo27.member_relations.select_permission

1 - select_permission = 1
0 - select_permission = 0
NULL - remove the relation
@idintINdbo27.member_relations.member_id
@data_languagevarchar(10)INContext data language

xls27.usp_member_types

This procedure is a form of editing member types.

Source table: dbo27.member_types

xls27.usp_members

This procedure is a form of editing members.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@dimension_idtinyintINdbo27.members.dimension_id
@is_in_budgetbitIN1 - the member is shown in budget requests
0 - the member is not shown in budget requests
@is_activebitINdbo27.members.is_active
@data_languagevarchar(10)INContext data language

Use this form to edit members of any dimension.

Use specific xls27.usp_budgeting_accounts and xls27.usp_subsidiary_accounts procedures to edit budgeting and subsidiary accounts.

Source table: dbo27.members

xls27.usp_members_delete

This procedure deletes rows of xls27.usp_members.

ParameterDataTypeModeComment
@idintINdbo27.members.id

xls27.usp_members_insert

This procedure inserts rows of xls27.usp_members.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@dimension_idintINdbo27.members.dimension_id
@sort_orderintINdbo27.members.sort_order
@codenvarchar(50)INdbo27.members.code
@namenvarchar(100)INdbo27.members.name
@translated_namenvarchar(100)INdbo27.translations.name
@is_activebitINdbo27.members.is_active
@data_languagevarchar(10)INContext data language

xls27.usp_members_update

This procedure updates rows of xls27.usp_members.

ParameterDataTypeModeComment
@idintINdbo27.members.id
@sort_orderintINdbo27.members.sort_order
@codenvarchar(50)INdbo27.members.code
@namenvarchar(100)INdbo27.members.name
@translated_namenvarchar(100)INdbo27.translations.name
@is_activebitINdbo27.members.is_active
@data_languagevarchar(10)INContext data language

xls27.usp_report_section_accounts

This procedure is a form of editing report section accounts.

ParameterDataTypeModeComment
@report_type_idtinyintINdbo27.report_types.id
@is_plbitINNULL - all accounts
1 - P/L accounts
0 - balance sheet accounts
@entry_side_idtinyintINdbo27.report_sections.entry_side_id
@data_languagevarchar(10)INContext data language

Source table: dbo27.report_section_accounts

xls27.usp_report_section_total_types

This procedure is a form of editing report section total types.

Source table: dbo27.report_section_total_types

xls27.usp_report_section_types

This procedure is a form of editing report section types.

Source table: dbo27.report_section_types

xls27.usp_report_section_value_types

This procedure is a form of editing report section value types.

Source table: dbo27.report_section_value_types

xls27.usp_report_sections

This procedure is a form of editing report sections.

ParameterDataTypeModeComment
@company_idintINdbo27.report_sections.company_id
@report_type_idtinyintINdbo27.report_types.id
@data_languagevarchar(10)INContext data language

Source table: dbo27.report_sections

xls27.usp_report_sections_delete

This procedure deletes rows of xls27.usp_report_sections.

ParameterDataTypeModeComment
@idintINdbo27.report_sections.id

xls27.usp_report_sections_insert

This procedure inserts rows of xls27.usp_report_sections.

ParameterDataTypeModeComment
@company_idintINdbo27.report_sections.company_id
@report_type_idtinyintINdbo27.report_sections.report_id
@sectionintINdbo27.report_sections.section
@row_formatintINdbo27.report_sections.row_format
@ref_numberintINdbo27.report_sections.ref_number
@codenvarchar(50)INdbo27.report_sections.code
@descriptionnvarchar(255)INdbo27.report_sections.name
@translated_namenvarchar(255)INdbo27.translations.name
@parent_idintINdbo27.report_sections.parent_id
@parent2_idintINdbo27.report_sections.parent2_id
@section_type_idtinyintINdbo27.report_sections.section_type_id
@inverse_signbitINdbo27.report_sections.inverse_sign
@hide_itemsbitINdbo27.report_sections.hide_items
@show_linebitINdbo27.report_sections.show_line
@show_line_beforebitINdbo27.report_sections.show_line_before
@show_line_afterbitINdbo27.report_sections.show_line_after
@page_break_beforebitINdbo27.report_sections.page_break_before
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_report_sections_update

This procedure updates rows of xls27.usp_report_sections.

ParameterDataTypeModeComment
@idintINdbo27.report_sections.id
@report_type_idtinyintINdbo27.report_sections.report_id
@sectionintINdbo27.report_sections.section
@row_formatintINdbo27.report_sections.row_format
@ref_numberintINdbo27.report_sections.ref_number
@codenvarchar(50)INdbo27.report_sections.code
@descriptionnvarchar(255)INdbo27.report_sections.name
@translated_namenvarchar(255)INdbo27.translations.name
@parent_idintINdbo27.report_sections.parent_id
@parent2_idintINdbo27.report_sections.parent2_id
@section_type_idtinyintINdbo27.report_sections.section_type_id
@inverse_signbitINdbo27.report_sections.inverse_sign
@hide_itemsbitINdbo27.report_sections.hide_items
@show_linebitINdbo27.report_sections.show_line
@show_line_beforebitINdbo27.report_sections.show_line_before
@show_line_afterbitINdbo27.report_sections.show_line_after
@page_break_beforebitINdbo27.report_sections.page_break_before
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_report_types

This procedure is a form of editing report types.

Source table: dbo27.report_types

xls27.usp_role_members

This procedure is a form for managing user roles.

A user must have VIEW DEFINITION permissions to see users.

xls27.usp_role_members_change

This procedure updates a role membership on cell changes of xls27.usp_role_members.

ParameterDataTypeModeComment
@column_namenvarchar(128)INusername
@cell_number_valueintIN1 - include the user into a role
0 - exclude the user from the role
@namenvarchar(128)INrole
@data_languagevarchar(10)INContext data language

A user must have ALTER USER and ALTER ROLE permissions to change permissions.

xls27.usp_saved_report_types

This procedure is a form of editing saved report types.

ParameterDataTypeModeComment
@company_idintINdbo27.saved_reports.company_id
@data_languagevarchar(10)INContext data language

Source table: dbo27.saved_report_types

xls27.usp_saved_report_types_delete

This procedure deletes rows of xls27.usp_saved_report_types.

ParameterDataTypeModeComment
@idintINdbo27.saved_reports.id

xls27.usp_saved_report_types_insert

This procedure inserts rows of xls27.usp_saved_report_types.

ParameterDataTypeModeComment
@company_idintINdbo27.saved_reports.company_id
@codenvarchar(50)INdbo27.saved_reports.code
@namenvarchar(100)INdbo27.saved_reports.name
@translated_namenvarchar(100)INdbo27.translations.name
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_saved_report_types_update

This procedure updates rows of xls27.usp_saved_report_types.

ParameterDataTypeModeComment
@idintINdbo27.saved_reports.id
@codenvarchar(50)INdbo27.saved_reports.code
@namenvarchar(100)INdbo27.saved_reports.name
@translated_namenvarchar(100)INdbo27.translations.name
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_saved_reports

This procedure selects a single saved report.

ParameterDataTypeModeComment
@company_idintINdbo27.saved_reports.company_id
@category_idintINdbo27.saved_reports.category_id
@time_idintINdbo27.saved_reports.time_id
@type_idintINdbo27.saved_reports.type_id

Source table: dbo27.saved_reports

xls27.usp_saved_reports_delete

This procedure deletes rows of xls27.usp_budget_report.

ParameterDataTypeModeComment
@category_idintINdbo27.saved_reports.category_id
@time_idintINdbo27.saved_reports.time_id
@type_idintINdbo27.saved_reports.type_id
@saved_row_indexintINdbo27.saved_reports.row_index

xls27.usp_saved_reports_insert

This procedure inserts rows of xls27.usp_budget_report.

ParameterDataTypeModeComment
@category_idintINdbo27.saved_reports.category_id
@time_idintINdbo27.saved_reports.time_id
@type_idintINdbo27.saved_reports.type_id
@rownumintINdbo27.saved_reports.row_index
@id1nvarchar(50)INdbo27.saved_reports.id1
@id2intINdbo27.saved_reports.id2
@ref_numberintINdbo27.saved_reports.ref_number
@accountnvarchar(50)INdbo27.saved_reports.account
@reportintINdbo27.saved_reports.form
@page_breakintINdbo27.saved_reports.page_break
@row_levelintINdbo27.saved_reports.row_level
@row_formatintINdbo27.saved_reports.row_format
@hideintINdbo27.saved_reports.hide
@zerointINdbo27.saved_reports.zero
@code1nvarchar(50)INdbo27.saved_reports.code1
@code2nvarchar(50)INdbo27.saved_reports.code2
@codenvarchar(50)INdbo27.saved_reports.code
@descriptionnvarchar(255)INdbo27.saved_reports.name
@data00floatINdbo27.saved_reports.data00
@data01floatINdbo27.saved_reports.data01
@data02floatINdbo27.saved_reports.data02
@data03floatINdbo27.saved_reports.data03
@data04floatINdbo27.saved_reports.data04
@data05floatINdbo27.saved_reports.data05
@data06floatINdbo27.saved_reports.data06
@data07floatINdbo27.saved_reports.data07
@data08floatINdbo27.saved_reports.data08
@data09floatINdbo27.saved_reports.data09
@data10floatINdbo27.saved_reports.data10
@data11floatINdbo27.saved_reports.data11
@data12floatINdbo27.saved_reports.data12
@transaction_start_timedatetimeINdbo27.saved_reports.transaction_start_time

xls27.usp_saved_reports_update

This procedure updates rows of xls27.usp_budget_report.

ParameterDataTypeModeComment
@category_idintINdbo27.saved_reports.category_id
@time_idintINdbo27.saved_reports.time_id
@type_idintINdbo27.saved_reports.type_id
@saved_row_indexintINdbo27.saved_reports.row_index
@rownumintINdbo27.saved_reports.row_index
@id1nvarchar(50)INdbo27.saved_reports.id1
@id2intINdbo27.saved_reports.id2
@ref_numberintINdbo27.saved_reports.ref_number
@accountnvarchar(50)INdbo27.saved_reports.account
@reportintINdbo27.saved_reports.form
@page_breakintINdbo27.saved_reports.page_break
@row_levelintINdbo27.saved_reports.row_level
@row_formatintINdbo27.saved_reports.row_format
@hideintINdbo27.saved_reports.hide
@zerointINdbo27.saved_reports.zero
@code1nvarchar(50)INdbo27.saved_reports.code1
@code2nvarchar(50)INdbo27.saved_reports.code2
@codenvarchar(50)INdbo27.saved_reports.code
@descriptionnvarchar(255)INdbo27.saved_reports.name
@data00floatINdbo27.saved_reports.data00
@data01floatINdbo27.saved_reports.data01
@data02floatINdbo27.saved_reports.data02
@data03floatINdbo27.saved_reports.data03
@data04floatINdbo27.saved_reports.data04
@data05floatINdbo27.saved_reports.data05
@data06floatINdbo27.saved_reports.data06
@data07floatINdbo27.saved_reports.data07
@data08floatINdbo27.saved_reports.data08
@data09floatINdbo27.saved_reports.data09
@data10floatINdbo27.saved_reports.data10
@data11floatINdbo27.saved_reports.data11
@data12floatINdbo27.saved_reports.data12
@transaction_start_timedatetimeINdbo27.saved_reports.transaction_start_time

xls27.usp_subsidiary_accounts

This procedure is a form of editing subsidiary accounts.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@subsidiary_group_idintINdbo27.subsidiary_groups.id
@data_languagevarchar(10)INContext data language

The application stores subsidiary accounts in the dbo27.members table with dimension_id = 7.

Contrary to xls27.usp_members, this form selects fields specific for subsidiary accounts.

Source table: dbo27.members

xls27.usp_subsidiary_accounts_delete

This procedure deletes rows of xls27.usp_subsidiary_accounts.

ParameterDataTypeModeComment
@idintINdbo27.members.id

xls27.usp_subsidiary_accounts_insert

This procedure inserts rows of xls27.usp_subsidiary_accounts.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@codenvarchar(50)INdbo27.members.code
@namenvarchar(100)INdbo27.members.name
@currency_idtinyintINdbo27.members.unit_id
@group1tinyintINsubsidiary_account_groups.group_id
@group2tinyintINsubsidiary_account_groups.group_id
@group3tinyintINsubsidiary_account_groups.group_id

xls27.usp_subsidiary_accounts_update

This procedure updates rows of xls27.usp_subsidiary_accounts.

ParameterDataTypeModeComment
@idintINdbo27.members.id
@codenvarchar(50)INdbo27.members.code
@namenvarchar(100)INdbo27.members.name
@currency_idtinyintINdbo27.members.unit_id
@group1tinyintINsubsidiary_account_groups.group_id
@group2tinyintINsubsidiary_account_groups.group_id
@group3tinyintINsubsidiary_account_groups.group_id
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_subsidiary_groups

This procedure is a form of editing subsidiary groups.

ParameterDataTypeModeComment
@company_idintINdbo27.subsidiary_groups.company_id
@data_languagevarchar(10)INContext data language

Source table: dbo27.subsidiary_groups

xls27.usp_subsidiary_groups_delete

This procedure deletes rows of xls27.usp_subsidiary_groups.

ParameterDataTypeModeComment
@idintINdbo27.subsidiary_groups.id

xls27.usp_subsidiary_groups_insert

This procedure inserts rows of xls27.usp_subsidiary_groups.

ParameterDataTypeModeComment
@company_idintINdbo27.subsidiary_groups.company_id
@codenvarchar(50)INdbo27.subsidiary_groups.code
@namenvarchar(100)INdbo27.subsidiary_groups.name
@translated_namenvarchar(100)INdbo27.translations.name
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_subsidiary_groups_update

This procedure updates rows of xls27.usp_subsidiary_groups.

ParameterDataTypeModeComment
@idintINdbo27.subsidiary_groups.id
@codenvarchar(50)INdbo27.subsidiary_groups.code
@namenvarchar(100)INdbo27.subsidiary_groups.name
@translated_namenvarchar(100)INdbo27.translations.name
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_translations

This procedure is a form of editing company-related translations.

ParameterDataTypeModeComment
@company_idintINdbo27.translations.company_id
@is_translatablebitIN1 - select translatable elements only
0 - select non-translatable elements
@is_completebitIN1 - show values with complete translations
0 - show values with incomple translations

Source table: dbo27.translations

xls27.usp_translations_change

This procedure updates an element translation on cell changes of xls27.usp_translations.

ParameterDataTypeModeComment
@company_idintINdbo27.translations.company_id
@table_idintINdbo27.translations.table_id
@member_idintINdbo27.translations.member_id
@column_namenvarchar(128)INdbo27.translations.language
@cell_valuenvarchar(400)INdbo27.translations.name
@cell_number_valueintINThe value for the is_translatable column in supported tables

xls27.usp_translations_common

This procedure is a form of editing application-level element translations.

ParameterDataTypeModeComment
@is_completebitIN1 - show values with complete translations
0 - show values with incomple translations

Source table: xls.translations

This procedure selects all elements available for translations.

xls27.usp_translations_xls

This procedure is a form of editing actual application-level element translations.

ParameterDataTypeModeComment
@fieldnvarchar(128)INTRANSLATED_NAME, TRANSLATED_DESC, or TRANSLATED_COMMENT
@schemanvarchar(128)INxls.translations.TABLE_SCHEMA
@is_completebitIN1 - show values with complete translations
0 - show values with incomple translations

Source table: xls.translations

This procedure selects existing elements.

xls27.usp_translations_xls_change

This procedure updates an application element translation on cell changes of xls27.usp_translations_xls.

ParameterDataTypeModeComment
@column_namenvarchar(128)INxls.translations.LANGUAGE_NAME
@cell_valuenvarchar(max)INA value for the specified field
@TABLE_SCHEMAnvarchar(128)INxls.translations.TABLE_SCHEMA
@TABLE_NAMEnvarchar(128)INxls.translations.TABLE_NAME
@COLUMNnvarchar(128)INxls.translations.COLUMN_NAME
@fieldnvarchar(128)INTRANSLATED_NAME, TRANSLATED_DESC, or TRANSLATED_COMMENT
@data_languagevarchar(10)INxls.translations.LANGUAGE_NAME

xls27.usp_units

This procedure is a form of editing units.

ParameterDataTypeModeComment
@company_idintINdbo27.units.company_id
@data_languagevarchar(10)INContext data language

Source table: dbo27.units

xls27.usp_units_delete

This procedure deletes rows of xls27.usp_units.

ParameterDataTypeModeComment
@idintINdbo27.units.id

xls27.usp_units_insert

This procedure inserts rows of xls27.usp_units.

ParameterDataTypeModeComment
@company_idintINdbo27.units.company_id
@codenvarchar(50)INdbo27.units.code
@namenvarchar(100)INdbo27.units.name
@translated_namenvarchar(100)INdbo27.translations.name
@sort_orderintINdbo27.units.sort_order
@factorfloatINdbo27.units.factor
@is_currencybitINdbo27.units.is_currency
@is_functional_currencybitINdbo27.units.is_functional_currency
@is_base_currencybitINdbo27.units.is_base_currency
@is_activebitINdbo27.units.is_active
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_units_update

This procedure updates rows of xls27.usp_units.

ParameterDataTypeModeComment
@idintINdbo27.units.id
@codenvarchar(50)INdbo27.units.code
@namenvarchar(100)INdbo27.units.name
@translated_namenvarchar(100)INdbo27.translations.name
@sort_orderintINdbo27.units.sort_order
@factorfloatINdbo27.units.factor
@is_currencybitINdbo27.units.is_currency
@is_functional_currencybitINdbo27.units.is_functional_currency
@is_base_currencybitINdbo27.units.is_base_currency
@is_activebitINdbo27.units.is_active
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_users

This procedure is a form of editing users.

ParameterDataTypeModeComment
@company_idintINdbo27.users.company_id

Source table: dbo27.users

xls27.usp_users_delete

This procedure deletes rows of xls27.usp_users.

ParameterDataTypeModeComment
@company_idintINdbo27.users.company_id
@usernamenvarchar(128)INdbo27.users.username

xls27.usp_users_insert

This procedure inserts rows of xls27.usp_users.

ParameterDataTypeModeComment
@company_idintINdbo27.users.company_id
@usernamenvarchar(128)INdbo27.users.username
@namenvarchar(100)INdbo27.users.name
@is_adminbitINdbo27.users.is_admin
@is_activebitINdbo27.users.is_active
@is_defaultbitINdbo27.users.is_default

xls27.usp_users_update

This procedure updates rows of xls27.usp_users.

ParameterDataTypeModeComment
@company_idintINdbo27.users.company_id
@usernamenvarchar(128)INdbo27.users.username
@namenvarchar(100)INdbo27.users.name
@is_adminbitINdbo27.users.is_admin
@is_activebitINdbo27.users.is_active
@is_defaultbitINdbo27.users.is_default

xls27.usp_vat_rates

This procedure is a form of editing VAT rates.

ParameterDataTypeModeComment
@company_idintINdbo27.vat_rates.company_id
@data_languagevarchar(10)INContext data language

Source table: dbo27.vat_rates

xls27.usp_vat_rates_delete

This procedure deletes rows of xls27.usp_vat_rates.

ParameterDataTypeModeComment
@idintINdbo27.vat_rates.id

xls27.usp_vat_rates_insert

This procedure inserts rows of xls27.usp_vat_rates.

ParameterDataTypeModeComment
@company_idintINdbo27.vat_rates.company_id
@codenvarchar(50)INdbo27.vat_rates.code
@namenvarchar(100)INdbo27.vat_rates.name
@translated_namenvarchar(100)INdbo27.translations.name
@sort_orderintINdbo27.vat_rates.sort_order
@factorfloatINdbo27.vat_rates.factor
@is_activebitINdbo27.vat_rates.is_active
@data_languagevarchar(10)INdbo27.translations.language

xls27.usp_vat_rates_update

This procedure updates rows of xls27.usp_vat_rates.

ParameterDataTypeModeComment
@idintINdbo27.vat_rates.id
@codenvarchar(50)INdbo27.vat_rates.code
@namenvarchar(100)INdbo27.vat_rates.name
@translated_namenvarchar(100)INdbo27.translations.name
@sort_orderintINdbo27.vat_rates.sort_order
@factorfloatINdbo27.vat_rates.factor
@is_activebitINdbo27.vat_rates.is_active
@data_languagevarchar(10)INdbo27.translations.language

xls27.xl_actions_actual_report_cell_data

This procedure selects underlying data for a reporting cell of actual reports.

ParameterDataTypeModeComment
@company_idintINdbo27.companies.id
@yearintINYear
@entity_idintINdbo27.journals.entity_id
@reportintINdbo27.report_types.id
@ref_numberintINValue of the ref_number column
@accountnvarchar(50)INdbo27.ledger_accounts.code
@code1nvarchar(50)INdbo27.members.code used to find dbo27.journals.account_id
@code2nvarchar(50)INdbo27.members.code used to find product_id, region_id, or subsidiary_id
@column_namenvarchar(128)INContext column name
@data_languagevarchar(10)INContext data language

Users may run this procedure from the context menu.

xls27.xl_actions_add_language

This procedure adds a new language for company-related elements.

ParameterDataTypeModeComment
@company_idintINdbo27.translations.company_id
@languagevarchar(10)INdbo27.translations.language

Users may run this procedure from the Actions menu.

xls27.xl_actions_auto_calc_all

This procedure creates automatic journal entries using all automation rules.

ParameterDataTypeModeComment
@company_idintINdbo27.companies.id

Users may run this procedure from the Actions menu.

xls27.xl_actions_auto_close_accounts

This procedure creates automatic journal entries to close accounts at the end of the month.

ParameterDataTypeModeComment
@company_idintINdbo27.companies.id

This procedure is called by xls27.xl_actions_auto_calc_all.

xls27.xl_actions_auto_currency_transactions

This procedure creates automatic journal entries related to currency transactions.

ParameterDataTypeModeComment
@company_idintINdbo27.companies.id

This procedure is called by xls27.xl_actions_auto_calc_all.

xls27.xl_actions_auto_currency_translation

This procedure creates automatic journal entries related to currency translation at the end of the month.

ParameterDataTypeModeComment
@company_idintINdbo27.companies.id

This procedure is called by xls27.xl_actions_auto_calc_all.

xls27.xl_actions_budget_report_cell_data

This procedure selects underlying data for a reporting cell of budget reports.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@category_idintINdbo27.budget_requests.category_id
@time_idintINdbo27.budget_requests.time_id
@entity_idintINdbo27.budget_requests.entity_id
@yearintINYear
@reportintINdbo27.report_types.id
@ref_numberintINValue of the ref_number column
@accountnvarchar(50)INdbo27.ledger_accounts.code
@code1nvarchar(50)INdbo27.members.code used to find dbo27.budget_requests.account_id
@code2nvarchar(50)INdbo27.members.code used to find product_id, region_id, or subsidiary_id
@column_namenvarchar(128)INContext column name
@data_languagevarchar(10)INContext data language

Users may run this procedure from the context menu.

xls27.xl_actions_select_members

This procedure selects a list of members available to a user.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Business users may use this form to check available accounts, periods, entities, and other members.

You may add it to the Actions menu using the xls.handlers table.

xls27.xl_parameter_values_category_id

This procedure selects a list of categories for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_parameter_values_category_id_not_null

This procedure selects a list of categories for Excel ribbon parameters except for NULL.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_parameter_values_company_id

This procedure selects a list of companies for Excel ribbon parameters.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.companies

xls27.xl_parameter_values_currency_id

This procedure selects a list of currencies for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.units

xls27.xl_parameter_values_day

This procedure selects a list of days for Excel ribbon parameters.

The procedure selects numbers 1-31.

xls27.xl_parameter_values_dimension_id

This procedure selects a list of dimensions for Excel ribbon parameters.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.dimensions

Use the xls.translations table to translated items.

xls27.xl_parameter_values_dimension_id_not_null

This procedure selects a list of dimensions for Excel ribbon parameters.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.dimensions

Use the xls.translations table to translated items.

xls27.xl_parameter_values_entity_id

This procedure selects a list of entities for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_parameter_values_entity_id_not_null

This procedure selects a list of entities for Excel ribbon parameters except for NULL.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_parameter_values_entry_side_id

This procedure selects a list of entry sides for Excel ribbon parameters.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.entry_sides

xls27.xl_parameter_values_ledger_account_id_code

This procedure selects a list of ledger accounts for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo27.ledger_accounts.company_id

Underlying table: dbo27.ledger_accounts

xls27.xl_parameter_values_member_type_id

This procedure selects a list of member types for Excel ribbon parameters.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.member_types

xls27.xl_parameter_values_month

This procedure selects a list of months for Excel ribbon parameters.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

The procedure selects month names in a user language.

xls27.xl_parameter_values_report_type_id

This procedure selects a list of built-in budget reports for Excel ribbon parameters.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.reports

Use the xls.translations table to translated items.

xls27.xl_parameter_values_report_type_id_code

This procedure selects a list of report types for Excel ribbon parameters.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.report_types

xls27.xl_parameter_values_saved_report_type_id

This procedure selects a list of saved report types for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo27.saved_report_types.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.saved_report_types

xls27.xl_parameter_values_subsidiary_account_id

This procedure selects a list of subsidiary accounts for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_parameter_values_subsidiary_group_id

This procedure selects a list of subsidiary groups for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.subsidiary_groups

xls27.xl_parameter_values_time_id

This procedure selects a list of periods for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_parameter_values_time_id_not_null

This procedure selects a list of periods for Excel ribbon parameters except for NULL.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_parameter_values_username

This procedure selects a list of usernames for Excel ribbon parameters.

ParameterDataTypeModeComment
@company_idintINdbo27.users.company_id

The procedure selects usernames of members of the budgeting_app_users role only.

To manage users, grant the VIEW DEFINITION permission. Other permissions are not required.

Underlying tables: sys.database_principals, sys.database_role_members

xls27.xl_parameter_values_year

This procedure selects a list of years for Excel ribbon parameters.

The procedure selects years from actual minimum to maximum years in the journal.

xls27.xl_validation_list_budgeting_account_id_code

This procedure selects budgeting accounts to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id

Underlying table: dbo27.members

xls27.xl_validation_list_budgeting_account_type_id

This procedure selects budgeting account types to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.member_types

xls27.xl_validation_list_budgeting_parent_id_code

This procedure selects accounts to use as an Excel validation list source of an account parent.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id

Underlying table: dbo27.members

xls27.xl_validation_list_credit_account_id_code

This procedure selects ledger accounts to use as an Excel validation list source of a credit account.

ParameterDataTypeModeComment
@company_idintINdbo27.ledger_accounts.company_id

Underlying table: dbo27.ledger_accounts

xls27.xl_validation_list_credit_subsidiary_account_id

This procedure selects subsidiary accounts to use as an Excel validation list source of a credit subsidiary account.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_validation_list_currency_id

This procedure selects currencies to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.units.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.units

xls27.xl_validation_list_currency_id_code

This procedure selects currencies to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.units.company_id

Underlying table: dbo27.units

xls27.xl_validation_list_debit_account_id_code

This procedure selects ledger accounts to use as an Excel validation list source of a debit account.

ParameterDataTypeModeComment
@company_idintINdbo27.ledger_accounts.company_id

Underlying table: dbo27.ledger_accounts

xls27.xl_validation_list_debit_subsidiary_account_id

This procedure selects subsidiary accounts to use as an Excel validation list source of a debit subsidiary account.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_validation_list_dimension_id

This procedure selects dimensions to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.dimensions

Use the xls.translations table to translated items.

xls27.xl_validation_list_entity_id

This procedure selects entities to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_validation_list_entity_id_code

This procedure selects entities to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id

Underlying table: dbo27.members

xls27.xl_validation_list_entry_side_id

This procedure selects entry sides to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.entry_sides

xls27.xl_validation_list_ledger_account_id

This procedure selects ledger accounts to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.ledger_accounts.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.ledger_accounts

xls27.xl_validation_list_ledger_account_id_code

This procedure selects ledger accounts to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.ledger_accounts.company_id

Underlying table: dbo27.ledger_accounts

xls27.xl_validation_list_ledger_account_special_type_id

This procedure selects ledger account special types to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.ledger_account_special_types

xls27.xl_validation_list_ledger_account_type_id

This procedure selects ledger account types to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.ledger_account_types

Use the xls.translations table to translated items.

xls27.xl_validation_list_member_type_id

This procedure selects member types to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.member_types

Use the xls.translations table to translated items.

xls27.xl_validation_list_product_id

This procedure selects products to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_validation_list_product_id_code

This procedure selects products to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id

Underlying table: dbo27.members

xls27.xl_validation_list_region_id

This procedure selects regions to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_validation_list_region_id_code

This procedure selects regions to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id

Underlying table: dbo27.members

xls27.xl_validation_list_report_section_id

This procedure selects report sections to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.report_sections.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.report_sections

xls27.xl_validation_list_report_section_total_type_id

This procedure selects report section total types to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.report_section_total_types

xls27.xl_validation_list_report_section_type_id

This procedure selects report section types to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.report_section_types

xls27.xl_validation_list_report_section_value_type_id

This procedure selects report section value types to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.report_section_value_types

xls27.xl_validation_list_report_type_id_code

This procedure selects reports to use as an Excel validation list source.

ParameterDataTypeModeComment
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.reports

xls27.xl_validation_list_subsidiary_account_id

This procedure selects subsidiary accounts to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.members

xls27.xl_validation_list_subsidiary_account_id_code

This procedure selects subsidiary accounts to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id

Underlying table: dbo27.members

xls27.xl_validation_list_subsidiary_group_id

This procedure selects subsidiary account groups to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.members.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.subsidiary_groups

xls27.xl_validation_list_unit_id

This procedure selects units to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.units.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.units

xls27.xl_validation_list_unit_id_code

This procedure selects units to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.units.company_id

Underlying table: dbo27.units

xls27.xl_validation_list_vat_rate_id

This procedure selects vat_rates to use as an Excel validation list source.

ParameterDataTypeModeComment
@company_idintINdbo27.vat_rates.company_id
@data_languagevarchar(10)INContext data language

Underlying table: dbo27.vat_rates