|
|
PRFUNDSRC FILE
REFERENCED BY
AC542 PR160 PR180 PR195 PR197 PR204
PR29.1 PR529 PR560 PR80.2 PR82.1 PR85.1
UK560
UPDATED BY
PR04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PFS-COMPANY Numeric 4 PR04.1
Element: Company The company number represents an
established company and is entered on
all function codes.
PFS-PROCESS-LEVEL Alpha 5 PR04.1
Element: Process Level This 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
PFS-DST-ACCT-UNIT Alpha 15 PR04.1
Element: Accounting Unit
PFS-DST-ACCOUNT Numeric 6 PR04.1
Element: Account
PFS-DST-SUB-ACCT Numeric 4 PR04.1
Element: Subaccount
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.
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 AC542 PR04.1
PROCESS-LEVEL PR160 PR180
DEPARTMENT PR195 PR197
FUNDING-SOURCE PR204 PR29.1
PR529 PR560
PR80.2 PR82.1
PR85.1 UK560
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
|
