Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
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
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
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
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).


PTX-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

                         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