Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PRFUNDSRC FILE

REFERENCED BY

PR195     PR197     PR204     PR560     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                                                PR04.1  PR195
          PROCESS-LEVEL                                          PR197   PR204
          DEPARTMENT                                             PR560   PR82.1
          FUNDING-SOURCE                                         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