PRFUNDSRC – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PFS
Primary key
COMPANY, PROCESS-LEVEL, DEPARTMENT, FUNDING-SOURCE
Fields
14
Updated by
1 program
Referenced by
12 programs

PRFUNDSRC is a Lawson Payroll table (prefix PFS); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, DEPARTMENT, FUNDING-SOURCE (PFSSET1); alternate indexes: PFSSET2. It is related 1:1 to ACACCTCAT, ACACTIVITY, PRSYSTEM, DEPTCODE and GLMASTER. It is updated by PR04.1 and referenced by PR160, PR180, PR195, PR197, PR204, PR29.1, PR529, PR560 and 4 more. The table has 14 fields, 2 indexes and 6 documented relations.

About PRFUNDSRC

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the PFS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PFS-COMPANY PK
COMPANY		Numeric 4—PR04.1
PFS-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—PR04.1
PFS-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department.PR04.1
PFS-FUNDING-SOURCE PK
FUNDING_SOURCE		Alpha 6—PR04.1
PFS-PAYMENT-DESC
PAYMENT_DESC		Alpha 15 (Lower Case)—PR04.1
PFS-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.PR04.1
PFS-DIST-COMPANY
DIST_COMPANY		Numeric 4Identifies 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.PR04.1
PFS-DST-ACCT-UNIT
DST_ACCT_UNIT		Alpha 15The 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.PR04.1
PFS-DST-ACCOUNT
DST_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.PR04.1
PFS-DST-SUB-ACCT
DST_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.PR04.1
PFS-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.PR04.1
PFS-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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 thruPR04.1
PFS-STATUS
STATUS		Numeric 1This field displays the status of the transaction.
  • 1 Active
  • 2 Inactive
PR04.1
PFS-USER-FIELD
USER_FIELD		Numeric 4—PR04.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PFSSET1COMPANY, PROCESS-LEVEL, DEPARTMENT, FUNDING-SOURCEPrimaryPR04.1, PR160, PR180, PR195, PR197, PR204, PR29.1, PR529 +5 more
PFSSET2COMPANY, PROCESS-LEVEL, DEPARTMENT, USER-FIELD, FUNDING-SOURCEKeyChange, SubsetWhere USER-FIELD != Zeroes And STATUS = 1—

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Acct CatACACCTCATNot RequiredPFS-ACCT-CATEGORY → AAX-ACCT-CATEGORY (AAXSET1)
ActivityACACTIVITYNot RequiredPFS-DIST-COMPANY → ACV-COMPANY, PFS-ACTIVITY → ACV-ACTIVITY
CompanyPRSYSTEMRequiredPFS-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
DepartmentDEPTCODENot RequiredPFS-COMPANY → DPT-COMPANY, PFS-PROCESS-LEVEL → DPT-PROCESS-LEVEL, PFS-DEPARTMENT → DPT-DEPARTMENT
Gl AccountGLMASTERNot RequiredPFS-DIST-COMPANY → GLM-COMPANY, PFS-DST-ACCT-UNIT → GLM-ACCT-UNIT, PFS-DST-ACCOUNT → GLM-ACCOUNT, PFS-DST-SUB-ACCT → GLM-SUB-ACCOUNT
Process LevelPRSYSTEMRequiredPFS-COMPANY → PRS-COMPANY, PFS-PROCESS-LEVEL → PRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (12)