ERPRef.com

11 COLUMNS | 2 INDICIES 920 | H90 | F9050 Rough Cut Answer Dependency

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F9050	AX	11	2	Rough Cut Answer Dependency	Secondary Master Files	H90: EnterpriseOne TOOLS	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.

11 COLUMNS | TOP 920 | H90 | F9050 Rough Cut Answer Dependency

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

2 INDICIES | TOP 920 | H90 | F9050 Rough Cut Answer Dependency

1: Sy Cd UDC Parent Seq (Primary/Unique)

Element	Alias	Description	Sequence
1	SY	Product Code	Ascending
2	RT	User Defined Codes	Ascending
3	PKY	Parent for Hierarchical UDC processing	Ascending
4	DSPSEQ	Dsp Seq of items in Hierarchcal UDC proc	Ascending

2: Sy Cd UDC Parent Child

Element	Alias	Description	Sequence
1	SY	Product Code	Ascending
2	RT	User Defined Codes	Ascending
3	PKY	Parent for Hierarchical UDC processing	Ascending
4	CKY	ChildKey for Hierarchical UDC processing	Ascending