Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBBILL


                              PBBILL FILE

REFERENCED BY

AR42.2    AR42.7    AR560     BN66.1    BR11.1    PBIP.1
PBWC.1    PHI3.1    PR140     PR189     PR195     PR197
PR80.1    PR85.1    PR89.1    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

PBB-INVOICE-STYLE      Alpha 1
Element: Invoice Style

PBB-AR-INTERFACE       Alpha 1
Element: Ar Interface

PBB-INVOICE-PREFIX     Alpha 2
Element: Invoice Prefix

PBB-CR-MEMO-PREFIX     Alpha 2
Element: Cr Memo Prefix

PBB-TAX-EXEMPT         Alpha 1
Element: All Flag

PBB-TAX-CODE           Alpha 10
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


PBB-DEDUCTION-GRP      Alpha 10
Element: Deduction Grp

PBB-DEDUCT-GRP-WC      Alpha 10
Element: Deduct Grp Wc

PBB-DEDUCT-GRP-SU      Alpha 10
Element: Deduct Grp Su

PBB-BILLING-TYPE       Alpha 1
Element: Billing Type

PBB-MANUAL-RATE-FL     Alpha 1
Element: Manual Rate Fl

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

PBB-INV-STL            Alpha 10
Element: Inv Stl

PBB-FED-DED-GW-FL      Alpha 1
Element: Fed Ded Gw Fl

PBB-FED-DED-BASIS      Alpha 1
Element: Fed Ded Basis G = Gross Wages
                       S = After Section 125

                         PBBILL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBBSET1   COMPANY                                                AR42.2  AR42.7
          PROCESS-LEVEL                                          AR560   BN66.1
                                                                 BR11.1  PBIP.1
                                                                 PBWC.1  PHI3.1
                                                                 PR140   PR189
                                                                 PR195   PR197
                                                                 PR80.1  PR85.1
                                                                 PR89.1  WH20.7

                         PBBILL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pbclient       PBCLIENT     Required

                            PBB-COMPANY          -> PCC-COMPANY
                            PBB-PROCESS-LEVEL    -> PCC-PROCESS-LEVEL

Prsystem       PRSYSTEM     Required

                            PBB-COMPANY          -> PRS-COMPANY
                            PBB-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

                         PBBILL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pbbljobcd      PBBLJOBCD

                            PBB-COMPANY          -> PBJ-COMPANY
                            PBB-PROCESS-LEVEL    -> PBJ-PROCESS-LEVEL
                                                    PBJ-JOB-CODE

Pbfee          PBFEE

                            PBB-COMPANY          -> PBF-COMPANY
                            PBB-PROCESS-LEVEL    -> PBF-PROCESS-LEVEL
                                                    PBF-FEE-CODE

Pbtrans        PBTRANS

                            PBB-COMPANY          -> PTN-COMPANY
                            PBB-PROCESS-LEVEL    -> PTN-PROCESS-LEVEL
                                                    PTN-EMPLOYEE
                                                    PTN-CHECK-ID
                                                    PTN-DATE
                                                    PTN-FEE-CODE
                                                    PTN-SEQ-NUMBER