BudgetControlSQLObjects Class [AX 2012]

The BudgetControlSQLObjects class manages the configuration of the budget control Microsoft SQL Server objects.

Syntax

class BudgetControlSQLObjects

Run On

Called

Methods

	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.

Top

Inheritance Hierarchy

Object Class
  BudgetControlSQLObjects Class