Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBBLWCDTL


                             PBBLWCDTL FILE

REFERENCED BY

PBWC.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

PBX-EFFECT-DATE        Numeric 8  (yyyymmdd)
Element: Date

PBX-WC-STATE           Alpha 2
Element: Wc State

PBX-WC-CLASS           Alpha 4
Workers Comp           Contains the workers' compensation
Classification         class.

PBX-BILLING-RATE       Signed 9.4
Element: Billing Rate

PBX-BILLING-MOD        Signed 7.4
Element: Billing Mod

PBX-WAGE-CUT-OFF       Signed 11.2
Element: Wage Cut Off

PBX-LIMIT-IND          Alpha 2
Element: Limit Indicator

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

PBX-CURR-ND            Numeric 1
Account Currency
Code

PBX-COUNTRY-CODE       Alpha 2
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

PBX-CA-WC-CLASS        Alpha 10
Element: Ca Wc Class

                         PBBLWCDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBXSET1   COMPANY                                                PBWC.1
          CURRENCY-CODE
          PROCESS-LEVEL
          EFFECT-DATE
          WC-STATE
          WC-CLASS
          CA-WC-CLASS

PBXSET2   COMPANY
          WC-STATE
          PROCESS-LEVEL
          EFFECT-DATE
          WC-CLASS
          CURRENCY-CODE
          CA-WC-CLASS

                         PBBLWCDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wcclass        WCCLASS      Required

                            PBX-COMPANY          -> WCC-COMPANY  (WCCSET1)
                            PBX-COUNTRY-CODE     -> WCC-COUNTRY-CODE
                            PBX-WC-STATE         -> WCC-WC-STATE
                            PBX-PROCESS-LEVEL    -> WCC-PROCESS-LEVEL
                            PBX-EFFECT-DATE      -> WCC-EFFECT-DATE
                            PBX-WC-CLASS         -> WCC-WC-CLASS
                            PBX-CA-WC-CLASS      -> WCC-CA-WC-CLASS