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     ARLL.1    BL00.1    BL01.1
BL120     BL121     BL122     BL123     BL130     BL20.1
BL20.3    BL200     BL201     BL21.2    BL21.5    BL29.1
BL29.2    BL520     BL820     BL92.1    BR11.1    OE10.1
OE10.2    OE10.3    OE10.4    OE10.5    OE10.6    OE10.7
OE10.8    OE11.1    OE11.4    OE11.8    OE11.9    OE110
OE111     OE113     OE114     OE116     OE129     OE13.2
OE13.3    OE13.5    OE13.6    OE14.4    OE30.1    OE30.2
OE30.3    OE30.4    OE30.5    OE30.6    OE30.7    OE30.9
OE510     OE530     OE810     OE830     PBIP.1    PBWC.1
PR197     PR85.1    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PBB-COMPANY            Numeric 4
Element: Company Hr    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.

PBB-PROCESS-LEVEL      Alpha 5
Element: Process Lev HrThis 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   ARLL.1
                                                                 BL00.1  BL01.1
                                                                 BL120   BL121
                                                                 BL122   BL123
                                                                 BL130   BL20.1
                                                                 BL20.3  BL200
                                                                 BL201   BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 BR11.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.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