BNALEMBR

UPDATED BY
BN00.7 BN00.8 BN227 BN255 BN27.1 BN27.2
BN290 BN297 BN299 BN527 BN597 BN99.2
BN99.3 BN99.6 BN990 BN991 BN996

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PP4-COMPANY
Element: Company Hr
Numeric 4
BN00.7
PP4-YEAR
Element: Payroll Year
Numeric 4
BN00.7
PP4-ALE-MBR-PL
Element: Process Lev Hr
Alpha 5
BN00.7
PP4-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
BN00.7
PP4-TAX-ID-NBR
Element: Tax Id
Alpha 20
BN00.7
PP4-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN00.7
PP4-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN00.7
PP4-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN00.7
PP4-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN00.7
PP4-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN00.7
PP4-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN00.7


BNALEMBR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PP4SET1 COMPANY
YEAR
ALE-MBR-PL
PROCESS-LEVEL
BN00.7 BN00.8
BN227 BN255
BN27.1 BN27.2
BN290 BN297
BN299 BN527
BN597 BN99.2
BN99.3 BN99.6
BN990 BN991
BN996
PP4SET2 COMPANY
YEAR
PROCESS-LEVEL
ALE-MBR-PL
BN00.7 BN255
BN990 BN991
BN996


BNALEMBR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
PP4-COMPANY->BNC-COMPANY


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

Home
Contact Us



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