select formatName from tbl_EAI_InboundFileFormats with (nolock) order by formatName
Format Name :
select formatId,ownerId,ownerType, formatName,stagingTable,delimeter, usageComments, defaultFileProcessor, defaultFileName,masterFormatName from tbl_EAI_InboundFileFormats where formatName like select b.broker_id as pkId, b.broker_name as companyName from tblBrokers b where b.broker_id = order by broker_name select c.cho_id as pkId, c.cho_name as companyName from tbl_CHO_Operators c where c.cho_id = order by cho_name select d.dstId as pkId, d.dstName as companyName from tbl_DST_Distributors d where d.dstId = order by dstName select m.mfr_id as pkId, m.mfr_name as companyName from tblManufacturers m where m.mfr_id = order by mfr_name select userId as pkId, company as companyName from tbl_MSC_FSLibraryUsers where userId in (227,228) --->
Owner Name Owner Type Staging Table Delimiter Default File Processor Default File Name Master Format Name Format Usage Comments
#ownerName# #ownerTypeFull# #stagingTable# #delimeter# #defaultFileProcessor# #defaultFileName# #masterFormatName# #usageComments#
--->