Veiligheidsonderzoek ABN AMRO HomeNet 2.0
Door Bastiaan Bakker en Richard Odekerken
Appendix B: Overzicht van de database tabellen
Appendix B: Overzicht van de database tabellen
ACCOUNT.DB
Field name Size Type
-------------------------------------------------
ACC_ID 4 Autoincrement
ACC_NUMBER 35 Alpha
ACC_NAME 35 Alpha
ACC_USAGE 2 Alpha
ACC_CURCODE 3 Alpha
ACC_SHORTNAME 10 Alpha
ACC_STARTDATE 4 Date
ACC_STARTAMOUNT 8 Number
ACC_LASTBALDATE 4 Date
ACC_LASTBAL 8 Number
ACC_CREAUSR 8 Alpha
ACC_CREADATE 8 Timestamp
ACC_MODIFUSR 8 Alpha
ACC_LASTDATE 8 Timestamp
ACC_ACTIVE 2 Short Int
ASSET.DB
Field name Size Type
-------------------------------------------------
Ass_Code 10 Alpha
Ass_ShortD 10 Alpha
Ass_DescD 40 Alpha
Ass_ShortF 10 Alpha
Ass_DescF 40 Alpha
Ass_ShortE 10 Alpha
Ass_DescE 40 Alpha
Ass_ShortG 10 Alpha
Ass_DescG 40 Alpha
Ass_Creausr 8 Alpha
Ass_Creadate 8 Timestamp
Ass_Modifusr 8 Alpha
Ass_Lastdate 8 Timestamp
BUDGET.DB
Field name Size Type
-------------------------------------------------
BUD_CODE 10 Alpha
BUD_DESC 30 Alpha
BUD_CREAUSR 8 Alpha
BUD_CREADATE 8 Timestamp
BUD_MODIFUSR 8 Alpha
BUD_LASTDATE 8 Timestamp
CURRENCY.DB
Field name Size Type
-------------------------------------------------
CUR_CODE 3 Alpha
CUR_NAME 35 Alpha
CUR_UNIT 8 Number
CUR_RATEOFDAY 8 Number
CUR_DATEDAILYRATE 4 Date
CUR_LASTUPDTEDATE 4 Date
CUR_STATUS 1 Alpha
CUR_CREAUSR 8 Alpha
CUR_CREADATE 8 Timestamp
CUR_MODIFUSR 8 Alpha
CUR_LASTDATE 8 Timestamp
CUR_QUOTTYP 2 Short Int
CUR_TYPUPD 2 Short Int
CUR_DECCOD 2 Short Int
DAP_ACNT.DB
Field name Size Type
-------------------------------------------------
DAP_ID 4 Long Int
DAP_NUMBER 35 Alpha
DAP_NAME 35 Alpha
DAP_SHORTNAME 10 Alpha
DAP_USAGE 2 Alpha
DAP_ACCESS 1 Logical
DAP_USR.DB
Field name Size Type
-------------------------------------------------
DUS_USRIDCODE 16 Alpha
DUS_ACCID 4 Long Int
DUS_PORID 4 Long Int
DUS_ACCESS 1 Logical
DUS_LCKKEY 10 Alpha
DUS_LCKFLG 1 Logical
DUS_CREAUSR 8 Alpha
DUS_CREADATE 8 Timestamp
DUS_MODIFUSR 8 Alpha
DUS_LASTDATE 8 Timestamp
EM_INDEX.DB
Field name Size Type
-------------------------------------------------
EM_CODE 8 Alpha
EM_TITLE 60 Alpha
EM_STATUS 1 Alpha
VIEWED 1 Logical
EM_VALDAT 4 Date
E_MAIL.DB
Field name Size Type
-------------------------------------------------
EMA_SEQNB 4 Long Int
EMA_ENTRYDATE 4 Date
EMA_ENTRYTIME 8 Alpha
EMA_CATEGORY 3 Alpha
EMA_TITLE 80 Alpha
EMA_LINE1 80 Alpha
EMA_LINE2 80 Alpha
EMA_LINE3 80 Alpha
EMA_LINE4 80 Alpha
EMA_LINE5 80 Alpha
EMA_LINE6 80 Alpha
EMA_LINE7 80 Alpha
EMA_ISOLANG 2 Alpha
LAST_NMB.DB
Field name Size Type
-------------------------------------------------
Last_Pay_Number 4 Long Int
Last_Sec_Number 4 Long Int
MAINMENU.DB
Field name Size Type
-------------------------------------------------
MNULBL 20 Alpha
MNUSEQ 2 Alpha
MNUCUR 20 Alpha
MNUITEM 30 Alpha
MNUTYP 2 Alpha
MNUPROCESS 40 Alpha
MNUSIZE 4 Long Int
MNUREGUP 1 Logical
DOWNLOADED 1 Logical
FILENAME 8 Alpha
MIRROR.DB
Field name Size Type
-------------------------------------------------
Mi_Code 1 Alpha
Mi_Source 10 Alpha
Mi_Target 10 Alpha
Mi_SourceOK 1 Logical
Mi_TargetOK 1 Logical
Mi_Key_Src 35 Alpha
Mi_Key_Trg 35 Alpha
ORDER.DB
Field name Size Type
-------------------------------------------------
ORD_CODE 4 Long Int
ORD_PORID 4 Long Int
ORD_SECCODE 12 Alpha
ORD_STATUS 2 Alpha
ORD_TYPE 1 Alpha
ORD_EXPDATE 4 Date
ORD_TRAUNI 1 Alpha
ORD_QUANTITY 8 Number
ORD_PRICELIMIT 8 Number
ORD_OPENCLOSE 1 Alpha
ORD_SECAON 1 Logical
ORD_SETID 8 Alpha
ORD_DATE 4 Date
ORD_OLDSTATUS 2 Alpha
ORD_ERRCOD 10 Alpha
ORD_ERRMSG 70 Alpha
ORD_CREAUSR 8 Alpha
ORD_CREADATE 8 Timestamp
ORD_MODIFUSR 8 Alpha
ORD_LASTDATE 8 Timestamp
ORD_SENDED 1 Alpha
ORD_SETID2 8 Alpha
ORD_LIMCUR 3 Alpha
ORD_AMOCUR 3 Alpha
ORD_UNIT 3 Alpha
ORDER_EX.DB
Field name Size Type
-------------------------------------------------
OEX_TRAREF 16 Alpha
OEX_NUMBER 35 Alpha
OEX_ORDCODE 4 Long Int
OEX_ORDPORID 4 Long Int
OEX_ORDSECCODE 12 Alpha
OEX_CURCODE 3 Alpha
OEX_TRANSDATE 4 Date
OEX_TRANSTIME 4 Time
OEX_SECTYP 3 Alpha
OEX_QUANTITY 8 Number
OEX_UNITYPRICECUR 3 Alpha
OEX_UNITYPRICE 8 Number
OEX_TOTAMOUNTCUR 3 Alpha
OEX_TOTAMOUNT 8 Number
OEX_ORDCONF 3 Alpha
OEX_INTDATE 4 Date
OEX_INTTIME 4 Time
OEX_TYPE 1 Alpha
OEX_CREAUSR 8 Alpha
OEX_CREADATE 8 Timestamp
OEX_MODIFUSR 8 Alpha
OEX_LASTDATE 8 Timestamp
ORDER_TR.DB
Field name Size Type
-------------------------------------------------
OTR_ID 4 Autoincrement
OTR_ORDCODE 4 Long Int
OTR_ORDPORID 4 Long Int
OTR_ORDSECCODE 12 Alpha
OTR_SEQNB 8 Alpha
OTR_TYPE 1 Alpha
OTR_TRANSACTTYPE 8 Alpha
OTR_TRANSACTDATE 4 Date
OTR_CURCODE 3 Alpha
OTR_EFFECTCURR 3 Alpha
OTR_EFFECTAMNT 8 Number
OTR_EFFECTDEBCRED 1 Alpha
OTR_QUANTITY 8 Number
OTR_QUANTITYCURR 3 Alpha
OTR_RATEVALUE 8 Number
OTR_CURRENCYRATE 8 Number
OTR_INTERESTDAY 8 Number
OTR_VALUEDATE 4 Date
OTR_DATATYPE 2 Alpha
OTR_QUANTITYUNITY 3 Alpha
OTR_2NDEFFECTCODE 10 Alpha
OTR_QNTITYDEBCRED 1 Alpha
OTR_BNKTRANSREF 16 Alpha
OTR_CREAUSR 8 Alpha
OTR_CREADATE 8 Timestamp
OTR_MODIFUSR 8 Alpha
OTR_LASTDATE 8 Timestamp
OTR_QUOTTYPE 2 Short Int
OTR_RATCURR 3 Alpha
ORD_CONF.DB
Field name Size Type
-------------------------------------------------
OCO_BNKTRAREF 10 Alpha
OCO_ORDCODE 10 Alpha
OCO_ORDPORID 4 Long Int
OCO_ORDSECCODE 12 Alpha
OCO_CURCODE 3 Alpha
OCO_EXPDATE 4 Date
OCO_EFFECTTYPE 3 Alpha
OCO_QUANTITY 8 Number
OCO_PRICELIMIT 8 Number
OCO_INTDATE 4 Date
OCO_INTTTIME 4 Time
OCO_TRASTA 1 Alpha
OCO_ORDREF 8 Number
OCO_TRATYP 1 Alpha
OCO_CREAUSR 8 Alpha
OCO_CREADATE 8 Timestamp
OCO_MODIFUSR 8 Alpha
OCO_LASTDATE 8 Timestamp
OCO_LIMCUR 3 Alpha
PAYMENT.DB
Field name Size Type
-------------------------------------------------
PAY_NBR 4 Long Int
PAY_STATUS 2 Alpha
PAY_ACCID 4 Long Int
PAY_THICODE 10 Alpha
PAY_RPANBR 4 Long Int
PAY_RPAGROID 8 Alpha
PAY_CREADATES 4 Date
PAY_CREATIME 4 Time
PAY_LASTMODIFDATE 4 Date
PAY_LASTMODIFTIME 4 Time
PAY_TRANSFTYPE 1 Alpha
PAY_URGENT 1 Logical
PAY_INTERNAL 1 Logical
PAY_DEBACCNUM 35 Alpha
PAY_BENNAME 35 Alpha
PAY_BENCITY 35 Alpha
PAY_BENACCNUM 35 Alpha
PAY_AMOUNT 8 Number
PAY_CNVTEDAMOUNT 8 Number
PAY_INTAMOUNT 8 Number
PAY_DECIMALAMOUNT 8 Number
PAY_CURDEBACC 3 Alpha
PAY_REFNUM 16 Alpha
PAY_DESC1 70 Alpha
PAY_DESC2 70 Alpha
PAY_DESC3 70 Alpha
PAY_EXECUTIONDATE 4 Date
PAY_ORIGIN 2 Alpha
PAY_REJECTCODE 10 Alpha
PAY_REJECTTEXT 70 Alpha
PAY_OLDSTATUS 8 Alpha
PAY_VALUEDATE 4 Date
PAY_ACCEPTGIROCODE 2 Alpha
PAY_FORMCHAR 16 Alpha
PAY_BUDCODE 10 Alpha
PAY_CREAUSR 8 Alpha
PAY_CREADATE 8 Timestamp
PAY_MODIFUSR 8 Alpha
PAY_LASTDATE 8 Timestamp
PAY_SENDED 1 Alpha
PAY_SETID 8 Alpha
PAY_AMOUNTCUR 3 Alpha
PAYM_SET.DB
Field name Size Type
-------------------------------------------------
PAS_ID 8 Alpha
PAS_NVBHASH 24 Alpha
PAS_DTM 12 Alpha
PORT.DB
Field name Size Type
-------------------------------------------------
POR_ID 4 Autoincrement
POR_CODE 10 Alpha
POR_NUMBER 35 Alpha
POR_NAME 35 Alpha
POR_USAGE 2 Alpha
POR_SHORTNAME 8 Alpha
POR_ORIGIN 1 Alpha
POR_CREAUSR 8 Alpha
POR_CREADATE 8 Timestamp
POR_MODIFUSR 8 Alpha
POR_LASTDATE 8 Timestamp
PORT_SEC.DB
Field name Size Type
-------------------------------------------------
PSE_ID 4 Autoincrement
PSE_PORID 4 Long Int
PSE_SECCODE 12 Alpha
PSE_DATE 4 Date
PSE_QNTTYP 3 Alpha
PSE_QNTUNI 5 Alpha
PSE_QUANTITY 8 Number
PSE_QNTDC 1 Alpha
PSE_PRICUR 3 Alpha
PSE_UNITYPRICE 8 Number
PSE_EFFECTRATE 8 Number
PSE_CURCODE 3 Alpha
PSE_VALSEC 8 Number
PSE_VALDC 1 Alpha
PSE_INFO 210 Alpha
PSE_TYPE 1 Alpha
PSE_SECSTA 2 Alpha
PSE_CREAUSR 8 Alpha
PSE_CREADATE 8 Timestamp
PSE_MODIFUSR 8 Alpha
PSE_LASTDATE 8 Timestamp
RATES.DB:
Field name Size Type
-------------------------------------------------
RAT_SECCODE 12 Alpha
RAT_DATE 4 Date
RAT_LOW 8 Number
RAT_HIGH 8 Number
RAT_CLOSERATEVALUE 8 Number
RAT_CURR 3 Alpha
RAT_VOL 8 Number
RAT_TYPE 1 Alpha
RAT_CREAUSR 8 Alpha
RAT_CREADATE 8 Timestamp
RAT_MODIFUSR 8 Alpha
RAT_LASTDATE 8 Timestamp
RECURPAY.DB
Field name Size Type
-------------------------------------------------
RPA_NBR 4 Long Int
RPA_GROID 8 Alpha
RPA_THICODE 10 Alpha
RPA_ACCID 4 Long Int
RPA_STATUS 2 Alpha
RPA_CREATIME 4 Time
RPA_LASTMODIFDATE 4 Date
RPA_LASTMODIFTIME 4 Time
RPA_PAYMNTTYPE 2 Alpha
RPA_DEBACCCUR 3 Alpha
RPA_DEBACCNB 35 Alpha
RPA_BENCODE 10 Alpha
RPA_BENNAME 35 Alpha
RPA_BENCITY 35 Alpha
RPA_BENACCNB 35 Alpha
RPA_AMOUNT 8 Number
RPA_CNVERTEDAMNT 8 Number
RPA_DESCRIPTION1 70 Alpha
RPA_DESCRIPTION2 70 Alpha
RPA_DESCRIPTION3 70 Alpha
RPA_EXECUTIONDATE 4 Date
RPA_LASTPAYDATE 4 Date
RPA_NEXTPAYDATE 4 Date
RPA_PERIODE 8 Number
RPA_BEGIN 4 Date
RPA_END 4 Date
RPA_INTAMOUNT 8 Number
RPA_DECAMOUNT 8 Number
RPA_BUDCODE 10 Alpha
RPA_CREAUSR 8 Alpha
RPA_CREADATE 8 Timestamp
RPA_MODIFUSR 8 Alpha
RPA_LASTDATE 8 Timestamp
RPA_TRSFERCUR 3 Alpha
REGION.DB
Field name Size Type
-------------------------------------------------
Reg_Code 10 Alpha
Reg_DescD 40 Alpha
Reg_ShortD 10 Alpha
SEC.DB
Field name Size Type
-------------------------------------------------
SEC_CODE 12 Alpha
SEC_NAME 40 Alpha
SEC_EFFECTSHORTNAM 35 Alpha
SEC_STYCODE 10 Alpha
SEC_CURCODE 3 Alpha
SEC_ASSCODE 3 Alpha
SEC_REGCODE 3 Alpha
SEC_SCTCODE 3 Alpha
SEC_SMALLCOUPON 8 Number
SEC_EMISSIONDATE 4 Date
SEC_PROVINT 8 Number
SEC_DRAWBONDS1DATE 4 Date
SEC_DRAWLASTDATE 4 Date
SEC_CALLPUT 1 Alpha
SEC_PIECEBYCONTR 8 Number
SEC_EXECPRICE 8 Number
SEC_EXPDATE 4 Date
SEC_ATTEFFECT 12 Alpha
SEC_SERIE 4 Alpha
SEC_ORIGIN 1 Alpha
SEC_QUOTYPE 3 Alpha
SEC_CREAUSR 8 Alpha
SEC_CREADATE 8 Timestamp
SEC_MODIFUSR 8 Alpha
SEC_LASTDATE 8 Timestamp
SECTOR.DB
Field name Size Type
-------------------------------------------------
SCT_CODE 10 Alpha
SCT_SHORTD 10 Alpha
SCT_DESCD 40 Alpha
SEC_SET.DB
Field name Size Type
-------------------------------------------------
SSE_ID 8 Alpha
SSE_NVBHASH 24 Alpha
SSE_DTM 12 Alpha
SEC_STAT.DB
Field name Size Type
-------------------------------------------------
SST_CODE 3 Alpha
SST_SHORTD 10 Alpha
SST_DESCD 40 Alpha
SST_CREAUSR 8 Alpha
SST_CREADAT 8 Timestamp
SST_MODIFUSR 8 Alpha
SST_LASTDATE 8 Timestamp
SEC_TYPE.DB
Field name Size Type
-------------------------------------------------
STY_CODE 10 Alpha
STY_SHORTF 10 Alpha
STY_DESCF 40 Alpha
STY_SHORTD 10 Alpha
STY_DESCD 40 Alpha
STY_SHORTE 10 Alpha
STY_DESCE 40 Alpha
STY_SHORTG 10 Alpha
STY_DESCG 40 Alpha
STY_CREAUSR 8 Alpha
STY_CREADATE 8 Timestamp
STY_MODIFUSR 8 Alpha
STY_LASTDATE 8 Timestamp
SERIE.DB
Field name Size Type
-------------------------------------------------
SER_Code 4 Alpha
SER_Name 30 Alpha
STA_GLOB.DB
Field name Size Type
-------------------------------------------------
SGL_ACCID 4 Long Int
SGL_CLBALDATE 4 Date
SGL_EXTID 4 Long Int
SGL_STNB 8 Number
SGL_OPBALDATE 4 Date
SGL_OPBALMNT 8 Number
SGL_OPSIGNMNT 1 Alpha
SGL_CLBALMNT 8 Number
SGL_CLSIGNMNT 1 Alpha
SGL_STATBANKID 35 Alpha
SGL_TYPEOFINPUT 1 Alpha
SGL_CREAUSR 8 Alpha
SGL_CREADATE 8 Timestamp
SGL_MODIFUSR 8 Alpha
SGL_LASTDATE 8 Timestamp
SGL_CLBALAMNTCUR 3 Alpha
STA_MOVE.DB
Field name Size Type
-------------------------------------------------
SMO_SGLEXTID 4 Long Int
SMO_SEQUENCENB 4 Long Int
SMO_SGLACCID 4 Long Int
SMO_BKDATE 4 Date
SMO_SGLSTNB 8 Number
SMO_BUDCODE 10 Alpha
SMO_VALDAT 4 Date
SMO_AMNT 8 Number
SMO_AMOUNTSIGN 1 Alpha
SMO_LINE0 24 Alpha
SMO_LINE1 65 Alpha
SMO_LINE2 65 Alpha
SMO_LINE3 65 Alpha
SMO_LINE4 65 Alpha
SMO_LINE5 65 Alpha
SMO_LINE6 65 Alpha
SMO_CREAUSER 8 Alpha
SMO_CREADATE 8 Timestamp
SMO_MODIFUSR 8 Alpha
SMO_LASTDATE 8 Timestamp
SMO_AMOCUR 3 Alpha
THIRD_PT.DB
Field name Size Type
-------------------------------------------------
THI_CODE 10 Alpha
THI_BENNAME 35 Alpha
THI_CITY 35 Alpha
THI_ACCNUM 35 Alpha
THI_BUDCODE 10 Alpha
THI_CREAUSR 8 Alpha
THI_CREADATE 8 Timestamp
THI_MODIFUSR 8 Alpha
THI_LASTDATE 8 Timestamp
USERFILE.DB
Field name Size Type
-------------------------------------------------
USR_IDCODE 16 Alpha
USR_PASSWORD 25 Alpha
USR_LGTHPASSW 4 Long Int
USR_NAME 35 Alpha
USR_SHORTC 3 Alpha
USR_ISOLANG 2 Alpha
USR_RETRYCOUNTER 8 Number
USR_LASTLOGONDATE 4 Date
USR_LASTLOGONTIME 4 Time
USR_LASTMODIFDATE 4 Date
USR_LASTMODIFTIME 4 Time
USR_OLDPASSW1 25 Alpha
USR_OLDPASSW2 25 Alpha
USR_LASTPASSMODDAT 4 Date
USR_LASTPASSMODTIM 4 Time
USR_PASSVALIDCYCLE 8 Number
USR_STATUS 1 Alpha
USR_VIOLATIONSTATU 40 Alpha
USR_LOCK 8 Number
USR_LSTMSGVIEWED 8 Number
USR_LSTCOMPMSGVIEW 8 Number
USR_COLOR 10 Alpha
USR_BEEPENABLE 1 Alpha
USR_TOKENNUMBER 8 Alpha
USR_AUTLEV 1 Alpha
USR_AGENT 1 Alpha
USR_PRR 3 Alpha
USR_SYS 1 Alpha
USR_CREAUSR 8 Alpha
USR_CREADATE 8 Timestamp
USR_MODIFUSR 8 Alpha
USR_LASTDATE 8 Timestamp
USERSET.DB
Field name Size Type
-------------------------------------------------
UST_USRIDCODE 16 Alpha
UST_ACCID 4 Long Int
UST_PORID 4 Long Int
UST_PRODUCTCODE 10 Alpha
UST_CREAUSR 16 Alpha
UST_CREADATE 8 Timestamp
UST_MODIFUSR 8 Alpha
UST_LASTDATE 8 Timestamp
|
