select formatName, usageComments from tbl_EAI_InboundFileFormats where formatId = select fieldName,stagingcolumn,sequence,usageComments, fieldDataType, fieldLength,required from tbl_EAI_InboundFileFormatFields where formatId = Order by sequence select formatName, usageComments from tbl_EAI_InboundFileFormats where formatId =

--->

select fmt.formatId, fld.fieldId, fld.fieldName, fld.stagingColumn, fld.usageComments, fld.sequence,fld.fieldFormatRegEx,fld.fieldDataType,fld.fieldLength from tbl_EAI_inboundFileFormats fmt inner join tbl_EAI_inboundFileFormatFields fld on fld.formatId = fmt.formatId where fmt.formatId = and (fmt.ownerType = OR fmt.ownerType = ) and fmt.ownerId in (0)---> and fld.stagingColumn not like 'void' order by fld.sequence select fieldName,stagingcolumn,sequence,usageComments, stagingTransformFn, fieldFormatRegEx,fieldDataType,fieldLength,required from tbl_EAI_InboundFileFormatFields where formatId = and fieldName =

Sequence	File Column Name	Staging Column Name	Staging Column Type	Staging Column Length	Required	Notes	Test Value	Reg. Exp.	Transform Function	Transformed Value

						--->