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 Hr

PTX-PAY-SUM-GRP        Alpha 3                                   PR20.6
Element: Pay Sum Grp   Contains status M (Manual Override) pay
                       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-TAX-AMT-PCT        Signed 13.4                               PR20.6
Element: Tax Amt Pct   Contains the amount of the override.

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-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
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


                         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