Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNPAYDETL


                             BNPAYDETL FILE

                         Benefit Payment Detail

The Benefit Payment Detail file contains payment information for COBRA
participants and retirees. Each payment is stored by invoice number and
general ledger posting account. BN81.1 (Cash Entry) is the primary program
that loads this file.

REFERENCED BY

BN190     BN281     BN82.1

UPDATED BY

BN480     BN81.1    BN81.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BPD-COMPANY            Numeric 4                                 BN81.1  BN81.2
Element: Company Hr    Contains the company number. The number
                       correlates all information about the
                       company.

BPD-EMPLOYEE           Numeric 9                                 BN81.1  BN81.2
Element: Employee      Contains the employee's number. The
                       number correlates all information about
                       the employee.

BPD-PARTICIPNT         Numeric 9                                 BN81.1  BN81.2
Element: Participnt    Contains COBRA participant numbers. The
                       number correlates all information about
                       the COBRA participant.

BPD-TYPE               Alpha 2                                   BN81.1  BN81.2
Element: Type          Indicates whether the cash entry is for
                       a payment or a credit memo.
                       CK = Payment
                       CM = Credit Memo

BPD-CHECK-NBR          Numeric 8                                 BN81.1  BN81.2
Element: Check Nbr     Contains the payment number.

BPD-INV-NUMBER         Numeric 3                                 BN81.1  BN81.2
Element: Inv Number    Contains the invoice number associated
                       with this payment.

BPD-PLAN-TYPE          Alpha 2                                   BN81.1  BN81.2
Element: Plan Type     Contains the benefit plan type used to
                       identify the kind of plan associated
                       with this payment.
                       DL = Dependent Life
                       DN = Dental
                       EL = Employee Life
                       HL = Health
                       RS = Spending Account

BPD-PLAN-CODE          Alpha 4                                   BN81.1  BN81.2
Element: Plan Code     Contains the plan code.

BPD-START-DATE         Numeric 8  (yyyymmdd)                     BN81.1  BN81.2
Element: Start Date    Contains the start date of the benefit
                       plan.

BPD-AR-DIST-CO         Numeric 4                                 BN81.1  BN81.2
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

BPD-AR-ACCT-UNIT       Alpha 15                                  BN81.1  BN81.2
Element: Acct Unit     Contains the accounting unit used for
                       posting the payment.

BPD-AR-ACCOUNT         Numeric 6                                 BN81.1  BN81.2
Element: Account       Contains the account used for posting
                       the payment.

BPD-AR-SUB-ACCT        Numeric 4                                 BN81.1  BN81.2
Element: Sub Acct      Contains the subaccount used for
                       posting the payment.

BPD-PMT-AMT            Signed 11.2                               BN81.1  BN81.2
Element: Pmt Amt       Contains the payment amount received.

                         BNPAYDETL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BPDSET1   COMPANY                                                BN190   BN281
          EMPLOYEE                                               BN480   BN81.1
          PARTICIPNT                                             BN81.2  BN82.1
          TYPE
          CHECK-NBR
          INV-NUMBER
          PLAN-TYPE
          PLAN-CODE
          START-DATE

                         BNPAYDETL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ar Account     GLMASTER     Required
                            When BPD-AR-ACCT-UNIT != Spaces
                            Or   BPD-AR-ACCOUNT   != Zeroes

                            BPD-COMPANY         -> GLM-COMPANY
                            BPD-AR-ACCT-UNIT    -> GLM-ACCT-UNIT
                            BPD-AR-ACCOUNT      -> GLM-ACCOUNT
                            BPD-AR-SUB-ACCT     -> GLM-SUB-ACCOUNT

Benefit        PARTBEN      Required

                            BPD-COMPANY         -> PTB-COMPANY
                            BPD-PLAN-TYPE       -> PTB-PLAN-TYPE
                            BPD-PARTICIPNT      -> PTB-PARTICIPNT
                            BPD-EMPLOYEE        -> PTB-EMPLOYEE
                            BPD-START-DATE      -> PTB-START-DATE
                            BPD-PLAN-CODE       -> PTB-PLAN-CODE

Company        BNCOMPANY    Required

                            BPD-COMPANY         -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            BPD-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required
                            When BPD-EMPLOYEE != Zeroes

                            BPD-COMPANY         -> EMP-COMPANY
                            BPD-EMPLOYEE        -> EMP-EMPLOYEE

Invoice Detail BNINVDETL    Required

                            BPD-COMPANY         -> BID-COMPANY
                            BPD-EMPLOYEE        -> BID-EMPLOYEE
                            BPD-PARTICIPNT      -> BID-PARTICIPNT
                            BPD-INV-NUMBER      -> BID-INV-NUMBER
                            BPD-PLAN-TYPE       -> BID-PLAN-TYPE
                            BPD-PLAN-CODE       -> BID-PLAN-CODE
                            BPD-START-DATE      -> BID-START-DATE

Participant    PARTICIPNT   Required
                            When BPD-PARTICIPNT != Zeroes

                            BPD-COMPANY         -> PAR-COMPANY
                            BPD-PARTICIPNT      -> PAR-PARTICIPNT

Payment        BNPAYMENT    Required

                            BPD-COMPANY         -> BNP-COMPANY
                            BPD-PARTICIPNT      -> BNP-EMPLOYEE
                            BPD-EMPLOYEE        -> BNP-PARTICIPNT
                            BPD-TYPE            -> BNP-TYPE
                            BPD-CHECK-NBR       -> BNP-CHECK-NBR

Plan           PLAN         Required

                            BPD-COMPANY         -> PLN-COMPANY
                            BPD-PLAN-TYPE       -> PLN-PLAN-TYPE
                            BPD-PLAN-CODE       -> PLN-PLAN-CODE