ACH Universal's SQL Insertion feature is bundled within the Software Integration Kit (SIK).
This feature enables you to insert transactions directly into a table within the ACH Universal SQL database.
While the majority of the Software Integration Kit (SIK) is 'Point and Click', this feature requires you to initiate the 'push' the transactions from your database into ours. This is an advanced feature and requires a strong working knowledge of SQL commands.
Select 'SQL Insertion' on the main screen or our Software Integration Kit (below)
Select the SQL Insertion options - in essence, you're telling ACH Universal what types of data to expect.
Need a test SQL script to populate the table?
Tip: Start SQL Server Management Studio and click on 'New Query' (make sure that you're in the right database). Then copy the script below.
INSERT into tblHoldingGLIntegration (tblHoldingGLIntegration.Amount, tblHoldingGLIntegration.Description, tblHoldingGLIntegration.Text1, tblHoldingGLIntegration.ACH_Account, tblHoldingGLIntegration.ACH_Routing_ABA, tblHoldingGLIntegration.ACH_CheckingorSavings, tblHoldingGLIntegration.Class_3_Letters, tblHoldingGLIntegration.Date) VALUES ('123.45', 'ABC Company', 'ABC01', '88888888','063000047', '0', 'CCD', '12/31/2013')
Tip: No valid records when using your data? - Remember that the software will filter out invalid ABA numbers. Make sure that you use valid ABA numbers in testing.
For a step-by-step checklist, see our SQL Insertion Help.