Wiki: IPBA

Bank Accounts contain information pertaining to the actual bank account from which funds will be drawn when issuing payroll checks or direct deposits. The Define Bank Accounts (IPBA) screen provides information about the employer’s banking information. You may access this feature under the Screen/Form menu: Payroll > Setup and Definitions > Define Bank Accounts Each payroll must be assigned a payroll bank account. Define Bank Account data is stored in the P2K_PR_PAYROLL_BANK_ACCOUNTS table.

Bank#

Entity: This field identifies the entity for which the bank account is being specified. Entity_Code from P2K_CM_ENTITIES is a mandatory 16-character alphanumeric field that you may manually enter or use the LOV (F9) to choose an option.

Bank Number: This number identifies the bank and branch. For Canadian Installations: The transit number is in the format of ddddddddd where the first 4 digits identify the bank transit while the last 5 digits identify the branch transit. Bank_Transit_Code from P2K_PR_BANK_LOCATIONS is a mandatory 16-character alphanumeric field that you must fill either manually or with a selection from the LOV (F9) provided.

Bank Name: This field displays the full name of the bank.Bank_Name from P2K_PR_BANK_LOCATIONS is a mandatory 50-character alphanumeric field that will default from the transit number chosen.

Country: This field identifies the country of origin for the bank. Country_Code from P2K_CM_COUNTRIES is a mandatory 16-character alphanumeric field that will default from the transit number chosen.

Account: This field displays the bank account for which the funds are withdrawn from. This information is provided by the bank. Bank_Account is a mandatory 30-character alphanumeric field that you must manually enter.

Currency: Currency is the actual currency in which the funds are transferred. Currency is an optional fixed lexicon (X_CURRENCY) that you may use to look up the value.

GL Accounts#

Cash,Checks,Deposits: G/L codes are entered for each of these payment accounts. These codes are defined through the Maintain G/L Accounts (IDGA) form.

Pre-Notification Days: For U.S. Installations Only: the ‘Pre-Noting Days’ field indicates the amount of lead-time

(in days) that a bank requires before actual deposits may be processed by the bank.The time begins from the pay issue date of the payrun. Prenote_Days is an optional 5 digit number field.

Starting Number: This is the number of the first check in the series. Starting_Number is a mandatory 10 digit numeric field that you must manually enter.

Ending Number: This is the number of the last check in the series. Ending_Number is a mandatory 10 digit numeric field that you must manually enter.

Last Used: This field is initially entered by user and provides the last check number used. The next

check to be printed will have the next sequential number. (e.g., If the number displayed in this field is 305648, the next check will be numbered 305649.)Each time the Disburse Pays (UPDISB) process is run, this number will be updated. Last_Number_Used is a mandatory 10 digit numeric field that you must manually enter.

Manual: If this toggle is set to ON, this range of check numbers are set aside to be used on manually produced checks. If the Manual toggle is OFF, the range of check numbers are not to be used for manually produced checks. Manual_Range is an optional toggle field.

Restricted: If this toggle is set to ON, the range of the check numbers may be used only for the current

entity. If this toggle is set to OFF, the check range may be used by any entity using this account. Restricted_Range is an optional toggle field.