Difference between revisions of "Mypmsdb"
From SPGC Document Wiki
(→pmmloca) |
|||
| Line 7,058: | Line 7,058: | ||
{| class="wikitable" \ | {| class="wikitable" \ | ||
!colspan="7" | pmmloca | !colspan="7" | pmmloca | ||
| + | |- | ||
| + | ! style="text-align:left;" | Column Name | ||
| + | ! Data Type | ||
| + | ! Length | ||
| + | ! Is PrimaryKey | ||
| + | ! Is Not Null | ||
| + | ! Auto Increment | ||
| + | |- | ||
| + | |LOCCODE | ||
| + | |varchar | ||
| + | |3 | ||
| + | |No | ||
| + | |No | ||
| + | |No | ||
| + | |- | ||
| + | |LOCDESC | ||
| + | |varchar | ||
| + | |20 | ||
| + | |No | ||
| + | |No | ||
| + | |No | ||
| + | |} | ||
| + | |||
| + | ==pmmmach== | ||
| + | {| class="wikitable" \ | ||
| + | !colspan="7" | pmmmach | ||
|- | |- | ||
! style="text-align:left;" | Column Name | ! style="text-align:left;" | Column Name | ||
Revision as of 08:46, 8 July 2016
Contents
- 1 ahs2016
- 2 alphalist_log
- 3 auditlogs
- 4 bse2016
- 5 bsm2016
- 6 bsw_2016sppe
- 7 cm2016
- 8 cw2016
- 9 cws2016
- 10 dailymhr2016
- 11 dt2016
- 12 dtr2016
- 13 dtt2016
- 14 dw2016
- 15 emphold_alogs
- 16 fp_id
- 17 fpid
- 18 hst2016
- 19 ins2016
- 20 lns2016
- 21 lv2016
- 22 lvdt2016
- 23 lw2016
- 24 mbtc_cc
- 25 mbtc_log
- 26 mbtc_outc
- 27 mfileuploaded
- 28 mhr_2016
- 29 mhw2016
- 30 mst_attlogs
- 31 mst_cost_center
- 32 mst_cost_center_555
- 33 mst_ctr_no
- 34 mst_diocese
- 35 mst_gl_555
- 36 mst_mission
- 37 mst_educatt
- 38 mst_nationality
- 39 mst_relivows
- 40 my_ctr_no
- 41 mybpibadv
- 42 ob2016
- 43 obtp2016
- 44 ok2016
- 45 ot2016
- 46 otdt2016
- 47 otpay2016
- 48 ow2016
- 49 pdm_essi2016
- 50 pdm_sppe2016
- 51 pdm2016
- 52 pdw_sppe2016
- 53 pdw2016
- 54 pmhempl
- 55 pmmcmpy
- 56 pmmacin
- 57 pmmbene
- 58 pmmcsta
- 59 pmmctzp
- 60 pmmdept
- 61 pmmicls
- 62 pmmjblv
- 63 pmmlnge
- 64 pmmloca
- 65 pmmmach
ahs2016
| ahs2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| AHSNUMB | Varchar | 15 | No | No | No | |
| AHSGPAY | double | 15,2 | No | No | No | |
| AHSALLO | double | 15,2 | No | No | No | |
| AHS13MO | double | 15,2 | No | No | No | |
| AHSSLVL | double | 15,2 | No | No | No | |
| AHSSVLR | double | 15,2 | No | No | No | |
| AHSBONS | double | 15,2 | No | No | No | |
| AHSTAXD | double | 15,2 | No | No | No | |
| AHSTAXW | double | 15,2 | No | No | No | |
alphalist_log
| alphalist_log | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | No | No | |
| EMPLNAM | varchar | 30 | No | No | No | |
| EMPFNAM | varchar | 30 | No | No | No | |
| EMPMNAM | varchar | 30 | No | No | No | |
| EMPTINO | varchar | 30 | No | No | No | |
| EMPTXCD | varchar | 2 | No | No | No | |
| EMPTAXEXEM | double | 15,2 | No | No | No | |
| EMPHDTE | date | 0 | No | No | No | |
| SEPDATE | date | 0 | No | No | No | |
| EMPBDTE | date | 0 | No | No | No | |
| EMP13TH | double | 15,2 | No | No | No | |
| EMPSLPY | double | 15,2 | No | No | No | |
| EMPUNION | double | 15,2 | No | No | No | |
| EMPAMEDE | double | 15,2 | No | No | No | |
| EMPASSSE | double | 15,2 | No | No | No | |
| EMPAGROSS | double | 15,2 | No | No | No | |
| EMPAPIBE | double | 15,2 | No | No | No | |
| EMPATAXC | double | 15,2 | No | No | No | |
| EMPATAXCDEC | double | 15,2 | No | No | No | |
| EMPSEPA | varchar | 1 | No | No | No | |
| EMPCLASSM | varchar | 10 | No | No | No | |
| TXYMNGR | double | 15,2 | No | No | No | |
| TXYTXRT | double | 15,2 | No | No | No | |
| TXYTXAD | double | 15,2 | No | No | No | |
| TAXI | double | 15,2 | No | No | No | |
| TAXEXEM | double | 15,2 | No | No | No | |
| GOV_CONTRIB | double | 19,2 | No | No | No | |
| EMPBPAY | double | 15,2 | No | No | No | |
| EMPBALL | double | 15,2 | No | No | No | |
| TAXDUE | double | 15,2 | No | No | No | |
| EMPDPCD | varchar | 30 | No | No | No | |
| EMP13THTAX | double | 15,2 | No | No | No | |
| MWE | varchar | 1 | No | No | No | |
| MWESAL | double | 19,2 | No | Yes | No | |
| _dateproc | datetime | 0 | No | Yes | No | |
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_DATE | date | 0 | No | No | No | |
| LOG_TBL | varchar | 20 | No | No | No | |
| LOG_KEYREC | varchar | 10 | No | No | No | |
| LOG_TIME | varchar | 10 | No | No | No | |
| LOG_ENUMB | varchar | 15 | No | No | No | |
| LOG_FIELD | varchar | 20 | No | No | No | |
| LOG_OLDVAL | varchar | 30 | No | No | No | |
| LOG_NEWVAL | varchar | 30 | No | No | No | |
| LOG_CHANGE | varchar | 1 | No | No | No | |
| LOG_IPADDR | varchar | 20 | No | No | No | |
| LOG_PRNT | varchar | 1 | No | No | No | |
| LOG_SQLEXEC | longtext | 0 | No | No | No | |
bse2016
| bse2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | No | No | |
| EMP13MO | double | 15,2 | No | No | No | |
| EMPSLPY | double | 15,2 | No | No | No | |
| EMPVLPY | double | 15,2 | No | No | No | |
| EMPLPAY | double | 15,2 | No | No | No | |
| EMPBONS | double | 15,2 | No | No | No | |
| EMPGPAY | double | 15,2 | No | No | No | |
| EMPBPAY | double | 15,2 | No | No | No | |
| EMPLNAM | varchar | 30 | No | No | No | |
| EMPFNAM | varchar | 30 | No | No | No | |
| EMPMNAM | varchar | 30 | No | No | No | |
| EMPCOCD | varchar | 1 | No | No | No | |
| EMPPCCD | varchar | 1 | No | No | No | |
| EMPLCCD | varchar | 3 | No | No | No | |
| EMPDPCD | varchar | 10 | No | No | No | |
| EMPFDSL | double | 15,2 | No | No | No | |
| EMPFDVL | double | 15,2 | No | No | No | |
| EMPSLRE | double | 15,2 | No | No | No | |
| EMPVLRE | double | 15,2 | No | No | No | |
| EMPESCD | varchar | 1 | No | No | No | |
| EMPPMCD | varchar | 1 | No | No | No | |
| EMPSTAT | varchar | 1 | No | No | No | |
| EMPPYNO | varchar | 10 | No | No | No | |
| EMPHDTE | date | 0 | No | No | No | |
| EMPCTAG | varchar | 1 | No | No | No | |
| EMPBKCD | varchar | 5 | No | No | No | |
bsm2016
| bsm2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | No | No | |
| EMP13MO | double | 15,2 | No | No | No | |
| EMPSLPY | double | 15,2 | No | No | No | |
| EMPVLPY | double | 15,2 | No | No | No | |
| EMPLPAY | double | 15,2 | No | No | No | |
| EMPBONS | double | 15,2 | No | No | No | |
| EMPGPAY | double | 15,2 | No | No | No | |
| EMPBPAY | double | 15,2 | No | No | No | |
| EMPLNAM | varchar | 30 | No | No | No | |
| EMPFNAM | varchar | 30 | No | No | No | |
| EMPMNAM | varchar | 30 | No | No | No | |
| EMPCOCD | varchar | 1 | No | No | No | |
| EMPPCCD | varchar | 1 | No | No | No | |
| EMPLCCD | varchar | 3 | No | No | No | |
| EMPDPCD | varchar | 10 | No | No | No | |
| EMPFDSL | double | 15,2 | No | No | No | |
| EMPFDVL | double | 15,2 | No | No | No | |
| EMPSLRE | double | 15,2 | No | No | No | |
| EMPVLRE | double | 15,2 | No | No | No | |
| EMPESCD | varchar | 1 | No | No | No | |
| EMPPMCD | varchar | 1 | No | No | No | |
| EMPSTAT | varchar | 1 | No | No | No | |
| EMPPYNO | varchar | 10 | No | No | No | |
| EMPHDTE | date | 0 | No | No | No | |
| EMPCTAG | varchar | 1 | No | No | No | |
| EMPBKCD | varchar | 5 | No | No | No | |
bsw_2016sppe
| bsw_2016sppe | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| HSTNUMB | varchar | 15 | No | No | No | |
| EMPNAME | varchar | 150 | No | No | No | |
| EMPCOCD | varchar | 1 | No | No | No | |
| HDTE | date | 0 | No | No | No | |
| ESCD | varchar | 1 | No | No | No | |
| TBASIC | double | 15,2 | No | No | No | |
| MMO | double | 15,2 | No | No | No | |
| 13MO | double | 15,2 | No | No | No | |
| SL_PAY | double | 15,2 | No | No | No | |
| COMPNAME | varchar | 60 | No | No | No | |
| DEPT | varchar | 10 | No | No | No | |
| PCCD | varchar | 1 | No | No | No | |
| LOCA | varchar | 3 | No | No | No | |
| DEPTNAME | varchar | 60 | No | No | No | |
| EMPLNAM | varchar | 50 | No | No | No | |
| EMPFNAM | varchar | 50 | No | No | No | |
| EMPMNAM | varchar | 1 | No | No | No | |
| EMPPMCD | varchar | 1 | No | No | No | |
| EMPSTAT | varchar | 1 | No | No | No | |
| EMPBKCD | varchar | 5 | No | No | No | |
| EMPATMP | varchar | 25 | No | No | No | |
| SVLSLEN | double | 15,2 | No | No | No | |
| SLREM | double | 15,2 | No | No | No | |
| SVLVLEN | double | 15,2 | No | No | No | |
| VLREM | double | 15,2 | No | No | No | |
| DAILYTAG | varchar | 1 | No | No | No | |
cm2016
| cm2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CWMNUMB | varchar | 15 | No | No | No | |
| CWMDATE | datetime | 0 | No | No | No | |
| CWMFSTM | varchar | 4 | No | No | No | |
| CWMESTM | varchar | 4 | No | No | No | |
| CWMSTME | varchar | 4 | No | No | No | |
| CWMETME | varchar | 4 | No | No | No | |
| CWMATAG | varchar | 1 | No | No | No | |
| CWMSFCD | varchar | 2 | No | No | No | |
cw2016
| cw2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CWMNUMB | varchar | 15 | No | No | No | |
| CWMDATE | datetime | 0 | No | No | No | |
| CWMFSTM | varchar | 4 | No | No | No | |
| CWMESTM | varchar | 4 | No | No | No | |
| CWMSTME | varchar | 4 | No | No | No | |
| CWMETME | varchar | 4 | No | No | No | |
| CWMATAG | varchar | 1 | No | No | No | |
| CWMSFCD | varchar | 2 | No | No | No | |
cws2016
| cws2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CWSNUMB | varchar | 15 | No | No | No | |
| CWSDATE | datetime | 0 | No | No | No | |
| CWSFSTM | varchar | 4 | No | No | No | |
| CWSESTM | varchar | 4 | No | No | No | |
| CWSSTME | varchar | 4 | No | No | No | |
| CWSETME | varchar | 4 | No | No | No | |
| CWSATAG | varchar | 1 | No | No | No | |
| CWSSFCD | varchar | 3 | 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 | |
| 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 | 50 | 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 | |
dt2016
| dt2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| DTRNUMB | varchar | 15 | No | No | No | |
| DTRUSER | varchar | 10 | No | No | No | |
| DTRDATE | datetime | 0 | No | No | No | |
| DTRAMIN | varchar | 4 | No | No | No | |
| DTRAMOT | varchar | 4 | No | No | No | |
| DTRPMIN | varchar | 4 | No | No | No | |
| DTRPMOT | varchar | 4 | No | No | No | |
| DTR_AMI | varchar | 4 | No | No | No | |
| DTR_AMO | varchar | 4 | No | No | No | |
| DTR_PMI | varchar | 4 | No | No | No | |
| DTR_PMO | varchar | 4 | No | No | No | |
| DTRSFCD | varchar | 3 | No | No | No | |
dtr2016
| dtr2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| DTRCODE | varchar | 3 | No | No | No | |
| DTRDATE | varchar | 6 | No | No | No | |
| DTRTIME | varchar | 4 | No | No | No | |
| DTRTMP1 | varchar | 2 | No | No | No | |
| DTRSHFT | varchar | 1 | No | No | No | |
| DTRCRNO | varchar | 12 | No | No | No | |
| DTRREMK | varchar | 1 | No | No | No | |
| DTRDATETIME | datetime | 0 | 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_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 | 0 | 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 | |
dw2016
| dw2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| DTWNUMB | varchar | 15 | No | No | No | |
| DTWUSER | varchar | 8 | No | No | No | |
| DTWDATE | datetime | 0 | No | No | No | |
| DTWAMIN | varchar | 4 | No | No | No | |
| DTWAMOT | varchar | 4 | No | No | No | |
| DTWPMIN | varchar | 4 | No | No | No | |
| DTWPMOT | varchar | 4 | No | No | No | |
| DTW_AMI | varchar | 4 | No | No | No | |
| DTW_AMO | varchar | 4 | No | No | No | |
| DTW_PMI | varchar | 4 | No | No | No | |
| DTW_PMO | varchar | 4 | No | No | No | |
| DTWSFCD | varchar | 2 | No | No | No | |
emphold_alogs
| emphold_alogs | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| HOLDRSN | varchar | 200 | No | Yes | No | |
| USERNAME | varchar | 20 | No | Yes | No | |
| TMPSTMP | datetime | 0 | No | Yes | No | |
fp_id
| fp_id | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| FPIDENUMB | varchar | 25 | No | No | No | |
| FPID | varchar | 25 | No | No | No | |
| FPLCCD | varchar | 25 | No | No | No | |
fpid
| fpid | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| FPENUMB | varchar | 15 | Yes | Yes | Yes | |
| FPID | varchar | 12 | No | No | No | |
| FPREMK | varchar | 1 | No | No | No | |
hst2016
| hst2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| HSTNUMB | varchar | 15 | Yes | Yes | Yes | |
| HSTCDTE | datetime | 0 | No | No | No | |
| HSTMPAY | double | 15,2 | No | No | No | |
| HSTMALL | double | 15,2 | No | No | No | |
| HSTBPAY | double | 15,2 | No | No | No | |
| HSTBALL | double | 15,2 | No | No | No | |
| HSTGPAY | double | 15,2 | No | No | No | |
| HSTSSSR | double | 15,2 | No | No | No | |
| HSTSSSE | double | 15,2 | No | No | No | |
| HSTTAXC | double | 15,2 | No | No | No | |
| HSTECCM | double | 15,2 | No | No | No | |
| HSTPIBE | double | 15,2 | No | No | No | |
| HSTPIBR | double | 15,2 | No | No | No | |
| HSTMEDE | double | 15,2 | No | No | No | |
| HSTMEDR | double | 15,2 | No | No | No | |
| HSTTDED | double | 15,2 | No | No | No | |
| HSTADON | double | 15,2 | No | No | No | |
| HSTNSPY | double | 15,2 | No | No | No | |
| HSTOTNS | double | 15,2 | No | No | No | |
| HSTOTPY | double | 15,2 | No | No | No | |
| HSTSLPY | double | 15,2 | No | No | No | |
| HSTVLPY | double | 15,2 | No | No | No | |
| HSTDOPY | double | 15,2 | No | No | No | |
| HSTLHPY | double | 15,2 | No | No | No | |
| HSTSHPY | double | 15,2 | No | No | No | |
| HSTCOFF | varchar | 3 | No | No | No | |
| HSTCOCD | varchar | 1 | No | No | No | |
| HSTPCCD | varchar | 1 | No | No | No | |
| HSTHOLD | varchar | 1 | No | No | No | |
| HSTPYNO | varchar | 9 | No | No | No | |
| HSTDPCD | varchar | 10 | No | No | No | |
| HSTLCCD | varchar | 3 | No | No | No | |
| HSTPMCD | varchar | 1 | No | No | No | |
| HSTPSNO | varchar | 1 | No | No | No | |
| HSTBKCD | varchar | 5 | No | No | No | |
| HSTESCD | varchar | 1 | No | No | No | |
| HSTFLPY | double | 15,2 | No | No | No | |
| HSTTDPD | varchar | 1 | No | No | No | |
ins2016
| ins2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| INSNUMB | varchar | 15 | Yes | Yes | Yes | |
| INSYEAR | varchar | 4 | No | No | No | |
| INSMNTH | varchar | 2 | No | No | No | |
| INSAMNT | double | 15,2 | No | No | No | |
lns2016
| lns2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | No | Yes | Yes | |
| LNSNUMB | varchar | 15 | No | No | No | |
| LNSSDCD | varchar | 3 | No | No | No | |
| LNSDATE | datetime | 0 | No | No | No | |
| LNSDDTE | datetime | 0 | No | No | No | |
| LNSAMNT | double | 15,2 | No | No | No | |
| LNSBALC | double | 15,2 | No | No | No | |
| LNSUNPD | double | 15,2 | No | No | No | |
lv2016
| lv2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LOANUMB | varchar | 15 | No | Yes | Yes | |
| LOADATE | datetime | 0 | No | No | No | |
| LOAOPTN | varchar | 1 | No | No | No | |
| LOACODE | varchar | 1 | No | No | No | |
| LOAHOUR | double | 15,5 | No | No | No | |
| LOAHRPD | double | 15,5 | No | No | No | |
| LOAASTA | tinyint | 1 | No | Yes | No | |
| LOACOFF | date | 0 | No | No | No | |
lvdt2016
| lvdt2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| 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 | 30 | No | No | No | |
| EMPTXCD | 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 | |
lw2016
| lw2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LOWNUMB | varchar | 15 | No | No | No | |
| LOWDATE | datetime | 0 | No | No | No | |
| LOWOPTN | varchar | 1 | No | No | No | |
| LOWCODE | varchar | 1 | No | No | No | |
| LOWHOUR | double | 15,2 | No | No | No | |
| LOWHRPD | double | 15,2 | No | No | No | |
| LOWASTA | tinyint | 1 | No | No | No | |
mbtc_cc
| mbtc_cc | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | No | Yes | Yes | |
| cc_cocd | varchar | 4 | No | No | No | |
| cc_cardno | varchar | 20 | No | No | No | |
| cc_desc | varchar | 50 | No | No | No | |
| cc_accno | varchar | 20 | No | No | No | |
| cc_dbank | varchar | 5 | No | No | No | |
| cc_bankc | varchar | 5 | No | No | No | |
| cc_dup | date | 0 | No | No | No | |
| cc_release | varchar | 1 | No | No | No | |
| cc_drelease | date | 0 | No | No | No | |
| cc_tag | varchar | 1 | No | No | No | |
| cc_dtag | date | 0 | No | No | No | |
| cc_active | varchar | 1 | No | No | No | |
| cc_bankn | varchar | 25 | No | No | No | |
| cc_pmcd | varchar | 1 | No | No | No | |
mbtc_log
| mbtc_log | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| cc_enumb | varchar | 15 | No | No | No | |
| cc_cardno | varchar | 20 | No | No | No | |
| cc_desc | varchar | 50 | No | No | No | |
| cc_accno | varchar | 20 | No | No | No | |
| cc_encdt | datetime | 0 | No | No | No | |
| cc_user | varchar | 10 | No | No | No | |
| cc_cocd | varchar | 4 | No | No | No | |
mbtc_outc
| mbtc_outc | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| cc_outcg | varchar | 10 | No | No | No | |
| cc_accno | varchar | 20 | No | No | No | |
| cc_cocd | varchar | 4 | No | No | No | |
| cc_print | varchar | 1 | No | No | No | |
| cc_bankn | varchar | 25 | No | No | No | |
mfileuploaded
| mfileuploaded | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| mfile | varchar | 50 | No | No | No | |
| mcontent | longtext | 0 | No | No | No | |
| mdateuploaded | datetime | 0 | 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 | |
mhw2016
| mhw2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| MHWNUMB | varchar | 15 | No | No | No | |
| MHWCDTE | datetime | 0 | No | No | No | |
| MHWTRDY | double | 15,2 | No | No | No | |
| MHWUTME | double | 15,2 | No | No | No | |
| MHWSLLV | double | 15,2 | No | No | No | |
| MHWVLLV | double | 15,2 | No | No | No | |
| MHWULOA | double | 15,2 | No | No | No | |
| MHWWOLV | double | 15,2 | No | No | No | |
| MHWDLOA | double | 15,2 | No | No | No | |
| MHWOTHR | double | 15,2 | No | No | No | |
| MHWDAYS | double | 15,2 | No | No | No | |
| MHWESCD | varchar | 1 | No | No | No | |
| MHWRRD1 | double | 15,2 | No | No | No | |
| MHWRRO1 | double | 15,2 | No | No | No | |
| MHWNRD1 | double | 15,2 | No | No | No | |
| MHWNRO1 | double | 15,2 | No | No | No | |
| MHWRRD2 | double | 15,2 | No | No | No | |
| MHWRRO2 | double | 15,2 | No | No | No | |
| MHWNRO2 | double | 15,2 | No | No | No | |
| MHWRSD1 | varchar | 2 | No | No | No | |
| MHWRSO1 | varchar | 1 | No | No | No | |
| MHWRSD2 | double | 15,2 | No | No | No | |
| MHWRSO2 | varchar | 1 | No | No | No | |
| MHWNSO1 | double | 15,2 | No | No | No | |
| MHWNSD2 | double | 15,2 | No | No | No | |
| MHWNSO2 | double | 15,2 | No | No | No | |
| MHWRLD1 | double | 15,2 | No | No | No | |
| MHWRLO1 | double | 15,2 | No | No | No | |
| MHWNLD1 | double | 15,2 | No | No | No | |
| MHWRLD2 | double | 15,2 | No | No | No | |
| MHWRLO2 | double | 15,2 | No | No | No | |
| MHWNLO1 | double | 15,2 | No | No | No | |
| MHWNLD2 | double | 15,2 | No | No | No | |
| MHWNLO2 | double | 15,2 | No | No | No | |
| MHWNRD2 | double | 15,2 | No | No | No | |
| MHWLHOL | double | 15,2 | No | No | No | |
| MHWSHOL | double | 15,2 | No | No | No | |
| MHWTHOL | double | 15,2 | No | No | No | |
| MHWRLEG | double | 15,2 | No | No | No | |
| MHWRSPC | double | 15,2 | No | No | No | |
| MHWFPER | varchar | 1 | No | No | No | |
| MHWADSL | double | 15,2 | No | No | No | |
| MHWADVL | double | 15,2 | No | No | No | |
| MHWDDSL | double | 15,2 | No | No | No | |
| MHWDDVL | double | 15,2 | No | No | No | |
| MHWADFL | double | 15,2 | No | No | No | |
mst_attlogs
| mst_attlogs | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| 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 | |
| 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 | |
mst_cost_center
| mst_cost_center | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| COCD | varchar | 25 | No | No | No | |
| NEW_DPCD | varchar | 25 | No | No | No | |
| NEW_DESC | varchar | 100 | No | No | No | |
| BUS_CENTER | varchar | 25 | No | No | No | |
| OLD_DPCD | varchar | 25 | No | No | No | |
| OLD_DESC | varchar | 100 | No | No | No | |
mst_cost_center_555
| mst_cost_center_555 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| Controlling_Area | varchar | 25 | No | No | No | |
| Cost_Center_Code_888 | varchar | 25 | No | No | No | |
| Cost_Center_Code_555 | varchar | 25 | No | No | No | |
| Cost_Center_Name | varchar | 100 | No | No | No | |
| Person_Responsible | varchar | 150 | No | No | No | |
| Profit_Center | varchar | 25 | No | No | No | |
| Department_new | varchar | 100 | No | No | No | |
mst_ctr_no
| mst_ctr_no | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| ctr_no | varchar | 15 | No | No | No | |
| ctr_err_no | varchar | 15 | No | No | No | |
| ctr_no_year | varchar | 4 | No | No | No | |
mst_diocese
| mst_diocese | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| DS_CODE | varchar | 25 | No | No | No | |
| DS_NAME | varchar | 100 | No | No | No | |
mst_gl_555
| mst_gl_555 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| COA | varchar | 25 | No | No | No | |
| GL_888 | varchar | 25 | No | No | No | |
| GL_555 | varchar | 25 | No | No | No | |
| Name | varchar | 100 | No | No | No | |
| Account_group | varchar | 25 | No | No | No | |
mst_mission
| mst_mission | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| MS_CODE | varchar | 25 | No | No | No | |
| MS_DESC | varchar | 100 | No | No | No | |
| MS_FDESC | longtext | 0 | No | No | No | |
mst_educatt
| mst_educatt | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| EA_CODE | varchar | 25 | No | No | No | |
| EA_DESC | varchar | 100 | No | No | No | |
mst_nationality
| mst_nationality | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| NT_CODE | varchar | 25 | No | No | No | |
| NT_DESC | varchar | 50 | No | No | No | |
mst_relivows
| mst_relivows | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| RV_CODE | varchar | 25 | No | No | No | |
| RV_DESC | varchar | 100 | No | No | No | |
my_ctr_no
| my_ctr_no | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| pvrecid | int | 20 | Yes | Yes | Yes | |
| myyear | varchar | 4 | No | No | No | |
mybpibadv
| mst_cost_center_555 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 1 | Yes | Yes | Yes | |
| atmno | varchar | 10 | No | No | No | |
| ddate | date | 0 | No | No | No | |
| dudate | date | 0 | No | No | No | |
| amount | double | 12,2 | No | No | No | |
| empname | varchar | 30 | No | No | No | |
| date_upld | datetime | 0 | No | No | No | |
| user | varchar | 15 | No | No | No | |
| company | varchar | 1 | No | No | No | |
ob2016
| ob2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| OBTNUMB | varchar | 8 | Yes | Yes | Yes | |
| OBTDATE | datetime | 0 | No | No | No | |
| OBTDTME | varchar | 4 | No | No | No | |
| OBTATME | varchar | 4 | No | No | No | |
obtp2016
| obtp2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| 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 | 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 | |
ok2016
| ok2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| OTWNUMB | varchar | 15 | No | No | No | |
| OTWDATE | datetime | 0 | No | No | No | |
| OTWFTME | varchar | 4 | No | No | No | |
| OTWTTME | varchar | 4 | No | No | No | |
ot2016
| ot2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| OTMNUMB | varchar | 15 | No | No | No | |
| OTMDATE | datetime | 0 | No | No | No | |
| OTMFTME | varchar | 4 | No | No | No | |
| OTMTTME | varchar | 4 | No | No | No | |
otdt2016
| otdt2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| OT_ENUMB | varchar | 25 | No | No | No | |
| OT_WS_CODE | varchar | 25 | No | No | No | |
| OT_DYCODE | varchar | 3 | No | No | No | |
| OT_DYTYPE | varchar | 25 | No | No | No | |
| OT_LCCD | varchar | 25 | No | No | No | |
| OT_DPCD | varchar | 25 | No | No | No | |
| OT_COCD | varchar | 25 | No | No | No | |
| OT_CDTE | date | 0 | No | No | No | |
| OT_DTETRX | date | 0 | No | No | No | |
| OT_SAMIN | datetime | 0 | No | No | No | |
| OT_SAMOUT | datetime | 0 | No | No | No | |
| OT_SPMIN | datetime | 0 | No | No | No | |
| OT_SPMOUT | datetime | 0 | No | No | No | |
| OT_STIME | datetime | 0 | No | No | No | |
| OT_ETIME | datetime | 0 | No | No | No | |
| OT_USER | varchar | 25 | No | No | No | |
| OT_ENCD | datetime | 0 | No | No | No | |
| OT_REMK | longtext | 0 | No | No | No | |
| OT_FLAG | varchar | 1 | No | No | No | |
otpay2016
| otpay2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| 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 | 15,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 | |
ow2016
| ow2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| OBWNUMB | varchar | 15 | No | No | No | |
| OBWDATE | datetime | 0 | No | No | No | |
| OBWDTME | varchar | 4 | No | No | No | |
| OBWATME | varchar | 4 | No | No | No | |
pdm_essi2016
| pdm_essi2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDMCOFF | varchar | 3 | No | No | No | |
| PDMFDTE | datetime | 0 | No | No | No | |
| PDMTDTE | datetime | 0 | No | No | No | |
| PDMPOST | varchar | 7 | No | No | No | |
| PDMAFDT | datetime | 0 | No | No | No | |
| PDMATDT | datetime | 0 | No | No | No | |
| PDMDAYS | double | 15,2 | No | No | No | |
| PDMADFD | datetime | 0 | No | No | No | |
| PDMADTD | datetime | 0 | No | No | No | |
| PDMSFDT | datetime | 0 | No | No | No | |
| PDMSTDT | datetime | 0 | No | No | No | |
pdm_sppe2016
| pdm_sppe2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDMCOFF | varchar | 3 | No | No | No | |
| PDMFDTE | datetime | 0 | No | No | No | |
| PDMTDTE | datetime | 0 | No | No | No | |
| PDMPOST | varchar | 7 | No | No | No | |
| PDMAFDT | datetime | 0 | No | No | No | |
| PDMATDT | datetime | 0 | No | No | No | |
| PDMDAYS | double | 15,2 | No | No | No | |
| PDMADFD | datetime | 0 | No | No | No | |
| PDMADTD | datetime | 0 | No | No | No | |
| PDMSFDT | datetime | 0 | No | No | No | |
| PDMSTDT | datetime | 0 | No | No | No | |
pdm2016
| pdm2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDMCOFF | varchar | 3 | No | No | No | |
| PDMFDTE | datetime | 0 | No | No | No | |
| PDMTDTE | datetime | 0 | No | No | No | |
| PDMPOST | varchar | 7 | No | No | No | |
| PDMAFDT | datetime | 0 | No | No | No | |
| PDMATDT | datetime | 0 | No | No | No | |
| PDMDAYS | double | 15,2 | No | No | No | |
| PDMADFD | datetime | 0 | No | No | No | |
| PDMADTD | datetime | 0 | No | No | No | |
| PDMSFDT | datetime | 0 | No | No | No | |
| PDMSTDT | datetime | 0 | No | No | No | |
pdw_sppe2016
| pdw_sppe2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDWWEEK | varchar | 3 | No | No | No | |
| PDWFDTE | datetime | 0 | No | No | No | |
| PDWTDTE | datetime | 0 | No | No | No | |
| PDWPOST | varchar | 7 | No | No | No | |
| PDWAFDT | datetime | 0 | No | No | No | |
| PDWATDT | datetime | 0 | No | No | No | |
| PDWDAYS | double | 15,2 | No | No | No | |
| PDWADFD | datetime | 0 | No | No | No | |
| PDWADTD | datetime | 0 | No | No | No | |
| PDWSFDT | datetime | 0 | No | No | No | |
| PDWSTDT | datetime | 0 | No | No | No | |
pdw2016
| pdw2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDWWEEK | varchar | 3 | No | No | No | |
| PDWFDTE | datetime | 0 | No | No | No | |
| PDWTDTE | datetime | 0 | No | No | No | |
| PDWPOST | varchar | 7 | No | No | No | |
| PDWAFDT | datetime | 0 | No | No | No | |
| PDWATDT | datetime | 0 | No | No | No | |
| PDWDAYS | double | 15,2 | No | No | No | |
| PDWADFD | datetime | 0 | No | No | No | |
| PDWADTD | datetime | 0 | No | No | No | |
| PDWSFDT | datetime | 0 | No | No | No | |
| PDWSTDT | datetime | 0 | No | No | No | |
pmhempl
| pmhempl | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | No | No | |
| EMPLNAM | varchar | 40 | No | No | No | |
| EMPFNAM | varchar | 40 | No | No | No | |
| EMPMNAM | varchar | 40 | No | No | No | |
| EMPSXCD | varchar | 1 | No | No | No | |
| EMPBDTE | datetime | 0 | No | No | No | |
| EMPPOBT | varchar | 50 | 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 | datetime | 0 | No | No | No | |
| EMPSSNO | varchar | 12 | No | No | No | |
| EMPTINO | varchar | 12 | No | No | No | |
| EMPHDTE | datetime | 0 | No | No | No | |
| EMPODTE | datetime | 0 | No | No | No | |
| EMPPMCD | varchar | 1 | No | No | No | |
| EMPPCCD | varchar | 1 | No | No | No | |
| EMPCOCD | varchar | 1 | No | No | No | |
| EMPLCCD | varchar | 3 | No | No | No | |
| EMPSTAT | varchar | 1 | No | No | No | |
| EMPSTDT | datetime | 0 | No | No | No | |
| EMPPINO | varchar | 12 | No | No | No | |
| EMPAVOL | tinyint | 1 | No | Yes | No | |
| EMPPVOL | tinyint | 1 | No | Yes | No | |
| EMPTDPD | varchar | 1 | No | No | No | |
| EMPCBAT | varchar | 1 | No | No | No | |
| EMPDPCD | varchar | 10 | No | No | No | |
| EMPESCD | varchar | 1 | No | No | No | |
| EMPDPCC | varchar | 10 | No | No | No | |
| EMPINCO | varchar | 1 | No | No | No | |
| EMPALLO | double | 15,5 | No | No | No | |
| EMPFEPF | varchar | 1 | No | No | No | |
| EMPHLDT | datetime | 0 | No | No | No | |
| EMPMENO | varchar | 12 | No | No | No | |
pmmcmpy
| pmmcmpy | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| CMPCOCD | varchar | 1 | No | No | No | |
| CMPNAME | varchar | 40 | No | No | No | |
| CMPSSSN | varchar | 12 | No | No | No | |
| CMPTINO | varchar | 12 | No | No | No | |
| CMPCADD | varchar | 50 | No | No | No | |
| CMPSLAC | varchar | 10 | No | No | No | |
| CMPSMEC | varchar | 10 | No | No | No | |
| CMPBKAL | varchar | 10 | No | No | No | |
| CMPOTHR | varchar | 10 | No | No | No | |
| CMPHOLD | varchar | 10 | No | No | No | |
| CMPPIBE | varchar | 10 | No | No | No | |
| CMPTELE | varchar | 10 | No | No | No | |
| CMPBMAK | varchar | 10 | No | No | No | |
| CMPCASH | varchar | 10 | No | No | No | |
| CMPTAXC | varchar | 10 | No | No | No | |
| CMPSMEP | varchar | 10 | No | No | No | |
| CMPABBR | varchar | 5 | No | No | No | |
| CMPMEDP | varchar | 10 | No | No | No | |
| CMPHACC | varchar | 3 | No | No | No | |
| CMPPACC | varchar | 3 | No | No | No | |
| CMPWACC | varchar | 3 | No | No | No | |
| CMPTACC | varchar | 3 | No | No | No | |
| CMPHLAC | varchar | 3 | No | No | No | |
| CMPSACC | varchar | 3 | No | No | No | |
| CMPBACC | varchar | 3 | No | No | No | |
| CMPOIAC | varchar | 3 | No | No | No | |
| CMPSMAC | varchar | 3 | No | No | No | |
| CMPSPAC | varchar | 3 | No | No | No | |
| CMPOSLA | varchar | 3 | No | No | No | |
| CMPADDR | varchar | 100 | No | No | No | |
| CMPPAGBR | varchar | 5 | No | No | No | |
| CMPTELNO | varchar | 15 | No | No | No | |
| CMPZIPCD | varchar | 10 | No | No | No | |
| CMPFNAME | varchar | 8 | No | No | No | |
| CMPPHILNO | varchar | 12 | No | No | No | |
| CMPPHILSIG | varchar | 60 | No | No | No | |
| CMPPHILSIGPOS | varchar | 60 | No | No | No | |
pmmacin
| pmmacin | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| ACIACCD | varchar | 3 | No | No | No | |
| ACIDESC | varchar | 20 | No | No | No | |
pmmbene
| pmmbene | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| BENBNCD | varchar | 3 | No | No | No | |
| BENDESC | varchar | 15 | No | No | No | |
pmmcsta
| pmmcsta | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CSTCSCD | varchar | 1 | No | No | No | |
| CSTDESC | varchar | 15 | No | No | No | |
pmmctzp
| pmmctzp | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CTZCZCD | varchar | 2 | No | No | No | |
| CTZDESC | varchar | 30 | No | No | No | |
pmmdept
| pmmdept | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| DEPDPCD | varchar | 10 | No | No | No | |
| DEPCPCD | varchar | 1 | No | No | No | |
| DEPNAME | varchar | 35 | No | No | No | |
| DEPINCO | varchar | 2 | No | No | No | |
| DEPSLWG | varchar | 8 | No | No | No | |
| DEPSSSM | varchar | 8 | No | No | No | |
| DEPABBR | varchar | 5 | No | No | No | |
| DEPCOCD | varchar | 1 | No | No | No | |
| DEPFLAG | varchar | 1 | No | No | No | |
| DEPBONS | varchar | 8 | No | No | No | |
| DEPBENE | varchar | 8 | No | No | No | |
| DEPOCDE | varchar | 3 | No | No | No | |
| DEPACTV | varchar | 1 | No | No | No | |
| DEPACTIVE | varchar | 1 | No | No | No | |
pmmicls
| pmmicls | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| ICLICCD | varchar | 3 | No | No | No | |
| ICLDESC | varchar | 15 | No | No | No | |
pmmjblv
| pmmjblv | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| JBLJLCD | varchar | 2 | No | No | No | |
| JBLDESC | varchar | 30 | No | No | No | |
pmmlnge
| pmmlnge | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LNGCODE | varchar | 2 | No | No | No | |
| LNGDESC | varchar | 15 | No | No | No | |
pmmloca
| pmmloca | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LOCCODE | varchar | 3 | No | No | No | |
| LOCDESC | varchar | 20 | No | No | No | |
pmmmach
| pmmmach | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LOCCODE | varchar | 3 | No | No | No | |
| LOCDESC | varchar | 20 | No | No | No | |
