/*
 *========================================================================
 *
 *    : AZN_PLAZA_LANE APP
 *      : db_sel_sql.h
 *      : JBY (baarong@neighbor21.co.kr)
 *      : 2018.07.13
 *      : 
 *        : DB Table  slect       
 *
 *========================================================================
*/

#ifndef  _DB_SEL_SQL
#define  _DB_SEL_SQL

/***************************************************************************
   TBLT01M :   B/L
***************************************************************************/
#define S_TBLT01M    "SELECT NVL(CDBH,' ') CDBH, NVL(SAYU, 0) SAYU FROM TBLT01M"

/***************************************************************************
   TBLT02M :  B/L 
***************************************************************************/
#define S_TBLT02M    "SELECT NVL(CDBH,' ') CDBH, NVL(CDVS, 0) CDVS, NVL(CDCD, 0) CDCD, NVL(SAYU, 0) SAYU FROM TBLT02M"

/***************************************************************************
   BLTM_VOIDEXMDC : /  B/L -ok
***************************************************************************/
#define bb    "SELECT NVL(CRD_NO,' ') CDBH, NVL(BL_CAUS, 0) SAYU FROM BLTM_VOIDEXMDC"

/***************************************************************************
   TBLT04M : / B/L 
***************************************************************************/
#define S_TBLT04M    "SELECT NVL(CDBH,' ') CDBH, NVL(CDVS, 0) CDVS, NVL(CDCD, 0) CDCD, NVL(SAYU, 0) SAYU FROM TBLT04M"

/***************************************************************************
   TBLT05M :   B/L
***************************************************************************/
#define S_TBLT05M    "SELECT NVL(CDBH,' ') CDBH, NVL(SAYU, 0) SAYU FROM TBLT05M"

/***************************************************************************
   TBLT06M :  B/L 
***************************************************************************/
#define S_TBLT06M    "SELECT NVL(CDBH,' ') CDBH, NVL(CDVS, 0) CDVS, NVL(CDCD, 0) CDCD, NVL(SAYU, 0) SAYU FROM TBLT06M"

/***************************************************************************
   BLTM_VOIDSMARTCD :   B/L -ok
***************************************************************************/
#define S_BLTM_VOIDSMARTCD    "SELECT NVL(MNGT_NO, 0) SEQ, NVL(BL_ECRD,' ') SCBH, NVL(BL_CAUS,' ') SAYU FROM BLTM_VOIDSMARTCD"

/***************************************************************************
   BLTM_VOIDSMARTCDB :  B/L  -ok
***************************************************************************/
#define S_BLTM_VOIDSMARTCDB    "SELECT NVL(MNGT_NO, 0) SEQ, NVL(BL_ECRD_NO,' ') SCBH, NVL(RVS_NO, 0) SCVS, NVL(CODE,' ') SCCD, \
NVL(BL_CAUS,' ') SAYU, NVL(MODF_DT,' ') SJDT FROM BLTM_VOIDSMARTCDB"

/***************************************************************************
   BLTM_DCCD :   B/L -ok          
***************************************************************************/
#define S_BLTM_DCCD    "SELECT NVL(CRD_NO,' ') CDBH, NVL(BL_CAUS, 0) SAYU FROM BLTM_DCCD"

/***************************************************************************
   TBLT10M :  B/L 
***************************************************************************/
#define S_TBLT10M    "SELECT NVL(CDBH,' ') CDBH, NVL(CDVS, 0) CDVS, NVL(CDCD, 0) CDCD, NVL(SAYU, 0) SAYU FROM TBLT10M"

/***************************************************************************
   TRFM_VOIDCD :   B/L -ok
***************************************************************************/
#define S_TRFM_VOIDCD    "SELECT NVL(SEQ, 0) SEQ, NVL(CDSA,' ') CDSA, NVL(BNCD,' ') BNCD, NVL(CDBH,' ') CDBH FROM TRFM_VOIDCD"

/***************************************************************************
   TRFM_VOIDCD_ :   B/L 
***************************************************************************/
#define S_TRFM_VOIDCD_    "SELECT NVL(SEQ, 0) SEQ, NVL(CDSA,' ') CDSA, NVL(CDBH,' ') CDBH, NVL(CRGB,' ') CRGB, NVL(CRDT,' ') CRDT FROM TRFM_VOIDCD_"

/***************************************************************************
   TRFM_VOIDCDB :  B/L  -ok
***************************************************************************/
#define S_TRFM_VOIDCDB    "SELECT NVL(SEQ, 0) SEQ, NVL(CDSA,' ') CDSA, NVL(BNCD,' ') BNCD, NVL(CDBH,' ') CDBH, NVL(CRGB,' ') CRGB, \
NVL(CRDT,' ') CRDT FROM TRFM_VOIDCDB"

/***************************************************************************
   BLTM_VOIDOBU :  OBU  -ok
***************************************************************************/
#define S_BLTM_VOIDOBU    "SELECT NVL(OBU_NO,' ') OBBH, NVL(BL_CAUS, 0) SAYU FROM BLTM_VOIDOBU"

/***************************************************************************
   BLTM_VOIDOBUB :  OBU  -ok
***************************************************************************/
#define S_BLTM_VOIDOBUB    "SELECT NVL(OBU_NO,' ') OBBH, NVL(RVS_NO, 0) CDVS, NVL(YN_CODE, 0) CDCD, NVL(BL_CAUS, 0) SAYU FROM BLTM_VOIDOBUB"

/***************************************************************************
   IMGL_VIOCD : BL() -ok
***************************************************************************/
#define S_IMGL_VIOCD    "SELECT NVL(DATETIME,' ') DATETIME, NVL(CARNUM,' ') CARNUM, NVL(LANE,' ') LANE, NVL(IC_CODE,' ') IC_CODE , \
NVL(NONPAVMENT,' ') NONPAVMENT, NVL(NONPAVMENTCNT,' ') NONPAVMENTCNT, NVL(FILEPATH,' ') FILEPATH FROM IMGL_VIOCD"

/***************************************************************************
   IMGL_VIOCDM : BL  () -ok
***************************************************************************/
#define S_IMGL_VIOCDM    "SELECT NVL(CAR_NO,' ') CANO, NVL(UPID_MNY,' ') MNKM, NVL(UPID_CNT,' ') MNCN, NVL(UNC_TYP,' ') JBYH FROM IMGL_VIOCDM"

/***************************************************************************
   IMGL_VIOCDB : BL  () -ok
***************************************************************************/
#define S_IMGL_VIOCDB    "SELECT NVL(KMDT,' ') KMDT, NVL(CANO,' ') CANO, NVL(MNKM,' ') MNKM, NVL(MNCN,' ') MNCN, NVL(JBYH,' ') JBYH, \
NVL(CRGB,' ') CRGB FROM IMGL_VIOCDB"

/***************************************************************************
   PUBM_CODEBIG : ¬Ù   -ok
***************************************************************************/
#define S_PUBM_CODEBIG    "SELECT NVL(MAJOR_CODE,' ') DBCD, NVL(MAJOR_CODE_NM,' ') DCNM, NVL(MAJOR_CODE_DESC,' ') DCSM, NVL(MAJOR_CODE_YN,' ') DCYN FROM PUBM_CODEBIG"

/***************************************************************************
   PUBM_CODESMALL : ¬Ù   -ok
***************************************************************************/
#define S_PUBM_CODESMALL    "SELECT NVL(MAJOR_CODE,' ') DBCD, NVL(SUB_CODE,' ') SBCD, NVL(MAJOR_SUB_CODE,' ') DSCD, NVL(SUB_CODE_NM,' ') SCNM, NVL(SUB_CODE_DESC,' ') SCSM, \
NVL(SUB_ADD,' ') SBYA, NVL(SORT_ORDR, 0) JYSS, NVL(SUB_CODE_YN,' ') SCYN FROM PUBM_CODESMALL"

/***************************************************************************
   PUBM_POST :    -ok
***************************************************************************/
#define S_PUBM_POST    "SELECT NVL(ZIP_CODE,' ') ZIPCODE, NVL(SNO,' ') SEQNO, NVL(SI_DO,' ') SIDO, NVL(GU_GUN,' ') GUGUN, NVL(E_M_D,' ') DOSU, \
NVL(ADDRESS,' ') BUNJI FROM PUBM_POST"

/***************************************************************************
   TCSCR01 : / / ()
***************************************************************************/
#define S_TCSCR01    "SELECT NVL(CARD_NO,' ') CARD_NO, NVL(CARD_KIND,' ') CARD_KIND, NVL(TYPE,' ') TYPE, \
NVL(SOURCE,' ') SOURCE, NVL(F_CARD_NO,' ') F_CARD_NO, NVL(O_CARD_NO,' ') O_CARD_NO, NVL(DEPT,' ') DEPT, \
NVL(GRADE,' ') GRADE, NVL(PERSONAL_NO,' ') PERSONAL_NO, NVL(NAME,' ') NAME, NVL(REGI_NO,' ') REGI_NO, \
NVL(NAME2,' ') NAME2, NVL(REGI_NO2,' ') REGI_NO2, NVL(NAME3,' ') NAME3, NVL(REGI_NO3,' ') REGI_NO3, \
NVL(NAME4,' ') NAME4, NVL(REGI_NO4,' ') REGI_NO4, NVL(CAR_NO,' ') CAR_NO, NVL(ISSUE_DATE,' ') ISSUE_DATE, \
NVL(END_YYYYMM,' ') END_YYYYMM, NVL(BJ_CODE,' ') BJ_CODE, NVL(BJ_DATE_F,' ') BJ_DATE_F, NVL(BJ_DATE_T,' ') BJ_DATE_T, \
NVL(REQ_OFFICE,' ') REQ_OFFICE, NVL(ADDR,' ') ADDR, NVL(TEL,' ') TEL, NVL(DISPLACEMENT, 0) DISPLACEMENT, \
NVL(CAR_CLASS,' ') CAR_CLASS, NVL(STATUS,' ') STATUS, NVL(UPDATE_DATE,' ') UPDATE_DATE, NVL(UPDATE_DEPT,' ') UPDATE_DEPT, \
NVL(TRANSE_YN,' ') TRANSE_YN, NVL(TRANSE_YN_2,' ') TRANSE_YN_2, NVL(TRANSE_YN_3,' ') TRANSE_YN_3, NVL(TRANSE_YN_4,' ') TRANSE_YN_4, \
NVL(TRANSE_YN_5,' ') TRANSE_YN_5, NVL(TRANSE_YN_6,' ') TRANSE_YN_6 FROM TCSCR01"

/***************************************************************************
   PUBM_DAYEND :   -ok
***************************************************************************/
#define S_PUBM_DAYEND    "SELECT NVL(PLZ_ID,' ') PLID, NVL(FSH_DATE,' ') IMDT, NVL(DAY_FSH_DIV_CD,' ') IMGB, NVL(MODF_NO, 0) SJBH, NVL(WRKR_NO,' ') KJBH, \
NVL(DATE_STRT_TM,' ') DSTI, NVL(DATE_END_TM,' ') DETI, NVL(CSH_CNT, 0) HKCN, NVL(COL_RCT_CSH, 0) HKKM, NVL(CSH_EXC_CNT, 0) EXCN, NVL(CSH_EXC_MNY, 0) EXKM, NVL(SAL_CHRG_CNT, 0) PCCN, \
NVL(SAL_CHRG_MNY, 0) PCKM, NVL(RFND_CNT, 0) HBCN, NVL(RFNE_MNY, 0) HBKM, NVL(EXMT_CRD_CNT, 0) MJCD, NVL(EXMT_BUT_CNT, 0) MJBT, NVL(BNCH_EXMT_HND_CNT, 0) BMDS, NVL(UPID_MNY_CNT, 0) MNDS, \
NVL(UPID_MNY, 0) MNKM, NVL(SUM_RCT_PASS_FARE, 0) TOKM FROM PUBM_DAYEND"

/***************************************************************************
   PUBL_DAYENDMODIFY :   -ok
***************************************************************************/
#define S_PUBL_DAYENDMODIFY    "SELECT NVL(WRK_DATE,' ') KMDT, NVL(PLZ_ID,' ') PLID, NVL(WRKR_NO,' ') KJBH, NVL(MODF_ITM,' ') SJHM, \
NVL(MODF_CAUS,' ') SJSU, NVL(MODF_NO, 0) SJBH, NVL(HND_TM,' ') HHBB FROM PUBL_DAYENDMODIFY"

/***************************************************************************
   PUBL_EARNOTHER :   -ok
***************************************************************************/
#define S_PUBL_EARNOTHER    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(MODF_TM,' ') SJDT, NVL(WRKR_NO,' ') KJBH, \
NVL(DIV,' ') SIGB, NVL(MNY, 0) KMAK, NVL(NOTE,' ') BIGO, NVL(VAT, 0) BGKM, NVL(IO_MNY_DIV,' ') ICGB, NVL(WRK_NO,' ') KMBH, \
NVL(ADMIN_NO,' ') GJBH FROM PUBL_EARNOTHER"

/***************************************************************************
   TDED04S : (/)
***************************************************************************/
#define S_TDED04S    "SELECT NVL(CGDT,' ') CGDT, NVL(PLID,' ') PLID, NVL(BCGS, 0) BCGS, NVL(BSCM, 0) BSCM, \
NVL(HCGS, 0) HCGS, NVL(HCKM, 0) HCKM, NVL(SSCG, 0) SSCG, NVL(SSCM, 0) SSCM, NVL(MGCG, 0) MGCG, NVL(MGCM, 0) MGCM, \
NVL(RPCM, 0) RPCM, NVL(RPHM, 0) RPHM, NVL(BJGS, 0) BJGS, NVL(BJKM, 0) BJKM, NVL(HJGS, 0) HJGS, NVL(HJKM, 0) HJKM, \
NVL(CSXG, 0) CSXG, NVL(CSXM, 0) CSXM, NVL(MGJG, 0) MGJG, NVL(MGJM, 0) MGJM, NVL(RJGC, 0) RJGC, NVL(RJMH, 0) RJMH, \
NVL(HGCM, 0) HGCM, NVL(HGJM, 0) HGJM, NVL(JJGS, 0) JJGS, NVL(JJKM, 0) JJKM, NVL(BSGS, 0) BSGS, NVL(BSKM, 0) BSKM, \
NVL(RPGS, 0) RPGS, NVL(RPKM, 0) RPKM, NVL(JXGS, 0) JXGS, NVL(JXKM, 0) JXKM, NVL(GSSM, 0) GSSM, NVL(TOTM, 0) TOTM, \
NVL(JSDT,' ') JSDT, NVL(JEDT,' ') JEDT, NVL(JSYI,' ') JSYI, NVL(JJYI,' ') JJYI, NVL(SNDF,' ') SNDF FROM TDED04S"

/***************************************************************************
   EXTS_PAYLOAD : (/) -ok
***************************************************************************/
#define S_EXTS_PAYLOAD    "SELECT NVL(RQ_DT,' ') CGDT, NVL(PLZ_ID,' ') PLID, NVL(CHRG_RQ_CNT_PLZ, 0) CCGH, NVL(CHRG_RQ_MNY_PLZ, 0) CCMH, \
NVL(CHRG_RQ_CNT_LANE, 0) CCGC, NVL(CHRG_RQ_MNY_LANE, 0) CCMC, NVL(CHRG_RQ_CNT_CCRD, 0) CCGS, NVL(CHRG_RQ_MNY_CCRD, 0) CCMS, NVL(CHRG_RQ_CNT_MILG, 0) CCGM, NVL(CHRG_RQ_MNY_MILG, 0) CCMM, \
NVL(PAY_HND_CNT, 0) JCGS, NVL(PAY_HND_MNY, 0) JBKM, NVL(CHRG_CALC_CNT_PLZ, 0) CJGH, NVL(CHRG_CALC_MNY_PLZ, 0) CJMH, NVL(CHRG_CALC_CNT_LANE, 0) CJGC, NVL(CHRG_CALC_MNY_LANE, 0) CJMC, \
NVL(CHRG_CALC_CNT_CCRD, 0) CJGS, NVL(CHRG_CALC_MNY_CCRD, 0) CJMS, NVL(CHRG_CALC_CNT_MILG, 0) CJGM, NVL(CHRG_CALC_MNY_MILG, 0) CJMM, NVL(CHRG_CALC_MNY_SUM, 0) CJMT, NVL(CHRG_CALC_EXTR_MNY, 0) CJJM, \
NVL(PAY_CALC_CNT, 0) JJGS, NVL(PAY_CALC_MNY, 0) JJKM, NVL(SNBCK_CODE, 0) BSGS, NVL(SNBCK_MNY, 0) BSKM, NVL(RE_HND_CNT, 0) RCGS, NVL(RE_HND_MNY, 0) RCKM, \
NVL(CALC_NOT_CNT, 0) JXGS, NVL(CAKC_NOT_MNY, 0) JXKM, NVL(CALC_FEE, 0) SSKM, NVL(TOT_PAY, 0) CJKM, NVL(CALC_STRT-DATE,' ') JSDT, NVL(CALC_END_DATE,' ') JEDT, \
NVL(CALC_WEEK,' ') JSYI, NVL(AGG_CALC_WEEK,' ') JJYI, NVL(SND_FLAG,' ') SNDF, NVL(CHRG_CALC_CNT, 0) CJSC FROM EXTS_PAYLOAD"

/***************************************************************************
   TDED06S : 
***************************************************************************/
#define S_TDED06S    "SELECT NVL(CGDT,' ') CGDT, NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KJBH,' ') KJBH, \
NVL(IRBH,' ') IRBH, NVL(SMID,' ') SMID, NVL(CDNO,' ') CDNO, NVL(GRKM,' ') GRKM, NVL(GRTY,' ') GRTY, NVL(GRDT,' ') GRDT, \
NVL(CRST,' ') CRST, NVL(BSCD,' ') BSCD, NVL(BSSU,' ') BSSU, NVL(RCDT,' ') RCDT, NVL(RCTI,' ') RCTI, NVL(RCSU,' ') RCSU, \
NVL(RCCD,' ') RCCD FROM TDED06S"

/***************************************************************************
   PUBL_DAYENDINFO :   -ok
***************************************************************************/
#define S_PUBL_DAYENDINFO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') IMDT, NVL(DAY_FSH_DIV_CD,' ') IMGB, NVL(WRKR_NO,' ') KJBH, \
NVL(DAY_FSH_TM_X,' ') DSTI, NVL(DAY_FSH_TM,' ') DETI, NVL(CSH_CNT, 0) HKCN, NVL(COL_RCT_CSH, 0) HKKM, NVL(CSH_EXC_CNT, 0) EXCN, NVL(CSH_EXC_MNY, 0) EXKM, \
NVL(SAL_CHRG_CNT,  0) PCCN, NVL(SAL_CHRG_MNY,  0) PCKM, NVL(RFND-CNT, 0) HBCN, NVL(RFND_MNY, 0) HBKM, NVL(EXMT_CRD_CNT, 0) MJCD, NVL(EXMT_BUT_CNT, 0) MJBT, \
NVL(BNCH_EXMT_HND_CNT,  0) BMDS, NVL(UPID_MNY_CNT,  0) MNDS, NVL(UPID_MNY, 0) MNKM, NVL(SUM_RCT_PASS_FARE, 0) TOKM FROM PUBL_DAYENDINFO"

/***************************************************************************
   TEMP_SMCD : Í¨()
***************************************************************************/
#define S_TEMP_SMCD    "SELECT NVL(YCCD,' ') YCCD, NVL(YHGB,' ') YHGB, NVL(CDNM,' ') CDNM FROM TEMP_SMCD"

/***************************************************************************
   TEMP_PUBM_CODESMALL : ¬Ù  ()
***************************************************************************/
#define S_TEMP_PUBM_CODESMALL    "SELECT NVL(DBCD,' ') DBCD, NVL(SBCD,' ') SBCD, NVL(DSCD,' ') DSCD, \
NVL(SCNM,' ') SCNM, NVL(SCSM,' ') SCSM,  NVL(SBYA,' ') SBYA, NVL(JYSS,  0) JYSS, NVL(SCYN,' ') SCYN FROM TEMP_PUBM_CODESMALL"

/***************************************************************************
   EXTL_SENDRECV :  -ok
***************************************************************************/
#define S_EXTL_SENDRECV    "SELECT NVL(CO_ID,' ') YGID, NVL(CALC_DATE,' ') JSDT, NVL(TRAD_DATE,' ') CRDT, NVL(FILE_NM,' ') FLNM, \
NVL(FILE_DIV,' ') FLGB, NVL(HND_CNT, 0) CRDS, NVL(TRAD_DIV,' ') CRGB, NVL(TRAD_RSLT,' ') RSLT, NVL(PLZ_ID,' ') PLID, NVL(CRD_CO,' ') CDSA, \
NVL(HND_PLZ_ID,' ') CPLID, NVL(WRKR_ID,' ') KJBH FROM EXTL_SENDRECV"

/***************************************************************************
   TRFS_TOTSEND :  -ok
***************************************************************************/
#define S_TRFS_TOTSEND    "SELECT NVL(CALC_DATE,' ') JSDT, NVL(CALC_ORGN,' ') JSGG, NVL(SNDRCV_DIV,' ') SSGB, NVL(CRD_CO,' ') CDSA, \
NVL(RQ_CNT_SUM, 0) CGGS, NVL(QR_FARE_SUM, 0) CGKM, NVL(CALC_CNT_SUM, 0) JSGS, NVL(CALC_FARE_SUM, 0) JSKM, NVL(SNBCK_CNT_SUM, 0) BSGS, NVL(SNBCK_FARE_SUM, 0) BSKM, \
NVL(DEC_IMP_SUM, 0) HJSI, NVL(DEC_FEE, 0) HFEE FROM TRFS_TOTSEND"

/***************************************************************************
   TRFL_BCKSEND : () -ok
***************************************************************************/
#define S_TRFL_BCKSEND    "SELECT NVL(PLID,' ') PLID, NVL(JSDT,' ') JSDT, NVL(JSGG,' ') JSGG, NVL(KMDT,' ') KMDT, \
NVL(KMBH,' ') KMBH, NVL(CRNO, 0) CRNO, NVL(CDBH,' ') CDBH, NVL(ERCD,' ') ERCD, NVL(CRDT,' ') CRDT, NVL(THYK, 0) THYK, \
NVL(GJKM, 0) GJKM, NVL(GHKM, 0) GHKM, NVL(CDTY,' ') CDTY, NVL(JJFL,' ') JJFL, NVL(JCDT,' ') JCDT, NVL(JSYN,' ') JSYN, \
NVL(CDSA,' ') CDSA FROM TRFL_BCKSEND"

/***************************************************************************
   TRFL_TOTCDC :  () -ok kmbh  
***************************************************************************/
#define S_TRFL_TOTCDC    "SELECT NVL(PLID,' ') PLID, NVL(JSDT,' ') JSDT, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, \
NVL(CRNO, 0) CRNO, NVL(CDSA,' ') CDSA, NVL(CDBH,' ') CDBH, NVL(THYK, 0) THYK, NVL(GJKM, 0) GJKM, NVL(GHKM, 0) GHKM, \
NVL(ERCD,' ') ERCD, NVL(GRYH,' ') GRYH, NVL(CRTY,' ') CRTY, NVL(CRDT,' ') CRDT, NVL(DMBH,' ') DMBH, NVL(YGGB,' ') YGGB, \
NVL(YSYT,' ') YSYT, NVL(CDYH,' ') CDYH, NVL(KJBH,' ') KJBH, NVL(ALGID,' ') ALGID, NVL(PSAMID,' ') PSAMID, NVL(GMDT,' ') GMDT, \
NVL(TRTPSAM,' ') TRTPSAM, NVL(PPIEP,' ') PPIEP, NVL(IEP,' ') IEP, NVL(NTIEP,' ') NTIEP, NVL(NTPSAM,' ') NTPSAM, \
NVL(MTOTPSAM,' ') MTOTPSAM, NVL(NIPP,' ') NIPP, NVL(NC,' ') NC, NVL(VKPSAM1,' ') VKPSAM1, NVL(SINDC1,' ') SINDC1, \
NVL(VKPSAM2,' ') VKPSAM2, NVL(SINDC2,' ') SINDC2, NVL(IDCENTER,' ') IDCENTER, NVL(JJDT,' ') JJDT, NVL(RSLT,' ') RSLT FROM TRFL_TOTCDC"

/***************************************************************************
   EXTL_SCLOAD :   () -ok
***************************************************************************/
#define S_EXTL_SCLOAD    "SELECT NVL(CALC_DATE,' ') JSDT, NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, \
NVL(WRKR_NO,' ') KJBH, NVL(SNO, 0) ILBH, NVL(ADMIN_NO,' ') KJID, NVL(OCC_DATE,' ') GRDT, NVL(CSTRM_CRD_NO,' ') CDBH, NVL(AGORZ_ID,' ') AGID, \
NVL(KEY_VER,' ') KEYV, NVL(CSTRM_CRD_SNO,' ') CDIL, NVL(LSAM_TRAD_SNO,' ') LMIL, NVL(CSTRM_CRD_NS,' ') CDRN, NVL(LSAM_NS,' ') LMRN, NVL(CO_ID,' ') BHGG, \
NVL(CSTRM_CRD_ID,' ') CDID, NVL(LSAM_ID,' ') LMID, NVL(BE_CHRG_BALC, 0) CJJK, NVL(CHRG_BALC,' ') CHJK, NVL(PAN,' ') PAND, NVL(CENTER_ID,' ') CTID, \
NVL(CRD_CO_ID,' ') CDGU, NVL(CRD_SIGN,' ') CDSI, NVL(LSAM_SIGN,' ') LMSI, NVL(TRAD_MNY, 0) GRKM, NVL(CHRG_EXTR_MNY, 0) HJKM, NVL(EXTR_RTE,' ') HJPE, \
NVL(RCT_TYP,' ') SNYH, NVL(CHRG_CANCL,' ') CJDT FROM EXTL_SCLOAD"

/***************************************************************************
   EXTL_SCCARD : TCS  (  -ok
***************************************************************************/
#define S_EXTL_SCCARD    "SELECT NVL(RQ_DT,' ') CKDT, NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, \
NVL(WRKR_NO,' ') KJBH, NVL(HND_SNO,  0) CRNO, NVL(AXLE_CODE,' ') CSCD, NVL(HND_TM,' ') CRTM, NVL(COL_PASS_FARE,   0) JSYM , NVL(WOUT_MNY,    0) CMKM  , \
NVL(WOUT_CRD_BALC,  0) CJCM, NVL(DC_RTE,' ') JBHI, NVL(RCT_DIV,' ') SNGB, NVL(CRD_KND,' ') CDGB, NVL(CAR_KND, ' ') CHJO , NVL(CRD_NO,  ' ') CDBH  , \
NVL(PAY_HND_DIV,' ') JCGB, NVL(DC_CRD_NO,' ') MCBH, NVL(LNK_DIV,' ') YKGB, NVL(OBU_NO,' ') DMBH, NVL(AGORZ_ID,' ') ALGID, NVL(PSAM_ID,' ') PSAMID, \
NVL(PCHA_DATE,' ') GMDT, NVL(TRAD_TYP,' ') TRTPSAM, NVL(ET_MNY_CO_ID,' ') PPIEP, NVL(ET_MNY_ID,' ') IEP, NVL(ET_MNY_TRAD_SNO,' ') NTIEP, NVL(TRAD_SNO,' ') NTPSAM, \
NVL(TRAD_SUM,' ') MTOTPSAM, NVL(ET_CO_TRAD_NO,' ') NIPP, NVL(DEAL_CLCT_SNO,' ') NC, NVL(PSAM_TRAD_SIGN1,' ') VKPSAM1, NVL(PSAM_CRT_SIGN1,' ') SINDC1, \
NVL(PSAM_TRAD_SIGN2,' ') VKPSAM2, NVL(PSAM_CRT_SIGN2,' ') SINDC2, NVL(ID_CENTER,' ') IDCENTER, NVL(LANE_DIV,' ') LNGB, NVL(INT_CALC_DATE,' ') CJDT FROM EXTL_SCCARD"

/***************************************************************************
   EXTL_BCKSEND :  () -@@  //¥ê       . sql   ...
***************************************************************************/
#define S_EXTL_BCKSEND    "SELECT NVL(CKDT,' ') CKDT, NVL(PLID,' ') PLID, NVL(PMTI,' ') PMTI, NVL(CDTY,' ') CDTY, \
NVL(CDBH,' ') CDBH, NVL(PMGB,' ') PMGB, NVL(PMTY,' ') PMTY, NVL(PMSS, 0) PMSS, NVL(JBSD,' ') JBSD, \
NVL(SYCD,' ') SYCD, NVL(SIBH,' ') SIBH, NVL(CSID,' ') CSID, NVL(SKJBH,' ') SKJBH, NVL(PCKM, 0) PCKM, \
NVL(ONOF,' ') ONOF, NVL(GMMG,' ') GMMG, NVL(JPMC,' ') JPMC, NVL(KMDT,' ') KMDT FROM EXTL_BCKSEND"

/***************************************************************************
   TEXT08T :    -@@
***************************************************************************/
#define S_TEXT08T    "SELECT NVL(CKDT,' ') CKDT, NVL(PLID,' ') PLID, NVL(CDBH,' ') CDBH, NVL(HBSN,' ') HBSN, NVL(APTI,' ') APTI, \
NVL(HBDT,' ') HBDT, NVL(SKJBH,' ') SKJBH, NVL(HBTY,' ') HBTY, NVL(CDJM, 0) CDJM, NVL(SHBM, 0) SHBM, NVL(HBCS, 0) HBCS, \
NVL(MILE, 0) MILE, NVL(SYCS, 0) SYCS, NVL(HJGJ, 0) HJGJ, NVL(GJSD,' ') GJSD, NVL(GJKM, 0) GJKM, NVL(SYCD,' ') SYCD, \
NVL(SIBH,' ') SIBH, NVL(SJMF,' ') SJMF, NVL(NAME,' ') NAME, NVL(BANK,' ') BANK, NVL(ACNO,' ') ACNO, NVL(KMDT,' ') KMDT FROM TEXT08T"

/***************************************************************************
   TRFL_TOTCDCK :    -@@  #define S_TRFL_TOTCDCK 
***************************************************************************/
/***************************************************************************
   EXTS_TOTSCPAY :    -@@  #define S_EXTS_TOTSCPAY 
***************************************************************************/


/***************************************************************************
   TGEN01M : ¬ß --@@
***************************************************************************/
#define S_TGEN01M    "SELECT NVL(CDBH,' ') CDBH, NVL(BSSDT,' ') BSSDT, NVL(BSSTI,' ') BSSTI, NVL(BSSA,' ') BSSA, \
NVL(BCDT,' ') BCDT, NVL(BCTI,' ') BCTI, NVL(BSST,' ') BSST, NVL(HBYN,' ') HBYN, NVL(DBAD,' ') DBAD, NVL(BHAD,' ') BHAD, \
NVL(PLID,' ') PLID, NVL(BSDT,' ') BSDT, NVL(BSTI,' ') BSTI FROM TGEN01M"

/***************************************************************************
   PUBL_ALLOWANCE :  -ok
***************************************************************************/
#define S_PUBL_ALLOWANCE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(HND_TM,' ') SJTI, NVL(WRKR_NO,' ') KJBH, \
NVL(IO_MYN_DIV,' ') IOGG, NVL(MYN, 0) KMAK, NVL(WRK_NO,' ') KMBH, NVL(AUTO_YN,' ') ATYN, NVL(ADMIN_NO,' ') GRBH, NVL(NOTE,' ') BIGO FROM PUBL_ALLOWANCE"

/***************************************************************************
   TGEN03M :  -@@
***************************************************************************/
#define S_TGEN03M    "SELECT NVL(EXID,' ') EXID, NVL(NWDT,' ') NWDT, NVL(OLDT,' ') OLDT, NVL(OJFR,' ') OJFR, NVL(OGFR,' ') OGFR, \
NVL(NJFR,' ') NJFR, NVL(NGFR,' ') NGFR FROM TGEN03M"

/***************************************************************************
   PUBL_DCCARDINFO : / (,//,) -ok
***************************************************************************/
#define S_PUBL_DCCARDINFO    "SELECT NVL(CARD_NO,' ') CARD_NO, NVL(CARD_KND,' ') CARD_KIND, NVL(TARGET_DIV,' ') TYPE, \
NVL(ISS_CO,' ') SOURCE, NVL(INT_CARD_NO,' ') F_CARD_NO, NVL(OD_CARD_NO,' ') O_CARD_NO, NVL(DEP,' ') DEPT, \
NVL(POS,' ') GRADE, NVL(EMP_NO,' ') PERSONAL_NO, NVL(NAME1,' ') NAME1, NVL(REG_NO1,' ') REGI_NO1, \
NVL(NAME2,' ') NAME2, NVL(REG_NO2,' ') REGI_NO2, NVL(NAME3,' ') NAME3, NVL(REG_NO3,' ') REGI_NO3, \
NVL(NAME4,' ') NAME4, NVL(REG_NO4,' ') REGI_NO4, NVL(CAR_NO,' ') CAR_NO, NVL(FATH_DATE,' ') ISSUE_DATE, \
NVL(EFF_DATE,' ') END_YYYYMM, NVL(UFAIR_CODE,' ') BJ_CODE, NVL(UFAIR_STRT_DATE,' ') BJ_DATE_F, \
NVL(UFAIR_END_DATE,' ') BJ_DATE_T, NVL(CO,' ') REQ_OFFICE, NVL(ADDR,' ') ADDR, NVL(PHONE_NO,' ') TEL, \
NVL(CC, 0) DISPLACEMENT, NVL(CAR_DIV,' ') CAR_CLASS, NVL(STAT_DIV,' ') STATUS, \
NVL(CHG_DATE,' ') UPDATE_DATE, NVL(CHG_DEP,' ') UPDATE_DEPT, NVL(SND_YN1,' ') TRANSE_YN, \
NVL(SND_YN2,' ') TRANSE_YN_2, NVL(SND_YN3,' ') TRANSE_YN_3, NVL(SND_YN4,' ') TRANSE_YN_4, \
NVL(SMD_YN5,' ') TRANSE_YN_5, NVL(SND_YN6,' ') TRANSE_YN_6 FROM PUBL_DCCARDINFO"

/***************************************************************************
   TGEN05M :  -@@
***************************************************************************/
#define S_TGEN05M    "SELECT NVL(CSID,' ') CSID, NVL(CSTY,' ') CSTY, NVL(NAME,' ') NAME, NVL(FRNO,' ') FRNO, \
NVL(DTNO,' ') DTNO, NVL(DRDT,' ') DRDT, NVL(TEL1,' ') TEL1, NVL(TEL2,' ') TEL2, NVL(TEL3,' ') TEL3, NVL(HZIP,' ') HZIP, \
NVL(HADD1,' ') HADD1, NVL(HADD2,' ') HADD2, NVL(HP1,' ') HP1, NVL(HP2,' ') HP2, NVL(HP3,' ') HP3, NVL(EMAL,' ') EMAL, \
NVL(FAX1,' ') FAX1, NVL(FAX2,' ') FAX2, NVL(FAX3,' ') FAX3, NVL(YGJT,' ') YGJT, NVL(CTEL1,' ') CTEL1, NVL(CTEL2,' ') CTEL2, \
NVL(CTEL3,' ') CTEL3, NVL(CZIP,' ') CZIP, NVL(CADD1,' ') CADD1, NVL(CADD2,' ') CADD2, NVL(SMSYN,' ') SMSYN, \
NVL(EMALYN,' ') EMALYN, NVL(DRID,' ') DRID, NVL(PRIC,' ') PRIC FROM TGEN05M"

/***************************************************************************
   TGEN06M : / -@@
***************************************************************************/
#define S_TGEN06M    "SELECT NVL(CHJO, 0) CHJO, NVL(GCJR, 0) GCJR, NVL(GJNI, 0) GJNI FROM TGEN06M"

/***************************************************************************
   EXTM_LSAMINFO : LSAM  -ok
***************************************************************************/
#define S_EXTM_LSAMINFO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_NO,' ') KMBH, NVL(WRK_DATE,' ') KMDT, \
NVL(TRAN_STRT_DATE,' ') SRDT, NVL(TRAN_UNQ_NO,' ') SRSN, NVL(LSAM_CRD_NO,' ') LSAMCARDNO, NVL(LSAM_ID,' ') LSAMID, \
NVL(LSAM_OFCER_ID,' ') PPISAM, NVL(LSAM_CO_ID,' ') BRAISAM, NVL(LSAM_AGORZ_ID,' ') ALGISAM, NVL(PUB_DATE,' ') DISSISAM, \
NVL(VAL_EZP_DATE,' ') DEXPISAM, NVL(USE_STRT_DATE,' ') DACTISAM, NVL(USE_STP_DATE,' ') DDEAISAM, NVL(CENTER_ID,' ') IDCENTER, \
NVL(SERVICE_ID,' ') IDSERVICE, NVL(LSAM_BALC, 0) LSAMBALANCE FROM EXTM_LSAMINFO"

/***************************************************************************
   EXTM_PSAMINFO : PSAM  -ok
***************************************************************************/
#define S_EXTM_PSAMINFO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(PSAM_ID,' ') PSAMID, NVL(LANE_NO,' ') CRBH, \
NVL(TRAN_STRT_DATE,' ') SRDT, NVL(TRAN_UNQ_NO,' ') SRSN, NVL(PSAM_CRD_NO,' ') PSAMCARDNO, NVL(PSAM_PCHA_CO_ID,' ') PPPSAM, \
NVL(TRAN_SNO,' ') NTPSAM, NVL(TRAN_CLCT_SNO,' ') NC, NVL(CSAM_ID,' ') CSAMID, NVL(INST_DATE,' ') DISSPSAM, \
NVL(MAT_DATE,' ') DEXPPSAM, NVL(ACT_DATE,' ') DACTPSAM, NVL(INACT_DATE,' ') DDEAPSAM, \
NVL(AGORZ_ID,' ') ALGPSAM, NVL(PSAM_ATT,' ') ATTPSAM, NVL(PAY_TRAN_CNT_SUM, 0) SRCNT, NVL(PAY_TRAN_MNY_SUM, 0) SRTOT, \
NVL(LSAM_RFND_MNY, 0) LSAMREFUND, NVL(CHRG_CNT, 0) RELOADCNT, NVL(CHRG_MNY, 0) RELOADTOT, NVL(WRK_DATE,' ') WRDT, NVL(HND_YN,' ') CRYN FROM EXTM_PSAMINFO"

/***************************************************************************
   PUBM_DCCARTYPE :   -ok
***************************************************************************/
#define S_PUBM_DCCARTYPE    "SELECT NVL(PLID,' ') PLID, NVL(CDBH,' ') CDBH, NVL(CDGB,' ') CDGB, NVL(CDNM,' ') CDNM, \
NVL(YGCD,' ') YGCD, NVL(JYCJ,' ') JYCJ, NVL(SYYN,' ') SYYN, NVL(RATE, 0) RATE, NVL(SYHS, 0) SYHS FROM PUBM_DCCARTYPE"

/***************************************************************************
   TGEN10M :   -@@
***************************************************************************/
#define S_TGEN10M    "SELECT NVL(HIGH_NO,' ') HIGH_NO, NVL(ACC_DATE,' ') ACC_DATE, NVL(REGI_NO,' ') REGI_NO, NVL(LOSER,' ') LOSER, \
NVL(LOSE_DATE,' ') LOSE_DATE, NVL(LOSE_PLATE,' ') LOSE_PLATE, NVL(TEL,' ') TEL, NVL(ADDR,' ') ADDR, NVL(ACC_NAME,' ') ACC_NAME, \
NVL(REMARK,' ') REMARK FROM TGEN10M"

/***************************************************************************
   PUBR_VOIDZONEM : /()  -@@
***************************************************************************/
#define S_PUBR_VOIDZONEM    "SELECT NVL(CARD_NO,' ') CARD_NO, NVL(REVNO, 0) REVNO, NVL(CARD_KIND,' ') CARD_KIND, \
NVL(SOURCE,' ') SOURCE, NVL(F_CARD_NO,' ') F_CARD_NO, NVL(O_CARD_NO,' ') O_CARD_NO, NVL(DEPT,' ') DEPT, NVL(GRADE,' ') GRADE, \
NVL(PERSONAL_NO,' ') PERSONAL_NO, NVL(NAME1,' ') NAME1, NVL(REGI_NO1,' ') REGI_NO1, NVL(NAME2,' ') NAME2, NVL(REGI_NO2,' ') REGI_NO2, \
NVL(NAME3,' ') NAME3, NVL(REGI_NO3,' ') REGI_NO3, NVL(NAME4,' ') NAME4, NVL(REGI_NO4,' ') REGI_NO4, NVL(CAR_NO,' ') CAR_NO, \
NVL(ISSUE_DATE,' ') ISSUE_DATE, NVL(END_YYYYMM,' ') END_YYYYMM, NVL(BJ_CODE,' ') BJ_CODE, NVL(BJ_DATE_F,' ') BJ_DATE_F, \
NVL(BJ_DATE_T,' ') BJ_DATE_T, NVL(REQ_OFFICE,' ') REQ_OFFICE, NVL(ADDR,' ') ADDR, NVL(TEL,' ') TEL, NVL(DISPLACEMENT, 0) DISPLACEMENT, \
NVL(CAR_CLASS,' ') CAR_CLASS, NVL(STATUS,' ') STATUS, NVL(UPDATE_DATE,' ') UPDATE_DATE, NVL(UPDATE_DEPT,' ') UPDATE_DEPT, \
NVL(TRANSE_YN,' ') TRANSE_YN, NVL(TRANSE_YN_2,' ') TRANSE_YN_2, NVL(TRANSE_YN_3,' ') TRANSE_YN_3, NVL(TRANSE_YN_4,' ') TRANSE_YN_4, \
NVL(TRANSE_YN_5,' ') TRANSE_YN_5, NVL(TRANSE_YN_6,' ') TRANSE_YN_6, NVL(ZIPCODE,' ') ZIPCODE, NVL(REVDATE,' ') REVDATE, \
NVL(ADMINID,' ') ADMINID, NVL(LISTRECV_DATE,' ') LISTRECV_DATE, NVL(BLPROC_DATE,' ') BLPROC_DATE, NVL(BIGO,' ') BIGO FROM PUBR_VOIDZONEM"

/***************************************************************************
   PUBR_VOIDZONE : /() -@@
***************************************************************************/
#define S_PUBR_VOIDZONE    "SELECT NVL(CARD_NO,' ') CARD_NO, NVL(CARD_KIND,' ') CARD_KIND, NVL(SOURCE,' ') SOURCE, \
NVL(F_CARD_NO,' ') F_CARD_NO, NVL(O_CARD_NO,' ') O_CARD_NO, NVL(DEPT,' ') DEPT, NVL(GRADE,' ') GRADE, NVL(PERSONAL_NO,' ') PERSONAL_NO, \
NVL(NAME1,' ') NAME1, NVL(REGI_NO1,' ') REGI_NO1, NVL(NAME2,' ') NAME2, NVL(REGI_NO2,' ') REGI_NO2, NVL(NAME3,' ') NAME3, \
NVL(REGI_NO3,' ') REGI_NO3, NVL(NAME4,' ') NAME4, NVL(REGI_NO4,' ') REGI_NO4, NVL(CAR_NO,' ') CAR_NO, NVL(ISSUE_DATE,' ') ISSUE_DATE, \
NVL(END_YYYYMM,' ') END_YYYYMM, NVL(BJ_CODE,' ') BJ_CODE, NVL(BJ_DATE_F,' ') BJ_DATE_F, NVL(BJ_DATE_T,' ') BJ_DATE_T, \
NVL(REQ_OFFICE,' ') REQ_OFFICE, NVL(ADDR,' ') ADDR, NVL(TEL,' ') TEL, NVL(DISPLACEMENT, 0) DISPLACEMENT, NVL(CAR_CLASS,' ') CAR_CLASS, \
NVL(STATUS,' ') STATUS, NVL(UPDATE_DATE,' ') UPDATE_DATE, NVL(UPDATE_DEPT,' ') UPDATE_DEPT, NVL(TRANSE_YN,' ') TRANSE_YN, \
NVL(TRANSE_YN_2,' ') TRANSE_YN_2, NVL(TRANSE_YN_3,' ') TRANSE_YN_3, NVL(TRANSE_YN_4,' ') TRANSE_YN_4, NVL(TRANSE_YN_5,' ') TRANSE_YN_5, \
NVL(TRANSE_YN_6,' ') TRANSE_YN_6, NVL(ZIPCODE,' ') ZIPCODE, NVL(LISTRECV_DATE,' ') LISTRECV_DATE, NVL(BLPROC_DATE,' ') BLPROC_DATE, \
NVL(BIGO,' ') BIGO FROM PUBR_VOIDZONE"

/***************************************************************************
   PUBM_PLAZAIP :   IP -ok
***************************************************************************/
#define S_PUBM_PLAZAIP    "SELECT NVL(PLZ_ID,' ') PLID, NVL(IP_ADDR,' ') IPAD, NVL(IP_ZNE,' ') GUYK FROM PUBM_PLAZAIP"

/***************************************************************************
   TGEN13M :  PL -@@
***************************************************************************/
#define S_TGEN13M    "SELECT NVL(CDSA,' ') CDSA, NVL(CDBH,' ') CDBH, NVL(PLBH,' ') PLBH, NVL(CDGB,' ') CDGB, \
NVL(DRDT,' ') DRDT, NVL(DRSJ,' ') DRSJ FROM TGEN13M"

/***************************************************************************
   TGEN14M : B/L -@@
***************************************************************************/
#define S_TGEN14M    "SELECT NVL(PLID,' ') PLID, NVL(BSDT,' ') BSDT, NVL(CANO,' ') CANO, NVL(NAME,' ') NAME, \
NVL(HMGB,' ') HMGB, NVL(BSNY,' ') BSNY, NVL(CRGG,' ') CRGG FROM TGEN14M"

/***************************************************************************
   TRFM_BINTBL :  BIN  -ok check
***************************************************************************/
#define S_TRFM_BINTBL    "SELECT NVL(SGGB,' ') SGGB, NVL(CDCD,' ') CDCD, NVL(BINC,' ') BINC, NVL(ILBH,' ') ILBH, \
NVL(SYYN,' ') SYYN FROM TRFM_BINTBL"

/***************************************************************************
   TGEN16M : SMS -@@
***************************************************************************/
#define S_TGEN16M    "SELECT NVL(SMID, 0) SMID, NVL(SMSG,' ') SMSG FROM TGEN16M"

/***************************************************************************
   TILJ01T :    -@@
***************************************************************************/
#define S_TILJ01T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(EDTI,' ') EDTI, NVL(KJBH,' ') KJBH, \
NVL(EDU,' ') EDU FROM TILJ01T"

/***************************************************************************
   PUBS_ERRRATE :  -ok
***************************************************************************/
#define S_PUBS_ERRRATE    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KJBH,' ') KJBH, NVL(KGDS, 0) KGDS, \
NVL(CRDS, 0) CRDS, NVL(OCDS, 0) OCDS, NVL(SAYU,' ') SAYU, NVL(BIGO,' ') BIGO FROM PUBS_ERRRATE"

/***************************************************************************
   PUBS_ETCJUDGE : Í§ -ok
***************************************************************************/
#define S_PUBS_ETCJUDGE    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(GTNY,' ') GTNY, NVL(GTSU,' ') GTSU FROM PUBS_ETCJUDGE"

/***************************************************************************
   TILJ04T :   -@@
***************************************************************************/
#define S_TILJ04T    "SELECT NVL(PLID,' ') PLID, NVL(SCDT,' ') SCDT, NVL(KMDT,' ') KMDT, NVL(KJBH,' ') KJBH, \
NVL(JHKM, 0) JHKM, NVL(HHKM, 0) HHKM, NVL(SAYU,' ') SAYU, NVL(BIGO,' ') BIGO FROM TILJ04T"

/***************************************************************************
   PUBM_BUSNJUDGE :  -ok
***************************************************************************/
#define S_PUBM_BUSNJUDGE    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(MJCR1, 0) MJCR1, NVL(MJCR2, 0) MJCR2, \
NVL(MJCR3, 0) MJCR3, NVL(MJCR4, 0) MJCR4, NVL(BIMJ1, 0) BIMJ1, NVL(BIMJ2, 0) BIMJ2, NVL(BIMJ3, 0) BIMJ3, \
NVL(BIMJ4, 0) BIMJ4, NVL(PSCR1, 0) PSCR1, NVL(PSCR2, 0) PSCR2, NVL(PJCR1, 0) PJCR1, NVL(PJCR2, 0) PJCR2, \
NVL(PJCR3, 0) PJCR3, NVL(PJCR4, 0) PJCR4, NVL(PJCR5, 0) PJCR5, NVL(MNCR1, 0) MNCR1, NVL(MNCR2, 0) MNCR2, \
NVL(MNCR3, 0) MNCR3, NVL(MNCR4, 0) MNCR4, NVL(HISM1, 0) HISM1, NVL(HISM2, 0) HISM2, NVL(HISM3, 0) HISM3, \
NVL(HISM4, 0) HISM4, NVL(HISM5, 0) HISM5, NVL(MJSY1, 0) MJSY1, NVL(MJSY2, 0) MJSY2, NVL(MJSY3, 0) MJSY3, \
NVL(MJSY4, 0) MJSY4, NVL(MJSY5, 0) MJSY5, NVL(SMGT1_D, 0) SMGT1_D, NVL(SMGT1_T, 0) SMGT1_T, NVL(SMGT2_D, 0) SMGT2_D, \
NVL(SMGT2_T, 0) SMGT2_T, NVL(SMGT3_D, 0) SMGT3_D, NVL(SMGT3_T, 0) SMGT3_T, NVL(JYG1, 0) JYG1, NVL(JYG2, 0) JYG2, \
NVL(JYG3, 0) JYG3, NVL(JYG4, 0) JYG4, NVL(JYG5, 0) JYG5, NVL(JYG6, 0) JYG6 FROM PUBM_BUSNJUDGE"

/***************************************************************************
   TIMG01M :   -@@
***************************************************************************/
#define S_TIMG01M    "SELECT NVL(PLID,' ') PLID, NVL(NRBH,' ') NRBH, NVL(IPAD,' ') IPAD, NVL(JGSJ, 0) JGSJ, \
NVL(LSSJ, 0) LSSJ, NVL(ICGB, 0) ICGB FROM TIMG01M"

/***************************************************************************
   TIMG02T :  -@@
***************************************************************************/
#define S_TIMG02T    "SELECT NVL(PLID,' ') PLID, NVL(NRBH,' ') NRBH, NVL(CANO,' ') CANO, NVL(HHBB,' ') HHBB, \
NVL(CRTY,' ') CRTY, NVL(CRNO, 0) CRNO, NVL(TBCD,' ') TBCD, NVL(ICHI,' ') ICHI FROM TIMG02T"

/***************************************************************************
   TIMG03T : / (1) -@@
***************************************************************************/
#define S_TIMG03T    "SELECT NVL(PLID,' ') PLID, NVL(NRBH,' ') NRBH, NVL(CANO,' ') CANO, NVL(HHBB,' ') HHBB, \
NVL(CRTY,' ') CRTY, NVL(CRNO, 0) CRNO, NVL(GCGB, 0) GCGB, NVL(CJNI, 0) CJNI, NVL(CGNI, 0) CGNI FROM TIMG03T"

/***************************************************************************
   TLOD01L : LSAM    -@@
***************************************************************************/
#define S_TLOD01L    "SELECT NVL(REVN, 0) REVN, NVL(IRDT,' ') IRDT, NVL(NWDT,' ') NWDT, NVL(OLDT,' ') OLDT, \
NVL(NCSM, 0) NCSM, NVL(NCDM, 0) NCDM, NVL(OCSM, 0) OCSM, NVL(OCDM, 0) OCDM, NVL(ADBH,' ') ADBH FROM TLOD01L"

/***************************************************************************
   EXTM_LSAMMAXMIN : LSAM   -ok
***************************************************************************/
#define S_EXTM_LSAMMAXMIN    "SELECT NVL(NW_INFO_APL_DT,' ') NWDT, NVL(OD_INFO_CLS_ATE,' ') OLDT, NVL(NW_LSAM_MIN_CHRG_MNY, 0) NCSM, NVL(NW_LSAM_MAX_CHRG_MNY, 0) NCDM, \
NVL(OD_LSAM_MIN_CHRG_MNY, 0) OCSM, NVL(OD_LSAM_MAX_CHRG_MNY, 0) OCDM FROM EXTM_LSAMMAXMIN"

/***************************************************************************
   EXTL_LOADRATE :     -ok
***************************************************************************/
#define S_EXTL_LOADRATE    "SELECT NVL(RVS_NO, 0) REVN, NVL(NW_APL_DT,' ') NWDT, NVL(OD_APL_DT,' ') OLDT, NVL(NW_CHRG_EXTR_RTE1,' ') NCHJ1, \
NVL(NW_MNY_UNT1,' ') NMO1, NVL(NW_CHRG_EXTR_RTE2,' ') NCHJ2, NVL(NW_MNY_UNT2,' ') NMO2, NVL(NW_CHRG_EXTR_RTE3,' ') NCHJ3, NVL(NW_MNY_UNT3,' ') NMO3, \
NVL(NW_CHRG_EXTR_RTE4,' ') NCHJ4, NVL(NW_MNY_UNT4,' ') NMO4, NVL(NW_CHRG_EXTR_RTE5,' ') NCHJ5, NVL(NW_MNY_UNT5,' ') NMO5, NVL(NW_CHRG_EXTR_RTE6,' ') NCHJ6, \
NVL(NW_MNY_UNT6,' ') NMO6, NVL(NW_CHRG_EXTR_RTE7,' ') NCHJ7, NVL(NW_MNY_UNT7,' ') NMO7, NVL(NW_CHRG_EXTR_RTE8,' ') NCHJ8, NVL(NW_MNY_UNT8,' ') NMO8, \
NVL(NW_CHRG_EXTR_RTE9,' ') NCHJ9, NVL(NW_MNY_UNT9,' ') NMO9, NVL(NW_CHRG_EXTR_RTE10,' ') NCHJ10, NVL(NW_MNY_UNT10,' ') NMO10, NVL(OD_CHRG_EXTR_RTE1,' ') OCHJ1, \
NVL(OD_MNY_UNT1,' ') OMO1, NVL(OD_CHRG_EXTR_RTE2,' ') OCHJ2, NVL(OD_MNY_UNT2,' ') OMO2, NVL(OD_CHRG_EXTR_RTE3,' ') OCHJ3, NVL(OD_MNY_UNT3,' ') OMO3, \
NVL(OD_CHRG_EXTR_RTE4,' ') OCHJ4, NVL(OD_MNY_UNT4,' ') OMO4, NVL(OD_CHRG_EXTR_RTE5,' ') OCHJ5, NVL(OD_MNY_UNT5,' ') OMO5, NVL(OD_CHRG_EXTR_RTE6,' ') OCHJ6, \
NVL(OD_MNY_UNT6,' ') OMO6, NVL(OD_CHRG_EXTR_RTE7,' ') OCHJ7, NVL(OD_MNY_UNT7,' ') OMO7, NVL(OD_CHRG_EXTR_RTE8,' ') OCHJ8, NVL(OD_MNY_UNT8,' ') OMO8, \
NVL(OD_CHRG_EXTR_RTE9,' ') OCHJ9, NVL(OD_MNY_UNT9,' ') OMO9, NVL(OD_CHRG_EXTR_RTE10,' ') OCHJ10, NVL(OD_MNY_UNT10,' ') OMO10, NVL(MODF_DT,' ') IRDT, \
NVL(ADMIN_NO,' ') KJBH FROM EXTL_LOADRATE"

/***************************************************************************
   EXTM_LOADRATE :    -ok
***************************************************************************/
#define S_EXTM_LOADRATE    "SELECT NVL(NW_APL_DT,' ') NWDT, NVL(OD_CLS_DT,' ') OLDT, NVL(NW_CHRG_EXTR_RTE1,' ') NCHJ1, NVL(NW_MNY_UNT1,' ') NMO1, \
NVL(NW_CHRG_EXTR_RTE2,' ') NCHJ2, NVL(NW_MNY_UNT2,' ') NMO2, NVL(NW_CHRG_EXTR_RTE3,' ') NCHJ3, NVL(NW_MNY_UNT3,' ') NMO3, NVL(NW_CHRG_EXTR_RTE4,' ') NCHJ4, \
NVL(NW_MNY_UNT4,' ') NMO4, NVL(NW_CHRG_EXTR_RTE5,' ') NCHJ5, NVL(NW_MNY_UNT5,' ') NMO5, NVL(NW_CHRG_EXTR_RTE6,' ') NCHJ6, NVL(NW_MNY_UNT6,' ') NMO6, \
NVL(NW_CHRG_EXTR_RTE7,' ') NCHJ7, NVL(NW_MNY_UNT7,' ') NMO7, NVL(NW_CHRG_EXTR_RTE8,' ') NCHJ8, NVL(NW_MNY_UNT8,' ') NMO8, NVL(NW_CHRG_EXTR_RTE9,' ') NCHJ9, \
NVL(NW_MNY_UNT9,' ') NMO9, NVL(NW_CHRG_EXTR_RTE10,' ') NCHJ10, NVL(NW_MNY_UNT10,' ') NMO10, NVL(OD_CHRG_EXTR_RTE1,' ') OCHJ1, NVL(OD_MNY_UNT1,' ') OMO1, \
NVL(OD_CHRG_EXTR_RTE2,' ') OCHJ2, NVL(OD_MNY_UNT2,' ') OMO2, NVL(OD_CHRG_EXTR_RTE3,' ') OCHJ3, NVL(OD_MNY_UNT3,' ') OMO3, NVL(OD_CHRG_EXTR_RTE4,' ') OCHJ4, \
NVL(OD_MNY_UNT4,' ') OMO4, NVL(OD_CHRG_EXTR_RTE5,' ') OCHJ5, NVL(OD_MNY_UNT5,' ') OMO5, NVL(OD_CHRG_EXTR_RTE6,' ') OCHJ6, NVL(OD_MNY_UNT6,' ') OMO6, \
NVL(OD_CHRG_EXTR_RTE7,' ') OCHJ7, NVL(OD_MNY_UNT7,' ') OMO7, NVL(OD_CHRG_EXTR_RTE8,' ') OCHJ8, NVL(OD_MNY_UNT8,' ') OMO8, NVL(OD_CHRG_EXTR_RTE9,' ') OCHJ9, \
NVL(OD_MNY_UNT9,' ') OMO9, NVL(OD_CHRG_EXTR_RTE10,' ') OCHJ10, NVL(OD_MNY_UNT10,' ') OMO10, NVL(MODF_DT,' ') IRDT FROM EXTM_LOADRATE"

/***************************************************************************
   EXTL_SCLREFUND :    -ok
***************************************************************************/
#define S_EXTL_SCLREFUND    "SELECT NVL(PLZ_ID,' ') PLID, NVL(CSTRM_CRD_NO,' ') CDBH, NVL(TRAD_SNO,' ') HBSN, NVL(SYSTEM_HND_DATE,' ') APTI, NVL(RFND_DATE,' ') HBDT, \
NVL(WRKR_NO,' ') SKJBH, NVL(RFND_TYP,' ') HBTY, NVL(CSTRM_CRD_BALC, 0) CDJM, NVL(RFND_MNY, 0) SHBM, NVL(CSH_FRND_MNY, 0) HBCS, NVL(MILG_DDT, 0) MILE, \
NVL(CCRD_CANCL, 0) SYCS, NVL(EXTR_DDT, 0) HJGJ, NVL(RE_PAY_MEANS,' ') GJSD, NVL(RE_PAY_MNY, 0) GJKM, NVL(CCRD_NO,' ') SYCD, NVL(CCRD_APP_NO,' ') SIBH, \
NVL(CLCT_FSH_FLAG,' ') SJMF, NVL(USER_NM,' ') NAME, NVL(BANK_NM,' ') BANK, NVL(ACC_NO,' ') ACNO FROM EXTL_SCLREFUND"

/***************************************************************************
   EXTL_SCLLOAD :    -ok
***************************************************************************/
#define S_EXTL_SCLLOAD    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, NVL(SNO, 0) ILBH, \
NVL(ADMIN_NO,' ') KJID, NVL(TRAD_DATE,' ') GRDT, NVL(USER_CRD_NO,' ') CDBH, NVL(AGORZ_ID,' ') AGID, NVL(KEY_VER,' ') KEYV, NVL(USER_CRD_SNO,' ') CDIL, \
NVL(LSAM_TRAD_SNO,' ') LMIL, NVL(CSTRM_CRD_NS,' ') CDRN, NVL(LSAM_NS,' ') LMRN, NVL(CO_ID,' ') BHGG, NVL(CSTRM_CRD_ID,' ') CDID, NVL(LSAM_ID,' ') LMID, \
NVL(BE_CHRG_BALC, 0) CJJK, NVL(CHRG_BALC,' ') CHJK, NVL(PAN,' ') PAND, NVL(CENTER_ID,' ') CTID, NVL(CRD_CO_ID,' ') CDGU, NVL(CRD_SIGN,' ') CDSI, \
NVL(LSAM_SIGN,' ') LMSI, NVL(TRAD_MNY, 0) GRKM, NVL(CHRG_EXTR_MNY, 0) HJKM, NVL(EXTR_RTE,' ') HJPE, NVL(RCT_TYP,' ') SNYH, NVL(CHRG_CANCL,' ') CAFL FROM EXTL_SCLLOAD"

/***************************************************************************
   TLOD05T :   -@@
***************************************************************************/
#define S_TLOD05T    "SELECT NVL(PLID,' ') PLID, NVL(BNDT,' ') BNDT, NVL(CDGB,' ') CDGB, NVL(CDBH,' ') CDBH, NVL(BNGB,' ') BNGB, \
NVL(SAYU,' ') SAYU, NVL(CSID,' ') CSID, NVL(KJBH,' ') KJBH, NVL(HBYN,' ') HBYN FROM TLOD05T"

/***************************************************************************
   EXTL_SCLSALE :   -ok
***************************************************************************/
#define S_EXTL_SCLSALE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(ECRD_ISS_DATE,' ') PMTI, NVL(ECRD_KND,' ') CDTY, NVL(ECRD_NO,' ') CDBH, NVL(SAL_DIV,' ') PMGB, \
NVL(SAL_TYP,' ') PMTY, NVL(SAL_FEE, 0) PMSS, NVL(PAY_DIV,' ') JBSD, NVL(CCRD_NO,' ') SYCD, NVL(CCRD_APP_NO,' ') SIBH, NVL(CSTRM_ID,' ') CSID, \
NVL(ADMIN_NO,' ') SKJBH, NVL(SAL_CHRG_MNY, 0) PCKM, NVL(ON_OFF_SAL_DIV,' ') ONOF, NVL(NM_BEAR_SAL_DIV,' ') GMMG, NVL(RE_SAL_CAUS,' ') JPMC FROM EXTL_SCLSALE"

/***************************************************************************
   TCSR_LSAMLOAD : LSAM  -ok
***************************************************************************/
#define S_TCSR_LSAMLOAD    "SELECT NVL(PLZ_ID,' ') PLID, NVL(SYS_UNQ_NO,' ') SYID, NVL(CHRG_TM,' ') CJDT, NVL(CRD_SNO,' ') CDBH, \
NVL(TRAN_NO,' ') CRNO, NVL(ET_MNY_ID,' ') ECID, NVL(BALC, 0) CDJA, NVL(CHRG_MNY, 0) CDKM, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, \
NVL(WRKR_NO,' ') KJBH, NVL(ADMIN_NO,' ') ADBH, NVL(CHRG_BALC, 0) CDHJ, NVL(CENTER_ID,' ') CTID, NVL(ACRDT_CPL_DATE,' ') OKDT, NVL(CHRG_END_YN,' ') CJGB FROM TCSR_LSAMLOAD"

/***************************************************************************
   EXTM_LOADMAX :   -ok
***************************************************************************/
#define S_EXTM_LOADMAX    "SELECT NVL(APL_DT,' ') NWDT, NVL(NW_1_MAX_CHRG_MNY, 0) NMKM, NVL(NW_MAX_RET_BALC, 0) NMJA, NVL(OD_1_MAX_CHRG_MNY, 0) OMKM, \
NVL(OD_MAX_RET_BALC, 0) OMJA, NVL(MODF_DT,' ') IRDT FROM EXTM_LOADMAX"

/***************************************************************************
   TLOG15S : () -@@
***************************************************************************/
#define S_TLOG15S    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(TBCD,' ') TBCD, NVL(CHJO,' ') CHJO, NVL(CRDS, 0) CRDS \
FROM TLOG15S"

/***************************************************************************
   PUBS_DAYTOT : ¢® -ok
***************************************************************************/
#define S_PUBS_DAYTOT    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(COL_DIV,' ') JSGB, NVL(HND_TYP,' ') CRYH, NVL(RCT_DIV,' ') SNGB, \
NVL(DC_DIV,' ') HIGB, NVL(CNT_CAR1, 0) DS1J, NVL(CNT_CAR2, 0) DS2J, NVL(CNT_CAR3, 0) DS3J, NVL(CNT_CAR4, 0) DS4J, NVL(CNT_CAR5, 0) DS5J, NVL(CNT_CAR6, 0) DS6J, \
NVL(CNT_CAR7, 0) DS7J, NVL(CNT_CAR8, 0) DS8J, NVL(PAY_CAR1, 0) TY1M, NVL(PAY_CAR2, 0) TY2M, NVL(PAY_CAR3, 0) TY3M, NVL(PAY_CAR4, 0) TY4M, NVL(PAY_CAR5, 0) TY5M, \
NVL(PAY_CAR6, 0) TY6M, NVL(PAY_CAR7, 0) TY7M, NVL(PAY_CAR8, 0) TY8M, NVL(VAT_CAR1, 0) VT1M, NVL(VAT_CAR2, 0) VT2M, NVL(VAT_CAR3, 0) VT3M, NVL(VAT_CAR4, 0) VT4M, \
NVL(VAT_CAR5, 0) VT5M, NVL(VAT_CAR6, 0) VT6M, NVL(VAT_CAR7, 0) VT7M, NVL(VAT_CAR8, 0) VT8M FROM PUBS_DAYTOT"

/***************************************************************************
   PUBS_DAYTOTRATE : ¢®() -ok
***************************************************************************/
#define S_PUBS_DAYTOTRATE    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(HIYH,' ') HIYH, NVL(JSGB,' ') JSGB, \
NVL(SNGB,' ') SNGB, NVL(DS1J, 0) DS1J, NVL(DS2J, 0) DS2J, NVL(DS3J, 0) DS3J, NVL(DS4J, 0) DS4J, NVL(DS5J, 0) DS5J, \
NVL(DS6J, 0) DS6J, NVL(DS7J, 0) DS7J, NVL(DS8J, 0) DS8J, NVL(OT1M, 0) OT1M, NVL(OT2M, 0) OT2M, NVL(OT3M, 0) OT3M, \
NVL(OT4M, 0) OT4M, NVL(OT5M, 0) OT5M, NVL(OT6M, 0) OT6M, NVL(OT7M, 0) OT7M, NVL(OT8M, 0) OT8M, NVL(TY1M, 0) TY1M, \
NVL(TY2M, 0) TY2M, NVL(TY3M, 0) TY3M, NVL(TY4M, 0) TY4M, NVL(TY5M, 0) TY5M, NVL(TY6M, 0) TY6M, NVL(TY7M, 0) TY7M, \
NVL(TY8M, 0) TY8M, NVL(VT1M, 0) VT1M, NVL(VT2M, 0) VT2M, NVL(VT3M, 0) VT3M, NVL(VT4M, 0) VT4M, NVL(VT5M, 0) VT5M, \
NVL(VT6M, 0) VT6M, NVL(VT7M, 0) VT7M, NVL(VT8M, 0) VT8M FROM PUBS_DAYTOTRATE"

/***************************************************************************
   PUBS_DAYTOTSALE : ¢®(/) -ok
***************************************************************************/
#define S_PUBS_DAYTOTSALE    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(GCSC1, 0) GCSC1, NVL(GCSM1, 0) GCSM1, \
NVL(GCSC2, 0) GCSC2, NVL(GCSM2, 0) GCSM2, NVL(GCSC3, 0) GCSC3, NVL(GCSM3, 0) GCSM3, NVL(GCSC4, 0) GCSC4, \
NVL(GCSM4, 0) GCSM4, NVL(GCSC5, 0) GCSC5, NVL(GCSM5, 0) GCSM5, NVL(SCSC, 0) SCSC, NVL(SCSM, 0) SCSM, \
NVL(SCLC, 0) SCLC, NVL(SCLM, 0) SCLM, NVL(SCRC, 0) SCRC, NVL(SCRM, 0) SCRM, NVL(LSLC, 0) LSLC, \
NVL(LSLM, 0) LSLM, NVL(LSRC, 0) LSRC, NVL(LSRM, 0) LSRM FROM PUBS_DAYTOTSALE"

/***************************************************************************
   TLOT04S :  Ý¸ -@@
***************************************************************************/
#define S_TLOT04S    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(CRBH,' ') CRBH, NVL(JBIG, 0) JBIG, \
NVL(JBHJ, 0) JBHJ, NVL(JBSU, 0) JBSU, NVL(JBJG, 0) JBJG, NVL(IGSU, 0) IGSU, NVL(HJSU, 0) HJSU, NVL(JHSU, 0) JHSU, \
NVL(BNSU, 0) BNSU, NVL(JPSU, 0) JPSU, NVL(JPKM, 0) JPKM, NVL(HBSU, 0) HBSU, NVL(HBKM, 0) HBKM, NVL(HBKM_T, 0) HBKM_T, \
NVL(CJKA_T, 0) CJKA_T FROM TLOT04S"

/***************************************************************************
   TLOT05S :   -@@
***************************************************************************/
#define S_TLOT05S    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(GCGJ, 0) GCGJ, NVL(JIDS, 0) JIDS, \
NVL(IGDS, 0) IGDS, NVL(HJDS, 0) HJDS, NVL(JSDS, 0) JSDS, NVL(JSAK, 0) JSAK, NVL(JSHK, 0) JSHK, NVL(JSNK, 0) JSNK, \
NVL(BNDS, 0) BNDS, NVL(BNJK, 0) BNJK, NVL(BNHK, 0) BNHK, NVL(DIDS, 0) DIDS, NVL(PMDS, 0) PMDS, NVL(PMKM, 0) PMKM FROM TLOT05S"

/***************************************************************************
   TLOT06S :   -@@
***************************************************************************/
#define S_TLOT06S    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(CPDS1, 0) CPDS1, NVL(CPDS2, 0) CPDS2, NVL(CPDS3, 0) CPDS3, \
NVL(CPDS4, 0) CPDS4, NVL(CPDS5, 0) CPDS5, NVL(CPDS6, 0) CPDS6, NVL(CPDS7, 0) CPDS7, NVL(CPDS8, 0) CPDS8, NVL(CPDS9, 0) CPDS9 FROM TLOT06S"

/***************************************************************************
   PUBS_TRADLETOT : ¥ê   -ok
***************************************************************************/
#define S_PUBS_TRADLETOT    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(LANE_NO,' ') CRBH, NVL(CBNG_CAR_KND_TOT, 0) CBNG, NVL(STRT_SENS_TOT, 0) BGNG \
FROM PUBS_TRADLETOT"

/***************************************************************************
   TLOT08S : ¥ê  -@@
***************************************************************************/
#define S_TLOT08S    "SELECT NVL(PLID,' ') PLID, NVL(CRBH,' ') CRBH, NVL(CBNG, 0) CBNG, NVL(BGNG, 0) BGNG FROM TLOT08S"

/***************************************************************************
   TLOT09S :     -@@
***************************************************************************/
#define S_TLOT09S    "SELECT NVL(YGBH,' ') YGBH, NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(CRBH,' ') CRBH, \
NVL(TIMD,' ') TIMD, NVL(KMBH,' ') KMBH, NVL(KMID,' ') KMID, NVL(GBBB, 0) GBBB FROM TLOT09S"

/***************************************************************************
   PUBL_TOTFARE : ¢®(¢®, MIS) -ok
***************************************************************************/
#define S_PUBL_TOTFARE    "SELECT NVL(TOLL_DATE,' ') INCOME_IL, NVL(PLZ_DIV,' ') INCOME_PLACE_GU, NVL(DATA_DIV,' ') INCOME_FLAG, \
NVL(GCAR_PASS_CNT, 0) IN_R_QTY, NVL(GCAR_PASS_FARE, 0) IN_R_AMT, NVL(GCAR_VAT, 0) IN_R_VAT, NVL(SCAR_PASS_CNT, 0) IN_S_QTY, NVL(SCAR_PASS_FARE, 0) IN_S_AMT, \
NVL(SCAR_VAT, 0) IN_S_VAT, NVL(MCAR_PASS_CNT, 0) IN_M_QTY, NVL(MCAR_PASS_FARE, 0) IN_M_AMT, NVL(MCAR_VAT, 0) IN_M_VAT, NVL(BCAR_PASS_CNT, 0) IN_G_QTY, \
NVL(BCAR_PASS_FARE, 0) IN_G_AMT, NVL(BCAR_VAT, 0) IN_G_VAT, NVL(PASS_CNT, 0) IN_X_QTY, NVL(COL_PASS_FARE, 0) IN_X_AMT, NVL(PASS_CNT_SUM, 0) TOTL_QTY, \
NVL(PASS_FARE_SUM, 0) TOTL_AMT, NVL(VAT_SUM, 0) TOTL_VAT, NVL(COL_PASS_CNT_SUM, 0) H_TOTL_QTY, NVL(COL_PASS_FARE_SUM, 0) H_TOTL_AMT, \
NVL(COL_VAT_SUM, 0) H_TOTL_VAT, NVL(BRIF,' ') INCOME_NAME, NVL(DC_PASS_CNT, 0) IN_O_QTY, NVL(DC_PASS_FARE, 0) IN_O_AMT, \
NVL(DC_VAT, 0) IN_O_VAT, NVL(CHIT_YN,' ') JUNPYO_YN FROM PUBL_TOTFARE"

/***************************************************************************
   PUBS_TOTSALE :  (¢®, MIS) -ok
***************************************************************************/
#define S_PUBS_TOTSALE    "SELECT NVL(SAL_DATE,' ') SALE_IL, NVL(PLZ_DIV,' ') SALE_PLACE_GU, NVL(DATA_DIV,' ') SALE_FLAG, \
NVL(QTY_SAL_CNT_SUM_1, 0) SALE_QTY_1, NVL(QTY_SAL_CNT_SUM_2, 0) SALE_QTY_2, NVL(QTY_SAL_CNT_SUM3, 0) SALE_QTY_3, NVL(QTY_SAL_CNT_SUM_5, 0) SALE_QTY_5, \
NVL(QTY_SAL_CNT_SUM_10, 0) SALE_QTY_10, NVL(SAL_QTY_CNT_SUM_RSV1, 0) SALE_QTY_X1, NVL(SAL_QTY_CNT_SUM_RSV2, 0) SALE_QTY_X2, NVL(SAL_QTY_CNT_SUM_RSV3, 0) SALE_QTY_X3, \
NVL(SAL_QTY_CNT_SUM_RSV4, 0) SALE_QTY_X4, NVL(QTY_SAL_FARE_SUM_1, 0) SALE_AMT_1, NVL(QTY_SAL_FARE_SUM_2, 0) SALE_AMT_2, NVL(QTY_SAL_FARE_SUM_3, 0) SALE_AMT_3, \
NVL(QTY_SAL_FARE_SUM_5, 0) SALE_AMT_5, NVL(QTY_SAL_FARE_SUM_10, 0) SALE_AMT_10, NVL(SAL_FARE_SUM_RSV1, 0) SALE_AMT_X1, NVL(SAL_FARE_SUM_RSV2, 0) SALE_AMT_X2, \
NVL(SAL_FARE_SUM_RSV3, 0) SALE_AMT_X3, NVL(SAL_FARE_SUM_RSV4, 0) SALE_AMT_X4, NVL(RFND_CNT_SUM, 0) HABL_QTY_1, NVL(RFND_CNT_SUM_RSV, 0) HABL_QTY_2, \
NVL(RFND_FARE_SUM, 0) HABL_AMT_1, NVL(RFND_FARE_SUM_RSV, 0) HABL_AMT_2, NVL(SAL_NM,' ') SALE_NAME, NVL(STMT_YN,' ') JUNPYO_YN FROM PUBS_TOTSALE"

/***************************************************************************
   TLOT12S :   -@@
***************************************************************************/
#define S_TLOT12S    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(CRBH,' ') CRBH, NVL(CHJO, 0) CHJO, \
NVL(JSDS, 0) JSDS, NVL(MJDS, 0) MJDS, NVL(MJCD, 0) MJCD, NVL(DJDS, 0) DJDS, NVL(HICD, 0) HICD, NVL(HIHJ, 0) HIHJ, NVL(CJBK, 0) CJBK FROM TLOT12S"

/***************************************************************************
   TLOT13S :   -@@
***************************************************************************/
#define S_TLOT13S    "SELECT NVL(PLID,' ') PLID, NVL(YEAR,' ') YEAR, NVL(MWEK, 0) MWEK, NVL(EWEK, 0) EWEK, \
NVL(CRBH,' ') CRBH, NVL(CHJO, 0) CHJO, NVL(JSDS, 0) JSDS, NVL(MJDS, 0) MJDS, NVL(MJCD, 0) MJCD, NVL(DJDS, 0) DJDS, \
NVL(HICD, 0) HICD, NVL(HIHJ, 0) HIHJ, NVL(CJBK, 0) CJBK FROM TLOT13S"

/***************************************************************************
   TLOT14S :   -@@
***************************************************************************/
#define S_TLOT14S    "SELECT NVL(PLID,' ') PLID, NVL(MONT,' ') MONT, NVL(CRBH,' ') CRBH, NVL(CHJO, 0) CHJO, \
NVL(JSDS, 0) JSDS, NVL(MJDS, 0) MJDS, NVL(MJCD, 0) MJCD, NVL(DJDS, 0) DJDS, NVL(HICD, 0) HICD, NVL(HIHJ, 0) HIHJ, NVL(CJBK, 0) CJBK FROM TLOT14S"

/***************************************************************************
   PUBS_DAYINCOMECAR : () -ok  LNEH, LNHH, LNSC 
***************************************************************************/
#define S_PUBS_DAYINCOMECAR    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(CAR_KND,' ') CHJO, NVL(HND_DIV,' ') CRGB, NVL(LANE_COL_CSH, 0) LNCA, \
NVL(LANE_COL_DUMMY, 0) LNGC, NVL(LANE_COL_ECRD_PPAY, 0) LNEC, NVL(LANE_COL_HPSS_PPAY, 0) LNHP, NVL(LANE_COL_LPAY_TCRD, 0) LNHC, NVL(LANE_COL_SUM, 0) LNHA, NVL(OFC_COL_TCS, 0) PZTC, NVL(CFC_COL_HPSS, 0) PZHP, \
NVL(UPID_MNY_RCOV, 0) PZMN, NVL(OFC_COL_SUM, 0) PZHA, NVL(UCLCT_CCRD, 0) MNSY, NVL(UCLCT_HDPN, 0) MNHP, NVL(UCLCT_ECRD, 0) MNEC, NVL(UCLCT_BBK, 0) MNTJ, NVL(UPID_ESCP, 0) MNDJ, \
NVL(DC_DSBLT, 0) DC85, NVL(DC_AREA_DSBLT, 0) DC95, NVL(DC_AREA_INHABI, 0) DC90, NVL(ECAR_EXMT, 0) EXNC, NVL(TCS_SUM, 0) TCHA, NVL(TCS_TOLL, 0) TCNR, NVL(TCS_DC, 0) TCDC, \
NVL(TCS_EXMT, 0) TCEX, NVL(TCS_OFC, 0) TCPZ, NVL(TCS_CLS, 0) TCCL, NVL(HPSS_TOLL, 0) HPNR, NVL(HPSS_DC, 0) HPDC, NVL(HPSS_EXMT, 0) HPEX, NVL(HPSS_VIO, 0) HPPZ, \
NVL(HPSS_SUM, 0) HPHA, NVL(LANE_COL_ECRD_LPAY, 0) LNEH, NVL(LANE_COL_HPSS_LPAY, 0) LNHH, NVL(LNSC, 0) LNSC FROM PUBS_DAYINCOMECAR"  //LNSC   ...

/***************************************************************************
   PUBS_DAYINCOMEETC : () -ok
***************************************************************************/
#define S_PUBS_DAYINCOMEETC    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(HND_DIV,' ') CRGB, NVL(ETC_UP_CSTM, 0) GSCU, NVL(ETC_UP_ETC, 0) GSWB, \
NVL(ETC_UP_PASS, 0) GSTH, NVL(ETC_RFND_CSTM, 0) GHCU, NVL(ETC_RFND_FARE, 0) GHTH, NVL(ECRD_SAL, 0) ECPM, NVL(ECRD_CHRG_CSH_LANE, 0) ELCA, NVL(ECRD_CHRG_CRD_OFC, 0) ELSY, NVL(DUMMY1, 0) GCCA, \
NVL(DUMMY2, 0) GCSY, NVL(DUMMY3, 0) GCHB, NVL(ECRD_RFND, 0) ECHB FROM PUBS_DAYINCOMEETC"

/***************************************************************************
   PUBM_EQUIPMENTSTATE :  -ok
***************************************************************************/
#define S_PUBM_EQUIPMENTSTATE    "SELECT NVL(WRK_NO,' ') KMBH, NVL(STAT_DATE,' ') GSDT, NVL(LANE_NO,' ') NRBH, NVL(OBU_NO,' ') DMBH, NVL(WRK_STAT,' ') KMST, \
NVL(EMPHY,' ') KKJR, NVL(RECVR_DIV,' ') BGGD, NVL(STAT_CODE,' ') ISCD FROM PUBM_EQUIPMENTSTATE"

/***************************************************************************
   PUBR_EQUIPMENTSTATE :   -ok
***************************************************************************/
#define S_PUBR_EQUIPMENTSTATE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(SEQES, 0) SEQ, NVL(WRK_NO,' ') KMBH, NVL(DATE_TM,' ') KMDT, NVL(LANE_NO,' ') CRBH, \
NVL(OBU_NO,' ') DMBH, NVL(WRK_STAT,' ') KMST, NVL(MDL,' ') KKJR, NVL(ROR_YN,' ') BGGD, NVL(STAT_CODE,' ') ISCD FROM PUBR_EQUIPMENTSTATE"

/***************************************************************************
   PUBL_TRADLECHANGE :   -ok
***************************************************************************/
#define S_PUBL_TRADLECHANGE    "SELECT NVL(PLZ_CO, 0) YGBH, NVL(PLZ_ID,' ') PLID, NVL(LANE_NO,' ') CRBH, NVL(CAR_TOT_YMD,' ') JIDT, NVL(STRT_TOT_YMD,' ') BJDT FROM PUBL_TRADLECHANGE"

/***************************************************************************
   TMAN04T :    -@@
***************************************************************************/
#define S_TMAN04T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KJBH,' ') KJBH, NVL(HSGW,' ') HSGW, \
NVL(HSBH,' ') HSBH, NVL(HSJA, 0) HSJA, NVL(HBKM, 0) HBKM, NVL(CJKM, 0) CJKM, NVL(BIGO,' ') BIGO FROM TMAN04T"

/***************************************************************************
   TMAN05T : ²À   -@@
***************************************************************************/
#define S_TMAN05T    "SELECT NVL(BZNO,' ') BZNO, NVL(BHKM, 0) BHKM, NVL(BGKM, 0) BGKM, NVL(BHDT,' ') BHDT, \
NVL(KJBH,' ') KJBH, NVL(PLID,' ') PLID, NVL(CSID,' ') CSID FROM TMAN05T"

/***************************************************************************
   TMAN06T : ¥ï -@@
***************************************************************************/
#define S_TMAN06T    "SELECT NVL(PLID,' ') PLID, NVL(KMID,' ') KMID, NVL(NAME,' ') NAME, NVL(TEL,' ') TEL, \
NVL(HADD,' ') HADD, NVL(JSNY,' ') JSNY, NVL(CRGB,' ') CRGB, NVL(SMSYN,' ') SMSYN, NVL(JSBH,' ') JSBH, NVL(JSIS,' ') JSIS FROM TMAN06T"

/***************************************************************************
   PUBL_USERVALUCATION :   -ok
***************************************************************************/
#define S_PUBL_USERVALUCATION    "SELECT NVL(PLID,' ') PLID, NVL(PGDT,' ') PGDT, NVL(KJBH,' ') KJBH, NVL(PGBH,' ') PGBH, NVL(HMGB,' ') HMGB, \
NVL(HMNY,' ') HMNY, NVL(HMJS, 0) HMJS FROM PUBL_USERVALUCATION"

/***************************************************************************
   PUBL_USERJUDGE :   -ok
***************************************************************************/
#define S_PUBL_USERJUDGE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(APPR_DATE,' ') PGDT, NVL(WRKR_NO,' ') KJBH, NVL(WRK_NO,' ') KMBH, \
NVL(ADMIN_NO,' ') PGBH, NVL(EXM_ITEM,' ') SSGB, NVL(EXM_DESC,' ') BSNY, NVL(ACT_DESC,' ') CRNY FROM PUBL_USERJUDGE"

/***************************************************************************
   TCSR_OFFICE : Í¨  -ok
***************************************************************************/
#define S_TCSR_OFFICE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, NVL(HND_SNO, 0) CRNO, \
NVL(OFC_CODE,' ') YCCD, NVL(OCC_YMDHMS,' ') HHBB, NVL(SYS_CLASS,' ') STJB, NVL(CAR_KND, 0) CHJO, NVL(BL_CRD,' ') MHKD, NVL(HND_STAT,' ') CRGB FROM TCSR_OFFICE"

/***************************************************************************
   TCSL_OFFICE : Í¨   -ok
***************************************************************************/
#define S_TCSL_OFFICE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRKR_NO,' ') KJBH, NVL(HND_SNO, 0) CRNO, \
NVL(MODF_HND_NO, 0) SCNO, NVL(OCC_DIV,' ') BSGB, NVL(OFC_CODE,' ') YCCD, NVL(HND_TM,' ') CRDT, NVL(HND_TYP,' ') CRYH, \
NVL(LPAY_YN,' ') HBYN, NVL(CAR_KND,' ') CHJO, NVL(CAR_NO,' ') CANO, NVL(KND_DIV,' ') SNGB, NVL(ORG_PASS_FARE_N, 0) WTHK, \
NVL(ORG_PASS_FARE, 0) THYK, NVL(VAT, 0) BGKM, NVL(PCHA_MC_CO,' ') IEPT, NVL(CRD_NO,' ') CDBH, NVL(APP_NO,' ') SIBH, \
NVL(HND_DIV,' ') CRGB, NVL(NOTE,' ') BIGO, NVL(PAY_DIV,' ') JBGB, NVL(OCC_DATE,' ') HHBB, NVL(WRK_NO,' ') KMBH, \
NVL(LPAY_AGR_DT,' ') HBDT, NVL(NM,' ') NAME, NVL(REG_NO,' ') JMBH, NVL(ADDR,' ') ADDR, NVL(PHONE_NO,' ') JHBH, \
NVL(RCT_FARE, 0) SSKM, NVL(ADMIN_NO,' ') MNBH, NVL(PASS_FARE_VAT, 0) BTKM, NVL(CAR_TYP,' ') CHJR, NVL(CAR_DIV,' ') CHGB FROM TCSL_OFFICE"

/***************************************************************************
   TOFS03T :  -@@
***************************************************************************/
#define S_TOFS03T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(SEND,' ') SEND, NVL(ACCEPT,' ') ACCEPT, NVL(TISH,' ') TISH FROM TOFS03T"

/***************************************************************************
   PUBL_UNPAYEDNOTICE :    -ok  CSID 
***************************************************************************/
#define S_PUBL_UNPAYEDNOTICE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(HND_SNO, 0) CRNO, \
NVL(MODF_HND_NO, 0) SCNO, NVL(NOTC_CNT, 0) GJHC, NVL(NOTC_SND_DATE,' ') GJDT, NVL(ADMIN_NO,' ') KJBH, NVL(UPID_P_ADDR,' ') ADDR, NVL(UPID_MNY, 0) MNKM, \
NVL(NAME,' ') NAME,NVL(NOTC_SND_ID,' ') CSID FROM PUBL_UNPAYEDNOTICE"

/***************************************************************************
   PUBR_PASSCLOSE :   -ok
***************************************************************************/
#define S_PUBR_PASSCLOSE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(LANE_NO,' ') CRBH, NVL(WRK_DATE,' ') KMDT, NVL(SNO, 0) IRBH, \
NVL(OCC_DATE,' ') BSDT, NVL(ADV_REV_DIV, 0) JJHJ, NVL(AXLE_CODE,' ') CSCD, NVL(SENS_CAR_KND, 0) GJCJ, NVL(IMG_NO, 0) YSBH, NVL(AXLE, 0) CHUK, \
NVL(YUNPOK, 0) YPOK, NVL(TREAD, 0) YGUR, NVL(CHAPOK, 0) CPOK, NVL(COND, 0) CJAN, NVL(GARAGE, 0) CHGO, NVL(PONT, 0) CHYC, \
NVL(SPED, 0) CSPD, NVL(OFC_HND_SNO, 0) SCNO, NVL(HND_STAT,' ') CRGB FROM PUBR_PASSCLOSE"

/***************************************************************************
   IMGL_TCSIMAGE : TCS -ok
***************************************************************************/
#define S_IMGL_TCSIMAGE    "SELECT NVL(IC_CODE,' ') IC_CODE, NVL(IC_WORK_NO,' ') IC_WORK_NO, NVL(IC_DATE,' ') IC_DATE, \
NVL(IC_HHMI,' ') IC_HHMI, NVL(SER_NO,' ') SER_NO, NVL(DATA_CLASS,' ') DATA_CLASS, NVL(CLASS_MAN,' ') CLASS_MAN, \
NVL(CLASS_TICK,' ') CLASS_TICK, NVL(AXLE_CODE,' ') AXLE_CODE, NVL(IN_IC_CODE,' ') IN_IC_CODE, NVL(IN_LANE_NO,' ') IN_LANE_NO, \
NVL(IN_IC_DATE,' ') IN_IC_DATE, NVL(IN_IC_HHMI,' ') IN_IC_HHMI, NVL(IN_SER_NO,' ') IN_SER_NO, NVL(IN_AXLE_CODE,' ') IN_AXLE_CODE, \
NVL(IN_FIT_GUBUN,' ') IN_FIT_GUBUN, NVL(IN_PASS_KIND,' ') IN_PASS_KIND, NVL(CAR_NO,' ') CAR_NO, NVL(AMT, 0) AMT, NVL(CASH, 0) CASH, \
NVL(SPE_PROC_CODE,' ') SPE_PROC_CODE, NVL(DC_CARD_NO,' ') DC_CARD_NO, NVL(FREE_CARD_NO,' ') FREE_CARD_NO, NVL(FILEPATH,' ') FILEPATH FROM IMGL_TCSIMAGE"

/***************************************************************************
   IMGL_ETCIMAGE : ¬ß -ok  DPROCESSNUM 
***************************************************************************/
#define S_IMGL_ETCIMAGE    "SELECT NVL(OVERDATETIME,' ') OVERDATETIME, NVL(OVERTYPE,' ') OVERTYPE, NVL(WORKNUM,' ') WORKNUM, \
NVL(WORKDATE,' ') WORKDATE, NVL(PROCESSNUM,' ') PROCESSNUM, NVL(OVERCODE,' ') OVERCODE, NVL(CARNUM,' ') CARNUM, \
NVL(WORKTYPE,' ') WORKTYPE, NVL(RCONGCARNUM,' ') RCONGCARNUM, NVL(TRANSNUM,' ') TRANSNUM, NVL(TRIGGERNUM,' ') TRIGGERNUM, \
NVL(IC_CODE,' ') IC_CODE, NVL(RCONG,' ') RCONG, NVL(FILEPATH,' ') FILEPATH, NVL(DPROCESSNUM,' ') DPROCESSNUM FROM IMGL_ETCIMAGE"

/***************************************************************************
   PUBL_UNPAYEDCAR :  -ok  ERCDO, ERCDC, OBBH, ECNO, CHJOO, CSID
***************************************************************************/
#define S_PUBL_UNPAYEDCAR    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(HND_SNO, 0) CRNO, NVL(OFC_CODE,' ') YCCD, \
NVL(RCT_PASS_FARE, 0) SNTM, NVL(VAT, 0) SNBM, NVL(HND_STAT,' ') CRST, NVL(CAR_KND,' ') CHJO, NVL(CAR_NO,' ') CANO, NVL(NAME,' ') NAME, \
NVL(REG_NO,' ') JMBH, NVL(CAR_CLASS,' ') CRJR, NVL(ADDR,' ') HADD, NVL(ZIP_CODE,' ') HZIP, NVL(PHONE_NO,' ') TEL, NVL(PUID_HND_CNT, 0) MCHS, \
NVL(NOTC_ISS_CNT, 0) GJHS, NVL(SMS_SND_CNT, 0) SMSC, NVL(LST_PAYMT_DATE,' ') CJIK, NVL(INT_STAT,' ') CKST, NVL(LPAY_AGR_DATE,' ') AJDT, NVL(CARADR_RQ_YN,' ') ANYN, \
NVL(CARADR_INST_DATE,' ') ANDT, NVL(NOTC_SND_YN_1,' ') GJY1, NVL(NOTC_SND_DATE_1,' ') GJD1, NVL(NOTC_SND_YN_2,' ') GJY2, NVL(NOTC_SND_DATE_2,' ') GJD2, NVL(NOTC_SND_YN_3,' ') GJY3, \
NVL(NOTC_SND_DATE_3,' ') GJD3, NVL(LST_NOTC_DATE,' ') GJCJ, NVL(COL_PASS_FARE, 0) THYK, NVL(DEF_YN,' ') BRYN, NVL(SMS_SND_DATE,' ') SMDT, NVL(LST_MODF_DT,' ') CRDT, \
NVL(OCC_DATE,' ') HHBB, NVL(CAR_DIV,' ') CHGB, NVL(PASS_FARE_VAT, 0) SNBT, NVL(SEZR_YN,' ') ARYN, NVL(SEZR_DATE,' ') ARDT, NVL(LST_PAY_DIV,' ') JBGB, \
NVL(PCHA_DATE,' ') MIDT, NVL(LST_PCHA_MC_CO,' ') IEPT, NVL(LST_APP_NO,' ') SIBH, NVL(LST_CRD_NO,' ') CDBH, NVL(NOTE,' ') BIGO, NVL(BBK_NO,' ') TJBH, \
NVL(LPAY_YN,' ') HBYN, NVL(ORG_VIO_CODE,' ') ERCDO, NVL(AFT_CIO_CODE,' ') ERCDC, NVL(OBU_NO,' ') OBBH, NVL(ECRD_NO,' ') ECNO, NVL(CAR_HND_HPSS,' ') CHJOO, \
NVL(NOTC_SND_ID,' ') CSID FROM PUBL_UNPAYEDCAR"

/***************************************************************************
   PUBL_UNPAYEDLIST :  -ok   LNGB
***************************************************************************/
#define S_PUBL_UNPAYEDLIST    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(HND_SNO, 0) CRNO, \
NVL(MODF_HND_NO, 0) SCNO, NVL(PAY_DIV,' ') JBGB, NVL(RCT_PASS_FARE, 0) SNKM, NVL(PAYMT_DATE,' ') IKDT, NVL(ADMIN_NO,' ') KJBH, NVL(HND_STAT,' ') CRST, \
NVL(HND_TYP,' ') CRTY, NVL(CAR_KND,' ') CHJO, NVL(PASS_FARE_VAT, 0) SNBM, NVL(RCT_DIV,' ') SNGB, NVL(PCHA_CO,' ') IEPT, NVL(APP_NO,' ') SIBH, \
NVL(CRD_NO,' ') CDBH, NVL(BBK_NO,' ') TJBH, NVL(UPID_HND_PLZ_ID,' ') PLIDR, NVL(LANE_DIV,' ') LNGB FROM PUBL_UNPAYEDLIST"

/***************************************************************************
   TOFS10T :  -@@
***************************************************************************/
#define S_TOFS10T    "SELECT NVL(SEQ, 0) SEQ, NVL(TJBH,' ') TJBH, NVL(IKDT,' ') IKDT, NVL(IGNM,' ') IGNM, \
NVL(IGAK, 0) IGAK, NVL(CJAK, 0) CJAK, NVL(GOAK, 0) GOAK, NVL(IGGB,' ') IGGB, NVL(CRGB,' ') CRGB, \
NVL(BIGO,' ') BIGO, NVL(DCDT,' ') DCDT, NVL(DCIM,' ') DCIM, NVL(DCAK, 0) DCAK, NVL(HBYN,' ') HBYN, NVL(SSAK, 0) SSAK FROM TOFS10T"

/***************************************************************************
   TOFS11T : () -@@
***************************************************************************/
#define S_TOFS11T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KJBH,' ') KJBH, NVL(PBYN,' ') PBYN, \
NVL(CRBH,' ') CRBH, NVL(CHJO,' ') CHJO, NVL(SNKM, 0) SNKM, NVL(CRSU,' ') CRSU, NVL(GJBH, 0) GJBH FROM TOFS11T"

/***************************************************************************
   TCSR_LANEUNPAYEDPAY :    -ok
***************************************************************************/
#define S_TCSR_LANEUNPAYEDPAY    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, \
NVL(SNO, 0) CRNO, NVL(HND_DT,' ') CRDT, NVL(CSH_RCT_FARE, 0) HKAK, NVL(CCRD_RCT_FARE, 0) SYAK, NVL(DUMMY_FARE, 0) GCAK, NVL(ECRD_RCT_FARE, 0) SCAK, \
NVL(IMP_DIV,' ') SIGB, NVL(RCT_BALC, 0) SNJA, NVL(CRD_DIV,' ') CDJR, NVL(CRD_NO,' ') CDBH, NVL(UPID_OCC_SNO, 0) BSIR, NVL(UPID_PCHA_SNO, 0) CRIR, \
NVL(PAY_HND_DIV,' ') JBGB, NVL(AGORZ_ID,' ') ALGID, NVL(PSAM_ID,' ') PSAMID, NVL(PCHA_DATE,' ') GMDT, NVL(TRAN_TYP,' ') TRTPSAM, \
NVL(ET_MNY_CO_ID,' ') PPIEP, NVL(ET_MNY_ID,' ') IEP, NVL(ET_MNY_DEAL_NO,' ') NTIEP, NVL(DEAL_NO,' ') NTPSAM, NVL(TRAD_SUM,' ') MTOTPSAM, \
NVL(ET_MNY_CO_DEAL_NO,' ') NIPP, NVL(TRAN_CLCT_NO,' ') NC, NVL(PSAM_TRAN_SIGN1,' ') VKPSAM1, NVL(PSAM_CRT_SIGN1,' ') SINDC1, NVL(PSAM_TRAN_SIGN2,' ') VKPSAM2, \
NVL(PSAM_CRT_SIGN2,' ') SINDC2, NVL(ID_CENTER,' ') IDCENTER, NVL(CAR_NO,' ') CARNO FROM TCSR_LANEUNPAYEDPAY"

/***************************************************************************
   IMGL_SPECIAL :  _ -ok
***************************************************************************/
#define S_IMGL_SPECIAL    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, \
NVL(HND_SNO, 0) CRNO, NVL(SPCL_HND_CD,' ') TBCD, NVL(HND_DATE,' ') CRDT, NVL(ADMIN_NO,' ') KRID, NVL(SPCL_HND_CD_DTL,' ') TBSS, NVL(NOTE,' ') BIGO, NVL(CAR_NO,' ') CANO FROM IMGL_SPECIAL"

/***************************************************************************
   TOFS14T :  -@@
***************************************************************************/
#define S_TOFS14T    "SELECT NVL(T_TRADEID,' ') T_TRADEID, NVL(T_CARNO,' ') T_CARNO, NVL(T_MOBILID,' ') T_MOBILID, \
NVL(T_PRDTNM,' ') T_PRDTNM, NVL(T_HPHONE,' ') T_HPHONE, NVL(T_JUMIN,' ') T_JUMIN, NVL(T_MONEY,' ') T_MONEY, \
NVL(T_LOCATION,' ') T_LOCATION, NVL(T_EMAIL,' ') T_EMAIL, NVL(T_ACTDATE,' ') T_ACTDATE, NVL(T_CHECK,' ') T_CHECK, NVL(T_BIGO,' ') T_BIGO FROM TOFS14T"

/***************************************************************************
   TOFS15T :  SMS  -@@
***************************************************************************/
#define S_TOFS15T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, NVL(CRNO, 0) CRNO, \
NVL(JSNO, 0) JSNO, NVL(KJBH,' ') KJBH, NVL(JHBH,' ') JHBH, NVL(JSDT,' ') JSDT, NVL(BIGO,' ') BIGO FROM TOFS15T"

/***************************************************************************
   IMGL_TOTIMAGE : FULL -ok
***************************************************************************/
#define S_IMGL_TOTIMAGE    "SELECT NVL(IC_CODE,' ') IC_CODE, NVL(IC_WORK_NO,' ') IC_WORK_NO, NVL(IC_DATE,' ') IC_DATE, \
NVL(IC_HHMI,' ') IC_HHMI, NVL(SER_NO,' ') SER_NO, NVL(DATA_CLASS,' ') DATA_CLASS, NVL(CLASS_MAN,' ') CLASS_MAN, \
NVL(CLASS_TICK,' ') CLASS_TICK, NVL(AXLE_CODE,' ') AXLE_CODE, NVL(IN_IC_CODE,' ') IN_IC_CODE, NVL(IN_LANE_NO,' ') IN_LANE_NO, \
NVL(IN_IC_DATE,' ') IN_IC_DATE, NVL(IN_IC_HHMI,' ') IN_IC_HHMI, NVL(IN_SER_NO,' ') IN_SER_NO, NVL(IN_AXLE_CODE,' ') IN_AXLE_CODE, \
NVL(IN_FIT_GUBUN,' ') IN_FIT_GUBUN, NVL(IN_PASS_KIND,' ') IN_PASS_KIND, NVL(CAR_NO,' ') CAR_NO, NVL(AMT, 0) AMT, NVL(CASH, 0) CASH, \
NVL(SPE_PROC_CODE,' ') SPE_PROC_CODE, NVL(DC_CARD_NO,' ') DC_CARD_NO, NVL(FREE_CARD_NO,' ') FREE_CARD_NO, NVL(FILEPATH,' ') FILEPATH FROM IMGL_TOTIMAGE"

/***************************************************************************
   PUBL_BANKBOOK : /  -ok
***************************************************************************/
#define S_PUBL_BANKBOOK    "SELECT NVL(PAYMT_DATE,' ') IGDT, NVL(PAYMT_NM,' ') IGNM, NVL(PAYMT_SUM, 0) IGAK, NVL(HND_BALC, 0) CJAK, \
NVL(OEPAY_MNY, 0) GOAK, NVL(PAYMT_DIV,' ') TGGB, NVL(HND_DIV,' ') CRGB, NVL(NOTE,' ') BIGO, NVL(ALT_DATE,' ') DCDT, NVL(ALT_PAYMT_NM,' ') DCNM, \
NVL(ALT_MNY, 0) DCAK, NVL(RFND_YN,' ') HBYB, NVL(FEE, 0) SSAK, NVL(PCHA_CO,' ') IEPT FROM PUBL_BANKBOOK"

/***************************************************************************
   PUBL_BANKBOOKPRO : /  -ok
***************************************************************************/
#define S_PUBL_BANKBOOKPRO    "SELECT NVL(PAYMT_DATE,' ') IGDT, NVL(PAYMT_NM,' ') IGNM, NVL(LNK_IC_NO,' ') YGBH, NVL(PLZ_ID,' ') ICBH, \
NVL(OCC_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(OFC_CODE,' ') YBCD, NVL(HND_NO, 0) IRBH, NVL(HND_MNY, 0) CRAK, NVL(VIO_CODE,' ') YCCD  FROM PUBL_BANKBOOKPRO"

/***************************************************************************
   ETCL_VIOLATION : ¬ß  -ok
***************************************************************************/
#define S_ETCL_VIOLATION    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(HND_SNO, 0) CRNO, \
NVL(MODF_HND_NO, 0) SCNO, NVL(OCC_DIV,' ') BSGB, NVL(MODF_VIO_CODE,' ') YCCD, NVL(OCC_DATE,' ') CRDT, NVL(HND_TYP,' ') CRYH, NVL(LPAY_YN,' ') HBYN, \
NVL(CHG_CAR_KND,' ') CHJO, NVL(CAR_NO,' ') CANO, NVL(KND_DIV,' ') SNGB, NVL(ORG_PASS_FARE, 0) WTHK, NVL(PASS_FARE, 0) THYK, NVL(VAT, 0) BGKM, \
NVL(PCHA_MC_CO,' ') IEPT, NVL(CRD_NO,' ') CDBH, NVL(APP_NO,' ') SIBH, NVL(NOTE,' ') BIGO, NVL(PAY_DIV,' ') JBGB, NVL(HND_TM,' ') CRTI, \
NVL(LPAY_AGR_DAY,' ') HBDT, NVL(NAME,' ') NAME, NVL(REG_NO,' ') JMBH, NVL(ADDR,' ') ADDR, NVL(PHONE_NO,' ') JHBH, NVL(RCT_FARE, 0) SSKM, \
NVL(ADMIN_NO,' ') MNBH, NVL(PASS_FARE_VAT, 0) BTKM, NVL(CAR_KND,' ') CHJR, NVL(CAR_DIV,' ') CHGB FROM ETCL_VIOLATION"

/***************************************************************************
   WIML_AXLE : AXLE() -ok
***************************************************************************/
#define S_WIML_AXLE    "SELECT NVL(WIM_DATE,' ') WIM_DATE, NVL(WIM_ID, 0) WIM_ID, NVL(WIM_DATETIME,' ') WIM_DATETIME, \
NVL(WIM_LANENUM, 0) WIM_LANENUM, NVL(WIM_SERIALNUM, 0) WIM_SERIALNUM, NVL(WIM_AXLECOUNT, 0) WIM_AXLECOUNT, \
NVL(WIM_SPEED, 0) WIM_SPEED, NVL(WIM_GROSSWEIGHT, 0) WIM_GROSSWEIGHT, NVL(WIM_AXLE1_STATE, 0) WIM_AXLE1_STATE, \
NVL(WIM_AXLE1_FLAG, 0) WIM_AXLE1_FLAG, NVL(WIM_AXLE1_DESTANCE, 0) WIM_AXLE1_DESTANCE, NVL(WIM_AXLE1_LWEIGHT, 0) WIM_AXLE1_LWEIGHT, \
NVL(WIM_AXLE1_RWEIGHT, 0) WIM_AXLE1_RWEIGHT, NVL(WIM_AXLE2_STATE, 0) WIM_AXLE2_STATE, NVL(WIM_AXLE2_FLAG, 0) WIM_AXLE2_FLAG, \
NVL(WIM_AXLE2_DESTANCE, 0) WIM_AXLE2_DESTANCE, NVL(WIM_AXLE2_LWEIGHT, 0) WIM_AXLE2_LWEIGHT, NVL(WIM_AXLE2_RWEIGHT, 0) WIM_AXLE2_RWEIGHT, \
NVL(WIM_AXLE3_STATE, 0) WIM_AXLE3_STATE, NVL(WIM_AXLE3_FLAG, 0) WIM_AXLE3_FLAG, NVL(WIM_AXLE3_DESTANCE, 0) WIM_AXLE3_DESTANCE, \
NVL(WIM_AXLE3_LWEIGHT, 0) WIM_AXLE3_LWEIGHT, NVL(WIM_AXLE3_RWEIGHT, 0) WIM_AXLE3_RWEIGHT, NVL(WIM_AXLE4_STATE, 0) WIM_AXLE4_STATE, \
NVL(WIM_AXLE4_FLAG, 0) WIM_AXLE4_FLAG, NVL(WIM_AXLE4_DESTANCE, 0) WIM_AXLE4_DESTANCE, NVL(WIM_AXLE4_LWEIGHT, 0) WIM_AXLE4_LWEIGHT, \
NVL(WIM_AXLE4_RWEIGHT, 0) WIM_AXLE4_RWEIGHT, NVL(WIM_AXLE5_STATE, 0) WIM_AXLE5_STATE, NVL(WIM_AXLE5_FLAG, 0) WIM_AXLE5_FLAG, \
NVL(WIM_AXLE5_DESTANCE, 0) WIM_AXLE5_DESTANCE, NVL(WIM_AXLE5_LWEIGHT, 0) WIM_AXLE5_LWEIGHT, NVL(WIM_AXLE5_RWEIGHT, 0) WIM_AXLE5_RWEIGHT, \
NVL(WIM_AXLE6_STATE, 0) WIM_AXLE6_STATE, NVL(WIM_AXLE6_FLAG, 0) WIM_AXLE6_FLAG, NVL(WIM_AXLE6_DESTANCE, 0) WIM_AXLE6_DESTANCE, \
NVL(WIM_AXLE6_LWEIGHT, 0) WIM_AXLE6_LWEIGHT, NVL(WIM_AXLE6_RWEIGHT, 0) WIM_AXLE6_RWEIGHT, NVL(WIM_AXLE7_STATE, 0) WIM_AXLE7_STATE, \
NVL(WIM_AXLE7_FLAG, 0) WIM_AXLE7_FLAG, NVL(WIM_AXLE7_DESTANCE, 0) WIM_AXLE7_DESTANCE, NVL(WIM_AXLE7_LWEIGHT, 0) WIM_AXLE7_LWEIGHT, \
NVL(WIM_AXLE7_RWEIGHT, 0) WIM_AXLE7_RWEIGHT, NVL(WIM_AXLE8_STATE, 0) WIM_AXLE8_STATE, NVL(WIM_AXLE8_FLAG, 0) WIM_AXLE8_FLAG, \
NVL(WIM_AXLE8_DESTANCE, 0) WIM_AXLE8_DESTANCE, NVL(WIM_AXLE8_LWEIGHT, 0) WIM_AXLE8_LWEIGHT, NVL(WIM_AXLE8_RWEIGHT, 0) WIM_AXLE8_RWEIGHT, \
NVL(WIM_PADNUM,' ') WIM_PADNUM FROM WIML_AXLE"

/***************************************************************************
   WIML_LSAM : LAME() -ok
***************************************************************************/
#define S_WIML_LSAM    "SELECT NVL(WIM_DATE,' ') WIM_DATE, NVL(WIM_ID, 0) WIM_ID, NVL(WIM_DATETIME,' ') WIM_DATETIME, \
NVL(WIM_LANENUM, 0) WIM_LANENUM, NVL(WIM_SERIALNUM, 0) WIM_SERIALNUM, NVL(LANE_IMAGEPATH,' ') LANE_IMAGEPATH, \
NVL(LANE_IMAGEWIDTH, 0) LANE_IMAGEWIDTH, NVL(LANE_IMAGEHEIGHT, 0) LANE_IMAGEHEIGHT, NVL(LANE_GRAY, 0) LANE_GRAY, \
NVL(LANE_PARTGRAY, 0) LANE_PARTGRAY, NVL(LANE_IRIS, 0) LANE_IRIS, NVL(LANE_CDS, 0) LANE_CDS, NVL(LANE_SHUTTER, 0) LANE_SHUTTER, \
NVL(LANE_GAIN, 0) LANE_GAIN, NVL(LANE_STB, 0) LANE_STB, NVL(LANE_PLATEPOSX, 0) LANE_PLATEPOSX, NVL(LANE_PLATEPOSY, 0) LANE_PLATEPOSY, \
NVL(LANE_PLATEWIDTH, 0) LANE_PLATEWIDTH, NVL(LANE_PLATEHEIGHT, 0) LANE_PLATEHEIGHT, NVL(LANE_RECOGNITIONSTATUS, 0) LANE_RECOGNITIONSTATUS, \
NVL(LANE_PLATENUMBER,' ') LANE_PLATENUMBER FROM WIML_LSAM"

/***************************************************************************
   WIML_WIM : WIM() -ok
***************************************************************************/
#define S_WIML_WIM    "SELECT NVL(WIM_DATE,' ') WIM_DATE, NVL(WIM_ID, 0) WIM_ID, NVL(WIM_DATETIME,' ') WIM_DATETIME, \
NVL(WIM_LANENUM, 0) WIM_LANENUM, NVL(WIM_SERIALNUM, 0) WIM_SERIALNUM, NVL(WIM_AXLECOUNT, 0) WIM_AXLECOUNT, \
NVL(WIM_SPEED, 0) WIM_SPEED, NVL(WIM_GROSSWEIGHT, 0) WIM_GROSSWEIGHT, NVL(WIM_AXLESTATE, 0) WIM_AXLESTATE, \
NVL(WIM_AXLE1_WEIGHT, 0) WIM_AXLE1_WEIGHT, NVL(WIM_AXLE2_WEIGHT, 0) WIM_AXLE2_WEIGHT, NVL(WIM_AXLE3_WEIGHT, 0) WIM_AXLE3_WEIGHT, \
NVL(WIM_AXLE4_WEIGHT, 0) WIM_AXLE4_WEIGHT, NVL(WIM_AXLE5_WEIGHT, 0) WIM_AXLE5_WEIGHT, NVL(WIM_AXLE6_WEIGHT, 0) WIM_AXLE6_WEIGHT, \
NVL(WIM_AXLE7_WEIGHT, 0) WIM_AXLE7_WEIGHT, NVL(WIM_AXLE8_WEIGHT, 0) WIM_AXLE8_WEIGHT, NVL(WIM_FLAG_TRSD, 0) WIM_FLAG_TRSD, \
NVL(WIM_FLAG_VIOLATION, 0) WIM_FLAG_VIOLATION, NVL(WIM_FLAG_OVERGROSSWEIGHT, 0) WIM_FLAG_OVERGROSSWEIGHT, \
NVL(WIM_FLAG_OVERAXLEWEIGHT, 0) WIM_FLAG_OVERAXLEWEIGHT, NVL(WIM_FLAG_OVERHEIGHTHIGH, 0) WIM_FLAG_OVERHEIGHTHIGH, \
NVL(WIM_FLAG_OVERHEIGHTLOW, 0) WIM_FLAG_OVERHEIGHTLOW, NVL(WIM_FLAG_OVERSPEED, 0) WIM_FLAG_OVERSPEED, \
NVL(WIM_FLAG_AXLEVIOLATION, 0) WIM_FLAG_AXLEVIOLATION, NVL(WIM_FLAG_LANDINGGEAR, 0) WIM_FLAG_LANDINGGEAR, \
NVL(WIM_FLAG_AXLELRVIOLATION, 0) WIM_FLAG_AXLELRVIOLATION, NVL(WIM_FLAG_AXLEFRVIOLATION, 0) WIM_FLAG_AXLEFRVIOLATION, \
NVL(WIM_FLAG_AXLEBALANCEVIOLATION, 0) WIM_FLAG_AXLEBALANCEVIOLATION, NVL(WIM_SECONDDATA_DATETIME,' ') WIM_SECONDDATA_DATETIME, \
NVL(WIM_SECONDDATA_LANENUM, 0) WIM_SECONDDATA_LANENUM, NVL(WIM_SECONDDATA_SERIALNUM, 0) WIM_SECONDDATA_SERIALNUM, \
NVL(WIM_THRIDDATA_DATETIME,' ') WIM_THRIDDATA_DATETIME, NVL(WIM_THRIDDATA_LANENUM, 0) WIM_THRIDDATA_LANENUM, \
NVL(WIM_THRIDDATA_SERIALNUM, 0) WIM_THRIDDATA_SERIALNUM FROM WIML_WIM"

/***************************************************************************
   WIML_TS : TS -ok
***************************************************************************/
#define S_WIML_TS    "SELECT NVL(TS_DATE,' ') TS_DATE, NVL(TS_DATETIME,' ') TS_DATETIME, NVL(TS_SERIALNUM,' ') TS_SERIALNUM, \
NVL(TS_NINDEX, 0) TS_NINDEX, NVL(TS_FIND_INDEX, 0) TS_FIND_INDEX, NVL(TS_PLACE,' ') TS_PLACE, NVL(TS_PLACE_ID,' ') TS_PLACE_ID, \
NVL(TS_CAR_NUM,' ') TS_CAR_NUM, NVL(TS_IMG_PATH,' ') TS_IMG_PATH, NVL(TS_AX_CNT, 0) TS_AX_CNT, NVL(TS_COMPANY,' ') TS_COMPANY, \
NVL(TS_WORKER,' ') TS_WORKER, NVL(TS_GW, 0) TS_GW, NVL(TS_AX1, 0) TS_AX1, NVL(TS_AX2, 0) TS_AX2, NVL(TS_AX3, 0) TS_AX3, \
NVL(TS_AX4, 0) TS_AX4, NVL(TS_AX5, 0) TS_AX5, NVL(TS_AX6, 0) TS_AX6, NVL(TS_AX7, 0) TS_AX7, NVL(TS_AX8, 0) TS_AX8, \
NVL(TS_RESULTE_INT, 0) TS_RESULTE_INT, NVL(TS_RESULTE,' ') TS_RESULTE, NVL(TS_OPER_TYPE, 0) TS_OPER_TYPE, \
NVL(TS_F_DATETIME,' ') TS_F_DATETIME, NVL(TS_F_LANE, 0) TS_F_LANE, NVL(TS_F_SERIALNUM, 0) TS_F_SERIALNUM, \
NVL(TS_F_AX_CNT, 0) TS_F_AX_CNT, NVL(TS_F_SPEED, 0) TS_F_SPEED, NVL(TS_F_GW, 0) TS_F_GW, NVL(TS_F_AX1, 0) TS_F_AX1, \
NVL(TS_F_AX2, 0) TS_F_AX2, NVL(TS_F_AX3, 0) TS_F_AX3, NVL(TS_F_AX4, 0) TS_F_AX4, NVL(TS_F_AX5, 0) TS_F_AX5, \
NVL(TS_F_AX6, 0) TS_F_AX6, NVL(TS_F_AX7, 0) TS_F_AX7, NVL(TS_F_AX8, 0) TS_F_AX8, NVL(TS_F_RESULTE,' ') TS_F_RESULTE, \
NVL(TS_STD_AXLE, 0) TS_STD_AXLE, NVL(TS_STD_GROSSAXLE, 0) TS_STD_GROSSAXLE, NVL(TS_STD_HEIGHT, 0) TS_STD_HEIGHT, \
NVL(TS_HEIGHT, 0) TS_HEIGHT, NVL(TS_HEIGHT_POS, 0) TS_HEIGHT_POS, NVL(TS_HEIGHT_INT, 0) TS_HEIGHT_INT, \
NVL(TS_HEIGHT_RESULTE,' ') TS_HEIGHT_RESULTE, NVL(TS_NOTE,' ') TS_NOTE, NVL(SPACE1,' ') SPACE1, NVL(SPACE2,' ') SPACE2, \
NVL(SPACE3,' ') SPACE3, NVL(SPACE4,' ') SPACE4, NVL(SPACE5,' ') SPACE5, NVL(SPACE6,' ') SPACE6, NVL(SPACE7,' ') SPACE7, \
NVL(SPACE8,' ') SPACE8, NVL(SPACE9,' ') SPACE9, NVL(SPACE10,' ') SPACE10, NVL(SPACE11, 0) SPACE11, NVL(SPACE12, 0) SPACE12, \
NVL(SPACE13, 0) SPACE13, NVL(SPACE14, 0) SPACE14, NVL(SPACE15, 0) SPACE15 FROM WIML_TS"

/***************************************************************************
   PUBR_WORKSTART :  -ok
***************************************************************************/
#define S_PUBR_WORKSTART    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, NVL(STRT_DATE,' ') STDT, \
NVL(TRMN_NO,' ') DMBH, NVL(LANE_DIV,' ') CRTY, NVL(WRK_DIV,' ') KMGB, NVL(SND_NO, 0) JSYB FROM PUBR_WORKSTART"

/***************************************************************************
   TCSR_SENSING : TCS  -ok
***************************************************************************/
#define S_TCSR_SENSING    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, \
NVL(SENS_YMDHMS,' ') GJDT, NVL(SENS_SNO, 0) GJBH, NVL(ADV_REV_DIV,' ') JJHJ, NVL(CAR_KND,' ') CSCD, NVL(DOUB_INFO_HND,' ') DOUB, NVL(AXLE,' ') CHUK FROM TCSR_SENSING"

/***************************************************************************
   ETCR_SENSING : ¬ß  -ok
***************************************************************************/
#define S_ETCR_SENSING    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(SENS_TM,' ') GJDT, \
NVL(SENS_SNO, 0) GJBH, NVL(G_DIV,' ') GTGB, NVL(ADV_REV_DIV,' ') JJHJ, NVL(END_CAR_KND,' ') GJCJ, NVL(HND_CAR_KND,' ') C_GJCJ, NVL(AXLE, 0) CHUK, \
NVL(YUNPOK, 0) YPOK, NVL(TREAD, 0) YGUR, NVL(CHAPOK, 0) CPOK, NVL(COND, 0) CJAN, NVL(GARAGE, 0) CHGO, NVL(PONT, 0) CHYC, NVL(SPED, 0) SPED, \
NVL(HND_YN,' ') CRYN, NVL(SND_NO, 0) JSYB FROM ETCR_SENSING"

/***************************************************************************
   TCSR_HANDLE : TCS  -ok
***************************************************************************/
#define S_TCSR_HANDLE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, NVL(HND_SNO, 0) CRNO, \
NVL(CAR_KND,' ') CHJO, NVL(HND_TM,' ') HHBB, NVL(SENS_SNO, 0) GJBH, NVL(ORG_PASS_FARE, 0) THYK, NVL(COL_PASS_FARE, 0) JSKM, NVL(RCT_CSH, 0) SSKM, \
NVL(AXLE_CODE,' ') CSCD, NVL(IMP_DIV,' ') SIGB, NVL(DC_CRD_NO,' ') HCBH, NVL(CRD_NO,' ') CDBH, NVL(DUMMY1, 0) GCKM, NVL(DUMMY2,' ') GCYN, \
NVL(DUMMY3, 0) GC1KM, NVL(DUMMY4,' ') GC1NO, NVL(NW_OD_FARE_DIV,' ') NOGB, NVL(RCT_DIV,' ') SNGB, NVL(LNK_EXMT_DIV,' ') YMGB FROM TCSR_HANDLE"

/***************************************************************************
   ETCR_HANDLE : ¬ß  -ok
***************************************************************************/
#define S_ETCR_HANDLE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(SND_NO, 0) JSYB, NVL(IO_KND,' ') IOGB, \
NVL(HND_SNO, 0) CRNO, NVL(OPER_DIV,' ') ORGB, NVL(HND_DIV,' ') CRGB, NVL(HPSS_HND_SNO, 0) HIPBH, NVL(BE_HND_TM,' ') BE_CRTI, NVL(BE_PLZ_CO,' ') BE_ORID, \
NVL(BE_PLZ_ID,' ') BE_PLID, NVL(BE_HND_TYP,' ') BE_CRTY, NVL(BE_LANE_NO,' ') BE_CRBH, NVL(BE_WRK_NO,' ') BE_KMBH, NVL(BE_HND_SNO, 0) BE_CRNO, \
NVL(BE_COL_PASS_FARE, 0) BE_WTHYK, NVL(BE_RCT_PASS_FARE, 0) BE_JSKM, NVL(BE_CAR_KND,' ') BE_CHJO, NVL(C_BE_CAR_KND,' ') C_BE_CHJO, NVL(BE_CAR_NO,' ') BE_BEPLID, \
NVL(BE_CRD_INFO_DIV,' ') BE_CDGB, NVL(HND_TM,' ') CRTI, NVL(VIO_CODE,' ') ERCD, NVL(ORG_PASS_FARE, 0) THYK, NVL(COL_PASS_FARE, 0) JSKM, NVL(RCT_PASS_FARE, 0) SNKM, NVL(RCT_CRD_BALC, 0) SNJM, \
NVL(PAY_DCRTE,' ') JBHI, NVL(ECRD_RCT_DIV,' ') SSGB, NVL(ECRD_KND,' ') SCTY, NVL(CAR_KND,' ') CHJO, NVL(CHG_CAR_KND,' ') C_CHJO, NVL(CRD_NO,' ') CDBH, NVL(PAY_HND_DIV,' ') JCGB, \
NVL(WRK_DIV,' ') KMGB, NVL(SENS_CAR_KND,' ') GJCJ, NVL(OBU_CAR_KND,' ') OBCJ, NVL(IMG_NO, 0) YSBH, NVL(OBU_NO,' ') OBBH, NVL(OBU_TYP,' ') OBTY, NVL(OBU_STAT,' ') OBST, \
NVL(ECRD_STAT,' ') CDST, NVL(COL_STAT,' ') JSST, NVL(ACRDT_STAT,' ') IJST, NVL(CBN_HND_STAT,' ') TCST, NVL(VIO_STAT,' ') WVST, NVL(CAR_NO,' ') CARNO, NVL(LNK_EXMT_DIV,' ') JOINEXMGB, \
NVL(RCT_DIV,' ') SNGB, NVL(EX_ID,' ') LOGICALID, NVL(AGORZ_ID,' ') ALGID, NVL(PSAM_ID,' ') PSAMID, NVL(PCHA_DATE,' ') GMDT, NVL(TRAN_TYP,' ') TRTPSAM, \
NVL(ET_MNY_CO_ID,' ') PPIEP, NVL(ET_MNY_ID,' ') IEP, NVL(ET_MNY_TRAN_SNO,' ') NTIEP, NVL(TRAD_SNO,' ') NTPSAM, NVL(TRAD_SUM,' ') MTOTPSAM, NVL(ET_CO_TRAD_NO,' ') NIPP, NVL(DEAL_CLCT_SNO,' ') NC, \
NVL(PSAM_TRAD_SIGN1,' ') VKPSAM1, NVL(PSAM_CRT_SIGN1,' ') SINDC1, NVL(PSAM_TRAD_SIGN2,' ') VKPSAM2, NVL(PSAM_CRT_SIGN2,' ') SINDC2, NVL(ID_CENTER,' ') IDCENTER FROM ETCR_HANDLE"

/***************************************************************************
   TRFM_CARDCONFIRM :   -ok
***************************************************************************/
#define S_TRFM_CARDCONFIRM    "SELECT NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, NVL(CRNO, 0) CRNO, NVL(JSYB, 0) JSYB, NVL(CRDT,' ') CRDT, \
NVL(CRTI,' ') CRTI, NVL(KJBH,' ') KJBH, NVL(CHJO,' ') CHJO, NVL(CSCD,' ') CSCD, NVL(THKM, 0) THKM, NVL(CDBH,' ') CDBH FROM TRFM_CARDCONFIRM"

/***************************************************************************
   TORG07T :   -@@
***************************************************************************/
#define S_TORG07T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, NVL(CRNO, 0) CRNO, \
NVL(HCNO,' ') HCNO, NVL(CRGB,' ') CRGB, NVL(CRDT,' ') CRDT, NVL(CRTI,' ') CRTI, NVL(KJBH,' ') KJBH, NVL(CHJO,' ') CHJO, \
NVL(CSCD,' ') CSCD, NVL(THKM, 0) THKM, NVL(CCKM, 0) CCKM, NVL(CMSB, 0) CMSB, NVL(EDMK,' ') EDMK FROM TORG07T"

/***************************************************************************
   TCSR_SALECONFIRM : TCS  -ok
***************************************************************************/
#define S_TCSR_SALECONFIRM    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(HND_SNO, 0) CRNO, \
NVL(DATE_DIV,' ') YIGB, NVL(HR_DIV,' ') SGGB, NVL(DC_EXTR_DIV,' ') HHGB, NVL(CAR_KND,' ') CHJO, NVL(COL_PASS_FARE, 0) THYK, \
NVL(DC_APL_TYP,' ') HIYH, NVL(DC_EXTR,' ') HIHJ, NVL(COL_RCT_PASS_FARE, 0) SNKM FROM TCSR_SALECONFIRM"

/***************************************************************************
   TORG09T : ¬ß  -@@
***************************************************************************/
#define S_TORG09T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, NVL(CRNO, 0) CRNO, \
NVL(YIGB,' ') YIGB, NVL(SGGB,' ') SGGB, NVL(HHGB,' ') HHGB, NVL(CHJO,' ') CHJO, NVL(THYK, 0) THYK, NVL(HIYH,' ') HIYH, \
NVL(HIHJ,' ') HIHJ, NVL(SNKM, 0) SNKM FROM TORG09T"

/***************************************************************************
   PUBR_CARDCONFIRM : TCS   -ok  LNGB 
***************************************************************************/
#define S_PUBR_CARDCONFIRM    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, \
NVL(HND_SNO, 0) CRNO, NVL(AXLE_CODE,' ') CSCD, NVL(HND_TM,' ') CRTM, NVL(COL_PASS_FARE, 0) JSYM, NVL(WOUT_MNY, 0) CMKM, NVL(PAY_BE_MNY, 0) CJCM, \
NVL(DCRTE,' ') JBHI, NVL(RCT_DIV,' ') SNGB, NVL(CRD_KND,' ') CDGB, NVL(CAR_KND,' ') CHJO, NVL(CRD_NO,' ') CDBH, NVL(PAY_HND_DIV,' ') JCGB, \
NVL(DC_CRD_NO,' ') MCBH, NVL(LNK_DIV,' ') YKGB, NVL(OBU_NO,' ') DMBH, NVL(AGORZ_ID,' ') ALGID, NVL(PSAM_ID,' ') PSAMID, NVL(PCHA_DATE,' ') GMDT, \
NVL(TRAN_TYP,' ') TRTPSAM, NVL(ET_MNY_CO_ID,' ') PPIEP, NVL(ET_MNY_ID,' ') IEP, NVL(ET_MNY_TRAN_SNO,' ') NTIEP, NVL(TRAN_SNO,' ') NTPSAM, NVL(TRAD_SUM,' ') MTOTPSAM, \
NVL(ET_CO_TRAD_NO,' ') NIPP, NVL(DEAL_CLCT_SNO,' ') NC, NVL(PSAM_TRAD_SIGN1,' ') VKPSAM1, NVL(PSAM_CRT_SIGN1,' ') SINDC1, NVL(PSAM_TRAD_SIGN2,' ') VKPSAM2, NVL(PSAM_CRT_SIGN2,' ') SINDC2, \
NVL(ID_CENTER,' ') IDCENTER, NVL(LANE_DIV,' ') LNGB FROM PUBR_CARDCONFIRM"

/***************************************************************************
   TCSR_CARDDATA :  ( ) -ok
***************************************************************************/
#define S_TCSR_CARDDATA    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, \
NVL(HND_SNO, 0) CRNO, NVL(OCC_DATE,' ') HHBB, NVL(CRD_KND, 0) CDGB, NVL(SYS_CLASS,' ') STJB, NVL(CAR_KND,' ') CHJO, NVL(AXLE_CODE,' ') CSCD, \
NVL(COL_PASS_FARE, 0) THYK, NVL(CRD_NO,' ') CDBH, NVL(CRD_SPCL_HND,' ') CDMH FROM TCSR_CARDDATA"

/***************************************************************************
   TORG12T :  -@@
***************************************************************************/
#define S_TORG12T    "SELECT NVL(YGBH,' ') YGBH, NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, \
NVL(CRNO, 0) CRNO, NVL(HHBB,' ') HHBB, NVL(KJBH,' ') KJBH, NVL(CHJO,' ') CHJO, NVL(CSCD,' ') CSCD, NVL(THYK, 0) THYK, NVL(SNYK, 0) SNYK FROM TORG12T"

/***************************************************************************
   TORG13T :    -@@
***************************************************************************/
#define S_TORG13T    "SELECT NVL(PLID,' ') PLID, NVL(CRBH,' ') CRBH, NVL(KMDT,' ') KMDT, NVL(GJCT,' ') GJCT, \
NVL(CJDT,' ') CJDT, NVL(CRNO, 0) CRNO, NVL(GJW1, 0) GJW1, NVL(GJW2, 0) GJW2, NVL(GJW3, 0) GJW3, NVL(GJW4, 0) GJW4, \
NVL(GJW5, 0) GJW5, NVL(GJW6, 0) GJW6, NVL(GJW7, 0) GJW7, NVL(GJW8, 0) GJW8, NVL(GJTW, 0) GJTW, NVL(GJTO, 0) GJTO, \
NVL(GJGN, 0) GJGN, NVL(CJTA, 0) CJTA, NVL(CJW1, 0) CJW1, NVL(CJW2, 0) CJW2, NVL(CJW3, 0) CJW3, NVL(CJW4, 0) CJW4, \
NVL(CJW5, 0) CJW5, NVL(CJW6, 0) CJW6, NVL(CJW7, 0) CJW7, NVL(CJW8, 0) CJW8, NVL(CJTW, 0) CJTW, NVL(YCNO,' ') YCNO, \
NVL(CRHS,' ') CRHS, NVL(CRJR,' ') CRJR, NVL(GJSM,' ') GJSM, NVL(JMBH,' ') JMBH, NVL(JUSO,' ') JUSO, NVL(YTEL,' ') YTEL, \
NVL(BIGO,' ') BIGO, NVL(LTAW, 0) LTAW, NVL(LTTW, 0) LTTW FROM TORG13T"

/***************************************************************************
   TCSR_SPECIAL :   -ok
***************************************************************************/
#define S_TCSR_SPECIAL    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, \
NVL(HND_SNO, 0) CRNO, NVL(SPCL_HND_CODE,' ') TBCD, NVL(OCC_DATE,' ') HHBB, NVL(SYS_CLASS,' ') STJB, NVL(COL_PASS_FARE, 0) THYK, \
NVL(CAR_KND,' ') CHJO, NVL(AXLE_CODE,' ') CSCD, NVL(SPEC_DATA,' ') MSDT FROM TCSR_SPECIAL"

/***************************************************************************
   TORG15T : ¬ß  -@@
***************************************************************************/
#define S_TORG15T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, NVL(CRNO, 0) CRNO, \
NVL(CHJO,' ') CHJO, NVL(YSBH,' ') YSBH, NVL(OBBH,' ') OBBH, NVL(CDBH,' ') CDBH, NVL(WVCD,' ') WVCD FROM TORG15T"

/***************************************************************************
   TORG16T :   -@@
***************************************************************************/
#define S_TORG16T    "SELECT NVL(PLID,' ') PLID, NVL(PMDT,' ') PMDT, NVL(GCGJ,' ') GCGJ, NVL(KJBH,' ') KJBH, \
NVL(SBSR, 0) SBSR, NVL(BIGO,' ') BIGO, NVL(KMDT,' ') KMDT, NVL(JBGB,' ') JBGB, NVL(KMBH,' ') KMBH, NVL(KRBH,' ') KRBH, \
NVL(PMJS,' ') PMJS, NVL(SIBH,' ') SIBH, NVL(SYBH,' ') SYBH, NVL(SBKM, 0) SBKM FROM TORG16T"

/***************************************************************************
   TORG17T :    -@@
***************************************************************************/
#define S_TORG17T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, NVL(KJBH,' ') KJBH, \
NVL(CRBH, 0) CRBH, NVL(BSTI,' ') BSTI, NVL(STJB,' ') STJB, NVL(CHJO,' ') CHJO, NVL(CSCD,' ') CSCD, NVL(JCDM, 0) JCDM, \
NVL(WCBH,' ') WCBH, NVL(JCDB,' ') JCDB FROM TORG17T"

/***************************************************************************
   TORG18T :   -@@
***************************************************************************/
#define S_TORG18T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, NVL(KJBH,' ') KJBH, \
NVL(STTI,' ') STTI, NVL(EDTI,' ') EDTI, NVL(BSCD,' ') BSCD FROM TORG18T"

/***************************************************************************
   TCSR_WORKENDMINAP : (¥é ) -ok
***************************************************************************/
#define S_TCSR_WORKENDMINAP    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(CSH_CNT, 0) HKDS, \
NVL(CSH_MNY, 0) HKKM, NVL(DUMMY_CNT, 0) GCDS, NVL(DUMMY_MNY, 0) GCKM, NVL(ECRD_CNT, 0) SCDS, NVL(ECRD_MNY, 0) SCKM, NVL(LPAY_TCRD_CNT, 0) HGDS, NVL(LPAY_TCRD_MNY, 0) HGKM FROM TCSR_WORKENDMINAP"

/***************************************************************************
   TCSR_WORKEND : () -ok
***************************************************************************/
#define S_TCSR_WORKEND    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRKR_NO,' ') KJBH, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, \
NVL(LANE_DIV,' ') CRGB, NVL(WRK_STRT_TM,' ') STTI, NVL(WRK_END_TM,' ') EDTI, NVL(CAR_HND_CNT, 0) CRDS, NVL(ADV_CNT, 0) JJDS, NVL(REV_CNT, 0) HJDS, \
NVL(REV_AXLE, 0) HJCS, NVL(EXMT_CRD_CNT, 0) MCGS, NVL(OFC_HND_CNT, 0) SCGS, NVL(DUMMY_CNT, 0) GCJS, NVL(GUN_ERR_CNT, 0) GISS, NVL(FORC_END_YN,' ') GJJR, \
NVL(WRK_STOP, 0) KMJD, NVL(CV_OP, 0) CVOP, NVL(CAR_HND_TOT_ETC, 0) CCDS, NVL(HND_TOC_CNT, 0) TCSD, NVL(LSAM_CHRG_MNY, 0) LSLM, NVL(ECRD_LANE_CHRG_MNY, 0) SCLM, \
NVL(LSAM_BALC, 0) LSJM, NVL(END_STAT,' ') EDGB FROM TCSR_WORKEND"

/***************************************************************************
   TCSR_WORKENDTOT : (¢®) -ok
***************************************************************************/
#define S_TCSR_WORKENDTOT    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(COL_DIV,' ') JSGB, \
NVL(FARE_DIV,' ') YKGB, NVL(RCT_DIV,' ') SNGB, NVL(DC_DIV,' ') HIGB, NVL(CNT_CAR1, 0) DS1J, NVL(CNT_CAR2, 0) DS2J, NVL(CNT_CAR3, 0) DS3J, \
NVL(CNT_CAR4, 0) DS4J, NVL(CNT_CAR5, 0) DS5J, NVL(CNT_CAR6, 0) DS6J, NVL(CNT_CAR7, 0) DS7J, NVL(CNT_CAR8, 0) DS8J, NVL(PAY_CAR1, 0) TY1M, \
NVL(PAY_CAR2, 0) TY2M, NVL(PAY_CAR3, 0) TY3M, NVL(PAY_CAR4, 0) TY4M, NVL(PAY_CAR5, 0) TY5M, NVL(PAY_CAR6, 0) TY6M, NVL(PAY_CAR7, 0) TY7M, \
NVL(PAY_CAR8, 0) TY8M FROM TCSR_WORKENDTOT"

/***************************************************************************
   TORG20T :   -@@
***************************************************************************/
#define S_TORG20T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(PMDT,' ') PMDT, NVL(CDBH,' ') CDBH, \
NVL(GCGJ,' ') GCGJ, NVL(KJBH,' ') KJBH, NVL(HBKM, 0) HBKM, NVL(CDKM, 0) CDKM, NVL(BNYH,' ') BNYH, NVL(BIGO,' ') BIGO, NVL(CJKM, 0) CJKM FROM TORG20T"

/***************************************************************************
   TCSR_WORKENDSENS : (/) -ok
***************************************************************************/
#define S_TCSR_WORKENDSENS    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRKR_NO,' ') KJBH, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, \
NVL(AXLE_DIV,' ') GBCD, NVL(CAR_KND,' ') CHJO, NVL(C2S, 0) C2S, NVL(C2D, 0) C2D, NVL(C2DW, 0) C2DW, NVL(C3, 0) C3, NVL(C4, 0) C4, \
NVL(C2_GCAR, 0) C2M, NVL(C5_OVR, 0) C5, NVL(ETC, 0) DT1, NVL(NO_SENS_DATA, 0) DT2 FROM TCSR_WORKENDSENS"

/***************************************************************************
   TORG21T :  ¬ß -@@
***************************************************************************/
#define S_TORG21T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(PMDT,' ') PMDT, NVL(KMBH,' ') KMBH, \
NVL(GCGJ,' ') GCGJ, NVL(KJBH,' ') KJBH, NVL(SBSR, 0) SBSR, NVL(BIGO,' ') BIGO, NVL(KRBH,' ') KRBH, NVL(BSYH,' ') BSYH FROM TORG21T"

/***************************************************************************
   TCSR_WORKENDETC : () -ok
***************************************************************************/
#define S_TCSR_WORKENDETC    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRKR_NO,' ') KJBH, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, \
NVL(HND_DIV,' ') CRGB, NVL(CAR1, 0) JON1, NVL(CAR2, 0) JON2, NVL(CAR3, 0) JON3, NVL(CAR4, 0) JON4, NVL(CAR5, 0) JON5, \
NVL(CAR6, 0) JON6, NVL(CAR7, 0) JON7, NVL(CAR8, 0) JON8, NVL(NO_DATA, 0) DATN FROM TCSR_WORKENDETC"

/***************************************************************************
   TCSR_WORKENDSPE : (/) -ok
***************************************************************************/
#define S_TCSR_WORKENDSPE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(ECRD_KND,' ') CDTY, \
NVL(CAR_HND_CNT, 0) CRDS, NVL(SPCL_HND_CODE,' ') TBCD FROM TCSR_WORKENDSPE"

/***************************************************************************
   TCSR_WORKENDSALE : (¢®) -ok
***************************************************************************/
#define S_TCSR_WORKENDSALE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, \
NVL(CRD_KND,' ') CDGB, NVL(RCT_DIV,' ') SNGB, NVL(CNT_CAR1, 0) DS1J, NVL(CNT_CAR2, 0) DS2J, NVL(CNT_CAR3, 0) DS3J, NVL(CNT_CAR4, 0) DS4J, \
NVL(CNT_CAR5, 0) DS5J, NVL(CNT_CAR6, 0) DS6J, NVL(CNT_CAR7, 0) DS7J, NVL(CNT_CAR8, 0) DS8J, NVL(MNY_CAR1, 0) TY1M, NVL(MNY_CAR2, 0) TY2M, \
NVL(MNY_CAR3, 0) TY3M, NVL(MNY_CAR4, 0) TY4M, NVL(MNY_CAR5, 0) TY5M, NVL(MNY_CAR6, 0) TY6M, NVL(MNY_CAR7, 0) TY7M, NVL(MNY_CAR8, 0) TY8M, \
NVL(VAT_CAR1, 0) BG1M, NVL(VAT_CAR2, 0) BG2M, NVL(VAT_CAR3, 0) BG3M, NVL(VAT_CAR4, 0) BG4M, NVL(VAT_CAR5, 0) BG5M, NVL(VAT_CAR6, 0) BG6M, \
NVL(VAT_CAR7, 0) BG7M, NVL(VAT_CAR8, 0) BG8M FROM TCSR_WORKENDSALE"

/***************************************************************************
   ETCR_WORKENDTOT : ETC(¢®) -ok
***************************************************************************/
#define S_ETCR_WORKENDTOT    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(PAY_DIV,' ') JBGB, \
NVL(DC,' ') HIGB, NVL(CNT_CAR1 0) DS1J, NVL(CNT_CAR2, 0) DS2J, NVL(CNT_CAR3, 0) DS3J, NVL(CNT_CAR4, 0) DS4J, NVL(CNT_CAR5, 0) DS5J, \
NVL(CNT_CAR6, 0) DS6J, NVL(CNT_CAR7, 0) DS7J, NVL(CNT_CAR8, 0) DS8J, NVL(PASS_FARE_CAR1, 0) TY1M, NVL(PASS_FARE_CAR2, 0) TY2M, NVL(PASS_FARE_CAR3, 0) TY3M, \
NVL(PASS_FARE_CAR4, 0) TY4M, NVL(PASS_FARE_CAR5, 0) TY5M, NVL(PASS_FARE_CAR6, 0) TY6M, NVL(PASS_FARE_CAR7, 0) TY7M, NVL(PASS_FARE_CAR8, 0) TY8M, NVL(ORG_PASS_FARE_CAR1, 0) WTY1M, \
NVL(ORG_PASS_FARE_CAR2, 0) WTY2M, NVL(ORG_PASS_FARE_CAR3, 0) WTY3M, NVL(ORG_PASS_FARE_CAR4, 0) WTY4M, NVL(ORG_PASS_FARE_CAR5, 0) WTY5M, NVL(ORG_PASS_FARE_CAR6, 0) WTY6M, NVL(ORG_PASS_FARE_CAR7, 0) WTY7M, \
NVL(ORG_PASS_FARE_CAR8, 0) WTY8M FROM ETCR_WORKENDTOT"

/***************************************************************************
   ETCR_WORKENDETC : ETC() -ok
***************************************************************************/
#define S_ETCR_WORKENDETC    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(HND_DIV,' ') CRGB, \
NVL(CNT_CAR1, 0) DS1J, NVL(CNT_CAR2, 0) DS2J, NVL(CNT_CAR3, 0) DS3J, NVL(CNT_CAR4, 0) DS4J, NVL(CNT_CAR5, 0) DS5J, NVL(CNT_CAR6, 0) DS6J, \
NVL(CNT_CAR7, 0) DS7J, NVL(CNT_CAR8, 0) DS8J, NVL(NO_DATA, 0) DATN FROM ETCR_WORKENDETC"

/***************************************************************************
   ETCR_WORKENDVIO1 : ETC() -ok 
***************************************************************************/
#define S_ETCR_WORKENDVIO1    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(VIO_DIV,' ') YBGB, \
NVL(CNT_CAR1, 0) DS1J, NVL(CNT_CAR2, 0) DS2J, NVL(CNT_CAR3, 0) DS3J, NVL(CNT_CAR4, 0) DS4J, NVL(CNT_CAR5, 0) DS5J, NVL(CNT_CAR6, 0) DS6J, \
NVL(CNT_CAR7, 0) DS7J, NVL(CNT_CAR8, 0) DS8J, NVL(MNY_CAR1, 0) TY1M, NVL(MNY_CAR2, 0) TY2M, NVL(MNY_CAR3, 0) TY3M, NVL(MNY_CAR4, 0) TY4M, \
NVL(MNY_CAR5, 0) TY5M, NVL(MNY_CAR6, 0) TY6M, NVL(MNY_CAR7, 0) TY7M, NVL(MNY_CAR8, 0) TY8M FROM ETCR_WORKENDVIO1"

/***************************************************************************
   ETCR_WORKENDSALE : ETC() -ok
***************************************************************************/
#define S_ETCR_WORKENDSALE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(DC_DIV,' ') HIGB, \
NVL(CNT_CAR1, 0) DS1J, NVL(CNT_CAR2, 0) DS2J, NVL(CNT_CAR3, 0) DS3J, NVL(CNT_CAR4, 0) DS4J, NVL(CNT_CAR5, 0) DS5J, NVL(CNT_CAR6, 0) DS6J, \
NVL(CNT_CAR7, 0) DS7J, NVL(CNT_CAR8, 0) DS8J, NVL(MNY_CAR1, 0) TY1M, NVL(MNY_CAR2, 0) TY2M, NVL(MNY_CAR3, 0) TY3M, NVL(MNY_CAR4, 0) TY4M, \
NVL(MNY_CAR5, 0) TY5M, NVL(MNY_CAR6, 0) TY6M, NVL(MNY_CAR7, 0) TY7M, NVL(MNY_CAR8, 0) TY8M, NVL(ORG_PASS_FARE_CAR1, 0) WTY1M, NVL(ORG_PASS_FARE_CAR2, 0) WTY2M, \
NVL(ORG_PASS_FARE_CAR3, 0) WTY3M, NVL(ORG_PASS_FARE_CAR4, 0) WTY4M, NVL(ORG_PASS_FARE_CAR5, 0) WTY5M, NVL(ORG_PASS_FARE_CAR6, 0) WTY6M, NVL(ORG_PASS_FARE_CAR7, 0) WTY7M, NVL(ORG_PASS_FARE_CAR8, 0) WTY8M FROM ETCR_WORKENDSALE"

/***************************************************************************
   ETCR_WORKENDCAR : ETC(4¬Ù¢®) -ok
***************************************************************************/
#define S_ETCR_WORKENDCAR    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(PAY_DIV,' ') JBGB, \
NVL(DC,' ') HIGB, NVL(CNT_CAR1, 0) DS1J, NVL(CNT_CAR2, 0) DS2J, NVL(CNT_CAR3, 0) DS3J, NVL(CNT_CAR4, 0) DS4J, NVL(CNT_CAR5, 0) DS5J, \
NVL(CNT_CAR6, 0) DS6J, NVL(CNT_CAR7, 0) DS7J, NVL(CNT_CAR8, 0) DS8J, NVL(PASS_FARE_CAR1, 0) TY1M, NVL(PASS_FARE_CAR2, 0) TY2M, NVL(PASS_FARE_CAR3, 0) TY3M, \
NVL(PASS_FARE_CAR4, 0) TY4M, NVL(PASS_FARE_CAR5, 0) TY5M, NVL(PASS_FARE_CAR6, 0) TY6M, NVL(PASS_FARE_CAR7, 0) TY7M, NVL(PASS_FARE_CAR8, 0) TY8M, NVL(VAT_CAR1, 0) BG1M, \
NVL(VAT_CAR2, 0) BG2M, NVL(VAT_CAR3, 0) BG3M, NVL(VAT_CAR4, 0) BG4M, NVL(VAT_CAR5, 0) BG5M, NVL(VAT_CAR6, 0) BG6M, NVL(VAT_CAR7, 0) BG7M, \
NVL(VAT_CAR8, 0) BG8M FROM ETCR_WORKENDCAR"

/***************************************************************************
   ETCR_WORKEND : ETC() -ok
***************************************************************************/
#define S_ETCR_WORKEND    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(IO_WRK_DIV,' ') KMGB, \
NVL(WRK_STRT_TM,' ') STTI, NVL(WRK_END_TM,' ') EDTI, NVL(HND_CNT, 0) CRDS, NVL(ADV_CNT, 0) JJDS, NVL(REV_CNT, 0) HJDS, NVL(END_STAT,' ') EDGB, NVL(SND_NO, 0) JYBH FROM ETCR_WORKEND"

/***************************************************************************
   ETCR_WORKENDVIO2 : ETC() -ok
***************************************************************************/
#define S_ETCR_WORKENDVIO2    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(VIO_CODE,' ') TBCD, NVL(HND_CNT, 0) CRDS FROM ETCR_WORKENDVIO2"

/***************************************************************************
   TCSR_CARCONFIRM : TCS () -ok
***************************************************************************/
#define S_TCSR_CARCONFIRM    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(WRKR_NO,' ') KJBH, \
NVL(HND_SNO, 0) CRNO, NVL(CAR_KND,' ') CHJO, NVL(HND_TM,' ') HHBB, NVL(SENS_SNO, 0) GJBH, NVL(ORG_PASS_FARE, 0) THYK, NVL(COL_PASS_FARE, 0) JSKM, \
NVL(RCT_CSH, 0) SSKM, NVL(AXLE_CODE,' ') CSCD, NVL(IMP_DIV,' ') SIGB, NVL(DC_CRD_NO,' ') HCBH, NVL(CRD_NO,' ') CDBH, NVL(DUMMY1, 0) GCKM, \
NVL(DUMMY2,' ') GCYN, NVL(DUMMY3, 0) GC1KM, NVL(DUMMY4,' ') GC1NO, NVL(NW_OD_FARE_HND_DIV,' ') NOGB, NVL(RCT_DIV,' ') SNGB, NVL(LNK_EXMT_DIV,' ') YMGB FROM TCSR_CARCONFIRM"

/***************************************************************************
   ETCR_VIOLATION : ¬ß  -ok
***************************************************************************/
#define S_ETCR_VIOLATION    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(HND_SNO, 0) CRNO, \
NVL(ORG_PASS_FARE, 0) THYK, NVL(COL_PASS_FARE, 0) JSKM, NVL(RCT_PASS_FARE, 0) SNKM, NVL(RCT_CRD_BALC, 0) SNJM, NVL(ECRD_KND,' ') SCTY, NVL(VIO_CODE,' ') ERCD, \
NVL(IMG_NO, 0) YSBH, NVL(CAR_KND,' ') CHJO, NVL(HND_TM,' ') CRTI, NVL(CRD_NO,' ') CDBH, NVL(WRK_DIV,' ') KMGB, NVL(OBU_STAT,' ') OBST, \
NVL(ECRD_STAT,' ') CDST, NVL(RCT_DIV,' ') SNGB, NVL(SEND_CAR_KND,' ') GJCJ, NVL(OBU_CAR_KND,' ') OBCJ, NVL(ACRDT_STAT,' ') IJST, NVL(OBU_NO,' ') OBBH, \
NVL(OBU_TYP,' ') OBTY, NVL(BE_PLZ_ID' ') BE_PLID, NVL(BE_HND_TM,' ') BE_CRTI, NVL(BE_WRK_NO,' ') BE_KMBH, NVL(BE_HND_NO, 0) BE_CRNO, \
NVL(BE_HND_TYP,' ') BE_CRTY, NVL(BE_CAR_KND,' ') BE_CHJO, NVL(HND_DIV,' ') CRGB FROM ETCR_VIOLATION"

/***************************************************************************
   PUBM_AUTHORITY :  -ok
***************************************************************************/
#define S_PUBM_AUTHORITY    "SELECT NVL(KJBH,' ') KJBH, NVL(PLID,' ') PLID, NVL(SCBY, 0) SCBY, NVL(SCSY, 0) SCSY, \
NVL(SCJY, 0) SCJY, NVL(PSWD,' ') PSWD, NVL(ACDG, 0) ACDG FROM PUBM_AUTHORITY"

/***************************************************************************
   PUBL_PROGRAM : ¥á  -ok
***************************************************************************/
#define S_PUBL_PROGRAM    "SELECT NVL(PG_ID,' ') PGID, NVL(TOP_PG_ID,' ') PPID, NVL(WDGB, 0) WDGB, NVL(INPUT_DIV, 0) INGB, \
NVL(UPGB, 0) UPGB, NVL(DLGB, 0) DLGB, NVL(SCGB, 0) SCGB, NVL(PRGB, 0) PRGB, NVL(PGDK, 0) PGDK, NVL(WMNM,' ') WMNM, \
NVL(WMSM,' ') WMSM, NVL(PG_NM,' ') PGNM, NVL(PG_DESC,' ') PGSM, NVL(EXYN,' ') EXYN, NVL(PVYN,' ') PVYN, NVL(LVBH, 0) LVBH, NVL(ORDR, 0) SEQ FROM PUBL_PROGRAM"

/***************************************************************************
   PUBL_REPORT :   -ok
***************************************************************************/
#define S_PUBL_REPORT    "SELECT NVL(RPT_ID,' ') RPID, NVL(RPT_NM,' ') RPNM, NVL(RPT_TYP, 0) RPTY, NVL(RPT_CY, 0) RPJG, \
NVL(PAYM_SP, 0) SIGN, NVL(RPT_RT, 0) RPDG, NVL(PRE_VIEW_YN,' ') MBYU FROM PUBL_REPORT"

/***************************************************************************
   TPRG04M :   -@@
***************************************************************************/
#define S_TPRG04M    "SELECT NVL(BSID, 0) BSID, NVL(PGID,' ') PGID, NVL(UCGB,' ') UCGB, NVL(SUCD,' ') SUCD, \
NVL(SKID,' ') SKID, NVL(BKID,' ') BKID, NVL(HHBB,' ') HHBB, NVL(SSYB,' ') SSYB, NVL(GGDG,' ') GGDG, NVL(DBCD,' ') DBCD, \
NVL(SBCD,' ') SBCD, NVL(ARG1,' ') ARG1, NVL(ARG2,' ') ARG2, NVL(ARG3,' ') ARG3, NVL(ARG4,' ') ARG4 FROM TPRG04M"

/***************************************************************************
   PUBM_REPORTIMAGE :   -ok IMGPATH
***************************************************************************/
#define S_PUBM_REPORTIMAGE    "SELECT NVL(RPT_PAYM_SP_ID, 0) RPID, NVL(INST_DATE,' ') REGDATE, NVL(IMG_DATA,' ') IMGDATA, NVL(IMG_PATH,' ') IMGPATH FROM PUBM_REPORTIMAGE"

/***************************************************************************
   TPRG06M : _¥ì -@@
***************************************************************************/
#define S_TPRG06M    "SELECT NVL(KJBH,' ') KJBH, NVL(CRGB,' ') CRGB, NVL(KKJR,' ') KKJR, NVL(ISCD,' ') ISCD, NVL(CRDT,' ') CRDT FROM TPRG06M"

/***************************************************************************
   ETCM_ENVMONITOR : ¬ß  -@@
***************************************************************************/
#define S_ETCM_ENVMONITOR    "SELECT NVL(SCCY, 0) SCCY, NVL(THCY, 0) THCY, NVL(CRDT,' ') CRDT FROM ETCM_ENVMONITOR"

/***************************************************************************
   ETCM_INFOMONITOR : ¬ß -@@
***************************************************************************/
#define S_ETCM_INFOMONITOR    "SELECT NVL(CRGB,' ') CRGB, NVL(KKJR,' ') KKJR, NVL(ISCD,' ') ISCD, NVL(CRDT,' ') CRDT, NVL(ALYN,' ') ALYN FROM ETCM_INFOMONITOR"

/***************************************************************************
   REVM_DATE :  -ok
***************************************************************************/
#define S_REVM_DATE    "SELECT NVL(YMD,' ') YMD, NVL(WRK_DATE_DIV, 0) DTGB, NVL(LUNA_DATE,' ') MNDT, NVL(NOTE,' ') COMM, NVL(CMUT_DIV,' ') CTGB FROM REVM_DATE"

/***************************************************************************
   REVL_BASICINFO :   -ok
***************************************************************************/
#define S_REVL_BASICINFO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(RVS_NO, 0) SEQS, NVL(MODF_TM,' ') IRDT, NVL(PLZ_NM,' ') PLNM, \
NVL(PLZ_PHONE_NO,' ') PLTE, NVL(DAY_CHG_TM,' ') BKSG, NVL(DAY_FSH_TM,' ') MKSG, NVL(UP_LANE_CNT, 0) SHCR, NVL(DWN_LANE_CNT, 0) HHCR, NVL(VRAB_LANE_CNT, 0) GBCR, \
NVL(TCS_HOL_DT,' ') HGDT, NVL(GCAR_DC_DT,' ') KCDT, NVL(GCAR_DC_CRD_DIV,' ') KHGB, NVL(DC_EXTR_DT,' ') HHDT, NVL(CMUT_DC_TM,' ') CTDT, NVL(SIG_ROT_TM,' ') CYHJ, \
NVL(ECAR_APL_DT,' ') BCDT, NVL(ECAR_NW_APL_UP,' ') BCNS, NVL(ECAR_OD_APL_UP,' ') BCDS, NVL(ECAR_NW_APL_DWN,' ') BCNH, NVL(ECAR_OD_APL_DWN,' ') BCDH, NVL(ADMIN_NO,' ') ADBH, \
NVL(LNK_FARE_DATE,' ') YYDT FROM REVL_BASICINFO"

/***************************************************************************
   REVM_BASICINFO :  -ok
***************************************************************************/
#define S_REVM_BASICINFO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(PLZ_NM,' ') PLNM, NVL(PLZ_PHONE_NO,' ') PLTE, NVL(DAY_CHG_TM,' ') BKSG, \
NVL(DAY_FSH_TM,' ') MKSG, NVL(UP_LANE_CNT, 0) SHCR, NVL(DWN_LANE_CNT, 0) HHCR, NVL(VRAB_KABE_CNT, 0) GBCR, NVL(TCS_HOL_DT,' ') HGDT, NVL(GCAR_DC_DT,' ') KCDT, \
NVL(GCAR_DC_CRD_DIV,' ') KHGB, NVL(DC_EXTR_DT,' ') HHDT, NVL(HR_DC_APL_DATE,' ') CTDT, NVL(LNK_FARE_APL_DATE,' ') YYDT, NVL(SIG_ROT_TM,' ') CYHJ, NVL(ECAR_APL_DT,' ') BCDT, \
NVL(ECAR_NW_APL_UP,' ') BCNS, NVL(ECAR_OD_APL_UP,' ') BCDS, NVL(ECAR_NW_APL_DWN,' ') BCNH, NVL(ECAR_OD_APL_DWN,' ') BCDH, NVL(MODF_TM,' ') IRDT FROM REVM_BASICINFO"

/***************************************************************************
   REVM_LANEINFO :  -ok
***************************************************************************/
#define S_REVM_LANEINFO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(PHGC_LANE,' ') CRBH, NVL(LOGC_LANE,' ') NRBH, NVL(LANE_TYP, 0) CRHT, \
NVL(UP_DWN_DIV, 0) IOGB, NVL(ENT_WOUT_NO,' ') IOBH, NVL(LANE_DIV,' ') CRGB, NVL(CAR_SRCH_DT1,' ') CPT1, NVL(CAR_SRCH_DT2,' ') CPT2, NVL(LANE_NM,' ') CRNM, \
NVL(COUN_LANE,' ') SDCR, NVL(IP_ADDR,' ') IPAD, NVL(PORT,' ') PTNO, NVL(TEL_KND,' ') TSGB, NVL(NOTE,' ') CRSM, NVL(PSAM_ID,' ') PMID, \
NVL(LSAM_NO,' ') LMID FROM REVM_LANEINFO"

/***************************************************************************
   REVL_FAREINFO : ( ) -ok
***************************************************************************/
#define S_REVL_FAREINFO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(SEQES, 0) SEQS, NVL(MODF_TM,' ') IRDT, NVL(ADMIN_NO,' ') ADBH, \
NVL(FARE_DIV,' ') YKGB, NVL(USE_YN,' ') SYYN, NVL(NW_ST_HR_MIN,' ') NSHB, NVL(NW_END_HR_MIN,' ') NEHB, NVL(OD_ST_HR_MIN,' ') OSHB, NVL(OD_END_HR_MIN,' ') OEHB,  \
NVL(CAR1_NW_FARE, 0) SYG1, NVL(CAR1_NW_FARE_VAT, 0) SYB1, NVL(CAR1_NW_FTOT, 0) SYC1, NVL(CAR1_OD_FARE, 0) GYG1, NVL(CAR1_OD_FARE_VAT, 0) GYB1, NVL(CAR1_OD_FTOT, 0) GYC1, \
NVL(CAR2_NW_FARE, 0) SYG2, NVL(CAR2_NW_FARE_VAT, 0) SYB2, NVL(CAR2_NW_FTOT, 0) SYC2, NVL(CAR2_OD_FARE, 0) GYG2, NVL(CAR2_OD_FARE_VAT, 0) GYB2, NVL(CAR2_OD_FTOT, 0) GYC2, \
NVL(CAR3_NW_FARE, 0) SYG3, NVL(CAR3_NW_FARE_VAT, 0) SYB3, NVL(CAR3_NW_FTOT, 0) SYC3, NVL(CAR3_OD_FARE, 0) GYG3, NVL(CAR3_OD_FARE_VAT, 0) GYB3, NVL(CAR3_OD_FTOT, 0) GYC3, \
NVL(CAR4_NW_FARE, 0) SYG4, NVL(CAR4_NW_FARE_VAT, 0) SYB4, NVL(CAR4_NW_FTOT, 0) SYC4, NVL(CAR4_OD_FARE, 0) GYG4, NVL(CAR4_OD_FARE_VAT, 0) GYB4, NVL(CAR4_OD_FTOT, 0) GYC4, \
NVL(CAR5_NW_FARE, 0) SYG5, NVL(CAR5_NW_FARE_VAT, 0) SYB5, NVL(CAR5_NW_FTOT, 0) SYC5, NVL(CAR5_OD_FARE, 0) GYG5, NVL(CAR5_OD_FARE_VAT, 0) GYB5, NVL(CAR5_OD_FTOT, 0) GYC5, \
NVL(CAR6_NW_FARE, 0) SYG6, NVL(CAR6_NW_FARE_VAT, 0) SYB6, NVL(CAR6_NW_FTOT, 0) SYC6, NVL(CAR6_OD_FARE, 0) GYG6, NVL(CAR6_OD_FARE_VAT, 0) GYB6, NVL(CAR6_OD_FTOT, 0) GYC6, \
NVL(CAR7_NW_FARE, 0) SYG7, NVL(CAR7_NW_FARE_VAT, 0) SYB7, NVL(CAR7_NW_FTOT, 0) SYC7, NVL(CAR7_OD_FARE, 0) GYG7, NVL(CAR7_OD_FARE_VAT, 0) GYB7, NVL(CAR7_OD_FTOT, 0) GYC7, \
NVL(CAR8_NW_FARE, 0) SYG8, NVL(CAR8_NW_FARE_VAT, 0) SYB8, NVL(CAR8_NW_FTOT, 0) SYC8, NVL(CAR8_OD_FARE, 0) GYG8, NVL(CAR8_OD_FARE_VAT, 0) GYB8, NVL(CAR8_OD_FTOT, 0) GYC8 FROM REVL_FAREINFO"

/***************************************************************************
   REVM_FAREINFO : ( ) -ok
***************************************************************************/
#define S_REVM_FAREINFO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(FARE_DIV,' ') YKGB, NVL(USE_YN,' ') SYYN, NVL(NW_ST_HR_MIN,' ') NSHB, \
NVL(NW_END_HR_MIN,' ') NEHB, NVL(OD_ST_HR_MIN,' ') OSHB, NVL(OD_END_HR_MIN,' ') OEHB, NVL(CAR1_NW_FARE, 0) SYG1, NVL(CAR1_NW_FARE_VAT, 0) SYB1, NVL(CAR1_NW_FTOT, 0) SYC1, \
NVL(CAR1_OD_FARE, 0) GYG1, NVL(CAR1_OD_FARE_VAT, 0) GYB1, NVL(CAR1_OD_FTOT, 0) GYC1, NVL(CAR2_NW_FARE, 0) SYG2, NVL(CAR2_NW_FARE_VAT, 0) SYB2, NVL(CAR2_NW_FTOT, 0) SYC2, \
NVL(CAR2_OD_FARE, 0) GYG2, NVL(CAR2_OD_FARE_VAT, 0) GYB2, NVL(CAR2_OD_FTOT, 0) GYC2, NVL(CAR3_NW_FARE, 0) SYG3, NVL(CAR3_NW_FARE_VAT, 0) SYB3, NVL(CAR3_NW_FTOT, 0) SYC3, \
NVL(CAR3_OD_FARE, 0) GYG3, NVL(CAR3_OD_FARE_VAT, 0) GYB3, NVL(CAR3_OD_FTOT, 0) GYC3, NVL(CAR4_NW_FARE, 0) SYG4, NVL(CAR4_NW_FARE_VAT, 0) SYB4, NVL(CAR4_NW_FTOT, 0) SYC4, \
NVL(CAR4_OD_FARE, 0) GYG4, NVL(CAR4_OD_FARE_VAT, 0) GYB4, NVL(CAR4_OD_FTOT, 0) GYC4, NVL(CAR5_NW_FARE, 0) SYG5, NVL(CAR5_NW_FARE_VAT, 0) SYB5, NVL(CAR5_NW_FTOT, 0) SYC5, \
NVL(CAR5_OD_FARE, 0) GYG5, NVL(CAR5_OD_FARE_VAT, 0) GYB5, NVL(CAR5_OD_FTOT, 0) GYC5, NVL(CAR6_NW_FARE, 0) SYG6, NVL(CAR6_NW_FARE_VAT, 0) SYB6, NVL(CAR6_NW_FTOT, 0) SYC6, \
NVL(CAR6_OD_FARE, 0) GYG6, NVL(CAR6_OD_FARE_VAT, 0) GYB6, NVL(CAR6_OD_FTOT, 0) GYC6, NVL(CAR7_NW_FARE, 0) SYG7, NVL(CAR7_NW_FARE_VAT, 0) SYB7, NVL(CAR7_NW_FTOT, 0) SYC7, \
NVL(CAR7_OD_FARE, 0) GYG7, NVL(CAR7_OD_FARE_VAT, 0) GYB7, NVL(CAR7_OD_FTOT, 0) GYC7, NVL(CAR8_NW_FARE, 0) SYG8, NVL(CAR8_NW_FARE_VAT, 0) SYB8, NVL(CAR8_NW_FTOT, 0) SYC8, \
NVL(CAR8_OD_FARE, 0) GYG8, NVL(CAR8_OD_FARE_VAT, 0) GYB8, NVL(CAR8_OD_FTOT, 0) GYC8, NVL(MODF_TM,' ') IRDT FROM REVM_FAREINFO"

/***************************************************************************
   REVM_USERINFO :   -ok
***************************************************************************/
#define S_REVM_USERINFO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRKR_NO,' ') KJBH, NVL(WRKR_NM,' ') KJNM, NVL(JOIN_DATE,' ') ISDT, \
NVL(COPR_NO,' ') SOBH, NVL(DOB,' ') SNMT, NVL(PSWD,' ') PSWD, NVL(PHONE_NO,' ') KTEL, NVL(HPHONE_NO,' ') KJHP, NVL(EMP_CRD_NO,' ') JCNO, \
NVL(ADDR,' ') JUSO, NVL(POS,' ') KJJG, NVL(RESIGN,' ') TSYN, NVL(PATH,' ') PATH, NVL(WRK_DIV, 0) ACDG FROM REVM_USERINFO"

/***************************************************************************
   REVL_CARDRATE : /  -ok  ADBH
***************************************************************************/
#define S_REVL_CARDRATE    "SELECT NVL(RVS_NO, 0) REVN, NVL(PLZ_ID,' ') PLID, NVL(CRD_KND,' ') CDTY, NVL(IN_DATE,' ') IRDT, \
NVL(DC_NW_DT,' ') NWDT, NVL(OD_CAR1_DCRTE, 0) ORAT1, NVL(OD_CAR2_DCRTE, 0) ORAT2, NVL(OD_CAR3_DCRTE, 0) ORAT3, NVL(OD_CAR4_DCRTE, 0) ORAT4, \
NVL(OD_CAR5_DCRTE, 0) ORAT5, NVL(OD_CAR6_DCRTE, 0) ORAT6, NVL(OD_CAR7_DCRTE, 0) ORAT7, NVL(OD_CAR8_DCRTE, 0) ORAT8, NVL(NW_CAR1_DCRTE, 0) NRAT1, \
NVL(NW_CAR2_DCRTE, 0) NRAT2, NVL(NW_CAR3_DCRTE, 0) NRAT3, NVL(NW_CAR4_DCRTE, 0) NRAT4, NVL(NW_CAR5_DCRTE, 0) NRAT5, NVL(NW_CAR6_DCRTE, 0) NRAT6, \
NVL(NW_CAR7_DCRTE, 0) NRAT7, NVL(NW_CAR8_DCRTE, 0) NRAT8, NVL(ADMIN_NO, ' ') ADBH FROM REVL_CARDRATE"

/***************************************************************************
   REVM_CARDRATE : / -ok
***************************************************************************/
#define S_REVM_CARDRATE    "SELECT NVL(PLID,' ') PLID, NVL(CDTY,' ') CDTY, NVL(IRDT,' ') IRDT, NVL(NWDT,' ') NWDT, \
NVL(ORAT1, 0) ORAT1, NVL(ORAT2, 0) ORAT2, NVL(ORAT3, 0) ORAT3, NVL(ORAT4, 0) ORAT4, NVL(ORAT5, 0) ORAT5, \
NVL(ORAT6, 0) ORAT6, NVL(ORAT7, 0) ORAT7, NVL(ORAT8, 0) ORAT8, NVL(NRAT1, 0) NRAT1, NVL(NRAT2, 0) NRAT2, \
NVL(NRAT3, 0) NRAT3, NVL(NRAT4, 0) NRAT4, NVL(NRAT5, 0) NRAT5, NVL(NRAT6, 0) NRAT6, NVL(NRAT7, 0) NRAT7, NVL(NRAT8, 0) NRAT8 FROM REVM_CARDRATE"

/***************************************************************************
   TREV07M :   -@@
***************************************************************************/
#define S_TREV07M    "SELECT NVL(PLID,' ') PLID, NVL(GUNJ, 0) GUNJ, NVL(KMAK, 0) KMAK, NVL(HIKM, 0) HIKM FROM TREV07M"

/***************************************************************************
   REVL_TIMERATE : ©£ ¥ç  -ok
***************************************************************************/
#define S_REVL_TIMERATE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(MODF_NO, 0) SEQS, NVL(MODF_TM,' ') IRDT, NVL(DATE_DIV,' ') DTGB, \
NVL(TM_SEQES, 0) TISQ, NVL(ADMIN_NO,' ') ADBH, NVL(ST_HR_MIN_NW,' ') NSTI, NVL(END_HR_MIN_NW,' ') NETI, NVL(ST_HR_MIN_OD,' ') OSTI, NVL(END_HR_MIN_OD,' ') OETI, \
NVL(NW_CAR_KND_DCRTE1,' ') NPE1, NVL(OD_CAR_KND_DCRTE1,' ') OPE1, NVL(NW_CAR_KND_DCRTE2,' ') NPE2, NVL(OD_CAR_KND_DCRTE2,' ') OPE2, NVL(NW_CAR_KND_DCRTE3,' ') NPE3, NVL(OD_CAR_KND_DCRTE3,' ') OPE3, \
NVL(NW_CAR_KND_DCRTE4,' ') NPE4, NVL(OD_CAR_KND_DCRTE4,' ') OPE4, NVL(NW_CAR_KND_DCRTE5,' ') NPE5, NVL(OD_CAR_KND_DCRTE5,' ') OPE5, NVL(NW_CAR_KND_DCRTE6,' ') NPE6, NVL(OD_CAR_KND_DCRTE6,' ') OPE6, \
NVL(NW_CAR_KND_DCRTE7,' ') NPE7, NVL(OD_CAR_KND_DCRTE7,' ') OPE7, NVL(NW_CAR_KND_DCRTE8,' ') NPE8, NVL(OD_CAR_KND_DCRTE8,' ') OPE8 FROM REVL_TIMERATE"

/***************************************************************************
   REVM_TIMERATE : ©£ ¥ç -ok
***************************************************************************/
#define S_REVM_TIMERATE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(DATA_DIV,' ') DTGB, NVL(TM_SEQES, 0) TISQ, NVL(IN_DATE,' ') IRDT, \
NVL(ST_HR_MIN_NW,' ') NSTI, NVL(END_HR_MIN_NW,' ') NETI, NVL(ST_HR_MIN_OD,' ') OSTI, NVL(END_HR_MIN_OD,' ') OETI, \
NVL(NW_CAR_KND_DCRTE1,' ') NPE1, NVL(OD_CAR_KND_DCRTE1,' ') OPE1, NVL(NW_CAR_KND_DCRTE2,' ') NPE2, NVL(OD_CAR_KND_DCRTE2,' ') OPE2, NVL(NW_CAR_KND_DCRTE3,' ') NPE3, \
NVL(OD_CAR_KND_DCRTE3,' ') OPE3, NVL(NW_CAR_KND_DCRTE4,' ') NPE4, NVL(OD_CAR_KND_DCRTE4,' ') OPE4, NVL(NW_CAR_KND_DCRTE5,' ') NPE5, NVL(OD_CAR_KND_DCRTE5,' ') OPE5, \
NVL(NW_CAR_KND_DCRTE6,' ') NPE6, NVL(OD_CAR_KND_DCRTE6,' ') OPE6, NVL(NW_CAR_KND_DCRTE7,' ') NPE7, NVL(OD_CAR_KND_DCRTE7,' ') OPE7, NVL(NW_CAR_KND_DCRTE8,' ') NPE8, NVL(OD_CAR_KND_DCRTE8,' ') OPE8 FROM REVM_TIMERATE"

/***************************************************************************
   PUBLM_SALERATE : / -ok
***************************************************************************/
#define S_PUBLM_SALERATE    "SELECT NVL(PLID,' ') PLID, NVL(SJDT,' ') SJDT, NVL(GJBH, 0) GJBH, NVL(YKTB, 0) YKTB, \
NVL(CDHI, 0) CDHI, NVL(HIHJ, 0) HIHJ FROM PUBLM_SALERATE"

/***************************************************************************
   REVL_TABLENO :   -ok
***************************************************************************/
#define S_REVL_TABLENO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(MODF_NO, 0) SEQS, NVL(RVS_NO_CODE,' ') TBID, NVL(ADMIN_NO,' ') ADBH, \
NVL(MODF_DT,' ') CRDT, NVL(APL_DT,' ') GJDT, NVL(RVS_NO, 0) GJBH FROM REVL_TABLENO"

/***************************************************************************
   REVM_TABLENO :  -ok
***************************************************************************/
#define S_REVM_TABLENO    "SELECT NVL(PLZ_ID,' ') PLID, NVL(BAS_INFO_MODF_DT,' ') GCSJ, NVL(BAS_INFO_APL_DT,' ') GCDT, NVL(BAS_INFO_RVS_NO, 0) GCBH, \
NVL(WRK_INFO_MODF_DT,' ') KCSJ, NVL(WRK_INFO_APL_DT,' ') KCDT, NVL(WRK_INFO_RVS_NO, 0) KCBH, NVL(FARE_MODF_DT,' ') YGSJ, NVL(FARE_APL_DT,' ') YGDT, NVL(FARE_RVS_NO, 0) YGBH, \
NVL(BL_CCRD_MODF_DT,' ') BCSJ, NVL(BL_CCRD_APL_DT,' ') BCDT, NVL(BL_CCRD_RVS_NO, 0) BCBH, NVL(BL_DC_MODF_DT,' ') BMSJ, NVL(BL_DC_APL_DT,' ') BMDT, NVL(BL_DC_RVS_NO, 0) BMBH, \
NVL(DUMMY_MODF_DT,' ') BGSJ, NVL(DUMMY_APL_DT,' ') BGDT, NVL(DUMMY_RVS_NO, 0) BGBH, NVL(HDAY_DATE_MODF_DT,' ') HDSJ, NVL(HDAY_DATE_APL_DT,' ') HDDT, NVL(HDAY_DATE_RVS_NO, 0) HDBH, \
NVL(CMUT_DATE_MODF_DT,' ') CTSJ, NVL(CMUT_DATE_APL_DT,' ') CTDT, NVL(CMUT_DATE_RVS_NO, 0) CTBH, NVL(BL_ECRD_MODF_DT,' ') BSSJ, NVL(BL_ECRD_APL_DT,' ') BSDT, NVL(BL_ECRD_RVS_NO, 0) BSBH, \
NVL(LNK_FARE_MODF_DT,' ') YYSJ, NVL(LNK_FARE_APL_DT,' ') YYDT, NVL(LNK_FARE_RVS_NO, 0) YYBH, NVL(TCRD_BIN_MODF_DT,' ') BBSJ, NVL(TCRD_BIN_APL_DT,' ') BBDT, NVL(BL_TCRD_RVS_NO, 0) BBBH, \
NVL(BL_TCRD_MODF_DT,' ') GBSJ, NVL(BL_TCRD_APL_DT,' ') GBDT, NVL(BL_TCRD_RVS_NO, 0) GBBH, NVL(HR_DC_TBL_MODF_DT,' ') SGSJ, NVL(HR_DC_TBL_APL_DT,' ') SGDT, NVL(HR_DC_TBL_RVS_NO, 0) SGBH, \
NVL(BL_OBU_MODF_DT,' ') BOSJ, NVL(BL_OBU_APL_DT,' ') BODT, NVL(BL_OBU_RVS_NO, 0) BOBH FROM REVM_TABLENO"

/***************************************************************************
   PUBM_MEDIAFEE :  -ok
***************************************************************************/
#define S_PUBM_MEDIAFEE    "SELECT NVL(APL_STDD_DATE,' ') GJDT, NVL(LPAY_CRD_CALC_FEE, 0) HBCD, NVL(EPS_CALC_FEE, 0) DEPS, NVL(HIPASS_CALC_FEE, 0) DHPS, \
NVL(MODF_DT,' ') CRDT, NVL(WRKR_NO,' ') KJBH FROM PUBM_MEDIAFEE"

/***************************************************************************
   REVL_SCRATECAR :  ¥ç  -ok  ADBH
***************************************************************************/
#define S_REVL_SCRATECAR    "SELECT NVL(RVS_NO, 0) REVN, NVL(PLZ_ID,' ') PLID, NVL(IN_DATE,' ') IRDT, NVL(DCRTE_NW_DT,' ') NWDT, \
NVL(OD_CAR_KND_DCRTE1, 0) ORAT1, NVL(OD_CAR_KND_DCRTE2, 0) ORAT2, NVL(OD_CAR_KND_DCRTE3, 0) ORAT3, NVL(OD_CAR_KND_DCRTE4, 0) ORAT4, NVL(OD_CAR_KND_DCRTE5, 0) ORAT5, \
NVL(OD_CAR_KND_DCRTE6, 0) ORAT6, NVL(OD_CAR_KND_DCRTE7, 0) ORAT7, NVL(OD_CAR_KND_DCRTE8, 0) ORAT8, NVL(NW_CAR_KND_DCRTE1, 0) NRAT1, NVL(NW_CAR_KND_DCRTE2, 0) NRAT2, \
NVL(NW_CAR_KND_DCRTE3, 0) NRAT3, NVL(NW_CAR_KND_DCRTE4, 0) NRAT4, NVL(NW_CAR_KND_DCRTE5, 0) NRAT5, NVL(NW_CAR_KND_DCRTE6, 0) NRAT6, NVL(NW_CAR_KND_DCRTE7, 0) NRAT7, \
NVL(NW_CAR_KND_DCRTE8, 0) NRAT8, NVL(ADMIN_NO,' ') ADBH FROM REVL_SCRATECAR"

/***************************************************************************
   REVM_SCRATECAR :  ¥ç -ok
***************************************************************************/
#define S_REVM_SCRATECAR    "SELECT NVL(PLZ_ID,' ') PLID, NVL(IN_DATE,' ') IRDT, NVL(DC_NW_DT,' ') NWDT, NVL(OD_CAR_KND_DCRTE1, 0) ORAT1, \
NVL(OD_CAR_KND_DCRTE2, 0) ORAT2, NVL(OD_CAR_KND_DCRTE3, 0) ORAT3, NVL(OD_CAR_KND_DCRTE4, 0) ORAT4, NVL(OD_CAR_KND_DCRTE5, 0) ORAT5, NVL(OD_CAR_KND_DCRTE6, 0) ORAT6, \
NVL(OD_CAR_KND_DCRTE7, 0) ORAT7, NVL(OD_CAR_KND_DCRTE8, 0) ORAT8, NVL(NW_CAR_KND_DCRTE1, 0) NRAT1, NVL(NW_CAR_KND_DCRTE2, 0) NRAT2, NVL(NW_CAR_KND_DCRTE3, 0) NRAT3, \
NVL(NW_CAR_KND_DCRTE4, 0) NRAT4, NVL(NW_CAR_KND_DCRTE5, 0) NRAT5, NVL(NW_CAR_KND_DCRTE6, 0) NRAT6, NVL(NW_CAR_KND_DCRTE7, 0) NRAT7, NVL(NW_CAR_KND_DCRTE8, 0) NRAT8 FROM REVM_SCRATECAR"

/***************************************************************************
   TREV14M : ¥ï -@@
***************************************************************************/
#define S_TREV14M    "SELECT NVL(PLID,' ') PLID, NVL(JJCR,' ') JJCR, NVL(CRGB,' ') CRGB, NVL(JHTN,' ') JHTN, \
NVL(JHTO,' ') JHTO, NVL(NRAT1, 0) NRAT1, NVL(NRAT2, 0) NRAT2, NVL(NRAT3, 0) NRAT3, NVL(NRAT4, 0) NRAT4, \
NVL(NRAT5, 0) NRAT5, NVL(NRAT6, 0) NRAT6, NVL(NRAT7, 0) NRAT7, NVL(NRAT8, 0) NRAT8, NVL(ORAT1, 0) ORAT1, NVL(ORAT2, 0) ORAT2, \
NVL(ORAT3, 0) ORAT3, NVL(ORAT4, 0) ORAT4, NVL(ORAT5, 0) ORAT5, NVL(ORAT6, 0) ORAT6, NVL(ORAT7, 0) ORAT7, NVL(ORAT8, 0) ORAT8 FROM TREV14M"

/***************************************************************************
   PUBL_LANESMS : ¥ä  -ok
***************************************************************************/
#define S_PUBL_LANESMS    "SELECT NVL(PLZ_ID,' ') PLID, NVL(LANE_NO,' ') CRBH, NVL(SND_TM,' ') HHBB, NVL(ADMIN_NO,' ') ADBH, \
NVL(MSG,' ') BIGO, NVL(SND_RES,' ') RSLT, NVL(SND_DATE,' ') JSDT FROM PUBL_LANESMS"

/***************************************************************************
   PUBM_FEEINFO :  -ok
***************************************************************************/
#define S_PUBM_FEEINFO    "SELECT NVL(APL_STDD_DATE,' ') GJDT, NVL(SKTR, 0) SKTR, NVL(KTFR, 0) KTFR, NVL(LGTR, 0) LGTR, NVL(HDCR, 0) HDCR, \
NVL(HNCR, 0) HNCR, NVL(WRCR, 0) WRCR, NVL(SSCR, 0) SSCR, NVL(SHCR, 0) SHCR, NVL(KMCR, 0) KMCR, NVL(OHCR, 0) OHCR, NVL(RDCR, 0) RDCR, \
NVL(BCCR, 0) BCCR, NVL(LGCR, 0) LGCR, NVL(SUCR, 0) SUCR, NVL(CTCR, 0) CTCR, NVL(HMCR, 0) HMCR, NVL(JJCR, 0) JJCR, NVL(JBCR, 0) JBCR, \
NVL(SACR, 0) SACR, NVL(KJCR, 0) KJCR, NVL(MODF_DT,' ') CRDT, NVL(ADMIN_NO,' ') KJBH, NVL(JRRA, 0) JRRA FROM PUBM_FEEINFO"

/***************************************************************************
   REVL_RATE : /  -ok
***************************************************************************/
#define S_REVL_RATE    "SELECT NVL(PLID,' ') PLID, NVL(SEQS, 0) SEQS, NVL(IRDT,' ') IRDT, NVL(UHGB,' ') UHGB, NVL(HIGB,' ') HIGB, NVL(ADBH,' ') ADBH, \
NVL(NSTI,' ') NSTI, NVL(NETI,' ') NETI, NVL(NPE1,' ') NPE1, NVL(NPE2,' ') NPE2, NVL(NPE3,' ') NPE3, NVL(NPE4,' ') NPE4, NVL(NPE5,' ') NPE5, \
NVL(NPE6,' ') NPE6, NVL(NPE7,' ') NPE7, NVL(NPE8,' ') NPE8 FROM REVL_RATE"

/***************************************************************************
   REVM_RATE : / -ok
***************************************************************************/
#define S_REVM_RATE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(KND_DIV,' ') UHGB, NVL(DC_EXTR_DIV,' ') HIGB, NVL(IN_DATE,' ') IRDT, NVL(ST_HR_MIN,' ') NSTI, \
NVL(END_HR_MIN,' ') NETI, NVL(CAR_KND_DC_EXTR1,' ') NPE1, NVL(CAR_KND_DC_EXTR2,' ') NPE2, NVL(CAR_KND_DC_EXTR3,' ') NPE3, NVL(CAR_KND_DC_EXTR4,' ') NPE4, NVL(CAR_KND_DC_EXTR5,' ') NPE5, NVL(CAR_KND_DC_EXTR6,' ') NPE6 \
, NVL(CAR_KND_DC_EXTR7,' ') NPE7, NVL(CAR_KND_DC_EXTR8,' ') NPE8 FROM REVM_RATE"

/***************************************************************************
   PUBM_LANESTATE : ¥ë -ok  F_LCYB,F_GBCY
***************************************************************************/
#define S_PUBM_LANESTATE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(LANE_NO,' ') CRBH, NVL(LANE_TYP,' ') CRHT, NVL(MCHI_STAT,' ') GGST, \
NVL(BAS_STAT,' ') GCST, NVL(BAS_RVS_NO, 0) GCBH, NVL(WRKR_CRD_STAT,' ') KCST, NVL(WRKR_CRD_RVS_NO, 0) KCBH, NVL(FARE_STAT,' ') YGST, NVL(FARE_RVS_NO, 0) YGBH, \
NVL(BL_CCRD_STAT,' ') BCST, NVL(BL_CCRD_RVS_NO, 0) BCBH, NVL(BL_EXMT_STAT,' ') BMST, NVL(BL_EXMT_RVS_NO, 0) BMBH, NVL(BL_DUMMY_STAT,' ') BGST, NVL(BL_DUMMY_RVS_NO, 0) BGBH, \
NVL(HDAY_STAT,' ') HDST, NVL(HDAY_RVS_NO, 0) HDBH, NVL(CMUT_STAT,' ') CTST, NVL(CMUT_RVS_NO, 0) CTBH, NVL(BL_ECRD_STAT,' ') BSST, NVL(BL_ECRD_RVS_NO, 0) BSBH, \
NVL(LNK_FARE_STAT,' ') YYST, NVL(LNK_FARE_RVS_NO, 0) YYBH, NVL(TCRD_BIN_STAT,' ') BBST, NVL(TCRD_BIN_RVS_NO, 0) BBBH, NVL(BL_TCRD_STAT,' ') GBST, NVL(BL_TCRD_RVS_NO, 0) GBBH, \
NVL(TIME_DC_STAT1,' ') SGST, NVL(TIME_DC_RVS_NO1, 0) SGBH, NVL(TIME_DC_STAT2,' ') BOST, NVL(TIME_DC_RVS_NO2, 0) BOBH, NVL(CONTROL_DIV,' ') JGGB, NVL(FW_NO,' ') CFBJ, \
NVL(FW_STAT,' ') CFST, NVL(EP_PAY_TRMN_FW_VER,' ') JFBJ, NVL(EP_PAY_TRMN_FW_STAT,' ') JFST, NVL(OUT_TRMN_FW_VER,' ') EFBJ, NVL(OUT_TRMN_FW_STAT,' ') EFST, NVL(ECRD_BL_NO, 0) LCYB, \
NVL(LST_CLCT_TM,' ') HHBB, NVL(COMM_STAT,' ') CMST, NVL(ECRD_FILE_NO, 0) F_LCYB, NVL(TCRD_FILE_NO, 0) F_GBCY FROM PUBM_LANESTATE"

/***************************************************************************
   PUBM_WORKSTATE : TCS  -ok
***************************************************************************/
#define S_PUBM_WORKSTATE    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, \
NVL(LANE_DIV,' ') CRTY, NVL(WRKR_NO,' ') KJBH, NVL(STRT_DATE,' ') STDT, NVL(END_DATE,' ') EDDT, NVL(STRT_DIV,' ') STGB, \
NVL(END_DIV,' ') EDGB, NVL(STRT_SND_NO, 0) STNO, NVL(END_SND_NO, 0) EDNO, NVL(WRK_DIV,' ') KMGB, NVL(WRK_END_STAT,' ') KMST FROM PUBM_WORKSTATE"

/***************************************************************************
   PUBS_WORKSTATUS : / -ok
***************************************************************************/
#define S_PUBS_WORKSTATUS    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(WEATHER,' ') WEATHER, NVL(CKMJ,' ') CKMJ, \
NVL(KMSK,' ') KMSK, NVL(KMHW,' ') KMHW, NVL(C_SNSW, 0) C_SNSW, NVL(C_SN, 0) C_SN, NVL(C_PTJ, 0) C_PTJ, \
NVL(C_HAP, 0) C_HAP, NVL(J_SNSW, 0) J_SNSW, NVL(J_SN, 0) J_SN, NVL(J_PTJ, 0) J_PTJ, NVL(J_HAP, 0) J_HAP, \
NVL(M_SNSW, 0) M_SNSW, NVL(M_SN, 0) M_SN, NVL(M_PTJ, 0) M_PTJ, NVL(M_HAP, 0) M_HAP, NVL(I_SNSW, 0) I_SNSW,  \
NVL(I_SN, 0) I_SN, NVL(I_PTJ, 0) I_PTJ, NVL(I_HAP, 0) I_HAP, NVL(IL_GT, 0) IL_GT, NVL(SGHM, 0) SGHM, \
NVL(SGGG, 0) SGGG, NVL(SGBG, 0) SGBG, NVL(SGBK, 0) SGBK, NVL(SGGT, 0) SGGT, NVL(ILKJ,' ') ILKJ, \
NVL(YJKJ,' ') YJKJ, NVL(KWKJ,' ') KWKJ, NVL(BIGO,' ') BIGO, NVL(IKTY, 0) IKTY, NVL(GKTY, 0) GKTY, \
NVL(TYHAP, 0) TYHAP, NVL(ISKJ,' ') ISKJ, NVL(IKKJ,' ') IKKJ, NVL(DLHY, 0) DLHY, NVL(NHHY, 0) NHHY FROM PUBS_WORKSTATUS"

/***************************************************************************
   TSTO01M :   -@@
***************************************************************************/
#define S_TSTO01M    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(IOGB,' ') IOGB, NVL(IOBH, 0) IOBH, \
NVL(IODT,' ') IODT, NVL(KJBH,' ') KJBH, NVL(FRPL,' ') FRPL, NVL(TOPL,' ') TOPL, NVL(GCGJ,' ') GCGJ, NVL(SBSR, 0) SBSR, \
NVL(SJBH,' ') SJBH, NVL(JRBH,' ') JRBH, NVL(BIGO,' ') BIGO FROM TSTO01M"

/***************************************************************************
   TSTO02M :   -@@
***************************************************************************/
#define S_TSTO02M    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(IOGB,' ') IOGB, NVL(IOBH, 0) IOBH, \
NVL(GCBH,' ') GCBH, NVL(GCGJ,' ') GCGJ FROM TSTO02M"

/***************************************************************************
   TSTO03M :  ¥ê¬Û -@@
***************************************************************************/
#define S_TSTO03M    "SELECT NVL(PLID,' ') PLID, NVL(CRBH,' ') CRBH, NVL(KMDT,' ') KMDT, NVL(BSDT,' ') BSDT, \
NVL(KJBH,' ') KJBH, NVL(GUNJ,' ') GUNJ, NVL(CDMS, 0) CDMS, NVL(SJBH,' ') SJBH, NVL(JRBH,' ') JRBH, NVL(CRKJ,' ') CRKJ, NVL(BIGO,' ') BIGO FROM TSTO03M"

/***************************************************************************
   TSTO04M : SAM  -@@
***************************************************************************/
#define S_TSTO04M    "SELECT NVL(IGBH, 0) IGBH, NVL(IGDT,' ') IGDT, NVL(IGTI,' ') IGTI, NVL(MFGR,' ') MFGR, \
NVL(SAMTY,' ') SAMTY, NVL(PLID,' ') PLID, NVL(WNT, 0) WNT, NVL(IGST,' ') IGST, NVL(DDID,' ') DDID, NVL(SAMGB,' ') SAMGB, NVL(GIBH, 0) GIBH FROM TSTO04M"

/***************************************************************************
   TSTO05M : SAM  -@@
***************************************************************************/
#define S_TSTO05M    "SELECT NVL(CGBH, 0) CGBH, NVL(CGIJ,' ') CGIJ, NVL(CGTI,' ') CGTI, NVL(SAMTY,' ') SAMTY, \
NVL(CGPL,' ') CGPL, NVL(IGPL,' ') IGPL, NVL(SJSB,' ') SJSB, NVL(SEBH,' ') SEBH, NVL(CUNT, 0) CUNT, NVL(DDID,' ') DDID, \
NVL(COMM,' ') COMM, NVL(SAMGB,' ') SAMGB FROM TSTO05M"

/***************************************************************************
   TSTO06M : SAM  -@@
***************************************************************************/
#define S_TSTO06M    "SELECT NVL(WRDT, 0) WRDT, NVL(PLID,' ') PLID, NVL(SAMTY,' ') SAMTY, NVL(STOCK,' ') STOCK, \
NVL(IGCN,' ') IGCN, NVL(CGCN,' ') CGCN, NVL(FGCN,' ') FGCN, NVL(FGCN_ER,' ') FGCN_ER, NVL(DDID,' ') DDID, NVL(LOSS,' ') LOSS FROM TSTO06M"

/***************************************************************************
   TTMP01S : ¢®(¢®, MIS) -@@
***************************************************************************/
#define S_TTMP01S    "SELECT NVL(INCOME_IL,' ') INCOME_IL, NVL(INCOME_PLACE_GU,' ') INCOME_PLACE_GU, NVL(INCOME_FLAG,' ') INCOME_FLAG, \
NVL(IN_R_QTY, 0) IN_R_QTY, NVL(IN_R_AMT, 0) IN_R_AMT, NVL(IN_R_VAT, 0) IN_R_VAT, NVL(IN_S_QTY, 0) IN_S_QTY, NVL(IN_S_AMT, 0) IN_S_AMT, \
NVL(IN_S_VAT, 0) IN_S_VAT, NVL(IN_M_QTY, 0) IN_M_QTY, NVL(IN_M_AMT, 0) IN_M_AMT, NVL(IN_M_VAT, 0) IN_M_VAT, NVL(IN_G_QTY, 0) IN_G_QTY, \
NVL(IN_G_AMT, 0) IN_G_AMT, NVL(IN_G_VAT, 0) IN_G_VAT, NVL(IN_X_QTY, 0) IN_X_QTY, NVL(IN_X_AMT, 0) IN_X_AMT, NVL(TOTL_QTY, 0) TOTL_QTY, \
NVL(TOTL_AMT, 0) TOTL_AMT, NVL(TOTL_VAT, 0) TOTL_VAT, NVL(H_TOTL_QTY, 0) H_TOTL_QTY, NVL(H_TOTL_AMT, 0) H_TOTL_AMT, \
NVL(H_TOTL_VAT, 0) H_TOTL_VAT, NVL(INCOME_NAME,' ') INCOME_NAME, NVL(IN_O_QTY, 0) IN_O_QTY, NVL(IN_O_AMT, 0) IN_O_AMT, \
NVL(IN_O_VAT, 0) IN_O_VAT, NVL(JUNPYO_YN,' ') JUNPYO_YN FROM TTMP01S"

/***************************************************************************
   TTMP02S :  (¢®, MIS) -@@
***************************************************************************/
#define S_TTMP02S    "SELECT NVL(SALE_IL,' ') SALE_IL, NVL(SALE_PLACE_GU,' ') SALE_PLACE_GU, NVL(SALE_FLAG,' ') SALE_FLAG, \
NVL(SALE_QTY_1,  0) SALE_QTY_1 , NVL(SALE_QTY_2,  0) SALE_QTY_2 , NVL(SALE_QTY_3,  0) SALE_QTY_3 , NVL(SALE_QTY_5,  0) SALE_QTY_5 , \
NVL(SALE_QTY_10, 0) SALE_QTY_10, NVL(SALE_QTY_X1, 0) SALE_QTY_X1, NVL(SALE_QTY_X2, 0) SALE_QTY_X2, NVL(SALE_QTY_X3, 0) SALE_QTY_X3, \
NVL(SALE_QTY_X4, 0) SALE_QTY_X4, NVL(SALE_AMT_1,  0) SALE_AMT_1 , NVL(SALE_AMT_2,  0) SALE_AMT_2 , NVL(SALE_AMT_3,  0) SALE_AMT_3 , \
NVL(SALE_AMT_5,  0) SALE_AMT_5 , NVL(SALE_AMT_10, 0) SALE_AMT_10, NVL(SALE_AMT_X1, 0) SALE_AMT_X1, NVL(SALE_AMT_X2, 0) SALE_AMT_X2, \
NVL(SALE_AMT_X3, 0) SALE_AMT_X3, NVL(SALE_AMT_X4, 0) SALE_AMT_X4, NVL(HABL_QTY_1,  0) HABL_QTY_1 , NVL(HABL_QTY_2,  0) HABL_QTY_2 , \
NVL(HABL_AMT_1,  0) HABL_AMT_1 , NVL(HABL_AMT_2,  0) HABL_AMT_2 , NVL(SALE_NAME, ' ') SALE_NAME  , NVL(JUNPYO_YN, ' ') JUNPYO_YN FROM TTMP02S"

/***************************************************************************
   TVER01L : S/W  -@@
***************************************************************************/
#define S_TVER01L    "SELECT NVL(SYST,' ') SYST, NVL(VERN,' ') VERN, NVL(MKDT,' ') MKDT, NVL(JYDT,' ') JYDT, NVL(BIGO,' ') BIGO FROM TVER01L"

/***************************************************************************
   PUBL_WORKCLOSING :  -ok
***************************************************************************/
#define S_PUBL_WORKCLOSING    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, NVL(LANE_DIV,' ') KMGB, \
NVL(STRT_TM,' ') STTI, NVL(END_TM,' ') EDTI, NVL(WRKR_NO,' ') KJBH, NVL(CAR_SENS_ADV_CNT, 0) JJDS, NVL(CAR_SENS_REV_CNT, 0) HJDS, NVL(CAR_HND_CNT, 0) CRDS, \
NVL(CSH_CNT, 0) HKDS, NVL(DUMMY_CNT, 0) GCDS, NVL(ECRD_CNT_PPAY, 0) JCDS, NVL(TCDS, 0) TCDS, NVL(PASS_FARE_SUM_CNT, 0) TODS, NVL(COL_CSH, 0) HKSN, \
NVL(COL_RCT_CSH, 0) HKSK, NVL(DUMMY_SUM, 0) GCSN, NVL(CSH_RCT_PASS_FARE, 0) JCSN, NVL(TCSN, 0) TCSN, NVL(SUM_COL_PASS_FARE, 0) TOSN, NVL(SUM_COL_RCT_CSH, 0) TOSK, \
NVL(LSAM_CARD_CHRG_MNY, 0) LSLM, NVL(LSAM_BALC, 0) LSJM, NVL(USE_CARD_CHRG_MNY, 0) SCLM, NVL(ECRD_SAL_CNT, 0) SCPS, NVL(ECRD_SAL_MNY, 0) SCPM, NVL(EXC_MNY, 0) GBUM, \
NVL(DUMMY_CNT3, 0) GCS3, NVL(DUMMY_CNT5, 0) GCS5, NVL(DUMMY_CNT10, 0) GCS10, NVL(NOTE,' ') BIGO, NVL(ADMIN_NO,' ') ADBH FROM PUBL_WORKCLOSING"

/***************************************************************************
   TWED02T :  -@@
***************************************************************************/
#define S_TWED02T    "SELECT NVL(PLID,' ') PLID, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, NVL(KJBH,' ') KJBH, NVL(IKBH,' ') IKBH, \
NVL(SGJBH, 0) SGJBH, NVL(SCRNO, 0) SCRNO, NVL(EGJBH, 0) EGJBH, NVL(ECRNO, 0) ECRNO FROM TWED02T"

/***************************************************************************
   TWED03T :   -@@
***************************************************************************/
#define S_TWED03T    "SELECT NVL(SSDT,' ') SSDT, NVL(MJBH,' ') MJBH, NVL(KMDT,' ') KMDT, NVL(KMBH,' ') KMBH, NVL(SJKM,' ') SJKM, \
NVL(RVNO, 0) RVNO, NVL(SSGG,' ') SSGG, NVL(BIGO,' ') BIGO FROM TWED03T"

/***************************************************************************
   PUBL_WORKENDAMEND :    -ok
***************************************************************************/
#define S_PUBL_WORKENDAMEND    "SELECT NVL(PLZ_ID,' ') PLID, NVL(MODF_HND_DATE_TM,' ') SCDT, NVL(WRK_DATE,' ') KMDT, NVL(WRK_NO,' ') KMBH, \
NVL(MODF_WRKR_NO,' ') KJBH, NVL(MODF_BEF_PASS_FARE, 0) JHKM, NVL(MODF_AFT_PASS_FARE, 0) HHKM, NVL(CAUS,' ') SAYU FROM PUBL_WORKENDAMEND"

/***************************************************************************
   PUBS_5MINTRIFFIC : ©£  -ok
***************************************************************************/
#define S_PUBS_5MINTRIFFIC    "SELECT NVL(PLZ_ID,' ') PLID, NVL(WRK_DATE,' ') KMDT, NVL(TM,' ') TIME, NVL(LANE_NO,' ') CRBH, \
NVL(CAR_KND, 0) CHJO, NVL(CALC_CNT, 0) JSDS, NVL(EXMT_CNT, 0) MJDS, NVL(EXMT_CRD, 0) MJCD, NVL(ESCP_CNT, 0) DJDS, NVL(DC_CRD, 0) HICD, \
NVL(DC_EXTR, 0) HIHJ, NVL(CHG_CAR_KND, 0) CJBK FROM PUBS_5MINTRIFFIC"

/***************************************************************************
   TWED06S : ©£  -@@
***************************************************************************/
#define S_TWED06S    "SELECT NVL(PLID,' ') PLID, NVL(CRBH,' ') CRBH, NVL(KMBH,' ') KMBH, NVL(KMDT,' ') KMDT, \
NVL(TIME,' ') TIME, NVL(CHJO, 0) CHJO, NVL(JSDS, 0) JSDS, NVL(MJDS, 0) MJDS, NVL(MJCD, 0) MJCD, NVL(DJDS, 0) DJDS, \
NVL(HICD, 0) HICD, NVL(HIHJ, 0) HIHJ, NVL(CJBK, 0) CJBK FROM TWED06S"

/***************************************************************************
   TWED07S : ©£ 2 -@@
***************************************************************************/
#define S_TWED07S    "SELECT NVL(PLID,' ') PLID, NVL(CRBH,' ') CRBH, NVL(KMDT,' ') KMDT, NVL(TIME,' ') TIME, \
NVL(CHJO, 0) CHJO, NVL(HKDS, 0) HKDS, NVL(GCDS, 0) GCDS, NVL(SCDS, 0) SCDS, NVL(MJDS, 0) MJDS, NVL(MJCD, 0) MJCD, \
NVL(HICD, 0) HICD, NVL(HIHJ, 0) HIHJ, NVL(SMDS, 0) SMDS, NVL(PTDS, 0) PTDS FROM TWED07S"

/***************************************************************************
   PUBS_TIMETRIFFIC : ©£ () -ok
***************************************************************************/
#define S_PUBS_TIMETRIFFIC    "SELECT NVL(PLZ_ID,' ') PLID, NVL(LANE_NO,' ') CRBH, NVL(WRK_DATE,' ') KMDT, NVL(TIME,' ') TIME, \
NVL(CAR_KND,' ') CHJO, NVL(HND_CODE,' ') CRCD, NVL(CAR_HND_CNT, 0) CRDS FROM PUBS_TIMETRIFFIC"

/***************************************************************************
   PUBS_TIMETRIFFICPAY : ©£ () -ok
***************************************************************************/
#define S_PUBS_TIMETRIFFICPAY    "SELECT NVL(PLZ_ID,' ') PLID, NVL(LANE_NO,' ') CRBH, NVL(WRK_DATE,' ') KMDT, NVL(TIME,' ') TIME, \
NVL(CAR_KND,' ') CHJO, NVL(HND_CODE,' ') CRCD, NVL(CAR_HND_CNT, 0) CRDS FROM PUBS_TIMETRIFFICPAY"


#endif  

