Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PBCLIENT FILE

REFERENCED BY

AC541     AC542     BN150     PBFE.1    PR128     PR131
PR132     PR134     PR136     PR137     PR195     PR197
PR198     PR32.1    PR32.2    PR33.1    PR33.2    PR33.3
PR35.1    PR35.2    PR35.3    PR35.4    PR35.5    PR35.6
PR35.8    PR36.1    PR37.1    PR45.1    PR530     PR82.1
PR85.1    UK102     UK330     UK120

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

PCC-CUSTOMER         Alpha 9  (Right Justified)
Customer Number      This field contains the number that
                     represents a customer.

PCC-AR-PROCESS-LVL   Alpha 5
Ar Process Lvl

PCC-ACCT-UNIT        Alpha 15
Accounting Unit      The accounting unit is a shorthand
                     notation representing the variable level
                     number. When used in the General Ledger
                     Account Master file, the accounting unit
                     must be defined in the General Ledger
                     Names file as a posting accounting unit.


PCC-REV-ACCOUNT      Numeric 6
Rev Account          This field represents the general
                     ledger revenue (sales) account for the
                     category.

PCC-REV-SUB-ACCT     Numeric 4
Rev Sub Acct         The general ledger revenue (sales)
                     subaccount for the category.

PCC-ACTIVITY         Alpha 15
Activity             Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity.


PCC-REV-ACCT-CAT     Alpha 5
Rev Acct Cat

PCC-BEGIN-DATE       Numeric 8  (yyyymmdd)
Begin Date           The beginning date in a range of dates.

PCC-END-DATE         Numeric 8  (yyyymmdd)
Ending Date          The ending date in a range of dates.

PCC-ACTIVE-STATUS    Alpha 1
Status               The status of the account. If Inactive,
                     no posting can be done to the account.


PCC-POST-COMPANY     Numeric 4
Post Company         The company used for posting
                     transactions to the general ledger.

PCC-SEGMENT-BLOCK    Alpha 103
User Analysis        This field identifies the user analysis
                     values included in the transaction.

                     You can either type up to four values
                     or use Define (F6) to open the User
                     Analysis Entry subform. Use this subform
                     to select the user analysis values you
                     want to include in the transaction. If
                     you choose to type values, use commas to
                     separate them. For example:
                     value1,value2,value3,value4

                     There are three conditions that affect
                     how you can select user analysis values.
                     See the User Analysis Entry form help or
                     the Strategic Ledger procedures manual
                     for additional information.

PCC-CONTRACT         Alpha 10
Contract

PCC-PROCESSOR        Alpha 20
Processor

PCC-SALES-REP        Numeric 4
Sales Rep

PCC-BILL-TO          Numeric 4
Bill To

PCC-DELIVERY-METHD   Numeric 1
Delivery Methd

PCC-AUTO-CHK-FL      Alpha 1
Auto Chk Fl

PCC-PROCESSOR-PHN    Alpha 15
Processor Phn

PCC-PROCESSOR-EXT    Alpha 5
Processor Ext

PCC-ENTITY-TYPE      Alpha 1
Entity Type

PCC-NAICS-CODE       Alpha 6
Naics Code

PCC-COST-ACCT-CAT    Alpha 5
Cost Acct Cat

PCC-CHCK-ACCT-CAT    Alpha 5
Chck Acct Cat

PCC-WK-EM-ACCT-CAT   Alpha 5
Wk Em Acct Cat

PCC-EM-PD-ACCT-CAT   Alpha 5
Em Pd Acct Cat

PCC-RESP-CODE        Alpha 5
Resp Code

PCC-RESP-CODE2       Alpha 5
Resp Code2

PCC-DEL-MTHD         Alpha 5
Del Mthd

PCC-STATUS-CD        Alpha 1
Status Cd

                         PBCLIENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCCSET1   COMPANY                                                AC541   AC542
          PROCESS-LEVEL                                          BN150   PBFE.1
                                                                 PR128   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 PR195   PR197
                                                                 PR198   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR36.1
                                                                 PR37.1  PR45.1
                                                                 PR530   PR82.1
                                                                 ...

PCCSET2   COMPANY
          AR-PROCESS-LVL
          CUSTOMER
          PROCESS-LEVEL

PCCSET3   POST-COMPANY
          CUSTOMER
          COMPANY
          PROCESS-LEVEL

                         PBCLIENT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            PCC-ACTIVITY         -> ACV-ACTIVITY  (ACVSET1)

Arcustomer     ARCUSTOMER   Required

                            PCC-POST-COMPANY     -> ACM-COMPANY
                            PCC-CUSTOMER         -> ACM-CUSTOMER

Glnames        GLNAMES      Required

                            PCC-POST-COMPANY     -> GLN-COMPANY
                            PCC-ACCT-UNIT        -> GLN-ACCT-UNIT

Pbbill         PBBILL       Required

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

Prsystem       PRSYSTEM     Required

                            PCC-COMPANY          -> PRS-COMPANY
                            PCC-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

                         PBCLIENT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE

                            PCC-COMPANY          -> EMP-COMPANY
                            PCC-PROCESS-LEVEL    -> EMP-PROCESS-LEVEL
                                                    EMP-EMPLOYEE

Pbacctasgn     PBACCTASGN

                            PCC-COMPANY          -> PBA-COMPANY
                                                    PBA-PROCESS-LEVEL
                                                    PBA-CODE-TYPE
                                                    PBA-DEDUCT-FEE-CD

Pbbldeduct     PBBLDEDUCT

                            PCC-COMPANY          -> PLD-COMPANY
                                                    PLD-EMPLOYEE
                                                    PLD-DED-CODE
                                                    PLD-EDM-SEQ-NBR
                                                    PLD-CHECK-ID
                                                    PLD-REPORT-ENTITY
                                                    PLD-BUS-NBR-GRP
                                                    PLD-QC-ENT-NBR-GRP
                                                    PLD-PROCESS-LEVEL
                                                    PLD-WORK-STATE

Pbbljobcd      PBBLJOBCD

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

Pbfee          PBFEE

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

Pbhstdtl       PBHSTDTL

                            PCC-COMPANY          -> PBH-COMPANY
                            PCC-PROCESS-LEVEL    -> PBH-PROCESS-LEVEL
                                                    PBH-INVOICE
                                                    PBH-LINE-NBR

Pbhsthdr       PBHSTHDR

                            PCC-COMPANY          -> PBK-COMPANY
                            PCC-PROCESS-LEVEL    -> PBK-PROCESS-LEVEL
                                                    PBK-INVOICE