Change Data Type Integer to Numeric Considerations
I have custom E1 Data Item (DD Item) that needs to be changed from Type Integer to Numeric (length 10) to eliminate the 5-digit entered-value design limitation for an Integer data type (re: Doc ID 626537.1, Question #18). I was not aware of this design limitation at the time I originally implemented the custom DD Item.
This custom DD Item is used across several tables, BSVWs, applications, etc. and is already in Production. In the JDE SQL DB I believe the column attributes for this data item will change from numeric(18,0) to float when making this Data Type change and regenerating the tables. I am running with a common set of DD tables for all pathcodes (JDE-supported configuration). I do not want to create a new DD item to replace the existing, as this will likely require as much or more change effort than changing the existing DD Item.