RESTRANS – Spending Account Transactions

System
Benefits (BN)
Prefix
RTR
Primary key
COMPANY, START-DATE, EMPLOYEE, PLAN-CODE, DATE, CHECK-NBR
Fields
8
Updated by
2 programs
Referenced by
26 programs

RESTRANS is the Spending Account Transactions table in Lawson Benefits (prefix RTR). It is indexed by COMPANY, START-DATE, EMPLOYEE, PLAN-CODE, DATE, CHECK-NBR (RTRSET1); alternate indexes: RTRSET2. It is related 1:1 to BENEFIT, BNCOMPANY, PRSYSTEM, EMPLOYEE and PLAN. It is updated by BN430 and BN59.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN232, BN258, BN259 and 18 more. The table has 8 fields, 2 indexes and 5 documented relations.

About RESTRANS

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

Fields (8)

Column = COBOL field name without the RTR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RTR-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN59.1
RTR-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the start date for an employee's spending account benefit. It is equal to the BEN-START-DATE in the BENEFIT file.BN59.1
RTR-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number.BN59.1
RTR-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains the user-defined plan code tied to a plan type of "RS" (Spending Account).BN59.1
RTR-DATE PK
DATE		Numeric 8 (yyyymmdd)Contains a date equal or later than RTR-START-DATE.BN59.1
RTR-CHECK-NBR PK
CHECK_NBR		Numeric 8Contains a check number tied to the employee's reimbursement of expenses.BN59.1
RTR-TRANS-AMT
TRANS_AMT		Signed 11.2Contains 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.BN59.1
RTR-DESC
DESC		Alpha 30 (Lower Case)Contains a description of the transaction. It can be a description of services provided.BN59.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RTRSET1COMPANY, START-DATE, EMPLOYEE, PLAN-CODE, DATE, CHECK-NBRPrimaryBN232, BN258, BN430
RTRSET2COMPANY, EMPLOYEE, PLAN-CODE, START-DATE, DATE, CHECK-NBRBN100, BN101, BN102, BN103, BN105, BN259, BN31.1, BN31.2 +19 more

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
BenefitBENEFITRequiredRTR-COMPANY → BEN-COMPANY, "RS" → BEN-PLAN-TYPE, RTR-EMPLOYEE → BEN-EMPLOYEE, RTR-START-DATE → BEN-START-DATE, RTR-PLAN-CODE → BEN-PLAN-CODE
CompanyBNCOMPANYRequiredRTR-COMPANY → BNC-COMPANY
Company NamePRSYSTEMRequiredRTR-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredRTR-COMPANY → EMP-COMPANY, RTR-EMPLOYEE → EMP-EMPLOYEE
PlanPLANRequiredRTR-COMPANY → PLN-COMPANY, "RS" → PLN-PLAN-TYPE, RTR-PLAN-CODE → PLN-PLAN-CODE

Programs

Updated by (2)

Referenced by (26)