ERPRef.com

10 COLUMNS | 2 INDICIES 920 | 06 | F06017 Employee Tax Exceptions/Overrides

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F06017	YA	10	2	Employee Tax Exceptions/Overrides	Master Files	06: Payroll (old) - Obsolete-do not reuse	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.

10 COLUMNS | TOP 920 | 06 | F06017 Employee Tax Exceptions/Overrides

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

2 INDICIES | TOP 920 | 06 | F06017 Employee Tax Exceptions/Overrides

1: Address Number Statutory.. +A (Primary/Unique)

Element	Alias	Description	Sequence
4	PTAX	Tax Type	Ascending
3	TARO	Tax Area Overridden	Ascending
2	SC01	Statutory Code 01	Ascending
1	AN8	Address Number	Ascending

2: Address Number Tax Area.. +A

Element	Alias	Description	Sequence
4	SC01	Statutory Code 01	Ascending
3	PTAX	Tax Type	Ascending
2	TARO	Tax Area Overridden	Ascending
1	AN8	Address Number	Ascending