a.ID a.lv a.pid aa.productId account.accountCd // 存管账户账号 account.accountId account.accountNm account.accountPayAgreementNo account.accountPhone account.amountFronze account.amountTotal account.amountVerify account.authorize account.autoBidAgreementNo account.createBy account.createTime account.defaultAccount account.memberId account.payPwd account.statusCode account.statusDesc account.trxId account.version account_client.accountClientId account_client.createBy account_client.createTime account_client.deleted account_client.fastCode account_client.fullName account_client.shorterName account_client.updateBy account_client.updateTime account_client.version account_detail.accountDetailId account_detail.accountId account_detail.balance account_detail.clientNm account_detail.clientSNm account_detail.createBy account_detail.createTime account_detail.credit account_detail.debit account_detail.deleted account_detail.no account_detail.productCd account_detail.productId account_detail.productNm account_detail.pzh account_detail.summary account_detail.updateBy account_detail.updateTime account_detail.version account_recharge.accountId account_recharge.accountStatementNo account_recharge.addip account_recharge.amount account_recharge.bankCardId account_recharge.collected account_recharge.createBy account_recharge.createTime account_recharge.fee account_recharge.memberId account_recharge.orderCd account_recharge.platCardno account_recharge.rechargeId account_recharge.remark account_recharge.resultCode account_recharge.status account_recharge.transferKind account_recharge.type account_recharge.userCardno account_recharge.verifyManager account_recharge.verifyReason account_recharge.verifyRemark account_recharge.verifyResult account_recharge.verifyTime account_recharge.version account_subject.accountCd account_subject.accountId account_subject.accountNm account_subject.accountPid account_subject.balance account_subject.beginBalance account_subject.createBy account_subject.createTime account_subject.creditAmount account_subject.debitAmount account_subject.deleted account_subject.fastCode account_subject.flag account_subject.hasChild account_subject.level account_subject.updateBy account_subject.updateTime account_subject.version account_subject_over_dtl.accountCd account_subject_over_dtl.accountId account_subject_over_dtl.accountNm account_subject_over_dtl.accountSubjectOverDtlId account_subject_over_dtl.accountSubjectOverMstId account_subject_over_dtl.balance account_subject_over_dtl.beginBalance account_subject_over_dtl.createBy account_subject_over_dtl.createTime account_subject_over_dtl.creditAmount account_subject_over_dtl.debitAmount account_subject_over_dtl.deleted account_subject_over_dtl.flag account_subject_over_dtl.updateBy account_subject_over_dtl.updateTime account_subject_over_dtl.version account_subject_over_mst.accountSubjectOverMstId account_subject_over_mst.createBy account_subject_over_mst.createTime account_subject_over_mst.curMonth account_subject_over_mst.curYear account_subject_over_mst.deleted account_subject_over_mst.updateBy account_subject_over_mst.updateTime account_subject_over_mst.version account_summary.accountSummaryId account_summary.createBy account_summary.createTime account_summary.deleted account_summary.fastCode account_summary.summary account_summary.updateBy account_summary.updateTime account_summary.version account_sys_voucher_dtl.accountId account_sys_voucher_dtl.accountSysVoucherDtlId account_sys_voucher_dtl.accountSysVoucherMstId account_sys_voucher_dtl.createBy account_sys_voucher_dtl.createTime account_sys_voucher_dtl.deleted account_sys_voucher_dtl.flag account_sys_voucher_dtl.no account_sys_voucher_dtl.summary account_sys_voucher_dtl.updateBy account_sys_voucher_dtl.updateTime account_sys_voucher_dtl.version account_sys_voucher_mst.accountSysVoucherMstId account_sys_voucher_mst.createBy account_sys_voucher_mst.createTime account_sys_voucher_mst.deleted account_sys_voucher_mst.description account_sys_voucher_mst.node account_sys_voucher_mst.title account_sys_voucher_mst.updateBy account_sys_voucher_mst.updateTime account_sys_voucher_mst.version addr_idcard.addridcardCd addr_idcard.addridcardId addr_idcard.addridcardNm addr_idcard.createBy addr_idcard.createTime addr_idcard.deleted addr_idcard.provinceCd addr_idcard.provinceNm addr_idcard.updateBy addr_idcard.updateTime addr_idcard.version agreement.__title__ 合同表 agreement.agreementCd agreement.agreementId agreement.agreementKind agreement.agreementUrl agreement.createBy agreement.createTime agreement.orderId agreement.productCreditId agreement.productId agreement.seqNumber agreement.signed agreement.status agreement.version asset.__title__ 资产表; 是否使用:product != null,表中无体现 asset.acceptedCompany 承兑机构 asset.acceptedNo asset.assetCd 资产编号 asset.assetType asset.attachmentDirId asset.bankBranchNo 开户行银联号 开户行号 asset.borrowAmt 约定借款金额(元) asset.borrowCompany asset.borrowerCardName 收款人 持卡人姓名 asset.borrowerCardNumber 收款人 持卡人卡号 asset.borrowerCd 借款人代码,锚定值,ref member.memberCd asset.borrowerName 借款人姓名 asset.borrowerPhone 借款人证照号 asset.businessType // 1=票据类,2=p2p asset.createBy asset.createTime asset.groundTime 申请上线时间 asset.id asset.idCard 营业执照号 asset.invalidBid 是否废标(废标 not null) asset.isCurrentBankFlag 是否本行: 0本行 1他行,注意,与member.bankcardType 相反 asset.isPersonFlag (收款人)是否个人: 0个人,1企业 asset.memberKind (借款人)客户类型 0 个人 1企业 asset.outTicketPerson asset.phoneOrCompanyCd asset.productBusinessTypeId asset.productBusinessTypeNm asset.productContent asset.productNm asset.productTypeName 资产类别 asset.productTypeRuleId asset.properties asset.receivablesPerson asset.receiverCd 收款人代码,锚定值,ref member.memberCd asset.registerNameOrCompanyNm 借款发起用户 注册人名称/企业名称 asset.registerPhoneOrCompanyCd 借款发起用户手机 注册人手机号/组织机构代码 asset.safeguardWay 保障方式 asset.spv asset.spvCd 锚定值,ref member.memberCd asset.tenderEnd 投标结束时间 asset.tenderStart 投标开始时间 asset.ticketAmt 票面金额/约定还款金额 还款总额 asset.ticketCode 票号 asset.ticketDueDate 票据到期日/项目结息日 asset.ticketIssueDate 票据签发日/项目发起日 asset.version asset_attachment.assetId asset_attachment.attachmentId attachment.attachmentExt attachment.attachmentGroup attachment.attachmentHash attachment.attachmentId attachment.attachmentNm attachment.attachmentPath attachment.attachmentSize attachment.attachmentTitle attachment.createBy attachment.createTime attachment.isTemp attachment.uploadip attachment.version autobidset.amount autobidset.autoBidSetId autobidset.createBy autobidset.createTime autobidset.flag autobidset.freqFlag autobidset.memberId autobidset.orderNo autobidset.periodRangFrom autobidset.periodRangTo autobidset.productTypeRang autobidset.rateRangFrom autobidset.rateRangTo autobidset.singleBidRangFrom autobidset.singleBidRangTo autobidset.version autobidsetlog.autoBidSetId autobidsetlog.autoBidSetLogId autobidsetlog.createBy autobidsetlog.createTime autobidsetlog.flag autobidsetlog.freqFlag autobidsetlog.memberId autobidsetlog.operationSrc autobidsetlog.orderNo autobidsetlog.periodRangFrom autobidsetlog.periodRangTo autobidsetlog.productTypeRang autobidsetlog.rateRangFrom autobidsetlog.rateRangTo autobidsetlog.resultStr autobidsetlog.singleBidRangFrom autobidsetlog.singleBidRangTo autobidsetlog.vCode autobidsetlog.version bank.bankCd bank.bankId bank.bankNm bank.createBy bank.createTime bank.isValid bank.logoUrl bank.version bank.withdraw bankbase.bankNm bankbase.bankNo bankbase.createBy bankbase.createTime bankbase.deleted bankbase.status bankbase.updateBy bankbase.updateTime bankbase.version bankbranchcity.branchCityNm bankbranchcity.branchCityNo bankbranchcity.branchLevel bankbranchcity.cityNo bankbranchcity.createBy bankbranchcity.createTime bankbranchcity.deleted bankbranchcity.updateBy bankbranchcity.updateTime bankbranchcity.version bankbranchinfo.bankNo bankbranchinfo.bankType bankbranchinfo.branchCityNo bankbranchinfo.branchNm bankbranchinfo.branchNo bankbranchinfo.createBy bankbranchinfo.createTime bankbranchinfo.deleted bankbranchinfo.status bankbranchinfo.updateBy bankbranchinfo.updateTime bankbranchinfo.version bankcard.area bankcard.areaCd bankcard.areaNm bankcard.bankAddress bankcard.bankBranch bankcard.bankCardId bankcard.bankCardType bankcard.bankCd bankcard.bankNo bankcard.bankTelephone bankcard.bankType bankcard.city bankcard.cityCd bankcard.cityNm bankcard.createBy bankcard.createTime bankcard.defaultCard bankcard.deleted bankcard.eAccountNo bankcard.idCard bankcard.memberId bankcard.operationSrc bankcard.protocolNo bankcard.province bankcard.provinceCd bankcard.provinceNm bankcard.status bankcard.statusCode bankcard.statusDesc bankcard.trxId bankcard.updateBy bankcard.updateTime bankcard.version bankcity.cityNm bankcity.cityNo bankcity.createBy bankcity.createTime bankcity.deleted bankcity.provinceNo bankcity.updateBy bankcity.updateTime bankcity.version bankinvesttransfer.accountCd bankinvesttransfer.accountId bankinvesttransfer.amount bankinvesttransfer.bankCardId bankinvesttransfer.bankCardNo bankinvesttransfer.bankInvestTransferId bankinvesttransfer.createBy bankinvesttransfer.createTime bankinvesttransfer.orderId bankinvesttransfer.status bankinvesttransfer.transferKind bankinvesttransfer.verifyDate bankinvesttransfer.verifyMemberId bankinvesttransfer.verifyMemberNm bankinvesttransfer.verifyReason bankinvesttransfer.version bankprovince.createBy bankprovince.createTime bankprovince.deleted bankprovince.provinceNm bankprovince.provinceNo bankprovince.status bankprovince.updateBy bankprovince.updateTime bankprovince.version bankquota.bankNm bankquota.bankQuotaId bankquota.createBy bankquota.createTime bankquota.deleted bankquota.onedayCumulativeLimit bankquota.singleTransferLimit bankquota.status bankquota.updateBy bankquota.updateTime bankquota.version borrower_card.__title__ 借款人银行卡,每创建一个项目,生成一条记录 bindcardmodifylog.bankNoNew bindcardmodifylog.bankNoOld bindcardmodifylog.bindCardModifyLogId bindcardmodifylog.createBy bindcardmodifylog.createTime bindcardmodifylog.memberId bindcardmodifylog.memberKind bindcardmodifylog.phone bindcardmodifylog.realCd bindcardmodifylog.realNm bindcardmodifylog.resultStr bindcardmodifylog.status bindcardmodifylog.version borrower_card.bankBranchNo borrower_card.borrowerCardId borrower_card.borrowerCardName borrower_card.borrowerCardNumber borrower_card.borrowerType borrower_card.createBy borrower_card.createTime borrower_card.idCard borrower_card.idType borrower_card.idTypeNm borrower_card.isCurrentBankFlag borrower_card.isPersonFlag borrower_card.productId borrower_card.version borroweradditionalinfo.borrowerAdditionalInfoId borroweradditionalinfo.borrowerNm borroweradditionalinfo.borrowingTimes borroweradditionalinfo.cityNm borroweradditionalinfo.createBy borroweradditionalinfo.createTime borroweradditionalinfo.creditInfo borroweradditionalinfo.gender borroweradditionalinfo.income borroweradditionalinfo.industry borroweradditionalinfo.industryNm borroweradditionalinfo.liabilities borroweradditionalinfo.maritalStatus borroweradditionalinfo.productId borroweradditionalinfo.realEstateInfo borroweradditionalinfo.version borroweradditionalinfo.yearIncome broker.brokerKind broker.brokerLevel broker.commStatus broker.commlevel broker.createBy broker.createTime broker.deleted broker.effTime broker.expTime broker.memberId broker.memberId1 broker.memberId2 broker.realCd1 broker.realCd2 broker.realNm1 broker.realNm2 broker.state broker.stateReason broker.stateTime broker.status broker.updateBy broker.updateTime broker.upgradeState broker.version broker_status_log.brokerId broker_status_log.createBy broker_status_log.createTime broker_status_log.endTime broker_status_log.id broker_status_log.operationType broker_status_log.remark broker_status_log.startTime broker_status_log.status broker_status_log.statusType broker_status_log.userCd broker_status_log.version brokerageapplyrecord.actualAmount brokerageapplyrecord.amount brokerageapplyrecord.applyDate brokerageapplyrecord.auditRemark brokerageapplyrecord.bankCard brokerageapplyrecord.bankNm brokerageapplyrecord.cashCode brokerageapplyrecord.cashId brokerageapplyrecord.confirmDate brokerageapplyrecord.confirmUser brokerageapplyrecord.createBy brokerageapplyrecord.createTime brokerageapplyrecord.financialConfirmDate brokerageapplyrecord.financialConfirmor brokerageapplyrecord.memberId brokerageapplyrecord.orderId brokerageapplyrecord.phone brokerageapplyrecord.promotionId brokerageapplyrecord.quantity brokerageapplyrecord.realCd brokerageapplyrecord.realNm brokerageapplyrecord.remark brokerageapplyrecord.status brokerageapplyrecord.taxAmount brokerageapplyrecord.version brokeragerecord.amount brokeragerecord.cashCode brokeragerecord.cashId brokeragerecord.createBy brokeragerecord.createTime brokeragerecord.investAmount brokeragerecord.investDate brokeragerecord.investorMemberId brokeragerecord.investorPhone brokeragerecord.investorRealCd brokeragerecord.itemCode brokeragerecord.itemName brokeragerecord.memberId brokeragerecord.orderId brokeragerecord.phone brokeragerecord.productId brokeragerecord.rate brokeragerecord.realCd brokeragerecord.realNm brokeragerecord.recordId brokeragerecord.status brokeragerecord.version calendardata.calendarId calendardata.calendarType calendardata.createBy calendardata.createTime calendardata.endTime calendardata.holidayName calendardata.isAllDay calendardata.isHoliday calendardata.startTime calendardata.version category.categoryCd 用于查询某个属性的key,可能对应多个值 category.categoryDesc category.categoryId category.categoryNm category.configed category.createBy category.createTime category.edited category.effTime category.expTime category.listSort category.remark category.state category.stateTime category.version categoryattr.actualval categoryattr.attrCd categoryattr.attrId categoryattr.attrNm categoryattr.attrRequired categoryattr.categoryId categoryattr.createBy categoryattr.createTime categoryattr.defaultVal categoryattr.effTime categoryattr.expTime categoryattr.listSort categoryattr.remark categoryattr.state categoryattr.stateTime categoryattr.version claimdetail.amount claimdetail.claimDate claimdetail.claimDetailId claimdetail.claimMan claimdetail.createBy claimdetail.createTime claimdetail.productId claimdetail.reClaimMan claimdetail.reClaimtime claimdetail.recoveryStatus claimdetail.status claimdetail.version claimitem.claimDetailId claimitem.claimItemId claimitem.createBy claimitem.createTime claimitem.factItemAmount claimitem.itemAmount claimitem.itemTypeCd claimitem.itemTypeNm claimitem.recoveryStatus claimitem.version cms_article.activityType cms_article.article_content cms_article.article_id cms_article.article_keyword cms_article.article_outline cms_article.article_subtitle cms_article.article_title cms_article.channel_code cms_article.channel_id cms_article.createBy cms_article.createTime cms_article.deleted cms_article.link_url cms_article.listSort cms_article.recomment cms_article.status cms_article.updateBy cms_article.updateTime cms_article.version cms_article_attachment.articleId cms_article_attachment.attachmentId cms_channel._title_ 资讯频道 每个频道可以有篇文章 cms_channel.channel_code cms_channel.channel_id cms_channel.channel_name cms_channel.channel_param1 cms_channel.channel_param2 cms_channel.channel_param3 cms_channel.channel_remark cms_channel.createBy cms_channel.createTime cms_channel.deleted cms_channel.editable cms_channel.parent_id 通过channel_id - parent_id建立tree:@ManyToOne @JoinColumn(name = "parent_id") cms_channel.updateBy cms_channel.updateTime cms_channel.version cms_fragment.channel_code cms_fragment.channel_id cms_fragment.createBy cms_fragment.createTime cms_fragment.deleted cms_fragment.fragment_content cms_fragment.fragment_id cms_fragment.fragment_title cms_fragment.path cms_fragment.status cms_fragment.updateBy cms_fragment.updateTime cms_fragment.version cms_link.channel_code cms_link.channel_id cms_link.createBy cms_link.createTime cms_link.link_id cms_link.link_title cms_link.link_url cms_link.listSort cms_link.status cms_link.updateBy cms_link.updateTime cms_link.version cms_link_attachment.attachmentId cms_link_attachment.linkId cms_operational_detail.cmsChannelId cms_operational_detail.cmsOperationalDetailId cms_operational_detail.cmsReportId cms_operational_detail.contentFileId cms_operational_detail.coverImageId cms_operational_detail.createBy cms_operational_detail.createTime cms_operational_detail.deleted cms_operational_detail.listSort cms_operational_detail.status cms_operational_detail.title cms_operational_detail.updateBy cms_operational_detail.updateTime cms_operational_detail.version cms_slide.channel_code cms_slide.channel_id cms_slide.createBy cms_slide.createTime cms_slide.effTime cms_slide.expTime cms_slide.listSort cms_slide.position cms_slide.slide_id cms_slide.slide_title cms_slide.slide_url cms_slide.slide_written cms_slide.status cms_slide.updateBy cms_slide.updateTime cms_slide.version cms_slide_attachment.attachmentId cms_slide_attachment.slideId comm_config.amountVerify comm_config.brokerKind comm_config.commConfigId comm_config.commMonth comm_config.commNm comm_config.commRate comm_config.commlevel comm_config.createBy comm_config.createTime comm_config.gradeLimit comm_config.investingAmt comm_config.rate21 comm_config.rate22 comm_config.rate31 comm_config.rate32 comm_config.rate33 comm_config.remark comm_config.version company.account 企业账号(银行卡号) company.bankBranchNo 开户行联行号 company.companyAddress company.companyCd 组织机构代码 company.companyComplaint company.companyCredit company.companyDesc company.companyFinance company.companyLicence 营业执照号 company.companyNm company.companyOperate company.companyRange company.createBy company.createTime company.foundTime company.isCurrentBankFlag 0 浙商 1他行 company.legalPerson company.legalPersonIDCard company.memberId ref member,1 v 1 company.phone 没有使用?? company.registedFund company.status 审核状态:0,申请.1、确认.2.失败 company.taxNo 税务登记号 company.upateTime company.updateBy company.version company_attachment.attachmentId company_attachment.memberId companycontact.contactDesc companycontact.contactDuty companycontact.contactFax companycontact.contactId companycontact.contactKind companycontact.contactNm companycontact.contactPhone companycontact.createBy companycontact.createTime companycontact.email companycontact.memberId companycontact.officePhone companycontact.version compensation.amount compensation.claimAmount compensation.createBy compensation.createTime compensation.memberId compensation.productId compensation.repayId compensation.status compensation.version contract_template.createBy contract_template.createTime contract_template.fileName contract_template.id contract_template.isDefault contract_template.remark contract_template.status contract_template.templateCode contract_template.templateNm contract_template.templateTypeCode contract_template.version contract_template_producttyperule.contractTemplateId contract_template_producttyperule.productTypeRuleId contractsignrecord.agreementId contractsignrecord.borrowerSignServiceId contractsignrecord.borrowerStatus contractsignrecord.createBy contractsignrecord.createTime contractsignrecord.investorSignServiceId contractsignrecord.investorStatus contractsignrecord.memberId contractsignrecord.platformSignServiceId contractsignrecord.platformStatus contractsignrecord.recId contractsignrecord.retry contractsignrecord.sceneEvid contractsignrecord.sceneUrl contractsignrecord.scened contractsignrecord.sourceFile contractsignrecord.status contractsignrecord.version coupon.applyDate coupon.couponAmount coupon.couponCd coupon.couponId coupon.couponNm coupon.couponRuleId coupon.couponSrc coupon.couponSrcDetailDesc coupon.couponSrcObjId coupon.couponType coupon.createBy coupon.createTime coupon.deleted coupon.expirationDate coupon.limitAmount coupon.limitDays coupon.memberId coupon.orderId coupon.remark coupon.ruleId coupon.sendDate coupon.status coupon.updateBy coupon.updateTime coupon.useDate coupon.version coupon_rule.couponAmount coupon_rule.couponAmtOrRate coupon_rule.couponNm coupon_rule.couponNum coupon_rule.couponType coupon_rule.createBy coupon_rule.createTime coupon_rule.deleted coupon_rule.isNeedAudit coupon_rule.isPemanent coupon_rule.limitAmount coupon_rule.limitDate coupon_rule.limitDays coupon_rule.maxDiscountAmt coupon_rule.maxLimitInvestAmt coupon_rule.minLimitInvestAmt coupon_rule.ruleCd coupon_rule.ruleId coupon_rule.sendQuantity coupon_rule.status coupon_rule.totalQuantity coupon_rule.updateBy coupon_rule.updateTime coupon_rule.useLimitAmt coupon_rule.usedQuantity coupon_rule.version coupon_send_setting.couponRuleId coupon_send_setting.couponSendSettingId coupon_send_setting.createBy coupon_send_setting.createTime coupon_send_setting.limitAmt coupon_send_setting.limitDays coupon_send_setting.maxNumber coupon_send_setting.minNumber coupon_send_setting.settingType coupon_send_setting.status coupon_send_setting.version coupon_used.couponId coupon_used.createBy coupon_used.createTime coupon_used.deleted coupon_used.orderId coupon_used.remark coupon_used.status coupon_used.updateBy coupon_used.updateTime coupon_used.usedCd coupon_used.usedId coupon_used.version credit_assignment_application.accruedInterest credit_assignment_application.actualUnitPrice credit_assignment_application.applicationDate credit_assignment_application.castQuantity credit_assignment_application.createBy credit_assignment_application.createTime credit_assignment_application.creditRightId credit_assignment_application.expectArrivalAmount credit_assignment_application.fullScaleTime credit_assignment_application.groundTime credit_assignment_application.lastUpdateDate credit_assignment_application.minFullQuantity credit_assignment_application.nextRepayDate credit_assignment_application.nowStock credit_assignment_application.previousRepayDate credit_assignment_application.productId credit_assignment_application.quantity credit_assignment_application.remark credit_assignment_application.sellingMemberId credit_assignment_application.status credit_assignment_application.tenderEnd credit_assignment_application.tenderStart credit_assignment_application.todayStock credit_assignment_application.transferAppliCd credit_assignment_application.transferAppliId credit_assignment_application.transferDiscount credit_assignment_application.transferPrice credit_assignment_application.transferServerFee credit_assignment_application.transferTimes credit_assignment_application.transferredRate credit_assignment_application.unitPrice credit_assignment_application.version credit_assignment_setup.allowSplitFlag credit_assignment_setup.allowTransferAgainFlag credit_assignment_setup.createBy credit_assignment_setup.createTime credit_assignment_setup.creditAssignmentSetupId credit_assignment_setup.holdTimeoutLimit credit_assignment_setup.maxTransferTime credit_assignment_setup.minHoldAmount credit_assignment_setup.minHoldTime credit_assignment_setup.transferDiscount credit_assignment_setup.updateBy credit_assignment_setup.updateDate credit_assignment_setup.version credit_transaction_record.actualUnitPrice credit_transaction_record.buyCreditId credit_transaction_record.buyingMemberId credit_transaction_record.buyingQuantity credit_transaction_record.createBy credit_transaction_record.createTime credit_transaction_record.creditRightId credit_transaction_record.creditTransactionCd credit_transaction_record.creditTransactionId credit_transaction_record.endDate credit_transaction_record.orderID credit_transaction_record.productId credit_transaction_record.sellingMemberId credit_transaction_record.status credit_transaction_record.transactionDate credit_transaction_record.transferAppliId credit_transaction_record.transferFee credit_transaction_record.transferPrice credit_transaction_record.transferRate credit_transaction_record.transferredRate credit_transaction_record.unitPrice credit_transaction_record.version creditright.actualUnitPrice creditright.createBy creditright.createTime creditright.creditRightId creditright.effTime creditright.expTime creditright.memberId creditright.orderId creditright.productId creditright.quantity creditright.status creditright.unitPrice creditright.version customercomment.auditDesc customercomment.auditTime customercomment.auditor customercomment.centent customercomment.cententType customercomment.commentId customercomment.createBy customercomment.createTime customercomment.deleted customercomment.email customercomment.memberId customercomment.phone customercomment.realCd customercomment.realNm customercomment.updateBy customercomment.updateTime customercomment.version incomeplan.createBy incomeplan.createTime incomeplan.incomePlanId incomeplan.period incomeplan.planCapital incomeplan.planInterest incomeplan.planTime incomeplan.planTotal incomeplan.productId incomeplan.status incomeplan.version integralrecord.amount integralrecord.createBy integralrecord.createTime integralrecord.deleted integralrecord.failureTime integralrecord.integralVal integralrecord.isAddFlag integralrecord.isPermanent integralrecord.memberId integralrecord.objId integralrecord.objType integralrecord.recordId integralrecord.remark integralrecord.status integralrecord.updateBy integralrecord.updateTime integralrecord.version integralrule.amount integralrule.businessType integralrule.createBy integralrule.createTime integralrule.deleted integralrule.editor integralrule.integralVal integralrule.oneceLimit integralrule.ruleId integralrule.status integralrule.updateBy integralrule.updateTime integralrule.version invest_order.order_id invest_order.product_id itemtemplate.createBy itemtemplate.createTime itemtemplate.defaultFlag itemtemplate.templateId itemtemplate.templateNm itemtemplate.version itemtemplate_itemtype.itemtemplate_id itemtemplate_itemtype.itemtype_id itemtype.biller itemtype.calOnlineFlag itemtype.charger itemtype.createBy itemtype.createTime itemtype.edited itemtype.feeType itemtype.itemTypeCd itemtype.itemTypeId itemtype.itemTypeNm itemtype.itemTypePCd itemtype.maxAmount itemtype.minAmount itemtype.node itemtype.periodOrDay itemtype.rate itemtype.rateReferened itemtype.version loandetail.amount loandetail.charger loandetail.createBy loandetail.createTime loandetail.loanDetailId loandetail.loanId loandetail.memberId loandetail.outTransferNo loandetail.outsideOrderNo loandetail.outsideSerialNo loandetail.paymentTime loandetail.productId loandetail.resultStr loandetail.status loandetail.version loaninfo.__title__ 放款明细 loaninfo.createBy loaninfo.createTime loaninfo.loanAmount loaninfo.loanId loaninfo.loanTime loaninfo.loanType loaninfo.outsideOrderNo loaninfo.outsideSerialNo loaninfo.paymentTimes loaninfo.productId loaninfo.status loaninfo.version loanrecord.createBy loanrecord.createTime loanrecord.loanAmount loanrecord.loanDate loanrecord.loanEndDate loanrecord.loanId loanrecord.loanOperator loanrecord.loanOrderId loanrecord.objId loanrecord.objType loanrecord.status loanrecord.version member.__title__ // 用户/企业表 member.auditType //认证方式1 :身份证认证(实名认证) 2 :银行卡认证 4 : 邮箱验证 8 : 手机验证 16:授权 ; 浙商开户后,16授权为on member.bankNo // 银行卡号,浙商返回,可能带**** member.bankcardType 0本行 1 他行 注意,与borrower_card.isCurrentBankFlag相反 member.createBy member.createTime member.deleted member.deviceTokenIOS member.eSealStatus member.eSignAccountId member.email member.errorloginCount member.idCard member.isNewSysMember member.isOpenZJB member.lastLogin member.lastLoginIp member.level member.loginCount member.memberCd // 用于锚定的唯一值。因为企业的锚定值不一定是手机号 member.memberId member.memberIdZ member.memberKind // 客户类型0:个人,1:企业 member.noviceStandardQuota member.operationSrc member.passSalt member.password member.phone // 手机号 member.promotionId member.realCd 登录帐号 member.realCdZ member.realNm // 用户名/企业名称 member.realNmZ member.registTime member.riskResult member.riskResultDate member.status member.statusZ member.updateBy member.updateTime member.version member_audit.auditAuthor member_audit.auditDesc member_audit.auditId member_audit.auditTime member_audit.auditType member_audit.createBy member_audit.createTime member_audit.memberId member_audit.status member_audit.submitTime member_audit.version member_old_capital_flow.amount member_old_capital_flow.createBy member_old_capital_flow.createTime member_old_capital_flow.deleted member_old_capital_flow.flag member_old_capital_flow.flowId member_old_capital_flow.memberId member_old_capital_flow.remark member_old_capital_flow.status member_old_capital_flow.updateBy member_old_capital_flow.updateTime member_old_capital_flow.version member_old_info.balance member_old_info.createBy member_old_info.createTime member_old_info.deleted member_old_info.infoId member_old_info.memberId member_old_info.oldId member_old_info.oldIdCard member_old_info.oldName member_old_info.outsideOrderNo member_old_info.outsideSerialNo member_old_info.remark member_old_info.updateBy member_old_info.updateTime member_old_info.version member_operation_log.createBy member_operation_log.createTime member_operation_log.logId member_operation_log.memberId member_operation_log.operateContent member_operation_log.operateType member_operation_log.version member_receivables.__title__ // 还款计划表? member_receivables.InterestDateBegin member_receivables.InterestDateEnd member_receivables.actualAmount 实际总金额(本金+利息) member_receivables.actualCapital 实际本金 member_receivables.actualDate member_receivables.actualInterest 实际利息 member_receivables.actualOtherFee member_receivables.advanceRepayPenaltyAmt member_receivables.createBy member_receivables.createTime member_receivables.currentOutsideOrderNo member_receivables.currentOutsideSerialNo member_receivables.expectAmount // 预期总金额 member_receivables.expectCapital // 预期本金? member_receivables.expectDate member_receivables.expectInterest // 预期利息 member_receivables.memberId member_receivables.orderId member_receivables.orderNo member_receivables.outsideOrderDate member_receivables.outsideOrderNo member_receivables.outsideSerialNo member_receivables.period member_receivables.preReapyInterest member_receivables.productId member_receivables.recId member_receivables.repayApplyStatus member_receivables.repayAuditStatus member_receivables.repayOutsideOrderDate member_receivables.repayOutsideOrderNo member_receivables.repayOutsideSerialNo member_receivables.status // 0:未收款 1:已收款 2:废除 member_receivables.version memberintegral.createBy memberintegral.createTime memberintegral.deleted memberintegral.integralVal memberintegral.maxInvestAmount memberintegral.memberId memberintegral.total memberintegral.updateBy memberintegral.updateTime memberintegral.usedAmount memberintegral.usedValue memberintegral.version memberrisktestanswer.createBy memberrisktestanswer.createTime memberrisktestanswer.deleted memberrisktestanswer.memberId memberrisktestanswer.memberRiskTestAnswerId memberrisktestanswer.riskTestAnswer memberrisktestanswer.updateBy memberrisktestanswer.updateTime memberrisktestanswer.version memberseal.createBy memberseal.createTime memberseal.deleted memberseal.evid memberseal.memberId memberseal.relateStatus memberseal.sealData memberseal.sealId memberseal.updateBy memberseal.updateTime memberseal.version notice.acceptBy notice.acceptNm notice.batchNo notice.content notice.createBy notice.createTime notice.deleted notice.effTime notice.expTime notice.listSort notice.noticeId notice.noticeTitle notice.readed notice.state notice.stateTime notice.title notice.version old_sys_repay.buyTime old_sys_repay.capital old_sys_repay.createBy old_sys_repay.createTime old_sys_repay.interest old_sys_repay.oldOrderCd old_sys_repay.oldOrderId old_sys_repay.oldProductId old_sys_repay.oldSysRepayId old_sys_repay.oldUserId old_sys_repay.outsideOrderNo old_sys_repay.outsideSerialNo old_sys_repay.repayTime old_sys_repay.status old_sys_repay.totalAmt old_sys_repay.version oldtable_1.itemid oldtable_1.单价 oldtable_1.投资总金额 oldtable_1.数量 oldtable_1.融资金额 oldtable_1.融资金额-投资总金额 oldtable_1.项目投资笔数 oldtable_1.项目状态 oldtable_2.Id oldtable_2.IdCard oldtable_2.Name oldtable_2.余额 oldtable_2.充值成功笔数 oldtable_2.充值成功金额 oldtable_2.已收款笔数 oldtable_2.已收款金额 oldtable_2.待收款笔数 oldtable_2.待收款金额 oldtable_2.投资成功笔数 oldtable_2.投资成功金额 oldtable_2.提现成功笔数 oldtable_2.提现成功金额 oldtable_4.TYPE oldtable_4.数量 order_detail.createBy order_detail.createTime order_detail.itemAmount order_detail.itemTypeCd order_detail.itemTypeNm order_detail.memberIdA order_detail.memberIdZ order_detail.orderId order_detail.orderdetailId order_detail.version order_extra_info.createBy order_extra_info.createTime order_extra_info.infoId order_extra_info.orderId order_extra_info.orderInfoNm order_extra_info.orderInfoVal order_extra_info.payPlatform order_extra_info.payPlatformCd order_extra_info.remark order_extra_info.version outsideorderrecord.createBy outsideorderrecord.createTime outsideorderrecord.orderId outsideorderrecord.outsideId outsideorderrecord.outsideOrderId outsideorderrecord.outsideSerialNo outsideorderrecord.version payrespdata.createBy payrespdata.createTime payrespdata.deleted payrespdata.remark payrespdata.respCd payrespdata.respId payrespdata.respMsg payrespdata.returnType payrespdata.returnTypeCd payrespdata.showCd payrespdata.showMsg payrespdata.status payrespdata.subType payrespdata.subTypeCd payrespdata.updateBy payrespdata.updateTime payrespdata.version personal.address personal.area personal.areaNm personal.birthday personal.borrowingTimes personal.city personal.cityNm personal.contactFax personal.createBy personal.createTime personal.creditInfo personal.deleted personal.ecpName personal.ecpRelation personal.ecpTelephone personal.education personal.email personal.gender personal.income personal.industry personal.industryNm personal.legalPersonIDCard personal.liabilities personal.memberId personal.monthIncome personal.msn personal.officePhone personal.province personal.provinceNm personal.qq personal.status personal.telephone personal.updateBy personal.updateTime personal.version praise.createBy praise.createTime praise.deleted praise.isPraise praise.memberId praise.praiseId praise.themeId praise.updateBy praise.updateTime praise.version processaudithistory.auditContent processaudithistory.auditContentWeb processaudithistory.auditDate processaudithistory.auditOpinion processaudithistory.auditResult processaudithistory.auditor processaudithistory.createBy processaudithistory.createTime processaudithistory.historyId processaudithistory.objId processaudithistory.objType processaudithistory.remark processaudithistory.title processaudithistory.version product.agreementCd product._title_ // 产品,核心 product.amount // 募集金额(借款金额)(元) = 放款金额 + 前置服务费 = 本金 = 数量 * 单价 product.assetId ref // 资产id product.auditPassedQuantity product.autoQuantity product.awardAmount product.awardFail product.awardRate product.awardTotal product.borrowAmt // 放款金额 在创建项目时=资产的 约定借款金额 但可以修改。 product.borrowerIdCard product.borrowerName // 借款人 product.brokerageStatus product.brrowUse product.brrowUseName product.businessType // 1=票据类,2=p2p product.businessTypeNm product.canAutobid product.canTransfer product.canUseCoupon product.castQuantity // 实际满标数量 product.checkTime product.commissionBalanceStatus product.compenInterest product.contractEffTime product.createBy product.createTime product.credit product.deleted product.directPassword product.ecardName product.ecardNo product.financingDays product.fullScaleSureTime 满标确认时间 product.fullScaleTime // 满标时间? product.fundUse product.groundTime 申请上线时间 product.guaranteeInfo product.holidayDelay product.industry product.interestAlgorithm product.interestBeginTime product.interestEndTime product.interestStartTime product.interestType product.interestTypeName product.isNewSysProduct product.lastRepayDate product.loanDays product.loanStatus product.loaneeBankAccountName product.loaneeBankAccountNumber product.loaneeBankBranchNm product.loaneeBankBranchNo product.loaneeBankCityNm product.loaneeBankCityNo product.loaneeBankCode product.loaneeBankName product.loaneeBankProvinceNm product.loaneeBankProvinceNo product.maxTenderQuantity product.memberId 非借款人id product.minFullQuantity product.minHoldDay product.minTenderQuantity product.mobileAwardRate product.nature product.oldItemId product.online product.period 借款期限 product.periodType product.personInfo product.personalLoan product.preServiceFeeAmt // 前置服务费 product.preSubsidyAmt // 前置补贴 product.productCd // 项目编号 product.productContent 承兑机构 product.productGrade product.productId product.productNm // 标题 项目名称 银票宝8268期 product.productTypeRuleId product.promotionType product.promotionTypeName product.quantity // 总数量 product.rate 利率 product.repayDelay product.repayMethod product.repayMethodName 还款方式 product.repayPeriod product.repayPlayTime // 预计还款日 product.repaySource product.singleInvestPen product.spv product.status // 10 "草稿"; 11 "待审核"; 12 "已废弃"; 13 "已撤回"; 14 "审核驳回"; 15 "审核失败"; 31 "待招标(待上线)"; 40 "已撤标"; 32 "已上线"; 30 "招标中"; 60 "满标待审"; 61 "流标待处理"; 80 "待放款"; 85 "放款中"; 90 "还款中"; 100 "已还完"; 70 "废标待退款"; 101 "废标已退款"; 71 "流标待退款"; 73 "撤标待退款"; 102 "流标已退款"; 50 "已流标"; 103 "撤标已退款"; ProductOrderDto.java 30 "招标中"; 60 "满标待审"; 80 "待放款"; 85 "放款中"; 90 "还款中"; 100 "已还完"; product.statusName 状态name product.sufServiceFeeAmt // 后置服务费 满标审核通过时计算,与sufSubsidyAmt只有一个值非零 product.sufSubsidyAmt // 后置补贴 product.tenderEnd 投标截止时间 product.tenderKind product.tenderKindName product.tenderStart 投标开始时间 product.ticketAmt 票面金额/约定还款金额 还款总额 product.totalPeriod product.unitPrice 单价 product.updateBy product.updateTime product.version product.virtualAcc product.virtualAccname product_apply.acceptedBank product_apply.acceptedBankType product_apply.address product_apply.applyTime product_apply.applyType product_apply.assetType product_apply.borrowAmount product_apply.borrowCd product_apply.borrowId product_apply.borrowName product_apply.borrowReason product_apply.borrowType product_apply.createBy product_apply.createTime product_apply.interest product_apply.memberId product_apply.mobile product_apply.period product_apply.periodType product_apply.productId product_apply.profession product_apply.rate product_apply.remark product_apply.repayMethod product_apply.safeguardDesc product_apply.status product_apply.ticketDueDate product_apply.ticketType product_apply.verifyManger product_apply.verifyTime product_apply.version product_apply.yearIncomeAmt product_apply_attachment.attachmentId product_apply_attachment.borrowId product_apply_detail.address product_apply_detail.annualSalesVolume product_apply_detail.borrowId product_apply_detail.companyNm product_apply_detail.createBy product_apply_detail.createTime product_apply_detail.detailId product_apply_detail.familyIncome product_apply_detail.gender product_apply_detail.idcard product_apply_detail.legalRepresentative product_apply_detail.monthlyIncome product_apply_detail.occupation product_apply_detail.operatingLife product_apply_detail.organizationCd product_apply_detail.registeredCapital product_apply_detail.safeguard product_apply_detail.safeguardDesc product_apply_detail.totalAssets product_apply_detail.version product_apply_detail.workinfo product_attachment.attachmentId product_attachment.productId product_authinfo.auditProject product_authinfo.auditProjectNm product_authinfo.createBy product_authinfo.createTime product_authinfo.id product_authinfo.infoType product_authinfo.passTime product_authinfo.productId product_authinfo.status product_authinfo.version product_contract_template.contractTemplateId product_contract_template.productId product_order.__title__ // 订单表 product_order.amount // 金额 本金 product_order.anticipatedIncome product_order.couponAmount // 优惠补贴 红包等产生的金额 product_order.couponOutsideOrderNo product_order.createBy product_order.createDate product_order.createTime // 下单时间 product_order.deleted product_order.expectedIncome // 收益 利息 product_order.freezeStatus product_order.freezeTrxId // 资金冻结银行流水号 product_order.investWay // 投资方式 0 手动 1 自动? /** * 手动出借 */ public static final Integer ORDERTYPE_HANDLEINVEST = 0; /** * 自动出借 */ public static final Integer ORDERTYPE_AUTOINVEST = 1; /** * 债权转让 */ public static final Integer ORDERTYPE_CREDITTRANSFER = 2; /** * 充值 */ public static final Integer ORDERTYPE_RECHARGE = 3; /** * 提现 */ public static final Integer ORDERTYPE_CASH = 4; /** * 放款 */ public static final Integer ORDERTYPE_LOANS = 5; /** * 还款 */ public static final Integer ORDERTYPE_REPAYMENT = 6; /** * 转账 */ public static final Integer ORDERTYPE_TRANSFER = 7; product_order.memberId product_order.operationSrc // 认购标识 0 pc 1 微网站 2 android 3 ios; product_order.orderCd product_order.orderDate product_order.orderId product_order.orderNo // 订单编号 product_order.outsideOrderNo // product_order.outsideSerialNo // 资金冻结银行流水号 product_order.payEndDate // 支付时间 product_order.payStatus 支付状态 0 待支付 1 支付成功 2 支付失败 3 待退款 4 已退款 product_order.payUrl product_order.productId product_order.quantity product_order.rate product_order.resultStr product_order.stageFlag // 0:已还款 1:出借 2:已放款 3:临时还款前 4:临时还款后 5:已放款;老系统数据,全为0 product_order.status // 订单状态 0 申请 1 确认 2 废弃 product_order.tradeBankCard 交易卡号 product_order.tradeRealNm product_order.trxId // 资金冻结银行流水号 product_order.unitprice product_order.updateBy product_order.updateTime product_order.verifyStatus // 审核状态 0 待审核 1 审核通过 2 审核驳回 product_order.version product_pledge.auctionCompany product_pledge.auctionTime product_pledge.author product_pledge.createBy product_pledge.createTime product_pledge.dealAmt product_pledge.id product_pledge.pledgeType product_pledge.productId product_pledge.remark product_pledge.size product_pledge.version product_pledge.workName productaudit.auditDesc productaudit.auditOpinion productaudit.auditTime productaudit.createBy productaudit.createTime productaudit.deleted productaudit.newStatus productaudit.newStatusNm productaudit.oldStatus productaudit.oldStatusNm productaudit.productAuditId productaudit.productId productaudit.updateBy productaudit.updateTime productaudit.version productbusinesstype._title_ 产品种类规则 productbusinesstype.abbreviation 单字简称 productbusinesstype.backColor 背景色 productbusinesstype.businessType 业务类型:1 票据类, 2 p2p类 productbusinesstype.businessTypeNm 业务类型:1 票据类, 2 p2p类 productbusinesstype.createBy productbusinesstype.createTime productbusinesstype.currNo 当前期数 productbusinesstype.deleted productbusinesstype.prefixName 前缀名称:银票宝 商票宝 车贷宝 productbusinesstype.productBusinessTypeId productbusinesstype.productBusinessTypeNm 产品种类:银票(电子) 商票(电子) 银行承兑汇票 电子银票 纸质商票 productbusinesstype.updateBy productbusinesstype.updateTime productbusinesstype.version productitemtype.biller productitemtype.calOnlineFlag productitemtype.charger productitemtype.createBy productitemtype.createTime productitemtype.edited productitemtype.feeType productitemtype.itemTypeCd productitemtype.itemTypeId productitemtype.itemTypeNm productitemtype.itemTypePCd productitemtype.maxAmount productitemtype.minAmount productitemtype.node productitemtype.periodOrDay productitemtype.productId productitemtype.productItemTypeId productitemtype.rate productitemtype.rateReferened productitemtype.templateId productitemtype.templateNm productitemtype.version productraterule.beginDay productraterule.createBy productraterule.createTime productraterule.deleted productraterule.endDay productraterule.productRateRuleId productraterule.productTypeRuleId productraterule.rate productraterule.updateBy productraterule.updateTime productraterule.version producttyperule._title_ 产品类型规则(产品模板,依赖productbusinesstype) producttyperule.createBy producttyperule.createTime producttyperule.deleted producttyperule.holidayDelay producttyperule.interestType producttyperule.interestTypeName 计息方式:项目成立计息 即投即生息 producttyperule.periodType producttyperule.periodTypeName producttyperule.productBusinessTypeId producttyperule.productPrefixName producttyperule.productPrifName producttyperule.productTypeName 产品名称(资产类别):村镇 国股 城商 三农 producttyperule.productTypeRuleId producttyperule.repayDelay producttyperule.repayDelayDays 最迟还款延期,一般都是3 producttyperule.repayMethod producttyperule.repayMethodName 还款方式:按期还息到期还本 到期一次返还本息 producttyperule.updateBy producttyperule.updateTime producttyperule.version rechargecashrecord.account rechargecashrecord.actualAmount rechargecashrecord.amount rechargecashrecord.bankCard rechargecashrecord.bankCardId rechargecashrecord.bankCode rechargecashrecord.channel rechargecashrecord.channelNm rechargecashrecord.checkValue rechargecashrecord.city rechargecashrecord.clientFee rechargecashrecord.createBy rechargecashrecord.createTime rechargecashrecord.doType rechargecashrecord.fee rechargecashrecord.feeReceivables rechargecashrecord.freeLimit rechargecashrecord.memberId rechargecashrecord.operationSrc rechargecashrecord.orderId rechargecashrecord.outsideOrderNo rechargecashrecord.outsideSerialNo rechargecashrecord.platFee rechargecashrecord.province rechargecashrecord.realName rechargecashrecord.recordId rechargecashrecord.recordType 1 充值 2提现 rechargecashrecord.remark rechargecashrecord.resultStr rechargecashrecord.serviceFee rechargecashrecord.serviceFeeReceivables rechargecashrecord.status 0 初始 1 成功 2 失败 3 废弃 rechargecashrecord.transferDate rechargecashrecord.transferEndDate rechargecashrecord.version recommend.createBy recommend.createTime recommend.effTime recommend.expTime recommend.listSort recommend.recommendId recommend.state recommend.stateTime recommend.targetId recommend.targetNm recommend.targetType recommend.version region.createBy region.createTime region.listSort region.regionCd region.regionId region.regionNm region.regionPCd region.regionPid region.regionType region.version repay.__title__ // 还款表,总表,每一期的还款金额等;还款申请 时插入 repay.advanceRepayFlag 提前还款标记 0/null 普通还款 1 提前结清申请 2 前置结清申请 3 提前结清完毕 4 前置结清完毕 repay.auditID 确认人 repay.auditRemark 审核意见 repay.auditTime 确认时间 repay.createBy repay.createTime repay.memberId 还款人或代偿人 repay.orderId repay.period 期数 repay.productId repay.receivableAmount 出借人收款总额 repay.repayId repay.repayKind 是否代偿(0:自还,1:代偿) repay.repayRemark 还款备注 repay.repayTime 还款日期 repay.repayTotal 还款总额 还款金额 repay.status // 实际还款状态:0:申请还款 1:还款中-审核完成,调用接口开始还款 2:完成-还款支付成功 3:还款失败 repay.version repayitem.__title__ // 没啥用,有用的数据 repayitemplan 都有,可能是起到关联 repay repayitemplan 两表的作用? repayitem.ItemAmount repayitem.ItemTypeId repayitem.createBy repayitem.createTime repayitem.itemNm repayitem.repayId repayitem.repayItemId repayitem.repayItemPlanId repayitem.version repayitemplan.__title__ // 还款表,每一期的还款明细表 repayitemplan.ItemTypeId repayitemplan.createBy repayitemplan.createTime repayitemplan.interestDateBegin repayitemplan.interestDateEnd repayitemplan.itemAmount repayitemplan.itemNm repayitemplan.period repayitemplan.productId repayitemplan.repayDate repayitemplan.repayItemPlanId repayitemplan.status // 计划还款状态:0:未还款 1:已还款(还款后并不会设为此值,见 repay.status) 2:废弃 3:已代偿 4:已追偿完毕 repayitemplan.version repayment_summary.DueincollectedOverdueInterest repayment_summary.actualDueinCapital repayment_summary.actualDueinInterest repayment_summary.actualDueinTotal repayment_summary.actualRepayCapital repayment_summary.actualRepayInterest repayment_summary.actualRepayPeriod repayment_summary.actualRepayTotal repayment_summary.claimDay repayment_summary.collectedOverdueInterest repayment_summary.createBy repayment_summary.createTime repayment_summary.nextRepayDate repayment_summary.nextRepayTotal repayment_summary.overdueDay repayment_summary.overdueInterest repayment_summary.planRepayCapital repayment_summary.planRepayInterest repayment_summary.planRepayPeriod repayment_summary.planRepayTotal repayment_summary.productId repayment_summary.stillDueinCapital repayment_summary.stillDueinInterest repayment_summary.stillDueinTotal repayment_summary.stillRepayCapital repayment_summary.stillRepayInterest repayment_summary.stillRepayPeriod repayment_summary.stillRepayTotal repayment_summary.version repaymenttrack.advanceRepayFlag repaymenttrack.auditDate repaymenttrack.auditorCd repaymenttrack.auditorId repaymenttrack.createBy repaymenttrack.createTime repaymenttrack.deleted repaymenttrack.interestDateBegin repaymenttrack.interestDateEnd repaymenttrack.memberId repaymenttrack.memberType repaymenttrack.orderId repaymenttrack.outsideOrderNo repaymenttrack.outsideSerialNo repaymenttrack.overdueDays repaymenttrack.overdueInterest repaymenttrack.period repaymenttrack.planCapital repaymenttrack.planInterest repaymenttrack.planReceivableAmount repaymenttrack.planRepayAmount repaymenttrack.planRepayDate repaymenttrack.planStatus repaymenttrack.preReapyDays repaymenttrack.preReapyInterest repaymenttrack.productId repaymenttrack.receivableAmount repaymenttrack.repayAccount repaymenttrack.repayAccountNm repaymenttrack.repayAccountNo repaymenttrack.repayAmount repaymenttrack.repayBankNm repaymenttrack.repayBankNo repaymenttrack.repayCapital repaymenttrack.repayDate repaymenttrack.repayInterest repaymenttrack.repayRemark repaymenttrack.repayStatus repaymenttrack.repayWay repaymenttrack.sufSubsidyOutsideOrderNo repaymenttrack.sufSubsidyOutsideSerialNo repaymenttrack.sufSubsidyPassDate repaymenttrack.sufSubsidyStatus repaymenttrack.trackId repaymenttrack.updateBy repaymenttrack.updateTime repaymenttrack.version safeguard.backletterCd safeguard.companyId safeguard.companyNm safeguard.createBy safeguard.createTime safeguard.debtDesc safeguard.guaranteeDesc safeguard.pawnDesc safeguard.productId safeguard.riskDesc safeguard.safeguardDesc safeguard.version sms_notice.VERSION sms_notice.acceptBy sms_notice.acceptNm sms_notice.batchNo sms_notice.content sms_notice.createBy sms_notice.createTime sms_notice.deleted sms_notice.effTime sms_notice.expTime sms_notice.listSort sms_notice.noticeId sms_notice.readed sms_notice.state sms_notice.stateTime sms_notice.title sms_provider.PASSWORD sms_provider.VERSION sms_provider.createBy sms_provider.createTime sms_provider.effTime sms_provider.expTime sms_provider.extra sms_provider.listSort sms_provider.maxDestination sms_provider.providerCode sms_provider.providerId sms_provider.providerName sms_provider.remark sms_provider.signPrefix sms_provider.signSuffix sms_provider.state sms_provider.stateTime sms_provider.userName sms_provider_log.STATUS sms_provider_log.VERSION sms_provider_log.createBy sms_provider_log.createTime sms_provider_log.deleted sms_provider_log.destination sms_provider_log.extra sms_provider_log.providerId sms_provider_log.providerLogId sms_provider_log.requestContent sms_provider_log.requestTime sms_provider_log.requestTitle sms_provider_log.responseContent sms_provider_log.responseTime sms_provider_log.triggerNode sms_provider_log.updateBy sms_provider_log.updateTime sms_send_queue.STATUS sms_send_queue.VERSION sms_send_queue.content sms_send_queue.createBy sms_send_queue.createTime sms_send_queue.deleted sms_send_queue.destination sms_send_queue.extra sms_send_queue.planSendTime sms_send_queue.providerId sms_send_queue.sendQueueId sms_send_queue.sendTime sms_send_queue.title sms_send_queue.triggerNode sms_send_queue.updateBy sms_send_queue.updateTime sms_template.VERSION sms_template.createBy sms_template.createTime sms_template.effTime sms_template.expTime sms_template.hasTimer sms_template.listSort sms_template.providerId sms_template.receiver sms_template.state sms_template.stateTime sms_template.templateContent sms_template.templateId sms_template.triggerNode sms_template.triggerNodeNm sys_app.appCd sys_app.appDesc sys_app.appId sys_app.appNm sys_app.context sys_app.createBy sys_app.createTime sys_app.effTime sys_app.expTime sys_app.host sys_app.isBusiness sys_app.listSort sys_app.port sys_app.state sys_app.stateTime sys_app.version sys_permission.createBy sys_permission.createTime sys_permission.effTime sys_permission.expTime sys_permission.listSort sys_permission.permissionId sys_permission.permissionType sys_permission.resourceId sys_permission.roleId sys_permission.state sys_permission.stateTime sys_permission.userId sys_permission.version sys_resource.__title__ // 菜单 menu sys_resource.appCd sys_resource.appId sys_resource.bigIcon sys_resource.createBy sys_resource.createTime sys_resource.effTime sys_resource.expTime sys_resource.listSort sys_resource.resourceCd sys_resource.resourceId // id sys_resource.resourceLevel // sys_resource.resourceLink sys_resource.resourceNm // 显示的name sys_resource.resourcePid // pid sys_resource.resourceType sys_resource.smallIcon sys_resource.state sys_resource.stateTime sys_resource.target sys_resource.version sys_role.createBy sys_role.createTime sys_role.effTime sys_role.expTime sys_role.listSort sys_role.roleCd sys_role.roleDesc sys_role.roleId sys_role.roleNm sys_role.state sys_role.stateTime sys_role.version sys_taskconfig.__title__ // 定时任务 sys_taskconfig.createBy sys_taskconfig.createTime sys_taskconfig.effTime sys_taskconfig.expTime sys_taskconfig.listSort sys_taskconfig.state // F0X 禁止运行; sys_taskconfig.stateTime sys_taskconfig.taskCd sys_taskconfig.taskCron sys_taskconfig.taskDesc sys_taskconfig.taskFixedDelay sys_taskconfig.taskFixedRate sys_taskconfig.taskId sys_taskconfig.taskInitialDelay sys_taskconfig.taskMethod sys_taskconfig.taskNm sys_taskconfig.taskRef sys_taskconfig.taskRun sys_taskconfig.taskTrigger sys_taskconfig.version sys_taskconfig.writeLog sys_taskconfig2.createBy sys_taskconfig2.createTime sys_taskconfig2.effTime sys_taskconfig2.expTime sys_taskconfig2.listSort sys_taskconfig2.state sys_taskconfig2.stateTime sys_taskconfig2.taskCd sys_taskconfig2.taskCron sys_taskconfig2.taskDesc sys_taskconfig2.taskFixedDelay sys_taskconfig2.taskFixedRate sys_taskconfig2.taskId sys_taskconfig2.taskInitialDelay sys_taskconfig2.taskMethod sys_taskconfig2.taskNm sys_taskconfig2.taskRef sys_taskconfig2.taskRun sys_taskconfig2.taskTrigger sys_taskconfig2.version sys_taskconfig2.writeLog sys_tasklog.createBy sys_tasklog.createTime sys_tasklog.execDate sys_tasklog.execTime sys_tasklog.message sys_tasklog.status sys_tasklog.taskCd sys_tasklog.taskLogId sys_tasklog.taskNm sys_tasklog.version sys_user.createBy sys_user.createTime sys_user.effTime sys_user.expTime sys_user.isAdmin sys_user.lastIp sys_user.lastLogin sys_user.listSort sys_user.password sys_user.state sys_user.stateTime sys_user.userCd sys_user.userId sys_user.userNm sys_user.version sys_user_role.createBy sys_user_role.createTime sys_user_role.effTime sys_user_role.expTime sys_user_role.listSort sys_user_role.roleId sys_user_role.state sys_user_role.stateTime sys_user_role.userId sys_user_role.userRoleId sys_user_role.version sysoperationlog.createBy sysoperationlog.createTime sysoperationlog.logId sysoperationlog.operateContent sysoperationlog.operateObj sysoperationlog.operateObjName sysoperationlog.operateObjType sysoperationlog.operateTime sysoperationlog.operateType sysoperationlog.operatorAccount sysoperationlog.operatorId sysoperationlog.operatorType sysoperationlog.remark sysoperationlog.version tax_rate_config.createBy tax_rate_config.createTime tax_rate_config.id tax_rate_config.maxLimitAmt tax_rate_config.minLimitAmt tax_rate_config.quickDeductionAmt tax_rate_config.taxRate tax_rate_config.version telcommunicationrecord.commuText telcommunicationrecord.commuTime telcommunicationrecord.createBy telcommunicationrecord.createTime telcommunicationrecord.memberAccount telcommunicationrecord.memberId telcommunicationrecord.operatorAccount telcommunicationrecord.operatorId telcommunicationrecord.orderCd telcommunicationrecord.orderId telcommunicationrecord.productId telcommunicationrecord.productNm telcommunicationrecord.recordId telcommunicationrecord.status telcommunicationrecord.version test_call.id test_call.param tradedetail.__title__ // 交易明细 流水 tradedetail.accountCd tradedetail.createBy tradedetail.createTime tradedetail.currentBalance tradedetail.itemAmount tradedetail.itemTypeCd tradedetail.itemTypeNm tradedetail.memberId tradedetail.nodeFlag tradedetail.nodePk // 投资时ref product_order.orderid;还款时ref repay.repayid;其他情况为null? tradedetail.operationSrc tradedetail.productId // 绝大多数情况下是null,因此对应是哪期项目只能通过remark字段查找。 tradedetail.remark tradedetail.rollInout tradedetail.serialNbr // 资金冻结银行流水号 tradedetail.status // 0 初始化 1 已确认 2 已失败 tradedetail.tradeDetailId tradedetail.version tradedetailrecord.createBy tradedetailrecord.createTime tradedetailrecord.deleted tradedetailrecord.feeType tradedetailrecord.hasChecked tradedetailrecord.inMemberId tradedetailrecord.isMainRecord tradedetailrecord.itemTypeCd tradedetailrecord.itemTypeNm tradedetailrecord.outMemberId tradedetailrecord.remark tradedetailrecord.saveStatus tradedetailrecord.status tradedetailrecord.tradeAmount tradedetailrecord.tradeDetailId tradedetailrecord.tradeEndTime tradedetailrecord.tradeId tradedetailrecord.updateBy tradedetailrecord.updateTime tradedetailrecord.version tradesummary.createBy tradesummary.createTime tradesummary.deleted tradesummary.hasChecked tradesummary.inOutFlag tradesummary.memberId tradesummary.realCd tradesummary.remark tradesummary.serialId tradesummary.sourceDataId tradesummary.sourceDataName tradesummary.status tradesummary.tradeAmount tradesummary.tradeEndTime tradesummary.tradeId tradesummary.tradeType tradesummary.updateBy tradesummary.updateTime tradesummary.version transaction_flow.callbackParams transaction_flow.callbackTime transaction_flow.callbackUrl transaction_flow.createBy transaction_flow.createTime transaction_flow.id transaction_flow.requestParams transaction_flow.requestTime transaction_flow.requestUrl transaction_flow.version transferdetail.bankInvestTransferId transferdetail.createBy transferdetail.createTime transferdetail.itemAmount transferdetail.itemTypeCd transferdetail.itemTypeNm transferdetail.memberIdA transferdetail.memberIdZ transferdetail.transferDetailId transferdetail.version transferspecial.amount transferspecial.ceateByName transferspecial.createBy transferspecial.createTime transferspecial.deleted transferspecial.inAccountCd transferspecial.inMemberId transferspecial.inPhone transferspecial.inRealCd transferspecial.inRealNm transferspecial.orderId transferspecial.outAccountCd transferspecial.outMemberId transferspecial.outPhone transferspecial.outRealCd transferspecial.outRealNm transferspecial.outsideOrderNo transferspecial.outsideSerialNo transferspecial.remark transferspecial.status transferspecial.transferSpecialId transferspecial.updateBy transferspecial.updateTime transferspecial.version user_summary.amountAward user_summary.amountAwardInvest user_summary.amountAwardRow user_summary.amountCash user_summary.amountCashRow user_summary.amountDueRepayAll user_summary.amountDueRepayCapital user_summary.amountDueRepayInterest user_summary.amountDueRepayRow user_summary.amountDueRepayedAll user_summary.amountDueRepayedCapital user_summary.amountDueRepayedInterest user_summary.amountDueRepayedRow user_summary.amountDueinAll user_summary.amountDueinCapital user_summary.amountDueinInterest user_summary.amountDueinRow user_summary.amountInedAll user_summary.amountInedCapital user_summary.amountInedInterest user_summary.amountInedRow user_summary.amountInterestFee user_summary.amountInvest user_summary.amountInvestRow user_summary.amountInvit user_summary.amountRecharge user_summary.amountRechargeRow user_summary.createBy user_summary.createTime user_summary.id user_summary.investIntegral user_summary.memberId user_summary.version visitdata.createBy visitdata.createTime visitdata.dataId visitdata.userData visitdata.version visitdata.visitIp visitdata.visitType xe_u_user.Cipher xe_u_user.Email xe_u_user.Enabled xe_u_user.GroupId xe_u_user.Id xe_u_user.IdCard xe_u_user.Ip xe_u_user.Name xe_u_user.PassSalt xe_u_user.Password xe_u_user.Payment xe_u_user.Recommend xe_u_user.Tel xe_u_user.Tel_Code xe_u_user.UpTime xe_u_user.channel