Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BNPAYMENT


                             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
Element: Company       Contains the company number. The number
                       correlates all information about the
                       company.

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

BNP-PARTICIPNT         Numeric 9                                 BN81.1
Element: Participant NuContains COBRA participant numbers. The
                       number correlates all information about
                       the COBRA participant.

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

BNP-CHECK-NBR          Numeric 8                                 BN81.1
Element: Payment NumberContains the number of the payment.

BNP-PMT-AMT            Signed 11.2                               BN81.1
Element: Payment AmountContains the payment amount.

BNP-APPLIED-AMT        Signed 15.2                               BN81.1  BN81.2
Element: Adj Amt       Contains the amount applied to the
                       outstanding balance.

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

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

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

BNP-ACCT-UNIT          Alpha 15                                  BN81.1
Element: Accounting UniContains the accounting unit for the
                       payment.

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

BNP-SUB-ACCT           Numeric 4                                 BN81.1
Element: 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
Element: Over/Short PlaContains the benefit type.
                       HL = Health
                       DN = Dental
                       EL = Employee Life
                       DL = Dependent Life
                       RS = Spending Account

BNP-OS-PLAN-CODE       Alpha 4                                   BN81.2
Element: Over/Short PlaContains 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
Element: 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
Element: Offsetting AccContains 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
Element: 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
Element: 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
Element: 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
Account Currency                                                 BN81.2
Code

                         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