ERPRef.com

49 COLUMNS | 3 INDICIES 920 | 07 | F07825 Company Special Handling Control Table

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F07825	JA	49	3	Company Special Handling Control Table	Extra Features Files	07Y: US Payroll Year End

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 | 07 | F07825 Company Special Handling Control Table

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

3 INDICIES | TOP 920 | 07 | F07825 Company Special Handling Control Table

1: Year End ID Year +A (Primary/Unique)

Element	Alias	Description	Sequence
12	W2RT	Record Type	Ascending
11	DTCF	Date - Correction Form	Descending
10	TWYE	Type of W-2	Ascending
9	TFYE	Type of Form	Ascending
8	TAXX	Tax Identification Number	Ascending
7	PDBA	DBA Code	Ascending
6	WCTY	Work City	Ascending
5	WCNT	Work County	Ascending
4	WST	Work State	Ascending
3	HMCO	Company - Home	Ascending
2	DTEY	Date - YR	Ascending
1	IDYE	Year-End ID	Ascending

2: Year End ID Year +B

Element	Alias	Description	Sequence
4	PDBA	DBA Code	Ascending
3	HMCO	Company - Home	Ascending
2	DTEY	Date - YR	Ascending
1	IDYE	Year-End ID	Ascending

3: Year End ID Year +C

Element	Alias	Description	Sequence
9	HT05	Special Handling Tag 05	Ascending
8	DTCF	Date - Correction Form	Ascending
7	TWYE	Type of W-2	Ascending
6	TFYE	Type of Form	Ascending
5	W2RT	Record Type	Ascending
4	TAXX	Tax Identification Number	Ascending
3	HMCO	Company - Home	Ascending
2	DTEY	Date - YR	Ascending
1	IDYE	Year-End ID	Ascending