|
|
EMDISTMAST FILE
Emp Acct Distribution Override
This file contains information for overriding, by percent, the normal
distribution of wages and company-paid deduction expenses by pay code,
company-paid deduction, or employee. The system uses the records to determine
the scheme for creating General Ledger Transaction File and Employee Payment
Distribution file records when you close the payroll cycle.
Records can include pay codes or deductions. If you do not enter either a pay
code or a deduction, the override distribution is referred to as an employee
override distribution and the distribution of wages and company-paid deduction
expenses follows the same pattern. PR23.1 (Payroll Distribution) is the
primary program that updates this file. PR199 (Payroll Close) and PR150
(Distribution Edit) are the primary programs that reference this file for
calculating distributions.
REFERENCED BY
AC541 AC542 BN150 HR511 HR650 PA100
PA102 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR120 PR128 PR13.1 PR13.5 PR13.6
PR13.8 PR130 PR131 PR132 PR134 PR136
PR189 PR195 PR223 PR29.1 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR36.1 PR45.1 PR529 PR530
PR560 PR80.1 PR82.1 UK102 UK560 TA147
UK120 PR197 PR85.1
UPDATED BY
PR23.1 PR23.3 HR11.1 PA02.1 PA115 PA302
PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DIP-COMPANY Numeric 4 PR23.1 PR23.3
Element: Company The company number represents an
established company and is entered on
all function codes.
DIP-EMPLOYEE Numeric 9 PR23.1 PR23.3
Element: Employee Valid in the Employee file.
DIP-PAY-CODE Alpha 4 PR23.1 PR23.3
Element: Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
DIP-DED-CODE Alpha 4 PR23.1 PR23.3
Element: Deduction CodeValid in the Deduction file as a
company-paid deduction (deduction Adjust
Pay field = C).
DIP-SEQ-NBR Numeric 4 PR23.1 PR23.3
Element: Sequence NumbeContains the distribution sequence
number. The value in this field is
automatically sequenced based on the
last employee distribution sequence
number.
DIP-PROCESS-LEVEL Alpha 5 PR23.1 PR23.3
Element: Process Level Contains the process level. The system
uses this field when creating Employee
Payment Distribution file records. The
system does not use this field when
creating General Ledger Transaction File
records.
DIP-DEPARTMENT Alpha 5 PR23.1 PR23.3
Element: Department Contains the department. The system
uses this field when creating Employee
Payment Distribution file records. The
system does not use this field when
creating General Ledger Transaction File
records.
DIP-DST-ACCT-UNIT Alpha 15 PR23.1 PR23.3
Element: Accounting UniContains the accounting unit to which
the amount is posted. The accounting
unit in this field together with the
account and subaccount must be valid in
the General Ledger Account file.
DIP-DST-ACCOUNT Numeric 6 PR23.1 PR23.3
Element: Account Contains the general ledger account to
which the amount is posted.
DIP-DST-SUB-ACCT Numeric 4 PR23.1 PR23.3
Element: Subaccount Contains the general ledger subaccount
to which the amount is posted.
DIP-DIST-COMPANY Numeric 4 PR23.1 PR23.3
Element: Company
DIP-PERCENT Signed 7.3 PR23.1 PR23.3
Element: Percent Contains the distribution percent.
DIP-JOB-CODE Alpha 9 PR23.1 PR23.3
Element: Job Code Contains the job code the system uses
when creating the Employee Payment
Distribution file record. The system
does not use this field when creating GL
Transactions file records.
DIP-OT-ACCOUNT Numeric 6 PR23.1 PR23.3
Element: Ot Account Contains the accounting unit for the
premium expense distribution override.
DIP-OT-SUB-ACCT Numeric 4 PR23.1 PR23.3
Element: Ot Sub Acct Contains the subaccount for the premium
expense distribution override.
DIP-SH-ACCOUNT Numeric 6 PR23.1 PR23.3
Element: Sh Account Contains the account number for the
shift expense distribution override.
DIP-SH-SUB-ACCT Numeric 4 PR23.1 PR23.3
Element: Sh Sub Acct Contains the subaccount number for the
shift expense distribution override.
DIP-ACTIVITY Alpha 15 PR23.1 PR23.3
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.
DIP-ACCT-CATEGORY Alpha 5 PR23.1 PR23.3
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.
DIP-POSITION Alpha 12 PR23.1 PR23.3
Element: Position Contains the user-defined code that
represents a position in the company.
EMDISTMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DIPSET1 COMPANY AC541 AC542
EMPLOYEE BN150 HR11.1
POSITION HR11.2 HR511
PAY-CODE HR650 PA02.1
DED-CODE PA100 PA102
SEQ-NBR PA115 PA302
PA502 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
...
DIPSET2 COMPANY Subset AC542 PR195
EMPLOYEE Where (EMPLOYEE != Zeroes ) PR197 PR82.1
PAY-CODE* PR85.1
DED-CODE*
SEQ-NBR
DIPSET3 COMPANY Subset AC542 PR195
POSITION Where (EMPLOYEE = Zeroes ) PR197 PR82.1
PAY-CODE* PR85.1
DED-CODE*
SEQ-NBR
EMDISTMAST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When DIP-ACCT-CATEGORY != Spaces
DIP-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When DIP-ACTIVITY != Spaces
DIP-ACTIVITY -> ACV-ACTIVITY
Company PRSYSTEM Required
DIP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduction Code DEDCODE Required
When DIP-DED-CODE != Spaces
DIP-COMPANY -> DDC-COMPANY
DIP-DED-CODE -> DDC-DED-CODE
Department DEPTCODE Required
When DIP-DEPARTMENT != Spaces
DIP-COMPANY -> DPT-COMPANY
DIP-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
DIP-DEPARTMENT -> DPT-DEPARTMENT
Dist Company GLSYSTEM Required
When DIP-DIST-COMPANY != Zeroes
DIP-DIST-COMPANY -> GLS-COMPANY
Employee EMPLOYEE Required
DIP-COMPANY -> EMP-COMPANY
DIP-EMPLOYEE -> EMP-EMPLOYEE
Gl Acct Nbr GLMASTER Required
DIP-DIST-COMPANY -> GLM-COMPANY
DIP-DST-ACCT-UNIT -> GLM-ACCT-UNIT
DIP-DST-ACCOUNT -> GLM-ACCOUNT
DIP-DST-SUB-ACCT -> GLM-SUB-ACCOUNT
Job Code JOBCODE Required
When DIP-JOB-CODE != Spaces
DIP-COMPANY -> JBC-COMPANY
DIP-JOB-CODE -> JBC-JOB-CODE
Ot Account GLMASTER Required
When DIP-OT-ACCOUNT != Zeroes
DIP-DIST-COMPANY -> GLM-COMPANY
DIP-DST-ACCT-UNIT -> GLM-ACCT-UNIT
DIP-OT-ACCOUNT -> GLM-ACCOUNT
DIP-OT-SUB-ACCT -> GLM-SUB-ACCOUNT
Pay Code PRPAYCODE Required
When DIP-PAY-CODE != Spaces
DIP-COMPANY -> PCD-COMPANY
DIP-PAY-CODE -> PCD-PAY-CODE
Spaces -> PCD-PROCESS-LEVEL
Spaces -> PCD-JOB-CODE
Process Level PRSYSTEM Required
When DIP-PROCESS-LEVEL != Spaces
DIP-COMPANY -> PRS-COMPANY
DIP-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Sh Account GLMASTER Required
When DIP-SH-ACCOUNT != Zeroes
DIP-DIST-COMPANY -> GLM-COMPANY
DIP-DST-ACCT-UNIT -> GLM-ACCT-UNIT
DIP-SH-ACCOUNT -> GLM-ACCOUNT
DIP-SH-SUB-ACCT -> GLM-SUB-ACCOUNT
|
