A

From SPGC Document Wiki

Revision as of 15:38, 4 August 2016 by Ojt2 (Talk | contribs)

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

Jump to: navigation, search

Contents

1 pdv2013
2 secthd
3 syslogs
4 tblclrlog
5 un2013
6 un2014
7 un2015
8 un2016
9 unibio_bk

pdv2013

secthd

pdv2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDVCOFF	varchar	3	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	7	No	No	No
PDVDAYS	double	15,2	No	No	No
PDVADFD	datetime	0	No	No	No
PDVADTD	datetime	0	No	No	No
PDVSFDT	datetime	0	No	No	No
PDVSTDT	datetime	0	No	No	No

secthd
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
DEPT_CODE	varchar	25	No	No	No
SECT_CODE	varchar	25	No	No	No
SECT_NAME	varchar	150	No	No	No

syslogs

syslogs
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
LOG_USER	varchar	25	No	Yes	No
LOG_MODULE	varchar	25	No	Yes	No
LOG_DATE	datetime	0	No	Yes	No
LOG_ENUMB	varchar	25	No	Yes	No
LOG_FIELD	varchar	25	No	Yes	No
LOG_OLDVAL	varchar	25	No	Yes	No
LOG_NEWVAL	varchar	25	No	Yes	No
LOG_SQLEXEC	longtext	0	No	No	No
LOG_CHANGE	varchar	25	No	Yes	No
LOG_IPADDR	varchar	25	No	Yes	No
LOG_PRNT	varchar	25	No	Yes	No

tblclrlog

tblclrlog
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	20	Yes	Yes	No
LOG_ENUMB	varchar	25	No	No	No
LOG_RCP	varchar	150	No	No	No
LOG_RCPID	datetime	20	No	No	No
LOG_SENDER	varchar	150	No	No	No
LOG_RCPDVIEW	datetime	0	No	No	No
LOG_RCPCLEARED	varchar	1	No	No	No
LOG_RCPCLEARED_DATE	datetime	0	No	No	No
LOG_RCPREMK	longtext	0	No	No	No
LOG_USER	varchar	50	No	No	No
LOG_IDENC	varchar	50	No	No	No
LOG_SEND_DATE	datetime	0	No	No	No
LOG_DATE_APP	date	0	No	No	No
LOG_MODULE	varchar	25	No	No	No

un2013

un2013
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
UNTNUMB	varchar	15	No	Yes	No
UNTDATE	datetime	0	No	Yes	No
UNTSTME	varchar	4	No	Yes	No
UNTETME	varchar	4	No	Yes	No
UNTPURP	longtext	0	No	Yes	No
UNTIAPP	varchar	1	No	Yes	No
UNTIAPPDT	datetime	0	No	Yes	No
UNTIAPPDTVW	datetime	0	No	No	No
UNTIAPPDISP	longtext	0	No	Yes	No
UNTFAPP	varchar	1	No	Yes	No
UNTFAPPDT	datetime	0	No	Yes	No
UNTFAPPDTVW	datetime	0	No	Yes	No
UNTFAPPDISP	longtext	0	No	Yes	No
UNTDTFLD	datetime	0	No	Yes	No
UNTRNUMB	varchar	20	No	No	No
UNTFNUMB	varchar	20	No	No	No
UNTCOCD	varchar	1	No	Yes	No
UNTSECCD	varchar	20	No	Yes	No
UNTDEPT	varchar	20	No	Yes	No
UNTSAVED	varchar	1	No	Yes	No
UNTTRANS	varchar	1	No	Yes	No

un2014

un2014
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
UNTNUMB	varchar	15	No	Yes	No
UNTDATE	datetime	0	No	Yes	No
UNTSTME	varchar	4	No	Yes	No
UNTETME	varchar	4	No	Yes	No
UNTPURP	longtext	0	No	Yes	No
UNTIAPP	varchar	1	No	Yes	No
UNTIAPPDT	datetime	0	No	Yes	No
UNTIAPPDTVW	datetime	0	No	No	No
UNTIAPPDISP	longtext	0	No	Yes	No
UNTFAPP	varchar	1	No	Yes	No
UNTFAPPDT	datetime	0	No	Yes	No
UNTFAPPDTVW	datetime	0	No	Yes	No
UNTFAPPDISP	longtext	0	No	Yes	No
UNTDTFLD	datetime	0	No	Yes	No
UNTRNUMB	varchar	20	No	No	No
UNTFNUMB	varchar	20	No	No	No
UNTCOCD	varchar	1	No	Yes	No
UNTSECCD	varchar	20	No	Yes	No
UNTDEPT	varchar	20	No	Yes	No
UNTSAVED	varchar	1	No	Yes	No
UNTTRANS	varchar	1	No	Yes	No

un2015

un2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
UNTNUMB	varchar	15	No	Yes	No
UNTDATE	datetime	0	No	Yes	No
UNTSTME	varchar	4	No	Yes	No
UNTETME	varchar	4	No	Yes	No
UNTPURP	longtext	0	No	Yes	No
UNTIAPP	varchar	1	No	Yes	No
UNTIAPPDT	datetime	0	No	Yes	No
UNTIAPPDTVW	datetime	0	No	No	No
UNTIAPPDISP	longtext	0	No	Yes	No
UNTFAPP	varchar	1	No	Yes	No
UNTFAPPDT	datetime	0	No	Yes	No
UNTFAPPDTVW	datetime	0	No	Yes	No
UNTFAPPDISP	longtext	0	No	Yes	No
UNTDTFLD	datetime	0	No	Yes	No
UNTRNUMB	varchar	20	No	No	No
UNTFNUMB	varchar	20	No	No	No
UNTCOCD	varchar	1	No	Yes	No
UNTSECCD	varchar	20	No	Yes	No
UNTDEPT	varchar	20	No	Yes	No
UNTSAVED	varchar	1	No	Yes	No
UNTTRANS	varchar	1	No	Yes	No

un2016

un2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	11	Yes	Yes	No
UNTNUMB	varchar	15	No	Yes	No
UNTDATE	datetime	0	No	Yes	No
UNTSTME	varchar	4	No	Yes	No
UNTETME	varchar	4	No	Yes	No
UNTPURP	longtext	0	No	Yes	No
UNTIAPP	varchar	1	No	Yes	No
UNTIAPPDT	datetime	0	No	Yes	No
UNTIAPPDTVW	datetime	0	No	No	No
UNTIAPPDISP	longtext	0	No	Yes	No
UNTFAPP	varchar	1	No	Yes	No
UNTFAPPDT	datetime	0	No	Yes	No
UNTFAPPDTVW	datetime	0	No	Yes	No
UNTFAPPDISP	longtext	0	No	Yes	No
UNTDTFLD	datetime	0	No	Yes	No
UNTRNUMB	varchar	20	No	No	No
UNTFNUMB	varchar	20	No	No	No
UNTCOCD	varchar	1	No	Yes	No
UNTSECCD	varchar	20	No	Yes	No
UNTDEPT	varchar	20	No	Yes	No
UNTSAVED	varchar	1	No	Yes	No
UNTTRANS	varchar	1	No	Yes	No

unibio_bk

unibio_bk
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FPENUMB	varchar	10	Yes	Yes	No
FPID	varchar	10	No	No	No
FPDATE	datetime	0	No	No	No
FPIO	varchar	5	No	No	No
OLDBARID	varchar	20	No	No	No

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