Mypaydb
From SPGC Document Wiki
Contents
- 1 ahs2016
- 2 alphalist_log
- 3 alphalist_log_mwe
- 4 attlogs_upld
- 5 bankdtl
- 6 birtax2316_2016
- 7 bonus_simul2016
- 8 bonus2016
- 9 bse2016
- 10 bsm_2016sppe
- 11 bsm2016
- 12 bsw2016
- 13 bsw_2016sppe
- 14 bwe2016
- 15 ccback
- 16 cm2016
- 17 cw2016
- 18 dt2016
- 19 dtr_allow_entry_maintenance
- 20 dtr2016
- 21 dtrallow2016
- 22 dtt2016
- 23 dw2016
- 24 empfix_allo
- 25 esapgl_empl
- 26 fp_id
- 27 fpid
- 28 hst2016
- 29 hstmwe2016
- 30 ins2016
- 31 lns2016
- 32 lns2016
- 33 lv2016
- 34 lw2016
- 35 mhr_2016
- 36 mhr2016
- 37 mhw2016
- 38 mhw2016mnhr_log2016
- 39 mst_attlogs
- 40 mst_cost_center
- 41 mst_cost_center_555
- 42 mst_cost_center_comp
- 43 mst_gl_555
- 44 mst_gl_account
- 45 mst_worksched
- 46 my_ctr_no
- 47 oasdsa
- 48 ob2016
- 49 obtp2016
- 50 ok2016
- 51 ot2016
- 52 otdt2016
- 53 otpay2016
- 54 ow2016
- 55 pmhempl
- 56 pmhrfempl
- 57 pmmdept
- 58 pmtatmp
- 59 pmtempl
- 60 pmtemve
- 61 pmtsepa
- 62 posting_logs
- 63 pp2016
- 64 pvf2016
- 65 pym_holi
- 66 pymacct
- 67 pymbank
- 68 pymbcnt
- 69 pymbran
- 70 pymftbl
- 71 pymhbnkadvc
- 72 pymholi
- 73 pymot
- 74 pympitb
- 75 pymprem
- 76 pymsdmf_newgl
- 77 pymsbnkadvc
- 78 pymsdmf
- 79 pymseqn
- 80 pymslvl
- 81 pymslvo
- 82 pymslvv
- 83 pymssst
- 84 pymtadd
- 85 pymtadw
- 86 pymtadw
- 87 pymtsrg
- 88 pymtsrg
- 89 pymtsrw
- 90 pymttbl
- 91 pymudue
- 92 pytchro
- 93 pytmerc
- 94 pytssrc
- 95 pytsdln
- 96 pytsdsa
- 97 pytsdsa_bk
- 98 pytssrc
- 99 pyttxrc
- 100 sdsaupload
- 101 slvladj2016
- 102 slvlrecon2016
- 103 sss_templ
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 | |
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 | |
mhw2016mnhr_log2016
| 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 | |
| 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 | 10 | 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 | |
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 | |
pmmdept
| pmmdept | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| 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 | |
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 | |
| EMPNUMB | varchar | 15 | No | No | No | |
| MHRCDTE | varchar | 15 | No | No | No | |
| EMPFNAM | varchar | 20 | No | No | No | |
| EMPMNAM | varchar | 15 | No | No | No | |
| EMPSXCD | varchar | 1 | 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 | |
| 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 | 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 | |
pmtemve
| pmtemve | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| EMVNUMB | varchar | 15 | No | No | No | |
| EMVEDTE | datetime | 0 | No | No | No | |
| EMVSCCD | varchar | 2 | No | No | No | |
| EMVSFCD | varchar | 3 | No | No | No | |
| EMVLCCD | varchar | 3 | No | No | No | |
| EMVDPCD | varchar | 10 | No | No | No | |
| EMVPSCD | varchar | 3 | No | No | No | |
| EMVBPAY | double | 15,5 | No | No | No | |
| EMVALLO | double | 15,5 | No | No | No | |
| EMVRDCD | varchar | 2 | No | No | No | |
| EMVESCD | varchar | 1 | No | No | No | |
| EMVFLAG | tinyint | 1 | No | No | No | |
| EMVPCCD | varchar | 1 | No | No | No | |
| EMVCOCD | varchar | 1 | No | No | No | |
| EMVFPER | varchar | 1 | No | No | No | |
| EMVPACD | varchar | 2 | No | No | No | |
| EMVPADT | datetime | 0 | No | No | No | |
| EMVTDPD | varchar | 1 | No | No | No | |
| EMVBLOC | varchar | 3 | No | No | No | |
| OCODE | varchar | 3 | No | No | No | |
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 | |
| ACCOACD | varchar | 10 | No | No | No | |
| ACCDESC | varchar | 35 | No | No | No | |
| ACCNAME | varchar | 35 | No | No | No | |
| ACCACDE | varchar | 3 | No | No | No | |
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 | |
| BCNBKCD | varchar | 5 | No | No | No | |
| BCNPSON | varchar | 30 | No | No | No | |
| BCNPOSI | varchar | 20 | No | No | No | |
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 | |
| FTBCOCD | varchar | 1 | No | No | No | |
| FTBSSSR | double | 15,2 | No | No | No | |
| FTBSSSE | double | 15,2 | No | No | No | |
| FTBMEDR | double | 15,2 | No | No | No | |
| FTBMEDE | double | 15,2 | No | Yes | No | |
| FTBECCM | double | 15,2 | No | No | No | |
| FTBPIBR | double | 15,2 | No | No | No | |
| FTBPIBE | double | 15,2 | No | No | No | |
| FTBGPAY | double | 15,2 | No | No | No | |
| FTBTAXC | double | 15,2 | No | No | No | |
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 | |
| RECID | int | 20 | Yes | Yes | Yes | |
| HOLDATE | datetime | 0 | No | No | No | |
| HOLTYPE | varchar | 1 | No | No | No | |
| HOLLCCD | varchar | 3 | No | No | No | |
| HOLDAYS | double | 15,5 | No | No | No | |
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 | |
| PITLWGP | double | 15,2 | No | No | No | |
| PITUPGP | double | 15,2 | No | No | No | |
| PITERCN | double | 15,2 | No | No | No | |
| PITERFC | double | 15,2 | No | No | No | |
| PITEECN | double | 15,2 | No | No | No | |
| PITEEFC | double | 15,2 | No | No | No | |
pymprem
| pymprem | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PRMRRD1 | double | 15,2 | No | No | No | |
| PRMRRO1 | double | 15,2 | No | No | No | |
| PRMRRD2 | double | 15,2 | No | No | No | |
| PRMRRO2 | double | 15,2 | No | No | No | |
| PRMRSD1 | double | 15,2 | No | No | No | |
| PRMRSO1 | double | 15,2 | No | No | No | |
| PRMRSD2 | double | 15,2 | No | No | No | |
| PRMRSO2 | double | 15,2 | No | No | No | |
| PRMRLD1 | double | 15,2 | No | No | No | |
| PRMRLO1 | double | 15,2 | No | No | No | |
| PRMRLD2 | double | 15,2 | No | No | No | |
| PRMRLO2 | double | 15,2 | No | No | No | |
| PRMNRD1 | double | 15,2 | No | No | No | |
| PRMNRO1 | double | 15,2 | No | No | No | |
| PRMNRD2 | double | 15,2 | No | No | No | |
| PRMNRO2 | double | 15,2 | No | No | No | |
| PRMNSD1 | double | 15,2 | No | No | No | |
| PRMNSO1 | double | 15,2 | No | No | No | |
| PRMNSD2 | double | 15,2 | No | No | No | |
| PRMNSO2 | double | 15,2 | No | No | No | |
| PRMNLD1 | double | 15,2 | No | No | No | |
| PRMNLO1 | double | 15,2 | No | No | No | |
| PRMNLD2 | double | 15,2 | No | No | No | |
| PRMNLO2 | double | 15,2 | 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 | |
| recid | int | 25 | Yes | Yes | Yes | |
| SDMCOMP | varchar | 24 | No | No | No | |
| SDMSDCD | varchar | 3 | No | No | No | |
| SDMDESC | varchar | 30 | No | No | No | |
| SDMSDTP | varchar | 1 | No | No | No | |
| SDMSDSA | varchar | 1 | No | No | No | |
| SDMOACD | varchar | 10 | No | No | No | |
| SDMCODE | varchar | 3 | No | No | No | |
| SDMCOTP | varchar | 1 | No | No | No | |
| SDMFLAG | varchar | 1 | No | No | No | |
| SDMACDE | varchar | 3 | No | No | No | |
| 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 | |
| SVLEDTE | date | 0 | No | No | No | |
| SVLETLE | double | 15,2 | No | No | No | |
pymslvo
| pymslvo | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| SVOEDTE | date | 0 | No | No | No | |
| SVOETLE | double | 15,2 | No | No | No | |
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 | |
| SSSLWGP | double | 15,2 | No | No | No | |
| SSSUPGP | double | 15,2 | No | No | No | |
| SSSSLCR | double | 15,2 | No | No | No | |
| SSSERCN | double | 15,2 | No | No | No | |
| SSSERMN | double | 15,2 | No | No | No | |
| SSSEREC | double | 15,2 | No | No | No | |
| SSSEECN | double | 15,2 | No | No | No | |
| SSSEEMN | double | 15,2 | No | No | No | |
pymtadd
| pymtadd | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| TADSQNO | varchar | 2 | No | No | No | |
| TADADED | double | 15,2 | No | No | No | |
| TADRATE | double | 15,2 | No | No | No | |
pymtadw
| pymtadw | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| TAWSQNO | varchar | 2 | No | No | No | |
| TAWRATE | double | 15,2 | No | No | No | |
| TAWADED | double | 15,2 | No | No | No | |
pymtadw
| pymtadw | ||||||
|---|---|---|---|---|---|---|
| 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 | |
| TSRSQNO | varchar | 2 | No | No | No | |
| TSRTXCD | varchar | 10 | No | No | No | |
| TSRSLRY | double | 15,2 | No | No | No | |
pymtsrg
| pymtsrg | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| TSRSQNO | varchar | 2 | No | No | No | |
| TSRTXCD | varchar | 10 | No | No | No | |
| TSRSLRY | double | 15,2 | No | No | No | |
pymtsrw
| pymtsrw | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| TSWSQNO | varchar | 2 | No | No | No | |
| TSWTXCD | varchar | 10 | No | No | No | |
| TSWSLRY | double | 15,2 | No | No | No | |
pymttbl
| pymttbl | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| TBLLATE | double | 15,2 | No | No | No | |
| TBLMNOT | double | 15,2 | No | No | No | |
| TBLTRDY | varchar | 3 | No | No | No | |
| TBLWOLV | varchar | 3 | No | No | No | |
| TBLDLOA | varchar | 3 | No | No | No | |
| TBLMNHF | double | 15,2 | No | No | No | |
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 | |
pytmerc
| pytmerc | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| MRCCOCD | varchar | 1 | No | No | No | |
| MRCCDTE | datetime | 0 | No | No | No | |
| MRCRCNO | varchar | 20 | No | No | No | |
| MRCDATE | datetime | 0 | No | No | No | |
| MRCAMNT | double | 15,2 | No | No | No | |
pytssrc
| pytssrc | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PRCCOCD | varchar | 1 | No | No | No | |
| PRCCDTE | datetime | 0 | No | No | No | |
| PRCRCNO | varchar | 20 | No | No | No | |
| PRCDATE | datetime | 0 | No | No | No | |
| PRCAMNT | double | 15,2 | No | No | No | |
pytsdln
| pytsdln | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| SDLCOCD | varchar | 1 | No | No | No | |
| SDLCDTE | datetime | 0 | No | No | No | |
| SDLRCNO | varchar | 20 | No | No | No | |
| SDLDATE | datetime | 0 | No | No | No | |
| SDLAMNT | double | 15,2 | No | No | No | |
| SDLSDCD | varchar | 3 | No | No | No | |
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 | |
