ERPRef.com

218 COLUMNS | 11 INDICIES 920 | 05T | F06116Z1 Employee Transactions - Batch File

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F06116Z1	VL	218	11	Employee Transactions - Batch File	Batch Input Files	05T: Time Entry	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.

218 COLUMNS | TOP 920 | 05T | F06116Z1 Employee Transactions - Batch File

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

11 INDICIES | TOP 920 | 05T | F06116Z1 Employee Transactions - Batch File

1: User Batch # + (Primary/Unique)

Element	Alias	Description	Sequence
4	EDLN	EDI - Line Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
2	EDBT	EDI - Batch Number	Ascending
1	EDUS	EDI - User ID	Ascending

2: User Batch # AN8 +

Element	Alias	Description	Sequence
6	EDTN	EDI - Transaction Number	Ascending
5	ICU	Batch Number	Ascending
4	DWK	Date - Worked	Ascending
3	AN8	Address Number	Ascending
2	EDBT	EDI - Batch Number	Ascending
1	EDUS	EDI - User ID	Ascending

4: AN8 DWK PRTR

Element	Alias	Description	Sequence
3	PRTR	Transaction No. - Payroll	Ascending
2	DWK	Date - Worked	Ascending
1	AN8	Address Number	Ascending

5: TaskID AN8 DWK

Element	Alias	Description	Sequence
4	PDBA	DBA Code	Ascending
3	DWK	Date - Worked	Ascending
2	AN8	Address Number	Ascending
1	TSKID	Task Unique Key ID	Ascending

6: EDBT

Element	Alias	Description	Sequence
1	EDBT	EDI - Batch Number	Ascending

7: AN8 PDBA DWK

Element	Alias	Description	Sequence
2	EDGL	Batch File Create G/L Record	Ascending
1	AN8	Address Number	Ascending

8: EDGL EDUS EDBT EDTN EDLN

Element	Alias	Description	Sequence
5	EDLN	EDI - Line Number	Ascending
4	EDTN	EDI - Transaction Number	Ascending
3	EDBT	EDI - Batch Number	Ascending
2	EDUS	EDI - User ID	Ascending
1	EDGL	Batch File Create G/L Record	Ascending

9: AN8 PDBA PANP

Element	Alias	Description	Sequence
3	PANP	Payroll ID - Input (Mode Unknown)	Ascending
2	PDBA	DBA Code	Ascending
1	AN8	Address Number	Ascending

10: AN8 SSREID DWK

Element	Alias	Description	Sequence
3	DWK	Date - Worked	Ascending
2	SSREID	Self Service Record Identifier	Ascending
1	AN8	Address Number	Ascending

11: Instance ID

Element	Alias	Description	Sequence
1	INSTID	Instance Identifier	Ascending

12: AN8 PDBA

Element	Alias	Description	Sequence
2	PDBA	DBA Code	Ascending
1	AN8	Address Number	Ascending