Not Tastewise Library Account
 update tbl_IMPORT_Tastewise1FSMapping set twc_id = null where twc_id = 'null' and eai_batchId = and ownerId = and ownerType = select twm.id, twm.eai_importId, twm.tastewise_id, twm.twc_id, twm.chain_name, twm.nameFound, twm.streetFound, twm.cityFound, twm.stateFound, twm.zipFound, 27 as countryId, opr.operatorId from tbl_IMPORT_Tastewise1FSMapping twm with (nolock) left outer join tbl_OPR_ClientOperators opr with (nolock) on opr.ownerId = twm.ownerId and opr.fsltablecode = twm.ownerType and opr.mfrCustNum = twm.tastewise_id where twm.eai_batchId = and twm.ownerId = and twm.ownerType = select top 1 territoryId from tbl_TER_Territories with (nolock) where ownerId = and fsl_tablecode = order by territoryId select cho_id, cho_name, tastewiseId from tbl_CHO_Operators with (nolock) where cho_id = select operatorId, mfrCustNum, fsl_choId from tbl_OPR_ClientOperators with (nolock) where ownerId = and fsltablecode = and fsl_choId = and nullif( mfrCustNum, '' ) is null insert into tbl_OPR_ClientOperators( ownerId, fsltablecode, mfrCustNum, companyName, address, address2, countryId, city, state, zipcode, parentMFRCustNum, parentMFRCustName, recordSource, lastImportSource, territoryId, fsl_choId, crmActive, dateCreated, lastUpdated ) values ( , , , , , null, , , , , , , , , , , 'Y', , ) update tbl_OPR_ClientOperators set mfrCustNum = , parentMFRCustNum = , parentMFRCustName = where ownerId = and fsltablecode = and operatorId = update tbl_CHO_Operators set tastewiseId = ,tastewiseIdMethod = 'BATCH' ,tastewiseIdDate = where cho_id = update tbl_IMPORT_Tastewise1FSMapping set fse_status = where ownerId = and ownerType = and eai_batchId = and eai_importId =

Tastewise 1FS Mapping Import Results

Records Imported: #lsnumberformat( _importCount )#
New Mappings: #lsnumberformat( _insMappingCount )#
Not Mapped: #lsnumberformat( _notMappedCount )#
Updated Mappings: #lsnumberformat( _updMappingCount )#
Added Queued: #lsnumberformat( _addedQueued )#
Existing Mappings: #lsnumberformat( _existingOperators )#
 select state from tbl_UT_States with (nolock) where stateFull = and countryId = select countryId from tbl_UT_Countries with (nolock) where country =