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

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

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
8 26-Nov-2021 10:22 3 KB RForbes to previous
7 26-Nov-2021 10:22 4 KB RForbes to previous | to last
6 26-Nov-2021 10:22 3 KB RForbes to previous | to last
5 26-Nov-2021 10:22 3 KB RForbes to previous | to last
4 26-Nov-2021 10:22 3 KB JAiken to previous | to last
3 26-Nov-2021 10:22 3 KB RForbes to previous | to last
2 26-Nov-2021 10:22 1 KB RForbes to previous | to last
1 26-Nov-2021 10:22 846 bytes RForbes to last

Page References

Incoming links Outgoing links
MICR FORMAT
MICR FORMAT

Version management

Difference between version and

At line 4 changed one line
[MICR FORMAT/MICR.JPG]
[MICR FORMAT/MICR-US.JPG]
At line 6 changed 4 lines
There are three main points of identification:
* The [CHECK_NUMBER] which is also printed higher on the face of the check in a more "human readable" form
* The [BANK_TRANSIT_CODE] which identifies which bank holds the funds to be paid
* The [BANK_ACCOUNT] which identifies the account within the bank from which the funds are taken
There are also special characters which separate the data for the bank's automated systems:
\\ [MICR FORMAT/MICR-ONUS.JPG] ON-US character
\\ [MICR FORMAT/MICR-TRANSIT.JPG] TRANSIT character
\\ [MICR FORMAT/MICR-DASH.JPG] HYPHEN character
At line 11 removed 5 lines
There are also four special characters which separate the data for the bank's automated systems:
* ON-US character [MICR FORMAT/MICR-ONUS.JPG]
* TRANSIT character [MICR FORMAT/MICR-TRANSIT.JPG]
* HYPHEN character [MICR FORMAT/MICR-DASH.JPG]
At line 15 added 3 lines
;Check Number: The check number is printed as shown on [IPDS] for each check
;Bank Transit Code:This nine-digit field is taken straight from the [BANK_TRANSIT_CODE] field on the [IPBL] screen.
;Bank Account Number:This is the payroll account for the company, from which funds are drawn, and is printed as stored (with hyphens as stored)
At line 22 changed one line
||Stored Procedure||Space between
[{Table
At line 22 added 40 lines
||Stored Procedure||Space between Transit\\and Bank Account ||Other Changes
| P2K_SPPGMICR_RCID | 0 spaces |
| P2K_SPPGMICR | 1 space ''*This is the default''|
| P2K_SPGGMICR_HED | 2 spaces |
| P2K_SPPGMCR_SOM | 3 spaces |
| P2K_SPPGMICR_WCO | 5 spaces |
| P2K_SPPGMICR_DUS | 6 spaces |
| P2K_SPPGMICR_CLA | 7 spaces |
| P2K_SPPGMICR_GES_BANK_ONE| 9 spaces |
| P2K_SPPGMICR_COM | 2 spaces | __Bank Account__ is formatted as 99-999999...
| P2K_SPPGMICR_LAC | 4 spaces | __Check Number__ is forced to 10 digits
|^ |^ |__Bank Account__ is formatted as the account (less the last two digits), the ON US symbol, and then the last two digits\\i.e. a bank account stored as 123456789012 would print as __1234567890C12__ where C is the ON US character (above)
}]
!!Canada Standards
Canadian banks format the MICR line differently. The most noticeable difference is that the Bank Transit Code is only eight characters long, comprised of a three digit bank number and a 5 digit "transit" or branch number.
;Check Number: The check number is printed as shown on [IPDS] for each check
;Bank Transit Code:This eight digit field is taken straight from the [BANK_TRANSIT_CODE] field on the [IPBL] screen.
;Bank Account Number:This is the payroll account for the company, from which funds are drawn, and should be stored without hyphens, as this will be formatted by the MICR procedure (unless noted otherwise, below)
The formats are as follows:
Examples assume that the Bank Transit on IBPL is 12345678 and the Bank Account on IPBA is 1234567890. Unless otherwise indicated, there is one space between the bank transit code and the bank account.
[{Table
||Stored Procedure ||Bank Transit Format||Bank Account Format||Other Changes
| P2K_SPPGMICR_CANADA | 12345-678 | 12345-67890 |
| P2K_SPPGMICR_ROYAL | 12345-678 | as entered |
| P2K_SPPGMICR_CANADA_TD | 12345-678 | 1234-567890 |
| P2K_SPPGMICR_RPU | 12345-678 | 12-34567890 |
| P2K_SPPGRMICR_CANADA_GN | 12345-678 | 123-456-7890 | 3 spaces between transit and account
| P2K_SPPGMICR_CANADA_EFX | 45678-123 | 1234-567890 |
| P2K_SPPGMICR_CANADA_AGLC | 56789-234 | as entered | 3 spaces between transit and account
|^ |^ |^ | __Check Number__ is appended with a modulus 9 check digit
}]
This page (revision-8) was last changed on 26-Nov-2021 10:22 by RForbesTop