Page 2 of 2 FirstFirst 1 2
Results 11 to 12 of 12

Thread: JDE Decimal value

  1. #11
    Join Date
    Oct 2000
    Missoula, MT, USA

    Re: RE: JDE Decimal value

    The Data Dictionary that defines the decimal values is in F9201. ALL JDE programs have sections that do the Data Dictionary retrieval of information for proper presentation so obviously you haven't looked at any of them.
    Sannan Solberg
    Functional Analyst/CreateForm
    E1 9.0/9.1/Tools 9.1
    CreateForm 7.x/CTIS

  2. #12
    New Member
    Join Date
    Dec 2000

    Re: RE: JDE Decimal value

    Ouch, details please!!!!!!!

    If you give us the SQL statement as an example & your ODBC connection
    string (without system name, user id, password).
    I am sure someone could provide better help. Although I think the question
    would probably be better for OneWorld group

    The data dictionary (DD for short). The table name is F9201, the library
    may not be the same as the data library.
    Without knowledge of the DD how do you know what field names (columns to
    you SQL people) mean.

    Another thing you need to know is that JDE uses a 2 character prefix for
    all there field names. I am 99% sure that all field names are 6 characters
    of less in length. So the DD only has position (3~6) ie IMITM, IMLITM,
    IMCRDJ would be ITM, LITM, CRDJ in the DD

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.