Difference between revisions of "Mypaydb"

From SPGC Document Wiki
Jump to: navigation, search
(→‎bankdtl)
Line 701: Line 701:
 
{| class="wikitable" \
 
{| class="wikitable" \
 
!colspan="7" | bankdtl  
 
!colspan="7" | bankdtl  
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|recid
 +
|int
 +
|25
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|BNKBKCD
 +
|Varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKCOCD
 +
|Varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKPCLASS
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKACCTTYPE
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKACCT
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKACCT_13MO
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKCONTPERSON
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKCONTPOSITION
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKADDR
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKDISBCODE
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|BNKDISBNAME
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|RPT_CHECK_REVIEWED
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|RPT_CHECK_REVIEWED_POSI
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|RPT_NOTED
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|RPT_NOTED_POSI
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|RPT_APPROVED
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|RPT_APPROVED_POSI
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|RPT_FINAL_APPROVED
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|-
 +
|RPT_FINAL_APPROVED_POSI
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==birtax2316_2016==
 +
{| class="wikitable" \
 +
!colspan="7" | birtax2316_2016
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name

Revision as of 17:42, 23 June 2016

ahs2016

ahs2016
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

alphalist_log

alphalist_log
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB Varchar 15 No No No
EMPLNAM Varchar 30 No No No
EMPFNAM Varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPTINO varchar 30 No No No
EMPTXCD varchar 2 No No No
EMPTAXEXEM double 15,2 No No No
EMPHDTE date 0 No No No
SEPDATE date 0 No No No
EMPBDTE date 0 No No No
EMP13TH double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPUNION double 15,2 No No No
EMPAMEDE double 15,2 No No No
EMPASSSE double 15,2 No No No
EMPAGROSS double 15,2 No No No
EMPAPIBE double 15,2 No No No
EMPATAXC double 15,2 No No No
EMPATAXCDEC double 15,2 No No No
EMPSEPA varchar 1 No No No
EMPCLASSM varchar 10 No No No
TXYMNGR double 15,2 No No No
TXYTXRT double 15,2 No No No
TXYTXAD double 15,2 No No No
TAXI double 15,2 No No No
TAXEXEM double 15,2 No No No
GOV_CONTRIB double 19,2 No No No
EMPBPAY double 15,2 No No No
AHSTAXW double 15,2 No No No
EMPBALL double 15,2 No No No
TAXDUE double 15,2 No No No
EMPDPCD varchar 30 No No No
EMP13THTAX double 15,2 No No No
MWE varchar 1 No No No
MWESAL double 19,2 No Yes No
_dateproc datetime 0 No Yes No

alphalist_log_mwe

alphalist_log_mwe
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB Varchar 15 No No No
EMPLNAM varchar 30 No No No
EMPFNAM varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPTINO varchar 30 No No No
EMPTXCD varchar 2 No No No
EMPTAXEXEM double 15,2 No No No
EMPHDTE varbinary 10 No No No
EMPSEPADTE date 0 No No No
EMPBDTE date 15 No No No
EMP13TH double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPUNION double 15,2 No No No
EMPAMEDE double 15,2 No No No
EMPASSSE double 15,2 No No No
EMPAGROSS double 15,2 No No No
EMPAPIBE double 15,2 No No No
EMPATAXC double 15,2 No No No
EMPATAXCDEC double 15,2 No No No
EMPSEPA varchar 1 No No No
EMPCLASSM varchar 10 No No No
TXYMNGR double 15,2 No No No
TXYTXRT double 15,2 No No No
TXYTXAD double 15,2 No No No
TAXI double 15,2 No No No
TAXEXEM double 15,2 No No No
GOV_CONTRIB double 19,2 No No No
EMPBPAY double 15,2 No No No
EMPBALL double 15,2 No No No
TAXDUE double 15,2 No No No
EMPREGION varchar 15 No No No
HOLPAY double 15,2 No No No
OTPAY double 15,2 No No No
NSDPAY double 15,2 No No No
RATEDAY double 15,2 No No No
RATEMO double 19,2 No No No
RATEYR double 15,2 No No No
EMPDPCD varchar 30 No No No
MWEGROSS double 15,2 No No No
MWESAL double 15,2 No Yes No
MWEFLAG varchar 1 No No No
DATEPROC datetime 0 No No No

attlogs_upld

attlogs_upld
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
ATTL_USER varchar 25 No No No
ATTL_FILE varchar 100 No No No
ATTL_DATE datetime 0 No No No
ATTL_OFILE varchar 100 No No No
ATTL_RMARK varchar 25 No No No

bankdtl

bankdtl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 No Yes No
BNKBKCD Varchar 3 No No No
BNKCOCD Varchar 25 No No No
BNKPCLASS varchar 25 No No No
BNKACCTTYPE varchar 25 No No No
BNKACCT varchar 25 No No No
BNKACCT_13MO varchar 25 No No No
BNKCONTPERSON varchar 150 No No No
BNKCONTPOSITION varchar 150 No No No
BNKADDR varchar 150 No No No
BNKDISBCODE varchar 15 No No No
BNKDISBNAME varchar 150 No No No
RPT_CHECK_REVIEWED varchar 150 No No No
RPT_CHECK_REVIEWED_POSI varchar 150 No No No
RPT_NOTED varchar 150 No No No
RPT_NOTED_POSI varchar 150 No No No
RPT_APPROVED varchar 150 No No No
RPT_APPROVED_POSI varchar 150 No No No
RPT_FINAL_APPROVED varchar 150 No No No
RPT_FINAL_APPROVED_POSI varchar 150 No No No

birtax2316_2016

birtax2316_2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 No Yes No
BNKBKCD Varchar 3 No No No
BNKCOCD Varchar 25 No No No
BNKPCLASS varchar 25 No No No
BNKACCTTYPE varchar 25 No No No
BNKACCT varchar 25 No No No
BNKACCT_13MO varchar 25 No No No
BNKCONTPERSON varchar 150 No No No
BNKCONTPOSITION varchar 150 No No No
BNKADDR varchar 150 No No No
BNKDISBCODE varchar 15 No No No
BNKDISBNAME varchar 150 No No No
RPT_CHECK_REVIEWED varchar 150 No No No
RPT_CHECK_REVIEWED_POSI varchar 150 No No No
RPT_NOTED varchar 150 No No No
RPT_NOTED_POSI varchar 150 No No No
RPT_APPROVED varchar 150 No No No
RPT_APPROVED_POSI varchar 150 No No No
RPT_FINAL_APPROVED varchar 150 No No No
RPT_FINAL_APPROVED_POSI varchar 150 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mypaydb&oldid=865"