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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
USER_FIELD		Numeric 4—PR04.1

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PFSSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
  4. FUNDING-SOURCE
PrimaryPR04.1, PR160, PR180, PR195, PR197, PR204, PR29.1, PR529 +5 more
PFSSET2
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
  4. USER-FIELD
  5. FUNDING-SOURCE
KeyChange, SubsetWhere USER-FIELD != Zeroes And STATUS = 1—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTIVITYPRSYSTEMDEPTCODEGLMASTERPRFUNDSRC

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Acct CatACACCTCATNot Required
PFS-ACCT-CATEGORY→AAX-ACCT-CATEGORY (AAXSET1)
ActivityACACTIVITYNot Required
PFS-DIST-COMPANY→ACV-COMPANY
PFS-ACTIVITY→ACV-ACTIVITY
CompanyPRSYSTEMRequired
PFS-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DepartmentDEPTCODENot Required
PFS-COMPANY→DPT-COMPANY
PFS-PROCESS-LEVEL→DPT-PROCESS-LEVEL
PFS-DEPARTMENT→DPT-DEPARTMENT
Gl AccountGLMASTERNot 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 LevelPRSYSTEMRequired
PFS-COMPANY→PRS-COMPANY
PFS-PROCESS-LEVEL→PRS-PROCESS-LEVEL

Programs

Updated by (1)

Referenced by (12)