Difference between revisions of "Itk"

From SPGC Document Wiki
Jump to: navigation, search
(→‎employee)
Line 2,894: Line 2,894:
 
|datetime
 
|datetime
 
|0
 
|0
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==lvdt2015==
 +
{| class="wikitable" \
 +
!colspan="7" | lvdt2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | lvdt2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | mhr_2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | mhr_2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | mst_attlogs
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | obtp2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | obtp2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | otdt2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | otdt2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | otpay2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | otpay2016
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | pmt_ctr_no
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | posting_logs
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | undt2015
 +
|-
 +
! style="text-align:left;" | 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==
 +
{| class="wikitable" \
 +
!colspan="7" | undt2016
 +
|-
 +
! style="text-align:left;" | 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
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 09:33, 10 August 2016

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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Itk&oldid=2819"