招商银行上海分行1Word文档下载推荐.docx
- 文档编号:20223152
- 上传时间:2023-01-21
- 格式:DOCX
- 页数:265
- 大小:77.85KB
招商银行上海分行1Word文档下载推荐.docx
《招商银行上海分行1Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《招商银行上海分行1Word文档下载推荐.docx(265页珍藏版)》请在冰豆网上搜索。
字段类型
字段描述
键
空
LIACNO
char(13)
ACNO
P
NO
LIBRNO
char
(2)
BRANCHNO.
LILONO
char(8)
LOANNO.
LIDBNO
LICYNO
CURRENCYNO.
LIACIT
char(5)
LIMHNO
DECIMAL(3,0)
NUMBEROFMONTH
LILMSD
date
STARTDATE
LIIVDT
VALUEDATE
LILMED
ENDDATE
LIINRT
DECIMAL(11,7)
INTERESTRATE
LIFNRT
LIDBBL
DECIMAL(13,2)
DEBTONBONDBALANCE
LIOIUA
DEBTONBONDAMOUNT
LIO2UA
LIOIPD
LIO2PD
LIOITO
DEBTONBONDTODAY
LIO2TO
LILOPR
char(10)
LOANOPERATER
LIDBST
char(4)
LIECQT
ECONOMICQUATILITY
LITRAD
TRADEQUATILITY
LIGRTP
GRANTTYPE
LILOQT
char
(1)
LOANQUATILITY
LIDEFR
DEFRQUATILITY
LILOID
TRADELOID
LISP80
char(80)
SPECAIL80
T_DATE
DATE
CURRENTDATE
T_WEEK
SMALLINT
T_MONTH
T_QUARTER
完整性约束:
约束类型
约束定义
索引定义:
索引名
索引定义
2.DW-借据表
DW_AS400_LOKHJLP
3.帐户表
帐户表。
AS400_ACACMSP
导入方式:
AMBRNO
BRANCHNUMBER
AMMMCD
char(15)
MEMORIZATIONCODE
AMACNO
ACCOUNTNO.
AMACCG
char
(1),
ACCOUNTCATEGORY
AMACSF
ACCOUNTSUFFIX
AMACNM
VARCHAR(42),
ACCOUNTNAME
AMCLNO
CLIENTNUMBER
AMCYNO
Char
(2)
AMACIT
ACCOUNTITEM
AMACTP
char(3)
ACCOUNTTYPE
AMEQLV
ENQUIRYLEVEL
AMEYLV
ENTRYLEVEL
AMACRD
ACCOUNTRECORDS
AMMHNO
AMTFCD
TRANSFERA/CCODE
AMTFDT
AMTFAC
TRANSFERA/CNO.
AMTFSP
SPECAILCONDITION10
AMCRNO
CONTRACTNUMBER
AMEYDT
LASTENTRYDATE
AMRFNO
REFERENCENUMBER
AMVLDT
AMMUDT
MATURITYDATE
AMOPDT
OPENEDDATE
AMMTDT
MAINTAINEDDATE
AMCLDT
CLOSEDDATE
AMUSID
char(6)
USERID.
AMSTCD
RECORDSTATUS
AMACDY
DECIMAL(5,0)
NUMBEROFDAYFORACCOUNT
AMBLYR
BALANCEFORENDOFYEAR
AMBLPR
PREVIOUSBALANCE
AMBLAV
AVAILBLEBALANCE
AMBLHO
HOLDINGBALANCE
AMBLBK
BOOKEDBALANCE
AMAUDY
DAYSNUMBER
AMAUAM
DECIMAL(15,2)
ACCRUEDAMOUNTS
AMAUQT
QUARTERACCRUEDAMOUNTS
AMAMRS
RESERVEDAMOUNT
AMAMCR
CREDITAMOUNT
AMITCR
CREDITITEMS
AMAMDR
DEBITAMOUNT
AMITDR
DEBITITEMS
AMTXCF
VARCHAR(22)
CERTIFICATETEXT
AMPSWD
PASSWORDNUMBER
AMSP80
SPECAILCONDITION80
AMSAC1
STATISTICSCODE1
AMSAC2
STATISTICSCODE2
AMSAC3
STATISTICSCODE3
AMSAC4
STATISTICSCODE4
AMSAC5
STATISTICSCODE5
AMSAC6
STATISTICSCODE6
AMSAC7
STATISTICSCODE7
AMSAC8
STATISTICSCODE8
AMLMWA
WARNINGLIMIT
AMLMOV
OVERDRAFLIMIT
AMLMSD
EFFECTIVEDATE
AMLMED
ENDOFDATE
AMINCD
INTERESTCODE
AMINTP
INTERESTTYPE
AMINRC
CRINTERESTRATE
AMINRD
DRINTERESTRATE
AMINAC
DECIMAL(15,7)
INTERESTCRACCRUED
AMINAD
INTERESTDRACCRUED
AMINJT
ADJUSTMENTDATE
AMINJC
CRINTERESTADJUSTMENT
AMINJD
DRINTERESTADJUSTMENT
AMINAM
INTERESTAMOUNT
AMINEY
INTERESTENTRYDATE
AMINVL
AMINTR
INTERESTTRANSFERCODE
AMINTA
INTERESTTRANSFERA/C
AMINUY
INTACCRUEDDAYS
AMINUA
INTACCRUEDAMOUNTS
AMINSP
AMSMCD
STATEMENTCODE
AMSMTP
STATEMENTTYPE
AMSMSP
AMPTCD
PRINTEDCODE
AMPTBL
PRINTEDBALANCE
AMPTPG
PRINTEDPAGES
AMPTLN
PRINTEDLINES
AMPTUN
UNPRINTEDNUMBER
AMPTRF
AMPTDT
PRINTEDDATE
4.DW_帐户表
DW_AS400_ACACMSP
DECIMAL(8,0)
5.月积数表
月积数文件。
AS400_ZAAVBLP
按年备份Append
Replace
ZAACNO
ZABRNO
ZAMMCD
ZACYNO
ZAACIT
ZAACNM
varchar(42)
ZAACTP
ZASP80
ZASTCD
ZAAU01
decimal(15,2)
ZAAU02
ZAAU03
ZAAU04
ZAAU05
ZAAU06
ZAAU07
ZAAU08
ZAAU09
ZAAU10
ZAAU11
ZAAU12
ZAAUTO
ZABLAV
decimal(13,2)
ZAEMNO
ZABRCG
ZABLBS
dec(13,2)
ZADTCG
ZAAUCG
ZABLCG
ZABRRV
ZAAURV
ZABLRV
ZABLPR
ZAINRC
decimal(11,7)
ZAINRD
ZAINTP
T_YEAR
6.DW_月积数表
DW_AS400_ZAAVBLP
ZAAU
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 招商银行 上海分行
![提示](https://static.bdocx.com/images/bang_tan.gif)