Employee Bank Account Rules by Country: Argentina to Guernsey
This topic outlines the employee and the Cash Management ad hoc payment bank account UI rules for each country listed in the topic. 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:
-
Argentina
-
Australia
-
Austria
-
Bahrain
-
Belgium
-
Brazil
-
Canada
-
Chile
-
China
-
Colombia
-
Cyprus
-
Czech Republic
-
Denmark
-
Egypt
-
Estonia
-
Finland
-
France
-
Germany
-
Greece
-
Guernsey
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.
If you're setting the CE_USE_EXISTING_BANK_BRANCH profile option as Yes, the bank and branch become required fields. This is irrespective of country UI rules.
Argentina
Country Code: AR
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 |
Y |
ORA_CBU |
N |
BANK_NAME |
Y |
N |
|
BANK_CODE |
Y |
BANK_ID |
Y |
BRANCH_NAME |
Y |
N |
|
BRANCH_NUMBER |
Y |
Y |
|
BIC |
N |
N |
Australia
Country Code: AU
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_ALT |
N |
N |
|
SEC_ACCT_REF |
N |
N |
|
BANK_NAME |
N |
N |
|
BANK_CODE |
N |
N |
|
BRANCH_NAME |
N |
N |
|
BRANCH_NUMBER |
Y |
BRANCH_NUM_AU |
Y |
BIC |
N |
N |
Austria
Country Code: AT
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 |
N |
|
BANK_CODE |
N |
N |
|
BRANCH_NAME |
N |
N |
|
BRANCH_NUMBER |
N |
N |
|
BIC |
Y |
N |
Bahrain
Country Code: BH
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
Belgium
Country Code: BE
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
Y |
N |
Brazil
Country Code: BR
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
COMPANY_CODE |
N |
BANK_NAME |
Y |
Y |
|
BANK_CODE |
Y |
Y |
|
BRANCH_NAME |
Y |
N |
|
BRANCH_NUMBER |
Y |
Y |
|
BIC |
Y |
N |
Canada
Country Code: CA
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
ACCOUNT_NUMBER |
Y |
Y |
|
IBAN |
N |
N |
|
ACCOUNT_TYPE |
N |
N |
|
CHECK_DIGIT |
N |
N |
|
BANK_CODE |
Y |
BANK_NUM_CA |
Y |
BRANCH_NUMBER |
Y |
ROUTE_NUM_CA |
Y |
Chile
Country Code: CL
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
ACCOUNT_NUMBER |
Y |
Y |
|
IBAN |
N |
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 |
Y |
|
BANK_CODE |
N |
N |
|
BRANCH_NAME |
N |
N |
|
BRANCH_NUMBER |
N |
N |
|
BIC |
N |
N |
China
Country Code: CN
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
Y |
Y |
|
BRANCH_NUMBER |
N |
N |
|
BIC |
N |
N |
Colombia
Country Code: CO
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
ACCOUNT_NUMBER |
Y |
Y |
|
IBAN |
N |
N |
|
ACCOUNT_TYPE |
Y |
Y |
|
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 |
Y |
Y |
|
BRANCH_NUMBER |
N |
N |
|
BIC |
N |
N |
Cyprus
Country Code: CY
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
Czech Republic
Country Code: CZ
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
Denmark
Country Code: DK
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
Y |
Y |
|
BRANCH_NAME |
N |
N |
|
BRANCH_NUMBER |
N |
N |
|
BIC |
Y |
N |
Egypt
Country Code: EG
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
Y |
Y |
Estonia
Country Code: EE
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
Finland
Country Code: FI
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
France
Country Code: FR
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
ACCOUNT_NUMBER |
Y |
Y |
|
IBAN |
Y |
Y |
|
ACCOUNT_TYPE |
Y |
ACCOUNT_TYPE_FR |
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 |
Germany
Country Code: DE
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
N |
Greece
Country Code: GR
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |
Guernsey
Country Code: GG
Attribute Name |
Display Indicator |
Label Code |
Required: Yes or No |
---|---|---|---|
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 |