BudgetControlSQLObjects Class [AX 2012]
The BudgetControlSQLObjects class manages the configuration of the budget control Microsoft SQL Server objects.
| Method | Description | |
|---|---|---|
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| createAdjustAmountSignFunction | Creates the BudgetControlAdjustAmountSignFunction function. |
| createAlterIdentityColumnsProc | Creates the BudgetControlAlterIdentityColumnsProc stored procedure. |
| createCalculateAvailableFundsProc | Creates the BudgetControlCalculateAvailableFundsProc stored procedure. |
| createCheckBudgetProc | Creates the BudgetControlCheckBudgetProc stored procedure. |
| createCleanUpDraftProc | Creates the BudgetControlCleanUpDraftProc stored procedure. |
| createConfigDraftCategoryView | Creates the BudgetControlConfigDraftCategoryView view. |
| createCopyErrorWarnResultsProc | Creates the BudgetControlCopyErrorWarningResultsProc stored procedure. |
| createCycleView | Creates the BudgetControlCycleView view. |
| createErrorWarningPrecedenceView | Creates the BudgetControlErrorWarningPrecedenceView view. |
| createForceApplockReleaseProc | Creates the BudgetControlForceApplockReleaseProc stored procedure. |
| createFunctions | Creates the budget control SQL functions. |
| createGetSummaryDatesProc | Creates the BudgetControlGetSummaryDatesProc stored procedure. |
| createGroupUserOverbudgetOptView | Creates the BudgetControlGroupUserOverbudgetOptView view. |
| createProcessProc | Creates the BudgetControlProcessProc stored procedure. |
| createRuleUserOverbudgetOptView | Creates the BudgetControlRuleUserOverbudgetOptView view. |
| createSaveErrorWarnResultsProc | Creates the BudgetControlSaveErrorWarningResultsProc stored procedure. |
| createSqlObjects | |
| createStoredProcedures | Creates the budget control SQL stored procedures. |
| createSysRaiseErrorProc | Creates the SysRaiseErrorProc stored procedure. |
| createViews | Creates the budget control SQL views. |
| dropFunction | Drops the SQL function that has the specified name. |
| dropProcedure | Drops the SQL stored procedure that has the specified name. |
| dropView | Drops the SQL view that has the specified name. |
| equal | Determines whether the specified object is equal to the current one. (Inherited from Object.) |
| executeSqlStatement | Executes the specified SQL statement text. |
| executeSqlStatementQuery | Executes the specified SQL statement text. |
| existProcedure | Indicates whether the SQL stored procedure that has the specified name exists. |
| getAdjustAmountSignFunctionSql | |
| getAlterIdentityColumnsProcSql | |
| getCalculateAvailableFundsProcSql | |
| getCheckBudgetProcSql1 | Gets the first part of the code for the BudgetControlCheckBudgetProc procedure. |
| getCheckBudgetProcSql2 | Gets the second part of the code for the BudgetControlCheckBudgetProc procedure. |
| getCheckBudgetProcSql3 | Gets the fourth part of the code for the BudgetControlCheckBudgetProc procedure. |
| getCleanUpDraftProcSql1 | Gets the first part of the code for the BudgetControlCleanUpDraftProc procedure. |
| getCleanUpDraftProcSql2 | Gets the third part of the code for the BudgetControlCleanUpDraftProc procedure. |
| getConfigDraftCategoryViewSql | |
| getCopyErrorWarnResultsProcSql | |
| getCycleViewSql | |
| getErrorWarningPrecedenceViewSql | |
| getForceApplockReleaseProcSql | |
| getGetSummaryDatesProcSql | |
| getGroupUserOverbudgetOptViewSql | |
| getProcessProcSql | |
| getRuleUserOverbudgetOptViewSql | |
| getSaveErrorWarnResultsProcSql | |
| getSysRaiseErrorProcSql | |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| initialize | |
| invokeAlterIdentityColumnsProc | Invokes the alter identity columns procedure. |
| new | Initializes a new instance of the BudgetControlSQLObjects class. |
| notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) |
| notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) |
| objectOnServer | Determines whether the object is on a server. (Inherited from Object.) |
| owner | Returns the instance that owns the object. (Inherited from Object.) |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| toString | Returns a string that represents the current object. (Inherited from Object.) |
| usageCount | Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.) |
| wait | Pauses a process. (Inherited from Object.) |
| xml | Returns an XML string that represents the current object. (Inherited from Object.) |
| ::createAll | Creates the budget control SQL objects. |
| ::createAllServer | Creates the budget control SQL objects. |
| ::formatFieldValueForStrArray | |
| ::getBudgetControlCopyErrorWarnBatchCount | Gets the budget control copy results stored procedure maximum record count that can be submitted to the stored procedure at the same time. |
| ::getBudgetControlCopyErrorWarnProcName | Gets the SQL name of the budget control copy error warning results stored procedure. |
| ::getBudgetControlCopyErrorWarnStrArray | Gets a string representation of a collection of from and to BudgetSource record ID pairs. |
| ::getBudgetControlProcessProcName | Gets the SQL name of the budget control process stored procedure. |
| ::getBudgetControlSaveErrorWarnBatchCount | Gets the budget control save results stored procedure maximum record count that can be submitted to the stored procedure at the same time. |
| ::getBudgetControlSaveErrorWarnProcName | Gets the SQL name of the budget control save error warning results stored procedure. |
| ::getBudgetControlSaveErrorWarnStrArray | Gets a string representation of an array of BudgetCheckResultErrorWarningDetail record details. |
| ::getForceApplockReleaseProcName | Gets the SQL name of the force release applock stored procedure. |
Community Additions
ADD
Show: