ERPRef.com

49 COLUMNS | 10 INDICIES 920 | 31 | F31122 Work Order Time Transactions

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F31122	WT	49	10	Work Order Time Transactions	Transaction Files	31: Shop Floor Control	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.

49 COLUMNS | TOP 920 | 31 | F31122 Work Order Time Transactions

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

10 INDICIES | TOP 920 | 31 | F31122 Work Order Time Transactions

1: ProcessedCode AddressNo+A

Element	Alias	Description	Sequence
3	DGL	Date - For G/L (and Voucher)	Ascending
2	AN8	Address Number	Ascending
1	YST	Processed Code	Ascending

2: ProcessedCode UserID +A

Element	Alias	Description	Sequence
4	PBDT	Date - Time Clock Start	Ascending
3	UPMJ	Date - Updated	Ascending
2	USER	User ID	Ascending
1	YST	Processed Code	Ascending

3: ProcessedCode OrderNo +A

Element	Alias	Description	Sequence
5	TYR	Type of Hours	Ascending
4	OPSQ	Sequence Number - Operations	Ascending
3	DGL	Date - For G/L (and Voucher)	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
1	YST	Processed Code	Ascending

4: PayrollTransNo ProcessCode +A

Element	Alias	Description	Sequence
3	TYR	Type of Hours	Ascending
2	YST	Processed Code	Ascending
1	PRTR	Transaction No. - Payroll	Ascending

5: ProcessedCode SummaryRecord +A

Element	Alias	Description	Sequence
6	TYR	Type of Hours	Ascending
5	OPSQ	Sequence Number - Operations	Ascending
4	DCTO	Order Type	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
2	SUMR	Summary Record	Ascending
1	YST	Processed Code	Ascending

6: Unique Key ID (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

7: ProcessedCode OrderNo OpSeq +A

Element	Alias	Description	Sequence
4	TYR	Type of Hours	Ascending
3	OPSQ	Sequence Number - Operations	Ascending
2	YST	Processed Code	Ascending
1	DOCO	Document (Order No Invoice etc.)	Ascending

8: ProcessedCode OrderNo +B

Element	Alias	Description	Sequence
7	TYR	Type of Hours	Ascending
6	OPSQ	Sequence Number - Operations	Ascending
5	SHFT	Shift Code	Ascending
4	DGL	Date - For G/L (and Voucher)	Ascending
3	DCTO	Order Type	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
1	YST	Processed Code	Ascending

9: AddressNo ProcessedCode +

Element	Alias	Description	Sequence
4	TYR	Type of Hours	Ascending
3	OPSQ	Sequence Number - Operations	Ascending
2	YST	Processed Code	Ascending
1	AN8	Address Number	Ascending

10: OrderNo OpSeq TypHrs PID

Element	Alias	Description	Sequence
4	PID	Program ID	Ascending
3	TYR	Type of Hours	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
1	DOCO	Document (Order No Invoice etc.)	Ascending