Results 1 to 4 of 4

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,260
    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

Thread Information

Users Browsing this Thread

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

  1. ravikumaroo7

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.