Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBCLIENT


                             PBCLIENT FILE

REFERENCED BY

BN150     PBFE.1    PBIP.1    PR128     PR130     PR131
PR132     PR134     PR136     PR137     PR160     PR197
PR198     PR29.1    PR32.1    PR32.2    PR33.1    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR35.9    PR36.1    PR37.1    PR45.1
PR529     PR530     PR560     PR82.1    PR85.1    UK102
UK330     TA147     TP135

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PCC-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.

PCC-PROCESS-LEVEL      Alpha 5
Element: Process Lev HrThis field contains the process level,
                       which is the reporting hierarchy below
                       company.

PCC-CUSTOMER           Alpha 9  (Right Justified)
Element: Customer NumbeThis field contains the number that
                       represents a customer.

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

PCC-ACCT-UNIT          Alpha 15
Element: Accounting UniThe 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
Element: Account       This field represents the general
                       ledger revenue (sales) account for the
                       category.

PCC-REV-SUB-ACCT       Numeric 4
Element: Subaccount    The general ledger revenue (sales)
                       subaccount for the category.

PCC-ACTIVITY           Alpha 15
Element: 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
Element: Account Category

PCC-BEGIN-DATE         Numeric 8  (yyyymmdd)
Element: Begin Date    The begin date for this effort period.

PCC-END-DATE           Numeric 8  (yyyymmdd)
Element: Ending Date   The end date for this effort period.

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


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

PCC-SEGMENT-BLOCK      Alpha 103
Element: 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
Element: Contract      Activity Management contract.

PCC-PROCESSOR          Alpha 20
Element: Processor

PCC-SALES-REP          Numeric 4
Element: Sales Rep

PCC-BILL-TO            Numeric 4
Element: Bill To       This field contains the mailing address
                       for the invoice.  Bill to addresses are
                       maintained in the Accounts Receviable
                       Bill To form AR09.4.

PCC-DELIVERY-METHD     Numeric 1
Element: Delivery Methd

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

PCC-PROCESSOR-PHN      Alpha 15
Element: Processor Phn

PCC-PROCESSOR-EXT      Alpha 5
Element: Processor Ext

PCC-ENTITY-TYPE        Alpha 1
Element: Entity Type

PCC-NAICS-CODE         Alpha 6
Element: Naics Code

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

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

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

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

PCC-RESP-CODE          Alpha 5
Element: Resp Code

PCC-RESP-CODE2         Alpha 5
Element: Resp Code2

PCC-DEL-MTHD           Alpha 5
Element: Del Mthd

PCC-STATUS-CD          Alpha 1
Element: Status Cd     Status Code.

                         PBCLIENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCCSET1   COMPANY                                                BN150   PBFE.1
          PROCESS-LEVEL                                          PBIP.1  PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 PR160   PR197
                                                                 PR198   PR29.1
                                                                 PR32.1  PR32.2
                                                                 PR33.1  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR35.9  PR36.1
                                                                 PR37.1  PR45.1
                                                                 ...

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

Pbbldedrt      PBBLDEDRT

                            PCC-COMPANY          -> PBR-COMPANY
                            PCC-PROCESS-LEVEL    -> PBR-PROCESS-LEVEL
                                                    PBR-DED-CODE-ORDER

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