OPTIONS(ERRORS=-1,ROWS=100)
LOAD DATA
CHARACTERSET UTF8
INFILE '$INFILE'
BADFILE '$BADFILE'
APPEND INTO TABLE TB_E2E_IBP_ORDER_RECEIVE
FIELDS TERMINATED BY '#@&@#'
trailing NULLCOLS 
(
  CUST_ORDER_ID,
  VERSION_ID,
  IBP_RECEIVE_CRM_TIME "to_date(:IBP_RECEIVE_CRM_TIME,'YYYY-MM-DD HH24:MI:SS')",
  FILE_TIME "to_date('$FILE_TIME','YYYY-MM-DD HH24:MI:SS')"
)