Wiki: UPDTB

CREATE PAYROLL DIRECT DEPOSIT FILE#

Processing Information#

If your organization creates direct deposits, 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.

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	H$TDBANK_CDN	Canada
	H$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.

Report Parameters#

Report Parameters
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 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.