WHSOnHandSPHelper Class [AX 2012]
The WHSOnHandSPHelper class contains helper methods to manipulate the WHS on-hand stored procedure.
| Method | Description | |
|---|---|---|
| buildCreateSPStmt | |
| buildCreateTVFOnHandUnionAllDeltaSqlStmt | |
| buildSPCallParameters | |
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| dimensionLevelParm | |
| dimensionParm | |
| enabledDimensions | Gets a list of enabled storage and tracking dimensions. |
| equal | Determines whether the specified object is equal to the current one. (Inherited from Object.) |
| generateEnabledDimsParametersMap | Generates a map of enabled dimensions to be used as parameters of the stored procedure. |
| generateProductDimsParametersMap | Generates a map of product dimensions to be used as parameters of the stored procedure. |
| getEnabledDimsParametersMap | Retrieves a cached map of enabled dimensions to be used as parameters of the stored procedure. |
| getProductDimsParametersMap | Retrieves a cached map of product dimensions to be used as parameters of the stored procedure. |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| levelExpression | |
| new | Initializes a new instance of the WHSOnHandSPHelper 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.) |
| productDimensions | Gets a list of supported product dimensions. |
| selectFromWHSInventReserveStmt | |
| serialOptimSelectWHSInventReserveStmt | |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| sqlFieldName | |
| sqlTableName | |
| sqlTypeNameForField | Gets a SQL type name that should be used for requested InventDim field in a stored precedure. |
| 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.) |
| whsInventReserveTableAlias | |
| whsInventReserveTableName | |
| xml | Returns an XML string that represents the current object. (Inherited from Object.) |
| ::buildSPCallStmt | Builds the SQL statement to call the WHS on-hand query. |
| ::clearCacheMaps | |
| ::construct | |
| ::createDBStoredProcedures | Creates the stored procedures that query WHS on hand. |
| ::createSqlOnHandUnionAllDeltaTVF | |
| ::createSqlStoredProcedure | Creates the WHS on-hand stored procedure. |
| ::dropDBStoredProcedures | Drops the stored procedures that query WHS on hand. |
| ::dropSqlOnHandUnionAllDeltaTVF | Drops the WHS on-hand stored procedure from the database. |
| ::dropSqlStoredProcedure | Drops the WHS on-hand stored procedure from the database. |
| ::storedProcedureName | |
| ::syncDBStoredProcedures | Drops and creates stored procedures that allow to query WHS on hand. |
Community Additions
ADD
Show: