Budgeting Application Functions

Budgeting Application 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.