Difference between revisions of "Myleave"

From SPGC Document Wiki
Jump to: navigation, search
Line 97: Line 97:
 
|varchar
 
|varchar
 
|25
 
|25
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==ccback==
 +
{| class="wikitable" \
 +
!colspan="7" | ccback
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|AHSNUMB
 +
|Varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|AHSGPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|AHSALLO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|AHS13MO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|AHSSLVL
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|AHSSVLR
 +
|double
 +
|15,2
 +
|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:00, 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
AHSNUMB Varchar 15 No No No
AHSGPAY double 15,2 No No No
AHSALLO double 15,2 No No No
AHS13MO double 15,2 No No No
AHSSLVL double 15,2 No No No
AHSSVLR double 15,2 No No No
AHSBONS double 15,2 No No No
AHSTAXD double 15,2 No No No
AHSTAXW double 15,2 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myleave&oldid=2395"