Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              PBBILL FILE

                     Pay to Bill Billing Paramaters

The Pay to Bill Billing file stores client billing parametes defined on Client
Billing (PB15.1).

REFERENCED BY

PBIP.1    PBWC.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        The invoice style identifies the type of
                     invoice printed. You can select
                     bundleded-one line, bundleded-two lines,
                     standard, workers comp detail, tax
                     detail, or CSV file format.
                     A = Bundled-One Line
                     B = Bundled-Two Line
                     C = Standard
                     D = Full Detail
                     E = Worker's Comp Detail
                     F = Tax Detail
                     V = CSV formatted file

PBB-AR-INTERFACE     Alpha 1
Ar Interface         This field identifies the level of Pay
                     to Bill data that is transferred to the
                     Accounts Receivable application.
                     S = Summary
                     D = Detail

PBB-INVOICE-PREFIX   Alpha 2
Invoice Prefix       Identifies where a transaction
                     originated in the Pay to Bill
                     application. This can be used when you
                     are looking at an invoice in another
                     subsystem.

PBB-CR-MEMO-PREFIX   Alpha 2
Cr Memo Prefix       Identifies where a credit memo
                     orginiated.

PBB-TAX-EXEMPT       Alpha 1
Tax Exempt           Determines if the bills you send to your
                     clients are tax emempt or taxable.
                     E = Exempt
                     T = Taxable

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        The deduction group is used to calculate
                     billable amounts.

PBB-DEDUCT-GRP-WC    Alpha 10
Deduct Grp Wc        Used to calculate workers comp billiable
                     amounts.

PBB-DEDUCT-GRP-SU    Alpha 10
Deduct Grp Su        Used to calculate state unemployment
                     insurance billable amounts.

PBB-BILLING-TYPE     Alpha 1
Billing Type         This field determines if you are billing
                     your client for fee codes or job codes.
                     F = Fee Code
                     J = Job Code

PBB-MANUAL-RATE-FL   Alpha 1
Manual Rate Fl       If you select Yes, manual rates are used
                     to calculate workers comp billable
                     rates.

PBB-WC-CODE          Alpha 10
Workers Comp Policy  Contains the workers' compensation code
Code                 or policy code you are billing your
                     client for.

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                                                PBIP.1  PBWC.1
          PROCESS-LEVEL

                         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

Pbblwchdr      PBBLWCHDR

                            PBB-COMPANY          -> PBW-COMPANY
                            PBB-PROCESS-LEVEL    -> PBW-PROCESS-LEVEL
                                                    PBW-EFFECT-DATE
                                                    PBW-WC-STATE