ERPRef.com

14 COLUMNS | 2 INDICIES 910 | 31 | F3102T Work Order Variance Tag - Needed for upgrade

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
910	F3102T	IG	14	2	Work Order Variance Tag - Needed for upgrade	Balance Files	89: Conversion Programs	Business Data

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.

14 COLUMNS | TOP 910 | 31 | F3102T Work Order Variance Tag - Needed for upgrade

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

2 INDICIES | TOP 910 | 31 | F3102T Work Order Variance Tag - Needed for upgrade

1: OrderNumber ParentChildRlt (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	PART	Parent Child Relationship	Ascending
3	ITM	Item Number - Short	Ascending
4	COST	Cost Component	Ascending

2: OrderNumber ItemNumber

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	ITM	Item Number - Short	Ascending
3	COST	Cost Component	Ascending