A Customize Statements and Advices
Use the predefined XML elements described in this topic to customize the information in the account statements and advices.
This topic contains the following sections:
Predefined XML elements
Table A-1 Predefined XML elements description table
| XML Element | Description |
|---|---|
| statementAdviceXML | root element |
| reportHeaderXML | child element |
| customerName | Customer Name |
| customerNumber | Customer Number |
| reportGenerationDate | Date when report is generated |
| addressLine1 | Address Line 1 |
| addressLine2 | Address Line 2 |
| addressLine3 | Address Line 3 |
| addressLine4 | Address Line 4 |
| pageHeaderXML | child element |
| fromDate | From Date |
| toDate | To Date |
| detailXML | child element |
| accountsXML | child element |
| accountXML | child element ( Complex Type ) - could be repeated for consolidated statements |
| accountName | Account Name |
| accountNo | Account Number |
| branchCode | Branch Code |
| branchName | Branch Name |
| currency | Account Currency |
| currentBalance | Current Balance |
| openingBalance | Opening Balance |
| closingBalance | Closing Balance |
| apyeAdviceRequestXML | child element (Specific to Retail Accounts) |
| apyeAvgBal | Average balance in the retail account |
| apye | child element (Specific to Retail Accounts) |
| liqdAmt | Available balance in the retail account |
| transactionItems | XML child element |
| item | XML child element (Complex Type) - could be repeated for multiple transaction |
| accClass | Account Class of the Account |
| accountCcy | Currency Of the Account |
| accountCcyAmount | Transaction Amount in Account Currency |
| accountEntryType | Indicates whether Entry is associated with Account(A) or GL(G) |
| accountingRefNo | Uniquely generated reference number to identify each transaction |
| accountingRefNoToBeReversed | Accounting reference number which is being reversed |
| accountNumber | Account Number |
| accountType | Indicates the Type of Account for which the Transaction is being posted |
| addlText | Indicates short explanation for each transaction to be shown in statements |
| amtInRealAccCcy | Transaction Amount in Account Currency |
| amtTag | Indicates Amount tag Associated with the Transaction |
| authStatus | Authorization Status of the Transaction |
| autoRelease | Flag to determine the release of the uncollected credit transaction on the uncollected fund release date |
| availabilityInfo | Indicates the time interval after which funds will be available. |
| availableDays | Indicates the number of days after which funds will be available |
| balance | Running Balance |
| balancedEntry | Indicates the sum of debits and sum of credits to be balanced if this flag is On |
| bankRefNo | Bank Reference Number |
| blockRefNo | Amount block reference number associated with the transaction |
| blockUtilizedAmt | Block Amount utilised |
| branchLcyAmtTransaction | Amount in Transaction Branch Currency |
| courtesyPaySource | Courtesy Pay Source associated with the transaction |
| customerNo | Customer Number |
| deferredResponse | Specify yes to defer the response. |
| deltaAmt | The difference in the amount, |
| deposit | Transaction Amount in Account Currency |
| drCr | Debit Credit Indicator |
| eaRefNo | External Accounting Reference Number |
| event | Transaction Event |
| exchRate | Exchange Rate |
| extAccountingRefNo | External Accounting Reference Number |
| externalChecker | User who has authorized the transaction |
| externalMaker | User who has Initiated the transaction |
| fileName | File Name associated with the Amount Block |
| forcePost | Flag to Indicate that Amount block has to be created irrespective of any error |
| instrumentCode | Instrument Code associated with the Amount block |
| limitRequired | Limit to be utilized |
| module | Indicates the Module from which the transaction is being posted |
| multiCcyAccNo | Indicates if it is a Multi-currency account number |
| operation | Operation name |
| originalSource | Source of transaction origination |
| pendingAmt | Pending Amount |
| product | Product Code associated with the Transaction |
| productProcessor | Product Processor which is sending the Transaction |
| realAccCcy | Account Currency |
| realAccClass | Account Class of the Account |
| realAccountBrn | Branch associated with the Account |
| realAccountNo | Account Number |
| referralAllowed | Referral allowed or not |
| regdApplicable | Indicates whether the transaction is applicable for Federal Reserve Registered Regulation |
| relatedAccount | Account associated with the transaction |
| relatedCustomer | Customer associated with the transaction |
| relatedReferrence | Related Reference Number associated with the Transaction |
| reval | Flag to Indicate Revaluation is to be done for the Transaction |
| revalCode | Revaluation Code to be associated with the Transaction being posted |
| revalLossGl | Revaluation Loss GL to be associated with the transaction being posted |
| revalProfitGl | Revaluation Profit GL to be associated with the transaction being posted |
| revalRate | Revaluation Rate to be associated with the transaction being posted |
| revalRateCode | Revaluation Rate Code to be associated with the transaction being posted |
| revalRequired | Indicates whether revaluation is required for the transaction being posted |
| revalTxnCode | Revaluation Transaction Code to be associated with the transaction being posted |
| reversal | Flag to Indicate whether the transaction is a reversal Transaction |
| rtlAllowed | Indicates if RTL is allowed on the transaction or not |
| rtlRefNo | RTL reference number |
| showInStmt | Indicator whether to show in statement or not |
| sourceCode | Source system from where the transaction is initiated |
| sourceRefNo | Source reference number |
| statementNarrative | Indicates short explanation for each transaction to be shown in statements |
| status | Status |
| stmtDate | Date on which the transaction is recorded in the statement generated for the account |
| suppressAccOverridesUptoSeverityLevel | Severity level upto which can be tolerated for the account validation override suppression in a transaction |
| suppressBalanceOverridesUptoSeverityLevel | Severity level upto which can be tolerated for the balance validation override suppression in a transaction |
| tag61SupportInfo | Tag 61 Info to be associated with the transaction |
| transactionAmount | Transaction amount |
| transactionCcy | Currency in which the transaction is done |
| transactionDate | Transaction Posting Date |
| transactionDescription | Indicates short explanation for each transaction to be shown in statements |
| transactionStatus | Transaction status of the transaction posted |
| txnBranch | Transaction Branch from which Transaction is initiated |
| txnDescription | Transaction Description |
| txnInitDate | Transaction Initialization Date |
| txnLcy | Transaction amount in LCY |
| txnRefNo | Transaction Reference Number |
| txnStatus | Transaction status of the transaction posted |
| userRefNo | User Reference Number |
| valueDate | Value Date of the Transaction |
| withdrawal | Transaction Amount in Account Currency |
Sample XML file
The following sample XML file shows the use of the predefined XML tags described in the Predefined XML elements table.
<statementAdvice>
<pageHeader>
<fromDate>2018-04-07</fromDate>
<toDate>2018-04-07</toDate>
</pageHeader>
<reportHeader>
<customerName>Barclays</customerName>
<customerNumber>001</customerNumber>
<reportGenerationDate>2018-04-07 08:04:00</reportGenerationDate>
<addressLine1>36/12 Umesh Mukherjee Road</addressLine1>
<addressLine2>Belgharia</addressLine2>
<addressLine3>Kolkata</addressLine3>
<addressLine4>INDIA 123456</addressLine4>
</reportHeader>
<detail>
<accounts>
<account>
<accountName>VA123</accountName>
<accountNo>123</accountNo>
<branchCode>000</branchCode>
<branchName>BR000</branchName>
<currency>GBP</currency>
<currentBalance>500</currentBalance>
<openingBalance>3000</openingBalance>
<closingBalance>500</closingBalance>
<transactionItems>
<item>
<transactionDate>2018-04-08 08:04:00</transactionDate>
<valueDate>2018-04-07 08:04:00</valueDate>
<transactionDescription>Some test value</transactionDescription>
<withdrawal>2500</withdrawal>
<deposit></deposit>
<balance>500</balance>
<accClass></accClass>
<accountCcy></accountCcy>
<accountCcyAmount></accountCcyAmount>
<accountEntryType></accountEntryType>
<accountingRefNo></accountingRefNo>
<accountingRefNoToBeReversed></accountingRefNoToBeReversed>
<accountNumber></accountNumber>
<accountType></accountType>
<addlText></addlText>
<amtInRealAccCcy></amtInRealAccCcy>
<amtTag></amtTag>
<authStatus></authStatus>
<autoRelease></autoRelease>
<availabilityInfo></availabilityInfo>
<availableDays></availableDays>
<balancedEntry></balancedEntry>
<bankRefNo></bankRefNo>
<blockRefNo></blockRefNo>
<blockUtilizedAmt></blockUtilizedAmt>
<branchLcyAmt></branchLcyAmt>
<courtesyPaySource></courtesyPaySource>
<customerNo></customerNo>
<deferredResponse></deferredResponse>
<deltaAmt></deltaAmt>
<drCr></drCr>
<eaRefNo></eaRefNo>
<event></event>
<exchRate></exchRate>
<extAccountingRefNo></extAccountingRefNo>
<externalChecker></externalChecker>
<externalMaker></externalMaker>
<fileName></fileName>
<forcePost></forcePost>
<instrumentCode></instrumentCode>
<limitRequired></limitRequired>
<module></module>
<multiCcyAccNo></multiCcyAccNo>
<operation></operation>
<originalSource></originalSource>
<pendingAmt></pendingAmt>
<product></product>
<productProcessor></productProcessor>
<realAccCcy></realAccCcy>
<realAccClass></realAccClass>
<realAccountBrn></realAccountBrn>
<realAccountNo></realAccountNo>
<referralAllowed></referralAllowed>
<regdApplicable></regdApplicable>
<relatedAccount></relatedAccount>
<relatedCustomer></relatedCustomer>
<relatedReferrence></relatedReferrence>
<reval></reval>
<revalCode></revalCode>
<revalLossGl></revalLossGl>
<revalProfitGl></revalProfitGl>
<revalRate></revalRate>
<revalRateCode></revalRateCode>
<revalRequired></revalRequired>
<revalTxnCode></revalTxnCode>
<reversal></reversal>
<rtlAllowed></rtlAllowed>
<rtlRefNo></rtlRefNo>
<showInStmt></showInStmt>
<sourceCode></sourceCode>
<sourceRefNo></sourceRefNo>
<statementNarrative></statementNarrative>
<status></status>
<stmtDate></stmtDate>
<suppressAccOverridesUptoSeverityLevel></suppressAccOverridesUptoSeverityLevel>
<suppressBalanceOverridesUptoSeverityLevel></suppressBalanceOverridesUptoSeverityLevel>
<tag61SupportInfo></tag61SupportInfo>
<transactionAmount></transactionAmount>
<transactionCcy></transactionCcy>
<transactionStatus></transactionStatus>
<txnBranch></txnBranch>
<txnDescription></txnDescription>
<txnInitDate></txnInitDate>
<txnLcy></txnLcy>
<txnRefNo></txnRefNo>
<txnStatus></txnStatus>
<userRefNo></userRefNo>
</item>
</transactionItems>
</account>
</accounts>
</detail>
</statementAdvice>