There are general requirements for loading the External Bank Account for employees during the project implementation which will be used either for expenses or Payroll.
Let's go through the pre-requisite and steps for loading the External bank account using HDL
Pre-Requisite:
There is pre-requisite to generate party id before loading the External Bank Account.
1) We need to run the "Synchronize Person Records" scheduled process by entering the details:
This process should generate the Party Id for employee which have been migrated using HDL.
2) If Party Id is still not generated even after running the above process then run the "Maintain Party and Location Current Record Information"
This process should generate the Party Id for employee which have been migrated using HDL.
Once the Party Id is generated run Load the External Bank Account HDL file.
Below is sample ExternalBankAccount.dat file:
METADATA|ExternalBankAccount|BankNumber|BankName|BankBranchNumber|BankBranchName|CountryCode|AccountNumber|IBAN|AccountName|AccountType|CurrencyCode|SourceSystemOwner|SourceSystemId
MERGE|ExternalBankAccount||HSBC|400104|London|GB|12345678||Test Employee||GBP|HDL_TEST|111_12345678
METADATA|ExternalBankAccountOwner|BankNumber|BankName|BankBranchNumber|BankBranchName|CountryCode|AccountNumber|CurrencyCode|PersonNumber|PrimaryFlag|SourceSystemId|SourceSystemOwner|ExternalBankAccountId(SourceSystemId)
MERGE|ExternalBankAccountOwner||HSBC|400104|London|GB|12345678|GBP|111|Y|111_12345678|HDL_TEST|111_12345678
Hope this is useful.
Comments
Post a Comment