«

»

Jul 04 2013

What are the maximum number of columns in a JDE table?

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

Xe / ERP8

In releases XE and ERP 8, the maximum number of columns a table can have is 254. This is a predefined constant value.

8.9 and newer

Starting with the EnterpriseOne 8.9  release and later, Table Design Aid (TDA) was enhanced to call the JDB_GetTableProperties API, which retrieves table definition related constants from the table F9300 – Database Property Values. This API can be called either for a particular database or for E1 supported values, but when used by TDA, it always returns the ONEWORLD database type corresponding parameters values. Therefore, it is irrelevant what database type the system actually has; the tables created via TDA will respect the ONEWORLD constraints, not the specific database ones.

As an example, for EnterpriseOne releases 8.12 and 9.0, the maximum number of columns in a table (property MaxNumberColumnsInTable) is 500.

Beside the Maximum Number Of Columns In Table, the following table properties can also be found in the F9300:

  • Maximum Column Name Length
  • Maximum Index Name Length
  • Maximum Number Of Blobs In Table
  • Maximum Number Of Columns In Index
  • Maximum Number Of Indexes In Table
  • Maximum Table Name Length
  • Maximum Total Index Length
  • Maximum Total Row Length
  • Minimum Column Name Length
  • Minimum Index Name Length
  • Minimum Number Of Blobs In Table
  • Minimum Number Of Columns In Index
  • Minimum Number Of Columns In Table
  • Minimum Number Of Indexes In Table
  • Minimum Table Name Length
  • Minimum Total Index Length
  • Minimum Total Row Length

Changing the defined values in the F9300 – Database Property Values table is not recommended or supported.

Source – MOS: ID 1077277.1

Published under the license.

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
(Visited 16 times, 1 visits today)

About the author

Krishna Nambiar

Krishna Nambiar is a very experienced CNC Consultant and has worked on quite implementations, and other support projects. Very keen to share and help for the goodwill of others, he is one of the Administrators of JDESource.com.
Also being a budding Photographer, and an Avid Reader, you can get to know more about him via following profiles.

1 ping

  1. Oracle JDEdwards EnterpriseOne Table Trivia « E1 Tips E1 Tips

    […] at JDESource, has a great post about the JDEdwards table property […]

Leave a Reply