JDE Schema (910) F0005 table definition

13 COLUMNS | 3 INDICIES 910 | H95 | F0005 User Defined Code Values

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
910	F0005	DR	13	3	User Defined Code Values	Extra Features Files	H95: Tech Resources/Applications	Control Tables

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

Select SQL

Insert SQL

Update SQL

Create SQL

13 COLUMNS | TOP 910 | H95 | F0005 User Defined Code Values

	Col#	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement

3 INDICIES | TOP 910 | H95 | F0005 User Defined Code Values

1: System Type Code (Primary/Unique)

Element	Alias	Description	Sequence
1	SY	Product Code	Ascending
2	RT	User Defined Codes	Ascending
3	KY	User Defined Code	Ascending

2: System Type Desc 2 Code (Unique)

Element	Alias	Description	Sequence
1	SY	Product Code	Ascending
2	RT	User Defined Codes	Ascending
3	DL02	Description 02	Ascending
4	KY	User Defined Code	Ascending

3: System Type Desc 1

Element	Alias	Description	Sequence
1	SY	Product Code	Ascending
2	RT	User Defined Codes	Ascending
3	DL01	Description	Ascending