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 view the supplier information of the transaction 
    1. the user with permission should be able to modify the supplier bank information.
  5. Can view attachments linked to that invoice
  6. Due dates are color-coded (red, yellow, green) to indicate urgency.
  7. Download the report of the transactions 
  8. Can download the bank file. 
  9. Can configure the bank file. (settings)
  10. Every action is permission based
  11. Batch should be validated against the bank file structure. 
    1. supplier bank information should be validated.
    2. should be validated if the line has been already paid or not.


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 
CREATE TABLE [dbo].[PaymentBatchPayableLines](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[AccountNumber] [nvarchar](max) NULL,
	[AccountName] [nvarchar](max) NULL,
	[Bic_Swift] [nvarchar](max) NULL,
	[IBAN] [nvarchar](max) NULL,
	[IsBankAccountValid] [bit] NOT NULL,
	[ExtOrderNum] [nvarchar](max) NULL,
	[InvoiceDate] [datetime2](7) NULL,
	[TxDescription] [nvarchar](max) NULL,
	[Reference] [nvarchar](max) NULL,
	[Order_No] [nvarchar](max) NULL,
	[UserName] [nvarchar](max) NULL,
	[cReference2] [nvarchar](max) NULL,
	[cAuditNumber] [nvarchar](max) NULL,
	[TrCodeDesc] [nvarchar](max) NULL,
	[Branch] [nvarchar](max) NULL,
	[Balance] [float] NOT NULL,
	[DocTotal] [float] NOT NULL,
	[UBD_DueDate] [datetime2](7) NULL,
	[UBD_Terms] [datetime2](7) NULL,
	[DCBalance] [float] NOT NULL,
	[fForeignBalance] [float] NOT NULL,
	[fForeignOutstanding] [float] NOT NULL,
	[OutstandingHome] [float] NOT NULL,
	[Module] [nvarchar](max) NULL,
	[Debit] [float] NOT NULL,
	[Credit] [float] NOT NULL,
	[DCLink] [int] NOT NULL,
	[Account] [nvarchar](max) NULL,
	[Name] [nvarchar](max) NULL,
	[Tax_Number] [nvarchar](max) NULL,
	[PurchaseOrderID] [bigint] NULL,
	[VendorID] [int] NOT NULL,
	[CurrencyID] [int] NOT NULL,
	[RemittanceChequeEFTs] [bit] NOT NULL,
	[TxOnHold] [bit] NOT NULL,
	[OnHold] [bit] NOT NULL,
	[BranchId] [bigint] NULL,
 CONSTRAINT [PK_PaymentBatchPayableLines] PRIMARY KEY CLUSTERED