Previous Next JavaScript must be enabled to correctly display this content

## 3 File Upload

This topic provides the information on the various File Upload features supported by Oracle Banking Virtual Account Management.

The user can perform the following actions:

- New – Creation of new records
- Modify – Modification of existing records
- Close – Closure of existing records

File Naming Convention: feedname_xxx

For example: virtualentity_27april2020

File Format: .csv

The processing status of the records in the file can be enquired through View File Upload Status screen.

Note:

Refer to Oracle Banking Microservices Plarform Foundation User Guide for the detailed explanation.

Oracle Banking Virtual Account Management provides a facility for bulk upload of the below features.

- Virtual Entity
- Virtual Account
- Account Structure
- Remittance Details
- Journal Posting
- Journal Posting Reversal

### 3.1 Virtual Entity

Virtual Entity File Upload is used for the bulk creation, modification and closure of Virtual Entities.

Feed Name: virtualentity

The following table describes the details of file structure.

Table 3-1 Virtual Entity - File Structure

Sequence Number | Field Name | Description | Data Type | Field Length | Modifiable (NA/Y/N)
--- | --- | --- | --- | --- | ---
1 | Action | Specifies the operation to be performed. Allowed operations are as following: New: Creation of Virtual Entities Modify: Modification of existing Virtual Entities Close: Closure of existing Virtual Entities | VARCHAR2 | - | NA
2 | Operation | Specifies the operation to be performed. Allowed operations are as following: E - Action specific to only Entities ES – Action applicable for both Entities and Statement Preferences | VARCHAR2 | - | NA
3 | Last KYC Date | Specifies the last KYC date. | DATE Format: YYYY-MM-DD | - | Y
4 | KYC Reference | Specifies the KYC Reference Number. | VARCHAR2 | 100 | Y
5 | KYC Status | Specifies the KYC Status of the entity. Available values are as following: P - Pending V - Verified E - Expired | CHAR | 1 | Y
6 | Tax Identification Number | Specifies the Tax Identification Number. | VARCHAR2 | 100 | Y
7 | Identification Number | Specifies the Identification Number. | VARCHAR2 | 100 | Y
8 | Identification Type | Specifies the Identification Type. Valid values are as following: N - National ID P- Passport S - SSN The values can be updated at bank level as a part of Day 0 setup. | CHAR | 1 | Y
9 | Registered Address Pincode | Specifies the Pincode of Registered Address. | VARCHAR2 | 15 | Y
10 | Registered Address Country | Specifies the Registered Address Country. | VARCHAR2 | 15 | Y
11 | Registered Address Line 1 | Specifies the Registered Address Line 1. | VARCHAR2 | 105 | Y
12 | Registered Address Line 2 | Specifies the Registered Address Line 2. | VARCHAR2 | 105 | Y
13 | Registered Address Line 3 | Specifies the Registered Address Line 3. | VARCHAR2 | 105 | Y
14 | Registered Address Line 4 | Specifies the Registered Address Line 4. | VARCHAR2 | 105 | Y
15 | Correspondence Address Pincode | Specifies the Pincode of Correspondence Address. | VARCHAR2 | 15 | Y
16 | Correspondence Address Country | Specifies the Correspondence Address Country. | VARCHAR2 | 3 | Y
17 | Correspondence Address Line 1 | Specifies the Correspondence Address Line 1. | VARCHAR2 | 105 | Y
18 | Correspondence Address Line 2 | Specifies the Correspondence Address Line 2. | VARCHAR2 | 105 | Y
19 | Correspondence Address Line 3 | Specifies the Correspondence Address Line 3. | VARCHAR2 | 105 | Y
20 | Correspondence Address Line 4 | Specifies the Correspondence Address Line 4. | VARCHAR2 | 105 | Y
21 | Entity Type | Specifies the Entity Type. Valid values are as following: C - Corporate I - Individual | CHAR | 1 | N
22 | Virtual Entity Name | Specifies the Virtual Entity Name. | VARCHAR2 | 105 | Y
23 | Virtual Entity ID | Specifies the Virtual Entity Identification. | VARCHAR2 | 12 | N
24 | Real Customer Number | Specifies the Real Customer Number for virtual entity creation. | VARCHAR2 | 20 | N
25 | Doer Remarks | Specifies the Requester Remarks. | VARCHAR2 | 200 | Y
26 | Approver Remarks | Specifies the Approver Remarks. | VARCHAR2 | 200 | Y
27 | Individual Preferred Mode | Specifies the Individual Preferred mode of communication. Applicable for Entity Type as “I”. Valid values are as following: E - Email M - Mobile | CHAR | 1 | Y
28 | Individual Email | Specifies the Email Details. Applicable for Entity Type as “I" and individualDetails_preferredMode as “E”. | VARCHAR2 | 255 | Y
29 | Individual Work Phone Number | Specifies the Work Phone Number. Applicable for Entity Type as “I”. | VARCHAR2 | 10 | Y
30 | Individual Work Phone ISD | Specifies the International Subscriber Dialing code for Work Phone Number. Applicable for Entity Type as “I”. | NUMBER | 4 | Y
31 | Individual Home Phone Number | Specifies the Home Phone Number. Applicable for Entity Type as “I”. | VARCHAR2 | 10 | Y
32 | Individual Home Phone ISD | Specifies the International Subscriber Dialing code for Home Phone Number. Applicable for Entity Type as “I”. | NUMBER | 4 | Y
33 | Individual Mobile Number ISD | Specifies the International Subscriber Dialing code for Mobile Number. Applicable for Entity Type as “I" and individualDetails_preferredMode as “M”. | NUMBER | 4 | Y
34 | Individual Mobile Number | Specifies the Mobile Phone Number. Applicable for Entity Type as “I" and individualDetails_preferredMode as “M”. | VARCHAR2 | 10 | Y
35 | Individual National ID | Specifies the National Identification of Individual. Applicable for Entity Type as “I”. | VARCHAR2 | 35 | Y
36 | Individual Nationality | Specifies the Nationality of Individual. Applicable for Entity Type as “I”. | VARCHAR2 | 3 | Y
37 | Individual Gender | Specifies the Gender. Applicable for Entity Type as “I”. Valid values are as following: M – Male F – Female O – Others | CHAR | 1 | Y
38 | Individual Date Of Birth | Specifies the Date of Birth of Individual. Applicable for Entity Type as “I”. | DATE Format: YYYY-MM-DD | - | Y
39 | Individual Last Name | Specifies the Individual Last Name. Applicable for Entity Type as “I”. | VARCHAR2 | 105 | Y
40 | Individual Middle Name | Specifies the Individual Middle Name. Applicable for Entity Type as “I”. | VARCHAR2 | 105 | Y
41 | Individual First Name | Specifies the Individual First Name. Applicable for Entity Type as “I”. | VARCHAR2 | 105 | Y
42 | Corporate Date Of Incorporation | Specifies the Date of Incorporation of the Corporate. Applicable for Entity Type as “C”. | DATE Format: YYYY-MM-DD | - | Y
43 | Corporate Country Of Incorporation | Specifies the Country of Incorporation of the Corporate. Applicable for Entity Type as “C”. | VARCHAR2 | 105 | Y
44 | Corporate Unique Id | Specifies the Unique ID of the Corporate. Applicable for Entity Type as “C”. | VARCHAR2 | 35 | Y
45 | Corporate Work Phone 1 ISD | Specifies the International Subscriber Dialing code for Work Phone Number1. Applicable for Entity Type as “C”. | VARCHAR2 | 10 | Y
46 | Corporate Work Phone No 1 | Specifies the Work Phone Number 1. Applicable for Entity Type as “C”. | VARCHAR2 | 10 | Y
47 | Corporate Work Phone 2 ISD | Specifies the International Subscriber Dialing code for Work Phone Number 2. Applicable for Entity Type as “C”. | VARCHAR2 | 10 | Y
48 | Corporate Work Phone No 2 | Specifies the Work Phone Number 2. Applicable for Entity Type as “C”. | VARCHAR2 | 10 | Y
49 | Corporate Mobile No ISD | Specifies the International Subscriber Dialing code for Mobile Number. Applicable for Entity Type as “C" and individualDetails_preferredMode as “M”. | VARCHAR | 10 | Y
50 | Corporate Mobile No | Specifies the Corporate Mobile Number. Applicable for Entity Type as “C" and individualDetails_preferredMode as “M”. | VARCHAR | 10 | Y
51 | Corporate Email | Specifies the Corporate Email Details. Applicable for Entity Type as “C" and individualDetails_preferredMode as “E”. | VARCHAR | 255 | Y
52 | Corporate Preferred Mode | Specifies the Corporate Preferred mode of communication. Applicable for Entity Type as “C”. Valid values are as following: E - Email M - Mobile | CHAR | 1 | Y
53 | Corporate Entity Type | Specifies the Corporate Entity Type. Applicable for Entity Type as “C”. Valid values are as following: C - Corporation P - Partnership S - Sole Partnership O - Cooperative The values can be updated at bank level as a part of Day 0 setup. | CHAR | 1 | Y
54 | Generate PDF Statements | Indicates if PDF statement is required. Valid values are as following: Y – Yes N – No | VARCHAR2 | 1 | Y
55 | Statement Type | Specifies the PDF Statement Type. Valid values are as following: C - Consolidated A - Account Level | CHAR | 1 | Y
56 | Frequency | Specifies the Statement Generation Frequency. Valid values are as following: D – Daily W – Weekly M – Monthly Q – Quarterly Y – Yearly | CHAR | 1 | Y
57 | Due On | Specifies the Statement Generation Day. Applicable for the following Frequency types: D W M Q Y | NUMBER | - | Y
58 | Generate MT 940 | Indicates if MT940 is required. Valid values are as following: Y – Yes N – No | VARCHAR2 | 1 | Y
59 | Generate MT 950 | Indicates if MT950 is required. Valid values are as following: Y – Yes N – No | VARCHAR2 | 1 | Y
60 | Generate MT 942 | Indicates if MT942 is required. Valid values are as following: Y – Yes N – No | VARCHAR2 | 1 | Y
61 | Display IBAN | Indicates if IBAN is to be displayed. Valid values are as following: Y – Yes N – No | VARCHAR2 | 1 | Y
62 | Generate MT942 On Movement | Indicates when to generate to MT942. Applicable if Generate MT 942 is set as Y. Valid values are as following: Y – Yes N – No | VARCHAR2 | 1 | Y (conditional based on Generate MT 942 value)
63 | MT 942 Report Transaction Since | Applicable if Generate MT 942 is set as Y. Valid values are as following: 940 950 942 | VARCHAR2 | 4 | Y (conditional based on Generate MT 942 value)
64 | MT 942 Generation Time | Specifies the Generation Time of MT 942 Report. Multiple times can be configured using pipe separator with hourly interval. | VARCHAR2 | - | Y (conditional based on Generate MT 942 value)
65 | Generate CAMT 053 | Indicates if CAMT.053 is required. Valid values are as following: Y – Yes N – No | VARCHAR2 | 1 | Y
66 | Generate CAMT 052 | Indicates if CAMT.052 is required. Valid values are as following: Y – Yes N – No | VARCHAR2 | 1 | Y
67 | Generate CAMT 052 On Movement | Indicates if Generate CAMT.052 is required. Valid values are as following: Y – Yes N – No | VARCHAR2 | 1 | Y (conditional based on Generate CAMT 052 value)
68 | CAMT 052 Report Transaction Since | Applicable if Generate CAMT 052 is set as Y. Valid values are as following: 052 053 | VARCHAR2 | 4 | Y (conditional based on Generate CAMT 052 value)
69 | CAMT 052 Generation Time | Specifies the Generation Time of CAMT.052 Report. Multiple times can be configured using pipe separator with hourly interval. | VARCHAR2 | - | Y (conditional based on Generate CAMT 052 value)
70 | Structured Address Department | Specifies the structured address - department. | VARCHAR2 | 70 | Y
71 | Structured Address Sub Department | Specifies the structured address – sub-department. | VARCHAR2 | 70 | Y
72 | Structured Address Street Name | Specifies the structured address - street name. | VARCHAR2 | 70 | Y
73 | Structured Address Building Number | Specifies the structured address – building number. | VARCHAR2 | 16 | Y
74 | Structured Address Building Name | Specifies the structured address - building name. | VARCHAR2 | 35 | Y
75 | Structured Address Floor | Specifies the structured address - floor. | VARCHAR2 | 70 | Y
76 | Structured Address Post Box | Specifies the structured address - post box. | VARCHAR2 | 16 | Y
77 | Structured Address Room | Specifies the structured address - room. | VARCHAR2 | 70 | Y
78 | Structured Address Post Code | Specifies the structured address - Post Code. | VARCHAR2 | 16 | Y
79 | Structured Address Town Name | Specifies the structured address - town name. | VARCHAR2 | 35 | Y
80 | Structured Address Town Location Name | Specifies the structured address - town location name. | VARCHAR2 | 35 | Y
81 | Structured Address District Name | Specifies the structured address - district name. | VARCHAR2 | 35 | Y
82 | Structured Address Country Sub Division | Specifies the structured address - country sub divison. | VARCHAR2 | 35 | Y
83 | Structured Address Country | Specifies the structured address - country. | VARCHAR2 | 2 | Y
84 | BIC Code | Customer’s BIC code | VARCHAR2 | 11 | Y
85 | Structured Address Hybrid Address Line 1 | Specifies the structured address - hybrid address line 1 | VARCHAR2 | 70 | Y
86 | Structured Address Hybrid Address Line 2 | Specifies the structured address - hybrid address line 2 | VARCHAR2 | 70 | Y

Parent topic: File Upload

### 3.2 Virtual Account

Virtual Account File Upload is used for the bulk creation, modification and closure of Virtual Accounts.

Feed Name: virtualaccount

The following table describes the details of the file structure.

Table 3-2 Virtual Account - File Structure

Sequence Number | Field Name | Description | Data Type | Field Length | Modifiable (NA/Y/N)
--- | --- | --- | --- | --- | ---
1 | Action | Specifies the operation to be performed. Allowed operations are as following: New: Creation of virtual accounts Modify: Modification of existing virtual accounts Close: Closure of existing virtual accounts | VARCHAR2 | - | NA
2 | Branch Code | Specifies the branch under which virtual account to be created. | VARCHAR2 | 3 | N
3 | Virtual Entity ID | Specifies the Virtual Entity for which virtual account to be created. | VARCHAR2 | 12 | N
4 | Real Customer Number | Specifies the Real Customer Number for which the Virtual Account is to be created. | VARCHAR2 | 20 | N
5 | Account Currency | Specifies the Account Currency. | VARCHAR2 | 3 | N
6 | Virtual Account Product | Specifies the product under which virtual account to be created. | VARCHAR2 | 4 | N
7 | Virtual Account Number | Virtual Account Number is applicable for Modify and Close operations. | VARCHAR2 | 20 | N
8 | IBAN Required | Specifies if IBAN is to be generated or not. Valid values are as following: Y N | CHAR | 1 | N
9 | IBAN Account Number | Specifies the IBAN Account Number. | VARCHAR2 | 30 | N
10 | Virtual Account Name | Specifies the virtual account name. | VARCHAR2 | 105 | Y
11 | Address Line 1 | Specifies the Correspondence Address Line 1. | VARCHAR2 | 35 | Y
12 | Address Line 2 | Specifies the Correspondence Address Line 2. | VARCHAR2 | 35 | Y
13 | Address Line 3 | Specifies the Correspondence Address Line 3. | VARCHAR2 | 35 | Y
14 | Address Line 4 | Specifies the Correspondence Address Line 4. | VARCHAR2 | 35 | Y
15 | Address Pincode | Specifies the Correspondence Address Zip code. | VARCHAR2 | 15 | Y
16 | Address Country Code | Specifies the Correspondence Address Country Code. | VARCHAR2 | 3 | Y
17 | Account Purpose | Specifies the description of the Account Purpose. | VARCHAR2 | 105 | Y
18 | Interest Calculation Required | Flag to indicate if Interest Calculation is required for the Virtual Account. Valid values are as following: Y N | CHAR | 1 | N
19 | Account Frozen | Flag to indicate if whether virtual account is frozen. Valid values are as following: Y N | CHAR | 1 | Y (conditional based on account product)
20 | Balance Check For Debits | Flag to indicate whether balance check is required for debit transactions. Valid values are as following: Y N | CHAR | 1 | Y
21 | Balance Availability Options | Balance Options Available options are as following: O - Own Balance P - Pool Balance B - Own Balance + Fixed Amount from Pool | CHAR | 1 | Y
22 | Fixed Amount From Pool | Specifies the Fixed Amount contribution from pool. Applicable if balAvailabilityOptions = Own Balance + Fixed Amount from Pool. | NUMBER | 22, 3 | Y (conditional)
23 | Overdraft Allowed | Flag to indicate whether virtual account can be overdrawn. Valid values are as following: Y N | CHAR | 1 | Y (conditional based on account product)
24 | Overdraft Sanction Amount | Specifies the Overdraft amount sanctioned. | NUMBER | 22, 3 | Y (conditional based on Overdraft Allowed)
25 | Credit Transactions Allowed | Flag to indicate whether credit transactions are allowed on the virtual account. Valid values are as following: Y N | CHAR | 1 | Y (based on account product configuration)
26 | Debit Transactions Allowed | Flag to indicate whether debit transactions are allowed on the virtual account. Valid values are as following: Y N | CHAR | 1 | Y (based on account product configuration)
27 | Real Account Linkage | Specifies the Real Account Linkage. Valid values are as following: S - Structure Level A - Account Level Default value is A. | CHAR | 1 | N
28 | Real Account Number | Specifies the Real Account Number. Applicable if realAccLinkage = A. | VARCHAR2 | 20 | N
29 | Real Account Currency | Specifies the Real Account Currency. Applicable if realAccLinkage = A. | VARCHAR2 | 3 | N
30 | Real Account Branch | Specifies the Real Account Branch. Applicable if realAccLinkage = A. | VARCHAR2 | 3 | N
31 | Overdraft Start Date | Specifies the Overdraft Start Date. | DATE Format: YYYY-MM-DD | - | Y (conditional based on Overdraft Allowed)
32 | Overdraft End Date | Specifies the Overdraft End Date. | DATE Format: YYYY-MM-DD | - | Y (conditional based on Overdraft Allowed)
33 | Remarks | Specifies the Account Remarks. | VARCHAR2 | 200 | Y
34 | Transfer In Virtual Account Number | In case of negative balance, a designated Virtual Account Number from which the said amount needs to be transferred from. | VARCHAR2 | 20 | NA
35 | Transfer Out Virtual Account Number | In case of positive balance, a designated Virtual Account Number to which the said amount needs to be transferred to. | VARCHAR2 | 20 | NA
36 | Structured Address Department | Specifies the structured address - department. | VARCHAR2 | 70 | Y
37 | Structured Address Sub Department | Specifies the structured address - sub-department. | VARCHAR2 | 70 | Y
38 | Structured Address Street Name | Specifies the structured address - street name. | VARCHAR2 | 70 | Y
39 | Structured Address Building Number | Specifies the structured address - building number. | VARCHAR2 | 16 | Y
40 | Structured Address Building Name | Specifies the structured address - building name. | VARCHAR2 | 35 | Y
41 | Structured Address Floor | Specifies the structured address - floor. | VARCHAR2 | 70 | Y
42 | Structured Address Post Box | Specifies the structured address - post box. | VARCHAR2 | 16 | Y
43 | Structured Address Room | Specifies the structured address - room. | VARCHAR2 | 70 | Y
44 | Structured Address Post Code | Specifies the structured address - Post Code. | VARCHAR2 | 16 | Y
45 | Structured Address Town Name | Specifies the structured address - town name. | VARCHAR2 | 35 | Y
46 | Structured Address Town Location Name | Specifies the structured address - town location name. | VARCHAR2 | 35 | Y
47 | Structured Address District Name | Specifies the structured address - district name. | VARCHAR2 | 35 | Y
48 | Structured Address Country Sub Divison | Specifies the structured address - country sub divison. | VARCHAR2 | 35 | Y
49 | Structured Address Country | Specifies the structured address - country. | VARCHAR2 | 2 | Y
50 | Structure Code | Specifies an existing structure code for linking to account structure. The Structure Code should already exist in Oracle Banking Virtual Account Management before uploading the file. | VARCHAR2 | 20 | N
51 | Virtual Parent Account Number | Specifies the Virtual Parent Account Number of the account structure for linkage. The Virtual Parent Account Number should already exist in Oracle Banking Virtual Account Management before uploading the file. | VARCHAR2 | 35 | N
52 | accLiqdAllowed | Specifies the Liquidity Management allowed or not. | VARCHAR2 | 1 | Y (conditional based on account product)
53 | accountExpiryDate | Specifies the Expiry Date of the Virtual Account | DATE Format: YYYY-MM-DD | 10 | Y
54 | Hybrid Address Line1 | Specifies the structured address - hybrid address – Address Line1 | VARCHAR2 | 70 | Y
55 | Hybrid Address Line2 | Specifies the structured address - hybrid address- Address Line2 | VARCHAR2 | 70 | Y

Parent topic: File Upload

### 3.3 Account Structure

Account Structure File Upload is used for the bulk creation, modification and closure of Virtual Account Structures.

Feed Name: virtualAccountMap

The following table describes the details of the file structure.

Table 3-3 Account Structure - Master Reocrds

Sequence Number | Field Name | Description | Data Type | Field Length | Modifiable (NA/Y/N)
--- | --- | --- | --- | --- | ---
1 | Action | Specifies the operation to be performed. Allowed operations are as following: New: Creation of Account Structure Modify: Modification of existing account structures Close: Closure of existing account structures | VARCHAR2 | - | NA
2 | Branch Code | Specifies the Branch Code. | VARCHAR2 | 3 | NA
3 | Real Customer Number | Specifies the Real Customer Number for which the Account Structure is to be created. | VARCHAR2 | 20 | N
4 | Structure Code | Specifies the Unique Identifier of the Structure. | VARCHAR2 | 20 | N
5 | Structure Description | Specifies the Structure Description. | VARCHAR2 | 35 | Y
6 | Virtual Main Account | Specifies the Virtual Header Account. | VARCHAR2 | 20 | N
7 | Real Account Number | Specifies the Real Account Number linked to the account structure. Applicable if the value for Account Linkage is A. | VARCHAR2 | 20 | Y (conditional if the linkage is Real Account)
8 | Real Account Branch | Specifies the Real Account Branch. Applicable if the value for Account Linkage is A. | VARCHAR2 | 3 | Y (conditional if the Real Account is changed)
9 | Account Linkage | Specifies the Account Linkage Type. Valid values are as following: A - Real Account G - Virtual Multi-Currency Account | CHAR | 1 | Y
10 | Account Group ID | Specifies the Virtual Multi-Currency Account. Applicable if the value for Account Linkage is G. | VARCHAR2 | 8 | Y (conditional based on linkage)
11 | Interest Calculation Required | Flag to indicate if Interest Calculation is required. Valid values are as following: Y N | CHAR | 1 | Y
12 | Remarks | Specifies the Additional Remarks. | VARCHAR2 | 200 | Y
13 | Charge Account | Specifies Customer’s Charge Account | VARCHAR2 | 35 | Y
14 | Charge Account Branch | Charge Account’s Branch | VARCHAR2 | 3 | Y
15 | Charge Account Currency | Charge Account Currency | VARCHAR2 | 3 | Y

Table 3-4 Account Structure - Child Records

Sequence Number | Field Name | Description | Data Type | Field Length | Modifiable (NA/Y/N)
--- | --- | --- | --- | --- | ---
1 | Virtual Parent Account | Specifies the Parent Virtual Account. | VARCHAR2 | 20 | NA
2 | Virtual Child Account | Specifies the Child Virtual Account. | VARCHAR2 | 20 | NA

Parent topic: File Upload

### 3.4 Remittance Details

Remittance Details File Upload is used for the bulk creation, modification and closure of Remittance.

Feed Name: remittanceDetails

The following table describes the details of the file structure.

Table 3-5 Remittance Details - File Structure

Sequence Number | Field Name | Description | Data Type | Field Length | Modifiable (NA/Y/N)
--- | --- | --- | --- | --- | ---
1 | Action | Specifies the operation to be performed. Allowed operations are as following: New: Creation of Remittance IDs Modify: Modification of existing Remittance IDs Close: Closure of existing Remittance IDs | VARCHAR2 | - | NA
2 | Real Customer Number | Specifies the Customer Number for which the Remittance ID is maintained. | VARCHAR2 | 20 | N
3 | Virtual Identifier | Specifies the Virtual Identifier of the Corporate | VARCHAR2 | 15 | N
4 | Remittance ID | Specifies the unique Identification of the Remittance ID. | VARCHAR2 | 35 | N
5 | IBAN Required | Specifies if IBAN is to be generated or not. Valid values are as following: Y N | CHAR | 1 | N
6 | Validity Start Date | Specifies the start date of Remittance ID | DATE Format: YYYY-MM-DD | - | Y
7 | Validity End Date | Specifies the end date of Remittance ID | DATE Format: YYYY-MM-DD | - | Y
8 | Reconciliation Information | Specifies the Reference number provided by the corporate for reconciliation purpose. | VARCHAR2 | 255 | Y
9 | Additional Information | Specifies the additional information provided by the corporate for further use. | VARCHAR2 | 255 | Y
10 | Remarks | Specifies the Remarks. Applicable for closure of Remittance ID. | VARCHAR2 | 200 | Y

Parent topic: File Upload

### 3.5 Journal Posting

Journal Posting File Upload is used for the bulk upload of the journal postings.

Feed Name: JournalPosting

The following table describes the details of the file structure.

Table 3-6 Journal Posting - Master Records

Sequence Number | Field Name | Description | Data Type | Field Length
--- | --- | --- | --- | ---
1 | Discriminator | Specifies the discriminator for Parent Record. Allowed Discriminator value = P | - | -
2 | Action | Specifies the operation to be performed. Allowed operations are as following: New: Creation of Transaction Journal | VARCHAR2 | -
3 | Source Code | Specifies the Source Code. | VARCHAR2 | 15
4 | Source Reference No | Specifies the Source Reference number. | VARCHAR2 | 20
5 | SkipDDAEntries | Specifies the indicator to skip DDA entries. Valid values are as following: true - To skip DDAEntries false - Not to SkipDDAEntries | VARCHAR2 | 4

Table 3-7 Journal Posting - Child Records

Sequence Number | Field Name | Description | Data Type | Field Length
--- | --- | --- | --- | ---
1 | Discriminator | Specifies the discriminator for child record. Allowed Discriminator value = C | VARCHAR2 | -
2 | TxnAccount | Specifies the Transaction Account Number. | VARCHAR2 | 35
3 | TxnAccountCcy | Specifies the Transaction Account Currency. | VARCHAR2 | 3
4 | TxnAccountBrn | Specifies the Transaction Account Branch. | VARCHAR2 | 3
5 | DrCrInd | Specifies the Debit/Credit Indicator. Valid Values are as following: D - Debit C - Credit | CHAR | 1
6 | ForceDebit | Specifies the ForceDebit Indicator. Valid Values are as following: N Y | CHAR | 1
7 | TxnCcy | Specifies the Transaction Currency. | VARCHAR2 | 3
8 | TxnAmount | Specifies the Transaction Amount. | NUMBER | 22, 3
9 | TxnCode | Specifies the Transaction Code. | VARCHAR2 | 3
10 | ValueDate | Specifies the Value Date. | DATE Format: YYYY-MM-DD | -
11 | ExchRate | Specifies the Exchange Rate for the Currency. | NUMBER | 24, 12
12 | AmtInTxnAccCcy | Specifies the Amount in Transaction Account Currency. | NUMBER | 22, 3
13 | ReconRefNo | Specifies the Recon Reference Number. | VARCHAR2 | 35
14 | EcaOrBlockRefNo | Specifies ECA or Block Reference Number. | VARCHAR2 | 35
15 | BlkReleaseStatus | Specifies the Block Release Status. Valid values are as following: F - Full BlkRelease P- Partial BlkRelease | CHAR | 1
16 | DdaOffset | Specifies the DDA Offset Number. | VARCHAR2 | 35
17 | AddlText | Specifies the additional text. | VARCHAR2 | 4000

Parent topic: File Upload

### 3.6 Journal Posting Reversal

Journal Posting Reversal File Upload is used for the bulk reversal of the transaction journals.

Feed Name: JournalPostingRev

The following table describes the details of the file structure.

Table 3-8 Journal Posting Reversal - File Structure

Sequence Number | Field Name | Description | Data Type | Field Length
--- | --- | --- | --- | ---
1 | txnRefNo | Specifies the Transaction Reference Number to be reversed. | VARCHAR2 | 35

Parent topic: File Upload