| SQL |
insert into tbl_EAI_InboundFileProcessors(ownerId,ownerType,fileName,fileProcessor,fileFormat,clientProcessEmail,fseProcessEmail,allowUpload,autoProcess,config,batchName,batchSequence,processingWindowStartHr24,processingWindowLengthHr,PGPPassPhrase,PGPPrivateKeyFile,PGPPublicKeyFile,PGPKeyId,defaultUploadConfig,allowEmail,defaultFtpConfig,defaultBatchClass,repeating,allowFTP,repeatTime,repeatOptions,notifications,allowManual,comment,required,direction,ttlDays,schedulingOptions,runOn,repeatFor)
values(0,'*','','/mstrcfmod/CDR/batch/brokerStockingStatusSync.cfm','$BROKER_STOCKING_STATUS_SYNC','matt.wopperer@blacksmithapplications.com','chris.marrano@blacksmithapplications.com','N','Y',NULL,NULL,NULL,0,24,NULL,NULL,NULL,NULL,NULL,'N',NULL,'S','Y','N','6:30AM',NULL,'N','N',NULL,'N','IN','30',NULL,NULL,'select distinct ownerId, ownerType from fsenablers..tbl_APP_Configurations with (nolock) where applicationCode = ''1FSBSR'' and parameterName = ''apps.distributorSalesData.enabled'' and parameterValue = ''true'' and ownerType = ''MFR'' and ownerId > 0'
)
|