TPPARAM

Tip Parameters

Contains all company and allocation level parameters necessary to run the Tips system. It is created and maintained in TP00.1 (Company Allocation). You can print the information in this file using TP200 (Allocation Level Listing).
UPDATED BY
PR195 PR197 PR582 PR82.1 PR85.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPP-COMPANY
Element: Company Hr		Numeric 4
PR195 PR197
PR582 PR82.1
PR85.1
TPP-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
Contains the process level the pay is associated with for allocation.
TPP-DEPARTMENT
Element: Department		Alpha 5
Contains the department the pay is associated with for allocation.
TPP-SHIFT
Element: Shift		Numeric 1
Contains the shift number the allocation is associated with.
TPP-ALLOC-METHOD
Element: Alloc Method		Alpha 1
Contains the value that determines the allocation method. Valid values are: G = Individual Gross Receipts. H = Hours Worked.
TPP-ALLOC-PCT
Element: Alloc Pct		Signed 7.3
Contains the allocation percent for the allocation method.
TPP-EST-NAME
Element: Est Name		Alpha 30 (Lower Case)
Contains the establishment name.
TPP-EST-ADDR1
Element: Est Addr1		Alpha 30 (Lower Case)
Contains the first line of the establishment address.
TPP-EST-ADDR2
Element: Est Addr2		Alpha 30 (Lower Case)
Contains the second line of the establishment address.
TPP-EST-ADDR3
Element: Est Addr3		Alpha 30 (Lower Case)
TPP-EST-ADDR4
Element: Est Addr4		Alpha 30 (Lower Case)
TPP-EST-CITY
Element: Est City		Alpha 18 (Lower Case)
Contains the city of the establishment address.
TPP-EST-STATE
Element: Est State		Alpha 2
Contains the state of the establishment address.
TPP-EST-ZIP
Element: Est Zip		Alpha 10
Contains the postal code of the establishment address.
TPP-EST-NBR
Element: Est Nbr		Alpha 30
Contains the establishment number.
TPP-LST-RUN-DATE
Element: Lst Run Date		Numeric 8 (yyyymmdd)
Contains the system date that defaults when you run TP100 (Shortfall Allocation Calculation).
TPP-LST-TIP-SEQ
Element: Lst Tip Seq		Numeric 4
Contains the number used to uniquely identify tip records.
PR195 PR197
PR582 PR82.1
PR85.1
TPP-CTRL-TOT-FLG
Element: Ctrl Tot Flg		Alpha 1
Contains 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
Element: Tran Cont Code		Alpha 5
Contains the Transmitter Control Code assigned by the IRS.
TPP-EST-TYPE
Element: Est Type		Alpha 1
Contains 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.


TPPARAM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPPSET1 COMPANY
PROCESS-LEVEL
DEPARTMENT
SHIFT
PR195 PR197
PR582 PR82.1
PR85.1


TPPARAM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TPP-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Department DEPTCODE Required
When TPP-DEPARTMENT !=Spaces
TPP-COMPANY->DPT-COMPANY
TPP-PROCESS-LEVEL->DPT-PROCESS-LEVEL
TPP-DEPARTMENT->DPT-DEPARTMENT
Process Level PRSYSTEM Required
When TPP-PROCESS-LEVEL !=Spaces
TPP-COMPANY->PRS-COMPANY
TPP-PROCESS-LEVEL->PRS-PROCESS-LEVEL


TPPARAM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Emp Summ EMPSUMM Delete Restricted
TPP-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 Pay TIPPAY Delete Restricted
TPP-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

File created: Wed Jun 08 20:51:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.