Functional Description
Purpose
The purpose of this function is to create Payment Distribution (F07351) records based on the Auto
Deposit Instructions (F065016) defined for an employee.
Setup Notes and Prerequisites
It is a requirement that you have Payment Records created for employees. Most of the time you will
also have Auto Deposit Instructions setup for an employee as well. This will allow the function to
split the Net Pay from the Payment Record according to how the Auto Deposit Instructions are defined for
a particular employee. If no Auto Deposit Instructions are setup for a particular employee then they
will receive a check for the full Net Amount from the F07350 record and this will be represented as
one F07351 record.
Special Logic
Technical Specification
Parameters:
Data Item Data Structure Description I/O RequiredNotes
PAYD Payroll ID I Y This is the Payroll ID
AN8 Address Number I Y This is the address number for an employee
CKCN Check Control Number I Y This is the check control number
NPAY Net Pay Amount from Stub I Y This is the net pay calculated from the stub
detail.
UPMJ Date Updated I Y This is the date the stub was updated
UPMT Time Last Updated I Y This is the time the stub was updated.
PID3 Program ID I Y This is the program that updated the stub file.
JOBN Workstation ID I Y This is the computer name that updated the stub
file.
USER User ID I Y This is the user ID that updated the stub file.
PFRQ Pay Frequency I Y This is the Pay Frequency.
PPM1 Pay Period Weekly I Y This is the Weekly pay period.
PPM2 Pay Period Bi-Weekly I Y This is the Bi-Weekly pay period.
PPM3 Pay Period Semi-Monthly I Y This is the Semi-Monthly pay period.
PPM4 Pay Period Monthly I Y This is the Monthly pay period.
CKDT Paycheck Date I Y This is the Paycheck Date.
ADOF Auto Deposit Override Flag I Y This is the Auto Deposit Override Flag.
ADPN Auto Deposit PreNote I Y This is the Auto Deposit PreNote.
GLBA GL Bank Account I Y This is the GL Bank Account.
GENLNG PPAT Workfield I Y This is the PPAT Workfield name.
NPYM Number of Payments O Y Total number of payments in this Payroll ID.
NCKS Number of Checks O Y Total number of checks in this Payroll ID.
NAUD Number of Auto Deposits O Y Total number of auto deposits in this Payroll
ID.
TNEP Total Number of Emp Paid O Y Total number of employees paid in this Payroll
ID.
ALPH NameAlpha I Y This is the Alpha Name for the employee.
Related Tables
Table Table Description
F07350 Payment File
F07351 Payment Distribution File
F07210 Pay Cycle Parameters File
F065016 Auto Deposit Instructions File
Related Business Functions
Source NameFunction Name
n0500012 Get AAI for Timecard Journals
b0100011 Error Message Processor to PPAT System
b0100025 Initialize PPAT Error Message API
blm0094 Set Payment Gross to Net Error
Processing
^
D0700002 - DS Create Payment Distribution Records
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szPayrollID | PAYD | char | OPT | NONE |
A code that identifies a group of employees for whom you are processing payroll. Use this ID to process each step of the payroll
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnCheckControlNumber | CKCN | MATH_NUMERIC | OPT | NONE |
A number used to group all payroll transactions for each payment or individual interim payment. This number is carried into the accounting
| ||||
mnAmountNetPay | NPAY | MATH_NUMERIC | OPT | NONE |
The net amount of the payment.
Before the net-deduction phase of the pre-payroll process runs, this amount equals gross pay, less taxes,
| ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeLastUpdated | UPMT | MATH_NUMERIC | OPT | NONE |
The time that specifies when the program executed the last update to this record. | ||||
szProgramID | PID3 | char | OPT | NONE |
Program ID - 03 | ||||
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
cPayFrequency | PFRQ | char | OPT | NONE |
A user defined code (07/PF) that indicates how often an employee is paid. Valid codes are:
B
Biweekly
W
Weekly
S
Semimonthly
| ||||
cPayPeriodWeekly | PPM1 | char | OPT | NONE |
The number of the pay period, within the month, for employees who are paid weekly. This field is used in conjunction with the Pay Period to
| ||||
cPayPeriodBiWeekly | PPM2 | char | OPT | NONE |
The number of the pay period, within the month, for employees who are paid biweekly. The system uses this value and the Pay Period to
| ||||
cPayPeriodSemiMonthly | PPM3 | char | OPT | NONE |
The number of the pay period, within the month, for employees paid semimonthly. The system uses this value and the Pay Period to
| ||||
cPayPeriodMonthly | PPM4 | char | OPT | NONE |
The number of the pay period within the month, for employees who are paid monthly. This field is used in conjunction with the Pay Period to
| ||||
jdDatePayCheck | CKDT | JDEDATE | OPT | NONE |
The date associated with the various types of net pay instructions. This date relates to a payroll check, an interim payment, a bank
| ||||
cAutoDepositOverride | ADOF | char | OPT | NONE |
A code that specifies whether to override auto deposits. A Y turns off auto deposit for all employees in this pre-payroll processing version
| ||||
cAutoDepositPreNote | ADPN | char | OPT | NONE |
A code that lets you test the deposit instructions for one pay period before actually processing a deposit. Adding an employee to this form
| ||||
szGLBankAccount | GLBA | char | OPT | NONE |
The number of the bank account (general ledger account) to be updated automatically when receipts or disbursements are entered. The
| ||||
idPPATWorkfield | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
mnNumberPayments | NPYM | MATH_NUMERIC | OPT | NONE |
The total number of payments in this Payroll ID. | ||||
mnNumberChecks | NCKS | MATH_NUMERIC | OPT | NONE |
The total number of checks in this Payroll ID. | ||||
mnNumberAutoDeposits | NAUD | MATH_NUMERIC | OPT | NONE |
The total number of auto deposits in this Payroll ID. | ||||
mnTotalNumberEmployeesPaid | TNEP | MATH_NUMERIC | OPT | NONE |
The total number of employees being processed in this Payroll ID. | ||||
szNameAlpha | ALPH | char | OPT | INPUT |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
cGrossNetErrorFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnPrePayrollErrorLineID | LIID | MATH_NUMERIC | OPT | NONE |
A system-assigned line ID that uniquely identifies the records in this table.
The line ID determines the print order of the records on the stub or
| ||||
szAAIJournalsCache_PID | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
|
B0700920 Retrieve AAI for Journals | ||||
N0500012 Get AAI For Timecard Journals | ||||
N0700105 F07355 Write Pre-Payroll Error Record | ||||
N0800031 Get UDC Description |
F0005 User Defined Codes | ||||
F065016 Automatic Bank Deposit Master | ||||
F07210 Pay Cycle Parameters File | ||||
F07350 Payment File | ||||
F07351 Payment Distribution File | ||||
F07355 Pre-Payroll Error File |