Description |
Positive pay
postive pay is the positive confimation sent to the bank that a check has been created and is valid. the purpose of positive pay is to make sure that the bank only cashes checks that you have cut for the dollar amount you cut them. here is an example of how it works below:
* User creates check 1234 for $50
* User prints check
* User creates postive confirmation file and sends to the bank
** File: 1234,50
* Bank will now only cash check 1234 for $50
* if someone takes that check and fradulently changes the amount to $500 - the bank will not cash it.
* if someone creates a fake check 123333 and tries to cash it the bank will not clear it.
ACH
* ACH automated clearling house transaction - this is where you send a file to the bank of the amounts and accounts you would like to pay.
** The bank will send the money into the recipient account.
NACHA
* a format for doing ACH's
* check the bottom of this page for an example file and layout properties
* [http://inet.irelyserver.com/display/CM/CM+-+Bank+File+Format]
Positive pay format we use for irely
USE [booksSS]
GO
/****** Object: StoredProcedure [dbo].[irely_positivepayi21] Script Date: 7/13/2015 6:48:32 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[irely_positivepayi21] (@date varchar (10)) as
select '121000248','4123110405',strReferenceNo,
convert(varchar(10),substring(convert(varchar (10),dtmCheckPrinted,101),1,2))+'-'+
convert(varchar(10),substring(convert(varchar (10),dtmCheckPrinted,101),4,2))+'-'+
convert(varchar(10),substring(convert(varchar (10),dtmCheckPrinted,101),7,4))
as filedate,
dblAmount,'320',UPPER (strPayee)
from tblCMBankTransaction
where
left(convert(varchar(10),dtmCheckPrinted,101),10)=@date and
intBankTransactionTypeId=16
|