This page (revision-12) was last changed on 23-Feb-2023 16:12 by Kevin Higgs

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
12 23-Feb-2023 16:12 4 KB Kevin Higgs to previous
11 26-Nov-2021 10:22 3 KB rforbes to previous | to last
10 26-Nov-2021 10:22 3 KB jmyers to previous | to last
9 26-Nov-2021 10:22 2 KB rforbes to previous | to last
8 26-Nov-2021 10:22 2 KB rforbes to previous | to last
7 26-Nov-2021 10:22 2 KB JMyers to previous | to last
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 4 KB JMyers to previous | to last
3 26-Nov-2021 10:22 4 KB JMyers to previous | to last
2 26-Nov-2021 10:22 4 KB JMyers to previous | to last
1 26-Nov-2021 10:22 46 bytes UnknownAuthor to last

Page References

Incoming links Outgoing links
UPDTB_CPA 1464
UPDTB_CPA1464

Version management

Difference between version and

At line 1 changed one line
!!!CREATE PAYROLL DIRECT DEPOSIT (CPA1464 format)
!!!CREATE PAYROLL DIRECT DEPOSIT
At line 4 changed one line
If your organization creates direct deposits or Electronic Fund Transfers (EFT) in the Canadian Payments Association 1464 byte format, an interface file needs to be created and then sent to the bank. You may generate this file through the Create Payroll Direct Deposit (UPDTB_CPA1464) form.
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 (UPDTB_CPA1464) form.
At line 6 added 14 lines
The UPDTB_CPA1464 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 14 changed 4 lines
|File Create Date|Mandatory, Date, LOV Available\\The date the file was created is indicated in this field.
|Due Date|Mandatory, Date, LOV Available\\The date the file is due is listed in this field.
|Institution ID|Mandatory, Text\\
|Short Name|Mandatory, Text\\
|File Create Date|Mandatory, Date, LOV Available\\
|Due Date|Mandatory, Date, LOV Available\\
|Institution ID|Mandatory, Text
|Short Name|Mandatory, Text
At line 20 changed one line
|File Name|Mandatory, Text\\Enter the name of the file that will be created in the interface directory specified.\\If you use the tokens ''MEX'' or ''DATE'' or ''TIME'' these will be replaced as noted in [P2K_PU.FILE_NAME]. Also supported is ''FILE'' which will replace the File Creation Number, which is a User Defined Field on the [IPBA] screen.
|File Name|Mandatory, Text\\Enter the name of the file that will be created in the interface directory specified.
At line 24 removed 2 lines
|(RBC) Proc Centre|Optional, Text\\This field allows for the support of the RBC variation of the CPA1464 format. It is __only__ needed by clients selecting the RBC Format. The definition of this field is provided in the specification supplied by RBC to the client.
|Additional File Header|Optional, Text\\This field is an optional extra file header which is a constant value. It is used __only__ for RBC clients. Once populated, the text in this field will be the first record in the file.
At line 27 removed 4 lines
----
!!BYPASSED DEPOSIT NOTIFICATIONS
The UPDTB_CPA1464 process will flag all deposits as being completed if run in non-trial mode.
The deposit will be updated with the MEX_ID of the UPDTB_CPA1464 that processed them.
At line 32 changed 4 lines
The UPDTB_CPA1464 will report any outstanding deposits that do not have this MEX_ID and meet the additional conditions of\\
\\
- Having a status of "Deposit Issued" in the lexicon X_DEPOSIT_STATUS \\
- Having a Pay Issue Date less than the "From" date in the UPDTB_CPA1496 parameters.
|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\\
|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
|File Name|
|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 57 added one line
[{If var='loginstatus' contains 'authenticated'
At line 39 removed 30 lines
!!HOW TO UNDO UPDTB_CPA1464
There is no standard function to "undo" a UPDTB_CPA1464 that has been run in UPDATE mode.
The UPDTB_CPA1464 will update MEX_ID column found on the P2K_PR_DEPOSITS table with the execution ID created when UPDTB_CPA1464 was processed.
This prevents deposits that have already been sent to the bank from appearing in susequent runs of UPDTB_CPA1464.
A script can be used in situations where the file sent is rejected, or problems are identified after running the process.\\
\\
Please note - '######' will be replaced by the MEX_ID from UPDTB_CPA1464.
First verify the number of records to be updated;
{{{
select count(mex_id)
from p2k_pr_deposits
where mex_id = '######';
/
}}}
Once you have verified the number of records, the update script can be run;
{{{
UPDATE p2k_pr_deposits
set mex_id = NULL
where mex_id = '######';
/
}}}
Once the update script has been completed - commit the records;
{{{
COMMIT;
/
}}}
At line 70 changed 2 lines
![Notes|Edit:Internal.UPDTB_CPA1464]
[{InsertPage page='Internal.UPDTB_CPA1464' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.UPDTB_CPA1464]
[{InsertPage page='Internal.UPDTB_CPA1464' default='Click to create a new discussion page'}]
At line 63 added 2 lines
}]
This page (revision-12) was last changed on 23-Feb-2023 16:12 by Kevin HiggsTop