TPPARAM – Tip Parameters

System
TP (TP)
Prefix
TPP
Primary key
COMPANY, PROCESS-LEVEL, DEPARTMENT, SHIFT
Fields
20
Updated by
5 programs
Referenced by
0 programs

TPPARAM is the Tip Parameters table in Lawson TP (prefix TPP). It is indexed by COMPANY, PROCESS-LEVEL, DEPARTMENT, SHIFT (TPPSET1). It is related 1:1 to PRSYSTEM and DEPTCODE and 1:M to EMPSUMM and TIPPAY. It is updated by PR195, PR197, PR582, PR82.1 and PR85.1. The table has 20 fields, 1 index and 5 documented relations.

About TPPARAM

No description in the Lawson data dictionary.

Fields (20)

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

Field / columnTypeDescription & valuesUpdated by
TPP-COMPANY PK
COMPANY		Numeric 4—PR195, PR197, PR582, PR82.1, PR85.1
TPP-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5Contains the process level the pay is associated with for allocation.—
TPP-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department the pay is associated with for allocation.—
TPP-SHIFT PK
SHIFT		Numeric 1Contains the shift number the allocation is associated with.—
TPP-ALLOC-METHOD
ALLOC_METHOD		Alpha 1Contains the value that determines the allocation method. Valid values are:
  • G Individual Gross Receipts.
  • H Hours Worked.
—
TPP-ALLOC-PCT
ALLOC_PCT		Signed 7.3Contains the allocation percent for the allocation method.—
TPP-EST-NAME
EST_NAME		Alpha 30 (Lower Case)Contains the establishment name.—
TPP-EST-ADDR1
EST_ADDR1		Alpha 30 (Lower Case)Contains the first line of the establishment address.—
TPP-EST-ADDR2
EST_ADDR2		Alpha 30 (Lower Case)Contains the second line of the establishment address.—
TPP-EST-ADDR3
EST_ADDR3		Alpha 30 (Lower Case)——
TPP-EST-ADDR4
EST_ADDR4		Alpha 30 (Lower Case)——
TPP-EST-CITY
EST_CITY		Alpha 58 (Lower Case)Contains the city of the establishment address.—
TPP-EST-STATE
EST_STATE		Alpha 2Contains the state of the establishment address.—
TPP-EST-ZIP
EST_ZIP		Alpha 10Contains the postal code of the establishment address.—
TPP-EST-NBR
EST_NBR		Alpha 30Contains the establishment number.—
TPP-LST-RUN-DATE
LST_RUN_DATE		Numeric 8 (yyyymmdd)Contains the system date that defaults when you run TP100 (Shortfall Allocation Calculation).—
TPP-LST-TIP-SEQ
LST_TIP_SEQ		Numeric 4Contains the number used to uniquely identify tip records.PR195, PR197, PR582, PR82.1, PR85.1
TPP-CTRL-TOT-FLG
CTRL_TOT_FLG		Alpha 1Contains the value that determines if the total employee gross receipts entered in TP20.2 (Employee Gross Receipts Allocation) must balance to the allocation level gross receipts before TP100 (Tip Shortfall Allocation) can be run.—
TPP-TRAN-CONT-CODE
TRAN_CONT_CODE		Alpha 5Contains the Transmitter Control Code assigned by the IRS.—
TPP-EST-TYPE
EST_TYPE		Alpha 1Contains the value that identifies the type of establishment. Valid values are:
  • 1 Evening meals only.
  • 2 Evening and other meals.
  • 3 Meals other than evening meals.
  • 4 Alcoholic beverages.
—

Indexes (1)

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

IndexKeysFlagsConditionUsed in
TPPSET1COMPANY, PROCESS-LEVEL, DEPARTMENT, SHIFTPrimaryPR195, PR197, PR582, PR82.1, PR85.1

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredTPP-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen TPP-DEPARTMENT != SpacesTPP-COMPANY → DPT-COMPANY, TPP-PROCESS-LEVEL → DPT-PROCESS-LEVEL, TPP-DEPARTMENT → DPT-DEPARTMENT
Process LevelPRSYSTEMRequiredWhen TPP-PROCESS-LEVEL != SpacesTPP-COMPANY → PRS-COMPANY, TPP-PROCESS-LEVEL → PRS-PROCESS-LEVEL

One to many (2) — child tables

RelationTableRulesConditionField map
Emp SummEMPSUMMDelete RestrictedTPP-COMPANY → ESM-COMPANY, TPP-PROCESS-LEVEL → ESM-PROCESS-LEVEL, TPP-DEPARTMENT → ESM-DEPARTMENT, TPP-SHIFT → ESM-SHIFT, → ESM-EMPLOYEE, → ESM-PAYROLL-YEAR, → ESM-LST-CALC-DATE
Tip PayTIPPAYDelete RestrictedTPP-COMPANY → TIP-COMPANY, TPP-PROCESS-LEVEL → TIP-TIP-PROC-LEV, TPP-DEPARTMENT → TIP-TIP-DEPART, TPP-SHIFT → TIP-SHIFT, → TIP-EMPLOYEE, → TIP-WRK-END-DATE, → TIP-SEQ-NBR

Programs

Updated by (5)