EMDISTMAST

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.
UPDATED BY
PR23.1 PR23.3 PR23.2 PR323 BN150 BN305
HR11.1 HR11.2 HR511 PR521 EXI2.1 EXI4.1
LP130 LP140 PA02.1 PA100 PA102 PA115
PA13.1 PA13.2 PA302 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PR110 PR113 PR120
PR128 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9
PR130 PR131 PR132 PR134 PR135 PR136
PR137 PR189 PR195 PR223 PR29.1 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR37.1 PR45.1 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 UK102 UK560
TA147 PA182 PR197 PR85.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DIP-COMPANY
Element: Company Hr
Numeric 4
PR23.1 PR23.3
DIP-EMPLOYEE
Element: Employee
Numeric 9
Valid in the Employee file.
PR23.1 PR23.3
DIP-PAY-CODE
Element: Pay Code
Alpha 4
Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.
PR23.1 PR23.3
DIP-DED-CODE
Element: Ded Code
Alpha 4
Valid in the Deduction file as a company-paid deduction (deduction Adjust Pay field = C).
PR23.1 PR23.3
DIP-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains the distribution sequence number. The value in this field is automatically sequenced based on the last employee distribution sequence number.
PR23.1 PR23.3
DIP-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
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.
PR23.1 PR23.3
DIP-DEPARTMENT
Element: Department
Alpha 5
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.
PR23.1 PR23.3
DIP-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains 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.
PR23.1 PR23.3
DIP-DST-ACCOUNT
Element: Account
Numeric 6
Contains the general ledger account to which the amount is posted.
PR23.1 PR23.3
DIP-DST-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the general ledger subaccount to which the amount is posted.
PR23.1 PR23.3
DIP-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.
PR23.1 PR23.3
DIP-PERCENT
Element: Percent
Signed 7.3
Contains the distribution percent.
PR23.1 PR23.3
DIP-JOB-CODE
Element: Job Code
Alpha 9
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.
PR23.1 PR23.3
DIP-OT-ACCOUNT
Element: Account
Numeric 6
Contains the accounting unit for the premium expense distribution override.
PR23.1 PR23.3
DIP-OT-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the subaccount for the premium expense distribution override.
PR23.1 PR23.3
DIP-SH-ACCOUNT
Element: Account
Numeric 6
Contains the account number for the shift expense distribution override.
PR23.1 PR23.3
DIP-SH-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the subaccount number for the shift expense distribution override.
PR23.1 PR23.3
DIP-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.
PR23.1 PR23.3
DIP-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
PR23.1 PR23.3
DIP-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
PR23.1 PR23.3
DIP-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
PR23.1 PR23.3
DIP-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PR23.1 PR23.3
DIP-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
PR23.1 PR23.3
DIP-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
PR23.1 PR23.3
DIP-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PR23.1 PR23.3
DIP-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
PR23.1 PR23.3


EMDISTMAST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DIPSET1 COMPANY
EMPLOYEE
POSITION
PAY-CODE
DED-CODE
SEQ-NBR
...
BN150 BN305
HR11.1 HR11.2
HR511 PR521
EXI2.1 EXI4.1
LP130 LP140
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA302 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
DIPSET2 COMPANY
EMPLOYEE
PAY-CODE*
DED-CODE*
SEQ-NBR
Subset
Where(EMPLOYEE !=Zeroes)
PA182 PR195
PR197 PR582
PR82.1 PR85.1
DIPSET3 COMPANY
POSITION
PAY-CODE*
DED-CODE*
SEQ-NBR
Subset
Where(EMPLOYEE =Zeroes)
PA182 PR195
PR197 PR323
PR582 PR82.1
PR85.1


EMDISTMAST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
When (DIP-EMPLOYEE !=Zeroes )
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


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

Home
Contact Us



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