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

Thread: JDE Decimal value

  1. #11
    Member
    Join Date
    Oct 2000
    Location
    Missoula, MT, USA
    Posts
    528

    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
    Posts
    18

    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

    FYI:
    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)

Similar Threads

  1. Incorrect decimal value
    By audioman in forum JD Edwards® EnterpriseOne Developers
    Replies: 1
    Last Post: 11-25-2010, 02:07 PM
  2. Convert Numeric with 4 decimal to 2 decimal
    By PCK in forum JD Edwards® EnterpriseOne
    Replies: 0
    Last Post: 03-15-2010, 09:40 PM
  3. Decimal Point
    By chokiti in forum JD Edwards® EnterpriseOne Developers
    Replies: 3
    Last Post: 02-25-2005, 10:22 AM
  4. Decimal Separators
    By Jamie_Yates in forum JD Edwards® EnterpriseOne Developers
    Replies: 4
    Last Post: 04-05-2002, 01:24 AM
  5. Decimal problems
    By dennisr in forum JD Edwards® EnterpriseOne Developers
    Replies: 2
    Last Post: 03-29-2002, 09:26 AM

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.