|
|
YEALLOC FILE
Year End Tip Allocation
Contains the year-to-date direct and indirect reported tips, tips shortfall,
and shortfall allocation. The information in this file is used to print the
allocated shortfall amount on employee W-2 forms. You can print the
information in this file using TP110 (Year End Shortfall Closing)
or TP210 (Year End Shortfall Report).
UPDATED BY
TP100 TP105
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
YEA-COMPANY Numeric 4 TP100
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
YEA-PAYROLL-YEAR Numeric 4 TP100
Element: Current PayrolContains the payroll year in which the
allocation was taken.
YEA-EMPLOYEE Numeric 9 TP100
Element: Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all information related to that person.
YEA-HM-PROC-LEV Alpha 5 TP100
Element: Process Lev HrContains the process level in which the
tips were reported.
YEA-HM-DEPT Alpha 5 TP100
Element: Department Contains the department in which the
tips were reported.
YEA-YTD-RPT-TIPS Signed 13.2 TP100
Year-to-date Contains the year-to-date reported tips.
Reported Tips
YEA-YTD-SHORTFALL Signed 13.2 TP100
Year-to-date Tips Contains the year-to-date tips
Shortfall shortfall.
YEA-YTD-SF-ALLOC Signed 13.2 TP100
Year-to-date Contains the year-to-date shortfall
Shortfall Alloc allocation.
YEA-YTD-IND-TIPS Signed 13.2 TP100
Element: Ytd Ind Tips Contains the year-to-date indirect tips.
YEA-CURRENCY-CODE Alpha 5 TP100
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
YEA-CURR-ND Numeric 1 TP100
Account Currency Represents the number of decimals
Code defined for the currency of the object.
YEALLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
YEASET1 COMPANY TP100 TP105
PAYROLL-YEAR
EMPLOYEE
HM-PROC-LEV
HM-DEPT
YEALLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
YEA-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When YEA-HM-DEPT != Spaces
YEA-COMPANY -> DPT-COMPANY
YEA-HM-PROC-LEV -> DPT-PROCESS-LEVEL
YEA-HM-DEPT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
YEA-COMPANY -> EMP-COMPANY
YEA-EMPLOYEE -> EMP-EMPLOYEE
Process Level PRSYSTEM Required
YEA-COMPANY -> PRS-COMPANY
YEA-HM-PROC-LEV -> PRS-PROCESS-LEVEL
YEALLOC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Emp Summ EMPSUMM Delete Restricted
YEA-COMPANY -> ESM-COMPANY
YEA-PAYROLL-YEAR -> ESM-PAYROLL-YEAR
YEA-EMPLOYEE -> ESM-EMPLOYEE
YEA-HM-PROC-LEV -> ESM-PROCESS-LEVEL
YEA-HM-DEPT -> ESM-DEPARTMENT
ESM-SHIFT
|
