Mypmsdb
From SPGC Document Wiki
Contents
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 | Yes | Yes | Yes | |
| 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 | |
