{"text_format":"2","workbook":"xlsx","n_sheets":53,"sheets":["目录","码表字典","SI_UPLOAD_LOG","SI_PROJECT_SUMMARY","SI_BANK_INTEREST","SI_EXCHANGE_RATE","SI_BANK_STATEMENT","SI_CATALOG","SI_FAPIAO","SI_FAPIAO_CUSTOMER","SI_FAPIAO_DETAIL","SI_FAPIAO_GOODS","SI_CUSTOMER_CATEGORY","SI_CUSTOMER_CATEGORY_RELATI_1","SI_CUSTOMER_GROUP","SI_CUSTOMER_GROUP_RELATION","SI_CUSTOMER_INFO","SI_CUSTOMER_TAG","SI_CUSTOMER_TAG_RELATION","TB_ENTERPRISE","TB_ENTERPRISE_ENTITY","TB_EXCHANGE_RATE","TB_CURRENCY","TB_KEY_VALUE","SI_BANK_ACCOUNT","SI_BANK_ACCOUNT_BAL","SI_BANK_ACCOUNT_BAL_LOG","SI_BANK_ACCOUNT_EXTRA","SI_ENTERPRISE_ADMINISTRATIV_1","SI_ENTERPRISE_ANNUAL_REPORT","SI_ENTERPRISE_BASIC","SI_ENTERPRISE_BIDDING","SI_ENTERPRISE_CHANGE_RECORD","SI_ENTERPRISE_CORE_TEAM","SI_ENTERPRISE_HOLDING","SI_ENTERPRISE_INTELLECTUAL__1","SI_ENTERPRISE_INVESTMENT","SI_ENTERPRISE_LEGAL_PERSON__1","SI_ENTERPRISE_LEGAL_RISK","SI_ENTERPRISE_PERSONNEL","SI_ENTERPRISE_QUALIFICATION","sys_user","SI_BANK_FLOW_ANALYSIS_RULES","SI_BANK_NOTE","SI_BANK_STATEMENT_EXTRA","SI_BANK_STATEMENT_MARKED","SI_CATA_GROUP","SI_CATA_GROUP_RELATION","SI_CATALOG_INFO","SI_CATALOG_RULE","SI_CATALOG_RULE_LOG","TB_BANK","TB_BANK_INTEREST"],"not_rendered":{"charts":0,"images":1,"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":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,2,0,4]]}
[null,null,"PDManer[元数建模]数据表结构"]
["主题域","#","数据表代码","显示名称","备注"]
["001-尽调基本信息域",1.0,"SI_UPLOAD_LOG","文件上传日志",""]
[null,2.0,"SI_PROJECT_SUMMARY","尽调项目统计信息表",""]
[null,3.0,"SI_BANK_INTEREST","银行结息利率表",""]
[null,4.0,"SI_EXCHANGE_RATE","汇率信息",""]
[null,5.0,"SI_BANK_STATEMENT","银行流水的信息",""]
[null,6.0,"SI_CATALOG","分类信息",""]
[null,7.0,"SI_FAPIAO","发票表",""]
[null,8.0,"SI_FAPIAO_CUSTOMER","发票对应流水对手方表",""]
[null,9.0,"SI_FAPIAO_DETAIL","发票文件补充信息表",""]
[null,10.0,"SI_FAPIAO_GOODS","发票货物表",""]
[null,11.0,"SI_CUSTOMER_CATEGORY","客户分类信息",""]
[null,12.0,"SI_CUSTOMER_CATEGORY_RELATION","客户和分类的关系表",""]
[null,13.0,"SI_CUSTOMER_GROUP","客户组信息",""]
[null,14.0,"SI_CUSTOMER_GROUP_RELATION","客户与分类组映射",""]
[null,15.0,"SI_CUSTOMER_INFO","客户信息表",""]
[null,16.0,"SI_CUSTOMER_TAG","标签信息表",""]
[null,17.0,"SI_CUSTOMER_TAG_RELATION","标签与对象关系表",""]
[null,18.0,"TB_ENTERPRISE","基础_机构信息",""]
[null,19.0,"TB_ENTERPRISE_ENTITY","基础_企业或组与企业实体关系表",""]
[null,20.0,"TB_EXCHANGE_RATE","基础_利率",""]
[null,21.0,"TB_CURRENCY","基础_汇率信息",""]
[null,22.0,"TB_KEY_VALUE","基础_名值对",""]
[null,23.0,"SI_BANK_ACCOUNT","银行账号数据表",""]
["002-流水分析信息域",1.0,"SI_BANK_ACCOUNT_BAL","银行账号余额信息",""]
[null,2.0,"SI_BANK_ACCOUNT_BAL_LOG","余额变更日志",""]
[null,3.0,"SI_BANK_ACCOUNT_EXTRA","账户信息扩展表",""]
["003-主体外部数据信息域",1.0,"SI_ENTERPRISE_ADMINISTRATIVE_LICENSE","企业行政许可表",""]
[null,2.0,"SI_ENTERPRISE_ANNUAL_REPORT","企业年报信息表",""]
[null,3.0,"SI_ENTERPRISE_BASIC","企业基本信息表",""]
[null,4.0,"SI_ENTERPRISE_BIDDING","企业招投标信息表",""]
[null,5.0,"SI_ENTERPRISE_CHANGE_RECORD","企业变更记录表",""]
[null,6.0,"SI_ENTERPRISE_CORE_TEAM","企业核心团队表",""]
[null,7.0,"SI_ENTERPRISE_HOLDING","企业控股表",""]
[null,8.0,"SI_ENTERPRISE_INTELLECTUAL_PROPERTY","企业知识产权表",""]
[null,9.0,"SI_ENTERPRISE_INVESTMENT","企业对外投资表",""]
[null,10.0,"SI_ENTERPRISE_LEGAL_PERSON_INFO","法定代表人相关信息表",""]
[null,11.0,"SI_ENTERPRISE_LEGAL_RISK","企业法律风险表",""]
[null,12.0,"SI_ENTERPRISE_PERSONNEL","企业主要人员表",""]
[null,13.0,"SI_ENTERPRISE_QUALIFICATION","企业资质证书表",""]
["SYS-框架系统管理域",1.0,"sys_user","用户表",""]
["default-默认主题域",1.0,"SI_BANK_FLOW_ANALYSIS_RULES","银行流水分析规则表",""]
[null,2.0,"SI_BANK_NOTE","承兑汇票数据表",""]
[null,3.0,"SI_BANK_STATEMENT_EXTRA","银行流水自定义信息",""]
[null,4.0,"SI_BANK_STATEMENT_MARKED","银行剔除流水",""]
[null,5.0,"SI_CATA_GROUP","分类组信息",""]
[null,6.0,"SI_CATA_GROUP_RELATION","分类与分类组关系",""]
[null,7.0,"SI_CATALOG_INFO","",""]
[null,8.0,"SI_CATALOG_RULE","分类规则",""]
[null,9.0,"SI_CATALOG_RULE_LOG","分类规则执行日志",""]
[null,10.0,"TB_BANK","基础_银行信息",""]
[null,11.0,"TB_BANK_INTEREST","不同年份的默认结息利率表",""]

{"sheet":"码表字典","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["PDManer[元数建模]码表字典"]
["主题域","字典代码","显示名称","#","条目代码","条目显示名称","排序码","父条目代码","条目描述"]
["001-尽调基本信息域"]
["002-流水分析信息域"]
["003-主体外部数据信息域"]
["SYS-框架系统管理域"]
["default-默认主题域"]

{"sheet":"SI_UPLOAD_LOG","index":2,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_UPLOAD_LOG"]
[null,"显示名称","文件上传日志"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"LOG_ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"LOG_TYPE","\"文件类型-invoice or bankstatement ...\"","VARCHAR",250.0,null,null,"√","","",""]
[3.0,"SOURCE","\"来源 http/sftp/email/local\"","VARCHAR",100.0,null,null,"√","","",""]
[4.0,"DATA_TYPE","\"文件类型CSV,EXCEL,MT940, XML\"","VARCHAR",150.0,null,null,"√","","",""]
[5.0,"BANK_NAME","银行名称","VARCHAR",250.0,null,null,null,"","",""]
[6.0,"TEMPLATE_NAME","模板名","VARCHAR",150.0,null,null,"√","","",""]
[7.0,"UPLOAD_FILE_NAME","上传文件名称","VARCHAR",240.0,null,null,null,"","",""]
[8.0,"DOWNLOAD_FILE_NAME","保存后文件名称","VARCHAR",1010.0,null,null,null,"","",""]
[9.0,"FILE_URL","文件路径","VARCHAR",1000.0,null,null,"√","","",""]
[10.0,"FILE_SIZE","文件大小","INT",{"$nulls":4},"0","",""]
[11.0,"FILE_UPLOAD_TIME","上传时间","DATETIME",{"$nulls":4},"","",""]
[12.0,"STATUS","状态","INT",null,null,null,"√","0","",""]
[13.0,"UPLOAD_STATUS_DESC","状态说明","VARCHAR",250.0,null,null,null,"","",""]
[14.0,"TRX_DATE_START","上传最小日期Id","INT",{"$nulls":4},"0","",""]
[15.0,"TRX_DATE_END","上传最大日期Id","INT",{"$nulls":4},"0","",""]
[16.0,"TOTAL_RECORDS","记录数","INT",{"$nulls":4},"0","",""]
[17.0,"TOTAL_AMOUNT_DR","流入金额","DECIMAL",19.0,2.0,null,null,"","",""]
[18.0,"TOTAL_AMOUNT_CR","流出金额","DECIMAL",19.0,2.0,null,null,"","",""]
[19.0,"LOAD_START_TIME","加载开始时间","DATETIME",{"$nulls":4},"","",""]
[20.0,"LOAD_END_TIME","加载完成时间","DATETIME",{"$nulls":4},"","",""]
[21.0,"COMMENTS","备注","VARCHAR",1000.0,null,null,null,"","",""]
[22.0,"LOG_META","附加信息","VARCHAR",1000.0,null,null,null,"","",""]
[23.0,"OVERRIDE_DETAIL","被覆盖信息","VARCHAR",2500.0,null,null,null,"","",""]
[24.0,"OVERRIDE_CONFIRMBY","确认人>0","BIGINT",{"$nulls":4},"0","",""]
[25.0,"OVERRIDE_CONFIRMDATE","覆盖确认时间","DATETIME",{"$nulls":4},"","",""]
[26.0,"FILE_UPLOAD_BY","文件上传者","BIGINT",{"$nulls":4},"","",""]
[27.0,"FILE_DELETE_TIME","文件删除时间","DATETIME",{"$nulls":4},"","",""]
[28.0,"FILE_DELETE_BY","文件删除者","BIGINT",{"$nulls":4},"","",""]
[29.0,"REAL_LE_ID","企业ID","BIGINT",{"$nulls":4},"0","",""]
[30.0,"ORIGIN_FILE_URL","源文件路径","VARCHAR",1000.0,null,null,null,"","",""]
[31.0,"MD5","源文件验证码","VARCHAR",500.0,null,null,null,"","",""]
[32.0,"GROUP_ID","项目ID","INT",{"$nulls":4},"","",""]
[33.0,"LE_ID","流水主体ID","VARCHAR",200.0,null,null,null,"","",""]

{"sheet":"SI_PROJECT_SUMMARY","index":3,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_PROJECT_SUMMARY"]
[null,"显示名称","尽调项目统计信息表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"GROUP_ID","项目ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ACCOUNT_NUM","账户数","INT",{"$nulls":4},"","",""]
[3.0,"ENTERPRISE_NUM","企业数","INT",{"$nulls":4},"","",""]
[4.0,"DATA_ENTRY_DONE","流水数据是否录入","INT",{"$nulls":4},"","",""]
[5.0,"START_DATE_ID","流水开始日期","INT",{"$nulls":4},"","",""]
[6.0,"END_DATE_ID","流水结束日期","INT",{"$nulls":4},"","",""]
[7.0,"TOTAL_CR_AMOUNT","收入金额汇总","DECIMAL",19.0,2.0,null,null,"","",""]
[8.0,"TOTAL_DR_AMOUNT","支出金额汇总","DECIMAL",19.0,2.0,null,null,"","",""]
[9.0,"TOTAL_IMPORT_RECORD","累计导入流水条数","INT",{"$nulls":4},"0","",""]
[10.0,"TOTAL_DELETED_RECORD","已删除流水条数","INT",{"$nulls":4},"0","",""]
[11.0,"TOTAL_RECORD_DR","支付数据条数","INT",{"$nulls":4},"0","",""]
[12.0,"TOTAL_RECORD_CR","收入数据条数","INT",{"$nulls":4},"0","",""]
[13.0,"BS_UPLOAD_FILE_NUM","流水上传文件数","INT",{"$nulls":4},"","",""]
[14.0,"LAST_UPDATE_TIME","项目更新或创建时间","DATETIME",{"$nulls":4},"","",""]
[15.0,"CREATED_TIME","本记录的创建时间","DATETIME",{"$nulls":4},"","",""]
[16.0,"CREATED_BY","本记录的创建者","BIGINT",{"$nulls":4},"","",""]
[17.0,"UPDATED_TIME","本记录的修改时间","DATETIME",{"$nulls":4},"","",""]
[18.0,"UPDATED_BY","本记录的修改着","BIGINT",{"$nulls":4},"","",""]
[19.0,"FAPIAO_START_DATE_ID","发票数据开始时间","INT",{"$nulls":4},"0","",""]
[20.0,"FAPIAO_END_DATE_ID","发票数据结束时间","INT",{"$nulls":4},"0","",""]
[21.0,"FAPIAO_UPLOAD_FILE_NUM","发票上传文件数","INT",{"$nulls":4},"0","",""]
[22.0,"DATA_QUALITY_SCORE","综合数据质量评分","DECIMAL",10.0,4.0,null,null,"","",""]
[23.0,"BS_MONTH_COUNT","流水分析数据时长（单位：月）","INT",{"$nulls":4},"","",""]
[24.0,"VALID_CR_AMOUNT","有效流入","DECIMAL",19.0,2.0,null,null,"","",""]
[25.0,"LOAN_COUNT","往来借贷方个数","INT",{"$nulls":4},"","",""]
[26.0,"LOAN_AMOUNT","借贷规模变动","DECIMAL",19.0,2.0,null,null,"","",""]

{"sheet":"SI_BANK_INTEREST","index":4,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_INTEREST"]
[null,"显示名称","银行结息利率表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","","INT",null,null,"√","√","","",""]
[2.0,"ABBR","银行简称","BIGINT",null,null,null,"√","","",""]
[3.0,"NAME","银行名称","VARCHAR",250.0,null,null,"√","","",""]
[4.0,"YEARNUM","年份数","INT",null,null,null,"√","","",""]
[5.0,"Q1TH_INTEREST","第一季度活期利息","DECIMAL",8.0,6.0,null,null,"0.000000","",""]
[6.0,"Q2ND_INTEREST","第二季度活期利息","DECIMAL",8.0,6.0,null,null,"0.000000","",""]
[7.0,"Q3RD_INTEREST","第三季度活期利息","DECIMAL",8.0,6.0,null,null,"0.000000","",""]
[8.0,"Q4TH_INTEREST","第四季度活期利息","DECIMAL",8.0,6.0,null,null,"0.000000","",""]
[9.0,"CREATED_BY","","INT",{"$nulls":4},"0","",""]
[10.0,"CREATED_DATE","","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_EXCHANGE_RATE","index":5,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_EXCHANGE_RATE"]
[null,"显示名称","汇率信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"EXCHANGE_RATE_ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"LE_ID","企业ID","INT",{"$nulls":4},"0","",""]
[3.0,"CURRENCY_FROM","from货币","VARCHAR",3.0,null,null,"√","'CNY'","",""]
[4.0,"CURRENCY_TO","to货币","VARCHAR",3.0,null,null,"√","'CNY'","",""]
[5.0,"START_DATE_ID","汇率开始时间","INT",{"$nulls":4},"0","",""]
[6.0,"END_DATE_ID","汇率结束时间","INT",{"$nulls":4},"0","",""]
[7.0,"RATE","汇率","DECIMAL",16.0,8.0,null,null,"1.00000000","",""]
[8.0,"CREATE_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[9.0,"CREATED_BY","创建者","BIGINT",null,null,null,"√","","",""]

{"sheet":"SI_BANK_STATEMENT","index":6,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_STATEMENT"]
[null,"显示名称","银行流水的信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"BANK_STATEMENT_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"LE_ID","租户ID","INT UNSIGNED",{"$nulls":4},"0","",""]
[3.0,"ACCOUNT_ID","账号ID","BIGINT UNSIGNED",null,null,null,"√","0","",""]
[4.0,"LE_ACCOUNT_NAME","银行账号名称","VARCHAR",240.0,null,null,null,"'NONE'","",""]
[5.0,"LE_ACCOUNT_NO","银行账号","VARCHAR",240.0,null,null,null,"","",""]
[6.0,"ACCOUNTING_DATE_ID","账号日期ID","INT",{"$nulls":4},"","",""]
[7.0,"ACCOUNTING_DATE","账号日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[8.0,"TRX_DATE","交易日期","VARCHAR",20.0,null,null,"√","","",""]
[9.0,"CURRENCY","币种","VARCHAR",10.0,null,null,null,"","",""]
[10.0,"AMOUNT_DR","付款金额","DECIMAL",19.0,2.0,null,"√","0.00","",""]
[11.0,"AMOUNT_CR","收款金额","DECIMAL",19.0,2.0,null,"√","0.00","",""]
[12.0,"AMOUNT_BALANCE","余额","DECIMAL",19.0,2.0,null,"√","","",""]
[13.0,"CASH_TYPE","交易类型","VARCHAR",500.0,null,null,null,"","",""]
[14.0,"CUSTOMER_LE_ID","对手客户ID","INT",{"$nulls":4},"-1","",""]
[15.0,"CUSTOMER_ACCOUNT_NAME","客户账号名称","VARCHAR",240.0,null,null,null,"","",""]
[16.0,"CUSTOMER_ACCOUNT_NO","客户账号","VARCHAR",240.0,null,null,null,"","",""]
[17.0,"CUSTOMER_BANK","客户银行","VARCHAR",300.0,null,null,null,"","",""]
[18.0,"CUSTOMER_REFERENCE","客户备注信息","VARCHAR",500.0,null,null,null,"","",""]
[19.0,"USER_MEMO","用户交易摘要","VARCHAR",1000.0,null,null,null,"","",""]
[20.0,"BANK_COMMENTS","银行交易摘要","VARCHAR",240.0,null,null,null,"","",""]
[21.0,"BANK_TRX_NUMBER","银行交易号","VARCHAR",240.0,null,null,null,"","",""]
[22.0,"BANK","所属银行缩写","VARCHAR",250.0,null,null,"√","","",""]
[23.0,"TRX_FLAG","交易标志位","VARCHAR",2.0,null,null,null,"'0'","",""]
[24.0,"TRX_TYPE","分类ID","INT",null,null,null,"√","0","",""]
[25.0,"EXCEPTION_TYPE","异常类型","VARCHAR",50.0,null,null,"√","","",""]
[26.0,"INTERNAL_FLAG","\"是否为内部交易1 是 0 否\"","BIT",1.0,null,null,null,"0","",""]
[27.0,"BATCH_ID","上传LOGID对应UPLOAD_LOG","INT",null,null,null,"√","0","",""]
[28.0,"BATCH_SEQUENCE","每次上传在文件中的LINE","INT",null,null,null,"√","","",""]
[29.0,"CREATE_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[30.0,"CREATED_BY","创建者","BIGINT UNSIGNED",null,null,null,"√","0","",""]
[31.0,"UPDATED_DATE","更新时间","DATETIME",{"$nulls":4},"","",""]
[32.0,"META_JSON","附加信息","TEXT",{"$nulls":4},"","",""]
[33.0,"NO_BALANCE","是否有余额信息","BIT",1.0,null,null,null,"0","",""]
[34.0,"BEGIN_BALANCE","是否初始余额","BIT",1.0,null,null,null,"0","是否为日初余额记录，0为否，1为是",""]
[35.0,"END_BALANCE","是否最终余额","BIT",1.0,null,null,null,"0","是否为日末余额记录，0为否，1为是",""]
[36.0,"SPLIT","是否拆分","INT",{"$nulls":4},"0","",""]
[37.0,"GROUP_ID","项目ID，也是租户ID","INT",{"$nulls":4},"0","",""]
[38.0,"SOURCE_CATALOG_ID","系统默认分类ID,首次分类时填入,后续不做更新","BIGINT",null,null,null,"√","0","",""]

{"sheet":"SI_CATALOG","index":7,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CATALOG"]
[null,"显示名称","分类信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"CATALOG_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"LE_ID","企业ID","BIGINT",null,null,null,"√","0","",""]
[3.0,"CATALOG_NAME","分类目录名称","VARCHAR",250.0,null,null,"√","","",""]
[4.0,"CATALOG_DESC","分类目录备注","VARCHAR",1000.0,null,null,"√","","",""]
[5.0,"CATALOG_TYPE","\"分类类型 营业性\"","VARCHAR",250.0,null,null,"√","","",""]
[6.0,"SPECIAL_FLAG","\"分类特殊标识 DEFAULT-默认分类 CUSTOMER-客户收入\"","VARCHAR",250.0,null,null,"√","","",""]
[7.0,"PAYMENT_FLAG","\"收支类型 P-支 R-收\"","VARCHAR",50.0,null,null,null,"","",""]
[8.0,"FORECAST_METHOD","预测方式","VARCHAR",250.0,null,null,null,"","",""]
[9.0,"FORECAST_LOCK","预测锁","INT",{"$nulls":4},"0","",""]
[10.0,"FORECAST_MODEL","预测模型","VARCHAR",250.0,null,null,null,"","",""]
[11.0,"FORECAST_SPLIT_METHOD","预测方式","VARCHAR",250.0,null,null,null,"","",""]
[12.0,"FORECAST_OLD_DAYS","预测数据取值过去多少天的数据?","INT",{"$nulls":4},"0","",""]
[13.0,"PARENT_ID","二级分类的话PARENT_ID不为0","BIGINT",null,null,null,"√","0","",""]
[14.0,"LIST_ORDER","排列顺序","INT",{"$nulls":4},"0","",""]
[15.0,"VALID","是否停用","INT",{"$nulls":4},"1","",""]
[16.0,"DELETE_FLAG","是否删除","INT",{"$nulls":4},"0","",""]
[17.0,"CREATION_DATE","创建时间","DATETIME",null,null,null,"√","","",""]
[18.0,"FORECAST_SYSTEM","预测系统","INT",{"$nulls":4},"0","",""]

{"sheet":"SI_FAPIAO","index":8,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_FAPIAO"]
[null,"显示名称","发票表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"FAPIAO_ID","","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"LE_ID","本方企业id,默认0","BIGINT",null,null,null,"√","0","",""]
[3.0,"GROUP_ID","项目id","BIGINT",null,null,null,"√","","",""]
[4.0,"FAPIAO_UNIQUE_NO","发票唯一识别号","VARCHAR",100.0,null,null,"√","","",""]
[5.0,"FAPIAO_CODE","发票代码","VARCHAR",50.0,null,null,null,"","",""]
[6.0,"FAPIAO_NO","发票号码","VARCHAR",50.0,null,null,null,"","",""]
[7.0,"CONSUMER_TAX_NO","购买方纳税人识别号","VARCHAR",50.0,null,null,null,"","",""]
[8.0,"CONSUMER_NAME","购买方纳税人名称","VARCHAR",100.0,null,null,"√","","",""]
[9.0,"SELLER_TAX_NO","销售方纳税人名称","VARCHAR",50.0,null,null,null,"","",""]
[10.0,"SELLER_NAME","销售方纳税人名称","VARCHAR",100.0,null,null,"√","","",""]
[11.0,"AMOUNT","发票金额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[12.0,"TAX_AMOUNT","税额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[13.0,"TAX_RATE","税率","DECIMAL",8.0,4.0,null,null,"0.0000","",""]
[14.0,"TOTAL_AMOUNT","价税合计","DECIMAL",19.0,2.0,null,"√","0.00","",""]
[15.0,"DATE_ID","开票日期id","INT",null,null,null,"√","","",""]
[16.0,"FAPIAO_DATE","开票日期","DATETIME",null,null,null,"√","","",""]
[17.0,"FAPIAO_TYPE","发票类型","VARCHAR",50.0,null,null,null,"","",""]
[18.0,"FAPIAO_STATUS","发票状态：0正常，1作废，2红冲","INT",null,null,null,"√","0","",""]
[19.0,"FAPIAO_FLAG","进项1/销项2","INT",null,null,null,"√","0","",""]
[20.0,"GOODS_NAME","货物名称","VARCHAR",200.0,null,null,"√","","",""]
[21.0,"BATCH_ID","上传文件log_id","BIGINT",null,null,null,"√","","",""]
[22.0,"SYSTEM_GENERATE","是否由系统生成，0否1是，默认否","INT",null,null,null,"√","0","",""]
[23.0,"CREATE_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_FAPIAO_CUSTOMER","index":9,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_FAPIAO_CUSTOMER"]
[null,"显示名称","发票对应流水对手方表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","编号","BIGINT",null,null,"√","√","","",""]
[2.0,"GROUP_ID","项目ID","BIGINT",null,null,null,"√","","",""]
[3.0,"FAPIAO_NAME","发票名","VARCHAR",50.0,null,null,"√","","",""]
[4.0,"CUSTOMER_NAME","关联流水对手方名","VARCHAR",50.0,null,null,"√","","",""]

{"sheet":"SI_FAPIAO_DETAIL","index":10,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_FAPIAO_DETAIL"]
[null,"显示名称","发票文件补充信息表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"DETAIL_ID","","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"LOG_ID","上传文件id","BIGINT",null,null,null,"√","","",""]
[3.0,"COMPANY_ID","本方企业id","BIGINT",null,null,null,"√","","",""]
[4.0,"COMPANY_NAME","本方企业名称","VARCHAR",100.0,null,null,"√","","",""]
[5.0,"FILE_TYPE","区分文件类型 0:汇总表,1:明细表","INT",null,null,null,"√","","",""]
[6.0,"FAPIAO_FLAG","进项1/销项2","INT",null,null,null,"√","0","",""]
[7.0,"GROUP_ID","项目id","BIGINT",null,null,null,"√","","",""]
[8.0,"CREATE_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[9.0,"UPDATE_DATE","更新时间","DATETIME",{"$nulls":4},"","",""]
[10.0,"SUBJECT_TYPE","主体类型：自然人主体（naturalPerson），法人主体（legalPerson)","VARCHAR",100.0,null,null,null,"","",""]

{"sheet":"SI_FAPIAO_GOODS","index":11,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_FAPIAO_GOODS"]
[null,"显示名称","发票货物表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"GOODS_ID","","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"LE_ID","本方企业id,默认0","BIGINT",null,null,null,"√","0","",""]
[3.0,"GROUP_ID","项目id","BIGINT",null,null,null,"√","","",""]
[4.0,"FAPIAO_UNIQUE_NO","发票唯一识别号","VARCHAR",100.0,null,null,null,"","",""]
[5.0,"FAPIAO_CODE","发票代码","VARCHAR",50.0,null,null,null,"","",""]
[6.0,"FAPIAO_NO","发票号码","VARCHAR",50.0,null,null,null,"","",""]
[7.0,"CONSUMER_TAX_NO","购买方纳税人识别号","VARCHAR",50.0,null,null,null,"","",""]
[8.0,"CONSUMER_NAME","购买方纳税人名称","VARCHAR",100.0,null,null,"√","","",""]
[9.0,"SELLER_TAX_NO","销售方纳税人名称","VARCHAR",50.0,null,null,null,"","",""]
[10.0,"SELLER_NAME","销售方纳税人名称","VARCHAR",100.0,null,null,"√","","",""]
[11.0,"AMOUNT","发票金额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[12.0,"TAX_AMOUNT","税额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[13.0,"TAX_RATE","税率","DECIMAL",8.0,4.0,null,null,"0.0000","",""]
[14.0,"TOTAL_AMOUNT","价税合计","DECIMAL",19.0,2.0,null,"√","0.00","",""]
[15.0,"DATE_ID","开票日期id","INT",null,null,null,"√","","",""]
[16.0,"FAPIAO_DATE","开票日期","DATETIME",null,null,null,"√","","",""]
[17.0,"ORDER_NO","序号","INT",{"$nulls":4},"","",""]
[18.0,"GOODS_NAME","货物名称","VARCHAR",200.0,null,null,null,"","",""]
[19.0,"GOODS_TYPE","货物品类","VARCHAR",100.0,null,null,null,"","",""]
[20.0,"GOODS_CODE","货物编码","VARCHAR",50.0,null,null,null,"","",""]
[21.0,"GOODS_SPECIFICATION","规格型号","VARCHAR",100.0,null,null,null,"","",""]
[22.0,"QUANTITY","货物数量","VARCHAR",50.0,null,null,null,"","",""]
[23.0,"UNIT","计量单位","VARCHAR",100.0,null,null,null,"","",""]
[24.0,"UNIT_PRICE","单价","DECIMAL",19.0,2.0,null,null,"","",""]
[25.0,"CONSUMER_ADDRESS_PHONE","购方地址电话","VARCHAR",600.0,null,null,null,"","",""]
[26.0,"CONSUMER_BANK_ACCOUNT","购方银行账号","VARCHAR",600.0,null,null,null,"","",""]
[27.0,"SELLER_ADDRESS_PHONE","销方地址电话","VARCHAR",600.0,null,null,null,"","",""]
[28.0,"SELLER_BANK_ACCOUNT","销方银行账号","VARCHAR",600.0,null,null,null,"","",""]
[29.0,"BATCH_ID","上传文件log_id","BIGINT",null,null,null,"√","","",""]
[30.0,"SYSTEM_GENERATE","是否由系统生成，0否1是，默认否","INT",null,null,null,"√","0","",""]
[31.0,"CREATE_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_CUSTOMER_CATEGORY","index":12,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CUSTOMER_CATEGORY"]
[null,"显示名称","客户分类信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"CATEGORY_ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"LE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"CATEGORY_NAME","分类名称","VARCHAR",200.0,null,null,null,"","",""]
[4.0,"CATEGORY_TYPE","分类类型","VARCHAR",200.0,null,null,null,"","",""]
[5.0,"CATEGORY_FLAG","P-供应商，R-客户","VARCHAR",10.0,null,null,null,"","",""]
[6.0,"PARENT_ID","父分类ID","BIGINT",{"$nulls":4},"0","",""]
[7.0,"PRIORITY","优先级","BIGINT",{"$nulls":4},"0","",""]
[8.0,"CREATED_BY","创建者","BIGINT",{"$nulls":4},"","",""]
[9.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[10.0,"UPDATED_BY","更新者","BIGINT",{"$nulls":4},"","",""]
[11.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_CUSTOMER_CATEGORY_RELATI_1","index":13,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CUSTOMER_CATEGORY_RELATION"]
[null,"显示名称","客户和分类的关系表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"RELATION_ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"FLOW_SUBJECT_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"CUSTOMER_ID","客户ID","BIGINT",{"$nulls":4},"","",""]
[4.0,"CUSTOMER_CATEGORY_ID","客户分类","BIGINT",{"$nulls":4},"","",""]
[5.0,"CREATED_BY","创建者","BIGINT",{"$nulls":4},"","",""]
[6.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_CUSTOMER_GROUP","index":14,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CUSTOMER_GROUP"]
[null,"显示名称","客户组信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"CUSTOMER_GROUP_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",null,null,null,"√","0","",""]
[3.0,"CUSTOMER_GROUP_NAME","分组名称","VARCHAR",250.0,null,null,"√","","",""]
[4.0,"CUSTOMER_GROUP_DESC","分组描述","VARCHAR",250.0,null,null,null,"","",""]
[5.0,"PAYMENT_FLAG","\"P-核心支出 R-核心收入\"","VARCHAR",5.0,null,null,null,"","",""]
[6.0,"IS_DELETE","\"0-有效 1-已删除\"","INT",{"$nulls":4},"0","",""]
[7.0,"CREATED_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[8.0,"CREATEDBY","创建人","BIGINT",{"$nulls":4},"0","",""]
[9.0,"UPDATE_DATE","更新时间","DATETIME",{"$nulls":4},"","",""]
[10.0,"UPDATEBY","修改人","BIGINT",{"$nulls":4},"0","",""]

{"sheet":"SI_CUSTOMER_GROUP_RELATION","index":15,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CUSTOMER_GROUP_RELATION"]
[null,"显示名称","客户与分类组映射"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"RELATION_ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"CUSTOMER_ID","客户ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"CUSTOMER_GROUP_ID","客户组","BIGINT",{"$nulls":4},"","",""]
[4.0,"ENTERPRISE_ID","\"企业 ID\"","BIGINT",{"$nulls":4},"","",""]
[5.0,"IS_DELETE","\"0-有效 1-已删除\"","INT",{"$nulls":4},"0","",""]
[6.0,"CREATED_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[7.0,"CREATE_BY","创建人","BIGINT",{"$nulls":4},"0","",""]
[8.0,"UPDATE_DATE","更新时间","DATETIME",{"$nulls":4},"","",""]
[9.0,"UPDATEBY","修改人","BIGINT",{"$nulls":4},"0","",""]

{"sheet":"SI_CUSTOMER_INFO","index":16,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CUSTOMER_INFO"]
[null,"显示名称","客户信息表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"CUSTOMER_ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",null,null,null,"√","0","",""]
[3.0,"CUSTOMER_NAME","客户名字","VARCHAR",500.0,null,null,"√","","",""]
[4.0,"CUSTOMER_DESC","客户描述","VARCHAR",250.0,null,null,"√","","",""]
[5.0,"GROUP_ID","分组的组ID","BIGINT",null,null,null,"√","0","",""]
[6.0,"GROUP_FLAG","\"0-不是group 1-是group\"","TINYINT",null,null,null,"√","0","",""]
[7.0,"CUSTOMER_TYPE","\"1-供应商  2-两者都是 3-客户\"","INT",null,null,null,"√","1","",""]
[8.0,"SPECIAL_FLAG","特殊标识","VARCHAR",150.0,null,null,"√","","",""]
[9.0,"CUSTOMER_CITY","客户所在城市","VARCHAR",100.0,null,null,null,"","",""]
[10.0,"LOCATION","地址信息","VARCHAR",1000.0,null,null,"√","","",""]
[11.0,"CREATION_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[12.0,"INTERCOMPANY","关联方标识","BIT",1.0,null,null,null,"0","",""]
[13.0,"CREATEDBY","创建人","BIGINT",{"$nulls":4},"0","",""]
[14.0,"CUSTOMER_CODE","客户代码","VARCHAR",240.0,null,null,null,"","",""]
[15.0,"INVOICE_RECON_FLAG","发票对账标志","INT",{"$nulls":4},"0","",""]
[16.0,"IS_COMPANY","0-个人，1-公司，2-缺省","INT",{"$nulls":4},"2","",""]
[17.0,"PROVINCE","省份","VARCHAR",10.0,null,null,null,"","",""]
[18.0,"ESTIBLISH_DATE","企业成立日期","VARCHAR",10.0,null,null,null,"","",""]
[19.0,"INDUSTRY","行业","VARCHAR",256.0,null,null,null,"","",""]
[20.0,"CUSTOMER_TAG_NAME","往来借贷方类型标签(银行、非银、企业、个人、其他)","VARCHAR",50.0,null,null,null,"","",""]
[21.0,"REGISTER_AMOUNT","注册资本","DECIMAL",23.0,2.0,null,null,"0.00","",""]
[22.0,"REGISTER_CAPITAL_UNIT","注册资本币种","VARCHAR",45.0,null,null,null,"","",""]
[23.0,"REGISTER_LOCATION","注册地址","VARCHAR",200.0,null,null,null,"","",""]
[24.0,"STAFF_NUM_RANGE","人员规模","VARCHAR",10.0,null,null,null,"","",""]

{"sheet":"SI_CUSTOMER_TAG","index":17,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CUSTOMER_TAG"]
[null,"显示名称","标签信息表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"TAG_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","项目ID","INT",{"$nulls":4},"","",""]
[3.0,"TAG_NAME","标签名称","VARCHAR",255.0,null,null,"√","","",""]
[4.0,"TAG_CODE","标签编码","VARCHAR",255.0,null,null,null,"","",""]
[5.0,"TAG_TYPE","标签类型","VARCHAR",500.0,null,null,null,"","",""]
[6.0,"TAG_COLOUR","标签颜色","VARCHAR",50.0,null,null,null,"","",""]
[7.0,"TAG_ORDER","","INT",{"$nulls":4},"0","",""]
[8.0,"CREATED_BY","创建者","INT",{"$nulls":4},"0","",""]
[9.0,"CREATED_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_CUSTOMER_TAG_RELATION","index":18,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CUSTOMER_TAG_RELATION"]
[null,"显示名称","标签与对象关系表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"RELATION_ID","ID","INT UNSIGNED",null,null,"√","√","","",""]
[2.0,"LE_ID","企业ID","INT",{"$nulls":4},"0","",""]
[3.0,"OBJECT_ID","对象ID","BIGINT",null,null,null,"√","0","",""]
[4.0,"CUSTOMER_GROUP_ID","","BIGINT",{"$nulls":4},"0","",""]
[5.0,"TAG_ID","标签ID","BIGINT",null,null,null,"√","","",""]
[6.0,"CREATED_BY","创建者","INT",{"$nulls":4},"0","",""]
[7.0,"CREATED_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[8.0,"RELATION_TYPE","0:默认，1:文件导入的关系","INT",null,null,null,"√","0","",""]

{"sheet":"TB_ENTERPRISE","index":19,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","TB_ENTERPRISE"]
[null,"显示名称","基础_机构信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ENTERPRISE_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"GROUP_ID","企业所在集团","BIGINT",null,null,null,"√","","",""]
[3.0,"ENTERPRISE_TYPE","\"company-企业  group-组别 org-组织\"","VARCHAR",50.0,null,null,"√","'company'","",""]
[4.0,"ENTERPRISE_NAME","企业名","VARCHAR",500.0,null,null,"√","","",""]
[5.0,"ENTERPRISE_INFO","企业备注","TEXT",null,null,null,"√","","",""]
[6.0,"INDUSTRY_ID","所属行业","BIGINT UNSIGNED",null,null,null,"√","0","",""]
[7.0,"ORG_CODE","组织代码","VARCHAR",300.0,null,null,"√","","",""]
[8.0,"REGISTERED_CAPITAL","注册资本","DECIMAL UNSIGNED",19.0,2.0,null,null,"0.00","",""]
[9.0,"ADDRESS","地址","VARCHAR",500.0,null,null,"√","","",""]
[10.0,"CITY","所在城市","VARCHAR",250.0,null,null,"√","","",""]
[11.0,"BANK_ID","开户行ID","BIGINT UNSIGNED",null,null,null,"√","0","",""]
[12.0,"CREATED_BY","创建人","BIGINT",null,null,null,"√","","",""]
[13.0,"CREATION_DATE","创建时间","DATETIME",null,null,null,"√","","",""]
[14.0,"VALID","\"是否有效 0-无效 1-有效\"","TINYINT UNSIGNED",null,null,null,"√","1","",""]
[15.0,"LICENSE_CODE","授权码","VARCHAR",50.0,null,null,null,"","",""]
[16.0,"REGISTERED_CAPITAL_CURRENCY","注册资本货币种类","VARCHAR",10.0,null,null,null,"","",""]
[17.0,"SOCIAL_CREDIT_CODE","纳税人号","VARCHAR",40.0,null,null,null,"","",""]
[18.0,"COUNTRY","国家","VARCHAR",40.0,null,null,null,"","",""]
[19.0,"COMMENT","备注","VARCHAR",200.0,null,null,null,"","",""]
[20.0,"SUB_GROUP_TYPE","0 组织性分组类型 1工作性分组类型","INT",{"$nulls":4},"0","",""]
[21.0,"ENTERPRISE_SORT","排序字段","INT",{"$nulls":4},"0","",""]
[22.0,"ORG_VERSION","尽调系统-机构版本(Base-基础版/Core-标准版)","VARCHAR",50.0,null,null,null,"","",""]
[23.0,"ANALYSIS_TYPE","分析类型: 0 对公/综合 ","VARCHAR",20.0,null,null,null,""," -1 个人 ",""]
[24.0,"IGNORE_FLAG","推荐工商信息是否忽略","INT",{"$nulls":4},"0","",""]
[25.0,"LE_TYPE","主体类型：自然人主体（naturalPerson），法人主体（legalPerson)","VARCHAR",100.0,null,null,null,"","",""]
[26.0,"BUSINESS_NAME","工商信息最新名称","VARCHAR",500.0,null,null,null,"","",""]
[27.0,"PROJECT_STATUS","项目状态：0未选择\n1审核中\n2审核通过\n3审核未通过\n4异常\n5已取消","INT",{"$nulls":4},"0","",""]
[28.0,"APP_ID","第三方系统申请创建项目时的固定值，用于生成报告后的回调url查询","VARCHAR",100.0,null,null,null,"","",""]

{"sheet":"TB_ENTERPRISE_ENTITY","index":20,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","TB_ENTERPRISE_ENTITY"]
[null,"显示名称","基础_企业或组与企业实体关系表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"EE_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业或者组ID","BIGINT",null,null,null,"√","","",""]
[3.0,"LE_ID","企业实体ID","BIGINT",null,null,null,"√","","",""]
[4.0,"VALID","\"有效 0-Invalid 1-Valid\"","SMALLINT",null,null,null,"√","1","",""]
[5.0,"CREATION_DATE","创建时间","DATETIME",null,null,null,"√","","",""]

{"sheet":"TB_EXCHANGE_RATE","index":21,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","TB_EXCHANGE_RATE"]
[null,"显示名称","基础_利率"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"CURRENCY_FROM","源币种","VARCHAR",10.0,null,null,null,"","",""]
[3.0,"CURRENCY_TO","目标币种","VARCHAR",10.0,null,null,null,"","",""]
[4.0,"DATE_ID","日期ID","INT",{"$nulls":4},"","",""]
[5.0,"RATE","汇率","DECIMAL",8.0,4.0,null,null,"","",""]
[6.0,"CREATE_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[7.0,"CREATED_BY","创建者","INT",{"$nulls":4},"","",""]

{"sheet":"TB_CURRENCY","index":22,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","TB_CURRENCY"]
[null,"显示名称","基础_汇率信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","自增ID","BIGINT",null,null,"√","√","","",""]
[2.0,"CURRENCY","汇率","VARCHAR",20.0,null,null,null,"","",""]
[3.0,"CN_DESC","中文名","VARCHAR",100.0,null,null,null,"","",""]
[4.0,"EN_DESC","英文名","VARCHAR",100.0,null,null,null,"","",""]
[5.0,"LIST_ORDER","排列序号","BIGINT",{"$nulls":4},"","",""]

{"sheet":"TB_KEY_VALUE","index":23,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","TB_KEY_VALUE"]
[null,"显示名称","基础_名值对"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"KEY_ID","主键id","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"KEY_TYPE","类型","VARCHAR",100.0,null,null,"√","","",""]
[3.0,"KEY_NAME","名称","VARCHAR",250.0,null,null,"√","","",""]
[4.0,"KEY_VALUE","","VARCHAR",1000.0,null,null,null,"","",""]
[5.0,"KEY_DESC","属性描述","VARCHAR",500.0,null,null,"√","","",""]
[6.0,"KEY_ORDER","顺序","INT",null,null,null,"√","","",""]
[7.0,"CREATION_DATE","创建时间","DATETIME",null,null,null,"√","","",""]
[8.0,"VALID","是否可用","INT",null,null,null,"√","1","",""]
[9.0,"LE_ID","企业ID","BIGINT",null,null,null,"√","0","",""]

{"sheet":"SI_BANK_ACCOUNT","index":24,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_ACCOUNT"]
[null,"显示名称","银行账号数据表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ACCOUNT_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"LE_ID","企业ID","BIGINT",null,null,null,"√","","",""]
[3.0,"BANK","银行标识","VARCHAR",250.0,null,null,"√","","",""]
[4.0,"ACCOUNT_NO","账号","VARCHAR",250.0,null,null,"√","","",""]
[5.0,"ACCOUNT_NAME","账户名称","VARCHAR",250.0,null,null,null,"","",""]
[6.0,"ACCOUNT_NAME_2","账户名2-可以为英文名","VARCHAR",250.0,null,null,null,"","",""]
[7.0,"ACCOUNT_TYPE","账号类型","VARCHAR",150.0,null,null,"√","","",""]
[8.0,"AGREEMENT_AMOUNT","\"协议存款额度 0 表示没有协定存款\"","DECIMAL",19.0,2.0,null,"√","0.00","",""]
[9.0,"SPECIAL_FLAG","特殊标记","VARCHAR",150.0,null,null,"√","","",""]
[10.0,"INIT_BALANCE","期初余额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[11.0,"CURRENCY","账号货币","VARCHAR",5.0,null,null,"√","'CNY'","",""]
[12.0,"INIT_BALANCE_UPDATE_USER","\"初始值是否被用户修改过 0 无 >0 是\"","BIGINT",null,null,null,"√","0","",""]
[13.0,"DATA_FROM_DATE_ID","数据开始时间ID","INT",{"$nulls":4},"0","",""]
[14.0,"DATA_TO_DATE_ID","数据结束时间ID","INT",{"$nulls":4},"0","",""]
[15.0,"TOTAL_RECORD_DR","payment数据条数","INT",{"$nulls":4},"0","",""]
[16.0,"TOTAL_RECORD_CR","receive数据条数","INT",{"$nulls":4},"0","",""]
[17.0,"TOTAL_AMOUNT_DR","总付款数","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[18.0,"TOTAL_AMOUNT_CR","总收款数","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[19.0,"STDEV_AMOUNT_DR","总付款标准差","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[20.0,"STDEV_AMOUNT_CR","总收款标准差","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[21.0,"MEDIAN_AMOUNT_DR","总付款中位数","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[22.0,"MEDIAN_AMOUNT_CR","总收款中位数","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[23.0,"UPDATE_DATE","更新时间","DATETIME",null,null,null,"√","","",""]
[24.0,"BANK_INFO_ID","银行信息","INT",{"$nulls":4},"0","",""]
[25.0,"CLOSED_FLAG","关闭标志","INT",{"$nulls":4},"0","",""]
[26.0,"CREATED_BY","创建者","INT",{"$nulls":4},"0","",""]
[27.0,"CREATED_DATE","创建日期","DATETIME",{"$nulls":4},"","",""]
[28.0,"SYSTEM_BALANCE","\"余额识别状态 0-已识别 1-未识别\"","INT",{"$nulls":4},"0","",""]
[29.0,"NEED_CONFIRM","\"是否需要确认账号（企业信息） 0-不需要 1-需要\"","SMALLINT",{"$nulls":4},"0","",""]
[30.0,"AGREEMENT_RATE","协定存款利率","DECIMAL",8.0,4.0,null,null,"0.0000","",""]
[31.0,"WHETHER_AGREEMENT","是否为协定存款：1.是；0，否；","VARCHAR",1.0,null,null,null,"'0'","",""]
[32.0,"CHANGE_TYPE","\"是否是客户维护的协定利率与协定额度 1.是；0.否；\"","VARCHAR",1.0,null,null,null,"'0'","",""]
[33.0,"DATA_AUTHENTICITY","账号数据真实性","VARCHAR",20.0,null,null,null,"","",""]
[34.0,"DIRECT_CONNECT_FLAG","是否银企直连","INT",{"$nulls":4},"0","",""]
[35.0,"CASHIER","出纳员","VARCHAR",255.0,null,null,null,"","",""]
[36.0,"DIRECT_CONNECT_TYPE","直连类型","VARCHAR",255.0,null,null,null,"","",""]
[37.0,"ACCT_OPEN_DATE_ID","开户日期ID","INT",{"$nulls":4},"","",""]
[38.0,"ACCT_CLOSE_DATE_ID","销户日期ID","INT",{"$nulls":4},"","",""]
[39.0,"STATUS","账户状态：0未删除，1已删除","INT",{"$nulls":4},"0","",""]

{"sheet":"SI_BANK_ACCOUNT_BAL","index":25,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_ACCOUNT_BAL"]
[null,"显示名称","银行账号余额信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"BALANCE_ID","","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"LE_ID","流水主体ID","BIGINT",null,null,null,"√","","",""]
[3.0,"ACCOUNT_ID","账号ID","BIGINT UNSIGNED",null,null,null,"√","","",""]
[4.0,"DATE_ID","日期","INT",null,null,null,"√","","",""]
[5.0,"OPENING_BALANCE","期初余额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[6.0,"RECORD_DR","payment数据条数","INT",{"$nulls":4},"0","",""]
[7.0,"RECORD_CR","receive数据条数","INT",{"$nulls":4},"0","",""]
[8.0,"AMOUNT_DR","总付款额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[9.0,"AMOUNT_CR","总收款额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[10.0,"CLOSING_BALANCE","期末余额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[11.0,"DEPOSIT_BALANCE","活期余额","DECIMAL",19.0,2.0,null,"√","0.00","",""]
[12.0,"AGREEMENT_AMOUNT","协定存款额度","DECIMAL",19.0,2.0,null,"√","0.00","",""]
[13.0,"AGREEMENT_BALANCE","协定存款余额","DECIMAL",19.0,2.0,null,"√","0.00","",""]
[14.0,"NEED_UPDATE","是否需要从该条开始更新","TINYINT",null,null,null,"√","0","",""]
[15.0,"UPDATE_DATE","更新时间","DATETIME",null,null,null,"√","","",""]
[16.0,"SYSTEM_BALANCE","\"0未识别 1已识别\"","INT",{"$nulls":4},"0","",""]
[17.0,"SYSTEM_OPENING_BALANCE","系统期初余额","DECIMAL",19.0,2.0,null,null,"0.00","",""]
[18.0,"SYSTEM_CLOSING_BALANCE","系统期末余额","DECIMAL",19.0,2.0,null,null,"0.00","",""]

{"sheet":"SI_BANK_ACCOUNT_BAL_LOG","index":26,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_ACCOUNT_BAL_LOG"]
[null,"显示名称","余额变更日志"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"BAL_LOG_ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"FLOW_SUBJECT_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"ACCOUNT_ID","银行账号ID","BIGINT",{"$nulls":4},"","",""]
[4.0,"BAL_AMOUNT","账号余额","DECIMAL",19.0,2.0,null,null,"","",""]
[5.0,"BAL_DATE_ID","余额计算日期ID","BIGINT",{"$nulls":4},"","",""]
[6.0,"CREATED_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[7.0,"CREATED_BY","创建者","BIGINT",{"$nulls":4},"","",""]

{"sheet":"SI_BANK_ACCOUNT_EXTRA","index":27,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_ACCOUNT_EXTRA"]
[null,"显示名称","账户信息扩展表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"EXTRA_ID","","BIGINT",null,null,"√","√","","",""]
[2.0,"GROUP_ID","项目id","BIGINT",null,null,null,"√","","",""]
[3.0,"ACCOUNT_ID","账户id","BIGINT",null,null,null,"√","","",""]
[4.0,"INTEREST_CHECK","活期结息校验","VARCHAR",500.0,null,null,null,"","",""]
[5.0,"LOG_UPDATE_CHECK","文件修改记录校验","VARCHAR",500.0,null,null,null,"","",""]
[6.0,"DATA_QUALITY","数据质量","VARCHAR",500.0,null,null,null,"","",""]
[7.0,"DATA_QUALITY_DETAIL","数据质量详情(json)","TEXT",{"$nulls":4},"","",""]
[8.0,"DATA_EXTENT","数据时长(月)","INT",{"$nulls":4},"0","",""]
[9.0,"FACTICITY_STATE","数据真实性校验状态：0正常,1需关注","INT",{"$nulls":4},"0","",""]
[10.0,"INTEGRITY_STATE","数据完整性校验状态：0正常,1余额不连续,2原文件无余额","INT",{"$nulls":4},"0","",""]
[11.0,"BALANCE_CHECK","余额不连续次数","INT",{"$nulls":4},"0","",""]
[12.0,"CREATED_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[13.0,"UPDATED_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_ADMINISTRATIV_1","index":28,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_ADMINISTRATIVE_LICENSE"]
[null,"显示名称","企业行政许可表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"LICENSE_NUMBER","行政许可证号","VARCHAR",100.0,null,null,null,"","",""]
[4.0,"LICENSE_NAME","许可名称","VARCHAR",255.0,null,null,null,"","",""]
[5.0,"LICENSE_CONTENT","许可内容","TEXT",{"$nulls":4},"","",""]
[6.0,"VALID_FROM","有效期自","DATETIME",{"$nulls":4},"","",""]
[7.0,"VALID_TO","有效期至","DATETIME",{"$nulls":4},"","",""]
[8.0,"LICENSING_AUTHORITY","许可机关","VARCHAR",100.0,null,null,null,"","",""]
[9.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[10.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_ANNUAL_REPORT","index":29,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_ANNUAL_REPORT"]
[null,"显示名称","企业年报信息表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"REPORT_YEAR","年报年度","INT",{"$nulls":4},"","",""]
[4.0,"ENTERPRISE_NAME","企业名称","VARCHAR",255.0,null,null,null,"","",""]
[5.0,"CREDIT_CODE","统一社会信用代码","VARCHAR",50.0,null,null,null,"","",""]
[6.0,"CONTACT_PHONE","联系电话","VARCHAR",50.0,null,null,null,"","",""]
[7.0,"POSTAL_CODE","邮政编码","VARCHAR",20.0,null,null,null,"","",""]
[8.0,"EMAIL","电子邮箱","VARCHAR",100.0,null,null,null,"","",""]
[9.0,"ENTERPRISE_STATUS","企业经营状态","VARCHAR",50.0,null,null,null,"","",""]
[10.0,"EMPLOYEE_COUNT","从业人数","VARCHAR",50.0,null,null,null,"","",""]
[11.0,"HAS_WEBSITE","是否有网站或网店","TINYINT",{"$nulls":4},"","",""]
[12.0,"HAS_INVESTMENT","企业是否有投资信息","TINYINT",{"$nulls":4},"","",""]
[13.0,"REGISTERED_ADDRESS","注册地址","VARCHAR",255.0,null,null,null,"","",""]
[14.0,"NET_PROFIT","净利润","VARCHAR",50.0,null,null,null,"","",""]
[15.0,"TOTAL_LIABILITY","负债总额","VARCHAR",50.0,null,null,null,"","",""]
[16.0,"TOTAL_SALES","销售总额","VARCHAR",50.0,null,null,null,"","",""]
[17.0,"TOTAL_PROFIT","利润总额","VARCHAR",50.0,null,null,null,"","",""]
[18.0,"TOTAL_EQUITY","所有者权益合计","VARCHAR",50.0,null,null,null,"","",""]
[19.0,"TOTAL_TAX","纳税总额","VARCHAR",50.0,null,null,null,"","",""]
[20.0,"TOTAL_ASSETS","资产总额","VARCHAR",50.0,null,null,null,"","",""]
[21.0,"MAIN_BUSINESS_INCOME","主营业务收入","VARCHAR",50.0,null,null,null,"","",""]
[22.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[23.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_BASIC","index":30,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_BASIC"]
[null,"显示名称","企业基本信息表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_NAME","企业名称","VARCHAR",255.0,null,null,null,"","",""]
[3.0,"REGISTRATION_NUMBER","工商注册号","VARCHAR",50.0,null,null,null,"","",""]
[4.0,"CREDIT_CODE","统一信用代码","VARCHAR",50.0,null,null,null,"","",""]
[5.0,"LEGAL_PERSON","法定代表人","VARCHAR",100.0,null,null,null,"","",""]
[6.0,"ORGANIZATION_CODE","组织机构代码","VARCHAR",50.0,null,null,null,"","",""]
[7.0,"ENTERPRISE_TYPE","企业类型","VARCHAR",100.0,null,null,null,"","",""]
[8.0,"INDUSTRY","所属行业","VARCHAR",100.0,null,null,null,"","",""]
[9.0,"BUSINESS_STATUS","经营状态","VARCHAR",50.0,null,null,null,"","",""]
[10.0,"REGISTERED_CAPITAL","注册资本","DECIMAL",20.0,2.0,null,null,"","",""]
[11.0,"REGISTERED_CAPITAL_UNIT","注册资本单位","VARCHAR",10.0,null,null,null,"","",""]
[12.0,"REGISTRATION_DATE","注册时间","DATETIME",{"$nulls":4},"","",""]
[13.0,"REGISTRATION_ADDRESS","注册地址","VARCHAR",255.0,null,null,null,"","",""]
[14.0,"BUSINESS_PERIOD","营业期限","VARCHAR",100.0,null,null,null,"","",""]
[15.0,"BUSINESS_SCOPE","经营范围","TEXT",{"$nulls":4},"","",""]
[16.0,"REGISTRATION_AUTHORITY","登记机关","VARCHAR",100.0,null,null,null,"","",""]
[17.0,"APPROVAL_DATE","核准日期","DATETIME",{"$nulls":4},"","",""]
[18.0,"PHONE","联系电话","VARCHAR",50.0,null,null,null,"","",""]
[19.0,"EMAIL","邮箱","VARCHAR",100.0,null,null,null,"","",""]
[20.0,"WEBSITE","网址","VARCHAR",255.0,null,null,null,"","",""]
[21.0,"ADDRESS","地址","VARCHAR",255.0,null,null,null,"","",""]
[22.0,"FROM_REPORT","数据来源报告","VARCHAR",100.0,null,null,null,"","",""]
[23.0,"REPORT_DATE","报告日期","DATETIME",{"$nulls":4},"","",""]
[24.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[25.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_BIDDING","index":31,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_BIDDING"]
[null,"显示名称","企业招投标信息表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"RELEASE_DATE","发布日期","DATETIME",{"$nulls":4},"","",""]
[4.0,"TITLE","标题","VARCHAR",255.0,null,null,null,"","",""]
[5.0,"REGION","地域","VARCHAR",100.0,null,null,null,"","",""]
[6.0,"BIDDING_COMPANY","招标公司","VARCHAR",255.0,null,null,null,"","",""]
[7.0,"WINNING_COMPANY","中标公司","VARCHAR",255.0,null,null,null,"","",""]
[8.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[9.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_CHANGE_RECORD","index":32,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_CHANGE_RECORD"]
[null,"显示名称","企业变更记录表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"CHANGE_DATE","变更日期","DATETIME",{"$nulls":4},"","",""]
[4.0,"CHANGE_ITEM","变更项目","VARCHAR",255.0,null,null,null,"","",""]
[5.0,"CHANGE_BEFORE","变更前","TEXT",{"$nulls":4},"","",""]
[6.0,"CHANGE_AFTER","变更后","TEXT",{"$nulls":4},"","",""]
[7.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[8.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_CORE_TEAM","index":33,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_CORE_TEAM"]
[null,"显示名称","企业核心团队表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"MEMBER_NAME","成员姓名","VARCHAR",100.0,null,null,null,"","",""]
[4.0,"POSITION","职位","VARCHAR",100.0,null,null,null,"","",""]
[5.0,"INTRODUCTION","简介","TEXT",{"$nulls":4},"","",""]
[6.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[7.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_HOLDING","index":34,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_HOLDING"]
[null,"显示名称","企业控股表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"HOLDING_ENTERPRISE_NAME","控股企业名称","VARCHAR",255.0,null,null,null,"","",""]
[4.0,"INVESTMENT_RATIO","投资占比","VARCHAR",50.0,null,null,null,"","",""]
[5.0,"INVESTMENT_PATH","投资路径","VARCHAR",255.0,null,null,null,"","",""]
[6.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[7.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_INTELLECTUAL__1","index":35,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_INTELLECTUAL_PROPERTY"]
[null,"显示名称","企业知识产权表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"PROPERTY_TYPE","知识产权类型","VARCHAR",50.0,null,null,null,"","",""]
[4.0,"PROPERTY_NAME","知识产权名称","VARCHAR",255.0,null,null,null,"","",""]
[5.0,"REGISTRATION_NUMBER","注册号/公告号","VARCHAR",100.0,null,null,null,"","",""]
[6.0,"CLASSIFICATION","国际分类/专利类型/软件分类","VARCHAR",100.0,null,null,null,"","",""]
[7.0,"APPLICATION_DATE","申请日期/公告日期/登记日期","DATETIME",{"$nulls":4},"","",""]
[8.0,"VERSION","版本号","VARCHAR",50.0,null,null,null,"","",""]
[9.0,"INDUSTRY_CLASSIFICATION","行业分类","VARCHAR",100.0,null,null,null,"","",""]
[10.0,"WEBSITE_URL","网站URL","VARCHAR",255.0,null,null,null,"","",""]
[11.0,"DOMAIN_NAME","域名","VARCHAR",255.0,null,null,null,"","",""]
[12.0,"RECORD_NUMBER","备案号","VARCHAR",100.0,null,null,null,"","",""]
[13.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[14.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_INVESTMENT","index":36,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_INVESTMENT"]
[null,"显示名称","企业对外投资表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"INVESTED_ENTERPRISE_NAME","被投资企业名称","VARCHAR",255.0,null,null,null,"","",""]
[4.0,"INVESTED_ENTERPRISE_LEGAL_PERSON","被投资企业法定代表人","VARCHAR",100.0,null,null,null,"","",""]
[5.0,"ESTABLISHMENT_DATE","成立日期","DATETIME",{"$nulls":4},"","",""]
[6.0,"INVESTMENT_RATIO","投资占比","DECIMAL",10.0,4.0,null,null,"","",""]
[7.0,"SUBSCRIBED_AMOUNT","认缴金额","DECIMAL",20.0,2.0,null,null,"","",""]
[8.0,"SUBSCRIBED_AMOUNT_UNIT","认缴金额单位","VARCHAR",10.0,null,null,null,"","",""]
[9.0,"STATUS","状态","VARCHAR",50.0,null,null,null,"","",""]
[10.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[11.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_LEGAL_PERSON__1","index":37,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_LEGAL_PERSON_INFO"]
[null,"显示名称","法定代表人相关信息表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"LEGAL_PERSON_NAME","法人姓名","VARCHAR",100.0,null,null,null,"","",""]
[4.0,"INFO_TYPE","信息类型（法定代表人、股东、高管）","VARCHAR",50.0,null,null,null,"","",""]
[5.0,"RELATED_ENTERPRISE_NAME","相关企业名称","VARCHAR",255.0,null,null,null,"","",""]
[6.0,"POSITION","职务","VARCHAR",100.0,null,null,null,"","",""]
[7.0,"SHAREHOLDING_RATIO","持股比例","DECIMAL",10.0,4.0,null,null,"","",""]
[8.0,"REGISTERED_CAPITAL","注册资本","DECIMAL",20.0,2.0,null,null,"","",""]
[9.0,"REGISTERED_CAPITAL_UNIT","注册资本单位","VARCHAR",10.0,null,null,null,"","",""]
[10.0,"ESTABLISHMENT_DATE","成立日期","DATETIME",{"$nulls":4},"","",""]
[11.0,"REGION","地区","VARCHAR",100.0,null,null,null,"","",""]
[12.0,"STATUS","状态","VARCHAR",50.0,null,null,null,"","",""]
[13.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[14.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_LEGAL_RISK","index":38,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_LEGAL_RISK"]
[null,"显示名称","企业法律风险表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"RISK_TYPE","风险类型","VARCHAR",100.0,null,null,null,"","",""]
[4.0,"CASE_NUMBER","案号","VARCHAR",100.0,null,null,null,"","",""]
[5.0,"CASE_REASON","案由","VARCHAR",255.0,null,null,null,"","",""]
[6.0,"INVOLVED_PARTIES","当事人","VARCHAR",255.0,null,null,null,"","",""]
[7.0,"COURT_DATE","开庭/立案日期","DATETIME",{"$nulls":4},"","",""]
[8.0,"COURT_NAME","受理法院","VARCHAR",100.0,null,null,null,"","",""]
[9.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[10.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_PERSONNEL","index":39,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_PERSONNEL"]
[null,"显示名称","企业主要人员表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"NAME","姓名","VARCHAR",100.0,null,null,null,"","",""]
[4.0,"POSITION","职务","VARCHAR",100.0,null,null,null,"","",""]
[5.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[6.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_ENTERPRISE_QUALIFICATION","index":40,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_ENTERPRISE_QUALIFICATION"]
[null,"显示名称","企业资质证书表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","主键ID","BIGINT",null,null,"√","√","","",""]
[2.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"CERTIFICATE_NUMBER","证书编号","VARCHAR",100.0,null,null,null,"","",""]
[4.0,"CERTIFICATE_TYPE","证书类型","VARCHAR",100.0,null,null,null,"","",""]
[5.0,"ISSUE_DATE","发证日期","DATETIME",{"$nulls":4},"","",""]
[6.0,"EXPIRY_DATE","截止日期","DATETIME",{"$nulls":4},"","",""]
[7.0,"CREATE_TIME","创建时间","DATETIME",{"$nulls":4},"","",""]
[8.0,"UPDATE_TIME","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"sys_user","index":41,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","sys_user"]
[null,"显示名称","用户表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"id","","BIGINT",null,null,null,"√","","",""]
[2.0,"username","","VARCHAR",32.0,null,null,null,"","",""]
[3.0,"password","","VARCHAR",200.0,null,null,null,"","",""]
[4.0,"password_level","","CHAR",50.0,null,null,null,"","",""]
[5.0,"enable","","CHAR",1.0,null,null,null,"","",""]
[6.0,"real_name","","VARCHAR",50.0,null,null,null,"","",""]
[7.0,"mobile","","VARCHAR",15.0,null,null,null,"","",""]
[8.0,"no","","VARCHAR",32.0,null,null,null,"","",""]
[9.0,"avatar","","VARCHAR",255.0,null,null,null,"","",""]
[10.0,"login_ip","","VARCHAR",50.0,null,null,null,"","",""]
[11.0,"email","","VARCHAR",100.0,null,null,null,"","",""]
[12.0,"sign","","VARCHAR",255.0,null,null,null,"","",""]
[13.0,"remark","","VARCHAR",255.0,null,null,null,"","",""]
[14.0,"iz_exist_org","","CHAR",1.0,null,null,null,"","",""]
[15.0,"iz_tenant_admin","","CHAR",1.0,null,null,null,"","",""]
[16.0,"tenant_id","","BIGINT",{"$nulls":4},"","",""]
[17.0,"enable_switch_tenant","","CHAR",1.0,null,null,null,"","",""]
[18.0,"deleted","","CHAR",1.0,null,null,null,"","",""]
[19.0,"version","","INT",null,null,null,"√","","",""]
[20.0,"create_by","","BIGINT",null,null,null,"√","","",""]
[21.0,"create_time","","DATETIME",null,null,null,"√","","",""]
[22.0,"update_by","","BIGINT",null,null,null,"√","","",""]
[23.0,"update_time","","DATETIME",null,null,null,"√","","",""]
[24.0,"ts","","TIMESTAMP",null,null,null,"√","CURRENT_TIMESTAMP","",""]
[25.0,"sex","性别","VARCHAR",255.0,null,null,null,"","",""]
[26.0,"birthday","出生日期","DATETIME",{"$nulls":4},"","",""]
[27.0,"contact_address","联系地址","VARCHAR",255.0,null,null,null,"","",""]
[28.0,"open_id","微信小程序唯一标识","VARCHAR",255.0,null,null,null,"","",""]

{"sheet":"SI_BANK_FLOW_ANALYSIS_RULES","index":42,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_FLOW_ANALYSIS_RULES"]
[null,"显示名称","银行流水分析规则表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","规则ID（主键，自增）","BIGINT",null,null,"√","√","","",""]
[2.0,"NAME","规则名称","VARCHAR",255.0,null,null,"√","","",""]
[3.0,"DESCRIPTION","规则描述","TEXT",{"$nulls":4},"","",""]
[4.0,"PRIORITY","规则优先级（数值越小，优先级越高）","INT",null,null,null,"√","","",""]
[5.0,"CATEGORY","规则分类（如风险检测、异常分析等）","VARCHAR",50.0,null,null,"√","","",""]
[6.0,"FLOW_SUBJECT_ID","流水主体 ID","VARCHAR",50.0,null,null,"√","","",""]
[7.0,"FILTER_PARAMS","范围过滤参数（JSON格式，如天数、笔数等）","JSON",{"$nulls":4},"","",""]
[8.0,"RUN_PARAMS","规则运行参数（JSON格式，如阈值、指标等）","JSON",{"$nulls":4},"","",""]
[9.0,"PLUGIN_NAME","规则逻辑插件名称（对应执行逻辑的Service名称）","VARCHAR",255.0,null,null,"√","","",""]
[10.0,"CREATED_AT","创建时间","TIMESTAMP",{"$nulls":4},"CURRENT_TIMESTAMP","",""]
[11.0,"UPDATED_AT","更新时间","TIMESTAMP",{"$nulls":4},"CURRENT_TIMESTAMP","",""]
[12.0,"DELETED","删除标志（0：未删除，1：已删除）","BIT",1.0,null,null,null,"0","",""]

{"sheet":"SI_BANK_NOTE","index":43,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_NOTE"]
[null,"显示名称","承兑汇票数据表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"BAD_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"FLOW_SUBJECT_ID","流水主体","INT UNSIGNED",{"$nulls":4},"0","",""]
[3.0,"CURRENCY","币种","VARCHAR",10.0,null,null,null,"","",""]
[4.0,"BAD_NO","承兑汇票号","VARCHAR",200.0,null,null,null,"","",""]
[5.0,"BAD_ACCEPTANCE_TYPE","\"票据类型 commercial_acceptance-商承,bank_acceptance-银承\"","VARCHAR",200.0,null,null,null,"","",""]
[6.0,"BAD_TYPE","汇票类型","VARCHAR",200.0,null,null,null,"","",""]
[7.0,"AMOUNT","金额","DECIMAL",19.0,2.0,null,null,"","",""]
[8.0,"ISSUE_DATE","出票日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[9.0,"END_DATE","结束日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[10.0,"END_DATE_ID","结束日期ID","INT UNSIGNED",{"$nulls":4},"0","",""]
[11.0,"RECEIVED_DATE","接收日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[12.0,"CUSTOMER_CODE","客户代码","VARCHAR",200.0,null,null,null,"","",""]
[13.0,"CUSTOMER_NAME","客户名称","VARCHAR",300.0,null,null,null,"","",""]
[14.0,"AR_DUE_DATE","应收日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[15.0,"DRAWEE_NAME","提现人名称","VARCHAR",200.0,null,null,null,"","",""]
[16.0,"DRAWEE_BANK","提现银行","VARCHAR",200.0,null,null,null,"","",""]
[17.0,"PAYEE","承兑人","VARCHAR",200.0,null,null,null,"","",""]
[18.0,"PENDING_DAYS","Pending天数","INT",{"$nulls":4},"","",""]
[19.0,"ENDORSE_TIMES","背书次数","INT",{"$nulls":4},"","",""]
[20.0,"IS_HANDOVER","\"是否移交银行 0-未移交，1-移交\"","INT",{"$nulls":4},"0","",""]
[21.0,"RECEIVING_BANK","接收银行","VARCHAR",200.0,null,null,null,"","",""]
[22.0,"HANDOVER_DATE","提交日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[23.0,"COLLECTION_DATE","收票日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[24.0,"STATUS","状态","VARCHAR",200.0,null,null,null,"","",""]
[25.0,"LOCATION","地点","VARCHAR",200.0,null,null,null,"","",""]
[26.0,"COLLECTION_SUBMIT_DATE","收票记录日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[27.0,"DISCOUNT_SUBMIT_DATE","折现记录日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[28.0,"DISCOUNT_DATE","打折日期","VARCHAR",10.0,null,null,null,"'0000-00-00'","",""]
[29.0,"DISCOUNT_RATE","折扣率","DECIMAL",19.0,2.0,null,null,"","",""]
[30.0,"DISCOUNT_DAYS","折扣天数","INT",{"$nulls":4},"","",""]
[31.0,"DISCOUNT_COST","折扣手续费","DECIMAL",19.0,2.0,null,null,"","",""]
[32.0,"COST_CENTER","成本中心","VARCHAR",200.0,null,null,null,"","",""]
[33.0,"COMMENTS","备注","VARCHAR",2000.0,null,null,null,"","",""]
[34.0,"CREATED_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[35.0,"CREATED_BY","创建者","BIGINT UNSIGNED",null,null,null,"√","0","",""]
[36.0,"UPDATED_DATE","更新时间","DATETIME",{"$nulls":4},"","",""]
[37.0,"UPDATED_BY","更新者","BIGINT UNSIGNED",null,null,null,"√","0","",""]
[38.0,"PAYMENT_FLAG","应收/应付","CHAR",1.0,null,null,"√","'R'","",""]
[39.0,"ENDORSEE_ID","受让人ID-映射c4c_customer_info中的customer_id字段","BIGINT",{"$nulls":4},"","",""]
[40.0,"ENDORSEE_TYPE","受让人类型ID-映射c4c_customer_category中的category_id字段","BIGINT",{"$nulls":4},"","",""]
[41.0,"INVOICE_BANK","收票银行","VARCHAR",200.0,null,null,null,"","",""]
[42.0,"INVOICE_BANK_ACCOUNT","收票银行账户","VARCHAR",200.0,null,null,null,"","",""]
[43.0,"INVOICE_BANK_LEVEL","出票银行评级","VARCHAR",200.0,null,null,null,"","",""]
[44.0,"DEAL_METHOD","处理方式","VARCHAR",200.0,null,null,null,"","",""]
[45.0,"DEAL_DESC","处理说明","VARCHAR",200.0,null,null,null,"","",""]
[46.0,"USER_DEFINE","用户自定义字段","TEXT",{"$nulls":4},"","",""]
[47.0,"INVOICE_DATE","发票日期","DATE",{"$nulls":4},"","",""]

{"sheet":"SI_BANK_STATEMENT_EXTRA","index":44,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_STATEMENT_EXTRA"]
[null,"显示名称","银行流水自定义信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"BANK_STATEMENT_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"IS_MARKED","是否标记，0否1是，默认否","INT",{"$nulls":4},"0","",""]
[3.0,"HAS_CUSTOM_NOTE","是否含有自定义备注，0否1是，默认否","INT",{"$nulls":4},"0","",""]
[4.0,"CUSTOM_NOTE_COUNT","自定义备注条数，默认0","INT",{"$nulls":4},"0","",""]
[5.0,"GROUP_ID","项目ID","BIGINT",null,null,null,"√","0","",""]
[6.0,"CREATE_DATE","创建时间","DATETIME",null,null,null,"√","","",""]
[7.0,"UPDATE_DATE","更新时间","DATETIME",null,null,null,"√","","",""]

{"sheet":"SI_BANK_STATEMENT_MARKED","index":45,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_BANK_STATEMENT_MARKED"]
[null,"显示名称","银行剔除流水"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"MARKED_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"BANK_STATEMENT_ID","流水表ID","BIGINT UNSIGNED",null,null,null,"√","","",""]
[3.0,"A_PAIR_ID","UUID作为剔除小组ID","VARCHAR",32.0,null,null,null,"","",""]
[4.0,"IS_MARKED","是否剔除，0不剔除，1剔除。默认=1剔除","INT",{"$nulls":4},"1","",""]
[5.0,"MARKED_TYPE","标记类型1已退回的支出，2快进快出的经营流入","CHAR",1.0,null,null,null,"","",""]
[6.0,"LE_ID","企业ID","INT",{"$nulls":4},"0","",""]
[7.0,"GROUP_ID","项目ID","INT",{"$nulls":4},"0","",""]
[8.0,"TRX_FLAG","交易标志位","VARCHAR",2.0,null,null,null,"'0'","",""]
[9.0,"TRX_TYPE","分类ID","INT",{"$nulls":4},"0","",""]
[10.0,"TRX_DATE","交易日期","DATETIME",{"$nulls":4},"","",""]
[11.0,"DATE_ID","账号日期ID","INT",{"$nulls":4},"0","",""]
[12.0,"LE_ACCOUNT_NAME","企业账号名称","VARCHAR",240.0,null,null,null,"'NONE'","",""]
[13.0,"LE_ACCOUNT_NO","企业银行账号","VARCHAR",240.0,null,null,null,"","",""]
[14.0,"CUSTOMER_ACCOUNT_NAME","对手方企业名称","VARCHAR",240.0,null,null,null,"","",""]
[15.0,"CUSTOMER_ACCOUNT_NO","对手方账号","VARCHAR",240.0,null,null,null,"","",""]
[16.0,"CURRENCY","币种","VARCHAR",10.0,null,null,null,"","",""]
[17.0,"AMOUNT","收/付款金额","DECIMAL",19.0,2.0,null,"√","0.00","",""]
[18.0,"CREATE_DATE","创建时间","DATETIME",null,null,null,"√","CURRENT_TIMESTAMP","",""]
[19.0,"UPDATE_DATE","更新时间","DATETIME",null,null,null,"√","CURRENT_TIMESTAMP","",""]
[20.0,"CREATED_BY","创建者","BIGINT UNSIGNED",{"$nulls":4},"","",""]
[21.0,"UPDATED_BY","更新者","BIGINT UNSIGNED",{"$nulls":4},"","",""]

{"sheet":"SI_CATA_GROUP","index":46,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CATA_GROUP"]
[null,"显示名称","分类组信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"CATA_GROUP_ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"CATA_GROUP_NAME","分类组名","VARCHAR",500.0,null,null,null,"","",""]
[3.0,"CATA_GROUP_DESC","分类组描述","VARCHAR",500.0,null,null,null,"","",""]
[4.0,"ORDER_ID","OrderID","INT",{"$nulls":4},"","",""]
[5.0,"CATA_GROUP_TYPE","分类组类型","VARCHAR",45.0,null,null,null,"","",""]
[6.0,"USER_MEMO","用户备注","VARCHAR",500.0,null,null,null,"","",""]
[7.0,"CREATED_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[8.0,"CREATED_BY","创建者","BIGINT",{"$nulls":4},"","",""]
[9.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"0","",""]
[10.0,"PARENT_ID","父分类组ID","BIGINT",{"$nulls":4},"0","",""]
[11.0,"IS_DELETE","是否删除","TINYINT",{"$nulls":4},"0","",""]
[12.0,"SYSTEM_DEFAULT","是否系统默认","TINYINT",{"$nulls":4},"0","",""]
[13.0,"PAYMENT_FLAG","P/R","VARCHAR",5.0,null,null,null,"","",""]

{"sheet":"SI_CATA_GROUP_RELATION","index":47,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CATA_GROUP_RELATION"]
[null,"显示名称","分类与分类组关系"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"RELATION_ID","ID","BIGINT",null,null,"√","√","","",""]
[2.0,"CATALOG_ID","分类ID","BIGINT",{"$nulls":4},"","",""]
[3.0,"CATA_GROUP_ID","分类组ID","BIGINT",{"$nulls":4},"","",""]
[4.0,"ENTERPRISE_ID","企业ID","BIGINT",{"$nulls":4},"","",""]
[5.0,"CREATED_DATE","创建时间","DATETIME",{"$nulls":4},"","",""]
[6.0,"CREATE_BY","创建者","BIGINT",{"$nulls":4},"","",""]

{"sheet":"SI_CATALOG_INFO","index":48,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CATALOG_INFO"]
[null,"显示名称",""]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"CATALOG_ID","","VARCHAR",50.0,null,null,null,"","",""]
[2.0,"ENTERPRISE_ID","","VARCHAR",50.0,null,null,null,"","",""]
[3.0,"CATALOG_NAME","","VARCHAR",100.0,null,null,null,"","",""]
[4.0,"CATALOG_DESC","","VARCHAR",255.0,null,null,null,"","",""]
[5.0,"CATALOG_TYPE","","VARCHAR",50.0,null,null,null,"","",""]
[6.0,"SPECIAL_FLAG","","VARCHAR",50.0,null,null,null,"","",""]
[7.0,"PAYMENT_FLAG","","VARCHAR",10.0,null,null,null,"","",""]
[8.0,"FORECAST_METHOD","","VARCHAR",50.0,null,null,null,"","",""]
[9.0,"LIST_ORDER","","INT",{"$nulls":4},"","",""]
[10.0,"VALID","","BIT",1.0,null,null,null,"","",""]
[11.0,"DELETE_FLAG","","BIT",1.0,null,null,null,"","",""]
[12.0,"PARENT_ID","","VARCHAR",50.0,null,null,null,"","",""]
[13.0,"CREATION_DATE","","DATETIME",{"$nulls":4},"","",""]

{"sheet":"SI_CATALOG_RULE","index":49,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CATALOG_RULE"]
[null,"显示名称","分类规则"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"RULE_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"LE_ID","企业ID","BIGINT",null,null,null,"√","0","",""]
[3.0,"RULE_TYPE","\"规则类型 SYSTEM 系统 ENTERPRISE 企业 USER 用户自定义\"","VARCHAR",100.0,null,null,"√","","",""]
[4.0,"PAYMENT_FLAG","\"P-付款 R-收款\"","VARCHAR",10.0,null,null,"√","","",""]
[5.0,"APPLY_OBJECT","分类对象","VARCHAR",100.0,null,null,"√","","",""]
[6.0,"FIND_COLUMN","查找的字段","VARCHAR",150.0,null,null,"√","","",""]
[7.0,"FIND_CONTENT","查找的匹配的内容","VARCHAR",4000.0,null,null,"√","","",""]
[8.0,"TARGET_CONTENT","匹配后的分类","VARCHAR",250.0,null,null,"√","","",""]
[9.0,"TARGET_CATALOG_ID","匹配后的分类ID","INT",null,null,null,"√","0","",""]
[10.0,"TARGET_SUB_CATEGORY","子类","INT",null,null,null,"√","0","",""]
[11.0,"PRIORITY","分类优先级越大优先级越高","INT",null,null,null,"√","1","",""]
[12.0,"CREATED_BY","创建者","BIGINT",null,null,null,"√","0","",""]
[13.0,"CREATION_DATE","创建时间","DATETIME",null,null,null,"√","","",""]
[14.0,"RULE_LEVEL","\"梯队 1-4\"","INT",{"$nulls":4},"4","",""]

{"sheet":"SI_CATALOG_RULE_LOG","index":50,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","SI_CATALOG_RULE_LOG"]
[null,"显示名称","分类规则执行日志"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","自增ID","BIGINT",null,null,"√","√","","",""]
[2.0,"LE_ID","企业ID","BIGINT",null,null,null,"√","0","",""]
[3.0,"SQL_STR","规则具体sql","TEXT",null,null,null,"√","","",""]
[4.0,"SQL_RUN_START_TIME","规则运行开始时间","DATETIME",null,null,null,"√","","",""]
[5.0,"SQL_RUN_END_TIME","规则运行结束时间","VARCHAR",250.0,null,null,null,"","",""]
[6.0,"SQL_AFFECT_ROWS","规则影响条数","INT",{"$nulls":4},"0","",""]
[7.0,"CREATED_BY","\"谁触发的-1系统 0-用户\"","BIGINT",{"$nulls":4},"0","",""]

{"sheet":"TB_BANK","index":51,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","TB_BANK"]
[null,"显示名称","基础_银行信息"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"BANK_ID","ID","BIGINT UNSIGNED",null,null,"√","√","","",""]
[2.0,"BANK_NAME","银行名称","VARCHAR",500.0,null,null,"√","","",""]
[3.0,"BANK_TYPE","银行类型","VARCHAR",100.0,null,null,"√","","",""]
[4.0,"LIST_ORDER","顺序","INT",null,null,null,"√","0","",""]
[5.0,"CREATION_DATE","创建时间","DATETIME",null,null,null,"√","","",""]
[6.0,"VALID","是否可用","INT",null,null,null,"√","1","",""]

{"sheet":"TB_BANK_INTEREST","index":52,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","TB_BANK_INTEREST"]
[null,"显示名称","不同年份的默认结息利率表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1.0,"ID","","BIGINT",null,null,"√","√","","",""]
[2.0,"ABBR","银行简称","VARCHAR",20.0,null,null,"√","","",""]
[3.0,"NAME","银行名称","VARCHAR",100.0,null,null,"√","","",""]
[4.0,"START_YEAR","起始年份","INT",null,null,null,"√","","",""]
[5.0,"END_YEAR","结束年份","INT",null,null,null,"√","","",""]
[6.0,"Q1ST_INTEREST","第一季度结息利率","DECIMAL",10.0,6.0,null,null,"","",""]
[7.0,"Q2ND_INTEREST","第二季度结息利率","DECIMAL",10.0,6.0,null,null,"","",""]
[8.0,"Q3RD_INTEREST","第三季度结息利率","DECIMAL",10.0,6.0,null,null,"","",""]
[9.0,"Q4TH_INTEREST","第四季度结息利率","DECIMAL",10.0,6.0,null,null,"","",""]
[10.0,"CURRENCY","币种","VARCHAR",50.0,null,null,"√","","",""]
[11.0,"CREATE_DATE","创建时间","DATETIME",null,null,null,"√","","",""]
[12.0,"UPDATE_DATE","更新时间","DATETIME",null,null,null,"√","","",""]
[13.0,"LE_TYPE","主体类型：自然人主体（naturalPerson），法人主体（legalPerson)","VARCHAR",100.0,null,null,null,"","",""]