Update TDI17 Processing / Short name mapping

[ochiu]

Update TDI17 parsing logic

• [ ] update short name parsing as the description begins with MISC PAYMENT, skip otherwise as they are not EFT payments
• [ ] transaction date is not provided, update parsing validation for this
• [ ] deposit date will be used as the main date, but time portion may not be provided
• [ ] review TDI transaction against EFT Transactions table, capture more information for reconciliation if possible

Short Name Mapping

• [ ] Update to support multi account linking

• [ ] Add status to short name

• Unlinked = created, no action to link as happened yet, or link was removed and any funds applied are reversed

• Pending = not linked yet waiting for 6pm

• Linked = mapped to BCROS account

• Inactive = link de-activated (short name mapping is no longer active but we want to preserve applied transactions)

[ochiu]

Pending some clarification about TDI17 fields