Difference between revisions of "202.2.2.89"

From SPGC Document Wiki
Jump to: navigation, search
(→‎pd2014)
Line 57: Line 57:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|Id
+
|recid
 
|int
 
|int
 
|11
 
|11
Line 64: Line 64:
 
|No
 
|No
 
|-
 
|-
−
|EmployeeNo
+
|PDMCOCD
 
|varchar
 
|varchar
−
|20
+
|25
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|PayDate
+
|PDMLCCD
−
|date
+
|varchar
−
|0
+
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMCOFF
 +
|varchar
 +
|3
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|DateOpen
+
|PDMFDTE           
 
|datetime
 
|datetime
 
|0
 
|0
 
|No
 
|No
−
|Yes
+
|No
 
|No
 
|No
 
|-
 
|-
−
|IpAddress
+
|PDMPOST
 
|varchar
 
|varchar
−
|50
+
|7
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMAFDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMATDT
 +
|datetime
 +
|25
 +
|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
−
|Yes
 
 
|No
 
|No
 
|}
 
|}

Revision as of 11:30, 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 25 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=2404"