InventSiteActivateUpdRule.inventDim2InventDimJoinLocSite Method [AX 2012]
Returns a SQL string for joining all the fields from the InventDim table, prefixed by two table buffers.
Syntax
protected str inventDim2InventDimJoinLocSite(
str _firstAlias,
str _secondAlias,
InventDimParm _inventDimParmBlank,
[TableId _tableId,
str _joinAlias,
boolean _applyToSite,
boolean _applyToLocation])
Run On
Server
Parameters
- _firstAlias
Type: str
The name of the first table buffer.
- _secondAlias
Type: str
The name of the second table buffer.
- _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 first table buffer.
- _joinAlias
Type: str
The name of the table buffer that is joined.
- _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
Returns a SQL string.