ERPRef.com

44 COLUMNS | 11 INDICIES 812 | 07 | F06156 Pay Check History Summary

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
812	F06156	YU	44	11	Pay Check History Summary	History Files	07: Payroll	AS400 Coexistence Tables

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.

44 COLUMNS | TOP 812 | 07 | F06156 Pay Check History Summary

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

11 INDICIES | TOP 812 | 07 | F06156 Pay Check History Summary

1: Address Num Check Cntrl +A (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CKCN	Check Control Number	Ascending
3	ICC	Interim Check Code	Ascending
4	SCKC	Check Control Number(Subsequent)	Ascending

2: Doc Check GL Bank Accnt +A

Element	Alias	Description	Sequence
1	DOCM	Document - Matching(Payment or Item)	Ascending
2	CKD	Date - Check	Ascending
3	GLBA	G/L Bank Account	Ascending

3: Address Num Check Date

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CKD	Date - Check	Ascending

4: GL Bank Accnt Check Date +A

Element	Alias	Description	Sequence
1	GLBA	G/L Bank Account	Ascending
2	CKD	Date - Check	Ascending
3	DOCM	Document - Matching(Payment or Item)	Ascending
4	CKCN	Check Control Number	Ascending
5	AN8	Address Number	Ascending

5: Check Date Doc Check +A

Element	Alias	Description	Sequence
1	CKD	Date - Check	Ascending
2	DOCM	Document - Matching(Payment or Item)	Ascending
3	GLBA	G/L Bank Account	Ascending

6: GL Bank Accnt Doc Check +A

Element	Alias	Description	Sequence
1	GLBA	G/L Bank Account	Ascending
2	DOCM	Document - Matching(Payment or Item)	Ascending
3	CKD	Date - Check	Ascending

7: Address Num Doc Check +A

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DOCM	Document - Matching(Payment or Item)	Ascending
3	GLBA	G/L Bank Account	Ascending

8: Company Home Address Num +A

Element	Alias	Description	Sequence
1	HMCO	Company - Home	Ascending
2	AN8	Address Number	Ascending
3	CKD	Date - Check	Ascending

9: GL Bank Acct Doc No Succ +A

Element	Alias	Description	Sequence
1	GLBA	G/L Bank Account	Ascending
2	DOCS	Document #- Successor	Ascending
3	DOCM	Document - Matching(Payment or Item)	Ascending
4	CKD	Date - Check	Ascending
5	CKCN	Check Control Number	Ascending
6	AN8	Address Number	Ascending
7	ICS	Interim Check Status	Ascending

10: Address Num Period End Date

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PPED	Date - Pay Period Ending	Ascending

11: Address Num Check Cntrl B

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CKCN	Check Control Number	Ascending
3	PPED	Date - Pay Period Ending	Ascending