Batch Type: The Batch type the imported transactions must belong to. Read more on batch types here Database Type: SQL or Oracle Connection String: Database and Server to get the data from SQL: Data Source=Server;UID=User;pwd=Password;Initial Catalog=Database; Oracle: User ID=User;Data Source=Server;Persist Security Info=True;Password=Password SQL: Query to return and map the data - see the links on the left for guidelines Key Field Name: The column in the query bank recon gets the Last key Value from. It must much a column in your query exactly Data Key Type: Date or int.
Last key: The value of the last record imported. For Int it will be the ID of the last record. For Date it will be the date the last import was done for |