OPTIONS(ERRORS=-1,ROWS=100)
LOAD DATA
CHARACTERSET UTF8
INFILE '$INFILE'
BADFILE '$BADFILE'
APPEND INTO TABLE TB_E2E_IBP_ORDER
FIELDS TERMINATED BY '#@&@#'
trailing NULLCOLS 
(
  PRODUCT_NAME, 
  VERSION_NUM, 
  P6_ID, 
  CUST_ORDER_ID, 
  ORDER_CREATE_TIME "to_date(:ORDER_CREATE_TIME,'YYYY-MM-DD HH24:MI:SS')", 
  FLOW_NAME, 
  TASK_NAME, 
  EQUIPMENT_NUM, 
  TRADE_TYPE, 
  TRADE_SUB_TYPE, 
  DISTICT_BUREAU, 
  PART_BUREAU, 
  TASK_START_TIME "to_date(:TASK_START_TIME,'YYYY-MM-DD HH24:MI:SS')", 
  P6_STATUS, 
  ORDER_STATUS, 
  TAG_TYPE, 
  SYSTEM_NAME, 
  SUB_SYSTEM, 
  WOP_ORDER_NUM, 
  IBP_SEND_OUTSYS_TIME "to_date(:IBP_SEND_OUTSYS_TIME,'YYYY-MM-DD HH24:MI:SS')", 
  IBP_RECEIVE_CRM_TIME "to_date(:IBP_RECEIVE_CRM_TIME,'YYYY-MM-DD HH24:MI:SS')", 
  TASK_ID, 
  ORDER_PROC_STATUS,
  CRM_VERSION,
  P6_VERSION,
  PRODUCT_NUM,
  PRODUCT_TYPE,
  ACCESS_TYPE,
  CLIENT_TYPE,
  FILE_TIME "to_date('$FILE_TIME','YYYY-MM-DD HH24:MI:SS')"
)