|
|
EMPGROSS FILE
Employee Gross Tips
Contains the gross receipts generated by individual employees. You can print
the information in this file using TP120 (Gross Receipts Edit by Employee).
REFERENCED BY
TP120
UPDATED BY
TP100 TP105 TP125 TP20.1 TP20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EGR-COMPANY Numeric 4 TP125 TP20.1
Element: Company Hr Identifies the AP company if the TP20.2
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
EGR-PROCESS-LEVEL Alpha 5 TP125 TP20.1
Element: Process Lev HrContains the process level the pay is TP20.2
associated with for allocation.
EGR-DEPARTMENT Alpha 5 TP125 TP20.1
Element: Department Contains the department the pay is TP20.2
associated with for allocation.
EGR-SHIFT Numeric 1 TP125 TP20.1
Element: Shift Contains the shift number the TP20.2
allocation is associated with.
EGR-RECORD-DATE Numeric 8 (yyyymmdd) TP125 TP20.1
Element: Record Date Contains the record date of the TP20.2
transaction.
EGR-EMPLOYEE Numeric 9 TP125 TP20.1
Element: Employee Contains the employee number. Each TP20.2
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all information related to that person.
EGR-STATUS Numeric 1 TP100 TP125
Element: Status Contains the transaction status. Valid TP20.1 TP20.2
values are:
0 = Current year not used in
calculation.
1 = Released.
2 = Current year not maintained.
3 = Current year maintained.
6 = Previous year not maintained.
9 = Year end close performed.
EGR-RCPT Signed 11.2 TP20.1 TP20.2
Element: Rcpt Contains the employee gross receipts
for this transaction.
EGR-CURRENCY-CODE Alpha 5 TP125 TP20.1
Element: Currency Code This field contains the company base TP20.2
currency code established in Company
(GL10.1 ).
EGR-CURR-ND Numeric 1 TP125 TP20.1
Account Currency Represents the number of decimals TP20.2
Code defined for the currency of the object.
EMPGROSS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EGRSET1 COMPANY TP100 TP125
PROCESS-LEVEL TP20.1
DEPARTMENT
SHIFT
RECORD-DATE
EMPLOYEE
EGRSET2 COMPANY TP100 TP105
EMPLOYEE TP120 TP20.2
RECORD-DATE
PROCESS-LEVEL
DEPARTMENT
SHIFT
EMPGROSS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Alc Gross ALCGROSS Required
EGR-COMPANY -> AGR-COMPANY
TPP-ALLOC-METHOD -> AGR-ALLOC-METHOD
EGR-PROCESS-LEVEL -> AGR-PROCESS-LEVEL
EGR-DEPARTMENT -> AGR-DEPARTMENT
EGR-SHIFT -> AGR-SHIFT
EGR-RECORD-DATE -> AGR-RECORD-DATE
Company PRSYSTEM Required
EGR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
EGR-COMPANY -> DPT-COMPANY
EGR-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
EGR-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
EGR-COMPANY -> EMP-COMPANY
EGR-EMPLOYEE -> EMP-EMPLOYEE
Process Level PRSYSTEM Required
EGR-COMPANY -> PRS-COMPANY
EGR-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Tip Control TIPCTL Required
EGR-COMPANY -> TPC-COMPANY
EGR-PROCESS-LEVEL -> TPC-PROCESS-LEVEL
EGR-DEPARTMENT -> TPC-DEPARTMENT
EGR-SHIFT -> TPC-SHIFT
EGR-RECORD-DATE -> TPC-RECORD-DATE
Tpparam TPPARAM Required
EGR-COMPANY -> TPP-COMPANY
EGR-PROCESS-LEVEL -> TPP-PROCESS-LEVEL
EGR-DEPARTMENT -> TPP-DEPARTMENT
EGR-SHIFT -> TPP-SHIFT
EMPGROSS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Alc Summ ALCSUMM Delete Restricted
EGR-COMPANY -> ASM-COMPANY
EGR-PROCESS-LEVEL -> ASM-PROCESS-LEVEL
EGR-DEPARTMENT -> ASM-DEPARTMENT
EGR-SHIFT -> ASM-SHIFT
ASM-PAYROLL-YEAR
Emp Summ EMPSUMM Delete Restricted
EGR-COMPANY -> ESM-COMPANY
EGR-PROCESS-LEVEL -> ESM-PROCESS-LEVEL
EGR-DEPARTMENT -> ESM-DEPARTMENT
EGR-SHIFT -> ESM-SHIFT
EGR-EMPLOYEE -> ESM-EMPLOYEE
ESM-PAYROLL-YEAR
ESM-LST-CALC-DATE
Tip Pay TIPPAY Delete Restricted
EGR-COMPANY -> TIP-COMPANY
EGR-PROCESS-LEVEL -> TIP-TIP-PROC-LEV
EGR-DEPARTMENT -> TIP-TIP-DEPART
EGR-SHIFT -> TIP-SHIFT
EGR-EMPLOYEE -> TIP-EMPLOYEE
EGR-RECORD-DATE -> TIP-WRK-END-DATE
TIP-SEQ-NBR
|
