{ sqlDriver: "net.sourceforge.jtds.jdbc.Driver", sqlUrl: "jdbc:jtds:sqlserver://SAGESVR/Sage200_RSP_Live;user=cindercone;password=adm1nPa$$", directory: "D:/Magma/magma_out/Prices-To-SFDC/", sql:" SELECT 1 AS IsActive, IIF(MAGMA.magma_erp_key = '', '', CI.Code) As CurrencyCode, SIP.Price As Price, IIF(MAGMA.magma_erp_key = '', '', SIP.PriceBandID) AS Sage_Price_Band_ID__c, IIF(MAGMA.magma_erp_key = '', '', SIP.ItemID) AS Sage_ItemID__c, CONVERT(bigint, SIP.OpLock) AS OpLock__c, CONCAT(SIP.PriceBandID,'-', SIP.ItemID,'-',CI.Code) as Sage_Stock_Item_Price_ID__c, S.Code AS ProductCode, MAGMA.magma_erp_key AS ExistingKey FROM StockitemPrice SIP WITH(NOLOCK) inner join StockItem S WITH(NOLOCK) on SIP.ItemID = S.ItemID inner join PriceBand P WITH(NOLOCK) on SIP.PriceBandID = P.PriceBandID inner join SYSCurrency C WITH(NOLOCK) on C.SYSCurrencyID IN (1365806,4148562) inner join SYSCurrencyISOCode CI WITH(NOLOCK) on C.SYSCurrencyISOCodeID = CI.SYSCurrencyISOCodeID full outer join [cindercone_magma_reece].dbo.magma_sfdc_tracking MAGMA WITH(NOLOCK) on SIP.PriceBandID = CAST(CASE WHEN ISNUMERIC(MAGMA.magma_sfdc_description) = 1 THEN MAGMA.magma_sfdc_description ELSE NULL END AS decimal) and S.Code = MAGMA.magma_spare4 and CI.Code = MAGMA.magma_spare2 WHERE CONVERT(bigint, SIP.OpLock) > CONVERT(bigint, 22445224) AND P.ThisIsTheStandardBand=1 ORDER BY SIP.OpLock ", filePrefix: "A-STD-PRICE_ENTRIES", recordsPerFile: "1000", columns: [ "IsActive", "CurrencyIsoCode", "UnitPrice", "Sage_Price_Band_ID__c", "Sage_ItemID__c", "OpLock__c", "Sage_Stock_Item_Price_ID__c" ], updateTrackingRequest: { trackingTable: "magma_sfdc_tracking", existingKeys: { magma_erp_key : "@ExistingKey", magma_sfdc_type: "Pricebookentry" }, updateFields: [ "magma_status", "magma_sfdc_description", "magma_spare1", "magma_spare2", "magma_spare3", "magma_spare4" ], fieldValues: { magma_status: "FROM-SAGE", magma_sfdc_description: "Sage_Price_Band_ID__c", magma_sfdc_id: "NEW", magma_sfdc_type: "Pricebookentry", magma_sfdc_name: "ProductCode", magma_mapping_runset_id: $runset_name, magma_mapping_in_filename: "Prices-To-SFDC-S2-20100", magma_mapping_out_filename: "p-Prices-To-SFDC-S2-20100", magma_is_fusion: "false", magma_session_date: "29_09_2017_11_36_29_845", magma_erp_key: "@ExistingKey", magma_spare1: "@Price", magma_spare2: "@CurrencyCode", magma_spare3: "@OpLock__c", magma_spare4: "@ProductCode" } } , returnField: "OpLock", returnType: "last" }