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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET4
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 SET3
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TIPSET1
  1. COMPANY
  2. EMPLOYEE
  3. RECORD-DATE
  4. TIP-PROC-LEV
  5. TIP-DEPART
  6. SHIFT
  7. PAY-SUM-GRP
  8. CHECK-TYPE
  9. SEQ-NBR
Primary—
TIPSET2
  1. COMPANY
  2. TIP-PROC-LEV
  3. TIP-DEPART
  4. SHIFT
  5. RECORD-DATE
  6. EMPLOYEE
  7. PAY-SUM-GRP
  8. CHECK-TYPE
  9. SEQ-NBR
KeyChange—
TIPSET3
  1. COMPANY
  2. TIP-PROC-LEV
  3. TIP-DEPART
  4. SHIFT
  5. EMPLOYEE
  6. WRK-END-DATE
  7. SEQ-NBR
KeyChangeBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
TIPSET4
  1. COMPANY
  2. CHECK-TYPE
  3. EMPLOYEE
  4. CHECK-NBR
  5. SEQ-NBR
KeyChangePR85.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEDEPTCODEPAYSUMGRPTPPARAMTIPPAY

One to one (8) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
TIP-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
TIP-COMPANY→EMP-COMPANY
TIP-EMPLOYEE→EMP-EMPLOYEE
Hm DepartmentDEPTCODERequiredWhen TIP-HM-DEPT != Spaces
TIP-COMPANY→DPT-COMPANY
TIP-HM-PROC-LEV→DPT-PROCESS-LEVEL
TIP-HM-DEPT→DPT-DEPARTMENT
Hm Proc LevPRSYSTEMRequired
TIP-COMPANY→PRS-COMPANY
TIP-HM-PROC-LEV→PRS-PROCESS-LEVEL
Pay Sum GroupPAYSUMGRPRequired
TIP-COMPANY→PSG-COMPANY
TIP-PAY-SUM-GRP→PSG-PAY-SUM-GRP
Tip DepartmentDEPTCODERequiredWhen TIP-TIP-DEPART != Spaces
TIP-COMPANY→DPT-COMPANY
TIP-TIP-PROC-LEV→DPT-PROCESS-LEVEL
TIP-TIP-DEPART→DPT-DEPARTMENT
Tip Proc LevPRSYSTEMRequired
TIP-COMPANY→PRS-COMPANY
TIP-TIP-PROC-LEV→PRS-PROCESS-LEVEL
TpparamTPPARAMRequired
TIP-COMPANY→TPP-COMPANY
TIP-TIP-PROC-LEV→TPP-PROCESS-LEVEL
TIP-TIP-DEPART→TPP-DEPARTMENT
TIP-SHIFT→TPP-SHIFT

Programs

Updated by (43)