Previous Next JavaScript must be enabled to correctly display this content

## 1.2 Bank Setup File Upload

This topics describes the information to perform the bulk upload for the bank setup in Oracle Banking Liquidity Management.

File Type Supported - CSV

File Naming Convention - LMBankParams_<UniqueName>.csv

Note:

Replace the <UniqueName> for each file upload.

Note:

The fields marked as Required are mandatory.

Table 1-2 Bank Setup File Upload - Master Records

Sequence | Attribute name | Type | Size | Description
--- | --- | --- | --- | ---
1 | Discriminator* | String | 1 | Denotes master record type. Default value is always “P”
2 | Action* | String | 10 | Denotes file operation type. Allowed values are new/modify
3 | Cross Border Sweep* | String | 1 | Indicates the bank allows Cross Border accounts in sweep structures
4 | Cross Border Pool* | String | 1 | Denotes the bank allows Cross Border accounts in pool structures
5 | Cross Border Hybrid Sweep* | String | 1 | Indicates the bank allows Cross Border sweep accounts in hybrid structures
6 | Cross Border Hybrid Pool* | String | 1 | Denotes the bank allows Cross Border pool accounts in hybrid structures
7 | Cross Ccy Sweep* | String | 1 | Indicates the bank allows Cross Currency accounts in sweep structures
8 | Cross Ccy Pool* | String | 1 | Denotes the bank allows Cross Currency accounts in pool structures
9 | Cross Ccy Hybrid Sweep* | String | 1 | Indicates the bank allows Cross Currency sweep accounts in hybrid structures
10 | Cross Ccy Hybrid Pool* | String | 1 | Indicates the bank allows Cross Currency pool accounts in hybrid structures
11 | Source System* | String | 35 | Specifies the source of maintenance
12 | Source System Bank Code | String | 4 | Denotes the Source System Bank Code
13 | Bank Code* | String | 4 | Specifies the Bank Code
14 | Bank Description* | String | 200 | Indicates the description of the Bank
15 | Bank Short Name | String | 30 | Denotes Short Name of the Bank
16 | Bank Type* | String | 10 | This will always default to Internal. External banks are created from Third Party Maintenance screens
17 | Line1 | String | 100 | Indicates the bank address details - Address Line 1
18 | Line2 | String | 100 | Indicates the bank address details - Address Line 2
19 | Line3 | String | 100 | Indicates the bank address details - Address Line 3
20 | Line4 | String | 100 | Indicates the bank address details - Address Line 4
21 | Country Id | String | 10 | Denotes the Country Id
22 | State Id | String | 10 | Specifies the State Id
23 | City Id | String | 10 | Specifies the City Id
24 | Zip | String | 10 | Indicates the Zip Code
25 | Phone Number | String | 13 | Specifies the Phone Number
26 | Fax | String | 20 | Specifies the Fax details
27 | Is Mbcc Allowed* | String | 1 | Multi Bank Cash Concentration - Indicates the host bank supports MBCC
28 | Is Bvt Allowed* | String | 1 | Indicates banks allow BVT
29 | Sweep* | String | 1 | Indicates the sweep structures are allowed in the Bank
30 | Pool* | String | 1 | Denotes the pool structures are allowed in the Bank
31 | Hybrid* | String | 1 | Indicates the Hybrid (Combination of Sweep and Pool) structures are allowed in the Bank
32 | Domestic Sweep* | String | 1 | Indicates the bank allows Domestic accounts to participate in sweep structures
33 | Domestic Pool* | String | 1 | Denotes the bank allows Domestic accounts in pool structures
34 | Domestic Hybrid Sweep* | String | 1 | Denotes the bank allows Domestic sweep accounts in hybrid structures
35 | Domestic Hybrid Pool* | String | 1 | Indicates the bank allows Domestic pool accounts in hybrid structures
36 | Ext Acc Sweep Basis | String | 15 | Denotes the External Account Sweep Basis
37 | If Avl Bal Ext Acc Not Avl | String | 15 | Indicates the Available Balance Tag Absense Handling
38 | Charge Calc Pref* | String | 1 | Specifies the Charge Calculation Preference
39 | Charge Col Pref* | String | 1 | Specifies the Charge Collection Preference
40 | Chg Include Closed Va* | String | 1 | Change include when closed

Table 1-3 Bank Setup File Upload - Child Records

Sequence | Attribute name | Type | Size | Description
--- | --- | --- | --- | ---
1 | Discriminator* | String | 1 | Denotes child record type. Default value is always “C”
2 | Parameter Name* | String | 50 | Indicates the Parameter Name
3 | Parameter Value* | String | 300 | Indicates the Parameter Value

Parent topic: File Upload