{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["修订记录","数据表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"修订记录","index":0,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["编号","版本号","修订人","修订类型","修订时间","修订内容","备注"]
[1,"V1.0","马圣毅","新建","2021-10-10"]
[2,"V1.1","马圣毅","修改","2022-01-10"]

{"sheet":"数据表","index":1,"n_rows":288,"n_cols":12,"rows_kept":288,"cut":false,"hidden":false,"merged":[]}
["数据库名","表英文名","表中文名","列名","类型","默认值","允许为空","数据类型","字符最大长度","数字精度","小数位数","字段说明"]
["db_invoice","t_CalculateInfor","无车计费信息表","id","int(100)",null,"NO","int",null,10,0,"主键"]
["db_invoice","t_CalculateInfor","无车计费信息表","customId","varchar(100)",null,"YES","varchar",100,null,null,"客户号"]
["db_invoice","t_CalculateInfor","无车计费信息表","companyNum","varchar(300)",null,"YES","varchar",300,null,null,"公司编号"]
["db_invoice","t_CalculateInfor","无车计费信息表","tradeId","varchar(50)",null,"YES","varchar",50,null,null,"申请id"]
["db_invoice","t_CalculateInfor","无车计费信息表","fee","double",null,"YES","double",null,22,null,"计费费用"]
["db_invoice","t_CalculateInfor","无车计费信息表","calculateTime","varchar(50)",null,"YES","varchar",50,null,null,"计费时间"]
["db_invoice","t_CalculateInfor","无车计费信息表","ctype","tinyint(4)",null,"YES","tinyint",null,3,0,"业务类型"]
["db_invoice","t_CalculateInfor","无车计费信息表","buyerName","varchar(300)",null,"YES","varchar",300,null,null,"购方名称"]
["db_invoice","t_CalculateInfor","无车计费信息表","buyerTaxpayerCode","varchar(100)",null,"YES","varchar",100,null,null,"购方税号"]
["db_invoice","t_CalculateInfor","无车计费信息表","invoiceMakeTime","varchar(30)",null,"YES","varchar",30,null,null,"开票时间"]
["db_invoice","t_CalculateInfor","无车计费信息表","companyLongName","varchar(200)",null,"YES","varchar",200,null,null,"主体名称"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","id","int(100)",null,"NO","int",null,10,0,"主键"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","customId","varchar(100)",null,"YES","varchar",100,null,null,"客户号"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","companyNum","varchar(300)",null,"YES","varchar",300,null,null,"公司编号"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","etcNum","varchar(50)",null,"YES","varchar",50,null,null,"etc卡号"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","fee","double",null,"YES","double",null,22,null,"计费费用"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","calTime","varchar(50)",null,"YES","varchar",50,null,null,"计费时间"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","invoiceMkTime","varchar(50)",null,"YES","varchar",50,null,null,"开票时间"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","companyReferencenum","varchar(30)",null,"YES","varchar",30,null,null,"税号"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","companyName","varchar(200)",null,"YES","varchar",200,null,null,"公司名称"]
["db_invoice","t_SelfCalculateInfor","自有车计费信息表","companyLongName","varchar(200)",null,"YES","varchar",200,null,null,"主体名称"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","id","int(100)",null,"NO","int",null,10,0,"主键"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","customId","varchar(100)",null,"YES","varchar",100,null,null,"客户号"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","companyNum","varchar(300)",null,"YES","varchar",300,null,null,"公司编号"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","cardId","varchar(100)",null,"YES","varchar",100,null,null,"ETC卡号"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","invoiceCount","int(11)",null,"YES","int",null,10,0,"发票数量"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","invoiceAmount","bigint(20)",null,"YES","bigint",null,19,0,"发票金额"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","invoiceTaxAmount","bigint(20)",null,"YES","bigint",null,19,0,"发票税额"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","applTime","varchar(30)",null,"YES","varchar",30,null,null,"申请时间"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","applId","varchar(50)",null,"YES","varchar",50,null,null,"申请id"]
["db_invoice","t_SelfCarAppl","自有车申请记录表","voiceFlag","tinyint(4)",null,"YES","tinyint",null,3,0,"是否已经取票 0 -未取票 1-已经取票"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","id","int(100)",null,"NO","int",null,10,0,"主键"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","cardId","varchar(100)",null,"YES","varchar",100,null,null,"etc卡号"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","invoiceNum","varchar(100)",null,"YES","varchar",100,null,null,"发票号码"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","invoiceCode","varchar(100)",null,"YES","varchar",100,null,null,"发票代码"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","invoiceMakeTime","varchar(30)",null,"YES","varchar",30,null,null,"开票时间"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","invoiceUrl","varchar(150)",null,"YES","varchar",150,null,null,"发票url"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","invoiceHtmlUrl","varchar(150)",null,"YES","varchar",150,null,null,"发票板式文件url"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","enStation","varchar(200)",null,"YES","varchar",200,null,null,"入口收费站"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","exStation","varchar(200)",null,"YES","varchar",200,null,null,"出口收费站"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","exTime","varchar(30)",null,"YES","varchar",30,null,null,"交易时间"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","fee","bigint(20)",null,"YES","bigint",null,19,0,"交易金额"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","totalTaxAmount","bigint(20)",null,"YES","bigint",null,19,0,"税额（可抵扣金额）"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","plateNum","varchar(30)",null,"YES","varchar",30,null,null,"车牌号"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","vehicleType","tinyint(4)",null,"YES","tinyint",null,3,0,"车型 见附录8.3"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","sellerName","varchar(200)",null,"YES","varchar",200,null,null,"销方名称"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","sellerTaxpayerCode","varchar(100)",null,"YES","varchar",100,null,null,"销方税号"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","totalAmount","bigint(20)",null,"YES","bigint",null,19,0,"价税合计"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","taxRate","double",null,"YES","double",null,22,null,"税率"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","invoiceType","varchar(30)",null,"YES","varchar",30,null,null,"发票种类"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","amount","bigint(20)",null,"YES","bigint",null,19,0,"金额"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","tradeId","varchar(50)",null,"YES","varchar",50,null,null,"交易ID"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","buyerName","varchar(200)",null,"YES","varchar",200,null,null,"购方名称"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","buyerTaxpayerCode","varchar(200)",null,"YES","varchar",200,null,null,"购方税号"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","companyNum","varchar(60)",null,"YES","varchar",60,null,null,"企业编号"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","companyName","varchar(200)",null,"YES","varchar",200,null,null,"企业名称"]
["db_invoice","t_SelfCarInvoice","自有车发票记录表","customerName","varchar(200)",null,"YES","varchar",200,null,null,"客户名称"]
["db_invoice","t_SellCarTrade","自有车交易记录表","id","int(100)",null,"NO","int",null,10,0,"主键"]
["db_invoice","t_SellCarTrade","自有车交易记录表","customId","varchar(100)",null,"YES","varchar",100,null,null,"客户号"]
["db_invoice","t_SellCarTrade","自有车交易记录表","companyNum","varchar(300)",null,"YES","varchar",300,null,null,"公司名称"]
["db_invoice","t_SellCarTrade","自有车交易记录表","cardId","varchar(100)",null,"YES","varchar",100,null,null,"ETC卡号"]
["db_invoice","t_SellCarTrade","自有车交易记录表","tradeId","varchar(50)",null,"YES","varchar",50,null,null,"交易id"]
["db_invoice","t_SellCarTrade","自有车交易记录表","exTime","varchar(30)",null,"YES","varchar",30,null,null,"交易时间"]
["db_invoice","t_SellCarTrade","自有车交易记录表","fee","bigint(20)",null,"YES","bigint",null,19,0,"交易费用"]
["db_invoice","t_SellCarTrade","自有车交易记录表","status","tinyint(4)",null,"YES","tinyint",null,3,0,"交易状态 0-未开票 1-开票中 2-成功开票"]
["db_invoice","t_SellCarTrade","自有车交易记录表","applId","varchar(50)",null,"YES","varchar",50,null,null,"申请id"]
["db_invoice","t_SellCarTrade","自有车交易记录表","companyName","varchar(100)",null,"YES","varchar",100,null,null,"公司名称"]
["db_invoice","t_SellCarTrade","自有车交易记录表","aclTime","varchar(30)",null,"YES","varchar",30,null,null,"申请开票时间"]
["db_invoice","t_SellCarTrade","自有车交易记录表","companyReferencenum","varchar(50)",null,"YES","varchar",50,null,null,"税号"]
["db_invoice","t_SellCarTrade","自有车交易记录表","interType","int(2)",1,"NO","int",null,10,0,"默认请求方式 0-接口 1-平台"]
["db_invoice","t_billInvoice","无车发票记录表","id","int(100)",null,"NO","int",null,10,0,"主键"]
["db_invoice","t_billInvoice","无车发票记录表","waybillNum","varchar(100)",null,"YES","varchar",100,null,null,"运单编号"]
["db_invoice","t_billInvoice","无车发票记录表","invoiceNum","varchar(100)",null,"YES","varchar",100,null,null,"发票号码"]
["db_invoice","t_billInvoice","无车发票记录表","invoiceCode","varchar(100)",null,"YES","varchar",100,null,null,"发票代码"]
["db_invoice","t_billInvoice","无车发票记录表","invoiceMakeTime","varchar(30)",null,"YES","varchar",30,null,null,"开票时间"]
["db_invoice","t_billInvoice","无车发票记录表","invoiceUrl","varchar(150)",null,"YES","varchar",150,null,null,"发票url"]
["db_invoice","t_billInvoice","无车发票记录表","invoiceHtmlUrl","varchar(150)",null,"YES","varchar",150,null,null,"发票板式文件url"]
["db_invoice","t_billInvoice","无车发票记录表","enStation","varchar(200)",null,"YES","varchar",200,null,null,"入口收费站"]
["db_invoice","t_billInvoice","无车发票记录表","exStation","varchar(200)",null,"YES","varchar",200,null,null,"出口收费站"]
["db_invoice","t_billInvoice","无车发票记录表","exTime","varchar(30)",null,"YES","varchar",30,null,null,"交易时间"]
["db_invoice","t_billInvoice","无车发票记录表","fee","bigint(20)",null,"YES","bigint",null,19,0,"交易金额"]
["db_invoice","t_billInvoice","无车发票记录表","totalTaxAmount","bigint(20)",null,"YES","bigint",null,19,0,"税额（可抵扣金额）"]
["db_invoice","t_billInvoice","无车发票记录表","plateNum","varchar(30)",null,"YES","varchar",30,null,null,"车牌号"]
["db_invoice","t_billInvoice","无车发票记录表","vehicleType","tinyint(4)",null,"YES","tinyint",null,3,0,"车型 见附录8.3"]
["db_invoice","t_billInvoice","无车发票记录表","sellerName","varchar(200)",null,"YES","varchar",200,null,null,"销方名称"]
["db_invoice","t_billInvoice","无车发票记录表","sellerTaxpayerCode","varchar(100)",null,"YES","varchar",100,null,null,"sellerTaxpayerCode"]
["db_invoice","t_billInvoice","无车发票记录表","waybillStatus","tinyint(4)",null,"YES","tinyint",null,3,0,"运单状态"]
["db_invoice","t_billInvoice","无车发票记录表","waybillStartTime","varchar(30)",null,"YES","varchar",30,null,null,"运单开始时间"]
["db_invoice","t_billInvoice","无车发票记录表","waybillEndTime","varchar(30)",null,"YES","varchar",30,null,null,"运单结束时间"]
["db_invoice","t_billInvoice","无车发票记录表","totalAmount","bigint(20)",null,"YES","bigint",null,19,0,"价税合计"]
["db_invoice","t_billInvoice","无车发票记录表","taxRate","double",null,"YES","double",null,22,null,"税率"]
["db_invoice","t_billInvoice","无车发票记录表","invoiceType","varchar(50)",null,"YES","varchar",50,null,null,"发票种类"]
["db_invoice","t_billInvoice","无车发票记录表","amount","bigint(20)",null,"YES","bigint",null,19,0,"金额"]
["db_invoice","t_billInvoice","无车发票记录表","transactionId","varchar(50)",null,"YES","varchar",50,null,null,"交易ID"]
["db_invoice","t_billInvoice","无车发票记录表","tradeMatchTime","varchar(30)",null,"YES","varchar",30,null,null,"交易匹配时间"]
["db_invoice","t_billInvoice","无车发票记录表","buyerName","varchar(200)",null,"YES","varchar",200,null,null,"购方名称"]
["db_invoice","t_billInvoice","无车发票记录表","buyerTaxpayerCode","varchar(200)",null,"YES","varchar",200,null,null,"购方税号"]
["db_invoice","t_billInvoice","无车发票记录表","aclTime","varchar(30)",null,"YES","varchar",30,null,null,"开票时间"]
["db_invoice","t_billInvoice","无车发票记录表","companyName","varchar(200)",null,"YES","varchar",200,null,null,"企业名称"]
["db_invoice","t_billInvoice","无车发票记录表","customerName","varchar(200)",null,"YES","varchar",200,null,null,"客户名称"]
["db_invoice","t_billInvoice","无车发票记录表","companyNum","varchar(50)",null,"YES","varchar",50,null,null,"企业编号"]
["db_invoice","t_billInvoice","无车发票记录表","calculateTime","varchar(30)",null,"YES","varchar",30,null,null,"计费时间"]
["db_invoice","t_billInvoice","无车发票记录表","interType","int(2)",1,"NO","int",null,10,0,"默认请求方式 0-接口 1-平台"]
["db_invoice","t_billInvoice","无车发票记录表","msg","varchar(200)",null,"YES","varchar",200,null,null,"发票状态信息"]
["db_invoice","t_billInvoice","无车发票记录表","invoiceStatus","tinyint(4)",null,"YES","tinyint",null,3,0,"发票状态 1、待开票 2、开票中 3、开票完成"]
["db_invoice","t_change_card","客户换绑etc动作表","id","int(11)",null,"NO","int",null,10,0,"唯一ID"]
["db_invoice","t_change_card","客户换绑etc动作表","applyId","varchar(90)",null,"YES","varchar",90,null,null,"申请id"]
["db_invoice","t_change_card","客户换绑etc动作表","cardId","varchar(90)",null,"YES","varchar",90,null,null,"ETC卡号"]
["db_invoice","t_change_card_info","客户换绑数据记录表","id","int(11)",null,"NO","int",null,10,0,"唯一ID"]
["db_invoice","t_change_card_info","客户换绑数据记录表","companyName","varchar(200)",null,"YES","varchar",200,null,null,"企业名称"]
["db_invoice","t_change_card_info","客户换绑数据记录表","companyNum","varchar(30)",null,"YES","varchar",30,null,null,"企业编码"]
["db_invoice","t_change_card_info","客户换绑数据记录表","targetCompanyName","varchar(200)",null,"YES","varchar",200,null,null,"目标公司名称"]
["db_invoice","t_change_card_info","客户换绑数据记录表","targetcompanyNum","varchar(30)",null,"YES","varchar",30,null,null,"目标公司编号"]
["db_invoice","t_change_card_info","客户换绑数据记录表","applyId","varchar(50)",null,"YES","varchar",50,null,null,"申请id"]
["db_invoice","t_change_card_info","客户换绑数据记录表","changeTime","varchar(50)",null,"YES","varchar",50,null,null,"换绑时间"]
["db_invoice","t_change_card_info","客户换绑数据记录表","info","varchar(300)",null,"YES","varchar",300,null,null,"换绑信息"]
["db_invoice","t_change_card_info","客户换绑数据记录表","customerId","varchar(50)",null,"YES","varchar",50,null,null,"客户名称"]
["db_invoice","t_cusomerOper","无车运单导入信息表","customerName","varchar(200)",null,"YES","varchar",200,null,null,"客户名称"]
["db_invoice","t_cusomerOper","无车运单导入信息表","customerPhone","varchar(30)",null,"YES","varchar",30,null,null,"客户手机号"]
["db_invoice","t_cusomerOper","无车运单导入信息表","company","varchar(300)",null,"YES","varchar",300,null,null,"公司名称"]
["db_invoice","t_cusomerOper","无车运单导入信息表","batchNumber","varchar(200)",null,"YES","varchar",200,null,null,"批次号"]
["db_invoice","t_cusomerOper","无车运单导入信息表","createTime","varchar(50)",null,"YES","varchar",50,null,null,"创建时间"]
["db_invoice","t_cusomerOper","无车运单导入信息表","id","int(11)",null,"NO","int",null,10,0,"唯一ID"]
["db_invoice","t_cusomerOper","无车运单导入信息表","operType","int(11)",null,"YES","int",null,10,0,"1-运单开始,2-运单结束 3 历史运单操作"]
["db_invoice","t_customer","企业注册信息主表","id","int(11)",null,"NO","int",null,10,0,"唯一ID"]
["db_invoice","t_customer","企业注册信息主表","app_secret","varchar(200)",null,"YES","varchar",200,null,null,"appSecret"]
["db_invoice","t_customer","企业注册信息主表","customer_name","varchar(20)",null,"NO","varchar",20,null,null,"appKey"]
["db_invoice","t_customer","企业注册信息主表","invoice_time","varchar(20)",null,"YES","varchar",20,null,null,"无车最后一次扣费时间"]
["db_invoice","t_customer","企业注册信息主表","usenum_all","int(11)",null,"YES","int",null,10,0,"用户访问总数量，扩展字段，暂不使用"]
["db_invoice","t_customer","企业注册信息主表","usenum_interface","int(11)",null,"YES","int",null,10,0,"用户访问接口数量，扩展字段，暂不使用"]
["db_invoice","t_customer","企业注册信息主表","usenum_plat","int(11)",null,"YES","int",null,10,0,"用户访问平台数量，扩展字段，暂不使用"]
["db_invoice","t_customer","企业注册信息主表","account_balance","double",null,"YES","double",null,22,null,"账户余额"]
["db_invoice","t_customer","企业注册信息主表","bussiness_type","int(11)",null,"YES","int",null,10,0,"0-自有车 1-外协车 2-无车"]
["db_invoice","t_customer","企业注册信息主表","integration_type","int(11)",null,"YES","int",null,10,0,"扩展字段，暂不使用"]
["db_invoice","t_customer","企业注册信息主表","first_sign","varchar(20)",null,"YES","varchar",20,null,null,"用户添加时间"]
["db_invoice","t_customer","企业注册信息主表","accStatus","int(11)",1,"NO","int",null,10,0,"是否启用  * 0 -正常 1-停用"]
["db_invoice","t_customer","企业注册信息主表","company","varchar(100)",null,"YES","varchar",100,null,null,"用户所属公司"]
["db_invoice","t_customer","企业注册信息主表","fee","double",5,"YES","double",null,22,null,"etc收费费用"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","customer_name","varchar(200)",null,"NO","varchar",200,null,null,"客户名称"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","company_name","varchar(200)",null,"YES","varchar",200,null,null,"公司名称"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","car_num","varchar(20)",null,"NO","varchar",20,null,null,"车牌号"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","car_color","varchar(10)",null,"YES","varchar",10,null,null,"车牌颜色"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","cust_phone","varchar(22)",null,"YES","varchar",22,null,null,"公司注册手机号"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","etc_num","varchar(50)",null,"YES","varchar",50,null,null,"etc卡号"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","succ_time","varchar(20)",null,"YES","varchar",20,null,null,"车辆备案成功时间"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","fail_time","varchar(20)",null,"YES","varchar",20,null,null,"车辆备案失败时间"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","rec_status","int(11)",null,"YES","int",null,10,0,"0-备案失败 1-备案成功 2-解绑"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","fail_reason","varchar(4000)",null,"YES","varchar",4000,null,null,"失败原因"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","bussiness_type","int(11)",null,"NO","int",null,10,0,"0-自有车 1-外协车 2-无车"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","companyNum","varchar(30)",null,"YES","varchar",30,null,null,"企业编码"]
["db_invoice","t_customer_carRec","客户车辆备案记录表","inter_type","int(2)",1,"NO","int",null,10,0,"默认请求方式 0-接口 1-平台"]
["db_invoice","t_customer_rec","企业注册信息明细表","id","int(11)",null,"NO","int",null,10,0,"唯一ID"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_leader","varchar(100)",null,"YES","varchar",100,null,null,"紧急联系人"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_leader_Phone","varchar(30)",null,"YES","varchar",30,null,null,"紧急联系人电话"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_name","varchar(100)",null,"YES","varchar",100,null,null,"公司名称"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_referenceNum","varchar(30)",null,"YES","varchar",30,null,null,"公司税号"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_openbank","varchar(100)",null,"YES","varchar",100,null,null,"公司开户行"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_openbank_acc","varchar(50)",null,"YES","varchar",50,null,null,"公司开户行账号"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_adress","varchar(300)",null,"YES","varchar",300,null,null,"公司地址"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_phone","varchar(30)",null,"YES","varchar",30,null,null,"公司电话"]
["db_invoice","t_customer_rec","企业注册信息明细表","createTime","varchar(20)",null,"NO","varchar",20,null,null,"创建时间"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_belong_name","varchar(200)",null,"YES","varchar",200,null,null,"主体名称"]
["db_invoice","t_customer_rec","企业注册信息明细表","rec_status","int(11)",null,"YES","int",null,10,0,"2-失败 1-成功 3-等待协议上传 4-停用 0-备案中"]
["db_invoice","t_customer_rec","企业注册信息明细表","inter_type","int(11)",1,"NO","int",null,10,0,"默认值是平台接入"]
["db_invoice","t_customer_rec","企业注册信息明细表","customerName","varchar(100)",null,"NO","varchar",100,null,null,"客户名称"]
["db_invoice","t_customer_rec","企业注册信息明细表","bussiness_type","int(11)",null,"NO","int",null,10,0,"0-自有车 1-外协车 2-无车"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_type","tinyint(4)",null,"YES","tinyint",null,3,0,"企业类别"]
["db_invoice","t_customer_rec","企业注册信息明细表","operating_rangeType","tinyint(4)",null,"YES","tinyint",null,3,0,"运营范围"]
["db_invoice","t_customer_rec","企业注册信息明细表","company_num","varchar(60)",null,"YES","varchar",60,null,null,"企业编号"]
["db_invoice","t_customer_rec","企业注册信息明细表","service_startTime","varchar(60)",null,"YES","varchar",60,null,null,"服务开始时间"]
["db_invoice","t_customer_rec","企业注册信息明细表","service_endTime","varchar(60)",null,"YES","varchar",60,null,null,"服务结束时间"]
["db_invoice","t_customer_rec","企业注册信息明细表","service_type","tinyint(60)",null,"YES","tinyint",null,3,0,"协议类型"]
["db_invoice","t_customer_rec","企业注册信息明细表","contractFileName","varchar(200)",null,"YES","varchar",200,null,null,"协议名称"]
["db_invoice","t_customer_rec","企业注册信息明细表","base64Str","longtext",null,"YES","longtext",4294967295,null,null,"协议base64流"]
["db_invoice","t_customer_rec","企业注册信息明细表","contractSuc","tinyint(4)",null,"YES","tinyint",null,3,0,"1-协议已上传 2-协议未上传"]
["db_invoice","t_customer_rec","企业注册信息明细表","contrantNum","varchar(20)",null,"YES","varchar",20,null,null,"协议编码"]
["db_invoice","t_customer_rec","企业注册信息明细表","lowerBase64Str","longtext",null,"YES","longtext",4294967295,null,null,"客户上传协议base64流"]
["db_invoice","t_customer_rec","企业注册信息明细表","lowerFileName","varchar(200)",null,"YES","varchar",200,null,null,"客户上传协议名称"]
["db_invoice","t_customer_rec","企业注册信息明细表","fileMessage","varchar(200)",null,"YES","varchar",200,null,null,"企业注册失败原因"]
["db_invoice","t_customer_rec","企业注册信息明细表","contractStatus","int(2)",0,"YES","int",null,10,0,"协议上传状态 1、协议上传失败 2、协议上传成功，审批中 3、备案成功"]
["db_invoice","t_customer_recharge","企业充值记录表","id","int(11)",null,"NO","int",null,10,0,"唯一ID"]
["db_invoice","t_customer_recharge","企业充值记录表","customer_name","varchar(200)",null,"YES","varchar",200,null,null,"客户名称"]
["db_invoice","t_customer_recharge","企业充值记录表","before_money","double",null,"YES","double",null,22,null,"充值前账户余额"]
["db_invoice","t_customer_recharge","企业充值记录表","recharge_mony","double",null,"YES","double",null,22,null,"充值金额"]
["db_invoice","t_customer_recharge","企业充值记录表","recharge_time","varchar(20)",null,"NO","varchar",20,null,null,"充值时间"]
["db_invoice","t_customer_recharge","企业充值记录表","companyName","varchar(200)",null,"YES","varchar",200,null,null,"公司名称"]
["db_invoice","t_hcinvoice","红冲发票记录表","id","int(11)",null,"NO","int",null,10,0,"主键"]
["db_invoice","t_hcinvoice","红冲发票记录表","sellerName","varchar(100)",null,"YES","varchar",100,null,null,"销方名称"]
["db_invoice","t_hcinvoice","红冲发票记录表","sellerTaxpayerCode","varchar(100)",null,"YES","varchar",100,null,null,"销方税号"]
["db_invoice","t_hcinvoice","红冲发票记录表","buyerName","varchar(100)",null,"YES","varchar",100,null,null,"购方名称"]
["db_invoice","t_hcinvoice","红冲发票记录表","buyerTaxpayerCode","varchar(30)",null,"YES","varchar",30,null,null,"购方税号"]
["db_invoice","t_hcinvoice","红冲发票记录表","amount","bigint(20)",null,"YES","bigint",null,19,0,"金额"]
["db_invoice","t_hcinvoice","红冲发票记录表","rawInvoiceId","varchar(100)",null,"YES","varchar",100,null,null,"原票id"]
["db_invoice","t_hcinvoice","红冲发票记录表","rawInvoiceCode","varchar(30)",null,"YES","varchar",30,null,null,"原票发票代码"]
["db_invoice","t_hcinvoice","红冲发票记录表","rawInvoiceNum","varchar(30)",null,"YES","varchar",30,null,null,"原票发票号码"]
["db_invoice","t_hcinvoice","红冲发票记录表","invoiceUrl","varchar(150)",null,"YES","varchar",150,null,null,"红票下载url"]
["db_invoice","t_hcinvoice","红冲发票记录表","yearMonth","varchar(16)",null,"YES","varchar",16,null,null,"年月"]
["db_invoice","t_hcinvoice","红冲发票记录表","invoiceCode","varchar(30)",null,"YES","varchar",30,null,null,"红票代码"]
["db_invoice","t_hcinvoice","红冲发票记录表","invoiceNum","varchar(30)",null,"YES","varchar",30,null,null,"红票号码"]
["db_invoice","t_manager_param","系统参数表","id","int(11)",null,"NO","int",null,10,0,"唯一ID"]
["db_invoice","t_manager_param","系统参数表","param_name","varchar(100)",null,"NO","varchar",100,null,null,"参数名称"]
["db_invoice","t_manager_param","系统参数表","param_value","varchar(50)",null,"NO","varchar",50,null,null,"参数值"]
["db_invoice","t_manager_param","系统参数表","param_note","varchar(100)",null,"NO","varchar",100,null,null,"注释"]
["db_invoice","t_mouth_cal","月账单记录表","id","int(11)",null,"NO","int",null,10,0,"唯一ID"]
["db_invoice","t_mouth_cal","月账单记录表","customerId","varchar(20)",null,"YES","varchar",20,null,null,"客户名称"]
["db_invoice","t_mouth_cal","月账单记录表","companyName","varchar(200)",null,"YES","varchar",200,null,null,"企业名称"]
["db_invoice","t_mouth_cal","月账单记录表","waybillNum","varchar(100)",null,"YES","varchar",100,null,null,"运单编号"]
["db_invoice","t_mouth_cal","月账单记录表","tradeId","varchar(200)",null,"YES","varchar",200,null,null,"交易ID"]
["db_invoice","t_mouth_cal","月账单记录表","fee","double",null,"YES","double",null,22,null,"交易费用"]
["db_invoice","t_mouth_cal","月账单记录表","exTime","varchar(20)",null,"YES","varchar",20,null,null,"计费时间"]
["db_invoice","t_mouth_cal","月账单记录表","buyerName","varchar(200)",null,"YES","varchar",200,null,null,"购方名称"]
["db_invoice","t_mouth_cal","月账单记录表","buyerTaxpayerCode","varchar(100)",null,"YES","varchar",100,null,null,"购方税号"]
["db_invoice","t_mouth_cal","月账单记录表","enStation","varchar(200)",null,"YES","varchar",200,null,null,"入口收费站"]
["db_invoice","t_mouth_cal","月账单记录表","exStation","varchar(200)",null,"YES","varchar",200,null,null,"出口收费站"]
["db_invoice","t_role","角色表","id","int(11)",null,"NO","int",null,10,0,"唯一ID"]
["db_invoice","t_role","角色表","role_name","varchar(20)",null,"YES","varchar",20,null,null,"角色名称"]
["db_invoice","t_user","系统用户表","id","int(11)",null,"NO","int",null,10,0,"id"]
["db_invoice","t_user","系统用户表","user_name","varchar(50)",null,"NO","varchar",50,null,null,"用户名"]
["db_invoice","t_user","系统用户表","password","varchar(50)",null,"NO","varchar",50,null,null,"密码"]
["db_invoice","t_user","系统用户表","name","varchar(20)",null,"NO","varchar",20,null,null,"真实姓名"]
["db_invoice","t_user","系统用户表","phone","varchar(20)",null,"NO","varchar",20,null,null,"手机号"]
["db_invoice","t_user","系统用户表","company","varchar(255)",null,"NO","varchar",255,null,null,"企业名称"]
["db_invoice","t_user","系统用户表","duty_paragraph","varchar(50)",null,"YES","varchar",50,null,null,"纳税人识别号"]
["db_invoice","t_user","系统用户表","operating_range_type","varchar(255)",null,"YES","varchar",255,null,null,"经营范围"]
["db_invoice","t_user","系统用户表","role_id","varchar(20)",null,"YES","varchar",20,null,null,"角色id"]
["db_invoice","t_user","系统用户表","role_name","varchar(20)",null,"YES","varchar",20,null,null,"角色名称"]
["db_invoice","t_user","系统用户表","money","bigint(255)",0,"NO","bigint",null,19,0,"余额"]
["db_invoice","t_user","系统用户表","create_time","bigint(255)",null,"NO","bigint",null,19,0,"创建时间"]
["db_invoice","t_user","系统用户表","is_lock","int(1)",0,"NO","int",null,10,0,"是否锁定"]
["db_invoice","t_user","系统用户表","company_num","varchar(50)",null,"YES","varchar",50,null,null,"企业编号"]
["db_invoice","t_user","系统用户表","price","bigint(255)",0,"NO","bigint",null,19,0,"自有车计费费用"]
["db_invoice","t_user","系统用户表","auto_update","int(1)",1,"NO","int",null,10,0,"是否自动更新开票中的状态"]
["db_invoice","t_user","系统用户表","threshold","varchar(8)",-1,"YES","varchar",8,null,null,"自动开票阈值"]
["db_invoice","t_user","系统用户表","fee","double",0,"YES","double",null,22,null,"etc卡每月收费"]
["db_invoice","t_waybill_Import","运单导入记录表","id","int(100)",null,"NO","int",null,10,0,"主键"]
["db_invoice","t_waybill_Import","运单导入记录表","customerName","varchar(200)",null,"YES","varchar",200,null,null,"客户名称"]
["db_invoice","t_waybill_Import","运单导入记录表","companyName","varchar(200)",null,"YES","varchar",200,null,null,"公司名称"]
["db_invoice","t_waybill_Import","运单导入记录表","billNum","varchar(100)",null,"YES","varchar",100,null,null,"运单编号"]
["db_invoice","t_waybill_Import","运单导入记录表","plateNum","varchar(20)",null,"YES","varchar",20,null,null,"车牌号"]
["db_invoice","t_waybill_Import","运单导入记录表","plateColor","varchar(20)",null,"YES","varchar",20,null,null,"车辆颜色"]
["db_invoice","t_waybill_Import","运单导入记录表","startTime","varchar(20)",null,"YES","varchar",20,null,null,"运单开始时间"]
["db_invoice","t_waybill_Import","运单导入记录表","predictEndTime","varchar(20)",null,"YES","varchar",20,null,null,"运单预计完成时间"]
["db_invoice","t_waybill_Import","运单导入记录表","sourceAddr","varchar(600)",null,"YES","varchar",600,null,null,"运单开始地址"]
["db_invoice","t_waybill_Import","运单导入记录表","destAddr","varchar(600)",null,"YES","varchar",600,null,null,"运单目的地址"]
["db_invoice","t_waybill_Import","运单导入记录表","fee","bigint(20)",null,"YES","bigint",null,19,0,"运单费用 分"]
["db_invoice","t_waybill_Import","运单导入记录表","titleType","int(11)",null,"YES","int",null,10,0,"发票抬头类型 1-默认发票抬头 2-自定义发票抬头"]
["db_invoice","t_waybill_Import","运单导入记录表","taxplayerCode","varchar(50)",null,"YES","varchar",50,null,null,"税号"]
["db_invoice","t_waybill_Import","运单导入记录表","intfaceStartTime","varchar(20)",null,"YES","varchar",20,null,null,"接口开始时间"]
["db_invoice","t_waybill_Import","运单导入记录表","InterfaceEndTime","varchar(20)",null,"YES","varchar",20,null,null,"接口结束时间"]
["db_invoice","t_waybill_Import","运单导入记录表","billwayStatus","int(11)",null,"YES","int",null,10,0,"运单转态 1-开票中 2-作废 3-开票完成"]
["db_invoice","t_waybill_Import","运单导入记录表","hisFlag","int(11)",null,"YES","int",null,10,0,"运单类型 0-实时运单 1-历史运单"]
["db_invoice","t_waybill_Import","运单导入记录表","companyNum","varchar(50)",null,"YES","varchar",50,null,null,"行云公司编号"]
["db_invoice","t_waybill_Import","运单导入记录表","companyAdress","varchar(500)",null,"YES","varchar",500,null,null,"公司地址"]
["db_invoice","t_waybill_Import","运单导入记录表","companyBank","varchar(50)",null,"YES","varchar",50,null,null,"开户行"]
["db_invoice","t_waybill_Import","运单导入记录表","companyBankAcc","varchar(50)",null,"YES","varchar",50,null,null,"开户行账号"]
["db_invoice","t_waybill_Import","运单导入记录表","companyTel","varchar(50)",null,"YES","varchar",50,null,null,"单位电话"]
["db_invoice","t_waybill_Import","运单导入记录表","updateTime","varchar(20)",null,"YES","varchar",20,null,null,"最后一次运单更新时间"]
["db_invoice","t_waybill_Import","运单导入记录表","batchNumber","varchar(50)",null,"YES","varchar",50,null,null,"平台操作批次号"]
["db_invoice","t_waybill_Import","运单导入记录表","batchNumEnd","varchar(50)",null,"YES","varchar",50,null,null,"平台操作结束批次号"]
["db_invoice","t_waybill_Import","运单导入记录表","failReason","varchar(4000)",null,"YES","varchar",4000,null,null,"平台导入失败原因"]
["db_invoice","t_waybill_no","运单记录表","id","int(100)",null,"NO","int",null,10,0,"主键"]
["db_invoice","t_waybill_no","运单记录表","customerName","varchar(200)",null,"YES","varchar",200,null,null,"客户名称"]
["db_invoice","t_waybill_no","运单记录表","companyName","varchar(200)",null,"YES","varchar",200,null,null,"公司名称"]
["db_invoice","t_waybill_no","运单记录表","billNum","varchar(100)",null,"YES","varchar",100,null,null,"运单编号"]
["db_invoice","t_waybill_no","运单记录表","plateNum","varchar(20)",null,"YES","varchar",20,null,null,"车牌号"]
["db_invoice","t_waybill_no","运单记录表","plateColor","varchar(20)",null,"YES","varchar",20,null,null,"车辆颜色"]
["db_invoice","t_waybill_no","运单记录表","startTime","varchar(20)",null,"YES","varchar",20,null,null,"运单开始时间"]
["db_invoice","t_waybill_no","运单记录表","predictEndTime","varchar(20)",null,"YES","varchar",20,null,null,"运单预计完成时间"]
["db_invoice","t_waybill_no","运单记录表","sourceAddr","varchar(600)",null,"YES","varchar",600,null,null,"运单开始地址"]
["db_invoice","t_waybill_no","运单记录表","destAddr","varchar(600)",null,"YES","varchar",600,null,null,"运单目的地址"]
["db_invoice","t_waybill_no","运单记录表","fee","bigint(20)",null,"YES","bigint",null,19,0,"运单费用 分"]
["db_invoice","t_waybill_no","运单记录表","titleType","int(11)",null,"YES","int",null,10,0,"发票抬头类型 1-默认发票抬头 2-自定义发票抬头"]
["db_invoice","t_waybill_no","运单记录表","taxplayerCode","varchar(50)",null,"YES","varchar",50,null,null,"税号"]
["db_invoice","t_waybill_no","运单记录表","intfaceStartTime","varchar(20)",null,"YES","varchar",20,null,null,"接口开始时间"]
["db_invoice","t_waybill_no","运单记录表","InterfaceEndTime","varchar(20)",null,"YES","varchar",20,null,null,"接口结束时间"]
["db_invoice","t_waybill_no","运单记录表","billwayStatus","int(11)",null,"YES","int",null,10,0,"运单转态 1-开票中 2-作废 3-开票完成"]
["db_invoice","t_waybill_no","运单记录表","hisFlag","int(11)",null,"YES","int",null,10,0,"运单类型 0-实时运单 1-历史运单"]
["db_invoice","t_waybill_no","运单记录表","companyNum","varchar(50)",null,"YES","varchar",50,null,null,"行云公司编号"]
["db_invoice","t_waybill_no","运单记录表","companyAdress","varchar(500)",null,"YES","varchar",500,null,null,"公司地址"]
["db_invoice","t_waybill_no","运单记录表","companyBank","varchar(50)",null,"YES","varchar",50,null,null,"开户行"]
["db_invoice","t_waybill_no","运单记录表","companyBankAcc","varchar(50)",null,"YES","varchar",50,null,null,"开户行账号"]
["db_invoice","t_waybill_no","运单记录表","companyTel","varchar(50)",null,"YES","varchar",50,null,null,"单位电话"]
["db_invoice","t_waybill_no","运单记录表","updateTime","varchar(20)",null,"YES","varchar",20,null,null,"最后一次运单更新时间"]
["db_invoice","t_waybill_no","运单记录表","batchNumber","varchar(50)",null,"YES","varchar",50,null,null,"平台操作批次号"]
["db_invoice","t_waybill_no","运单记录表","batchNumEnd","varchar(50)",null,"YES","varchar",50,null,null,"平台操作结束批次号"]
["db_invoice","t_waybill_no","运单记录表","failReason","varchar(4000)",null,"YES","varchar",4000,null,null,"平台导入失败原因"]
["db_invoice","t_waybill_no","运单记录表","interType","int(2)",1,"NO","int",null,10,0,"默认请求方式 0-接口 1-平台"]