Difference between revisions of "Myleave"

From SPGC Document Wiki
Jump to: navigation, search
(→‎ccback)
Line 113: Line 113:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|AHSNUMB
+
|mymodule
−
|Varchar
+
|varchar
−
|15
+
|20
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHSGPAY
+
|myremark
−
|double
+
|varchar
−
|15,2
+
|1
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHSALLO
+
|myuser
−
|double
+
|varchar
−
|15,2
+
|10
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHS13MO
+
|myppdte
−
|double
+
|datetime
−
|15,2
+
|0
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHSSLVL
+
|mydate
−
|double
+
|datetime
−
|15,2
+
|0
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHSSVLR
+
|mycomp
−
|double
+
|varchar
−
|15,2
+
|10
−
|No
+
−
|No
+
−
|No
+
−
|-
+
−
|AHSBONS
+
−
|double
+
−
|15,2
+
−
|No
+
−
|No
+
−
|No
+
−
|-
+
−
|AHSTAXD
+
−
|double
+
−
|15,2
+
−
|No
+
−
|No
+
−
|No
+
−
|-
+
−
|AHSTAXW
+
−
|double
+
−
|15,2
+
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 11:03, 4 August 2016

auditlogs

auditlogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes No
LOG_USER double 15,2 No No No
LOG_MODULE varchar 50 No No No
LOG_DATE datetime 0 No No No
LOG_TBL varchar 50 No No No
LOG_KEYREC varchar 50 No No No
LOG_FIELD varchar 25 No No No
LOG_OLDVAL longtext 0 No No No
LOG_NEWVAL longtext 0 No No No
LOG_CHANGE varchar 25 No No No
LOG_SQLEXEC longtext 0 No No No
LOG_IPADDR varchar 25 No No No
LOG_PRNT varchar 25 No No No

ccback

ccback
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
mymodule varchar 20 No No No
myremark varchar 1 No No No
myuser varchar 10 No No No
myppdte datetime 0 No No No
mydate datetime 0 No No No
mycomp varchar 10 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myleave&oldid=2396"