SELECT 
	[WAREHOUSEID]
	,[WAREHOUSELOCATIONID]
	,[WAREHOUSEZONEID]
	,[SORTORDERCODE]
	,[WAREHOUSELOCATIONPROFILEID]
	,[DATAAREAID]
	,[WAREHOUSELOCATIONID] [DESTINATIONWAREHOUSELOCATIONID]
	,'0'[BINID]
	,'0'[GENERATECHECKDIGITS]
	,CASE [SORTORDERCODE] 
		WHEN 0 THEN '0'
		ELSE '1'
	 END AS [ISSORTORDERCODEMANUAL]
	,'1' [ISWAREHOUSELOCATIONIDMANUAL]
	,'0' [PHYSICALDEPTH]
	,'0' [PHYSICALHEIGHT]
	,'0' [PHYSICALHEIGHTABOVEGROUND]
	,'0' [PHYSICALMAXIMUMSTORAGEVOLUME]
	,'0' [PHYSICALMAXIMUMSTORAGEWEIGHT]
	,'0' [PHYSICALWIDTH]
	,'0' [RACKID]
	,'0' [SHELFID]
	,'--' [WAREHOUSEAISLEID]
	,'0'[WAREHOUSELOCATIONTYPE]
	,'0'[ISDEFAULTCREDITONLYRETURNWAREHOUSELOCATION]
	,'0'[ISDEFAULTISSUEWAREHOUSELOCATION]
	,'0'[ISDEFAULTKANBANFINISHEDGOODSWAREHOUSELOCATION]
	,'0'[ISDEFAULTPRODUCTIONFINISHEDGOODSWAREHOUSELOCATION]
	,'0'[ISDEFAULTPRODUCTIONINPUTWAREHOUSELOCATION]
	,'0'[ISDEFAULTRECEIPTWAREHOUSELOCATION]
	,'0'[ISDEFAULTRETAILSTORERETURNWAREHOUSELOCATION]
	,'0'[ISDEFAULTRETAILSTOREWAREHOUSELOCATION]
	,'0'[ISDEFAULTSHIPMENTMAINTENANCEWAREHOUSELOCATION]

FROM [AxMasterData].[dbo].[LAX-WmsLocations]