I'm getting this error when I populate the SHIPTOZIP field.

(FOC1470) TYPE CONVERSION FAILED FOR STATEMENT usp_RPT_TransactionList

TABLE FILE USP_RPT_TRANSACTIONLIST
PRINT
*
WHERE ( @I_BASEDATE EQ 2011/02/23 )
AND ( @I_AUTHDATE_TOKEN EQ YEAR|||0 )
AND ( @I_SHIPTOZIP EQ 80127 )
ON TABLE HOLD AS TRANSLIST1 FORMAT ALPHA
END

Master file

 
FIELDNAME=@I_SHIPTOZIP, ALIAS=P0063, USAGE=A10V, ACTUAL=A10VB,
      MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $

Does anyone know what could be the issue?

This message has been edited. Last edited by: Kerry,

(FOC1470) TYPE CONVERSION FAILED FOR STATEMENT %1%2%3%4
An attempt was made to execute a statement that was prepared and bound
with parameterized SQL using data that cannot be converted to the
datatype(s) specified at the time the statement was bound.

Perhaps you could check the master file, and compare to the table.

Also check the SQL being generated for any possible clues.

There was an error in the master file, missing an output paramater.