The field is called Assets.cSerialNumber.

Armed with this information, we can now build the MET/TEAM query, to get the equivalent information as was used in MET/BASE:

SELECT Assets.cID, Facilities.cFacilityName, Assets.cModelNumber,  

 Assets.cDescription, Assets.cSerialNumber

FROM dbo.Assets Assets

JOIN dbo.Facilities Facilities

ON Facilities.nFacilityUID = Assets.nManufacturerUID

ORDER BY Assets.cID