Mypaydb

From SPGC Document Wiki
Revision as of 14:06, 30 September 2016 by Ojt1 (Talk | contribs) (→‎pytssrc)

Jump to: navigation, search

Main Page > Application Development Team > DB Specs > 202.2.2.52

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
AHSTAXW 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

alphalist_log_mwe

alphalist_log_mwe
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 varbinary 10 No No No
EMPSEPADTE date 0 No No No
EMPBDTE date 15 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
EMPREGION varchar 15 No No No
HOLPAY double 15,2 No No No
OTPAY double 15,2 No No No
NSDPAY double 15,2 No No No
RATEDAY double 15,2 No No No
RATEMO double 19,2 No No No
RATEYR double 15,2 No No No
EMPDPCD varchar 30 No No No
MWEGROSS double 15,2 No No No
MWESAL double 15,2 No Yes No
MWEFLAG varchar 1 No No No
DATEPROC datetime 0 No No No

attlogs_upld

attlogs_upld
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
ATTL_USER varchar 25 No No No
ATTL_FILE varchar 100 No No No
ATTL_DATE datetime 0 No No No
ATTL_OFILE varchar 100 No No No
ATTL_RMARK varchar 25 No No No

bankdtl

bankdtl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 No Yes No
BNKBKCD Varchar 3 No No No
BNKCOCD Varchar 25 No No No
BNKPCLASS varchar 25 No No No
BNKACCTTYPE varchar 25 No No No
BNKACCT varchar 25 No No No
BNKACCT_13MO varchar 25 No No No
BNKCONTPERSON varchar 150 No No No
BNKCONTPOSITION varchar 150 No No No
BNKADDR varchar 150 No No No
BNKDISBCODE varchar 15 No No No
BNKDISBNAME varchar 150 No No No
RPT_CHECK_REVIEWED varchar 150 No No No
RPT_CHECK_REVIEWED_POSI varchar 150 No No No
RPT_NOTED varchar 150 No No No
RPT_NOTED_POSI varchar 150 No No No
RPT_APPROVED varchar 150 No No No
RPT_APPROVED_POSI varchar 150 No No No
RPT_FINAL_APPROVED varchar 150 No No No
RPT_FINAL_APPROVED_POSI varchar 150 No No No

birtax2316_2016

birtax2316_2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
EMPTINNO Varchar 15 No No No
EMPCOCD Varchar 3 No No No
EMPMWE_FLAG varchar 3 No No No
EMPSEP_FLAG varchar 3 No No No
EMPTXCD varchar 10 No No No
EMPNAME varchar 150 No No No
EMPADDR varchar 150 No No No
EMPBDAY date 0 No No No
MINWAGE_PER_DATE double 15,2 No No No
MINWAGE_PER_MONTH double 15,2 No No No
EMPLOYER_NAME varchar 150 No No No
EMPLOYER_ADDR varchar 150 No No No
P4GPAY_PRES double 15,2 No No No
P4NONTX_EXMPT double 15,2 No No No
P4TX_COMP_PRES double 15,2 No No No
P4TX_COMP_PREV double 15,2 No No No
P4GROSS_TAX_COMP double 15,2 No No No
P4TOT_EXEMPT double 15,2 No No No
P4PREMIUM_MEDE double 15,2 No No No
P4NET_TAX_COMP double 15,2 No Yes No
P4TAX_DUE double 15,2 No No No
P4TAXWITH_PRES double 15,2 No No No
P4TEXWITH_PREV double 15,2 No No No
P4_ADJUSTED_TAX_AMNT double 15,2 No No No
NTBPAY double 15,2 No No No
NTHOLPAY double 15,2 No No No
NTOTPAY double 15,2 No No No
NTNTPAY double 15,2 No No No
NTHAZPAY double 15,2 No No No
NTMPAY13 double 15,2 No No No
NTDEMINIMIS double 15,2 No No No
NTGOV_CONT double 15,2 No No No
NTOTHER_COMP double 15,2 No No No
NTNONTAX_COMP double 15,2 No No No
TXBPAY double 15,2 No No No
TXREPRESENTATION double 15,2 No No No
TXTRANSPO double 15,2 No No No
TXCOLA double 15,2 No No No
TXHOUSE_ALLO double 15,2 No No No
TXCOMMISION double 15,2 No No No
TXPROF_SHARING double 15,2 No No No
TXDIRECTOR_FEE double 15,2 No No No
TXMPAY13 double 15,2 No No No
TXHAZPAY double 15,2 No No No
TXOTPAY double 15,2 No No No
TXTAX_COMP double 150 No No No
PERIOD_FROM date 0 No No No
PERIOD_TO date 0 No No No
EMPNUMB varchar 15 No No No
EMPPCCD varchar 2 No No No
EMPTAXREF double 15,2 No No No

bonus_simul2016

bonus_simul2016
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
AHS13MO double 15,2 No No No
AHSBONS double 15,2 No No No
AHSSLRE double 15,2 No No No
AHSVLRE double 15,2 No No No
AHSSLPY double 15,2 No No No
AHSVLPY double 15,2 No No No
AHSLTAG tinyint 1 No No No
AHSCTAG varchar 1 No No No
AHSLPAY double 15,2 No No No
AHSPYNO varchar 10 No No No
AHSSTAT varchar 1 No No No
AHSPMCD varchar 1 No No No
AHSESCD varchar 1 No No No
AHSPCCD varchar 1 No No No
AHSBKCD varchar 5 No No No
AHSCOCD varchar 1 No No No
AHSLCCD varchar 3 No No No
AHSFDVL double 15,2 No No No
AHSFDSL double 15,2 No No No
AHSBPAY double 15,2 No No No
AHSDPCD varchar 10 No No No

bonus2016

bonus2016
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
AHS13MO double 15,2 No No No
AHSBONS double 15,2 No No No
AHSSLRE double 15,2 No No No
AHSVLRE double 15,2 No No No
AHSSLPY double 15,2 No No No
AHSVLPY double 15,2 No No No
AHSLTAG tinyint 1 No No No
AHSCTAG varchar 1 No No No
AHSLPAY double 15,2 No No No
AHSPYNO varchar 10 No No No
AHSSTAT varchar 1 No No No
AHSPMCD varchar 1 No No No
AHSESCD varchar 1 No No No
AHSPCCD varchar 1 No No No
AHSBKCD varchar 5 No No No
AHSCOCD varchar 1 No No No
AHSLCCD varchar 3 No No No
AHSFDVL double 15,2 No No No
AHSFDSL double 15,2 No No No
AHSBPAY double 15,2 No No No
AHSDPCD varchar 10 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

bsm_2016sppe

bsm_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 double 50 No No No
EMPMNAM varchar 50 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

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

bsw2016

bsw2016
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 3 No No No
EMPLNAM varchar 50 No No No
EMPLNAM double 15,2 No No No
EMPFNAM varchar 50 No No No
EMPMNAM varchar 50 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

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 3 No No No
EMPLNAM varchar 50 No No No
EMPLNAM double 15,2 No No No
EMPFNAM varchar 50 No No No
EMPMNAM varchar 50 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

bwe2016

bwe2016
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

ccback

ccback
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
mymodule varchar 20 No No No
myremark varchar 1 No No No
myuser varchar 10 No No No
mydate datetime 0 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

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

dtr_allow_entry_maintenance

dtr_allow_entry_maintenance
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
DTRAEMRCODE varchar 20 No No No
DTRAEMRDESC varchar 40 No No No

dtr2016

dtr2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
DTRCODE Varchar 3 No No No
EMPLNAM Varchar 30 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

dtrallow2016

dtrallow2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
DTRAENUMB Varchar 15 No No No
DTRACDTE date 0 No No No
DTRADATE date 0 No No No
DTRARCODE varchar 25 No No No
DTRAOR varchar 100 No No No
DTRAUSER varchar 10 No No No
DTRAENCD datetime 0 No No No
DTRAFLAG varchar 1 No No No
DTRAABY varchar 10 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 25 No No No
DT_DYTYPE varchar 30 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_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_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
DTWNUMB 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

empfix_allo

empfix_allo
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB Varchar 15 No Yes No
AMOUNT double 15,2 No Yes No
USERID varchar 45 No Yes No
DTENCODED datetime 0 No Yes No

esapgl_empl

esapgl_empl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
EMPNUMB varchar 15 No No No
EMPLNAM varchar 35 No No No
EMPFNAM varchar 35 No No No
EMPMNAM varchar 35 No No 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 No No No
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 No No No
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

hstmwe2016

hstmwe2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
HSTNUMB varchar 15 No No No
HSTCDTE date 0 No No No
HSTPCCD varchar 1 No No No
HSTCOCD varchar 1 No No No
HSTESCD varchar 1 No No No
HSTTAXC double 15,2 No No No
HSTMD varchar 1 No No No
HSTMWE varchar 1 No No No

ins2016

ins2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
LNSNUMB varchar 15 No No No
LNSSDCD varchar 3 No No No
LNSDATE datetime 0 No No No
LNSAMNT double 15,2 No No No
LNSBALC double 15,2 No No No
LNSUNPD datetime 0 No No No

lns2016

lns2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes 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 No No
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 No No
LOACOFF date 0 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
LOAHOUR double 15,2 No No No
LOAHRPD double 15,2 No No No
LOAASTA tinyint 1 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 date 0 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

mhr2016

mhr2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
MHRNUMB varchar 15 No No No
MHRCDTE datetime 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
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
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

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 double 15,2 No No No
MHWRSO1 double 15,2 No No No
MHWNSD1 double 15,2 No No No
MHWRSD2 double 15,2 No No No
MHWRSO2 double 15,2 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

mnhr_log2016

MHRRSO2
mnhr_log2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
MHRNUMB varchar 15 No No No
DTRDATE date 0 No No No
DAYCODE varchar 2 No No No
MHRCDTE datetime 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
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
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

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
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

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_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_cost_center_comp

mst_cost_center_comp
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 11 Yes Yes Yes
COCD_DUE varchar 25 No No No
DPCD varchar 25 No No No
COCD varchar 25 No No No
DPCD_MAP varchar 25 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_gl_account

mst_gl_account
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_GLCD varchar 25 No No No
NEW_DESC varchar 100 No No No
OLD_GLCD varchar 25 No No No
OLD_DESC varchar 100 No No No

mst_worksched

mst_worksched
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
WS_CODE varchar 25 No No No
WS_DESC varchar 50 No No No
WS_DYCODE varchar 25 No No No
WS_AMIN varchar 6 No No No
WS_AMOUT varchar 6 No No No
WS_PMIN varchar 6 No No No
WS_PMOUT varchar 6 No No No
WS_GPERD double 15,2 No No No
WS_NSSTART varchar 6 No No No
WS_NSEND varchar 6 No No No
WS_MHC_GROUP varchar 1 No No No
WS_MINS_AUTO_AMHDAY double 15,2 No No No
WS_MINS_AUTO_AMWDAY double 15,2 No No No
WS_MINS_MIN_OT double 15,2 No No No
WS_MINS_AUTO_PMHDAY double 15,2 No No No
WS_MINS_AUTO_PMWDAY double 15,2 No No No
WS_MINS_CBA double 15,2 No No No
WS_MINS_CBF varchar 1 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

oasdsa

oasdsa
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SDARECID int 20 Yes Yes Yes
SDANUMB varchar 15 No No No
SDADATE datetime 0 No No No
SDASDCD varchar 3 No No No
SDASAMT double 15,2 No No No
SDAINST double 15,2 No No No
SDAEDTE datetime 0 No No No
SDABALC double 15,2 No No No
SDAUNPD double 15,2 No No No
SDAREMK varchar 10 No No No
SDAINNO double 15,2 No No No
SDADCNO varchar 30 No No No
SDADCDT SDADCDT 0 No No No
SDASDTP varchar 1 No No No
SDASDSA varchar 1 No No No
SDATAGD varchar 1 No No No
SDAPRNT varchar 1 No No No
SDAUSER varchar 10 No No No
SDAPOST varchar 1 No No No
SDAENDT datetime 0 No No No
SDATRAN varchar 1 No No No
SDALAMT double 15,2 No No No
SDAPVRECID int 20 No Yes Yes

ob2016

ob2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
OBTNUMB varchar 8 No No No
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 varchar 1 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 1 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

pmhempl

pmhempl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
EMPNUMB varchar 15 No No No Employee No.
EMPLNAM varchar 40 No No No Last Name
EMPFNAM varchar 40 No No No First Name
EMPMNAM varchar 40 No No No Middle Name
EMPSXCD varchar 1 No No No Sex Code
EMPBDTE datetime 0 No No No Birth Date
EMPPOBT varchar 50 No No No Place of Birth
EMPRGCD varchar 2 No No No Religion Code
EMPCSCD varchar 1 No No No Civil Status
EMPCADD varchar 40 No No No Address
EMPTOWN varchar 20 No No No Town
EMPCITY varchar 20 No No No City
EMPCZCD varchar 2 No No No Citizenship
EMPTXCD varchar 10 No No No Tax Code
EMPLDTE datetime 0 No No No Tax Status Effectivity Date
EMPSSNO varchar 12 No No No SSS No.
EMPTINO varchar 12 No No No Tin No.
EMPHDTE datetime 0 No No No Date Hired
EMPODTE datetime 0 No No No Orientation Date
EMPPMCD varchar 1 No No No Payment Code
EMPPCCD varchar 1 No No No Payment Class
EMPCOCD varchar 1 No No No Company Code
EMPLCCD varchar 3 No No No Location Code
EMPSTAT varchar 1 No No No Tag for Active
EMPSTDT datetime 0 No No No Date Hold
EMPPINO varchar 12 No No No Pagibig No.
EMPAVOL tinyint 1 No Yes No Tag Below 4,000
EMPPVOL tinyint 1 No Yes No Tag Above 4,000
EMPTDPD varchar 1 No No No Tag for Daily Paid
EMPCBAT varchar 1 No No No Tag for CBA
EMPDPCD varchar 10 No No No Department Code
EMPESCD varchar 1 No No No Employment Status
EMPDPCC varchar 10 No No No Department Charging
EMPINCO varchar 10 No No No Internal Company
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

pmhrfempl

pmhrfempl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB Varchar 15 No No No
EMPLNAM Varchar 15 No No No
EMPFNAM Varchar 20 No No No
EMPMNAM Varchar 15 No No No
EMPSXCD varchar 30 No No No
EMPBDTE datetime 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 datetime 0 No No No
EMPSSNO Varchar 12 No No No
EMPTINO Varchar 11 No No No
EMPHDTE 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 No No
EMPPVOL tinyint 1 No No 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,2 No No No
EMPFEPF varchar 1 No No No
EMPHLDT datetime 0 No No No
EMPMENO varchar 12 No No No
EMPDBNK varchar 5 No No No
EMPEOCD datetime 0 No No No
EMPEOCC varchar 1 No No No
EMPADDR1 varchar 500 No No No
EMPADDR2 varchar 500 No No No
EMPADDR3 varchar 500 No No No
EMPADDR4 varchar 500 No No No
EMPATMP varchar 16 No No No
EMPTELN varchar 500 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
EMPDPROC datetime 0 No No No

pmmcmpy

pmmcmpy
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
CMPCOCD varchar 1 Yes Yes Yes Company Code
CMPNAME Varchar 40 No No No Company Name
CMPSSSN Varchar 12 No No No SSS Number
CMPTINO varchar 12 No No No TIN Number
CMPCADD varchar 50 No No No Address
CMPSLAC varchar 10 No No No Salaries, Wages
CMPSMEC varchar 10 No No No SSS/MED/EC
CMPBKAL varchar 10 No No No Kalookan Bank
CMPOTHR varchar 10 No No No Other Income
CMPHOLD varchar 10 No No No Hold Amount
CMPPIBE varchar 10 No No No Pagibig Acct
CMPTELE varchar 10 No No No Telegraphic
CMPBMAK varchar 10 No No No Makati Bank
CMPCASH varchar 10 No No No Cash Account
CMPTAXC varchar 10 No No No Tax Acct Code
CMPSMEP varchar 10 No No No SSS/MED/EC/PIB
CMPABBR varchar 5 No No No Company Abbr.
CMPMEDP varchar 10 No No No MED/EC/Payable
CMPHACC varchar 3 No No No
CMPPACC varchar 3 No No No
CMPWACC varchar 3 No Yes 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

pmmdept

pmmdept
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
DEPDPCD varchar 10 No No No Department Code
DEPCPCD varchar 1 No No No Company Code
DEPNAME varchar 35 No No No Department Name
DEPINCO varchar 2 No No No Internal Comp.
DEPSLWG varchar 8 No No No Salaries/Wages
DEPSSSM varchar 8 No No No SSS/MED/EC
DEPABBR varchar 5 No No No Abbreviation
DEPCOCD varchar 1 No No No Company Code
DEPFLAG varchar 1 No No No Flag for Remit.
DEPBONS varchar 8 No No No Bonus Account
DEPBENE varchar 8 No No No Benifits Acct.
DEPOCDE varchar 3 No No No Old Department

pmtatmp

pmtatmp
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
ATMNUMB varchar 15 No No No
ATMBKCD varchar 5 No No No
ATMACCT varchar 14 No No No

pmtempl

pmtempl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
EMPNUMB varchar 15 No No No Employee No.
EMPLNAM varchar 15 No No No Last Name
EMPFNAM varchar 20 No No No First Name
EMPMNAM varchar 15 No No No Middle Name
EMPSXCD varchar 1 No No No Sex Code
EMPBDTE datetime 0 No No No Birth Date
EMPPOBT varchar 15 No No No Place of Birth
EMPRGCD varchar 2 No No No Religion Code
EMPCSCD varchar 1 No No No Civil Status
EMPCADD varchar 40 No No No Address
EMPTOWN varchar 20 No No No Town
EMPCITY varchar 20 No No No City
EMPCZCD varchar 2 No No No Citizenship Code
EMPTXCD varchar 10 No No No Tax Code
EMPLDTE datetime 0 No No No Tax Status Effectivity Date
EMPSSNO varchar 12 No No No SSS No.
EMPTINO varchar 11 No No No Tin No.
EMPHDTE datetime 0 No No No Date Hired
EMPODTE datetime 0 No No No Orientation Date
EMPPMCD varchar 1 No No No Payment Code
EMPPCCD varchar 1 No No No Payment Class
EMPCOCD varchar 1 No No No Company Code
EMPLCCD varchar 3 No No No Location Code
EMPSTAT varchar 1 No No No Tag for Active
EMPSTDT datetime 0 No No No Date Hold
EMPPINO varchar 12 No No No Pagibig No.
EMPAVOL tinyint 1 No No No Tag Below 4,000
EMPPVOL tinyint 1 No No No Tag Above 4,000
EMPTDPD varchar 1 No No No Tag for Daily Paid
EMPCBAT varchar 1 No No No Tag for CBA
EMPDPCD varchar 10 No No No Department Code
EMPESCD varchar 1 No No No Employment Status
EMPDPCC varchar 10 No No No Department Charging
EMPINCO varchar 1 No No No Internal Company
EMPALLO double 15,2 No No No Allowance
EMPFEPF varchar 1 No No No Tag for Downloaded EPF
EMPHLDT datetime 0 No No No
EMPMENO varchar 12 No No No
EMPDBNK varchar 5 No No No
EMPEOCD datetime 0 No No No
EMPEOCC varchar 1 No No No
EMPADDR1 varchar 500 No No No
EMPADDR2 varchar 500 No No No
EMPADDR3 varchar 500 No No No
EMPADDR4 varchar 500 No No No
EMPATMP varchar 16 No No No
EMPTELN varchar 500 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

pmtemve

pmtemve
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
recid int 25 Yes Yes Yes
EMVNUMB varchar 15 No No No Employee No.
EMVEDTE datetime 0 No No No Effectivity Date
EMVSCCD varchar 2 No No No Section Code
EMVSFCD varchar 3 No No No Shift Code
EMVLCCD varchar 3 No No No Location
EMVDPCD varchar 10 No No No Department Code
EMVPSCD varchar 3 No No No Position Code
EMVBPAY double 15,5 No No No Basic Pay
EMVALLO double 15,5 No No No Allowance
EMVRDCD varchar 2 No No No Rest Day Code
EMVESCD varchar 1 No No No Employment Status
EMVFLAG tinyint 1 No No No Flag
EMVPCCD varchar 1 No No No Payment Class
EMVCOCD varchar 1 No No No Company Code
EMVFPER varchar 1 No No No Flag for Field Personnel
EMVPACD varchar 2 No No No PAM Code
EMVPADT datetime 0 No No No PAM Effective Date
EMVTDPD varchar 1 No No No Pay for Daily Paid
EMVBLOC varchar 3 No No No
OCODE varchar 3 No No No Old Department Code

pmtsepa

pmtsepa
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SEPSLPY double 15,5 Yes Yes Yes
SEPVLPY double 15,5 No No No
SEPADDS 15,5 0 No No No
SEPNNUM varchar 6 No No No
SEPRELE tinyint 1 No Yes No
SEPTAXD double 15,5 No No No
SEPTAXW double 15,5 No No No
SEPALLO double 15,5 No No No
SEPGPAY double 15,5 No No No
SEPRDTE datetime 0 No No No
SEPRTAG varchar 1 No No No
SEPRLBY varchar 8 No No No
SEPPRNT varchar 1 No No No
SEPHLSL double 15,2 No No No
SEPMARK varchar 1 No No No
SEPCOCD varchar 1 No No No
SEPLHSL double 15,2 No No No
SEPLHSL2 double 15,2 No No No
SEPLHSL_CDTE date 0 No No No
SEPLHSL2_CDTE date 0 No No No
OCODE varchar 3 No No No

posting_logs

posting_logs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
COMPANY varchar 25 No No No
SITE varchar 25 No No No
PCLASS varchar 25 No No No
MODULE varchar 60 No Yes No
MPERIOD date 0 No No No
DATEP datetime 0 No No No
USERN varchar 25 No No No

pp2016

pp2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
PDMCOCD varchar 25 No No No
PDMCOFF varchar 3 No No No
PDMFDTE date 0 No No No
PDMTDTE date 0 No No No
PDMPOST varchar 1 No No No
PDMAFDT date 0 No No No
PDMATDT date 0 No No No
PDMDAYS double 15,2 No No No
PDMDAYS datetime 0 No No No
PDMADTD datetime 0 No No No
PDMSFDT datetime 0 No No No
PDMSTDT datetime 0 No No No
PDMPCCD varchar 25 No No No

pvf2016

pvf2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
PVFRECID varchar 20 No No No
PVFNUMB varchar 15 No No No
PVFSDCD varchar 3 No No No
PVFPDTE datetime 0 No No No
PVFBPAY double 15,2 No No No
PVFALLO double 15,2 No No No
PVFTAGD varchar 1 No No No
PVFPDAY double 15,2 No No No
PVFHOUR double 15,2 No No No
PVFMINS double 15,2 No No No
PVFSDSA varchar 1 No No No
PVFEDTE datetime 0 No No No
PVFAMNT double 15,2 No No No
PVFDATE datetime 0 No No No
PVFNRD1 double 15,2 No No No
PVFRRD2 double 15,2 No No No
PVFRRO2 double 15,2 No No No
PVFNRD2 double 15,2 No No No
PVFNRO2 double 15,2 No No No
PVFRRO1 double 15,2 No No No
PVFNRO1 double 15,2 No No No
PVFPRNT varchar 1 No No No
PVFUSER varchar 10 No No No

pym_holi

pym_holi
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
HOLDATE datetime 0 No No No
HOLTYPE varchar 1 No No No
HOLLCCD varchar 25 No No No
HOLCOCD varchar 25 No No No
HOLDAYS double 15,2 No No No

pymacct

pymacct
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
ACCOACD varchar 10 No No No Account Code
ACCDESC varchar 35 No No No Description
ACCNAME varchar 35 No No No Account Name
ACCACDE varchar 3 No No No Old Acct. Code

pymbank

pymbank
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
BNKBKCD varchar 5 No No No
BNKDESC varchar 30 No No No
BNKADDR varchar 30 No No No
BNKTCSH double 15,2 No No No
BNKACDE varchar 3 No No No

pymbcnt

pymbcnt
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
BCNBKCD varchar 5 No No No Bank Code
BCNPSON varchar 30 No No No Bank Contact Person
BCNPOSI varchar 20 No No No Position

pymbran

pymbran
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
BRNCODE varchar 5 No No No
BRNNAME varchar 35 No No No

pymftbl

pymftbl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
FTBCOCD varchar 1 No No No
FTBSSSR double 15,2 No No No Employer SSS
FTBSSSE double 15,2 No No No Employee SSS
FTBMEDR double 15,2 No No No Medicare Employer
FTBMEDE double 15,2 No Yes No Medicare Employee
FTBECCM double 15,2 No No No Employer EC
FTBPIBR double 15,2 No No No Pagibig Employer
FTBPIBE double 15,2 No No No Pagibig Employee
FTBGPAY double 15,2 No No No Gross Pay
FTBTAXC double 15,2 No No No TAX Contribution

pymhbnkadvc

pymhbnkadvc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 11 No Yes Yes
BNKCD varchar 5 No Yes No
CMPNAM varchar 1 No No No
CMPADD varchar 80 No No No
BNKCPER varchar 30 No No No
BNKCPPOS varchar 30 No No No
BNKNAM varchar 30 No No No
BNKADD varchar 80 No No No
BNKACCT varchar 30 No No No
BNKPCD varchar 2 No No No
BNKTYPE varchar 2 No No No

pymholi

pymholi
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
RECID int 20 Yes Yes Yes
HOLDATE datetime 0 No No No Holiday Date
HOLTYPE varchar 1 No No No Holiday Type
HOLLCCD varchar 3 No No No Location
HOLDAYS double 15,5 No No No No. of Days

pymot

pymot
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
OT_CODE varchar 20 No No No
OT_COCD varchar 15 No No No
OT_DESC varchar 60 No No No
OT_SDESC varchar 60 No No No
OT_RATE double 10,3 No No No
OT_AMT_RATE double 15,3 No No No
OT_ED_CODE varchar 25 No No No
OT_PCMP_GRP_CODE varchar 25 No No No
OT_ACTIVE varchar 1 No No No
OT_MFIELD varchar 25 No No No
OT_FORMULA varchar 15 No No No
OT_REMK varchar 25 No No No
OT_PREM double 10,3 No No No

pympitb

pympitb
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
PITLWGP double 15,2 No No No Lower Range
PITUPGP double 15,2 No No No Upper Range
PITERCN double 15,2 No No No ER Contribution
PITERFC double 15,2 No No No Employer Fixed Contribution
PITEECN double 15,2 No No No Employee Contribution
PITEEFC double 15,2 No No No Employee Fixed Contribution

pymprem

pymprem
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
PRMRRD1 double 15,2 No No No Regular Hours
PRMRRO1 double 15,2 No No No Regular OT
PRMRRD2 double 15,2 No No No Rest Day
PRMRRO2 double 15,2 No No No Rest Day OT
PRMRSD1 double 15,2 No No No Special Holiday Regular Hrs.
PRMRSO1 double 15,2 No No No Special Holiday Regular OT
PRMRSD2 double 15,2 No No No Special Holiday Rest Day
PRMRSO2 double 15,2 No No No Special Holiday Rest Day OT
PRMRLD1 double 15,2 No No No Legal Holiday Regular Hrs.
PRMRLO1 double 15,2 No No No Legal Holiday OT
PRMRLD2 double 15,2 No No No Legal Holiday Rest Day Hours
PRMRLO2 double 15,2 No No No Legal Holiday Rest Day OT
PRMNRD1 double 15,2 No No No Night Shift Hours
PRMNRO1 double 15,2 No No No Night Shift OT
PRMNRD2 double 15,2 No No No Night Shift Rest Day
PRMNRO2 double 15,2 No No No Rest Day Night Shift OT
PRMNSD1 double 15,2 No No No Special Holiday Night Shift
PRMNSO1 double 15,2 No No No Special Holiday Night Shift OT
PRMNSD2 double 15,2 No No No Special Holiday Night Shift Rest Day
PRMNSO2 double 15,2 No No No Special Holiday Night Shift Rest Day OT
PRMNLD1 double 15,2 No No No Legal Holiday Night Shift Hours
PRMNLO1 double 15,2 No No No Legal Holiday Night Shift Hours OT
PRMNLD2 double 15,2 No No No Legal Holiday Night Shift Rest Day Hours
PRMNLO2 double 15,2 No No No Legal Holiday Night Shift Rest Day OT

pympymt

pympymt
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
PYMNUMB varchar 15 No No No
PYMSDCD varchar 3 No No No
PYMSDDT date 0 No No No
PYMDATE date 0 No No No
PYMAMNT double 15,2 No No No
PYMREFDCN varchar 40 No No No
PYMREMARK varchar 40 No No No
PYMPERD_LOG date 0 No No No
PYMUSER varchar 10 No No No
PYMDLOG datetime 0 No No No

pymsdmf_newgl

pymsdmf_newgl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
PYMNUMB varchar 15 No No No
PYMSDCD varchar 15 No No No
PYMSDDT date 0 No No No
PYMDATE varchar 0 No No No
PYMAMNT double 15,2 No No No
PYMREFDCN varchar 40 No No No
PYMREMARK varchar 40 No No No
PYMPERD_LOG date 0 No No No
PYMUSER varchar 10 No No No
PYMDLOG datetime 0 No No No

pymsbnkadvc

pymsbnkadvc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 11 No Yes Yes
BNKCD varchar 5 No No No
BNKSIGNA varchar 40 No No No
BNKSIGNAPOS varchar 30 No No No
BNKDOCPOS varchar 60 No Yes No
CMPNAM varchar 30 No No No
BNKPCD varchar 2 No No No
BNKTYPE varchar 2 No No No

pymsdmf

pymsdmf
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
recid int 25 Yes Yes Yes
SDMCOMP varchar 24 No No No
SDMSDCD varchar 3 No No No SDSA Code
SDMDESC varchar 30 No No No Description
SDMSDTP varchar 1 No No No SDSA Payment Type
SDMSDSA varchar 1 No No No SDSA Type
SDMOACD varchar 10 No No No Old Account Code
SDMCODE varchar 3 No No No
SDMCOTP varchar 1 No No No
SDMFLAG varchar 1 No No No Flag
SDMACDE varchar 3 No No No Account Code
SDMCODE_PRIO int 3 No No No
SDMNGLCD varchar 10 No No No

pymseqn

pymseqn
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
M01SEQN int 5 No No No
M02SEQN int 5 No No No
M03SEQN int 5 No No No
M04SEQN int 5 No No No
E01SEQN int 5 No No No
E02SEQN int 5 No No No
E03SEQN int 5 No No No
E04SEQN int 5 No No No
D01SEQN int 8 No No No
D02SEQN int 8 No No No
D03SEQN int 8 No No No
D04SEQN int 8 No No No

pymslvl

pymslvl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SVLEDTE date 0 No No No Effectivity Date
SVLETLE double 15,2 No No No Entitlement

pymslvo

pymslvo
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SVOEDTE date 0 No No No Effectivity Date
SVOETLE double 15,2 No No No Entitlement

pymslvv

pymslvo
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SVVEDTE date 0 No No No
SVVETLE double 15,2 No No No

pymssst

pymssst
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SSSLWGP double 15,2 No No No Lower Gross Range
SSSUPGP double 15,2 No No No Upper Gross Range
SSSSLCR double 15,2 No No No Salary Cieling
SSSERCN double 15,2 No No No Employer SSS Contribution
SSSERMN double 15,2 No No No Employer Medicare Contribution
SSSEREC double 15,2 No No No Employer EC Contribution
SSSEECN double 15,2 No No No Employee SSS Contribution
SSSEEMN double 15,2 No No No Employee Medicare Contribution

pymtadd

pymtadd
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
TADSQNO varchar 2 No No No Sequence No.
TADADED double 15,2 No No No Additional Deduction
TADRATE double 15,2 No No No Rate

pymtadw

pymtadw
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
TAWSQNO varchar 2 No No No Sequence No.
TAWRATE double 15,2 No No No Rate
TAWADED double 15,2 No No No Additional Deduction

pymtaxy

pymtaxy
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
TXYMNGR double 15,2 No No No
TXYMXGR double 15,2 No No No
TXYTXAD double 15,2 No No No
TXYTXRT double 15,2 No No No

pymtsrg

pymtsrg
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
TSRSQNO varchar 2 No No No Sequence No.
TSRTXCD varchar 10 No No No Tax Code
TSRSLRY double 15,2 No No No Salary

pymtsrw

pymtsrw
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
TSWSQNO varchar 2 No No No Sequence No.
TSWTXCD varchar 10 No No No Tax Code
TSWSLRY double 15,2 No No No Salary

pymttbl

pymttbl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
TBLLATE double 15,2 No No No Late
TBLMNOT double 15,2 No No No Minimum OT
TBLTRDY varchar 3 No No No Tardy
TBLWOLV varchar 3 No No No Without LOA
TBLDLOA varchar 3 No No No Disapproved
TBLMNHF double 15,2 No No No Man Hour

pymudue

pymudue
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
DUECODE varchar 3 No No No
DUEAMNT double 15,2 No No No
DUEEDTE date 0 No No No
DUEDCNO varchar 30 No No No

pytchro

pytchro
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
CRONUMB varchar 8 No No No
CROCRNO varchar 12 No No No

pytfixp

pytfixp
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
FIXNUMB varchar 15 No No No
FIXFLAG tinyint 1 No No No
FIXAMNT double 15,2 No No No

pytmerc

pytmerc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
MRCCOCD varchar 1 No No No Company Code
MRCCDTE datetime 0 No No No Cut-Off Date
MRCRCNO varchar 20 No No No Receipt No.
MRCDATE datetime 0 No No No Receipt Date
MRCAMNT double 15,2 No No No Amount

pytssrc

pytssrc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
PRCCOCD varchar 1 No No No Company Code
PRCCDTE datetime 0 No No No Cut-Off Date
PRCRCNO varchar 20 No No No Receipt No.
PRCDATE datetime 0 No No No Receipt Date
PRCAMNT double 15,2 No No No Amount

pytsdln

pytsdln
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SDLCOCD varchar 1 No No No Company Code
SDLCDTE datetime 0 No No No Cut-Off Date
SDLRCNO varchar 20 No No No Receipt No.
SDLDATE datetime 0 No No No Receipt Date
SDLAMNT double 15,2 No No No Amount
SDLSDCD varchar 3 No No No SDSA Code

pytsdsa

pytsdsa
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SDARECID int 20 No Yes Yes
SDANUMB varchar 15 No No No
SDADATE datetime 0 No No No
SDASDCD varchar 3 No No No
SDASAMT double 15,2 No No No
SDAINST double 15,2 No No No
SDAEDTE datetime 0 No No No
SDABALC double 15,2 No No No
SDAUNPD double 15,2 No No No
SDAREMK varchar 10 No No No
SDAINNO double 15,2 No No No
SDADCNO varchar 30 No No No
SDADCDT datetime 0 No No No
SDASDTP varchar 1 No No No
SDASDSA varchar 1 No No No
SDATAGD varchar 1 No No No
SDAPRNT varchar 1 No No No
SDAUSER varchar 10 No No No
SDAPOST varchar 1 No No No
SDAENDT datetime 0 No No No
SDATRAN varchar 1 No No No
SDALAMT double 15,2 No No No
SDAPVRECID int 20 No No No

pytsdsa_bk

pytsdsa_bk
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SDARECID int 20 No Yes Yes
SDANUMB varchar 15 No No No
SDADATE datetime 0 No No No
SDASDCD varchar 3 No No No
SDASAMT double 15,2 No No No
SDAINST double 15,2 No No No
SDAEDTE datetime 0 No No No
SDABALC double 15,2 No No No
SDAUNPD double 15,2 No No No
SDAREMK varchar 10 No No No
SDAINNO double 15,2 No No No
SDADCNO varchar 30 No No No
SDADCDT datetime 0 No No No
SDASDTP varchar 1 No No No
SDASDSA varchar 1 No No No
SDATAGD varchar 1 No No No
SDAPRNT varchar 1 No No No
SDAUSER varchar 10 No No No
SDAPOST varchar 1 No No No
SDAENDT datetime 0 No No No
SDATRAN varchar 1 No No No
SDALAMT double 15,2 No No No
SDAPVRECID int 20 No No No

pytssrc

pytssrc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
SRCCOCD varchar 1 No No No
SRCCDTE datetime 0 No No No
SRCRCNO varchar 20 No No No
SRCDATE datetime 0 No No No
SRCAMNT double 15,2 No No No

pyttxrc

pyttxrc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
TRCCDTE datetime 0 No No No
TRCRCNO varchar 20 No No No
TRCDATE datetime 0 No No No
TRCAMNT double 15,2 No No No

sdsaupload

sdsaupload
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SDARECID int 20 Yes Yes Yes
SDANUMB varchar 15 No No No
SDADATE datetime 0 No No No
SDASDCD varchar 3 No No No
SDASAMT double 15,2 No No No
SDAINST double 15,2 No No No
SDAEDTE datetime 0 No No No
SDABALC double 15,2 No No No
SDAUNPD double 15,2 No No No
SDAREMK varchar 10 No No No
SDAINNO double 15,2 No No No
SDADCNO varchar 30 No No No
SDADCDT datetime 0 No No No
SDASDTP varchar 1 No No No
SDASDSA varchar 1 No No No
SDATAGD varchar 1 No No No
SDAPRNT varchar 1 No No No
SDAUSER varchar 10 No No No
SDAPOST varchar 1 No No No
SDAENDT datetime 0 No No No
SDATRAN varchar 1 No No No
SDALAMT double 15,2 No No No
SDAPVRECID varchar 20 No No No
SDACLASS varchar 3 No Yes No
SDAMARK varchar 1 No Yes No

slvladj2016

slvladj2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
LVAB_RECID int 10 No Yes Yes
LVAB_ENUMB varchar 15 No No No
LVAB_EDATE date 0 No No No
LVAB_SL double 15,2 No No No
LVAB_VL double 15,2 No No No
LVAB_ASSUMSL double 15,2 No No No
LVAB_ASSUMVL double 15,2 No No No
LVAB_FATERNAL double 15,2 No No No
LVAB_USER varchar 10 No No No
PAYPERIOD date 0 No No No

slvlrecon2016

slvlrecon2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
LVAB_RECID int 20 No Yes Yes
LVAB_ENUMB varchar 15 No No No
LVAB_EDATE date 0 No No No
LVAB_SL double 15,2 No No No
LVAB_VL double 15,2 No No No
LVAB_USER varchar 10 No No No
PAYPERIOD date 0 No No No

sss_templ

sss_templ
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
SAL_LOW double 15,2 No No No
SAL_HIGH double 20,2 No No No
MO_SAL_CREDIT double 15,2 No No No
ER double 15,2 No No No
EE double 15,2 No No No
TOTAL double 15,2 No No No
EC_ER_ECCM double 15,2 No No No
ER_TOTAL double 15,2 No No No
EE_TOTAL double 15,2 No No No
ER_EC_TOTAL double 15,2 No No No
SE_VM_OFW_TOTAL double 15,2 No No No

sssc2016

sssc2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
ctrno double 8,2 Yes Yes Yes
ctryr varchar 4 No No No

svl2016

svl2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SVLNUMB varchar 15 Yes Yes Yes
SVLEDTE datetime 0 No No No
SVLSLEN double 15,2 No No No
SVLVLEN double 15,2 No No No
SVLFLEN double 15,2 No No No
SVLSLRE double 15,2 No No No
SVLVLRE double 15,2 No No No
SVLFLRE double 15,2 No No No

syslogs

syslogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
LOG_USER varchar 25 No Yes No
LOG_MODULE varchar 25 No Yes No
LOG_DATE datetime 0 No Yes No
LOG_ENUMB varchar 25 No Yes No
LOG_FIELD varchar 25 No Yes No
LOG_OLDVAL varchar 25 No Yes No
LOG_NEWVAL varchar 25 No Yes No
LOG_SQLEXEC longtext 0 No No No
LOG_CHANGE varchar 25 No Yes No
LOG_IPADDR varchar 25 No Yes No
LOG_PRNT varchar 25 No Yes No

tblempfixallo

tblempfixallo
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
FXEMPNUMB varchar 15 No Yes No
FXAMOUNT double 15,2 No Yes No
FXTMPSTMP datetime 0 No Yes No
FXUSER varchar 45 No Yes No

tkf2016

tkf2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
MHENUMB varchar 15 No No No
MHCDTE date 0 No No No
MHCOCD varchar 1 No No No
MHPCCD varchar 1 No No No
MHUSER varchar 10 No No No
MHDATEE datetime 0 No No No
MHDPCD varchar 10 No No No
MHPOSTED varchar 1 No No No

un2016

un2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
UNTNUMB varchar 15 No No No
UNTDATE datetime 0 No No No
UNTSTME varchar 4 No No No
UNTETME varchar 4 No No No

undt2016

undt2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
UN_ENUMB varchar 25 No No No
UN_WS_CODE varchar 25 No No No
UN_DYCODE varchar 3 No No No
UN_DYTYPE varchar 25 No No No
UN_LCCD varchar 25 No No No
UN_DPCD varchar 25 No No No
UN_COCD varchar 25 No No No
UN_CDTE date 0 No No No
UN_DTETRX date 0 No No No
UN_SAMIN datetime 0 No No No
UN_SAMOUT datetime 0 No No No
UN_SPMIN datetime 0 No No No
UN_SPMOUT datetime 0 No No No
UN_FTIME datetime 0 No No No
UN_TTIME datetime 0 No No No
UN_USER varchar 25 No No No
UN_ENCD datetime 0 No No No
UN_REMK longtext 1 No No No
UN_FLAG varchar 1 No No No

unibio28u2016

unibio28u2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
FPENUMB varchar 45 No No No
FPID varchar 45 No No No
FPDATE datetime 0 No No No
FPIO varchar 3 No No No
OLDBARID varchar 36 No No No

unionduesqb

unionduesqb
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB varchar 15 No No No

uw2016

uw2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
UNWNUMB varchar 15 No No No
UNWDATE datetime 0 No No No
UNWSTME varchar 4 No No No
UNWETME varchar 4 No No No

year_co

year_co
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
yco_year varchar 4 No No No
yco_post varchar 1 No No No

Main Page > Application Development Team > DB Specs > 202.2.2.52

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mypaydb&oldid=4236"