上海银行 新申请的接口.doc

新卡申请表 表名 CP_NACMST 实体类型 Independent 主键 NM_APPL_NO 表或文件功能 Application Master Table (validation:If CORPORATE ID field in basic application is modified from space to non space, check if there is any supplementary application in NACMST and NSUTRN table)如果公司标识从空改成非空，检查是否有副卡申请 字段名 字段含义 数据类型 Null 字段含义(英文） NM_APPL_NO DECIMAL(14, 0) N Application Number NM_BATCH_NO 批次号 DECIMAL(3, 0) Y The application data capture batch number NM_BASIC_CARD_NO 主卡卡号 CHAR(19) Y Basic Cardholder Number NM_SER_CENTRE_CODE 服务中心和机构代码 CHAR(6) Y Servicing Centre or branch code NM_RECOM_CARD_NO 推荐人卡号 CHAR(19) Y The recommender cardholder number NM_RECOM_CARD_NAME 推荐人姓名 CHAR(30) Y The recommender name NM_APPL_SOURCE_CODE 卡申请来源代码 CHAR(15) Y Code indicating the source of the card application. NM_MICROFILM_NO 卡申请影像文件的缩微胶片参考号(如果申请表格存储在缩微胶片) CHAR(6) Y Reference number of microfilm holding image of the card application - if the applications forms are stored in microfilm . NM_TITLE 称呼 CHAR(4) Y Salutation used to address cardholder or applicant. NM_FULLNAME 申请人全名 CHAR(40) Y The full name of the applicant. NM_EMBOSSNAME 磁条或卡面上的凸印名 CHAR(19) Y Name of cardholder to be embossed onto the card and encoded into the magnetic stripe. NM_DOB 申请人出生日期 CHAR(8) Y Birth date of applicant or cardholder. NM_SEX 申请人性别 CHAR(1) Y Indicates gender of applicant or cardholder. NM_ID_TYPE 证件类型 CHAR(1) Y Type of the identification number. NM_NRIC_NO 证件号 CHAR(25) Y Identification number of the applicant. NM_PASSPORT_NO 护照号 CHAR(10) Y Passport Number NM_NATIONALITY 持卡人ISO国家代码(参考CP_CTRYCD表) CHAR(3) Y ISO country code of the nationality of the cardholder . (reference to CP_CTRYCD table ) NM_PR_OF_COUNTRY CHAR(1) Y Code indicating permanent residency status of the cardholder (Yes or No) NM_RESIDENCY_CODE 持卡人居住国家ISO国家代码 CHAR(3) Y ISO Code of the country where the applicant or cardholder resides NM_MARITAL_STATUS 婚姻状态 S - 单身 M - 已婚 W - 寡居 CHAR(1) Y Marital Status eg. S (Single), M (M