Tuesday, 20 April 2021

HDL Template for External Bank Account Details

HDL Template for External Bank Account Details   

Prerequisite: 
1. Bank and Bank Branches data should be loaded. Click here to find the sample bank details.   


For this use ExternalBankAccount.dat file.

You can see step by step video to load External Bank Account Details using this Link

Please find the below sample template :


METADATA|ExternalBankAccount|SourceSystemOwner|SourceSystemId|AccountNumber|BankBranchName|BankName|CountryCode|CurrencyCode|AccountType

MERGE|ExternalBankAccount|XXTEST|XXTEST_BANKACCT2|123456|AMC123|American Bank|US|USD|Checking


METADATA|ExternalBankAccountOwner|SourceSystemOwner|SourceSystemId|PersonNumber|AccountNumber|BankBranchNumber|BankNumber|CountryCode|CurrencyCode|BankBranchName|BankName|ExternalBankAccountId(SourceSystemId)

MERGE|ExternalBankAccountOwner|XXTEST|XXTEST_ACCTOWNER2|XXTEST2|123456|123|Test123|US|USD|AMC123|American Bank|XXTEST_BANKACCT2

No comments:

Post a Comment

How to sort data in rtf template

  How to sort data in rtf template Sort the data in Data model is the recommended approach. But if you want to sort the data in rtf template...