This page (revision-5) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
5 26-Nov-2021 10:22 1 KB JMyers to previous
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 3 KB JMyers to previous | to last
1 26-Nov-2021 10:22 37 bytes UnknownAuthor to last

Page References

Incoming links Outgoing links
UPEQPTR
UPEQPTR

Version management

Difference between version and

At line 1 changed one line
!!!PROCESS EQUIPMENT JOURNALS FROM PAY TRANSACTIONS
!!!CREATE PAYROLL DIRECT DEPOSIT FILE
At line 4 changed one line
The (UPEQPTR) file allows you to process equipment journals from pay transactions.
If your organization creates direct deposits or Electronic Fund Transfers (EFT), an interface file needs to be created and then sent to the bank. You may generate this file through the Create Payroll Direct Deposit File (UPDTB) form.
At line 6 added 14 lines
The UPDTB will create the bank deposit file according to the layout specified on the [IDIF] form.
|__Interface Type__| __Interface Code__ |__Country__
|Bank Deposit| [HL$ACH]| USA
|Disbursement File|[HL$UPDIF_CDN]| Canada
| |[HL$UPDIF_USA]| USA
|TD Fund$Out|[HL$TDBANK_CDN] |Canada
| |[HL$TDBANK_USA]| USA
|Royal Bank Deposit| [HL$RYBANK_STD152]| Canada
|Scotia Bank Deposit| [HL$BNS_BANK]| Canada
|CIBC Deposits| [HL$CIBC] |Canada
Pre-notification deposits are processed.
At line 10 changed 7 lines
|Entity|Mandatory,LOV available\\This field lets you identify the entity associated with the report.
|EQ Time Code|Optional,LOV available\\This field lets you identify the equipment time code associated with the report.
|EQ Request File|Optional, Text\\This field allows you to provide an interface file name for the equipment.
|EQ Errors File|Optional, Text\\This field allows you to provide an interface file name for the equipment errors.
|Interface Directory|Mandatory, Text\\This field must indicate a directory on the [data base server|DATA BASE SERVER] for which the current user (as signed onto the \\client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the \\‘TEMP’ directory on the server, not the local directory for the computer terminal\\ being used.
|Trial Interface Run|Optional, [Yes or No|X_YES_NO] lexicon available//You may choose to run the report in a trial mode to see results <Yes> or in update mode <No>.
|Exception Level|Mandatory, [Exception Level|X_TRACE_LEVEL] lexicon available\\This field defines the exception level (report messages) required.
|Payroll Bank Account|Mandatory, LOV Available\\The bank account from where the deposits are drawn.
|Debit Payroll Account|Optional, Toggle\\This parameter is used only for the ACH format and will create conditional debit \\to cover the total of all checks.
|As Of Date|Mandatory, Date, LOV Available\\The date of the EFT.
|From Pay Issue Date|Mandatory, Date, LOV Available\\The earliest issue date of the deposits that will qualify for this EFT
|To Pay Issue Date|Mandatory, Date, LOV Available\\The latest issue date of the deposits that will qualify for this EFT.
|Interface Code|Mandatory, LOV Available\\The report definition selected will determine the format of the output file (if any), \\as well as the columnar content of the report.
|Interface Directory|Mandatory, Text\\Must be a directory on the [data base server|DATA BASE SERVER] for which the current user (as signed onto the \\client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the \\‘TEMP’ directory on the server, not the local directory for the computer terminal\\ being used.
|File Name|Mandatory, Text\\Enter the name of the file that will be created in the interface directory specified.
|Write or Append|Mandatory, LOV Available\\Append or overwrite any existing file.
|Custom Header Record|Optional, Text\\This exact text will be written as a separate record at the beginning of the file.
|Custom Trailer Record|Optional, Text\\This exact text will be written as a separate record at the end of the file.
|Output Headers/Trailer|Optional, Toggle\\If this toggle is ON, these records will be marked as ‘/H’ at the beginning and ‘/T’ at \\the end.
|Test Run|Optional, Toggle (Only used for the Royal Bank)\\This is a function for Canadian installations. This field ensures that in the Royal\\Bank format, Record ‘1’, Field ‘6’ will have a value of TEST. This indicates that this\\is a test file and not an actual file that the bank will load. The file will still be created\\normally.
|ACH Blocking|Optional, Toggle\\This is a function for US installations only.\\Some clearing houses require blocking as described in the ‘ACH Rules’. Normally\\these are ones who still use ‘reel to reel’ tape drives.\\ACH records must be written in groups (blocks) of 10 records. After the file control\\record is written onto the file, the remaining unused records of the last physical\\block is completed with all 9's. If the total number records (headers + details +\\control records) is a number evenly divisible by ten then there are no records written\\with 9's.
|Trial|Optional, Toggle\\If ‘ON’ then the update is not committed and UPDTB may be run again.
|Exception Level|Mandatory, LOV Available\\Users may increase the level of logging done from exception to user, legislation,\\usercalc, program or utility levels.
At line 18 removed 5 lines
||Report Filters||
|Payroll|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the payrolls selected.
|Pay Category|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the pay categories selected.
|Pay Period|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the pay periods selected.
|Batch Number|Optional, Multiple Selection Available, LOV Available\\This will limit the report to the batch numbers selected.
At line 42 added one line
[{If var='loginstatus' contains 'authenticated'
At line 26 changed 2 lines
![Notes|Edit:Internal.UPEQPTR]
[{InsertPage page='Internal.UPEQPTR' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.UPEQPTR]
[{InsertPage page='Internal.UPEQPTR' default='Click to create a new discussion page'}]
At line 48 added 2 lines
}]
This page (revision-5) was last changed on 26-Nov-2021 10:22 by JMyersTop