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
HR00.1 | HR01.1 | HR02.1 | PR223 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
DIP-COMPANY Element: Company Hr | Numeric 4 |
|
||
DIP-EMPLOYEE Element: Employee | Numeric 9 Valid in the Employee file. |
|
||
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. |
|
||
DIP-DED-CODE Element: Ded Code | Alpha 4 Valid in the Deduction file as a company-paid deduction (deduction Adjust Pay field = C). |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
DIP-DST-ACCOUNT Element: Account | Numeric 6 Contains the general ledger account to which the amount is posted. |
|
||
DIP-DST-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the general ledger subaccount to which the amount is posted. |
|
||
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. |
|
||
DIP-PERCENT Element: Percent | Signed 7.3 Contains the distribution percent. |
|
||
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. |
|
||
DIP-OT-ACCOUNT Element: Account | Numeric 6 Contains the accounting unit for the premium expense distribution override. |
|
||
DIP-OT-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the subaccount for the premium expense distribution override. |
|
||
DIP-SH-ACCOUNT Element: Account | Numeric 6 Contains the account number for the shift expense distribution override. |
|
||
DIP-SH-SUB-ACCT Element: Sub Acct | Numeric 4 Contains the subaccount number for the shift expense distribution override. |
|
||
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. |
|
||
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 |
|
||
DIP-POSITION Element: Position | Alpha 12 Contains the user-defined code that represents a position in the company. |
|
||
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. |
|
||
DIP-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
DIP-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) Contains the user ID of the person who last changed this record. |
|
||
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. |
|
||
DIP-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
DIP-USER-ID Element: User Id | Alpha 10 (Lower Case) Contains the user ID of the person who last changed this record. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DIPSET1 |
COMPANY EMPLOYEE POSITION PAY-CODE DED-CODE SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||||||
DIPSET2 |
COMPANY EMPLOYEE PAY-CODE* DED-CODE* SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||||||
DIPSET3 |
COMPANY POSITION PAY-CODE* DED-CODE* SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acct Category | ACACCTCAT |
Required
| ||||||||||||||||||
Activity | ACACTIVITY |
Required
| ||||||||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||||||||
Deduction Code | DEDCODE |
Required
| ||||||||||||||||||
Department | DEPTCODE |
Required
| ||||||||||||||||||
Dist Company | GLSYSTEM |
Required
| ||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||
Gl Acct Nbr | GLMASTER |
Required
| ||||||||||||||||||
Job Code | JOBCODE |
Required
| ||||||||||||||||||
Ot Account | GLMASTER |
Required
| ||||||||||||||||||
Pay Code | PRPAYCODE |
Required
| ||||||||||||||||||
Process Level | PRSYSTEM |
Required
| ||||||||||||||||||
Sh Account | GLMASTER |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.