Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRFUNDSRC


                             PRFUNDSRC FILE

REFERENCED BY

PR160     PR180     PR197     PR204     PR29.1    PR529
PR560     PR82.1    PR85.1

UPDATED BY

PR04.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PFS-COMPANY            Numeric 4                                 PR04.1
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.

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

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

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

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

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

PFS-DIST-COMPANY       Numeric 4                                 PR04.1
Element: 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
Element: Accounting UniContains the General Ledger accounting
                       unit to which the amount is posted.

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

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

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


PFS-ACCT-CATEGORY      Alpha 5                                   PR04.1
Element: Account CategoAccount 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.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

PFS-STATUS             Numeric 1                                 PR04.1
Element: Status        This field displays the status of the
                       transaction.
                       1 = Active
                       2 = Inactive

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

                         PRFUNDSRC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PFSSET1   COMPANY                                                PR04.1  PR160
          PROCESS-LEVEL                                          PR180   PR197
          DEPARTMENT                                             PR204   PR29.1
          FUNDING-SOURCE                                         PR529   PR560
                                                                 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