TIPPAY – Employee Tip Pay

System
Payroll (PR)
Prefix
TIP
Primary key
COMPANY, EMPLOYEE, RECORD-DATE, TIP-PROC-LEV, TIP-DEPART, SHIFT, PAY-SUM-GRP, CHECK-TYPE, SEQ-NBR
Fields
24
Updated by
43 programs
Referenced by
0 programs

TIPPAY is the Employee Tip Pay table in Lawson Payroll (prefix TIP). It is indexed by COMPANY, EMPLOYEE, RECORD-DATE, TIP-PROC-LEV, TIP-DEPART, SHIFT, PAY-SUM-GRP, CHECK-TYPE, SEQ-NBR (TIPSET1); alternate indexes: TIPSET2, TIPSET3 and TIPSET4. It is related 1:1 to PRSYSTEM, EMPLOYEE, DEPTCODE, PAYSUMGRP and TPPARAM. It is updated by BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 and 35 more. The table has 24 fields, 4 indexes and 8 documented relations.

About TIPPAY

No description in the Lawson data dictionary.

Fields (24)

Column = COBOL field name without the TIP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
TIP-COMPANY PK
COMPANY		Numeric 4—PR195, PR197, PR582, PR82.1, PR85.1
TIP-CHECK-TYPE PK
CHECK_TYPE		Alpha 1Contains the payment type.PR195, PR197, PR582, PR82.1, PR85.1
TIP-EMPLOYEE PK
EMPLOYEE		Numeric 9Employee number is assigned to each person employed by the firm. It is used to correlate all of the information related to that person.PR195, PR197, PR582, PR82.1, PR85.1
TIP-RECORD-DATE PK
RECORD_DATE		Numeric 8 (yyyymmdd)Contains the time record date.PR195, PR197, PR582, PR82.1, PR85.1
TIP-TIP-PROC-LEV PK
TIP_PROC_LEV		Alpha 5Contains the process level.PR195, PR197, PR582, PR82.1, PR85.1
TIP-TIP-DEPART PK
TIP_DEPART		Alpha 5Contains the department.PR195, PR197, PR582, PR82.1, PR85.1
TIP-SHIFT PK
SHIFT		Numeric 1Contains the shift number associated with the pay.PR195, PR197, PR582, PR82.1, PR85.1
TIP-PAY-SUM-GRP PK
PAY_SUM_GRP		Alpha 3Contains the pay summary group from the time record.PR195, PR197, PR582, PR82.1, PR85.1
TIP-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the automatically assigned sequence number from the time record.PR195, PR197, PR582, PR82.1, PR85.1
TIP-TIP-PAY-TYPE
TIP_PAY_TYPE		Numeric 1Contains the value that indicates if the pay is from direct or indirect tips as indicated on the pay summary group record.PR195, PR197, PR582, PR82.1, PR85.1
TIP-HM-PROC-LEV
HM_PROC_LEV		Alpha 5Contains the employee's home process level.PR195, PR197, PR582, PR82.1, PR85.1
TIP-HM-DEPT
HM_DEPT		Alpha 5Contains the employee's home department.PR195, PR197, PR582, PR82.1, PR85.1
TIP-RPT-TIPS-AMT
RPT_TIPS_AMT		Signed 9.2Contains the reportable tip payment amount.PR195, PR197, PR582, PR82.1, PR85.1
TIP-HOURS
HOURS		Signed 7.2Contains the hours associated with this record.PR195, PR197, PR582, PR82.1, PR85.1
TIP-CHECK-NBR
CHECK_NBR		Numeric 8Contains the payment number.PR195, PR197, PR582, PR82.1, PR85.1
TIP-CHECK-DATE
CHECK_DATE		Numeric 8 (yyyymmdd)Contains the payment date.PR195, PR197, PR582, PR82.1, PR85.1
TIP-STATUS
STATUS		Numeric 1Contains the record status.PR195, PR197, PR582, PR82.1, PR85.1
TIP-JOB-CODE
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job.PR195, PR197, PR582, PR82.1, PR85.1
TIP-TIP-CRED-AMT
TIP_CRED_AMT		Signed 9.2Contains the tip credit amount calculated on TP135 (Tip Calculation).PR85.1
TIP-WRK-END-DATE
WRK_END_DATE		Numeric 8 (yyyymmdd)Contains the work period end date which is determined by the employee's pay plan and the time record date.PR195, PR197, PR582, PR82.1, PR85.1
TIP-PAY-END-DATE
PAY_END_DATE		Numeric 8 (yyyymmdd)Contains the pay period end date which is determined by the employee's pay plan and the time record date.PR195, PR197, PR582, PR82.1, PR85.1
TIP-WORK-STATE
WORK_STATE		Alpha 2Identifies the state in which the workers' compensation plan is affective.PR195, PR197, PR582, PR82.1, PR85.1
TIP-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).PR195, PR197, PR582, PR82.1, PR85.1
TIP-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PR195, PR197, PR582, PR82.1, PR85.1

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TIPSET1COMPANY, EMPLOYEE, RECORD-DATE, TIP-PROC-LEV, TIP-DEPART, SHIFT, PAY-SUM-GRP, CHECK-TYPE, SEQ-NBRPrimary—
TIPSET2COMPANY, TIP-PROC-LEV, TIP-DEPART, SHIFT, RECORD-DATE, EMPLOYEE, PAY-SUM-GRP, CHECK-TYPE, SEQ-NBRKeyChange—
TIPSET3COMPANY, TIP-PROC-LEV, TIP-DEPART, SHIFT, EMPLOYEE, WRK-END-DATE, SEQ-NBRKeyChangeBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
TIPSET4COMPANY, CHECK-TYPE, EMPLOYEE, CHECK-NBR, SEQ-NBRKeyChangePR85.1

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredTIP-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredTIP-COMPANY → EMP-COMPANY, TIP-EMPLOYEE → EMP-EMPLOYEE
Hm DepartmentDEPTCODERequiredWhen TIP-HM-DEPT != SpacesTIP-COMPANY → DPT-COMPANY, TIP-HM-PROC-LEV → DPT-PROCESS-LEVEL, TIP-HM-DEPT → DPT-DEPARTMENT
Hm Proc LevPRSYSTEMRequiredTIP-COMPANY → PRS-COMPANY, TIP-HM-PROC-LEV → PRS-PROCESS-LEVEL
Pay Sum GroupPAYSUMGRPRequiredTIP-COMPANY → PSG-COMPANY, TIP-PAY-SUM-GRP → PSG-PAY-SUM-GRP
Tip DepartmentDEPTCODERequiredWhen TIP-TIP-DEPART != SpacesTIP-COMPANY → DPT-COMPANY, TIP-TIP-PROC-LEV → DPT-PROCESS-LEVEL, TIP-TIP-DEPART → DPT-DEPARTMENT
Tip Proc LevPRSYSTEMRequiredTIP-COMPANY → PRS-COMPANY, TIP-TIP-PROC-LEV → PRS-PROCESS-LEVEL
TpparamTPPARAMRequiredTIP-COMPANY → TPP-COMPANY, TIP-TIP-PROC-LEV → TPP-PROCESS-LEVEL, TIP-TIP-DEPART → TPP-DEPARTMENT, TIP-SHIFT → TPP-SHIFT

Programs

Updated by (43)