202.2.2.89

From SPGC Document Wiki

Revision as of 15:39, 4 August 2016 by Ojt1 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

Contents

1 paysliplog
2 pd2014
3 pd2015
4 pdm_essi2013
5 pdm_essi2014
6 pd2016
7 pdm_essi2015
8 pdm_essi2016
9 pdm_sppe2013
10 pdm_sppe2014
11 pdm_sppe2015
12 pdm_sppe2016
13 pdv2013

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	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

pdm_essi2013

pdm_essi2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	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	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_essi2014

pdm_essi2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	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	double	15,2	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
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

pdm_essi2015

pdm_essi2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
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

pdm_essi2016

pdm_essi2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	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	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_sppe2013

pdm_sppe2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	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	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_sppe2014

pdm_sppe2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	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	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_sppe2015

pdm_sppe2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	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	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_sppe2016

pdm_sppe2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	30	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	double	15,2	No	No	No
PDMSTDT	datetime	0	No	No	No

pdv2013

pdv2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDVCOFF	varchar	30	No	No	No
PDVFDTE	datetime	0	No	No	No
PDVTDTE	datetime	0	No	No	No
PDVPOST	varchar	7	No	No	No
PDVAFDT	datetime	0	No	No	No
PDVATDT	datetime	0	No	No	No
PDVDAYS	double	15,2	No	No	No
PDVADFD	datetime	0	No	No	No
PDVADTD	datetime	0	No	No	No
PDVSFDT	double	15,2	No	No	No
PDVSTDT	datetime	0	No	No	No

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=202.2.2.89&oldid=2479"