PRFUNDSRC

REFERENCED BY
PR160 PR180 PR195 PR197 PR29.1 PR529
PR560 PR582 PR80.2 PR82.1 PR85.1 UK560


UPDATED BY
PR04.1 PR204

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFS-COMPANY
Element: Company Hr
Numeric 4
PR04.1
PFS-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
PR04.1
PFS-DEPARTMENT
Element: Department
Alpha 5
Contains the department.
PR04.1
PFS-FUNDING-SOURCE
Element: Funding Source
Alpha 6
PR04.1
PFS-PAYMENT-DESC
Element: Payment Desc
Alpha 15 (Lower Case)
PR04.1
PFS-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
PR04.1
PFS-DIST-COMPANY
Element: Company
Numeric 4
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.
PR04.1
PFS-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
The 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
Element: Account
Numeric 6
This 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
Element: Sub Acct
Numeric 4
This 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
Element: Activity
Alpha 15
Activities 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
Element: Acct Category
Alpha 5
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. Valid account category types are: cost revenue accrual pass thru
PR04.1
PFS-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
1 = Active
2 = Inactive
PR04.1
PFS-USER-FIELD
Element: User Field
Numeric 4
PR04.1


PRFUNDSRC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PFSSET1 COMPANY
PROCESS-LEVEL
DEPARTMENT
FUNDING-SOURCE
PR04.1 PR160
PR180 PR195
PR197 PR204
PR29.1 PR529
PR560 PR582
PR80.2 PR82.1
PR85.1 UK560
PFSSET2 COMPANY
PROCESS-LEVEL
DEPARTMENT
USER-FIELD
FUNDING-SOURCE
KeyChange, Subset
WhereUSER-FIELD !=Zeroes
AndSTATUS =1


PRFUNDSRC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:51:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.