Itk
From SPGC Document Wiki
Contents
auditlogs
| auditlogs | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LOG_USER | varchar | 10 | No | No | No | |
| LOG_MODULE | varchar | 20 | No | No | No | |
| LOG_TBL | varchar | 60 | No | Yes | No | |
| LOG_DATE | date | 0 | No | No | No | |
| LOG_TIME | varchar | 10 | No | No | No | |
| LOG_ENUMB | varchar | 15 | No | No | No | |
| LOG_KEYREC | varchar | 60 | No | No | No | |
| LOG_FIELD | varchar | 20 | No | No | No | |
| LOG_OLDVAL | varchar | 30 | No | Yes | No | |
| LOG_NEWVAL | varchar | 30 | No | Yes | No | |
| LOG_CHANGE | varchar | 1 | No | Yes | No | |
| LOG_IPADDR | varchar | 20 | No | No | No | |
| LOG_PRNT | varchar | 1 | No | Yes | No | |
| LOG_SQLEXEC | longtext | 0 | No | Yes | No | |
dailymhr2015
| dailymhr2015 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| MHRNUMB | varchar | 25 | No | No | No | |
| MHRCDTE | date | 0 | No | No | No | |
| MHRDATE | date | 0 | No | No | No | |
| MHRTRDY | double | 15,2 | No | No | No | |
| MHRUTME | double | 15,2 | No | No | No | |
| MHRSLLV | double | 15,2 | No | No | No | |
| MHRVLLV | double | 15,2 | No | No | No | |
| MHRULOA | double | 15,2 | No | No | No | |
| MHRWOLV | double | 15,2 | No | No | No | |
| MHRDLOA | double | 15,2 | No | No | No | |
| MHROTHR | double | 15,2 | No | No | No | |
| MHRDAYS | double | 15,2 | No | No | No | |
| MHRCOCD | varchar | 25 | No | No | No | |
| MHRDPCD | varchar | 25 | No | No | No | |
| MHRDPCD_FLAG | varchar | 25 | No | No | No | |
| MHRRATEC | varchar | 25 | No | No | No | |
| MHRPYTYPE | varchar | 1 | No | No | No | |
| MHRTXTYPE | varchar | 1 | No | No | No | |
| MHRDEFDAYS | double | 15,2 | No | No | No | |
| MHRDEFMO | varchar | 2 | No | No | No | |
| MHRDEFCMO | varchar | 1 | No | No | No | |
| MHRDEFHRS | double | 15,2 | No | No | No | |
| MHRESCD | varchar | 15,2 | No | No | No | |
| MHRRRO1 | double | 15,2 | No | No | No | |
| MHRNRD1 | double | 15,2 | No | No | No | |
| MHRNRO1 | double | 15,2 | No | No | No | |
| MHRRRD2 | double | 15,2 | No | No | No | |
| MHRRRO2 | double | 15,2 | No | No | No | |
| MHRNRO2 | double | 15,2 | No | No | No | |
| MHRRSD1 | double | 15,2 | No | No | No | |
| MHRRSO1 | double | 15,2 | No | No | No | |
| MHRNSD1 | double | 15,2 | No | No | No | |
| MHRRSD2 | double | 15,2 | No | No | No | |
| MHRRSO2 | double | 15,2 | No | No | No | |
| MHRNSO1 | double | 15,2 | No | No | No | |
| MHRNSD2 | double | 15,2 | No | No | No | |
| MHRNSO2 | double | 15,2 | No | No | No | |
| MHRRLD1 | double | 15,2 | No | No | No | |
| MHRRLO1 | double | 15,2 | No | No | No | |
| MHRNLD1 | double | 15,2 | No | No | No | |
| MHRRLD2 | double | 15,2 | No | No | No | |
| MHRRLO2 | double | 15,2 | No | No | No | |
| MHRNLO1 | double | 15,2 | No | No | No | |
| MHRNLD2 | double | 15,2 | No | No | No | |
| MHRNLO2 | double | 15,2 | No | No | No | |
| MHRNRD2 | double | 15,2 | No | No | No | |
| MHRLHOL | double | 15,2 | No | No | No | |
| MHRSHOL | double | 15,2 | No | No | No | |
| MHRTHOL | double | 15,2 | No | No | No | |
| MHRRLEG | double | 15,2 | No | No | No | |
| MHRRSPC | double | 15,2 | No | No | No | |
| MHRFPER | varchar | 1 | No | No | No | |
| MHRADSL | double | 15,2 | No | No | No | |
| MHRADVL | double | 15,2 | No | No | No | |
| MHRDDSL | double | 15,2 | No | No | No | |
| MHRDDVL | varchar | 1 | No | No | No | |
| MHRSPLLV | double | 15,2 | No | No | No | |
| MHRLCCD | varchar | 25 | No | No | No | |
| MHRDDSL | MHRTDPD | 25 | No | No | No | |
dailymhr2016
| dailymhr2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| MHRNUMB | varchar | 25 | No | No | No | |
| MHRCDTE | date | 0 | No | No | No | |
| MHRDATE | date | 0 | No | No | No | |
| MHRTRDY | double | 15,2 | No | No | No | |
| MHRUTME | double | 15,2 | No | No | No | |
| MHRSLLV | double | 15,2 | No | No | No | |
| MHRVLLV | double | 15,2 | No | No | No | |
| MHRULOA | double | 15,2 | No | No | No | |
| MHRWOLV | double | 15,2 | No | No | No | |
| MHRDLOA | double | 15,2 | No | No | No | |
| MHROTHR | double | 15,2 | No | No | No | |
| MHRDAYS | double | 15,2 | No | No | No | |
| MHRCOCD | varchar | 25 | No | No | No | |
| MHRDPCD | varchar | 25 | No | No | No | |
| MHRDPCD_FLAG | varchar | 25 | No | No | No | |
| MHRRATEC | varchar | 25 | No | No | No | |
| MHRPYTYPE | varchar | 1 | No | No | No | |
| MHRTXTYPE | varchar | 1 | No | No | No | |
| MHRDEFDAYS | double | 15,2 | No | No | No | |
| MHRDEFMO | varchar | 2 | No | No | No | |
| MHRDEFCMO | varchar | 1 | No | No | No | |
| MHRDEFHRS | double | 15,2 | No | No | No | |
| MHRESCD | varchar | 15,2 | No | No | No | |
| MHRRRO1 | double | 15,2 | No | No | No | |
| MHRNRD1 | double | 15,2 | No | No | No | |
| MHRNRO1 | double | 15,2 | No | No | No | |
| MHRRRD2 | double | 15,2 | No | No | No | |
| MHRRRO2 | double | 15,2 | No | No | No | |
| MHRNRO2 | double | 15,2 | No | No | No | |
| MHRRSD1 | double | 15,2 | No | No | No | |
| MHRRSO1 | double | 15,2 | No | No | No | |
| MHRNSD1 | double | 15,2 | No | No | No | |
| MHRRSD2 | double | 15,2 | No | No | No | |
| MHRRSO2 | double | 15,2 | No | No | No | |
| MHRNSO1 | double | 15,2 | No | No | No | |
| MHRNSD2 | double | 15,2 | No | No | No | |
| MHRNSO2 | double | 15,2 | No | No | No | |
| MHRRLD1 | double | 15,2 | No | No | No | |
| MHRRLO1 | double | 15,2 | No | No | No | |
| MHRNLD1 | double | 15,2 | No | No | No | |
| MHRRLD2 | double | 15,2 | No | No | No | |
| MHRRLO2 | double | 15,2 | No | No | No | |
| MHRNLO1 | double | 15,2 | No | No | No | |
| MHRNLD2 | double | 15,2 | No | No | No | |
| MHRNLO2 | double | 15,2 | No | No | No | |
| MHRNRD2 | double | 15,2 | No | No | No | |
| MHRLHOL | double | 15,2 | No | No | No | |
| MHRSHOL | double | 15,2 | No | No | No | |
| MHRTHOL | double | 15,2 | No | No | No | |
| MHRRLEG | double | 15,2 | No | No | No | |
| MHRRSPC | double | 15,2 | No | No | No | |
| MHRFPER | varchar | 1 | No | No | No | |
| MHRADSL | double | 15,2 | No | No | No | |
| MHRADVL | double | 15,2 | No | No | No | |
| MHRDDSL | double | 15,2 | No | No | No | |
| MHRDDVL | varchar | 1 | No | No | No | |
| MHRSPLLV | double | 15,2 | No | No | No | |
| MHRLCCD | varchar | 25 | No | No | No | |
| MHRTDPD | varchar | 25 | No | No | No | |
dtt2015
| dtt2015 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| DT_ENUMB | varchar | 25 | No | No | No | |
| DT_WS_CODE | varchar | 25 | No | No | No | |
| DT_DYCODE | varchar | 3 | No | No | No | |
| DT_DYTYPE | varchar | 25 | No | No | No | |
| DT_LCCD | varchar | 25 | No | No | No | |
| DT_DPCD | varchar | 25 | No | No | No | |
| DT_COCD | varchar | 25 | No | No | No | |
| DT_FPID | varchar | 25 | No | No | No | |
| DT_PCCD | varchar | 25 | No | No | No | |
| DT_TDPD | varchar | 25 | No | No | No | |
| DT_DTETRX | date | 0 | No | No | No | |
| DT_SAMIN | datetime | 0 | No | No | No | |
| DT_SAMOUT | datetime | 0 | No | No | No | |
| DT_SPMIN | datetime | 0 | No | No | No | |
| DT_SPMOUT | datetime | 0 | No | No | No | |
| DT_GPERD | double | 15,2 | No | No | No | |
| DT_NSSTART | datetime | 0 | No | No | No | |
| DT_NSEND | datetime | 0 | No | No | No | |
| DT_AAMIN | datetime | 0 | No | No | No | |
| DT_AAMOUT | datetime | 0 | No | No | No | |
| DT_APMIN | datetime | 0 | No | No | No | |
| DT_APMOUT | datetime | 0 | No | No | No | |
| DT_ACBOUT | datetime | 0 | No | No | No | |
| DT_ACBIN | datetime | 0 | No | No | No | |
| DT_CBOUT | datetime | 0 | No | No | No | |
| DT_CBIN | datetime | 0 | No | No | No | |
| DT_CBLATES | double | 15,2 | No | No | No | |
| DT_AMIN | datetime | 0 | No | No | No | |
| DT_AMOUT | datetime | 0 | No | No | No | |
| DT_PMIN | datetime | 0 | No | No | No | |
| DT_PMOUT | datetime | 0 | No | No | No | |
| DT_AM_IN | datetime | 0 | No | No | No | |
| DT_AM_OUT | datetime | 0 | No | No | No | |
| DT_PM_IN | datetime | 0 | No | No | No | |
| DT_PM_OUT | datetime | 0 | No | No | No | |
| DT_VAMIN | datetime | 0 | No | No | No | |
| DT_VAMOUT | datetime | 0 | No | No | No | |
| DT_VPMIN | datetime | 0 | No | No | No | |
| DT_VPMOUT | datetime | 0 | No | No | No | |
| DT_AMLATES | double | 15,2 | No | No | No | |
| DT_PMLATES | double | 15,2 | No | No | No | |
| DT_UNDERT | double | 15,2 | No | No | No | |
| DT_UTFILE | double | 15,2 | No | No | No | |
| DT_ATHRS | double | 15,2 | No | No | No | |
| DT_ABS | double | 15,2 | No | No | No | |
| DT_REQTHRS | double | 15,2 | No | No | No | |
| DT_NS_HRS | double | 15,2 | No | No | No | |
| DT_AM_NS_HRS | double | 15,2 | No | No | No | |
| DT_ROTAM | double | 15,2 | No | No | No | |
| DT_ROTPM | double | 15,2 | No | No | No | |
| DT_USER | varchar | 25 | No | No | No | |
| DT_DATEP | datetime | 1 | No | No | No | |
| DT_REMK | varchar | 25 | No | No | No | |
| DT_NDFLAG | varchar | 1 | No | No | No | |
| DT_FLAG | varchar | 1 | No | No | No | |
| DT_COMPLETE | varchar | 1 | No | No | No | |
| DT_MHC_GRP | varchar | 1 | No | No | No | |
| DT_OTAM_PD | double | 15,2 | No | No | No | |
| DT_OTPM_PD | double | 15,2 | No | No | No | |
| DT_AMLATES_DED | double | 15,2 | No | No | No | |
| DT_UNDERT_DED | double | 15,2 | No | No | No | |
| DT_OTREG_PD | double | 15,2 | No | No | No | |
| DT_REG_HRS_PD | double | 15,2 | No | No | No | |
| DT_NS_HRS_PD | double | 15,2 | No | No | No | |
| DT_THRSWS | double | 15,2 | No | No | No | |
| DT_AMLATES_MIN | double | 15,2 | No | No | No | |
| DT_UNDERT_MIN | double | 15,2 | No | No | No | |
| DT_EMP_RDORG | varchar | 3 | No | No | No | |
| DT_EMP_RDORD | varchar | 3 | No | No | No | |
| DT_EMP_OTSUN | varchar | 1 | No | No | No | |
| DT_EMP_OTHOL | varchar | 1 | No | No | No | |
| DT_EMP_OTREG | varchar | 1 | No | No | No | |
| DT_PYTYPE | varchar | 1 | No | No | No | |
| DT_TXTYPE | varchar | 1 | No | No | No | |
| DT_ERATEC | varchar | 25 | No | No | No | |
| DT_NODYYR | double | 15,2 | No | No | No | |
| DT_NOHRDY | double | 15,2 | No | No | No | |
| DT_THRSWS_PD | double | 15,2 | No | No | No | |
| DT_CDTE | date | 0 | No | No | No | |
| DT_LV_CODE | varchar | 25 | No | No | No | |
| DT_LVP_DYS | double | 15,2 | No | No | No | |
| DT_LVP_HRS | double | 15,2 | No | No | No | |
| DT_CS | varchar | 25 | No | No | No | |
| DT_REGD_X8 | double | 15,2 | No | No | No | |
| DT_REGD_PHOL | date | 0 | No | No | No | |
| DT_REGD_PHOL_HRS_PD | double | 15,2 | No | No | No | |
| DT_CSHIFT | varchar | 1 | No | No | No | |
| DT_OT_IN | datetime | 0 | No | No | No | |
| DT_OT_OUT | datetime | 0 | No | No | No | |
| DT_OT_S | datetime | 0 | No | No | No | |
| DT_OT_E | datetime | 0 | No | No | No | |
| DT_WS_GPERD | double | 10,2 | No | No | No | |
| DT_AUTO_AMHDAY | double | 15,2 | No | No | No | |
| DT_AUTO_AMWDAY | double | 15,2 | No | No | No | |
| DT_MINS_MIN_OT | double | 15,2 | No | No | No | |
| DT_MFLAG_DAY | varchar | 1 | No | No | No | |
| DT_AUTO_PMHDAY | double | 15,2 | No | No | No | |
| DT_AUTO_PMWDAY | double | 15,2 | No | No | No | |
| DT_CB | double | 15,2 | No | No | No | |
dtt2016
| dtt2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| DT_ENUMB | varchar | 25 | No | No | No | |
| DT_WS_CODE | varchar | 25 | No | No | No | |
| DT_DYCODE | varchar | 3 | No | No | No | |
| DT_DYTYPE | varchar | 25 | No | No | No | |
| DT_LCCD | varchar | 25 | No | No | No | |
| DT_DPCD | varchar | 25 | No | No | No | |
| DT_COCD | varchar | 25 | No | No | No | |
| DT_FPID | varchar | 25 | No | No | No | |
| DT_PCCD | varchar | 25 | No | No | No | |
| DT_TDPD | varchar | 25 | No | No | No | |
| DT_DTETRX | date | 0 | No | No | No | |
| DT_SAMIN | datetime | 0 | No | No | No | |
| DT_SAMOUT | datetime | 0 | No | No | No | |
| DT_SPMIN | datetime | 0 | No | No | No | |
| DT_SPMOUT | datetime | 0 | No | No | No | |
| DT_GPERD | double | 15,2 | No | No | No | |
| DT_NSSTART | datetime | 0 | No | No | No | |
| DT_NSEND | datetime | 0 | No | No | No | |
| DT_AAMIN | datetime | 0 | No | No | No | |
| DT_AAMOUT | datetime | 0 | No | No | No | |
| DT_APMIN | datetime | 0 | No | No | No | |
| DT_APMOUT | datetime | 0 | No | No | No | |
| DT_ACBOUT | datetime | 0 | No | No | No | |
| DT_ACBIN | datetime | 0 | No | No | No | |
| DT_CBOUT | datetime | 0 | No | No | No | |
| DT_CBIN | datetime | 0 | No | No | No | |
| DT_CBLATES | double | 15,2 | No | No | No | |
| DT_AMIN | datetime | 0 | No | No | No | |
| DT_AMOUT | datetime | 0 | No | No | No | |
| DT_PMIN | datetime | 0 | No | No | No | |
| DT_PMOUT | datetime | 0 | No | No | No | |
| DT_AM_IN | datetime | 0 | No | No | No | |
| DT_AM_OUT | datetime | 0 | No | No | No | |
| DT_PM_IN | datetime | 0 | No | No | No | |
| DT_PM_OUT | datetime | 0 | No | No | No | |
| DT_VAMIN | datetime | 0 | No | No | No | |
| DT_VAMOUT | datetime | 0 | No | No | No | |
| DT_VPMIN | datetime | 0 | No | No | No | |
| DT_VPMOUT | datetime | 0 | No | No | No | |
| DT_AMLATES | double | 15,2 | No | No | No | |
| DT_PMLATES | double | 15,2 | No | No | No | |
| DT_UNDERT | double | 15,2 | No | No | No | |
| DT_UTFILE | double | 15,2 | No | No | No | |
| DT_ATHRS | double | 15,2 | No | No | No | |
| DT_ABS | double | 15,2 | No | No | No | |
| DT_REQTHRS | double | 15,2 | No | No | No | |
| DT_NS_HRS | double | 15,2 | No | No | No | |
| DT_AM_NS_HRS | double | 15,2 | No | No | No | |
| DT_ROTAM | double | 15,2 | No | No | No | |
| DT_ROTPM | double | 15,2 | No | No | No | |
| DT_USER | varchar | 25 | No | No | No | |
| DT_DATEP | datetime | 1 | No | No | No | |
| DT_REMK | varchar | 25 | No | No | No | |
| DT_NDFLAG | varchar | 1 | No | No | No | |
| DT_FLAG | varchar | 1 | No | No | No | |
| DT_COMPLETE | varchar | 1 | No | No | No | |
| DT_MHC_GRP | varchar | 1 | No | No | No | |
| DT_OTAM_PD | double | 15,2 | No | No | No | |
| DT_OTPM_PD | double | 15,2 | No | No | No | |
| DT_AMLATES_DED | double | 15,2 | No | No | No | |
| DT_UNDERT_DED | double | 15,2 | No | No | No | |
| DT_OTREG_PD | double | 15,2 | No | No | No | |
| DT_REG_HRS_PD | double | 15,2 | No | No | No | |
| DT_NS_HRS_PD | double | 15,2 | No | No | No | |
| DT_THRSWS | double | 15,2 | No | No | No | |
| DT_AMLATES_MIN | double | 15,2 | No | No | No | |
| DT_UNDERT_MIN | double | 15,2 | No | No | No | |
| DT_EMP_RDORG | varchar | 3 | No | No | No | |
| DT_EMP_RDORD | varchar | 3 | No | No | No | |
| DT_EMP_OTSUN | varchar | 1 | No | No | No | |
| DT_EMP_OTHOL | varchar | 1 | No | No | No | |
| DT_EMP_OTREG | varchar | 1 | No | No | No | |
| DT_PYTYPE | varchar | 1 | No | No | No | |
| DT_TXTYPE | varchar | 1 | No | No | No | |
| DT_ERATEC | varchar | 25 | No | No | No | |
| DT_NODYYR | double | 15,2 | No | No | No | |
| DT_NOHRDY | double | 15,2 | No | No | No | |
| DT_THRSWS_PD | double | 15,2 | No | No | No | |
| DT_CDTE | date | 0 | No | No | No | |
| DT_LV_CODE | varchar | 25 | No | No | No | |
| DT_LVP_DYS | double | 15,2 | No | No | No | |
| DT_LVP_HRS | double | 15,2 | No | No | No | |
| DT_CS | varchar | 25 | No | No | No | |
| DT_REGD_X8 | double | 15,2 | No | No | No | |
| DT_REGD_PHOL | date | 0 | No | No | No | |
| DT_REGD_PHOL_HRS_PD | double | 15,2 | No | No | No | |
| DT_CSHIFT | varchar | 1 | No | No | No | |
| DT_OT_IN | datetime | 0 | No | No | No | |
| DT_OT_OUT | datetime | 0 | No | No | No | |
| DT_OT_S | datetime | 0 | No | No | No | |
| DT_OT_E | datetime | 0 | No | No | No | |
| DT_WS_GPERD | double | 10,2 | No | No | No | |
| DT_AUTO_AMHDAY | double | 15,2 | No | No | No | |
| DT_AUTO_AMWDAY | double | 15,2 | No | No | No | |
| DT_MINS_MIN_OT | double | 15,2 | No | No | No | |
| DT_MFLAG_DAY | varchar | 1 | No | No | No | |
| DT_AUTO_PMHDAY | double | 15,2 | No | No | No | |
| DT_AUTO_PMWDAY | double | 15,2 | No | No | No | |
| DT_CB | double | 15,2 | No | No | No | |
employee
| employee | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 25 | No | No | No | |
| AEMPNUMB | varchar | 25 | No | No | No | |
| EMPLNAM | varchar | 30 | No | No | No | |
| EMPFNAM | varchar | 30 | No | No | No | |
| EMPMNAM | varchar | 30 | No | No | No | |
| EMPSXCD | varchar | 1 | No | No | No | |
| EMPBDTE | date | 0 | No | No | No | |
| EMPPOBT | varchar | 15 | No | No | No | |
| EMPRGCD | varchar | 2 | No | No | No | |
| EMPCSCD | varchar | 1 | No | No | No | |
| EMPCADD | varchar | 40 | No | No | No | |
| EMPTOWN | varchar | 20 | No | No | No | |
| EMPCITY | varchar | 20 | No | No | No | |
| EMPCZCD | varchar | 2 | No | No | No | |
| EMPTXCD | varchar | 10 | No | No | No | |
| EMPLDTE | date | 0 | No | No | No | |
| EMPSSNO | varchar | 25 | No | No | No | |
| EMPTINO | varchar | 25 | No | No | No | |
| EMPHDTE | date | 0 | No | No | No | |
| EMPODTE | date | 0 | No | No | No | |
| EMPPMCD | varchar | 1 | No | No | No | |
| EMPPCCD | varchar | 1 | No | No | No | |
| EMPCOCD | datetime | 0 | No | No | No | |
| EMPLCCD | varchar | 25 | No | No | No | |
| EMPPSCD | varchar | 25 | No | No | No | |
| EMPSTAT | varchar | 1 | No | No | No | |
| EMPSTDT | date | 0 | No | No | No | |
| EMPPINO | varchar | 12 | No | No | No | |
| EMPAVOL | tinyint | 1 | No | No | No | |
| EMPPVOL | tinyint | 1 | No | No | No | |
| EMPTDPD | varchar | 1 | No | No | No | |
| EMPCBAT | varchar | 1 | No | No | No | |
| EMPDPCD | varchar | 25 | No | No | No | |
| EMPESCD | varchar | 1 | No | No | No | |
| EMPDPCC | varchar | 10 | No | No | No | |
| EMPINCO | varchar | 1 | No | No | No | |
| EMPBPAY | double | 15,2 | No | No | No | |
| EMPALLO | double | 15,2 | No | No | No | |
| EMPFEPF | varchar | 1 | No | No | No | |
| EMPHLDT | date | 0 | No | No | No | |
| EMPMENO | varchar | 25 | No | No | No | |
| EMPDBNK | varchar | 5 | No | No | No | |
| EMPEOCD | date | 0 | No | No | No | |
| EMPEOCC | varchar | 1 | No | No | No | |
| EMPADDR1 | varchar | 150 | No | No | No | |
| EMPADDR2 | varchar | 150 | No | No | No | |
| EMPADDR3 | varchar | 150 | No | No | No | |
| EMPADDR4 | varchar | 150 | No | No | No | |
| EMPATMP | varchar | 16 | No | No | No | |
| EMPTELN | varchar | 150 | No | No | No | |
| EMPBKCD | varchar | 3 | No | No | No | |
| EMPUNITHEAD | varchar | 50 | No | No | No | |
| EMPUNIT | varchar | 50 | No | No | No | |
| EMPDEMINI_AMT | double | 15,2 | No | No | No | |
| EMPREC_UPLD | varchar | 1 | No | No | No | |
| EMPREC_PSTD | varchar | 1 | No | No | No | |
| EMPREGN | varchar | 25 | No | No | No | |
| EMPREGNAREA | varchar | 25 | No | No | No | |
| EMPPACD | varchar | 25 | No | No | No | |
| EMPWSCD | varchar | 25 | No | No | No | |
| EMPFPER | varchar | 25 | No | No | No | |
| EMPPYEF | date | 0 | No | No | No | |
| EMPBLOC | varchar | 25 | No | No | No | |
| EMPORDRD | varchar | 1 | No | No | No | |
| EMPORGRD | varchar | 1 | No | No | No | |
| EMPUSER | varchar | 10 | No | No | No | |
| EMP_UPLD_USER | varchar | 10 | No | No | No | |
| EMP_UPLD_DPROC | datetime | 0 | No | No | No | |
| EMPENCD | datetime | 0 | No | No | No | |
lvdt2015
| lvdt2015 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| LV_ENUMB | varchar | 25 | No | No | No | |
| LV_WS_CODE | varchar | 25 | No | No | No | |
| LV_DYCODE | varchar | 3 | No | No | No | |
| LV_DYTYPE | varchar | 25 | No | No | No | |
| LV_LCCD | varchar | 25 | No | No | No | |
| LV_DPCD | varchar | 25 | No | No | No | |
| LV_COCD | varchar | 25 | No | No | No | |
| LV_CDTE | date | 0 | No | No | No | |
| LV_DTETRX | date | 0 | No | No | No | |
| LV_SAMIN | datetime | 0 | No | No | No | |
| LV_SAMOUT | datetime | 0 | No | No | No | |
| LV_SPMIN | datetime | 0 | No | No | No | |
| LV_SPMOUT | datetime | 0 | No | No | No | |
| LV_TYPE | varchar | 25 | No | No | No | |
| LV_OPTN | varchar | 25 | No | No | No | |
| LV_APHRS | double | 15,2 | No | No | No | |
| LV_PDHRS | double | 15,2 | No | No | No | |
| LV_USER | varchar | 25 | No | No | No | |
| LV_ENCD | datetime | 0 | No | No | No | |
| LV_APP | varchar | 1 | No | No | No | |
| LV_REMK | longtext | 0 | No | No | No | |
| LV_FLAG | varchar | 1 | No | No | No | |
lvdt2016
| lvdt2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| LV_ENUMB | varchar | 25 | No | No | No | |
| LV_WS_CODE | varchar | 25 | No | No | No | |
| LV_DYCODE | varchar | 3 | No | No | No | |
| LV_DYTYPE | varchar | 25 | No | No | No | |
| LV_LCCD | varchar | 25 | No | No | No | |
| LV_DPCD | varchar | 25 | No | No | No | |
| LV_COCD | varchar | 25 | No | No | No | |
| LV_CDTE | date | 0 | No | No | No | |
| LV_DTETRX | date | 0 | No | No | No | |
| LV_SAMIN | datetime | 0 | No | No | No | |
| LV_SAMOUT | datetime | 0 | No | No | No | |
| LV_SPMIN | datetime | 0 | No | No | No | |
| LV_SPMOUT | datetime | 0 | No | No | No | |
| LV_TYPE | varchar | 25 | No | No | No | |
| LV_OPTN | varchar | 25 | No | No | No | |
| LV_APHRS | double | 15,2 | No | No | No | |
| LV_PDHRS | double | 15,2 | No | No | No | |
| LV_USER | varchar | 25 | No | No | No | |
| LV_ENCD | datetime | 0 | No | No | No | |
| LV_APP | varchar | 1 | No | No | No | |
| LV_REMK | longtext | 0 | No | No | No | |
| LV_FLAG | varchar | 1 | No | No | No | |
mhr_2015
| mhr_2015 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| MHRNUMB | varchar | 25 | No | No | No | |
| MHRCDTE | date | 0 | No | No | No | |
| MHRTRDY | double | 15,2 | No | No | No | |
| MHRUTME | double | 15,2 | No | No | No | |
| MHRSLLV | double | 15,2 | No | No | No | |
| MHRVLLV | double | 15,2 | No | No | No | |
| MHRULOA | double | 15,2 | No | No | No | |
| MHRWOLV | double | 15,2 | No | No | No | |
| MHRDLOA | double | 15,2 | No | No | No | |
| MHROTHR | double | 15,2 | No | No | No | |
| MHRDAYS | double | 15,2 | No | No | No | |
| MHRCOCD | varchar | 25 | No | No | No | |
| MHRDPCD | varchar | 25 | No | No | No | |
| MHRDPCD_FLAG | varchar | 25 | No | No | No | |
| MHRRATEC | varchar | 25 | No | No | No | |
| MHRPYTYPE | varchar | 1 | No | No | No | |
| MHRTXTYPE | varchar | 1 | No | No | No | |
| MHRDEFDAYS | double | 15,2 | No | No | No | |
| MHRDEFMO | varchar | 2 | No | No | No | |
| MHRDEFCMO | varchar | 1 | No | No | No | |
| MHRDEFHRS | double | 15,2 | No | No | No | |
| MHRESCD | varchar | 1 | No | No | No | |
| MHRRRD1 | double | 15,2 | No | No | No | |
| MHRRRO1 | double | 15,2 | No | No | No | |
| MHRNRD1 | double | 15,2 | No | No | No | |
| MHRNRO1 | double | 15,2 | No | No | No | |
| MHRRRD2 | double | 15,2 | No | No | No | |
| MHRRRO2 | double | 15,2 | No | No | No | |
| MHRNRO2 | double | 15,2 | No | No | No | |
| MHRRSD1 | double | 15,2 | No | No | No | |
| MHRRSO1 | double | 15,2 | No | No | No | |
| MHRNSD1 | double | 15,2 | No | No | No | |
| MHRRSD2 | double | 15,2 | No | No | No | |
| MHRRSO2 | double | 15,2 | No | No | No | |
| MHRNSO1 | double | 15,2 | No | No | No | |
| MHRNSD2 | double | 15,2 | No | No | No | |
| MHRNSO2 | double | 15,2 | No | No | No | |
| MHRRLD1 | double | 15,2 | No | No | No | |
| MHRRLO1 | double | 15,2 | No | No | No | |
| MHRNLD1 | double | 15,2 | No | No | No | |
| MHRRLD2 | double | 15,2 | No | No | No | |
| MHRRLO2 | double | 15,2 | No | No | No | |
| MHRNLO1 | double | 15,2 | No | No | No | |
| MHRNLD2 | double | 15,2 | No | No | No | |
| MHRNLO2 | double | 15,2 | No | No | No | |
| MHRNRD2 | double | 15,2 | No | No | No | |
| MHRLHOL | double | 15,2 | No | No | No | |
| MHRSHOL | double | 15,2 | No | No | No | |
| MHRTHOL | double | 15,2 | No | No | No | |
| MHRRLEG | double | 15,2 | No | No | No | |
| MHRRSPC | double | 15,2 | No | No | No | |
| MHRFPER | varchar | 1 | No | No | No | |
| MHRADSL | double | 15,2 | No | No | No | |
| MHRADVL | double | 15,2 | No | No | No | |
| MHRDDSL | double | 15,2 | No | No | No | |
| MHRDDVL | double | 15,2 | No | No | No | |
| MHRADFL | double | 15,2 | No | No | No | |
| MHRSPLLV | double | 15,2 | No | No | No | |
| MHRLCCD | varchar | 25 | No | No | No | |
| MHRTDPD | varchar | 25 | No | No | No | |
mhr_2016
| mhr_2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| MHRNUMB | varchar | 25 | No | No | No | |
| MHRCDTE | date | 0 | No | No | No | |
| MHRTRDY | double | 15,2 | No | No | No | |
| MHRUTME | double | 15,2 | No | No | No | |
| MHRSLLV | double | 15,2 | No | No | No | |
| MHRVLLV | double | 15,2 | No | No | No | |
| MHRULOA | double | 15,2 | No | No | No | |
| MHRWOLV | double | 15,2 | No | No | No | |
| MHRDLOA | double | 15,2 | No | No | No | |
| MHROTHR | double | 15,2 | No | No | No | |
| MHRDAYS | double | 15,2 | No | No | No | |
| MHRCOCD | varchar | 25 | No | No | No | |
| MHRDPCD | varchar | 25 | No | No | No | |
| MHRDPCD_FLAG | varchar | 25 | No | No | No | |
| MHRRATEC | varchar | 25 | No | No | No | |
| MHRPYTYPE | varchar | 1 | No | No | No | |
| MHRTXTYPE | varchar | 1 | No | No | No | |
| MHRDEFDAYS | double | 15,2 | No | No | No | |
| MHRDEFMO | varchar | 2 | No | No | No | |
| MHRDEFCMO | varchar | 1 | No | No | No | |
| MHRDEFHRS | double | 15,2 | No | No | No | |
| MHRESCD | varchar | 1 | No | No | No | |
| MHRRRD1 | double | 15,2 | No | No | No | |
| MHRRRO1 | double | 15,2 | No | No | No | |
| MHRNRD1 | double | 15,2 | No | No | No | |
| MHRNRO1 | double | 15,2 | No | No | No | |
| MHRRRD2 | double | 15,2 | No | No | No | |
| MHRRRO2 | double | 15,2 | No | No | No | |
| MHRNRO2 | double | 15,2 | No | No | No | |
| MHRRSD1 | double | 15,2 | No | No | No | |
| MHRRSO1 | double | 15,2 | No | No | No | |
| MHRNSD1 | double | 15,2 | No | No | No | |
| MHRRSD2 | double | 15,2 | No | No | No | |
| MHRRSO2 | double | 15,2 | No | No | No | |
| MHRNSO1 | double | 15,2 | No | No | No | |
| MHRNSD2 | double | 15,2 | No | No | No | |
| MHRNSO2 | double | 15,2 | No | No | No | |
| MHRRLD1 | double | 15,2 | No | No | No | |
| MHRRLO1 | double | 15,2 | No | No | No | |
| MHRNLD1 | double | 15,2 | No | No | No | |
| MHRRLD2 | double | 15,2 | No | No | No | |
| MHRRLO2 | double | 15,2 | No | No | No | |
| MHRNLO1 | double | 15,2 | No | No | No | |
| MHRNLD2 | double | 15,2 | No | No | No | |
| MHRNLO2 | double | 15,2 | No | No | No | |
| MHRNRD2 | double | 15,2 | No | No | No | |
| MHRLHOL | double | 15,2 | No | No | No | |
| MHRSHOL | double | 15,2 | No | No | No | |
| MHRTHOL | double | 15,2 | No | No | No | |
| MHRRLEG | double | 15,2 | No | No | No | |
| MHRRSPC | double | 15,2 | No | No | No | |
| MHRFPER | varchar | 1 | No | No | No | |
| MHRADSL | double | 15,2 | No | No | No | |
| MHRADVL | double | 15,2 | No | No | No | |
| MHRDDSL | double | 15,2 | No | No | No | |
| MHRDDVL | double | 15,2 | No | No | No | |
| MHRADFL | double | 15,2 | No | No | No | |
| MHRSPLLV | double | 15,2 | No | No | No | |
| MHRLCCD | varchar | 25 | No | No | No | |
| MHRTDPD | varchar | 25 | No | No | No | |
mst_attlogs
| mst_attlogs | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| FP_ID | varchar | 25 | No | No | No | |
| FP_TRXDATE | datetime | 0 | No | No | No | |
| FP_SITE | varchar | 25 | No | No | No | |
| MYF3 | varchar | 1 | No | No | No | |
| FP_INOUT | varchar | 1 | No | No | No | |
| MYF5 | varchar | 1 | No | No | No | |
| MYF6 | varchar | 1 | No | No | No | |
| FP_IDNO | varchar | 25 | No | No | No | |
| FP_EMPNAME | varchar | 200 | No | No | No | |
| FP_DPCD | varchar | 25 | No | No | No | |
| FP_COCD | varchar | 25 | No | No | No | |
| FP_LCCD | varchar | 25 | No | No | No | |
| FP_USER | varchar | 25 | No | No | No | |
| FP_DTEUP | datetime | 0 | No | No | No | |
obtp2015
| obtp2015 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| OB_ENUMB | varchar | 25 | No | No | No | |
| OB_WS_CODE | varchar | 25 | No | No | No | |
| OB_DYCODE | varchar | 3 | No | No | No | |
| OB_DYTYPE | varchar | 25 | No | No | No | |
| OB_LCCD | varchar | 25 | No | No | No | |
| OB_DPCD | varchar | 25 | No | No | No | |
| OB_COCD | varchar | 25 | No | No | No | |
| OB_CDTE | varchar | 0 | No | No | No | |
| FP_DPCD | date | 0 | No | No | No | |
| OB_DTETRX | date | 0 | No | No | No | |
| OB_SAMIN | datetime | 0 | No | No | No | |
| OB_SAMOUT | datetime | 0 | No | No | No | |
| OB_SPMIN | datetime | 0 | No | No | No | |
| OB_SPMOUT | datetime | 0 | No | No | No | |
| OB_ATIME | datetime | 0 | No | No | No | |
| OB_DTIME | datetime | 0 | No | No | No | |
| OB_USER | varchar | 25 | No | No | No | |
| OB_ENCD | datetime | 0 | No | No | No | |
| OB_REMK | longtext | 0 | No | No | No | |
| OB_FLAG | varchar | 1 | No | No | No | |
obtp2016
| obtp2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| OB_ENUMB | varchar | 25 | No | No | No | |
| OB_WS_CODE | varchar | 25 | No | No | No | |
| OB_DYCODE | varchar | 3 | No | No | No | |
| OB_DYTYPE | varchar | 25 | No | No | No | |
| OB_LCCD | varchar | 25 | No | No | No | |
| OB_DPCD | varchar | 25 | No | No | No | |
| OB_COCD | varchar | 25 | No | No | No | |
| OB_CDTE | varchar | 0 | No | No | No | |
| FP_DPCD | date | 0 | No | No | No | |
| OB_DTETRX | date | 0 | No | No | No | |
| OB_SAMIN | datetime | 0 | No | No | No | |
| OB_SAMOUT | datetime | 0 | No | No | No | |
| OB_SPMIN | datetime | 0 | No | No | No | |
| OB_SPMOUT | datetime | 0 | No | No | No | |
| OB_ATIME | datetime | 0 | No | No | No | |
| OB_DTIME | datetime | 0 | No | No | No | |
| OB_USER | varchar | 25 | No | No | No | |
| OB_ENCD | datetime | 0 | No | No | No | |
| OB_REMK | longtext | 0 | No | No | No | |
| OB_FLAG | varchar | 1 | No | No | No | |
otdt2015
| otdt2015 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| OB_ENUMB | varchar | 25 | No | No | No | |
| OB_WS_CODE | varchar | 25 | No | No | No | |
| OB_DYCODE | varchar | 3 | No | No | No | |
| OB_DYTYPE | varchar | 25 | No | No | No | |
| OB_LCCD | varchar | 25 | No | No | No | |
| OB_DPCD | varchar | 25 | No | No | No | |
| OB_COCD | varchar | 25 | No | No | No | |
| OB_CDTE | varchar | 0 | No | No | No | |
| FP_DPCD | date | 0 | No | No | No | |
| OB_DTETRX | date | 0 | No | No | No | |
| OB_SAMIN | datetime | 0 | No | No | No | |
| OB_SAMOUT | datetime | 0 | No | No | No | |
| OB_SPMIN | datetime | 0 | No | No | No | |
| OB_SPMOUT | datetime | 0 | No | No | No | |
| OB_STIME | datetime | 0 | No | No | No | |
| OB_ETIME | datetime | 0 | No | No | No | |
| OB_USER | varchar | 25 | No | No | No | |
| OB_ENCD | datetime | 0 | No | No | No | |
| OB_REMK | longtext | 0 | No | No | No | |
| OB_FLAG | varchar | 1 | No | No | No | |
otdt2016
| otdt2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| OB_ENUMB | varchar | 25 | No | No | No | |
| OB_WS_CODE | varchar | 25 | No | No | No | |
| OB_DYCODE | varchar | 3 | No | No | No | |
| OB_DYTYPE | varchar | 25 | No | No | No | |
| OB_LCCD | varchar | 25 | No | No | No | |
| OB_DPCD | varchar | 25 | No | No | No | |
| OB_COCD | varchar | 25 | No | No | No | |
| OB_CDTE | varchar | 0 | No | No | No | |
| FP_DPCD | date | 0 | No | No | No | |
| OB_DTETRX | date | 0 | No | No | No | |
| OB_SAMIN | datetime | 0 | No | No | No | |
| OB_SAMOUT | datetime | 0 | No | No | No | |
| OB_SPMIN | datetime | 0 | No | No | No | |
| OB_SPMOUT | datetime | 0 | No | No | No | |
| OB_STIME | datetime | 0 | No | No | No | |
| OB_ETIME | datetime | 0 | No | No | No | |
| OB_USER | varchar | 25 | No | No | No | |
| OB_ENCD | datetime | 0 | No | No | No | |
| OB_REMK | longtext | 0 | No | No | No | |
| OB_FLAG | varchar | 1 | No | No | No | |
otpay2015
| otpay2015 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | No | |
| OTP_EMPNUMB | varchar | 25 | No | No | No | |
| OTP_CDTE | date | 0 | No | No | No | |
| OTP_TFDATE | date | 0 | No | No | No | |
| OTP_TTDATE | date | 0 | No | No | No | |
| OTP_HRS | double | 10,2 | No | No | No | |
| OTP_MNS | double | 10,2 | No | No | No | |
| OTP_CODE | varchar | 25 | No | No | No | |
| OTP_COCD | varchar | 25 | No | No | No | |
| OTP_RATE | double | 10,3 | No | No | No | |
| OTP_RALLO | double | 10,3 | No | No | No | |
| OTP_AMT_RATE | double | 10,3 | No | No | No | |
| OTP_REFC | varchar | 60 | No | No | No | |
| OTP_ED_CODE | varchar | 25 | No | No | No | |
| OTP_PCMP_GRP_CODE | varchar | 25 | No | No | No | |
| OTP_DPCD | varchar | 25 | No | No | No | |
| OTP_DPCD_FLAG | varchar | 25 | No | No | No | |
| OTP_RATEC | varchar | 25 | No | No | No | |
| OTP_PYTYPE | varchar | 1 | No | No | No | |
| OTP_TXTYPE | varchar | 1 | No | No | No | |
| OTP_MFIELD | varchar | 25 | No | No | No | |
| OTP_DEFDAYS | double | 15,2 | No | No | No | |
| OTP_DEFMO | varchar | 2 | No | No | No | |
| OTP_DEFCMO | varchar | 1 | No | No | No | |
| OTP_DEFHRS | double | 15,2 | No | No | No | |
| OTP_PMRK | varchar | 1 | No | No | No | |
| OT_SFLAG | varchar | 1 | No | No | No | |
| OT_APPROVED | varchar | 1 | No | No | No | |
otpay2016
| otpay2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | No | |
| OTP_EMPNUMB | varchar | 25 | No | No | No | |
| OTP_CDTE | date | 0 | No | No | No | |
| OTP_TFDATE | date | 0 | No | No | No | |
| OTP_TTDATE | date | 0 | No | No | No | |
| OTP_HRS | double | 10,2 | No | No | No | |
| OTP_MNS | double | 10,2 | No | No | No | |
| OTP_CODE | varchar | 25 | No | No | No | |
| OTP_COCD | varchar | 25 | No | No | No | |
| OTP_RATE | double | 10,3 | No | No | No | |
| OTP_RALLO | double | 10,3 | No | No | No | |
| OTP_AMT_RATE | double | 10,3 | No | No | No | |
| OTP_REFC | varchar | 60 | No | No | No | |
| OTP_ED_CODE | varchar | 25 | No | No | No | |
| OTP_PCMP_GRP_CODE | varchar | 25 | No | No | No | |
| OTP_DPCD | varchar | 25 | No | No | No | |
| OTP_DPCD_FLAG | varchar | 25 | No | No | No | |
| OTP_RATEC | varchar | 25 | No | No | No | |
| OTP_PYTYPE | varchar | 1 | No | No | No | |
| OTP_TXTYPE | varchar | 1 | No | No | No | |
| OTP_MFIELD | varchar | 25 | No | No | No | |
| OTP_DEFDAYS | double | 15,2 | No | No | No | |
| OTP_DEFMO | varchar | 2 | No | No | No | |
| OTP_DEFCMO | varchar | 1 | No | No | No | |
| OTP_DEFHRS | double | 15,2 | No | No | No | |
| OTP_PMRK | varchar | 1 | No | No | No | |
| OT_SFLAG | varchar | 1 | No | No | No | |
| OT_APPROVED | varchar | 1 | No | No | No | |
pmt_ctr_no
| pmt_ctr_no | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| empnumb_ctr | varchar | 15 | No | No | No | |
| empnumb_year | varchar | 4 | No | No | No | |
posting_logs
| posting_logs | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| COMPANY | varchar | 25 | No | No | No | |
| SITE | varchar | 25 | No | No | No | |
| PCLASS | varchar | 25 | No | No | No | |
| MODULE | varchar | 60 | No | No | No | |
| MPERIOD | date | 0 | No | No | No | |
| DATEP | datetime | 25 | No | No | No | |
| USERN | varchar | 25 | No | No | No | |
undt2015
| undt2015 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| OB_ENUMB | varchar | 25 | No | No | No | |
| OB_WS_CODE | varchar | 25 | No | No | No | |
| OB_DYCODE | varchar | 3 | No | No | No | |
| OB_DYTYPE | varchar | 25 | No | No | No | |
| OB_LCCD | varchar | 25 | No | No | No | |
| OB_DPCD | varchar | 25 | No | No | No | |
| OB_COCD | varchar | 25 | No | No | No | |
| OB_CDTE | varchar | 0 | No | No | No | |
| FP_DPCD | date | 0 | No | No | No | |
| OB_DTETRX | date | 0 | No | No | No | |
| OB_SAMIN | datetime | 0 | No | No | No | |
| OB_SAMOUT | datetime | 0 | No | No | No | |
| OB_SPMIN | datetime | 0 | No | No | No | |
| OB_SPMOUT | datetime | 0 | No | No | No | |
| OB_FTIME | datetime | 0 | No | No | No | |
| OB_TTIME | datetime | 0 | No | No | No | |
| OB_USER | varchar | 25 | No | No | No | |
| OB_ENCD | datetime | 0 | No | No | No | |
| OB_REMK | longtext | 0 | No | No | No | |
| OB_FLAG | varchar | 1 | No | No | No | |
undt2016
| undt2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| OB_ENUMB | varchar | 25 | No | No | No | |
| OB_WS_CODE | varchar | 25 | No | No | No | |
| OB_DYCODE | varchar | 3 | No | No | No | |
| OB_DYTYPE | varchar | 25 | No | No | No | |
| OB_LCCD | varchar | 25 | No | No | No | |
| OB_DPCD | varchar | 25 | No | No | No | |
| OB_COCD | varchar | 25 | No | No | No | |
| OB_CDTE | varchar | 0 | No | No | No | |
| FP_DPCD | date | 0 | No | No | No | |
| OB_DTETRX | date | 0 | No | No | No | |
| OB_SAMIN | datetime | 0 | No | No | No | |
| OB_SAMOUT | datetime | 0 | No | No | No | |
| OB_SPMIN | datetime | 0 | No | No | No | |
| OB_SPMOUT | datetime | 0 | No | No | No | |
| OB_FTIME | datetime | 0 | No | No | No | |
| OB_TTIME | datetime | 0 | No | No | No | |
| OB_USER | varchar | 25 | No | No | No | |
| OB_ENCD | datetime | 0 | No | No | No | |
| OB_REMK | longtext | 0 | No | No | No | |
| OB_FLAG | varchar | 1 | No | No | No | |
