Results 1 to 6 of 6

Thread: How can i change length of DSC1 (F4101 Table) column up to 300 ??? is it possible ?

  1. #1

    How can i change length of DSC1 (F4101 Table) column up to 300 ??? is it possible ?

    My client ask to me want to input more informaion into DSC1 and DSC2 column of ITEM Master Table ( F4101 ).

    If there is a way... Please help me.
    Thanks.

  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,267
    No.
    Show the client Text Attachments
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3
    No the vanilla DD item cannot be changed . It is never recommended . In our case , there was such requirement to have some large fields like Marketing description , allergy information etc (in food business ) , so we create custom item tag and it has item # and other custom fields of larger description sizes as needed by business , custom application and reports .Our ecommerce gets info from there for web customers and mobile too

    Custom UBE to see everyday using outbound interoperability in F4101Z1 to see new items added and create entries in the custom tag to keep in synch always . Mass update application with grid given to business to update the records what they want .

  4. #4
    As others have said, the short answer is no. It has been tried before and always ends in tears (very expensive tears).

    As is mentioned, you can look at text attachments or a tag table mod. Another option to consider is AMS (https://amseam.com/) have an OVI extension that provides searchable 3000 character description fields for the item master.
    Russell Codlin
    www.rinami.com
    Capital Asset Management & Manufacturing Specialists
    REST Integration, IoT, Mobile Applications and Job Scheduling for all E1 releases from 9.2 back to 8.11SP1

  5. #5
    Member
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    53
    Don't even think about it. I uderstand the need and I think almost everyone want more positions in DSC1 but it will be a disaster now and in the future when you get esu's etc..
    JDE 9.2

  6. #6
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,603
    I've done it before, but I have to quote my favorite post on jdelist every time the subject of changing the size of a DD item comes up.

    If created by JDE, changing the size is equivalent to pointing a gun at your head and pulling the trigger.

    If created by you, changing the size is only equivalent to pointing the gun at your foot and pulling the trigger.

    - Larry Jones
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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 and, or Oracle.