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