BNPAYMENT

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.
UPDATED BY
BN190 BN480 BN81.1 BN81.2 BN82.1 BN281

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BNP-COMPANY
Element: Company Hr
Numeric 4
Contains the company number. The number correlates all information about the company.
BN81.1
BNP-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee's number.
BN81.1
BNP-PARTICIPNT
Element: Participnt
Numeric 9
Contains COBRA participant numbers. The number correlates all information about the COBRA participant.
BN81.1
BNP-TYPE
Element: Type
Alpha 2
Indicates whether the transaction is a payment or a credit memo.
CK = Payment
CM = Credit Memo
BN81.1
BNP-CHECK-NBR
Element: Check Nbr
Numeric 8
Contains the number of the payment.
BN81.1
BNP-PMT-AMT
Element: Pmt Amt
Signed 11.2
Contains the payment amount.
BN81.1
BNP-APPLIED-AMT
Element: Applied Amt
Signed 15.2
Contains the amount applied to the outstanding balance.
BN81.1 BN81.2
BNP-DATE
Element: Date
Numeric 8 (yyyymmdd)
Contains the transaction date.
BN81.1
BNP-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
Contains a user-defined reference or comment.
BN81.1
BNP-DIST-CO
Element: Company
Numeric 4
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.
BN81.1
BNP-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the accounting unit for the payment.
BN81.1
BNP-ACCOUNT
Element: Account
Numeric 6
Contains the account for the payment.
BN81.1
BNP-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the subaccount for the payment.
BN81.1
BNP-OS-INV-NUMBER
Element: Os Inv Number
Numeric 3
Contains the invoice number for the over or short amount of the payment.
BN81.2
BNP-OS-PLAN-TYPE
Element: Os Plan Type
Alpha 2
Contains the benefit type.
HL = Health
DN = Dental
EL = Employee Life
DL = Dependent Life
RS = Spending Account
BN81.2
BNP-OS-PLAN-CODE
Element: Os Plan Code
Alpha 4
Contains the benefit plan's code.
BN81.2
BNP-OS-START-DATE
Element: Os Start Date
Numeric 8 (yyyymmdd)
Contains the start date of the benefit plan.
BN81.2
BNP-OS-AMOUNT
Element: Os Amount
Signed 7.2
Contains the over or short amount.
BN81.2
BNP-OS-DIST-CO
Element: Company
Numeric 4
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.
BN81.2
BNP-OS-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the account used for posting the over or short amount.
BN81.2
BNP-OS-ACCOUNT
Element: Account
Numeric 6
Contains the account for posting the over or short amount.
BN81.2
BNP-OS-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the subaccount for posting the over or short amount.
BN81.2
BNP-AR-DIST-CO
Element: Company
Numeric 4
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.
BN81.2
BNP-AR-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the accounting unit for the over short account.
BN81.2
BNP-AR-ACCOUNT
Element: Account
Numeric 6
Contains the account for the over short payment.
BN81.2
BNP-AR-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the subaccount for the over short account.
BN81.2
BNP-STATUS
Element: Status
Numeric 1
Contains the status of a given transaction.
1 = Posted to G/L
0 = Not Posted to G/L
BN190 BN81.1
BN81.2
BNP-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN81.1 BN81.2
BNP-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN81.1 BN81.2


BNPAYMENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BNPSET1 COMPANY
EMPLOYEE
PARTICIPNT
TYPE
CHECK-NBR
BN480 BN82.1
BNPSET2 COMPANY
EMPLOYEE
PARTICIPNT
TYPE
CHECK-NBR
Subset
WhereSTATUS !=9
BN190 BN281
BN81.1 BN81.2


BNPAYMENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ar Account GLMASTER Required
When BNP-AR-ACCT-UNIT !=Spaces
OrBNP-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
AndBNP-ACCOUNT !=Zeroes
AndBNP-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
OrBNP-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
NAME
RELATED 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


File created: Wed Jun 08 20:48:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.