Numeric Will Never Equal Alpha

Read Time:44 Sec

Apples to Oranges Here is a really frustrating thing about some tables or files, depending on your IT dialect, with in EnterpriseOne. After working with EnterpriseOne for awhile (10 minutes should do) you will notice that the omniscient creators of the application did not like to make things easy. Take, for instance, the issue that Alan VanNice addresses on his blog: joining the F4211 (Sales Orders) and the F4801 (Work Orders).

Our staff has talked about this a number of times. It is a strange way of relating tables. You see the RORN on the F4801 is an alpha field where the DOCO field on the F4211 is numeric. Now, this issue can be overcome fairly easily in SQL with a CAST function. However, inside of E1 the issue is a little more complicated. Alan does a great job explaining his method using the EnterpriseOne Report Design Aid.

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post Escape From SQL
Next post EnterpriseOne CNC Admins Need To Know Everything About Everything