We all know that most database tables in EnterpriseOne have a large number of columns. In fact, they usually push the limits of the RDBMS.
Well sometimes, you need a list of those columns for things like INSERT statements.
Below is how you can get the column names from a table in a SQL Server database:
USE JDE_PY910 SELECT [name] AS [Column Name] FROM syscolumns WHERE id = (SELECT id FROM sysobjects WHERE type = 'U' AND [Name] = 'F98950')
You can use either type V (views) or U (tables).