Contents Diagrams Roles Schemas Tables Views Procedures Functions

Gartle Budgeting
Part V. Functions

Version 2.0, July 20, 2020

Functions

FunctionDescription
dbo27.get_translated_stringThis function returns a company-related translated string.
dbo27.is_request_row_emptyThis function checks whether a budget request row is empty or not.

dbo27.get_translated_string

This function returns a company-related translated string.

ParameterDataTypeComment
Resultnvarchar(128)xls.translations.TRANSLATED_NAME
@stringnvarchar(128)xls.translations.COLUMN_NAME
@data_languagechar(2)xls.translations.LANGUAGE_NAME

Underlying table: dbo27.translations

dbo27.is_request_row_empty

This function checks whether a budget request row is empty or not.

ParameterDataTypeComment
Resultbit0 - the row has no values
1 - the row has at least one value
@category_idintNot used
@time_idintNot used
@entity_idintNot used
@row_formatintCustom row format
@descriptionnvarchar(255)Custom comment
@account_idintdbo27.members.id
@subsidiary_account_idintdbo27.members.id
@region_idintdbo27.members.id
@product_idintdbo27.members.id
@vat_rate_idtinyintdbo27.vat_rates.id
@unit_idtinyintdbo27.units.id
@total_paymentsmoneyTotal payments
@total_chargesmoneyTotal charges
@balance00moneyBalance at the beginning
@payments01moneyPayments of period 01
@charges01moneyCharges of period 01
@balance01moneyBalance at the end of period 01
@payments02moneyPayments of period 02
@charges02moneyCharges of period 02
@balance02moneyBalance at the end of period 02
@payments03moneyPayments of period 03
@charges03moneyCharges of period 03
@balance03moneyBalance at the end of period 03
@payments04moneyPayments of period 04
@charges04moneyCharges of period 04
@balance04moneyBalance at the end of period 04
@payments05moneyPayments of period 05
@charges05moneyCharges of period 05
@balance05moneyBalance at the end of period 05
@payments06moneyPayments of period 06
@charges06moneyCharges of period 06
@balance06moneyBalance at the end of period 06
@payments07moneyPayments of period 07
@charges07moneyCharges of period 07
@balance07moneyBalance at the end of period 07
@payments08moneyPayments of period 08
@charges08moneyCharges of period 08
@balance08moneyBalance at the end of period 08
@payments09moneyPayments of period 09
@charges09moneyCharges of period 09
@balance09moneyBalance at the end of period 09
@payments10moneyPayments of period 10
@charges10moneyCharges of period 10
@balance10moneyBalance at the end of period 10
@payments11moneyPayments of period 11
@charges11moneyCharges of period 11
@balance11moneyBalance at the end of period 11
@payments12moneyPayments of period 12
@charges12moneyCharges of period 12
@balance12moneyBalance at the end of period 12

xls27.usp_budget_request1_update calls it to check the row and skips inserting empty ones.

Contents

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.OK