ERPRef.com

209 COLUMNS | 8 INDICIES 920 | 41 | F4101 Item Master

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F4101	IM	209	8	Item Master	Master Files	41: Inventory Management	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.

209 COLUMNS | TOP 920 | 41 | F4101 Item Master

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

8 INDICIES | TOP 920 | 41 | F4101 Item Master

1: Item Master (Primary/Unique)

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending

2: 2nd Item Number (Unique)

Element	Alias	Description	Sequence
1	LITM	2nd Item Number	Ascending

3: 3rd Item Number (Unique)

Element	Alias	Description	Sequence
1	AITM	3rd Item Number	Ascending

4: Search Text Compressed

Element	Alias	Description	Sequence
1	ALN	Search Text - Compressed	Ascending

5: Low level Code

Element	Alias	Description	Sequence
1	LLX	Low Level Code	Descending

6: Segment1 Seg 2 +

Element	Alias	Description	Sequence
10	SEG0	Segment 10	Ascending
9	SEG9	Segment 9	Ascending
8	SEG8	Segment 8	Ascending
7	SEG7	Segment 7	Ascending
6	SEG6	Segment 6	Ascending
5	SEG5	Segment 5	Ascending
4	SEG4	Segment 4	Ascending
3	SEG3	Segment 3	Ascending
2	SEG2	Segment 2	Ascending
1	SEG1	Segment 1	Ascending

7: Template

Element	Alias	Description	Sequence
1	TMPL	Template	Ascending

8: Description Line1

Element	Alias	Description	Sequence
1	DSC1	Description	Ascending