Employee Bank Account Rules by Country: Oman to Vietnam
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:
-
Oman
-
Pakistan
-
Philippines
-
Poland
-
Qatar
-
Romania
-
Russian Federation
-
Saudi Arabia
-
Singapore
-
Slovakia
-
South Africa
-
Spain
-
Sudan
-
Sweden
-
Switzerland
-
Syrian Arab Republic
-
Turkey
-
Ukraine
-
United Arab Emirates
-
United Kingdom
-
United States
-
Vietnam
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.
Oman
Country Code: OM
|
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 |
Y |
N |
|
|
ACCOUNT_NAME_ALT |
Y |
N |
|
|
SEC_ACCT_REF |
Y |
N |
|
|
BANK_NAME |
Y |
Y |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
Y |
N |
|
|
BRANCH_NUMBER |
Y |
N |
|
|
BIC |
Y |
N |
Pakistan
Country Code: PK
|
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 |
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 |
Philippines
Country Code: PH
|
Attribute Name |
Display Indicator |
Label Code |
Required: Y or N |
|---|---|---|---|
|
ACCOUNT_NUMBER |
Y |
Y |
|
|
IBAN |
Y |
N |
|
|
ACCOUNT_TYPE |
Y |
Y |
|
|
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 |
Poland
Country Code: PL
|
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 |
Y |
Y |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
N |
N |
|
|
BRANCH_NUMBER |
N |
N |
|
|
BIC |
Y |
N |
Portugal
Country Code: PT
|
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 |
Y |
N |
|
|
BANK_CODE |
Y |
Y |
|
|
BRANCH_NAME |
N |
N |
|
|
BRANCH_NUMBER |
Y |
Y |
|
|
BIC |
Y |
N |
Qatar
Country Code:
|
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 |
Y |
N |
|
|
ACCOUNT_NAME_ALT |
Y |
N |
|
|
SEC_ACCT_REF |
Y |
N |
|
|
BANK_NAME |
Y |
Y |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
Y |
N |
|
|
BRANCH_NUMBER |
N |
N |
|
|
BIC |
Y |
N |
Romania
Country Code: RO
|
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 |
Y |
N |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
N |
N |
|
|
BRANCH_NUMBER |
N |
N |
|
|
BIC |
Y |
Y |
Russian Federation
Country Code: RU
|
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 |
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 |
N |
|
|
BIC |
Y |
N |
Saudi Arabia
Country Code: SA
|
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 |
Y |
N |
|
|
BRANCH_NAME |
Y |
N |
|
|
BRANCH_NUMBER |
N |
N |
|
|
BIC |
Y |
N |
Singapore
Country Code: SG
|
Attribute Name |
Display Indicator |
Label Code |
Required: Y or N |
|---|---|---|---|
|
ACCOUNT_NUMBER |
Y |
Y |
|
|
IBAN |
Y |
N |
|
|
ACCOUNT_TYPE |
Y |
N |
|
|
CHECK_DIGIT |
|||
|
ACCOUNT_NAME |
Y |
Y |
|
|
ACCOUNT_NAME_ALT |
N |
N |
|
|
SEC_ACCT_REF |
Y |
N |
|
|
BANK_NAME |
Y |
N |
|
|
BANK_CODE |
Y |
Y |
|
|
BRANCH_NAME |
Y |
N |
|
|
BRANCH_NUMBER |
Y |
Y |
|
|
BIC |
Y |
N |
Slovakia
Country Code: SK
|
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 |
Y |
N |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
N |
N |
|
|
BRANCH_NUMBER |
N |
N |
|
|
BIC |
Y |
Y |
South Africa
Country Code: ZA
|
Attribute Name |
Display Indicator |
Label Code |
Required: Y or N |
|---|---|---|---|
|
ACCOUNT_NUMBER |
Y |
Y |
|
|
IBAN |
Y |
N |
|
|
ACCOUNT_TYPE |
Y |
Y |
|
|
CHECK_DIGIT |
N |
N |
|
|
ACCOUNT_NAME |
Y |
Y |
|
|
ACCOUNT_NAME_ALT |
N |
N |
|
|
SEC_ACCT_REF |
N |
N |
|
|
BANK_NAME |
Y |
N |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
N |
N |
|
|
BRANCH_NUMBER |
Y |
Y |
|
|
BIC |
Y |
N |
Spain
Country Code: ES
|
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 |
Y |
Y |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
N |
N |
|
|
BRANCH_NUMBER |
N |
N |
|
|
BIC |
Y |
N |
Sudan
Country Code: SD
|
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 |
Sweden
Country Code: SE
|
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 |
N |
N |
|
|
BRANCH_NUMBER |
|||
|
BIC |
Y |
N |
Switzerland
Country Code: CH
|
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 |
Y |
N |
|
|
BANK_NAME |
N |
N |
|
|
BANK_CODE |
Y |
N |
|
|
BRANCH_NAME |
N |
N |
|
|
BRANCH_NUMBER |
N |
N |
|
|
BIC |
Y |
N |
Syrian Arab Republic
Country Code: SY
|
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 |
Y |
Turkey
Country Code: TR
|
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 |
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 |
Ukraine
Country Code: UA
|
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 |
Y |
N |
|
|
ACCOUNT_NAME_ALT |
Y |
N |
|
|
SEC_ACCT_REF |
Y |
N |
|
|
BANK_NAME |
Y |
Y |
|
|
BANK_CODE |
Y |
N |
|
|
BRANCH_NAME |
Y |
N |
|
|
BRANCH_NUMBER |
Y |
N |
|
|
BIC |
Y |
N |
United Arab Emirates
Country Code: AE
|
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 |
Y |
N |
|
|
BANK_NAME |
Y |
Y |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
Y |
N |
|
|
BRANCH_NUMBER |
Y |
N |
|
|
BIC |
Y |
N |
United Kingdom
Country Code: GB
|
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 |
Y |
|
|
ACCOUNT_NAME_ALT |
N |
N |
|
|
SEC_ACCT_REF |
Y |
SEC_ACCT_REF_GB |
N |
|
BANK_NAME |
Y |
N |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
Y |
N |
|
|
BRANCH_NUMBER |
Y |
BRANCH_NUM_GB |
Y |
|
BIC |
Y |
N |
United States
Country Code: US
|
Attribute Name |
Display Indicator |
Label Code |
Required: Y or N |
|---|---|---|---|
|
ACCOUNT_NUMBER |
Y |
Y |
|
|
IBAN |
N |
N |
|
|
ACCOUNT_TYPE |
Y |
Y |
|
|
CHECK_DIGIT |
|||
|
ACCOUNT_NAME |
Y |
N |
|
|
ACCOUNT_NAME_ALT |
N |
N |
|
|
SEC_ACCT_REF |
Y |
N |
|
|
BANK_NAME |
Y |
N |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
Y |
N |
|
|
BRANCH_NUMBER |
Y |
ROUTE_NUM |
Y |
|
BIC |
Y |
N |
Vietnam
Country Code: VN
|
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 |
Y |
Y |
|
|
BANK_CODE |
N |
N |
|
|
BRANCH_NAME |
N |
N |
|
|
BRANCH_NUMBER |
N |
N |
|
|
BIC |
N |
N |