{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["开立借记卡（账户）模板","数据字典"],"not_rendered":{"external_links":2,"defined_names":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"开立借记卡（账户）模板","index":0,"n_rows":3,"n_cols":49,"rows_kept":3,"flags":["formulas_cached_only"]}
["申请人姓名\n（必填，不超过30个字节）","申请人英文名\n（选填，不超过60个字节）","拼音名\n（选填，不超过20个字节）","民族\n（选填）","出生日期\n（“税收居民身份”为“中国税收居民”时选填；否则必填，且不能填入9999-12-31。格式为YYYY-MM-DD）","文化程度\n（选填）","婚姻状况\n（选填）","专属职业\n（必填）","工作单位\n（选填，不超过60个字节）","专属行业\n（必填）","国籍\n（必填）","性别\n（必填）","个人证件类型\n（必填）","个人证件号码\n（必填）","证件有效期截止日\n（必填，格式为YYYY-MM-DD；如果“证件有效期截止日”为9999-12-30，则“是否长期有效”的输入被忽略，后台转换时，“是否长期有效”自动默认为是）","是否长期有效\n（选填，如果“是否长期有效”为是，则“证件有效期截止日”只能为空或9999-12-30）","发证机关\n（选填，不超过30个字节）","地址\n（必填，不超过50个字节）","邮编\n（必填，6位数字）","联系电话\n（必填，1-12位数字）","联系电话类型\n（选填）","手机号码\n（选填，11位数字（开通工行信使的手机号码也请在这里填写）,同一手机号码最多只可以出现在两条记录中）","电子邮件地址\n（选填，不能超过50个字节）","传真\n（选填，不超过22个字节）","卡号\n（若为军保卡开户或理财金/E时代卡开基本户挂卡或开附属卡时，则必填；其他则留空。当为开附属卡时，上送主卡卡号。（开预付卡下帐户暂不支持））","监护人姓名\n（16岁以下客户必填，若此不为空，则监护人证件类型，监护人证件号码，监护人性别不能为空。不超过30个字节）","监护人证件类型\n（16岁以下客户必填，若此不为空，则监护人姓名，监护人证件号码，监护人性别不能为空。）","监护人证件号码\n（16岁以下客户必填，若此不为空，则监护人姓名，监护人证件类型，监护人性别不能为空。）","监护人性别\n（16岁以下客户必填，若此不为空，则监护人姓名，监护人证件类型，监护人证件号码不能为空。若监护人证件类型为“身份证”、“临时身份证”、“户口本”，则监护人性别只能为“男”或“女”。）","监护人电话\n（16岁以下客户必填，不能超过22个字节）","军保卡卡号\n（若为开军辅卡时，则必填，不超过19个字节；其余情况留空）","税收居民身份\n(必填，若“个人证件类型”为“警官证、军官证、士兵证”，则“税收居民身份”只能选“中国税收居民”；若“个人证件类型”为“护照”，则“税收居民身份”不能选“中国税收居民”)","出生国家（地区）\n(“税收居民身份”为“中国税收居民”时留空；否则必填)","税收居民国（地区）\n(“税收居民身份”为“中国税收居民”时留空；否则必填，且不能选择“中国”)","居民国（地区）纳税人识别号\n(“税收居民身份”为“中国税收居民”时留空，否则必填；若不输入，需填写“无居民国（地区）纳税人识别号的原因”，不超过50字节，不应包含‘&’、‘<’、‘--’‘/*’、‘&#’)","无居民国（地区）纳税人识别号的原因\n(“税收居民身份”为“中国税收居民”，或已录入纳税识别号时留空，否则必填)","未能取得纳税人识别号的具体原因\n(“无居民国（地区）纳税人识别号的原因”为“账户持有人未能取得纳税人识别号”时必填，否则留空，不超过200字节，不应包含‘&’、‘<’、‘--’‘/*’、‘&#’)","中文姓\n(“税收居民身份”为“中国税收居民”时留空；否则必输，不超过30字节，不应包含‘&’、‘<’、‘--’‘/*’、‘&#’；如果账户持有人的法定姓名是一个单名，不区分名和姓，则在名中填写‘NFN’，在姓中填写该单名”，即：如果客户只有名或只有姓，那么就认为客户只有一个姓。)","中文名\n(“税收居民身份”为“中国税收居民”时留空；否则必输，不超过30字节，不应包含‘&’、‘<’、‘--’‘/*’、‘&#’；如果账户持有人的法定姓名是一个单名，不区分名和姓，则在名中填写‘NFN’，在姓中填写该单名”，即：如果客户只有名或只有姓，那么就认为客户只有一个姓。)","英文姓\n(“税收居民身份”为“中国税收居民”时留空；否则必输，不超过50字节，不应包含‘&’、‘<’、‘--’‘/*’、‘&#’；如果账户持有人的法定姓名是一个单名，不区分名和姓，则在名中填写‘NFN’，在姓中填写该单名”，即：如果客户只有名或只有姓，那么就认为客户只有一个姓。)","英文中间名\n(“税收居民身份”为“中国税收居民”时留空；否则选输，不超过100字节，不应包含‘&’、‘<’、‘--’‘/*’、‘&#’)","英文名\n(“税收居民身份”为“中国税收居民”时留空；否则必输，不超过100字节，不应包含‘&’、‘<’、‘--’‘/*’、‘&#’；如果账户持有人的法定姓名是一个单名，不区分名和姓，则在名中填写‘NFN’，在姓中填写该单名”，即：如果客户只有名或只有姓，那么就认为客户只有一个姓。)","英文城市\n(“税收居民身份”为“中国税收居民”时留空；否则必输，不超过100字节，不应包含‘&’、‘<’、‘--’‘/*’、‘&#’)","英文地址\n(“税收居民身份”为“中国税收居民”时留空；否则必输，不超过200字节，不应包含‘&’、‘<’、‘--’‘/*’、‘&#’)","处理标志\n（回盘文件回写使用，请不要手工添加数据）","账号\n（回盘文件回写使用，请不要手工添加数据）","卡号\n（回盘文件回写使用，请不要手工添加数据）","账户类型\n（回盘文件回写使用，请不要手工添加数据）"]
[{"$nulls":48},"必填"]
[{"$nulls":48},"选填"]

{"sheet":"数据字典","index":1,"n_rows":242,"n_cols":4,"rows_kept":242,"flags":["formulas_cached_only"]}
["阿昌族","公务员","阿尔巴尼亚","未知"]
["白族","事业单位员工","阿尔及利亚","邮电通讯行业"]
["保安族","公司员工","阿富汗","房地产行业"]
["崩龙族","军人警察","阿根廷","交通运输行业"]
["布朗族","工人","阿联酋","法律/司法行业"]
["布依族","农民","阿鲁巴","文化/娱乐/体育行业"]
["藏族","管理人员","阿曼","媒介/广告行业"]
["朝鲜族","技术人员","阿塞拜疆","科研/教育行业"]
["达翰尔族","私营业主","埃及","医疗行业"]
["傣族","文体明星","埃塞俄比亚","计算机/网络行业"]
["东乡族","自由职业者","爱尔兰","商业贸易行业"]
["侗族","学生","爱沙尼亚","财政行业"]
["独龙族",null,"安道尔","税务行业"]
["俄罗斯族",null,"安哥拉","咨询行业"]
["鄂伦春族",null,"安圭拉","社会服务行业"]
["鄂温克族",null,"安提瓜和巴布达","旅游/饭店行业"]
["高山族",null,"奥地利","部队系统"]
["哈尼族",null,"澳大利亚","证券行业"]
["哈萨克族",null,"巴巴多斯","银行业"]
["汉族",null,"巴布亚新几内亚","保险行业"]
["赫哲族",null,"巴哈马","其它金融行业"]
["回族",null,"巴基斯坦","采矿业"]
["基诺族",null,"巴拉圭","建筑业"]
["京族",null,"巴勒斯坦","工业"]
["景颇族",null,"巴林","制造业"]
["柯尔克孜族",null,"巴拿马","水电气供应"]
["拉祜族",null,"巴西","机关团体"]
["黎族",null,"白俄罗斯","农林牧渔"]
["傈僳族",null,"百慕大"]
["珞巴族",null,"保加利亚"]
["满族",null,"北马里亚纳"]
["毛南族",null,"贝宁"]
["门巴族",null,"比利时"]
["蒙古族",null,"冰岛"]
["苗族",null,"波多黎各"]
["麽老族",null,"波黑"]
["纳西族",null,"波兰"]
["怒族",null,"玻利维亚"]
["普米族",null,"伯利兹"]
["其他",null,"博茨瓦纳"]
["羌族",null,"不丹"]
["撒拉族",null,"布基纳法索"]
["畲族",null,"布隆迪"]
["水族",null,"布维岛"]
["塔吉克族",null,"朝鲜"]
["塔塔尔族",null,"赤道几内亚"]
["土家族",null,"丹麦"]
["土族",null,"德国"]
["佤族",null,"东帝汶"]
["外国血统中国籍人士",null,"多哥"]
["维吾尔族",null,"多米尼加"]
["乌孜别克族",null,"多米尼克"]
["锡伯族",null,"俄罗斯联邦"]
["瑶族",null,"厄瓜多尔"]
["彝族",null,"厄立特里亚"]
["仡佬族",null,"法国"]
["裕固族",null,"法罗群岛"]
["壮族",null,"法属波利尼西亚"]
[null,null,"法属圭亚那"]
[null,null,"法属南部领地"]
[null,null,"梵蒂冈"]
[null,null,"菲律宾"]
[null,null,"斐济"]
[null,null,"芬兰"]
[null,null,"佛得角"]
[null,null,"福克兰群岛（马尔维纳斯）"]
[null,null,"冈比亚"]
[null,null,"刚果（布）"]
[null,null,"刚果（金）"]
[null,null,"哥伦比亚"]
[null,null,"哥斯达黎加"]
[null,null,"格林纳达"]
[null,null,"格陵兰"]
[null,null,"格鲁吉亚"]
[null,null,"古巴"]
[null,null,"瓜德罗普"]
[null,null,"关岛"]
[null,null,"圭亚那"]
[null,null,"哈萨克斯坦"]
[null,null,"海地"]
[null,null,"韩国"]
[null,null,"荷兰"]
[null,null,"荷属安的列斯"]
[null,null,"赫德岛和麦克唐纳岛"]
[null,null,"洪都拉斯"]
[null,null,"基里巴斯"]
[null,null,"吉布提"]
[null,null,"吉尔吉斯斯坦"]
[null,null,"几内亚"]
[null,null,"几内亚比绍"]
[null,null,"加拿大"]
[null,null,"加纳"]
[null,null,"加蓬"]
[null,null,"柬埔寨"]
[null,null,"捷克"]
[null,null,"津巴布韦"]
[null,null,"喀麦隆"]
[null,null,"卡塔尔"]
[null,null,"开曼群岛"]
[null,null,"科科斯（基林）群岛"]
[null,null,"科摩罗"]
[null,null,"科特迪瓦"]
[null,null,"科威特"]
[null,null,"克罗地亚"]
[null,null,"肯尼亚"]
[null,null,"库克群岛"]
[null,null,"拉脱维亚"]
[null,null,"莱索托"]
[null,null,"老挝"]
[null,null,"黎巴嫩"]
[null,null,"立陶宛"]
[null,null,"利比里亚"]
[null,null,"利比亚"]
[null,null,"列支敦士登"]
[null,null,"留尼汪"]
[null,null,"卢森堡"]
[null,null,"卢旺达"]
[null,null,"罗马尼亚"]
[null,null,"马达加斯加"]
[null,null,"马尔代夫"]
[null,null,"马耳他"]
[null,null,"马拉维"]
[null,null,"马来西亚"]
[null,null,"马里"]
[null,null,"马其顿"]
[null,null,"马绍尔群岛"]
[null,null,"马提尼克"]
[null,null,"马约特"]
[null,null,"毛里求斯"]
[null,null,"毛里塔尼亚"]
[null,null,"美国"]
[null,null,"美国本土外小岛屿"]
[null,null,"美属萨摩亚"]
[null,null,"美属维尔京群岛"]
[null,null,"蒙古"]
[null,null,"蒙特塞拉特"]
[null,null,"孟加拉国"]
[null,null,"秘鲁"]
[null,null,"密克罗尼西亚联邦"]
[null,null,"缅甸"]
[null,null,"摩尔多瓦"]
[null,null,"摩洛哥"]
[null,null,"摩纳哥"]
[null,null,"莫桑比亚"]
[null,null,"墨西哥"]
[null,null,"纳米比亚"]
[null,null,"南非"]
[null,null,"南极洲"]
[null,null,"南乔治亚岛和南桑德韦奇岛"]
[null,null,"南斯拉夫"]
[null,null,"瑙鲁"]
[null,null,"尼泊尔"]
[null,null,"尼加拉瓜"]
[null,null,"尼日尔"]
[null,null,"尼日利亚"]
[null,null,"纽埃"]
[null,null,"挪威"]
[null,null,"诺福克岛"]
[null,null,"帕劳"]
[null,null,"皮特凯恩"]
[null,null,"葡萄牙"]
[null,null,"其它"]
[null,null,"日本"]
[null,null,"瑞典"]
[null,null,"瑞士"]
[null,null,"萨尔瓦多"]
[null,null,"萨摩亚"]
[null,null,"塞尔维亚"]
[null,null,"塞拉利昂"]
[null,null,"塞内加尔"]
[null,null,"塞浦路斯"]
[null,null,"塞舌尔"]
[null,null,"沙特阿拉伯"]
[null,null,"圣诞岛"]
[null,null,"圣多美和普林西比"]
[null,null,"圣赫勒拿"]
[null,null,"圣基茨和尼维斯"]
[null,null,"圣卢西亚"]
[null,null,"圣马力诺"]
[null,null,"圣皮埃尔和密克隆"]
[null,null,"圣文森特和格林纳丁斯"]
[null,null,"斯里兰卡"]
[null,null,"斯洛伐克"]
[null,null,"斯洛文尼亚"]
[null,null,"斯瓦尔巴岛和扬马延岛"]
[null,null,"斯威士兰"]
[null,null,"苏丹"]
[null,null,"苏里南"]
[null,null,"所罗门群岛"]
[null,null,"索马里"]
[null,null,"塔吉克斯坦"]
[null,null,"泰国"]
[null,null,"坦桑尼亚"]
[null,null,"汤加"]
[null,null,"特克斯和凯科斯群岛"]
[null,null,"特立尼达和多巴哥"]
[null,null,"突尼斯"]
[null,null,"图瓦卢"]
[null,null,"土耳其"]
[null,null,"土库曼斯坦"]
[null,null,"托克劳"]
[null,null,"瓦利斯和富图纳"]
[null,null,"瓦努阿图"]
[null,null,"危地马拉"]
[null,null,"委内瑞拉"]
[null,null,"文莱"]
[null,null,"乌干达"]
[null,null,"乌克兰"]
[null,null,"乌拉圭"]
[null,null,"乌兹别克斯坦"]
[null,null,"西班牙"]
[null,null,"西撒哈拉"]
[null,null,"希腊"]
[null,null,"新加坡"]
[null,null,"新喀里多尼亚"]
[null,null,"新西兰"]
[null,null,"匈牙利"]
[null,null,"叙利亚"]
[null,null,"牙买加"]
[null,null,"亚美尼亚"]
[null,null,"也门"]
[null,null,"伊拉克"]
[null,null,"伊朗"]
[null,null,"以色列"]
[null,null,"意大利"]
[null,null,"印度"]
[null,null,"印度尼西亚"]
[null,null,"英国"]
[null,null,"英属维尔京群岛"]
[null,null,"英属印度洋领地"]
[null,null,"约旦"]
[null,null,"越南"]
[null,null,"赞比亚"]
[null,null,"乍得"]
[null,null,"直布罗陀"]
[null,null,"智利"]
[null,null,"中非"]
[null,null,"中国"]
[null,null,"中国澳门"]
[null,null,"中国台湾"]
[null,null,"中国香港"]
[null,null,"中途岛"]