StockingLocationssiteDedicatedLocations

Columns


Name	Type	Description
StockingLocationsStockLocationId [KEY]	Long	StockingLocationsStockLocationId of StockingLocationssiteDedicatedLocations
SiteDedicatedLocId [KEY]	Long	Value that uniquely identifies the site dedicated location record in the dedicated sites table (RCL_SITE_DEDICATED_LOCATIONS).
PartySiteId	Long	Value that uniquely identifies the customer site (HZ_PARTY_SITES) associated with the service logistics stocking locations table (RCL_STOCK_LOCATION).
StockLocationId	Long	Value that uniquely identifies the row in the service logistics stocking location table (RCL_STOCK_LOCATION).
PartySiteNumber	String	Number that identifies the customer site (HZ_PARTY_SITES) associated with the service logistics stocking locations table (RCL_STOCK_LOCATION).

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。