BNPAYDETL

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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BPD-COMPANY
Element: Company Hr
Numeric 4
Contains the company number. The number correlates all information about the company.
BN81.1 BN81.2
BPD-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee's number. The number correlates all information about the employee.
BN81.1 BN81.2
BPD-PARTICIPNT
Element: Participnt
Numeric 9
Contains COBRA participant numbers. The number correlates all information about the COBRA participant.
BN81.1 BN81.2
BPD-TYPE
Element: Type
Alpha 2
Indicates whether the cash entry is for a payment or a credit memo.
CK = Payment
CM = Credit Memo
BN81.1 BN81.2
BPD-CHECK-NBR
Element: Check Nbr
Numeric 8
Contains the payment number.
BN81.1 BN81.2
BPD-INV-NUMBER
Element: Inv Number
Numeric 3
Contains the invoice number associated with this payment.
BN81.1 BN81.2
BPD-PLAN-TYPE
Element: Plan Type
Alpha 2
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
BN81.1 BN81.2
BPD-PLAN-CODE
Element: Plan Code
Alpha 4
Contains the plan code.
BN81.1 BN81.2
BPD-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Contains the start date of the benefit plan.
BN81.1 BN81.2
BPD-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.1 BN81.2
BPD-AR-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the accounting unit used for posting the payment.
BN81.1 BN81.2
BPD-AR-ACCOUNT
Element: Account
Numeric 6
Contains the account used for posting the payment.
BN81.1 BN81.2
BPD-AR-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the subaccount used for posting the payment.
BN81.1 BN81.2
BPD-PMT-AMT
Element: Pmt Amt
Signed 11.2
Contains the payment amount received.
BN81.1 BN81.2


BNPAYDETL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BPDSET1 COMPANY
EMPLOYEE
PARTICIPNT
TYPE
CHECK-NBR
INV-NUMBER
PLAN-TYPE
PLAN-CODE
START-DATE
BN190 BN281
BN480 BN81.1
BN81.2 BN82.1


BNPAYDETL FILE RELATIONS


ONE TO ONE RELATIONS

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


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

Home
Contact Us



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