Are you referring to the Effective Date in the text file that is generated for upload to the bank?  If so, to my knowledge, that is only stored in the text file and is established based on the logic in the file format used (NACHA, CAN_EFT...) so I don't think you would find it anywhere in the Orchid EFT tables in order to link it to the invoice # from APOBL (or which ever table you use). However, if you are referring to the Effective Date in the EFT file format that date logic is probably the same for each payment, you would just need to know what the date logic is to compare it to the invoice date (today, tomorrow, next business day....).

Are you referring to the Effective Date in the text file that is generated for upload to the bank?  If so, to my knowledge, that is only stored in the text file and is established based on the logic in the file format used (NACHA, CAN_EFT...) so I don't think you would find it anywhere in the Orchid EFT tables in order to link it to the invoice # from APOBL (or which ever table you use). However, if you are referring to the Effective Date in the EFT file format that date logic is probably the same for each payment, you would just need to know what the date logic is to compare it to the invoice date (today, tomorrow, next business day....).