Description |
Company: ncpllc
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-233267 - Vendor EFT Import during Origin conversion|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-233267]
We would like to convert the EFT information on the vendors that is found in the Additional drop down on the entity
!pastedImage_d100064_0.png!
Conversion Specs:
* Origin EFT Information is found in efeftmst
|tblEntityEFTInformation|efeftmst|Notes|
|intEntityEFTInfoId|N/A|Autoincremented|
|
|intEntityId|
|efeft_eft_no|The field in origin is the vendor number which should be joined with tblEMEntity.strEntityNo to get the intEntityId for this field|
|
|intBankId|
|efeft_bnk_no|The field in the origin table is the bank code that links back to ssbnkmst.ssbnk_code which will give the info to link to tblCMBank to get the correct bank account id in i21|
|
|strBankName|
|efeft_bnk_no|This is another one where you should link efeft_bnk_no to ssbnkmst and use the information in ssbnkmst.ssbnk_name to put in this field in i21|
|
|strAccountNumber|
|efeft_account_no|strAccountNumber must be encrypted|
|
|strAccountType|
|
|efeft_acct_type|
|If "C" then checking, if "S" then savings|
|
|strAccountClassification|
|
|efeft_acct_class_cp|
|If "C then corportae, if "P" then personal|
|
|dtmEffectiveDate|
|
|efeft_effective_date|
| |
|
|ysnPrintNotifications|
|
|efeft_notify_yn|
| |
|
|ysnActive|
|
|efeft_active_yn|
| |
|
|strPullARBy|
|N/A|Not needed for AP Vendor conversion|
|
|
|ysnPullTaxSeparately|
|
|
|efeft_pull_tax_separate_yn|
| |
|
|ysnRefundBudgetCredits|
|
|efeft_refund_bdgt_credits_yn|
| |
|
|strDistributionType|
| | *Please find out the use of this. It seems like it is very similar to strEFTType* |
|
|dblAmount|
| |I think this is for prenote amount? But can you please find out|
|
|intOrder|
| |Also not sure what this field is needed for|
|
|strEFTType|
|
|efeft_src_sys|
|If "AP" then "Accounts Payable, If "AR" then "Accounts Recievable"|
|