Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              PBBILL FILE

REFERENCED BY

AR42.2    AR42.7    AR560     BL00.1    BL01.1    BL121
BL123     BL200     BL201     BR11.1    PBWC.1    PHI3.1
PR197     PR85.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

PBB-INVOICE-STYLE    Alpha 1
Invoice Style

PBB-AR-INTERFACE     Alpha 1
Ar Interface

PBB-INVOICE-PREFIX   Alpha 2
Invoice Prefix

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

PBB-TAX-EXEMPT       Alpha 1
Tax Exempt

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

PBB-DEDUCTION-GRP    Alpha 10
Deduction Grp

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

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

PBB-BILLING-TYPE     Alpha 1
Billing Type

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

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

PBB-INV-STL          Alpha 10
Inv Stl

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

PBB-FED-DED-BASIS    Alpha 1
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   BL00.1
                                                                 BL01.1  BL121
                                                                 BL123   BL200
                                                                 BL201   BR11.1
                                                                 PBWC.1  PHI3.1
                                                                 PR197   PR85.1

                         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