select m.bidMfrName, m.minimumCases, m.minimumLbs, m.defaultMfrDisclaimer, m.bidProcessingComments, m.mfrId from tbl_BID_Manufacturers m left outer join tbl_BID_partnerContacts pc on m.bidMfrId = pc.bidpartnerId and m.bidMfrContactId = pc.bidContactId where m.ownerId = 2 and m.ownerType = 'BRO' order by m.bidMfrName select bidMfrName, customerManager, minimumCases, minimumLbs, defaultMfrDisclaimer, bidProcessingComments from qmd_bidManufacturerProfileBRO2 select m.bidMfrName, m.minimumCases, m.minimumLbs, m.defaultMfrDisclaimer, m.bidProcessingComments, m.mfrId from tbl_BID_Manufacturers m left outer join tbl_BID_partnerContacts pc on m.bidMfrId = pc.bidpartnerId and m.bidMfrContactId = pc.bidContactId where m.ownerId = 14 and m.ownerType = 'BRO' order by m.bidMfrName select bidMfrName, customerManager, minimumCases, minimumLbs, defaultMfrDisclaimer, bidProcessingComments from qmd_bidManufacturerProfileBRO14 select m.bidMfrName, bidSku, overrideDesc, bidSkuDesc, bidPackSizeDesc, bidComments, includeCommentsOnQuote from tbl_BID_Skus bs left outer join tbl_PRD_Skus s on s.skuId = bs.skuId and s.ownerId = bs.ownerId and s.fsl_tablecode = bs.ownerType inner join tbl_BID_Manufacturers m on m.bidMfrId = bs.bidMfrId and m.ownerId = bs.ownerId and m.ownerType = bs.ownerType where bs.ownerId = 2 and bs.ownerType = 'BRO' and s.discontinued = 'N' order by bs.overridedesc desc, bs.bidSkuDesc select m.bidMfrName, bidSku, overrideDesc, bidSkuDesc, bidPackSizeDesc, bidComments, includeCommentsOnQuote from tbl_BID_Skus s inner join tbl_BID_Manufacturers m on m.bidMfrId = s.bidMfrId and m.ownerId = s.ownerId and m.ownerType = s.ownerType where s.ownerId = 14 and s.ownerType = 'BRO' order by s.overridedesc desc, s.bidSkuDesc theDir = GetDirectoryFromPath( GetCurrentTemplatePath() ); theLottFile = theDir & "Lott.xls"; theNEFile = theDir & "NE.xls"; theSheet = SpreadsheetNew( "BRO2 - MFR Profiles" ); SpreadsheetAddColumn( theSheet, "Name", 1, 1, true ); SpreadsheetAddColumn( theSheet, "Customer Manager", 1, 2, true ); SpreadsheetAddColumn( theSheet, "Min Cases", 1, 3, true ); SpreadsheetAddColumn( theSheet, "Min Lbs", 1, 4, true ); SpreadsheetAddColumn( theSheet, "Disclaimner", 1, 5, true ); SpreadsheetAddRows( theSheet, qmd_bidMFRProfileBRO2 ); theSheetTwo = SpreadsheetNew( "BRO14 - MFR Profiles" ); SpreadsheetAddColumn( theSheetTwo, "Name", 1, 1, true ); SpreadsheetAddColumn( theSheetTwo, "Customer Manager", 1, 2, true ); SpreadsheetAddColumn( theSheetTwo, "Min Cases", 1, 3, true ); SpreadsheetAddColumn( theSheetTwo, "Min Lbs", 1, 4, true ); SpreadsheetAddColumn( theSheetTwo, "Disclaimner", 1, 5, true ); SpreadsheetAddRows( theSheetTwo, qmd_bidMFRProfileBRO14 ); theSheetThree = SpreadsheetNew( "BRO2 - Bid Skus" ); SpreadsheetAddColumn( theSheetThree, "Bid Mfr Name", 1, 1, true ); SpreadsheetAddColumn( theSheetThree, "Bid Sku", 1, 2, true ); SpreadsheetAddColumn( theSheetThree, "Override Desc", 1, 3, true ); SpreadsheetAddColumn( theSheetThree, "Bid Desc", 1, 4, true ); SpreadsheetAddColumn( theSheetThree, "Bid Pack Size", 1, 5, true ); SpreadsheetAddColumn( theSheetThree, "Bid Sku Comments", 1, 6, true ); SpreadsheetAddColumn( theSheetThree, "Show Comments on reports?", 1, 7, true ); SpreadsheetAddRows( theSheetThree, qmd_bidSkusBRO2 ); theSheetFour = SpreadsheetNew( "BRO14 - Bid Skus" ); SpreadsheetAddColumn( theSheetFour, "Bid Mfr Name", 1, 1, true ); SpreadsheetAddColumn( theSheetFour, "Bid Sku", 1, 2, true ); SpreadsheetAddColumn( theSheetFour, "Override Desc", 1, 3, true ); SpreadsheetAddColumn( theSheetFour, "Bid Desc", 1, 4, true ); SpreadsheetAddColumn( theSheetFour, "Bid Pack Size", 1, 5, true ); SpreadsheetAddColumn( theSheetFour, "Bid Sku Comments", 1, 6, true ); SpreadsheetAddColumn( theSheetFour, "Show Comments on reports?", 1, 7, true ); SpreadsheetAddRows( theSheetFour, qmd_bidSkusBRO14 );