Requirements: 

Phase1:

1. Loading supplier transactions which are not allocated and not paid yet. 
2. User can filter the transactions by 
   1. Supplier range 
   2. Due date
   3. on hold suppliers 
   4. Remittance cheque EFT
   5. transaction on hold
   6. Action date
3. Can allocate the transactions individually or as a batch 
4. Can download bank file and upload it to the bank 
5. Can view the supplier information of the transaction 
6. Can view attachments linked to that invoice
7. Due dates are color-coded (red, yellow, green) to indicate urgency.
8. Download the report of the transactions 
9. Can download the bank file. 
10. Can configure the bank file. (settings)
11. Every action is permission based
12. Batch should be validated against the bank file structure. 

Phase2: 

1. Link the payments to the bank and directly pay them 
2. Saving the batches as Draft and ability to load them later on
3. Can create a batch from transactions and send it through approval

Data structure 

Header table: 

CREATE TABLE [dbo].[PaymentBatchAccounts](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[AccountLink] [int] NOT NULL,
	[iAllowICPurchases] [bit] NOT NULL,
	[Master_Sub_Account] [nvarchar](max) NULL,
	[Account_Type] [nvarchar](max) NULL,
	[Description] [nvarchar](max) NULL,
	[iAccountType] [int] NOT NULL,
	[AcLookup] [nvarchar](max) NULL,
	[iForeignBankCurrencyID] [int] NOT NULL,
	[CurrencyCode] [nvarchar](max) NULL,
	[CurrencyId] [int] NOT NULL,
	[BranchId] [bigint] NULL,
 CONSTRAINT [PK_PaymentBatchAccounts] PRIMARY KEY CLUSTERED