JDE Table List

Patrick3388

Member
Hello,

I am new in JDE.
Anyone can advise me the JDE Table List ?
E.g. F4071 Price Adjustment Type, F4072 Price Adjustment Detail

Thanks a lot !

Thanks & Regards,
Patrick
 
Welcome Patrick

There are a few ways to retrieve this information. One way is to use UTB or Databrowser (if applicable on your version) to view table F9860.

Enter F* into SIOBNM (Object Name) column, the table names will appear in the SIMD (Member Description) column.

Hope this helps
Aidy
 
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
FCW02 Item Structure Definition

Thanks.
 
EnterpriseOne 9.0 Table Listing in file numeric sequence in attached Excel file for download.
 

Attachments

  • 170527-EnterpriseOne 9.0 Table Listing Numeric Sort.xls
    620.5 KB · Views: 4,666
Table names starting with FCW* were created for a new module called "Apparel Solutions" in Enterprise One 9.0.2.

Regards,
Sankarguru Mani
 
Back
Top