Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             RESTRANS FILE

                     Spending Account Transactions

The Spending Account Transactions file contains reimbursement records for
spending accounts. These transactions are maintained in BN59.1 (Spending
Account Transactions).

REFERENCED BY

BN232     BN258     BN100     BN101     BN102     BN103
BN105     BN259     BN31.1    BN31.2    BN32.1    BN32.2
BN32.3    BN531     BN70.1    BN71.1    BN72.1    BS32.1
HR170     HR70.1

UPDATED BY

BN430     BN59.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RTR-COMPANY          Numeric 4                                   BN59.1
Company              Contains the company number.

RTR-START-DATE       Numeric 8  (yyyymmdd)                       BN59.1
Start Date           Contains the start date for an
                     employee's spending account benefit. It
                     is equal to the BEN-START-DATE in the
                     BENEFIT file.

RTR-EMPLOYEE         Numeric 9                                   BN59.1
Employee             Contains the employee number.

RTR-PLAN-CODE        Alpha 4                                     BN59.1
Plan                 Contains the user-defined plan code
                     tied to a plan type of "RS" (Spending
                     Account).

RTR-DATE             Numeric 8  (yyyymmdd)                       BN59.1
Date                 Contains a date equal or later than
                     RTR-START-DATE.

RTR-CHECK-NBR        Numeric 8                                   BN59.1
Payment Number       Contains a check number tied to the
                     employee's reimbursement of expenses.

RTR-TRANS-AMT        Signed 11.2                                 BN59.1
Transaction Amount   Contains the eligible expense the
                     employee submitted to the employer for
                     reimbursement from his/her reserve
                     account.  If the PLN-PAY-EXP-FLG is
                     equal to "C," the total of the
                     transaction amounts cannot exceed the
                     BEN-YTD-CONT.  If the PLN-PAY-EXP-FLG is
                     equal to "A," the total transactions
                     cannot exceed the BEN-EMP-PRE-CONT plus
                     BEN-CMP-FLX-CONT.

RTR-DESC             Alpha 30  (Lower Case)                      BN59.1
Description          Contains a description of the
                     transaction. It can be a description of
                     services provided.

                         RESTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RTRSET1   COMPANY                                                BN232   BN258
          START-DATE                                             BN430
          EMPLOYEE
          PLAN-CODE
          DATE
          CHECK-NBR

RTRSET2   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PLAN-CODE                                              BN105   BN259
          START-DATE                                             BN31.1  BN31.2
          DATE                                                   BN32.1  BN32.2
          CHECK-NBR                                              BN32.3  BN531
                                                                 BN59.1  BN59.2
                                                                 BN59.3  BN70.1
                                                                 BN71.1  BN72.1
                                                                 BS32.1  HR170
                                                                 HR70.1

                         RESTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Benefit        BENEFIT      Required

                            RTR-COMPANY       -> BEN-COMPANY
                            "RS"              -> BEN-PLAN-TYPE
                            RTR-EMPLOYEE      -> BEN-EMPLOYEE
                            RTR-START-DATE    -> BEN-START-DATE
                            RTR-PLAN-CODE     -> BEN-PLAN-CODE

Company        BNCOMPANY    Required

                            RTR-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            RTR-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            RTR-COMPANY       -> EMP-COMPANY
                            RTR-EMPLOYEE      -> EMP-EMPLOYEE

Plan           PLAN         Required

                            RTR-COMPANY       -> PLN-COMPANY
                            "RS"              -> PLN-PLAN-TYPE
                            RTR-PLAN-CODE     -> PLN-PLAN-CODE