Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PRFUNDSRC FILE

REFERENCED BY

AC542     PR160     PR180     PR195     PR197     PR204
PR29.1    PR529     PR560     PR80.2    PR82.1    PR85.1

UPDATED BY

PR04.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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


PFS-DEPARTMENT       Alpha 5                                     PR04.1
Department           Contains the department.

PFS-FUNDING-SOURCE   Alpha 6                                     PR04.1
Funding Source

PFS-PAYMENT-DESC     Alpha 15  (Lower Case)                      PR04.1
Payment Desc

PFS-DESCRIPTION      Alpha 30  (Lower Case)                      PR04.1
Description          This field displays the description.

PFS-DIST-COMPANY     Numeric 4                                   PR04.1
Distribution Company The company number used for posting the
                     transaction. A valid intercompany
                     relationship must be defined in the
                     Lawson General Ledger system.

PFS-DST-ACCT-UNIT    Alpha 15                                    PR04.1
Distribution         Contains the General Ledger accounting
Accounting Unit      unit to which the amount is posted.

PFS-DST-ACCOUNT      Numeric 6                                   PR04.1
Distribution         Contains the General Ledger account to
Account Number       which the amount is posted.

PFS-DST-SUB-ACCT     Numeric 4                                   PR04.1
Distribution         Contains the General Ledger subaccount
Subaccount Number    to which the amount is posted.

PFS-ACTIVITY         Alpha 15                                    PR04.1
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.



PFS-ACCT-CATEGORY    Alpha 5                                     PR04.1
Account Category     Account categories are groupings of
                     costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.



PFS-STATUS           Numeric 1                                   PR04.1
Status               This field displays the status of the
                     transaction.

                     1 = Active
                     2 = Inactive

PFS-USER-FIELD       Numeric 4                                   PR04.1
User Field

                         PRFUNDSRC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PFSSET1   COMPANY                                                AC542   PR04.1
          PROCESS-LEVEL                                          PR160   PR180
          DEPARTMENT                                             PR195   PR197
          FUNDING-SOURCE                                         PR204   PR29.1
                                                                 PR529   PR560
                                                                 PR80.2  PR82.1
                                                                 PR85.1

PFSSET2   COMPANY       KeyChange, Subset
          PROCESS-LEVEL Where USER-FIELD != Zeroes
          DEPARTMENT    And   STATUS     =  1
          USER-FIELD
          FUNDING-SOURCE

PFSSET3   COMPANY       Subset
          PROCESS-LEVEL Where STATUS = 1
          DEPARTMENT
          FUNDING-SOURCE

                         PRFUNDSRC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Cat       ACACCTCAT    Not Required

                            PFS-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY  (AAXSET1)

Activity       ACACTIVITY   Not Required

                            PFS-DIST-COMPANY     -> ACV-COMPANY
                            PFS-ACTIVITY         -> ACV-ACTIVITY

Company        PRSYSTEM     Required

                            PFS-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Not Required

                            PFS-COMPANY          -> DPT-COMPANY
                            PFS-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            PFS-DEPARTMENT       -> DPT-DEPARTMENT

Gl Account     GLMASTER     Not Required

                            PFS-DIST-COMPANY     -> GLM-COMPANY
                            PFS-DST-ACCT-UNIT    -> GLM-ACCT-UNIT
                            PFS-DST-ACCOUNT      -> GLM-ACCOUNT
                            PFS-DST-SUB-ACCT     -> GLM-SUB-ACCOUNT

Process Level  PRSYSTEM     Required

                            PFS-COMPANY          -> PRS-COMPANY
                            PFS-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL