Difference between revisions of "202.2.2.89"

From SPGC Document Wiki
Jump to: navigation, search
(→‎pd2014)
Line 152: Line 152:
 
{| class="wikitable" \
 
{| class="wikitable" \
 
!colspan="7" | pd2015
 
!colspan="7" | pd2015
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|recid
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|PDMCOCD
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMLCCD
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMCOFF
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMFDTE
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMTDTE
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMPOST
 +
|varchar
 +
|7
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMAFDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMATDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMDAYS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMADFD
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMADTD
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMSFDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMSTDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==pd2016==
 +
{| class="wikitable" \
 +
!colspan="7" | pd2016
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name

Revision as of 13:23, 4 August 2016

paysliplog

paysliplog
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Id int 11 Yes Yes No
EmployeeNo varchar 20 No Yes No
PayDate date 0 No Yes No
DateOpen datetime 0 No Yes No
IpAddress varchar 50 No Yes No

pd2014

pd2014
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 11 Yes Yes No
PDMCOCD varchar 25 No No No
PDMLCCD varchar 25 No No No
PDMCOFF varchar 3 No No No
PDMFDTE datetime 0 No No No
PDMPOST varchar 7 No No No
PDMAFDT datetime 0 No No No
PDMATDT datetime 0 No No No
PDMDAYS double 15,2 No No No
PDMADFD datetime 0 No No No
PDMADTD datetime 0 No No No
PDMSFDT datetime 0 No No No
PDMSTDT datetime 0 No No No

pd2015

pd2015
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 11 Yes Yes Yes
PDMCOCD varchar 25 No No No
PDMLCCD varchar 25 No No No
PDMCOFF varchar 3 No No No
PDMFDTE datetime 0 No No No
PDMTDTE datetime 0 No No No
PDMPOST varchar 7 No No No
PDMAFDT datetime 0 No No No
PDMATDT datetime 0 No No No
PDMDAYS double 15,2 No No No
PDMADFD datetime 0 No No No
PDMADTD datetime 0 No No No
PDMSFDT datetime 0 No No No
PDMSTDT datetime 0 No No No

pd2016

pd2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 11 Yes Yes Yes
PDMCOCD varchar 25 No No No
PDMLCCD varchar 25 No No No
PDMCOFF varchar 3 No No No
PDMFDTE datetime 0 No No No
PDMTDTE datetime 0 No No No
PDMPOST varchar 7 No No No
PDMAFDT datetime 0 No No No
PDMATDT datetime 0 No No No
PDMDAYS double 15,2 No No No
PDMADFD datetime 0 No No No
PDMADTD datetime 0 No No No
PDMSFDT datetime 0 No No No
PDMSTDT datetime 0 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=202.2.2.89&oldid=2420"