SELECT 	
	  F1.[Asset ID] 'No.'
          ,RTRIM(F1.[Asset Description]) 'Description'
	  ,'' 'Search Description'
	  ,RTRIM(F2.EXTASSETDESC) 'Description 2'
	  ,'TANGIBLE' 'FA Class Code'
	  ,'' 'FA Posting Group'
	  ,RTRIM(F1.[Asset Class ID]) 'FA Subclass Code'
	  ,RTRIM(F3.VENDORID) 'Vendor No.'
	  ,RTRIM(F2.SERLNMBR) 'Serial No.'
	  ,'' 'Global Dimension 1 Code'
	  ,'' 'Global Dimension 2 Code'
	  ,RTRIM(F1.[Depreciation Method]) 'Depreciation Method'
	  ,RTRIM(F1.[Book ID]) 'Depreciation Book Code'
	  ,F1.[Place in Service Date] 'Acquisition Date'
	  ,RTRIM(F1.[Cost Basis]) 'Acquisition Cost'
	  ,RTRIM(F1.[LTD Depreciation Amount]) 'Accumulated Depreciation'
	  ,F1.[Net Book Value] 'Net Book Value'
	  ,F1.[Depreciated to Date] 'Accumulated Dep. Date'
	  ,RTRIM(F1.[Original Life Years]) 'Life of Asset in Years'
	  ,'' 'Depreciation Ending Date'
	  ,F2.ASSETQTY 'Asset Qty'
       	  ,[Salvage Value]
    	  ,RTRIM(F1.[Location ID]) 'Location ID'
	,RTRIM(F1.[Structure ID]) 'Structure ID'
	,RTRIM(F1.[Physical Location ID]) 'Physical Location ID'
	,CASE F2.ASSETSTATUS 
		WHEN 1 THEN 'Active'
		WHEN 2 THEN 'Deleted'
		WHEN 3 THEN 'Partial Open'
		WHEN 4 THEN 'Retired'
	 	ELSE 'OTHER'
		END	'Asset Status'
	  FROM [dbo].[FixedAssetsBooks] F1
  
  	LEFT OUTER JOIN FA00100 F2
	  ON F1.[Asset Index] = F2.ASSETINDEX

	LEFT OUTER JOIN FA01400 F3
  	ON F1.[Asset Index] = F3.ASSETINDEX

  	WHERE F1.[Book ID] = 'INTERNAL'
  	AND F2.ASSETSTATUS = 1

  	ORDER BY F1.[Asset ID]