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       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: Participant NuContains 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: Payment NumberContains the payment number.

BPD-INV-NUMBER         Numeric 3                                 BN81.1  BN81.2
Element: Invoice NumberContains the invoice number associated
                       with this payment.

BPD-PLAN-TYPE          Alpha 2                                   BN81.1  BN81.2
Element: 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          Contains the plan code.

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

BPD-AR-DIST-CO         Numeric 4                                 BN81.1  BN81.2
Element: Ar Dist Co

BPD-AR-ACCT-UNIT       Alpha 15                                  BN81.1  BN81.2
Accts Receivable       Contains the accounting unit used for
Account Unit           posting the payment.

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

BPD-AR-SUB-ACCT        Numeric 4                                 BN81.1  BN81.2
Accts Receivable       Contains the subaccount used for
Subaccount             posting the payment.

BPD-PMT-AMT            Signed 11.2                               BN81.1  BN81.2
Element: Payment AmountContains 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