Difference between revisions of "Myquota"
From SPGC Document Wiki
(→svl2004) |
|||
| Line 1,047: | Line 1,047: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARP02 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,054: | Line 1,054: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARO02 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,061: | Line 1,061: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARP03 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,068: | Line 1,068: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARO03 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,075: | Line 1,075: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARP04 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,082: | Line 1,082: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARO04 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,089: | Line 1,089: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARP05 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,096: | Line 1,096: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARO05 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,103: | Line 1,103: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARP06 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,110: | Line 1,110: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTARO06 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,117: | Line 1,117: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOP01 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,124: | Line 1,124: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOO01 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,131: | Line 1,131: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOP02 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,138: | Line 1,138: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOO02 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,145: | Line 1,145: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOP03 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,152: | Line 1,152: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOO03 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,159: | Line 1,159: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOP04 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,166: | Line 1,166: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOO04 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,173: | Line 1,173: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOP05 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,180: | Line 1,180: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOO05 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,187: | Line 1,187: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOP06 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,194: | Line 1,194: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAOO06 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,201: | Line 1,201: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHP01 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,208: | Line 1,208: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHO01 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,215: | Line 1,215: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHP02 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,222: | Line 1,222: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHO02 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,229: | Line 1,229: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHP03 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,236: | Line 1,236: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHO03 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,243: | Line 1,243: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHP04 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,250: | Line 1,250: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHO04 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,257: | Line 1,257: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHP05 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,264: | Line 1,264: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHO05 |
|double | |double | ||
|15,2 | |15,2 | ||
| Line 1,271: | Line 1,271: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHP06 |
|varchar | |varchar | ||
|5 | |5 | ||
| Line 1,278: | Line 1,278: | ||
|No | |No | ||
|- | |- | ||
| − | | | + | |QTAHO06 |
|double | |double | ||
|15,2 | |15,2 | ||
Revision as of 09:11, 5 August 2016
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 | |
