Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBHSTDTL


                             PBHSTDTL FILE

UPDATED BY

PBIP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PBH-COMPANY            Numeric 4                                 PBIP.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

PBH-PROCESS-LEVEL      Alpha 5                                   PBIP.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

PBH-INVOICE            Alpha 22                                  PBIP.1
Element: Invoice NumberUsed to identify the invoice.

PBH-INVOICE-PREFIX     Alpha 2                                   PBIP.1
Element: Invoice Prefix

PBH-INVOICE-NBR        Numeric 8                                 PBIP.1
Element: Invoice Nbr

PBH-LINE-NBR           Numeric 6                                 PBIP.1
Element: Line Number   This field contains the line number.

PBH-RECORD-TYPE        Alpha 1                                   PBIP.1
Element: Record Type   This field identifies the type of
                       record defined.

                       Valid values are:
                       S = Summary
                       D = Detail
                       F = Fee Info
                       T = Time Record Info
                       O = AR Offset Transaction
                       J = Job Code Fee
                       B

PBH-EMPLOYEE           Numeric 9                                 PBIP.1
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PBH-DEDUCT-FEE-CD      Alpha 4                                   PBIP.1
Element: Deduct Fee Cd

PBH-CODE-TYPE          Alpha 1                                   PBIP.1
Element: Code Type

PBH-PROGRAM            Alpha 5                                   PBIP.1
Element: Program       This field designates the program this
                       record was created by

PBH-DESCRIPTION        Alpha 30  (Lower Case)                    PBIP.1
Element: Description   This field displays the description.

PBH-TAX-CATEGORY       Numeric 2                                 PBIP.1
Element: Tax Category

PBH-TAX-AUTH-TYPE      Alpha 2                                   PBIP.1
Element: Tax Auth Type

PBH-ADJUST-PAY         Alpha 1                                   PBIP.1
Element: Adjust Pay

PBH-WC-STATE           Alpha 2                                   PBIP.1
Element: Wc State

PBH-WC-CODE            Alpha 10                                  PBIP.1
Workers Comp Policy    Contains the workers' compensation code.
Code

PBH-WC-CLASS           Alpha 4                                   PBIP.1
Workers Comp           Contains the workers' compensation
Classification         class.

PBH-WC-RATE            Signed 13.4                               PBIP.1
Element: Wc Rate

PBH-REG-HOURS          Signed 7.2                                PBIP.1
Element: Reg Hours

PBH-OT-HOURS           Signed 7.2                                PBIP.1
Element: Ot Hours

PBH-OTH-HOURS          Signed 7.2                                PBIP.1
Element: Oth Hours

PBH-REG-RATE           Signed 13.4                               PBIP.1
Element: Reg Rate

PBH-OT-RATE            Signed 13.4                               PBIP.1
Element: Ot Rate

PBH-OTH-RATE           Signed 13.4                               PBIP.1
Element: Oth Rate

PBH-REG-PAY            Signed 11.2                               PBIP.1
Element: Reg Pay

PBH-OT-PAY             Signed 11.2                               PBIP.1
Element: Ot Pay

PBH-OTH-PAY            Signed 11.2                               PBIP.1
Element: Oth Pay

PBH-TIPS-PAY           Signed 11.2                               PBIP.1
Element: Tips Pay

PBH-GROSS-PAY          Signed 13.2                               PBIP.1
Element: Gross Pay

PBH-EMPLOYEE-CAFE      Signed 11.2                               PBIP.1
Element: Employee Cafe

PBH-CREDITS            Signed 11.2                               PBIP.1
Element: Credits

PBH-BILLABLE-AMT       Signed 15.2                               PBIP.1
Element: Adj Amt

PBH-BILLABLE-UNIT      Signed 15.2                               PBIP.1
Element: Unit

PBH-TAXABLE-AMT        Signed 15.2                               PBIP.1
Element: Adj Amt

PBH-CHECK-ID           Numeric 12                                PBIP.1
Internal Check ID      Contains the payment identification
Number                 number (unique payment identifier used
                       in tracking payment information).

PBH-DEPARTMENT         Alpha 5                                   PBIP.1
Element: Department    Contains the department.

PBH-JOB-CODE           Alpha 9                                   PBIP.1
Element: Job Code      Contains a user-defined code that
                       represents a type of job.

PBH-POSITION           Alpha 12                                  PBIP.1
Element: Position      Contains the user-defined code that
                       represents a position in the company.

PBH-PCD-SEQ-NBR        Numeric 4                                 PBIP.1
Element: Pcd Seq Nbr

PBH-PRD-REC-TYPE       Alpha 1                                   PBIP.1
Element: Prd Rec Type

PBH-PLAN-TYPE          Alpha 2                                   PBIP.1
Element: Type

PBH-PLAN-CODE          Alpha 4                                   PBIP.1
Element: Plan          Contains the user-defined code that
                       represents a benefit plan.

PBH-REPORT-ENTITY      Alpha 5                                   PBIP.1
Element: Process Level

PBH-BUS-NBR-GRP        Alpha 4                                   PBIP.1
Element: Bus Nbr Grp

PBH-QC-ENT-NBR-GRP     Alpha 4                                   PBIP.1
Element: Qc Ent Nbr Grp

PBH-CURRENCY-CODE      Alpha 5                                   PBIP.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PBH-CURR-ND            Numeric 1                                 PBIP.1
Account Currency
Code

PBH-CALC-TYPE          Alpha 1                                   PBIP.1
Element: Calculation TyThis field contains the calculation
                       type.

PBH-PAY-SUM-GRP        Alpha 3                                   PBIP.1
Payment Summary
Group

PBH-TR-DATE            Numeric 8  (yyyymmdd)                     PBIP.1
Element: Time Record Date

PBH-TIME-SEQ           Numeric 12                                PBIP.1
Element: Sequence Number

PBH-CLIENT-JOBID       Alpha 20                                  PBIP.1
Element: Client Jobid

PBH-EDM-SEQ-NBR        Numeric 4                                 PBIP.1
Emp Deduction
Sequence Number

                         PBHSTDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBHSET1   COMPANY                                                PBIP.1
          PROCESS-LEVEL
          INVOICE
          LINE-NBR

PBHSET2   COMPANY
          EMPLOYEE
          CHECK-ID
          PROCESS-LEVEL
          INVOICE
          LINE-NBR

PBHSET3   COMPANY
          PROCESS-LEVEL
          INVOICE
          EMPLOYEE
          LINE-NBR

PBHSET4   COMPANY
          PROCESS-LEVEL
          WC-CODE
          WC-STATE
          INVOICE
          LINE-NBR

                         PBHSTDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Paymastr       PAYMASTR     Required

                            PBH-COMPANY          -> PYM-COMPANY  (PYMSET1)
                            PBH-EMPLOYEE         -> PYM-EMPLOYEE
                            PBH-CHECK-ID         -> PYM-CHECK-ID

Pbhsthdr       PBHSTHDR     Required

                            PBH-COMPANY          -> PBK-COMPANY
                            PBH-PROCESS-LEVEL    -> PBK-PROCESS-LEVEL
                            PBH-INVOICE          -> PBK-INVOICE