Previous Next JavaScript must be enabled to correctly display this content

## 1.3 Branch Setup File Upload

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

File Type Supported - CSV

File Naming Convention - LMBranchParams_<UniqueName>.csv

Note:

Replace the <UniqueName> for each file upload.

Note:

The fields marked as Required are mandatory.

Table 1-4 Branch 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 | Bank Code* | String | 4 | Code of the Bank
4 | BIC Code* | String | 15 | Denotes the BIC Code of the Branch
5 | Branch Code* | String | 4 | Code of the Branch
6 | Branch Currency* | String | 3 | Denotes Branch Local Currency
7 | Branch Name* | String | 50 | Name of the branch
8 | City Id* | String | 50 | Specifies the City Id
9 | Country Id* | String | 10 | Denotes the Country Id
10 | Cross Border Hybrid Pool* | String | 1 | Denotes accounts from the branch are allowed as Cross Border pool accounts in hybrid structures
11 | Cross Border Hybrid Sweep* | String | 1 | Denotes accounts from the branch are allowed as Cross Border sweep accounts in hybrid structures
12 | Cross Border Pool* | String | 1 | Indicates accounts from the branch are allowed to participate in Cross Border pool structures
13 | Cross Border Sweep* | String | 1 | Indicates accounts from the branch are allowed to participate in Cross Border sweep structures
14 | Cross Ccy Hybrid Pool* | String | 1 | Denotes accounts from the branch are allowed as Cross Currency pool accounts in hybrid structures
15 | Cross Ccy Hybrid Sweep* | String | 1 | Denotes accounts from the branch are allowed as Cross Currency sweep accounts in hybrid structures
16 | Cross Ccy Pool* | String | 1 | Indicates accounts from the branch are allowed to participate in Cross Currency pool structures
17 | Cross Ccy Sweep* | String | 1 | Indicates accounts from the branch are allowed to participate in Cross Currency sweep structures
18 | Domestic Hybrid Pool* | String | 1 | Denotes accounts from the branch are allowed as Domestic pool accounts in hybrid structures
19 | Domestic Hybrid Sweep* | String | 1 | Denotes accounts from the branch are allowed as Domestic sweep accounts in hybrid structures
20 | Domestic Pool* | String | 1 | Indicates accounts from the branch are allowed to participate in Domestic pool structures
21 | Domestic Sweep* | String | 1 | Indicates accounts from the branch are allowed to participate in Domestic sweep structures
22 | Entity ID* | String | 50 | Specifies the Entity ID for branch
23 | Entity Name* | String | 105 | Specifies the Entity name for branch
24 | External System Id* | String | 35 | Denotes the External System ID of the Branch
25 | Fax | String | 20 | Specifies the Fax details
26 | Hybrid* | String | 1 | Allow accounts of the branch in Hybrid (Combination of Sweep and Pool) structures
27 | Is Balance Online* | String | 1 | Denotes the Balance build method as online or offline
28 | Latitude | Number | 15 | Specifies the Latitude details
29 | Line 1* | String | 100 | Denotes the branch address details - Address Line 1
30 | Line 2 | String | 100 | Denotes the branch address details - Address Line 2
31 | Line 3 | String | 100 | Denotes the branch address details - Address Line 3
32 | Line 4 | String | 100 | Denotes the branch address details - Address Line 4
33 | Longitude | Number | 15 | Specifies the Longitude details
34 | Phone Number | String | 13 | Specifies the Phone Number
35 | Pool* | String | 1 | Allow accounts of the branch in pool structures
36 | Region* | String | 100 | Specifies the region of the Branch
37 | Source System* | String | 35 | Source System
38 | Source System Branch Code | String | 4 | Branch Code of the Source System
39 | State Id | String | 10 | Specifies the State Id
40 | Sweep* | String | 1 | Allow accounts of the branch in sweep structures
41 | Time Zone* | String | 30 | Specifies the Time Zone details
42 | Branch Date* | String | 30 | Indicates the Branch Date
43 | Local Clearing Code | String | 50 | Specifies the local clearing code for the branch
44 | Is External* | String | 1 | Indicates whether the branch is External or not
45 | Bank Type | String | 10 | Denotes the Bank Type
46 | Zip | String | 10 | Indicates the Zip Code
47 | Host Code* | String | 8 | Host Code
48 | Balance Update Offset* | Number | 38 | Defines the balance offset beyond which the balances are considered stale for offline balance fetch
49 | Is Mt 942 | String | 1 | Indicates whether the branch sends MT942 messages or not
50 | Mt 942 Msg Type | String | 11 | Denotes the MT942 message type
51 | Rate Type | String | 8 | Specify the Rate Type
52 | Rate Code | String | 1 | Specify the Rate Code

Table 1-5 Branch Setup File Upload - Child Record 1

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

Table 1-6 Branch Setup File Upload - Child Record 2

Sequence | Attribute name | Type | Size | Description
--- | --- | --- | --- | ---
1 | Discriminator* | String | 15 | Denotes the second child record type. Default value is always “ExternalSystem”
2 | External System Id* | String | 36 | Denotes the External System Id for the branch
3 | Message Type* | String | 20 | Specifies the Message type for the selected external system Id
4 | Method Name* | String | 100 | Indicates the Method Name for the selected external system Id
5 | Network Type* | String | 50 | Specifies the Network type for the selected external system Id
6 | Service Type* | String | 30 | Denotes the Service type for the selected external system Id

Parent topic: File Upload