会员管理系统客户管理系统（积分管理）

会员余额统计会员查询使用说明积分统计充值记录消费记录积分兑换会员信息Membershipmanagementsystem会员信息会员卡号会员姓名手机号码性别生日地址入会日期A001爱问18912762163女43506北京2019/1/18A002爱问15012762164女43532上海2019/1/19A003爱问16812762165男43595广州2019/1/20充值充值日期会员卡号会员姓名手机号码充值金额赠送金额2019/1/18A001爱问18912762163300502019/1/19A002爱问150127621645001002019/1/20A003爱问16812762165500100消费记录表消费日期会员卡号会员姓名手机号码产品名称数量单价金额积分2019/1/20A002爱问15012762164产品116868682019/1/20A003爱问16812762165产品22881761762019/1/20A001爱问18912762163产品318888882019/1/21A002爱问15012762164产品111881881882019/1/22A002爱问15012762164产品21188188188000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000积分兑换表兑换日期会员卡号会员姓名手机号码兑换积分兑换奖品备注2019/2/1A002爱问15012762164400湿巾会员积分统计表会员卡号会员姓名手机号码总积分已兑换积分剩余积分A001爱问1891276216388088A002爱问1501276216444440044A003爱问168127621651760176000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000会员余额统计表会员卡号会员姓名手机号码充值总金额赠送总金额已消费金额剩余金额A001爱问189127621633005088262A002爱问15012762164500100444156A003爱问1681276216550010017642400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000会员查询输入查询的卡号:A001▌会员基本信息：会员卡号会员姓名手机号码性别A001爱问18912762163女生日地址入会日期43506北京2019/1/18▌充值消费信息：充值总金额赠送总金额已消费金额剩余金额3005088262▌积分兑换信息：总积分已兑换积分剩余积分88088使用说明各表录入及功能：1、【会员信息】，按照填入2、【充值记录】，录入充值信息即可3、【消费记录】，录入消费信息及积分4、【积分兑换】，输入兑换的卡号及积分5、【积分统计】，自动统计6、【余额统计】，自动统计7、【会员查询】，输入卡号，自动查询使用小贴士：表格进行了保护，可自行撤销保护，审阅-撤销工作表保护即可