Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database.
More...
|
| GetTrialBalanceProcedure () |
| Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database. More...
|
|
| GetTrialBalanceProcedure (DateTime dateFrom, DateTime dateTo, int userId, int officeId, bool compact, decimal factor, bool changeSideWhenNegative, bool includeZeroBalanceAccounts) |
| Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database. More...
|
|
IEnumerable< DbGetTrialBalanceResult > | Execute () |
| Prepares and executes the function "transactions.get_trial_balance". More...
|
|
void | Validate (AccessTypeEnum type, long loginId, bool noException) |
| Validates application user access rights to execute the function. More...
|
|
|
override string | ObjectNamespace => "transactions" |
| The schema of this PostgreSQL function. More...
|
|
override string | ObjectName => "get_trial_balance" |
| The schema unqualified name of this PostgreSQL function. More...
|
|
|
long | _LoginId [get, set] |
| Login id of application user accessing this PostgreSQL function. More...
|
|
int | _UserId [get, set] |
| User id of application user accessing this table. More...
|
|
string | Catalog [get, set] |
| The name of the database on which queries are being executed to. More...
|
|
DateTime | DateFrom [get, set] |
| Maps to "_date_from" argument of the function "transactions.get_trial_balance". More...
|
|
DateTime | DateTo [get, set] |
| Maps to "_date_to" argument of the function "transactions.get_trial_balance". More...
|
|
int | UserId [get, set] |
| Maps to "_user_id" argument of the function "transactions.get_trial_balance". More...
|
|
int | OfficeId [get, set] |
| Maps to "_office_id" argument of the function "transactions.get_trial_balance". More...
|
|
bool | Compact [get, set] |
| Maps to "_compact" argument of the function "transactions.get_trial_balance". More...
|
|
decimal | Factor [get, set] |
| Maps to "_factor" argument of the function "transactions.get_trial_balance". More...
|
|
bool | ChangeSideWhenNegative [get, set] |
| Maps to "_change_side_when_negative" argument of the function "transactions.get_trial_balance". More...
|
|
bool | IncludeZeroBalanceAccounts [get, set] |
| Maps to "_include_zero_balance_accounts" argument of the function "transactions.get_trial_balance". More...
|
|
abstract string | ObjectNamespace [get] |
|
abstract string | ObjectName [get] |
|
bool | HasAccess [get] |
|
bool | Validated [get] |
|
bool | SkipValidation [get, set] |
|
bool | HasAccess [get] |
|
Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database.
MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.GetTrialBalanceProcedure |
( |
| ) |
|
Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database.
MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.GetTrialBalanceProcedure |
( |
DateTime |
dateFrom, |
|
|
DateTime |
dateTo, |
|
|
int |
userId, |
|
|
int |
officeId, |
|
|
bool |
compact, |
|
|
decimal |
factor, |
|
|
bool |
changeSideWhenNegative, |
|
|
bool |
includeZeroBalanceAccounts |
|
) |
| |
Prepares, validates, and executes the function "transactions.get_trial_balance(_date_from date, _date_to date, _user_id integer, _office_id integer, _compact boolean, _factor numeric, _change_side_when_negative boolean, _include_zero_balance_accounts boolean)" on the database.
- Parameters
-
dateFrom | Enter argument value for "_date_from" parameter of the function "transactions.get_trial_balance". |
dateTo | Enter argument value for "_date_to" parameter of the function "transactions.get_trial_balance". |
userId | Enter argument value for "_user_id" parameter of the function "transactions.get_trial_balance". |
officeId | Enter argument value for "_office_id" parameter of the function "transactions.get_trial_balance". |
compact | Enter argument value for "_compact" parameter of the function "transactions.get_trial_balance". |
factor | Enter argument value for "_factor" parameter of the function "transactions.get_trial_balance". |
changeSideWhenNegative | Enter argument value for "_change_side_when_negative" parameter of the function "transactions.get_trial_balance". |
includeZeroBalanceAccounts | Enter argument value for "_include_zero_balance_accounts" parameter of the function "transactions.get_trial_balance". |
Prepares and executes the function "transactions.get_trial_balance".
override string MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.ObjectName => "get_trial_balance" |
The schema unqualified name of this PostgreSQL function.
override string MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.ObjectNamespace => "transactions" |
The schema of this PostgreSQL function.
long MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure._LoginId |
|
getset |
Login id of application user accessing this PostgreSQL function.
int MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure._UserId |
|
getset |
User id of application user accessing this table.
string MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.Catalog |
|
getset |
The name of the database on which queries are being executed to.
bool MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.ChangeSideWhenNegative |
|
getset |
Maps to "_change_side_when_negative" argument of the function "transactions.get_trial_balance".
bool MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.Compact |
|
getset |
Maps to "_compact" argument of the function "transactions.get_trial_balance".
DateTime MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.DateFrom |
|
getset |
Maps to "_date_from" argument of the function "transactions.get_trial_balance".
DateTime MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.DateTo |
|
getset |
Maps to "_date_to" argument of the function "transactions.get_trial_balance".
decimal MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.Factor |
|
getset |
Maps to "_factor" argument of the function "transactions.get_trial_balance".
bool MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.IncludeZeroBalanceAccounts |
|
getset |
Maps to "_include_zero_balance_accounts" argument of the function "transactions.get_trial_balance".
int MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.OfficeId |
|
getset |
Maps to "_office_id" argument of the function "transactions.get_trial_balance".
int MixERP.Net.Schemas.Transactions.Data.GetTrialBalanceProcedure.UserId |
|
getset |
Maps to "_user_id" argument of the function "transactions.get_trial_balance".
The documentation for this class was generated from the following file:
- C:/Users/nirvan/Desktop/mixerp/0. GitHub/src/Libraries/DAL/Transactions/GetTrialBalanceProcedure.cs