mysql 1292 - Truncated incorrect INTEGER

错误信息 1292 - Truncated incorrect INTEGER value: 'F161200101008'

源代码是这样的

INSERT INTO ca_pay_batch (
 BATCH_NO,
 BATCH_DATE
 , LOAN_CNT
, SUC_CNT
, FAIL_CNT
, AMOUNT_SUM
, STATUS
, CREATER
, UPDATE_TIME
, CREATE_TIME
) SELECT
    '' BATCH_NO,
    SYSDATE() BATCH_DATE,
    count( case when sd.loan_type='CF' and  IFNULL(c.SER_FIN_REBATE, 0)>0  then c.APP_CODE
when sd.loan_type='MF' then c.APP_CODE end
) LOAN_CNT,
    0 SUC_CNT,
    0 FAIL_CNT,
    sum(distinct c.R_LOAN_AMOUNT) AMOUNT_SUM,

    '0' STATUS,
    d.usernames CREATER,
    SYSDATE() UPDATE_TIME,
    SYSDATE() CREATE_TIME
FROM
     c
INNER JOIN tmp_print d ON c.APP_CODE = d.appno
 LEFT JOIN  SD ON