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.