Difference between revisions of "202.2.2.89"

From SPGC Document Wiki
Jump to: navigation, search
(→‎pd2014)
Line 43: Line 43:
 
|No
 
|No
 
|Yes
 
|Yes
 +
|No
 +
|}
 +
 +
==pd2014==
 +
{| class="wikitable" \
 +
!colspan="7" | pd2014
 +
|-
 +
! style="text-align:left;" | 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
 
|No
 
|}
 
|}

Revision as of 12:44, 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

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