Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PSGTAXES


                             PSGTAXES FILE

                        Pay Summary Group Taxes

This file contains tax override information for specific pay summary groups.

REFERENCED BY

BN66.1    PR140     PR189     PR195     PR220     PR80.1
PR89.1

UPDATED BY

PR20.6    PR20.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PTX-COMPANY            Numeric 4                                 PR20.6
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

PTX-PAY-SUM-GRP        Alpha 3                                   PR20.6
Payment Summary        Contains status M (Manual Override) pay
Group                  summary groups for which tax overrides
                       are defined.

PTX-TAX-AUTH-TYPE      Alpha 2                                   PR20.6
Element: Tax Auth Type Contains the tax authority type to
                       which the tax override applies.
                       FD = Federal
                       ST = State
                       CI = City
                       CN = County
                       SD = School District
                       TD = Transportation District

PTX-AMT-PCT-FLAG       Alpha 1                                   PR20.6
Element: Amt Pct Flag  Contains the value that indicates if
                       the amount defined for the override is
                       an amount or percent.
                       A = Amount
                       P = Percent

PTX-TAX-AMT-PCT        Signed 11.2                               PR20.6
Tax Amount             Contains the amount of the override.
Percentage

PTX-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PTX-CURR-ND            Numeric 1
Account Currency
Code

                         PSGTAXES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTXSET1   COMPANY                                                BN66.1  PR140
          PAY-SUM-GRP                                            PR189   PR195
          TAX-AUTH-TYPE                                          PR20.2  PR20.6
                                                                 PR220   PR80.1
                                                                 PR89.1

                         PSGTAXES FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PTX-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Pay Sum Grp    PAYSUMGRP    Required

                            PTX-COMPANY        -> PSG-COMPANY
                            PTX-PAY-SUM-GRP    -> PSG-PAY-SUM-GRP