Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             PBCLIENT FILE

                           Pay to Bill Client

The Pay to Bill Client file stores information relating to your client
parameters.

REFERENCED BY

BN150     PBFE.1    PBIP.1    PR128     PR131     PR132
PR134     PR136     PR137     PR140     PR150     PR160
PR195     PR199     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
PR80.1    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.

                     An Accounts Receivable customer and Pay
                     to Bill client are the same entity.

PCC-AR-PROCESS-LVL   Alpha 5
Ar Process Lvl       The Accounts Receivable customer process
                     level you are posting Pay to Bill
                     transactions to.

PCC-ACCT-UNIT        Alpha 15
Accounting Unit      The General Ledger accounting unit you
                     are sending Pay to Bill revenue
                     transactions to.

PCC-REV-ACCOUNT      Numeric 6
Rev Account          The General Ledger account you are
                     sending Pay to Bill client revenue
                     transactions to.

PCC-REV-SUB-ACCT     Numeric 4
Rev Sub Acct         The General Ledger subaccount you are
                     sending Pay to Bill client revenue
                     transactions to.

PCC-ACTIVITY         Alpha 15
Activity             The Activity Management activity you are
                     using to track Pay to Bill client
                     profitability.

PCC-REV-ACCT-CAT     Alpha 5
Rev Acct Cat         The Pay to Bill default account category
                     you are sending client records to.

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.
                     A = Active
                     I = Inactive

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             A contract assigned to the client. When
                     you interface records to Accounts
                     Receivable, the contract field in Pay to
                     Bill dispalys in Accounts Receivable in
                     User Field 1.

PCC-CONTACT          Alpha 20
Primary Contact      This is the name of the main contact.

PCC-PROCESSOR        Alpha 20
Processor            The name of the person that creates the
                     invoice.

PCC-SALES-REP        Numeric 4
Sales Rep            A credit analysis code to identifiy the
                     sales rep responsible for your client.

PCC-PHONE-NMBR       Alpha 15
Telephone Number     The clients telephone number.

PCC-PHONE-EXT        Alpha 5
Telephone Extension  This field contains the telephone
                     extension number.

PCC-FAX-NBR          Alpha 15
Fax Number           Your client's fax number.

PCC-FAX-EXT          Alpha 5
Fax Extension        This field contains the fax number
                     extension.

PCC-BILL-TO          Numeric 4
Bill-To Customer     A bill code that identifies the client
Number               billing address.

PCC-DELIVERY-METHD   Numeric 1
Delivery Methd       Identifies how invoices are sent to your
                     customer. Valid values are ACH, Courier,
                     Direct Deposit, Federal Express, Mail,
                     Pick-up, Unknown.
                     1 = ACH
                     2 = Courier
                     3 = Direct Deposit
                     4 = Federal Express
                     5 = Mail
                     6 = Pick-up
                     7 = Unknown

PCC-AUTO-CHK-FL      Alpha 1
Auto Chk Fl          If this field is set to Yes, checks are
                     automatically numbered when you run the
                     payroll cycle.

PCC-PROCESSOR-PHN    Alpha 15
Processor Phn        The processors telephone number.

PCC-PROCESSOR-EXT    Alpha 5
Processor Ext        The processor's telephone extenstion.

PCC-ENTITY-TYPE      Alpha 1
Entity Type          The entity type classifies your client.
                     Valid values are C-Corp, S-Corp, Sole
                     Proprietorship, LTD Liability Corp,
                     Partnership, Joint Venture, Non-Profit
                     Organization, Other.

PCC-NAICS-CODE       Alpha 6
Naics Code           The client industry classification code.

PCC-COST-ACCT-CAT    Alpha 5
Cost Acct Cat        The default account category you are
                     sending records to.

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-CONTACT2         Alpha 20
Contact2

PCC-PHONE-NMBR2      Alpha 15
Phone Nmbr2

PCC-PHONE-EXT2       Alpha 5
Phone Ext2

PCC-FAX-NBR2         Alpha 15
Fax Nbr2

PCC-FAX-EXT2         Alpha 5
Fax Ext2

PCC-DEL-MTHD         Alpha 5
Delivery Method

PCC-STATUS-CD        Alpha 1
Status Cd

                         PBCLIENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCCSET1   COMPANY                                                BN150   PBFE.1
          PROCESS-LEVEL                                          PBIP.1  PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR137   PR140
                                                                 PR150   PR160
                                                                 PR195   PR199
                                                                 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
                                                                 ...

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

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