Lawson Insight Technical Documentation

                            TASERVCODE FILE

REFERENCED BY

BN150     ET530     ET700     ETI2.1    LP02.1    LP03.1
LP03.2    LP03.3    LP03.4    LP03.5    LP03.6    LP09.2
LP130     LP140     LP201     LP203     LP208     LP209
LP210     LP260     LP262     LP53.1    LP54.1    LP553
LP554     LP60.1    PR128     PR130     PR131     PR132
PR134     PR135     PR136     PR137     PR189     PR20.4
PR29.1    PR30.1    PR32.1    PR32.2    PR33.1    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR35.9    PR36.1    PR37.1    PR45.1
PR529     PR530     PR560     PR80.1    PR82.1    UK102
UK560     TA147

UPDATED BY

LP08.2    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TSC-COMPANY            Numeric 4                                 LP08.2
Element: Company Hr

TSC-SERVICE-CODE       Alpha 4                                   LP08.2
Element: Ta Service Cd

TSC-DESCRIPTION        Alpha 30  (Lower Case)                    LP08.2
Element: Ta Description

TSC-EVENT              Numeric 1                                 LP08.2
Element: Lp Event      0 = No
                       1 = Yes

TSC-REASON-CODE        Alpha 4                                   LP08.2
Element: Ta Reason Code

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

TSC-CURR-ND            Numeric 1                                 LP08.2
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


TSC-STATUS             Numeric 1                                 LP08.2
Element: Ta Status     0 = Active
                       1 = Inactive

                         TASERVCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TSCSET1   COMPANY                                                BN150   ET530
          SERVICE-CODE                                           ET700   ETI2.1
                                                                 HR00.1  HR01.1
                                                                 LP02.1  LP03.1
                                                                 LP03.2  LP03.3
                                                                 LP03.4  LP03.5
                                                                 LP03.6  LP08.2
                                                                 LP08.3  LP08.4
                                                                 LP09.2  LP130
                                                                 LP140   LP201
                                                                 LP203   LP208
                                                                 LP209   LP210
                                                                 LP260   LP262
                                                                 LP53.1  LP54.1
                                                                 LP553   LP554
                                                                 ...

                         TASERVCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TSC-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When (TSC-CURRENCY-CODE != Spaces )

                            TSC-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Reason Code    TAREASCODE   Required
                            When (TSC-REASON-CODE != Spaces )

                            TSC-COMPANY          -> TRE-COMPANY
                            TSC-REASON-CODE      -> TRE-REASON-CODE

                         TASERVCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ta Service     TASERVICE    Delete Cascades

                            TSC-COMPANY          -> TSV-COMPANY
                            TSC-SERVICE-CODE     -> TSV-SERVICE-CODE
                                                    TSV-SERVICE-CLASS