InventSiteActivateUpdRule.andNotExistInventDimLocSite Method [AX 2012]
Returns a SQL string of a NOT EXISTS running through all the inventory dimensions.
Syntax
protected str andNotExistInventDimLocSite(
str _alias,
InventDimParm _inventDimParmBlank,
[TableId _tableId,
str _joinAlias,
boolean _applyToSite,
boolean _applyToLocation])
Run On
Server
Parameters
- _alias
Type: str
The first of the aliases for the comparing of the two inventory dimensions 'C' and 'A'.
- _inventDimParmBlank
Type: InventDimParm Table
InventDimParm record stating the fields that should be compared against a blank value.
- _tableId
Type: TableId Extended Data Type
The tableid of the alias.
- _joinAlias
Type: str
The join alias (if any).
- _applyToSite
Type: boolean
A boolean specifying whether to apply the _joinAlias to the InventSiteId field.
- _applyToLocation
Type: boolean
A boolean specifying whether to apply the _joinAlias to the InventLocationId field.
Return Value
Type: str
A SQL string.