Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TPPARAM


                              TPPARAM FILE

                             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

AC542     PR195     PR197     PR82.1    PR85.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TPP-COMPANY            Numeric 4                                 AC542   PR195
Element: Company       The company number represents an          PR197   PR82.1
                       established company and is entered on     PR85.1
                       all function codes.

TPP-PROCESS-LEVEL      Alpha 5
Element: Process Level Contains the process level the pay is
                       associated with for allocation.

TPP-DEPARTMENT         Alpha 5
Element: Department    Contains the department the pay is
                       associated with for allocation.

TPP-SHIFT              Numeric 1
Element: Shift         Contains the shift number the
                       allocation is associated with.

TPP-ALLOC-METHOD       Alpha 1
Element: Allocation MetContains the value that determines the
                       allocation method. Valid values are:

                       G = Individual Gross Receipts.
                       H = Hours Worked.


TPP-ALLOC-PCT          Signed 7.3
Element: Allocation PerContains the allocation percent for the
                       allocation method.

TPP-EST-NAME           Alpha 30  (Lower Case)
Element: Establishment Contains the establishment name.

TPP-EST-ADDR1          Alpha 30  (Lower Case)
Establishment          Contains the first line of the
Address 1              establishment address.

TPP-EST-ADDR2          Alpha 30  (Lower Case)
Establishment          Contains the second line of the
Address 2              establishment address.

TPP-EST-ADDR3          Alpha 30  (Lower Case)
Element: Address 3

TPP-EST-ADDR4          Alpha 30  (Lower Case)
Element: Address 4

TPP-EST-CITY           Alpha 21  (Lower Case)
Element: Establishment Contains the city of the establishment
                       address.

TPP-EST-STATE          Alpha 2
Element: Establishment Contains the state of the establishment
                       address.

TPP-EST-ZIP            Alpha 10
Establishment Zip      Contains the postal code of the
Code                   establishment address.

TPP-EST-NBR            Alpha 30
Element: Establishment Contains the establishment number.

TPP-LST-RUN-DATE       Numeric 8  (yyyymmdd)
Element: Last Run Date Contains the system date that defaults
                       when you run TP100 (Shortfall Allocation
                       Calculation).

TPP-LST-TIP-SEQ        Numeric 4                                 AC542   PR195
Element: Lst Tip Seq   Contains the number used to uniquely      PR197   PR82.1
                       identify tip records.                     PR85.1

TPP-CTRL-TOT-FLG       Alpha 1
Element: Ctrl Tot Flg  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     Alpha 5
Element: Tran Cont CodeContains the Transmitter Control Code
                       assigned by the IRS.

TPP-EST-TYPE           Alpha 1
Element: Est Type      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                                                AC542   PR195
          PROCESS-LEVEL                                          PR197   PR82.1
          DEPARTMENT                                             PR85.1
          SHIFT

                         TPPARAM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           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       RELATED
 NAME           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