I found this online and don't see why they would recommend Diesel oil over those oils made and sold as motorcycle specific oils. Everything you wanted to know about oil can be found here:
http://www.petro-canada.ca/pdfs/englube.pdf
The Codes are listed here starting about page 34
"S" – SPARK IGNITION (Gasoline, Propane, CNG)
The second letter designated the type and year of the additives
In general The higher the code, the newer the oil. It is generally OK to use a higher letter, however, some oils had detergents while others didn't. If you have an older vehicle that was not designed to handle detergents (to reduce deposits) it may be harmeful to add an oil with detergent in it. Different additives could have a detrimental effect the different materials used for gaskets and seals.
Exerpts from the link:
Standards SA to SF are considered obsolete. The current standard is backservicable to these standards.
SG = Service typical of gasoline engines in passenger cars, vans, and light trucks beginning with the 1989 model year
SH = 1994 provides improved control of engine deposits, oxidation and engine wear relative to oils developed for previous categories. Oils meeting API Service Classification SH may be used to replace SG, SG/CC, SF, SF/CC and SE are recommended. (obsolete)
SJ = 1997 SJ may be used where API Service Classifications SH
and earlier have been recommended.
SL = 2001 Service typical of gasoline engines in passenger cars, sport utility vehicles,
vans and light trucks effective July 1, 2001. In addition to a general improvement
in quality, this new standard aims specifically to improve oil volatility,
SM = 2004 In addition to a general improvement in quality, this new standard aims specifically to improve oil volatility, oil life, fuel economy and emissions system compatibility. Oils meeting API Service
Classification SM may be used where API Service Classifications SL and earlier have been recommended.
"C" – COMPRESSION IGNITION (Diesel)
CA FOR DIESEL ENGINE SERVICE 1940's and 1950's
Service typical of diesel engines operated in mild to moderate duty with high
quality fuels and occasionally has included gasoline engines in mild service.
CB FOR DIESEL ENGINE SERVICE 1949.
mild to moderate duty, but with lower quality fuels which necessitate more protection from wear and deposits.
CC FOR DIESEL ENGINE SERVICE 1961
Service typical of certain naturally aspirated, turbo-charged or supercharged
diesel engines operated in moderate to severe duty service and certain heavy-duty
gasoline engines. Oils designed for this service provide protection from
high temperature deposits and bearing corrosion in these diesel engines and
also from rust, corrosion and low-temperature deposits in gasoline engines.
CD FOR DIESEL ENGINE SERVICE 1955
Service typical of certain naturally aspirated, turbocharged or supercharged
diesel engines where highly effective control of wear and deposits is vital, or
when using fuels of a wide quality range including high sulfur fuels. Oils
provide protection from bearing corrosion and from high-temperature deposits in these diesel engines.
CD-II FOR FOR SEVERE DUTY 2-STROKE
Service typical of 2-stroke cycle diesel engines requiring highly effective
control over wear and deposits. Oils designed for this service also meet all
performance requirements of API Service Category CD. (obsolete)
CE = 1983 DIESEL ENGINE SERVICE - certain turbocharged or supercharged heavy-duty diesel engines operated under both low speed high load and high speed high load conditions. Oils designed for this service must also meet the requirements of the API Engine Service Categories CC and CD.
CF = 1994 OFF-ROAD INDIRECT INJECTED DIESEL ENGINE SERVICE
off-road indirect injected diesel engines and other diesel engines that use a broad range of fuel types
including those using fuel with higher sulphur content, for example, over 0.5% wt. Effective control of piston deposits, wear and corrosion of copper-containing bearings is essential for these engines which may be naturally aspirated, turbocharged or supercharged. Oils designated for this service may also be
used when API Service Category CD is recommended.
CF-2 FOR 1994 SEVERE DUTY 2-STROKE CYCLE DIESEL ENGINE SERVICE
two-stroke cycle engines requiring highly effective control over cylinder and ring-face scuffing and
deposits. - may also be used when API Service Category CD-II is recommended. These oils do not necessarily meet the requirements of CF or CF-4 unless the oils have specifically met the performance requirements of these categories.
CF-4 FOR 1991 DIESEL ENGINE SERVICE
Service typical of severe duty turbocharged, 4-stroke cycle diesel engines, particularly late models designed to give lower emissions. These engines are usually found in on-highway, heavy duty truck applications. API CF-4 oils exceed the requirements of CE category oils and can be used in place of
earlier CC, CD and CE oils.
CG-4 FOR 1994 SEVERE DUTY DIESEL ENGINE SERVICE
For use in high speed, four-stroke cycle diesel engines used in highway and off-road applications where the fuel sulphur may vary from less than 0.05 percent to less than 0.5 percent by weight. CG-4 oils provide effective control over high temperature piston deposits, wear, corrosion, foaming, oxidation
stability and soot accumulation. These oils are especially effective in engines designed to meet 1994 emission standards and may also be used in engines requiring API Service Categories CD, CE and CF-4.
CH-4 FOR 1999 SEVERE DUTY DIESEL ENGINE SERVICE
For use in high speed, four-stroke cycle diesel engines used in highway and off-road applications, where the fuel contents range from less than 0.05% to less than 0.5% by weight. CH-4 oils provide superior control over high temperature piston deposits, wear, corrosion, foaming, oxidation stability and
soot accumulation. These oils have been specifically formulated for engines designed to meet November 1998 EPA emission standards and may be used where API CD, CE, CF-4 and CG-4 oils are required. Oils designated for this service have been available since 1999.
CI-4 (CI-4 PLUS) FOR 2002 SEVERE DUTY DIESEL ENGINE SERVICE
For use in high speed, four-stroke cycle diesel engines used in highway and off-road applications where fuel sulphur contents range from less than 0.05% to less than 0.5% by weight. This new category is designed to cope with stringent environmental emissions legislation and increased engine severity
caused by Exhaust Gas Recirculation (EGR). Oils designated for this service are currently available from Petro-Canada and may also be used where API CD, CE, CF-4, CG-4 and CH-4 oils are required.
CJ-4 FOR 2007 SEVERE DUTY DIESEL ENGINE SERVICE
For use in high-speed four-stroke cycle diesel engines designed to meet 2007 model year on-highway exhaust emission standards as well as for previous model years. These oils are compounded for use in all applications with diesel fuels ranging in sulphur content up to 500 ppm (0.05% by weight). However, the use of these oils with greater than 15 ppm (0.0015% by weight) sulphur fuel may impact exhaust after treatment system durability and/or oil drain interval.