Page Comparison

...

1. If we look in the ERP_Prod_Ext database table ImportExportJob we can find Shipping Detail Updates. This is the process for updating ERP customer orders with data from CFS.
   
   The commands run by the scheduler are located in the ERP_Prod_Ext database table ImportExportStep. By using the idImportExportJob value 4 from above we can query the table and see the commands used to bring data back to ERP from CFS.
2. The first command (based on CommandOrder) is a select to get the next BatchNumber. I copied the SourceCommand value and pasted it into the query panel to see the full command.
   Image Added
   Reviewing the command above you can see that it is querying the INTERFACES database table BATCH. It is looking for ERP and Shipping with a Processed value of ‘’.
3. Next we will need the password for the ComputerWay database. To get this we look in the ERP_Prod database table ImportExportConnections.
   Below you will see the password for ComputerWay is myPassword
   .Image Added
   
   
4. To Run the command, connect to the Country Ribbon SQL server.
   They should have QTODBC on the desktop. This is how we can run commands on the CFS database.
   Image Added
   
   

5. When you load the QTODBC you will see this next screen.Click on the Machine Data Source tab.

   Image Added

   
   

6. Next click on the interfaces Data Source Name and then click OK.

   Image Added

    

7. You will need to enter Password from above.

   Image Added

    

8. You can now see the INTERFACES database and it’s tables.

   Copy and paste the SELECT command we got from the ERP_Prod_Ext database table ImportExportStep.

   This command is looking for the next available batch. Click on the right arrow to run the command and see the results down below.

   You can see that currently there is no next batch available.
   Image Added