上海银行新申请的接口.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)NApplication Number NM_BATCH_NO批次号DECIMAL(3, 0)YThe application data capture batch number NM_BASIC_CARD_NO主卡卡号CHAR(19)YBasic Cardholder Number NM_SER_CENTRE_CODE服务中心和机构代码CHAR(6)YServicing Centre or branch code NM_RECOM_CARD_NO推荐人卡号CHAR(19)YThe recommender cardholder number NM_RECOM_CARD_NAME推荐人姓名CHAR(30)YThe recommender name NM_APPL_SOURCE_CODE卡申请来源代码CHAR(15)YCode indicating the source of the card application.NM_MICROFILM_NO卡申请影像文件的缩微胶片参考号(如果申请表格存储在缩微胶片)CHAR(6)YReference number of microfilm holding image of the card application - if the applications forms are stored in microfilm .NM_TITLE称呼CHAR(4)YSalutation used to address cardholder or applicant.NM_FULLNAME申请人全名CHAR(40)YThe full name of the applicant.NM_EMBOSSNAME磁条或卡面上的凸印名CHAR(19)YName of cardholder to be embossed onto the card and encoded into the magnetic stripe.NM_DOB申请人出生日期CHAR(8)YBirth date of applicant or cardholder.NM_SEX申请人性别CHAR(1)YIndicates gender of applicant or cardholder.NM_ID_TYPE证件类型CHAR(1)YType of the identification number. NM_NRIC_NO证件号CHAR(25)YIdentification number of the applicant. NM_PASSPORT_NO护照号CHAR(10)YPassport NumberNM_NATIONALITY持卡人ISO国家代码(参考CP_CTRYCD表)CHAR(3)YISO country code of the nationality of the cardholder . (reference to CP_CTRYCD table ) NM_PR_OF_COUNTRY是否永久居住标志CHAR(1)YCode indicating permanent residency status of the cardholder (Yes or No) NM_RESIDENCY_CODE持卡人居住国家ISO国家代码CHAR(3)YISO Code of the country where the applicant or cardholder residesNM_MARITAL_STATUS婚姻状态S - 单身M - 已婚W - 寡居CHAR(1)YMarital Status eg. S (Single), M (Married), W (Widowed) etc. NM_QUALIFICATION学历CHAR(1)YAcademic qualification (reference to CP_QUATBL table) NM_SOCIAL_STATUS社会状况G - 好S - 可疑(拘留过三天)B - 坏(拘留过三天以上)CHAR(1)YValid values are G (Good social status), S (Suspect - 3 days detention by police), B (Bad - More than 3 days detention by police).NM_RELATION_TO_BASIC同持卡人关系CHAR(1)YRelationship between cardholder and its basic cardholder . NM_HOME_ADDR1家庭地址1CHAR(40)YHome address - line 1 NM_HOME_ADDR2家庭地址2CHAR(40)YHome address - line 2 NM_HOME_ADDR3家庭地址3CHAR(40)YHome address - line 3NM_HOME_ADDR4家庭地址4CHAR(40)YHome address - line 4NM_HOME_ADDR5家庭地址5CHAR(40)YHome address - line 5NM_HOME_CITY家庭地址所在城市CHAR(20)YHome address - city NM_HOME_STATE家庭地址所在省/州CHAR(20)YHome address - state NM_HOME_CNTRY_CD家庭地址所在国家CHAR(2)YHome address - country code NM_HOME_POSTCODE家庭地址邮政编码CHAR(10)YHome address - postal code NM_HOME_TELNO家庭电话CHAR(15)YHome address - telephone number NM_HOME_OWNERSHIP居住房屋的所有权,如：1=完全拥有2=贷款购买3=租赁4=同父母同住CHAR(1)YThe ownership of the residence asset . Valid values are 1=Own Fully, 2= Own with morgage, 3= Rent, 4=Parent NM_HOUSE_TYPE房屋类型1=平房2=商品房3=公寓4=错层5=间CHAR(1)YThe type of the residence asset . Valid values are 1= Bungalow, 2= Condo, 3= Apartment 4= Terrace, 5= Room NM_YEAR_THERE居住时间(YYMM)DECIMAL(4, 0)YNumber of Years staying in the residence asset . (YYMM format) NM_LIQUID_ASSET持卡人流动资产总额1： 900,000CHAR(1)YThe value of the asset. Valid values are 1= 900K NM_MOBILE_NO移动电话号码CHAR(15)YHandphone Number.NM_PAGER_NO寻呼机号码CHAR(15)YPager Number. NM_EMAILEmail地址CHAR(40)YEmail addressNM_COMP_NAME公司名CHAR(40)YName of company where applicant or cardholder is employed or ownsNM_COMP_ADDR1公司地址1CHAR(40)YCompany Address - line 1 NM_COMP_ADDR2公司地址2CHAR(40)YCompany Address - line 2NM_COMP_ADDR3公司地址3CHAR(40)YCompany Address - line 3NM_COMP_ADDR4公司地址4CHAR(40)YCompany Address - line 4NM_COMP_ADDR5公司地址5CHAR(40)YCompany Address - line 5NM_COMP_CITY公司地址所在城市CHAR(20)YCompany Address - city NM_COMP_STATE公司地址所在省CHAR(20)YCompany Address - stateNM_COMP_CNTRY_CD公司地址所在国家代码CHAR(2)YCompany Address - country code NM_COMP_POSTCODE公司地址邮政编码CHAR(10)YCompany Address - post code NM_COMP_TELNO公司电话号码CHAR(15)YCompany Address - telephone number NM_COMP_FAXNO公司传真号码CHAR(15)YCompany Address - fax number NM_COMP_DESGN职务CHAR(40)YDescription or position of applicant/cardholder at place of employmentNM_COMP_STRUCTURE公司性质1= 私人2= 股份制3= 政府机关4= 私人有限公司5= 跨国公司.CHAR(1)YValid values are 1= Sole proprietor, 2= Partnership, 3= Government, 4= Private Lmt, 5= MNC.NM_EMP_STABILITY稳定性1=未换过工作2=换过1次工作3=换过2次工作4=超过2次以上工作CHAR(1)YThe stability of the cardholder in terms of number of jobs changed. Valid values are 1= No change, 2= Change job 1 time, 3= Change job 2 times, 4= Change 2 times .NM_MTH_BASIC_SALARY月基本工资DECIMAL(11, 0)YMonthly basic salary .NM_MTH_FIXED_ALLOW月固定补贴DECIMAL(11, 0)YMonthly fix allowance . NM_OTHER_INCOME其它总额DECIMAL(11, 0)YOther income amount. NM_LENGTH_SRV持卡人在该公司的服务期限(YYMM)DECIMAL(4, 0)YNumber of years and months (YY:MM) format) the applicant or cardholder has been employed at the named company.NM_SELF_EMPLOY自雇标志CHAR(1)YCode indicating if card applicant/cardholder is self-employed. (Yes or No) NM_BUSS_SIC公司经营业务CHAR(6)YBusiness Structure - Description of the type of business the applicants or cardholders employer is involved in.NM_EX_EMPLOY_NAME前一个公司名CHAR(40)YPrevious Employer Name NM_EX_EMPLOY_LENGTH_SEV持卡人在前一个公司的服务期限(YYMM)DECIMAL(4, 0)YNumber of years and months (YY:MM) format) the applicant or cardholder has been employed at the previous companyNM_EX_EMPLOY_DESGN在前一个公司职务CHAR(40)YDescription or position of applicant/cardholder at place of previous employment.NM_OTH_LOAN_BANK_1持卡人其它未偿贷款银行名称1CHAR(20)YName of bank where applicant has other outstanding loans - bank 1 NM_OTH_LOAN_TYPE_1持卡人其它未偿贷款类型1CHAR(20)YType of outstanding loans under applicants name - bank 1.NM_OTH_LOAN_AMT_1持卡人其它未偿贷款金额1DECIMAL(11, 0)YAmount of other outstanding loans under applicants name - bank 1 .NM_OTH_LOAN_BANK_2持卡人其它未偿贷款银行名称2CHAR(20)YName of bank where applicant has other outstanding loans - bank 2NM_OTH_LOAN_TYPE_2持卡人其它未偿贷款类型2CHAR(20)YType of outstanding loans under applicants name - bank 2.NM_OTH_LOAN_AMT_2持卡人其它未偿贷款金额2DECIMAL(11, 0)YAmount of other outstanding loans under applicants name - bank 2 .NM_OTH_LOAN_BANK_3持卡人其它未偿贷款银行名称3CHAR(20)YName of bank where applicant has other outstanding loans - bank 3NM_OTH_LOAN_TYPE_3持卡人其它未偿贷款类型3CHAR(20)YType of outstanding loans under applicants name - bank 3.NM_OTH_LOAN_AMT_3持卡人其它未偿贷款金额3DECIMAL(11, 0)YAmount of other outstanding loans under applicants name - bank 3 .NM_CR_CARD_NO_1持卡人持有的其它信用卡卡号1CHAR(19)YCard number of other credit cards already held by the applicant - credit card 1 NM_CR_CARD_LIMIT_1分配给卡1的信用额度DECIMAL(11, 0)YCredit limit assigned to the credit card 1 . NM_CR_CARD_NO_2持卡人持有的其它信用卡卡号2CHAR(19)YCard number of other credit cards already held by the applicant - credit card 2NM_CR_CARD_LIMIT_2分配给卡2的信用额度DECIMAL(11, 0)YCredit limit assigned to the credit card 2.NM_CR_CARD_NO_3持卡人持有的其它信用卡卡号3CHAR(19)YCard number of other credit cards already held by the applicant - credit card 3 .NM_CR_CARD_LIMIT_3分配给卡3的信用额度DECIMAL(11, 0)YCredit limit assigned to the credit card 3.NM_OTH_BANK_CR_STATUS申请人在其它行的信用状态CHAR(1)YThe credit status of the applicant in other bank . The code is user defined. NM_MOTHER_MAIDEN_NAME申请人母亲的婚前姓名CHAR(40)YThe applicants or cardholders mothers name before marriage - usually used as a security feature.NM_SPOUSE_NAME申请人丈夫或妻子的姓名CHAR(40)YName of husband or wife of applicant or cardholder.NM_SPOUSE_NRIC申请人丈夫或妻子的身份证号CHAR(25)YThe identification number of husband or wife of applicant or cardholder. NM_SPOUSE_EMPLOY_NAME申请人丈夫或妻子的公司名CHAR(40)YEmployer name of husband or wife of applicant or cardholderNM_NO_OF_DEPENDENTS抚养人数DECIMAL(2, 0)YNumber of dependents .NM_REL_NAME申请人的亲戚名CHAR(30)YThe relative name of the applicant/cardholder . NM_REL_NRIC亲戚身份证号CHAR(25)YThe identification number of the named relative. NM_REL_DOB亲戚出生日期CHAR(8)YDate of Birth of the named relative. NM_REL_SEX亲戚婚姻状况CHAR(1)YMarital status of the named relative.NM_REL_RELATION_TO_CH与申请人的关系CHAR(1)YRelationship between the relative and the applicant. (NM_REL_DESGN亲戚职务CHAR(20)YDescription of position of the named relative at place of employment.NM_REL_ADDR1亲戚地址1CHAR(40)YRelative Address - line 1 NM_REL_ADDR2亲戚地址2CHAR(40)YRelative Address - line 2NM_REL_ADDR3亲戚地址3CHAR(40)YRelative Address - line 3NM_REL_ADDR4亲戚地址4CHAR(40)YRelative Address - line 4NM_REL_ADDR5亲戚地址5CHAR(40)YRelative Address - line 5NM_REL_CITY亲戚地址所在城市CHAR(20)YRelative Address - City NM_REL_STATE亲戚地址所在省份CHAR(20)YRelative Address - state NM_REL_CNTRY_CD亲戚地址所在国家CHAR(2)YRelative Address - Country Code NM_REL_TELNO亲戚电话号码CHAR(15)YRelative Address - Telephone Number NM_BILL_ADDR_CODE对帐单地址代码H = 家庭地址C = 公司地址1 = 候选帐单地址1 2 = 候选帐单地址2CHAR(1)YBilling Address Code - H = Home Address; C = Company Address; 1 = Alternate Billing Address 1; 2 = Alternate Billing Address 2.NM_CARD_COLLECTION_CD卡片寄送方法CHAR(1)YThe method of card collection - C = Courier; R = Registered; B =Branch NM_CARD_DELIVERY_ADDR_CD卡片寄送地址代码CHAR(1)YCard Delivery Address Code - H = Home Address; C = Company Address; 1 = Alternate Billing Address 1; 2 = Alternate Billing Address 2.NM_LEGAL_ADDR_CD法律地址代码CHAR(1)YLegal Address Code - Legal proceeding letters will be sent to the address defined in this code . NM_ALT_BILL_ADDR1候选地址1行1CHAR(40)YAlternate Address 1 - line 1 NM_ALT_BILL_ADDR2候选地址1行2CHAR(40)YAlternate Address 1 - line 2NM_ALT_BILL_ADDR3候选地址1行3CHAR(40)YAlternate Address 1 - line 3NM_ALT_BILL_ADDR4候选地址1行4CHAR(40)YAlternate Address 1 - line 4NM_ALT_BILL_ADDR5候选地址1行5CHAR(40)YAlternate Address 1 - line 5NM_ALT_BILL_CITY候选地址1所在城市CHAR(20)YAlternate Address 1 - city NM_ALT_BILL_STATE候选地址1所在省份CHAR(20)YAlternate Address 1 - state NM_ALT_BILL_CNTRY_CD候选地址1所在国家CHAR(2)YAlternate Address 1 - country code NM_ALT_BILL_POSTCODE候选地址1邮政代码CHAR(10)YAlternate Address 1 - postal code NM_ALT2_BILL_ADDR1候选地址2行1CHAR(40)YAlternate Address 2 - line 1NM_ALT2_BILL_ADDR2候选地址2行2CHAR(40)YAlternate Address 2 - line 2NM_ALT2_BILL_ADDR3候选地址2行3CHAR(40)YAlternate Address 2 - line 3NM_ALT2_BILL_ADDR4候选地址2行4CHAR(40)YAlternate Address 2 - line 4NM_ALT2_BILL_ADDR5候选地址2行5CHAR(40)YAlternate Address 2- line 5NM_ALT2_BILL_CITY候选地址2所在城市CHAR(20)YAlternate Address 2 - city NM_ALT2_BILL_STATE候选地址2所在省份CHAR(20)YAlternate Address 2 - stateNM_ALT2_BILL_CNTRY_CD候选地址2所在国家CHAR(2)YAlternate Address 2 - county code NM_ALT2_BILL_POSTCODE候选地址2邮政代码CHAR(10)YAlternate Address 2 - post code NM_LOCAL_CREDIT_LIMIT本币信用额度DECIMAL(11, 0)YCredit limit for local currency . NM_FOREIGN_CREDIT_LIMIT外币信用额度：主副卡一同申请检查主卡的外币信用额度，值必须小于主卡的外币信用额度。如果主卡的信用额度不为零，该域强制为？，副卡单独申请，如果主卡的卡号在CRDTBL表中存在，检查主卡的额度，如果CRDTBL表中不存在主卡的卡号，在NACMST表中读主卡的卡号，如果存在，检查NM_FOREIGN_CREDIT_LIMIT域(应该不大于NACMST中的值)，如果NACMST不存在，用主卡卡号读NBATRN表，如果存在，检查BT_FOREIGN_CREDIT_LIMIT.DECIMAL(11, 0)YCredit Limit for Foreign Currency .validation:a) Attached supp. application - Check the credit limit against its basic application foreign credit limit . The value must not more than its basic card foreign Credit limit. If basic card foreign limit is not zeros then this field is mandatory.b) Separate Supp. Application -Check the credit limit against its basic Cardholder credit limit if the basic cardholder number exist in CRDTBL table (cp_indacc.CB_LINE_LIMIT of acct type=2). - If the basic card not exist in CRDTBL, read NACMST for the basic cardholder number and if exist, check against NM_FOREIGN_CREDIT_LIMIT. (Should not more than the value in NACMST) - If NACMST not found, read NBATRN for the the basic cardholder number and if exist, check against BT_FOREIGN_CREDIT_LIMIT.NM_AUTOPAY_IND持卡人信用卡帐户清算自动扣缴或GIRO服务标志DECIMAL(1, 0)YCode indicating cardholder is requesting for autopay or GIRO facility for credit card account settlement.NM_LOCAL_AUTOPAY_BANK_BRANCH指定本币自动扣缴帐户的银行名称CHAR(8)YThe Name of the bank the cardholders nominated autopay or GIRO account - local currency account .NM_LOCAL_AUTOPAY_BANK_ACCNO指定本币自动扣缴帐户的帐号CHAR(20)YAccount number of cardholders nominated autopay or GIRO account - local currency account .NM_LOCAL_AUTOPAY_ACCNO_NAME指定本币自动扣缴帐户的维护银行或机构CHAR(20)YCode indicating bank and branch where the cardholders nominated autopay or GIRO account is maintained - local currency account .NM_FRGN_AUTOPAY_BANK_BRANCH指定外币自动扣缴帐户的银行名称CHAR(8)YThe Name of the bank the cardholders nominated autopay or GIRO account - foreign currency account .NM_FRGN_AUTOPAY_BANK_ACCNO指定外币自动扣缴帐户的帐号CHAR(20)YAccount number of cardholders nominated autopay or GIRO account - foreign currency account .NM_FRGN_AUTOPAY_ACCNO_NAME指定外币自动扣缴帐户的维护银行或机构CHAR(20)YCode indicating bank and branch where the cardholders nominated autopay or GIRO account is maintained - foreign currency account .NM_PIN_GEN_IND补发卡是否产生新PIN标志CHAR(1)YCode denoting whether a new PIN should be generated for any reissued card .validation:value Y/NNM_CURR_BANK_REL持卡人是否是发卡机构的现有客户CHAR(1)YCode indicating if cardholder is an existing customer of the issuer organization. (Yes/No) NM_RWDS_ACCNO现存银行客户中被决定获得特殊奖励的账号CHAR(19)YAccount number to be used for determination of special rewards eligibility for existing bank customers.NM_DECISION_CODE申请的审批结果DECIMAL(2, 0)YCode indicating decision made on card application . Eg. 1 (approved the application), 02 - declined the basic application etc. NM_DECISION_REASON申请审批结果描述性信息CHAR(40)YDescriptive COMMENT ON reason for decision made on application.NM_DECISION_DATE申请的审批日期CHAR(8)YDate the decision on the application is made.NM_REACTIVE_DATE以前拒绝或取消的申请重新激活的日期CHAR(8)YDate when previously declined or cancelled applications are reactivated.(validation:NM_REACTIVE_DATE equal to zeros and NM_UPDATE_FLAG = C then display message )NM_CARD_PRODCT_GROUP标识卡产品组的4位数字代码DECIMAL(4, 0)Y4 digit unique code to identify a card product group. NM_CARD_NO卡号：人工分配的卡号，如果为空，系统分配CHAR(19)YCardholder Number - either manually assigned or system generated if left blank. NM_CREDIT_GUARANTEE参考指示：用户定义的代码，表示持卡人为保持授予他/她的信用额度而提供的保证类型CHAR(1)YUser-defined code indicating the type of guarantee given by the cardholder to secure the line/credit given to him/herNM_CROSS_REF_IND参考号码：用户自定义的代码以指明参考号码与当前持卡人账户之间的参考类型CHAR(1)YUser-defined code indicating type of cross-referencing between Cross-reference Number and current cardholder account. NM_CROSS_REF_ACCNO当前持卡人交叉引用的其它帐号的卡号(关系由X-Ref标志定义)CHAR(19)YCard number of other account cross-referenced to current cardholder. The relationship is defined by the X-Ref IndicatorNM_BILL_CYCLE帐单周期DECIMAL(2, 0)YIndicates the day of the month when the account will be billed or statemented. Only open cycles may be assigned - open cycles are controlled in the Billing Cycle Control Table (CP_BILCYC) . NM_FEE_CODE卡费用代码(年费、换卡费等)DECIMAL(3, 0)YCode indicating the card fees (joining, 1st year annual and renewal fee) to be charged to the cardholder . (cross reference to CP_FEETBL table) NM_CUST_CLASS客户分类代码：识别客户类别的代码。如自由职业者，高级公务员等。可用做MIS报告或向持卡人寄送广告信的标准CHAR(4)YCode identifying classification of customer , e.g. professionals, senior civil servants, etc. May be used for MIS reporting or as criteria for marketing mailings to cardholders. (cross reference to CP_CSTCLS table) NM_MONITOR_CODE监控代码：用户定义的代码，用以指明需对持卡人进行监控的级别。监控代码是在授权处理和续卡审核过程中用到的一个标准CHAR(1)YCode to indicate the level of monitoring required on the cardholder. The Monitor Code is one of the criteria used during authorization processing and renewal review. (Cross reference to CP_MONCDE) NM_STOP_DUNN_CODE停止催款指示：正常催缴行动是否可用于持卡人帐户Y=停止对持卡人的所有催缴N=正常催缴行动，缺省CHAR(1)YIndicates whether normal dunning actions is applicable to cardholder account. (Yes or No) NM_DIRECT_MAIL_IND直邮指示：该代码指示是否应该给持卡人发送销售或推广邮件及夹页广告。影响持卡人地址标签和对帐单夹页广告的生成Y=正常邮寄，缺省N=未寄销售/推广邮件给持卡人CHAR(1)YCode indicating whether cardholder should be sent marketing or merchandising mail and inserts. Affects generation of cardholder address labels and statement inserts . NM_INTEREST_GRP_CODE兴趣组代码CHAR(3)YCode indicating the interest group the cardholder belongs to - as indicated on the card application form .NM_PREF_INT_RATE_SET利率设定：当申请被核准时分配给账户的优惠利率和滞纳金利率DECIMAL(1, 0)YDenotes the set of preferential interest and late payment charge rates applicable to the account. Determined at time of application approval - captured in Application Decision screen. (cross reference to CP_PRDPRF table) NM_USER_CODE_1预留字段CHAR(2)YExtra field allocated for future use or user-defined usage.NM_USER_CODE_2预留字段CHAR(2)YExtra field allocated for future use or user-defined