ERPRef.com

22 COLUMNS | 4 INDICIES 920 | 13 | F1307 Status History File

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F1307	F1	22	4	Status History File	History Files	13: Plant/Equipment 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.

22 COLUMNS | TOP 920 | 13 | F1307 Status History File

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

4 INDICIES | TOP 920 | 13 | F1307 Status History File

1: Type of Record Record Number+ (Primary/Unique)

Element	Alias	Description	Sequence
6	DOCO	Document (Order No Invoice etc.)	Ascending
5	EWST	Equipment / Work Order Status	Ascending
4	BEGT	Time Beginning	Descending
3	EFTB	Date - Beginning Effective	Descending
2	NUMR	Record Number	Ascending
1	TREC	Type of Record	Ascending

2: Status Type of Record +

Element	Alias	Description	Sequence
5	BEGT	Time Beginning	Ascending
4	EFTB	Date - Beginning Effective	Ascending
3	NUMR	Record Number	Ascending
2	TREC	Type of Record	Ascending
1	EWST	Equipment / Work Order Status	Ascending

3: Type of Record Work Order +

Element	Alias	Description	Sequence
4	BEGT	Time Beginning	Descending
3	EFTB	Date - Beginning Effective	Descending
2	DOCO	Document (Order No Invoice etc.)	Ascending
1	TREC	Type of Record	Ascending

4: Status Type of Record +A

Element	Alias	Description	Sequence
5	BEGT	Time Beginning	Ascending
4	EFTB	Date - Beginning Effective	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
2	TREC	Type of Record	Ascending
1	EWST	Equipment / Work Order Status	Ascending