E9.2 - JDE Tables and definitions - JDELIST.com
2024年7月18日 · E9.2 JDE Tables and definitions. Thread starter hgnis. Start date Jul 18, 2024; hgnis. Member. Jul 18, 2024 #1
JDE System Tables | JDELIST.com - JD Edwards ERP Forums
2019年3月20日 · My employer is currently upgrading from JDE 7.3.3.3 to 9.2. NOTE: I am a developer, but I believe this is the correct forum to pose my question. 1) I created a new custom table F55XXXXX in 9.2 via the Table Design Aid. I generated the table and the indexes. 2) There are currently 3 JDE 9.2 DB Users - JDE, JDER, and JDEX.
List of all JD Edwards EnterpriseOne Application Tables and its ...
2008年12月17日 · Find the list of all JD Edwards EnterpriseOne application tables and their structures.
Making sense of JD Edwards tables - JDELIST.com
2010年7月13日 · All JDE table objects should start with an "F". To find column descriptions for a specific table, link F98711 and F9202, where TDOBNM is the table name, and TDOBND=FRDTAI. The columns you will want to pull are TDPSEQ (sequence number), TDSQLC (field id), and FRDSCR (field description).
JDE Tables | JDELIST.com - JD Edwards ERP Forums
2011年6月14日 · If you have command line access within the JDE environment, from the JDE menu where the Supply/Demand inquiry is run type option # 25 to see the name of the program being run (Jxxxxx). If the name begins with 'J', Replace the J with a P to get the RPG program name (Pxxxxx), then use the command DSPPGMREF Pxxxxx to see a list of the programs and ...
JDE Tables Schema Documentation - JDELIST.com
2008年9月9日 · Post 117268 - old 128717 for Links to JDE Documentation on the Oracle website Post 117562 - old 129018 for an attachment for a SQL that produces information about the Tables in the JDE Database - ( download attachment to Post 117562 - old 129018 )
World table list | JDELIST.com - JD Edwards ERP Forums
2006年7月19日 · If you go into the list of UDC tables (if you have access just type "UDC"), press F5 to view the code types. Specify a System Code (eg: "00") and this will display a list of the UDC tables for that system and how they are defined. This is also where you define your own tables for local programs. Hope this helps.
Auditing transaction tables | JDELIST.com - JD Edwards ERP Forums
2011年10月5日 · We just created F55xxxxL tables (such as F554101L) that the data base triggers write after images into. Then we created very simple JDE apps that can query these tables and linked the appropriate standard JDE apps to the Audit apps. So for example in Item Master Maintenance I can row exit on a Item to see the history of changes to that item.
Menu table F9000 | JDELIST.com - JD Edwards ERP Forums
2009年4月8日 · F9002 is the Alternate Description for a task. There are a couple of other Alternate Description tables as well (F9005D, F9006D). F9005 and F9006 contain the Variants; these records either enable or disable a task for a given role. This was at one time called "fine-cut". What you may be describing are "orphan" task relationships.
JDE Table List | JDELIST.com - JD Edwards ERP Forums
2011年7月9日 · We're upgrading from A7.3 cum 14 to E1 9.0 / windows /sql. There is a list of 80 FCW* work files in our E1 CRP environment. Does anyone know if these tables are part of the upgrade or are they needed for production? I can't find any info using the new Oracle KG search. Example: FCW01 Item Structure Detail FCW011 Item Level Type