select ff.fieldName, ff.stagingColumn, ff.sequence, ff.stagingTransformFn from tbl_EAI_inboundFileFormatFields ff inner join tbl_EAI_inboundFileFormats f on f.formatId = ff.formatId where f.formatId = and f.formatName = order by ff.sequence

The following ePOD import mapping has been newly created or changed. Before this batch and others using the same format can be fully processed the mapping needs to be reviewed and confirmed as accurate.

Select confirm to confirm the import mapping and click submit. This will cause the batch to continue (and others like it)

To reject the mapping / mapping change, click reject and them click submit. This will cause the batch to cancel (and others like it). Not ePOD data will be imported for the claim

select * from tbl_IMPORT_ProofOfDelivery where eai_batchId = and ownerId = and ownerType = order by eai_lineNumber
select fld.fieldName, fld.stagingColumn, fld.usageComments from tbl_EAI_inboundFileFormats fmt inner join tbl_EAI_inboundFileFormatFields fld on fld.formatId = fmt.formatId where fmt.formatName = 'TPM_PROOF_OF_DELIVERY_XLSX' and fmt.ownerType = 'MFR' and fmt.ownerId = 0 and fld.stagingColumn =
Unconfirmed Mapping download raw source file
<<< Proposed Data Mapping (#min( _maxSampleDataRows, qmd_import.recordCount)# of #qmd_import.recordCount# rows) >>>
Source Mapping Row #_r#
CALCULATED#htmleditformat( fieldName )# #htmleditformat( qmd_masterformatFieldNames.fieldName )##htmleditformat( stagingColumn )# ignore #htmleditformat( qmd_import[_stagingColumn][_r])# ignored
select s.importMappingApprover from tbl_tpm_settings s with (nolock) where s.ownerId = and s.ownerType = --->
select m.firstname + ' ' + m.lastname as approverName from tbl_fspro_members m with (nolock) where m.ownerid = 21 and m.fsl_tablecode = 'MSC' and m.fspro_userid in ()

This format must be reviewed by an approver, #_approverNames#