ToJDEDecimal Parameters

[tzdanows]

Inquiry about the Data Conversion Service ToJDEDecimal. I've pretty much switched to using the expression during the query to the database rather than this service but I was curious what the Dictionary parameter here is supposed to be. Its required and during our meeting today, we were all curious about it.

I'm attempting to change RPAG (Amount-Gross, Numeric) to contain decimal points rather than display as an integer.

[SteveCap]

Dictionary gets mapped to the FRDTAI column from the F9210 table for the majority of precisions. For currency it is mapped to CVCRCD in the F0013 table

[shalomsims]

Is this what you mean? Or would we need to create another Inquire service for CurrencyCode and Dictionary?

[SteveCap]

The service is going to run a query like:
SELECT FRCLAS, FRCDEC FROM F9210 WHERE FRDTA = {Dictionary}
If it finds a record and the FRCLAS column = 'currency' it will then run a query like:
SELECT CVCDEC FROM F0013 WHERE CVCRCD = {CurrecnyCode}

[mollydunn]

I'm still a little confused on how to fill out the service itself specifically the Dictionary and Currency code values. Is it necessary to create another inquire service?

[JustinVanRegenmorter]

Here is some documentation on how to setup and use this service.