Difference between revisions of "Myquota"

From SPGC Document Wiki
Jump to: navigation, search
(→‎qta2016_20160301)
Line 533: Line 533:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|QTACODE
+
|QTANUMB
 
|varchar
 
|varchar
−
|5
+
|15
−
|Yes
+
|No
−
|Yes
+
|No
 
|No
 
|No
 
|-
 
|-
−
|QTAEDTE
+
|QTACDTE
 
|date
 
|date
 
|0
 
|0
Line 547: Line 547:
 
|No
 
|No
 
|-
 
|-
−
|QTAREG
+
|QTARP01
−
|bigint
+
|varchar
−
|20
+
|5
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|QTARTEQT
+
|QTARO01
 
|double
 
|double
−
|0
+
|15,2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|QTARTEPC
+
|QTARP02
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO02
 
|double
 
|double
−
|0
+
|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
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 08:48, 5 August 2016

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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myquota&oldid=2539"