Employee Bank Account Rules by Country: Hong Kong to Norway

This topic outlines the employee and the Cash Management ad hoc payment bank account UI rules for each country. The fields displayed on the user interface are governed by the rules defined in the table CE_CTRY_SPECIFIC_UI_RULES.

We've a REST service to update these rules.

These countries have specific rules:

  • Hong Kong

  • Hungary

  • India

  • Iraq

  • Ireland

  • Isle of Man

  • Israel

  • Italy

  • Japan

  • Jersey

  • Jordan

  • Kazakhstan

  • Republic of Korea

  • Kuwait

  • Latvia

  • Lebanon

  • Liechtenstein

  • Lithuania

  • Luxembourg

  • Malaysia

  • Mexico

  • Morocco

  • Netherlands

  • New Zealand

  • Norway

Different countries can have certain rules governing the content and required attributes. These rules govern the fields on the employee and cash management ad hoc payments. Here’s is a list of delivered attributes that might or might not be required depending on the country when setting up these accounts:

Standard UI Name

Attribute Name (Table Name)

Account Number

ACCOUNT_NUMBER

IBAN

IBAN

Account Type

ACCOUNT_TYPE

Check Digit

CHECK_DIGIT

Account Holder

ACCOUNT_NAME

Alternate Account Holder

ACCOUNT_NAME_ALT

Secondary Account Reference

SEC_ACCT_REF

Bank

BANK_NAME

Bank Code

BANK_CODE

Bank Branch

BRANCH_NAME

Branch Number

BRANCH_NUMBER

BIC Code

BIC

The following tables list the country specific UI rules that had been predefined for employee bank account common component. For predefined records, the predefined indicator will be Y and the page name will be ORA.

Any country or attribute, except the ACCOUNT_NUMBER and the ACCOUNT_SUFFIX attribute not listed has the following default setting:

  • Display Indicator = Y

  • Required Indicator = N

The ACCOUNT_NUMBER default has the following setting:

  • Display Indicator = Y

  • Required Indicator = Y

The ACCOUNT_SUFFIX default has the following setting:

  • Display Indicator = N

  • Required Indicator = N

Note:
  • The LABEL_CODE is derived from the lookup_type CE_ACCOUNT_FIELDS, for countries that are prompted for that information.
  • Any field (other than account number and account suffix) that doesn’t have any predefined rules will have the default behavior of Display Indicator as Y and Required option as N.
  • Bank account field values are validated as per the Cash Management application. If you don’t want to validate the data, you must select the profile option CE_DISABLE_BANK_VAL as Yes.
  • While creating a bank account, you can select the bank and branch from a predefined set of values or you can create them at runtime. To select the bank and branch from the predefined values, you must select the profile option CE_USE_EXISTING_BANK_BRANCH as Yes.
  • In the UI, you can select a check box to search for a bank using a unique bank branch identifier, such as routing number. This feature is available only when you set the profile option CE_DISABLE_BANK_VAL as Yes. For countries where the bank branch number is displayed and required, the check box is selected and the search is done using the bank branch identifier by default. For all other countries, the search is based on the bank and branch.
Note:

If you're setting the CE_USE_EXISTING_BANK_BRANCH profile option as Yes, the bank and branch become required field. This is irrespective of country UI rules.

Hong Kong.

Country Code: HK

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

N

ACCOUNT_TYPE

N

N

CHECK_DIGIT

ACCOUNT_NAME

Y

Y

ACCOUNT_NAME_ALT

Y

Y

SEC_ACCT_REF

Y

N

BANK_NAME

Y

N

BANK_CODE

Y

Y

BRANCH_NAME

Y

N

BRANCH_NUMBER

Y

Y

BIC

Y

N

Hungary

Country Code: HU

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

N

ACCOUNT_TYPE

N

N

CHECK_DIGIT

Y

N

ACCOUNT_NAME

N

N

ACCOUNT_NAME_ALT

Y

N

SEC_ACCT_REF

Y

N

BANK_NAME

Y

Y

BANK_CODE

N

N

BRANCH_NAME

N

N

BRANCH_NUMBER

N

N

BIC

Y

N

India

Country Code: IN

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

N

ACCOUNT_TYPE

Y

Y

CHECK_DIGIT

ACCOUNT_NAME

Y

Y

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

Y

BANK_CODE

Y

N

BRANCH_NAME

Y

Y

BRANCH_NUMBER

Y

ORA_IFSC_CODE

N

BIC

Y

N

Iraq

Country Code: IQ

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

N

N

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

Y

BANK_CODE

N

N

BRANCH_NAME

Y

N

BRANCH_NUMBER

N

N

BIC

Y

N

Ireland

Country Code: IE

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

Y

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

N

N

BANK_CODE

N

N

BRANCH_NAME

N

N

BRANCH_NUMBER

N

N

BIC

Y

N

Isle of Man

Country Code: IM

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

N

ACCOUNT_TYPE

Y

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

Y

ACCOUNT_NAME_ALT

Y

N

SEC_ACCT_REF

Y

N

BANK_NAME

Y

N

BANK_CODE

Y

N

BRANCH_NAME

Y

N

BRANCH_NUMBER

Y

BRANCH_NUM_GB

Y

BIC

Y

N

Israel

Country Code: IL

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

N

N

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

N

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

N

BANK_CODE

Y

Y

BRANCH_NAME

Y

N

BRANCH_NUMBER

Y

N

BIC

Y

N

Italy

Country Code: IT

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

Y

Y

CHECK_DIGIT

N

N

ACCOUNT_NAME

N

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

N

N

BANK_CODE

N

N

BRANCH_NAME

N

N

BRANCH_NUMBER

N

N

BIC

Y

N

Japan

Country Code: JP

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

N

ACCOUNT_TYPE

Y

ACCOUNT_TYPE_FR

Y

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

Y

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

Y

N

BANK_NAME

Y

Y

BANK_CODE

Y

Y

BRANCH_NAME

Y

Y

BRANCH_NUMBER

Y

Y

BIC

Y

N

Jersey

Country Code: JE

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

N

ACCOUNT_TYPE

Y

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

Y

ACCOUNT_NAME_ALT

Y

N

SEC_ACCT_REF

Y

N

BANK_NAME

Y

N

BANK_CODE

Y

N

BRANCH_NAME

Y

N

BRANCH_NUMBER

Y

BRANCH_NUM_GB

Y

BIC

Y

N

Jordan

Country Code: JO

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

Y

BANK_CODE

N

N

BRANCH_NAME

Y

N

BRANCH_NUMBER

N

N

BIC

N

N

Kazakhstan

Country Code: KZ

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

N

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

N

N

BANK_CODE

N

N

BRANCH_NAME

N

N

BRANCH_NUMBER

N

N

BIC

Y

Y

Republic of Korea

Country Code: KR

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

N

ACCOUNT_TYPE

Y

N

CHECK_DIGIT

Y

N

ACCOUNT_NAME

Y

N

ACCOUNT_NAME_ALT

Y

N

SEC_ACCT_REF

Y

N

BANK_NAME

Y

Y

BANK_CODE

Y

Y

BRANCH_NAME

Y

N

BRANCH_NUMBER

Y

N

BIC

Y

N

Kuwait

Country Code: KW

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

Y

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

Y

BANK_CODE

N

N

BRANCH_NAME

Y

N

BRANCH_NUMBER

N

N

BIC

Y

N

Latvia

Country Code: LV

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

Y

N

ACCOUNT_NAME

N

N

ACCOUNT_NAME_ALT

Y

N

SEC_ACCT_REF

Y

N

BANK_NAME

N

N

BANK_CODE

N

N

BRANCH_NAME

N

N

BRANCH_NUMBER

N

N

BIC

N

N

Lebanon

Country Code: LB

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

Y

BANK_CODE

N

N

BRANCH_NAME

Y

N

BRANCH_NUMBER

N

N

BIC

N

N

Liechtenstein

Country Code: LI

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

N

BANK_CODE

N

N

BRANCH_NAME

N

N

BRANCH_NUMBER

N

N

BIC

Y

N

Lithuania

Country Code: LT

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

Y

N

ACCOUNT_NAME

N

N

ACCOUNT_NAME_ALT

Y

N

SEC_ACCT_REF

Y

N

BANK_NAME

N

N

BANK_CODE

N

N

BRANCH_NAME

N

N

BRANCH_NUMBER

N

N

BIC

N

N

Luxembourg

Country Code: LU

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

N

BANK_CODE

N

N

BRANCH_NAME

N

N

BRANCH_NUMBER

N

N

BIC

Y

Y

Malaysia

Country Code: MY

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

N

ACCOUNT_TYPE

Y

N

CHECK_DIGIT

Y

N

ACCOUNT_NAME

Y

Y

ACCOUNT_NAME_ALT

Y

N

SEC_ACCT_REF

Y

N

BANK_NAME

Y

Y

BANK_CODE

Y

N

BRANCH_NAME

Y

Y

BRANCH_NUMBER

Y

N

BIC

Y

N

Mexico

Country Code: MX

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

IBAN

ACCOUNT_TYPE

CHECK_DIGIT

ACCOUNT_NAME

ACCOUNT_NAME_ALT

SEC_ACCT_REF

Y

ORA_CLABE

N

BANK_NAME

BANK_CODE

BRANCH_NAME

BRANCH_NUMBER

BIC

Morocco

Country Code: MA

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

N

N

ACCOUNT_TYPE

Y

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

Y

BANK_CODE

N

N

BRANCH_NAME

Y

N

BRANCH_NUMBER

N

N

BIC

Y

N

Netherlands

Country Code: NL

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

Y

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

N

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

Y

N

BANK_NAME

N

N

BANK_CODE

N

N

BRANCH_NAME

N

N

BRANCH_NUMBER

N

N

BIC

Y

N

New Zealand

Country Code: NZ

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

N

N

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

Y

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

N

N

BANK_CODE

Y

BANK_ID

Y

BRANCH_NAME

Y

N

BRANCH_NUMBER

Y

Y

BIC

N

N

Norway

Country Code: NO

Attribute Name

Display Indicator

Label Code

Required: Y or N

ACCOUNT_NUMBER

Y

Y

IBAN

Y

N

ACCOUNT_TYPE

N

N

CHECK_DIGIT

N

N

ACCOUNT_NAME

Y

N

ACCOUNT_NAME_ALT

N

N

SEC_ACCT_REF

N

N

BANK_NAME

Y

N

BANK_CODE

N

N

BRANCH_NAME

Y

N

BRANCH_NUMBER

Y

N

BIC

Y

N