Difference between revisions of "Myquota"
From SPGC Document Wiki
(→svl2004) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]] | ||
| + | |||
==hst2016== | ==hst2016== | ||
{| class="wikitable" \ | {| class="wikitable" \ | ||
| Line 1,285: | Line 1,287: | ||
|No | |No | ||
|} | |} | ||
| + | |||
| + | [[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]] | ||
Latest revision as of 09:20, 1 September 2016
Main Page > Application Development Team > DB Specs > 202.2.2.52
Contents
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 | |
pmtempl
| pmtempl | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | Yes | Yes | No | |
| EMPLNAM | varchar | 15 | No | No | No | |
| EMPFNAM | varchar | 20 | No | No | No | |
| EMPMNAM | varchar | 15 | No | No | No | |
| EMPTXCD | varchar | 15 | No | No | No | |
| EMPNUMB | varchar | 10 | No | No | No | |
| EMPSSNO | varchar | 12 | No | No | No | |
| EMPTINO | varchar | 11 | No | No | No | |
| EMPPMCD | varchar | 1 | No | No | No | |
| EMPCOCD | varchar | 1 | No | No | No | |
| EMPLCCD | varchar | 3 | No | No | No | |
| EMPSTAT | varchar | 1 | No | No | No | |
| EMPPINO | varchar | 12 | No | No | No | |
| EMPDPCD | varchar | 10 | No | No | No | |
| QTACODE | varchar | 10 | No | No | No | |
pmtproc
| pmtproc | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PROCODE | varchar | 5 | No | No | No | |
| PRODESC | varchar | 35 | No | No | No | |
| PROGRPC | varchar | 3 | No | No | No | |
| PROABBR | varchar | 5 | No | No | No | |
pmtproc_mey
| pmtproc_mey | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PROCODE | varchar | 5 | No | No | No | |
| PRODESC | varchar | 35 | No | No | No | |
| PROGRPC | varchar | 3 | No | No | No | |
| PROABBR | varchar | 5 | No | No | No | |
pmtqota
| pmtqota | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| QTACODE | varchar | 5 | Yes | Yes | No | |
| QTAEDTE | date | 0 | No | No | No | |
| QTAREG | bigint | 20 | No | No | No | |
| QTARTEQT | double | 0 | No | No | No | |
| QTARTEPC | double | 0 | No | No | No | |
qta2016_20160301
| qta2016_20160301 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| QTANUMB | varchar | 15 | No | No | No | |
| QTACDTE | date | 0 | No | No | No | |
| QTARP01 | varchar | 5 | No | No | No | |
| QTARO01 | double | 15,2 | No | No | No | |
| QTARP02 | varchar | 5 | No | No | No | |
| QTARO02 | double | 15,2 | No | No | No | |
| QTARP03 | varchar | 5 | No | No | No | |
| QTARO03 | double | 15,2 | No | No | No | |
| QTARP04 | varchar | 5 | No | No | No | |
| QTARO04 | double | 15,2 | No | No | No | |
| QTARP05 | varchar | 5 | No | No | No | |
| QTARO05 | double | 15,2 | No | No | No | |
| QTARP06 | varchar | 5 | No | No | No | |
| QTARO06 | double | 15,2 | No | No | No | |
| QTAOP01 | varchar | 5 | No | No | No | |
| QTAOO01 | double | 15,2 | No | No | No | |
| QTAOP02 | varchar | 5 | No | No | No | |
| QTAOO02 | double | 15,2 | No | No | No | |
| QTAOP03 | varchar | 5 | No | No | No | |
| QTAOO03 | double | 15,2 | No | No | No | |
| QTAOP04 | varchar | 5 | No | No | No | |
| QTAOO04 | double | 15,2 | No | No | No | |
| QTAOP05 | varchar | 5 | No | No | No | |
| QTAOO05 | double | 15,2 | No | No | No | |
| QTAOP06 | varchar | 5 | No | No | No | |
| QTAOO06 | double | 15,2 | No | No | No | |
| QTAHP01 | varchar | 5 | No | No | No | |
| QTAHO01 | double | 15,2 | No | No | No | |
| QTAHP02 | varchar | 5 | No | No | No | |
| QTAHO02 | double | 15,2 | No | No | No | |
| QTAHP03 | varchar | 5 | No | No | No | |
| QTAHO03 | double | 15,2 | No | No | No | |
| QTAHP04 | varchar | 5 | No | No | No | |
| QTAHO04 | double | 15,2 | No | No | No | |
| QTAHP05 | varchar | 5 | No | No | No | |
| QTAHO05 | double | 15,2 | No | No | No | |
| QTAHP06 | varchar | 5 | No | No | No | |
| QTAHO06 | double | 15,2 | No | No | No | |
quota_entry
| quota_entry | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| emp_no | varchar | 15 | Yes | Yes | No | |
| actual_date | date | 0 | No | No | No | |
| day_type | varchar | 10 | No | No | No | |
| reg_quota_code1 | varchar | 10 | No | No | No | |
| reg_actual_quota1 | double | 15,2 | No | No | No | |
| reg_quota_code1_amt | double | 15,2 | No | No | No | |
| reg_quota_code2 | varchar | 10 | No | No | No | |
| reg_actual_quota2 | 15,2 | 0 | No | No | No | |
| reg_quota_code2_amt | double | 15,2 | No | No | No | |
| reg_quota_code3 | varchar | 10 | No | No | No | |
| reg_actual_quota3 | 15,2 | 0 | No | No | No | |
| reg_quota_code3_amt | double | 15,2 | No | No | No | |
| reg_quota_code4 | varchar | 10 | No | No | No | |
| reg_actual_quota4 | double | 15,2 | No | No | No | |
| reg_quota_code4_amt | double | 15,2 | No | No | No | |
| reg_quota_code_ot1 | varchar | 10 | No | No | No | |
| reg_actual_quota_ot1 | double | 15,2 | No | No | No | |
| reg_quota_code1_amt_ot | double | 15,2 | No | No | No | |
| reg_quota_code_ot2 | varchar | 10 | No | No | No | |
| reg_actual_quota_ot2 | double | 15,2 | No | No | No | |
| reg_quota_code2_amt_ot | double | 15,2 | No | No | No | |
| reg_quota_code_ot3 | varchar | 10 | No | No | No | |
| reg_actual_quota_ot3 | double | 15,2 | No | No | No | |
| reg_quota_code3_amt_ot | double | 15,2 | No | No | No | |
| reg_quota_code_ot4 | varchar | 10 | No | No | No | |
| reg_actual_quota_ot4 | double | 15,2 | No | No | No | |
| reg_quota_code4_amt_ot | double | 15,2 | No | No | No | |
| location | varchar | 5 | Yes | Yes | No | |
svl2004
| svl2004 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| QTANUMB | varchar | 15 | No | No | No | |
| QTACDTE | date | 0 | No | No | No | |
| QTARP01 | varchar | 5 | No | No | No | |
| QTARO01 | double | 15,2 | No | No | No | |
| QTARP02 | varchar | 5 | No | No | No | |
| QTARO02 | double | 15,2 | No | No | No | |
| QTARP03 | varchar | 5 | No | No | No | |
| QTARO03 | double | 15,2 | No | No | No | |
| QTARP04 | varchar | 5 | No | No | No | |
| QTARO04 | double | 15,2 | No | No | No | |
| QTARP05 | varchar | 5 | No | No | No | |
| QTARO05 | double | 15,2 | No | No | No | |
| QTARP06 | varchar | 5 | No | No | No | |
| QTARO06 | double | 15,2 | No | No | No | |
| QTAOP01 | varchar | 5 | No | No | No | |
| QTAOO01 | double | 15,2 | No | No | No | |
| QTAOP02 | varchar | 5 | No | No | No | |
| QTAOO02 | double | 15,2 | No | No | No | |
| QTAOP03 | varchar | 5 | No | No | No | |
| QTAOO03 | double | 15,2 | No | No | No | |
| QTAOP04 | varchar | 5 | No | No | No | |
| QTAOO04 | double | 15,2 | No | No | No | |
| QTAOP05 | varchar | 5 | No | No | No | |
| QTAOO05 | double | 15,2 | No | No | No | |
| QTAOP06 | varchar | 5 | No | No | No | |
| QTAOO06 | double | 15,2 | No | No | No | |
| QTAHP01 | varchar | 5 | No | No | No | |
| QTAHO01 | double | 15,2 | No | No | No | |
| QTAHP02 | varchar | 5 | No | No | No | |
| QTAHO02 | double | 15,2 | No | No | No | |
| QTAHP03 | varchar | 5 | No | No | No | |
| QTAHO03 | double | 15,2 | No | No | No | |
| QTAHP04 | varchar | 5 | No | No | No | |
| QTAHO04 | double | 15,2 | No | No | No | |
| QTAHP05 | varchar | 5 | No | No | No | |
| QTAHO05 | double | 15,2 | No | No | No | |
| QTAHP06 | varchar | 5 | No | No | No | |
| QTAHO06 | double | 15,2 | No | No | No | |
Main Page > Application Development Team > DB Specs > 202.2.2.52
