Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             BNPAYMENT FILE

                            Benefit Payment

The Benefit Payment file contains payment information for COBRA participant
and retiree premiums. Each record is for one COBRA participant or retiree
transaction.

BN81.1 (Cash Entry) is the primary program that updates this file.

REFERENCED BY

BN82.1    BN281

UPDATED BY

BN190     BN480     BN700     BN81.1    BN81.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BNP-COMPANY          Numeric 4                                   BN81.1
Company              Contains the company number. The number
                     correlates all information about the
                     company.

BNP-EMPLOYEE         Numeric 9                                   BN81.1
Employee             Contains the employee's number.

BNP-PARTICIPNT       Numeric 9                                   BN81.1
Participant Number   Contains COBRA participant numbers. The
                     number correlates all information about
                     the COBRA participant.

BNP-TYPE             Alpha 2                                     BN81.1
Type                 Indicates whether the transaction is a
                     payment or a credit memo.
                     CK = Payment
                     CM = Credit Memo

BNP-CHECK-NBR        Numeric 8                                   BN81.1
Payment Number       Contains the number of the payment.

BNP-PMT-AMT          Signed 11.2                                 BN81.1
Payment Amount       Contains the payment amount.

BNP-APPLIED-AMT      Signed 15.2                                 BN81.1  BN81.2
Applied Amount       Contains the amount applied to the
                     outstanding balance.

BNP-DATE             Numeric 8  (yyyymmdd)                       BN81.1
Date                 Contains the transaction date.

BNP-REFERENCE        Alpha 10  (Lower Case)                      BN81.1
Reference            Contains a user-defined reference or
                     comment.

BNP-DIST-CO          Numeric 4                                   BN81.1
Dist Co

BNP-ACCT-UNIT        Alpha 15                                    BN81.1
Accounting Unit      Contains the accounting unit for the
                     payment.

BNP-ACCOUNT          Numeric 6                                   BN81.1
Account              Contains the account for the payment.

BNP-SUB-ACCT         Numeric 4                                   BN81.1
Subaccount           Contains the subaccount for the payment.

BNP-OS-INV-NUMBER    Numeric 3                                   BN81.2
Over/Short Invoice   Contains the invoice number for the
Number               over or short amount of the payment.

BNP-OS-PLAN-TYPE     Alpha 2                                     BN81.2
Over/Short Plan Type Contains the benefit type.
                     HL = Health
                     DN = Dental
                     EL = Employee Life
                     DL = Dependent Life
                     RS = Spending Account

BNP-OS-PLAN-CODE     Alpha 4                                     BN81.2
Over/Short Plan Code Contains the benefit plan's code.

BNP-OS-START-DATE    Numeric 8  (yyyymmdd)                       BN81.2
Over/Short Start     Contains the start date of the benefit
Date                 plan.

BNP-OS-AMOUNT        Signed 7.2                                  BN81.2
Over/Short           Contains the over or short amount.
Transaction Amount

BNP-OS-DIST-CO       Numeric 4                                   BN81.2
Os Dist Co

BNP-OS-ACCT-UNIT     Alpha 15                                    BN81.2
Offsetting           Contains the account used for posting
Accounting Unit      the over or short amount.

BNP-OS-ACCOUNT       Numeric 6                                   BN81.2
Offsetting Account   Contains the account for posting the
                     over or short amount.

BNP-OS-SUB-ACCT      Numeric 4                                   BN81.2
Offsetting           Contains the subaccount for posting the
Subaccount           over or short amount.

BNP-AR-DIST-CO       Numeric 4                                   BN81.2
Ar Dist Co

BNP-AR-ACCT-UNIT     Alpha 15                                    BN81.2
Accts Receivable     Contains the accounting unit for the
Account Unit         over short account.

BNP-AR-ACCOUNT       Numeric 6                                   BN81.2
Accounts Receivable  Contains the account for the over short
Account              payment.

BNP-AR-SUB-ACCT      Numeric 4                                   BN81.2
Accts Receivable     Contains the subaccount for the over
Subaccount           short account.

BNP-STATUS           Numeric 1                                   BN190   BN81.1
Status               Contains the status of a given              BN81.2
                     transaction.
                     1 = Posted to G/L
                     0 = Not Posted to G/L

BNP-CURRENCY-CODE    Alpha 5                                     BN700   BN81.1
Currency Code        This field contains the company base        BN81.2
                     currency code established in Company
                     (GL10.1 ).


BNP-CURR-ND          Numeric 1                                   BN700   BN81.1
Currency Number of   Represents the number of decimals           BN81.2
Decimals             defined for the currency of the object.

                         BNPAYMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BNPSET1   COMPANY                                                BN480   BN700
          EMPLOYEE                                               BN82.1
          PARTICIPNT
          TYPE
          CHECK-NBR

BNPSET2   COMPANY       Subset                                   BN190   BN281
          EMPLOYEE      Where STATUS != 9                        BN81.1  BN81.2
          PARTICIPNT
          TYPE
          CHECK-NBR

                         BNPAYMENT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

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

Company        BNCOMPANY    Required

                            BNP-COMPANY          -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            BNP-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required

                            BNP-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required
                            When BNP-EMPLOYEE != Zeroes

                            BNP-COMPANY          -> EMP-COMPANY
                            BNP-EMPLOYEE         -> EMP-EMPLOYEE

Gl Account     GLMASTER     Required
                            When BNP-ACCT-UNIT != Spaces
                            And  BNP-ACCOUNT   != Zeroes
                            And  BNP-SUB-ACCT  != Zeroes

                            BNP-COMPANY          -> GLM-COMPANY
                            BNP-ACCT-UNIT        -> GLM-ACCT-UNIT
                            BNP-ACCOUNT          -> GLM-ACCOUNT
                            BNP-SUB-ACCT         -> GLM-SUB-ACCOUNT

Os Account     GLMASTER     Required
                            When BNP-OS-ACCT-UNIT != Spaces
                            Or   BNP-OS-ACCOUNT   != Zeroes

                            BNP-COMPANY          -> GLM-COMPANY
                            BNP-OS-ACCT-UNIT     -> GLM-ACCT-UNIT
                            BNP-OS-ACCOUNT       -> GLM-ACCOUNT
                            BNP-OS-SUB-ACCT      -> GLM-SUB-ACCOUNT

Os Invoice     BNINVDETL    Required
                            When BNP-OS-INV-NUMBER != Zeroes

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

Os Plan        PLAN         Required
                            When BNP-OS-PLAN-CODE != Spaces

                            BNP-COMPANY          -> PLN-COMPANY
                            BNP-OS-PLAN-TYPE     -> PLN-PLAN-TYPE
                            BNP-OS-PLAN-CODE     -> PLN-PLAN-CODE

Participant    PARTICIPNT   Required
                            When BNP-PARTICIPNT != Zeroes

                            BNP-COMPANY          -> PAR-COMPANY
                            BNP-PARTICIPNT       -> PAR-PARTICIPNT

                         BNPAYMENT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Payment Detail BNPAYDETL    Delete Restricted

                            BNP-COMPANY          -> BPD-COMPANY
                            BNP-EMPLOYEE         -> BPD-EMPLOYEE
                            BNP-PARTICIPNT       -> BPD-PARTICIPNT
                            BNP-TYPE             -> BPD-TYPE
                            BNP-CHECK-NBR        -> BPD-CHECK-NBR
                                                    BPD-INV-NUMBER
                                                    BPD-PLAN-TYPE
                                                    BPD-PLAN-CODE
                                                    BPD-START-DATE