金蝶Cloud 应收账龄分析表-按到期日查询SQL

已于 2022-01-19 13:10:34 修改
阅读量2.3k 收藏 2
点赞数 4
分类专栏： SQL 文章标签： sql
于 2022-01-19 12:58:43 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/langji_1/article/details/122578494
版权

金蝶Cloud 应收账龄分析表-按到期日查询SQL

select t.组织,t.客户,sum(t.余额*isnull(m.FEXCHANGERATE,1)) 期末余额,
            sum(isnull(t.[账期内],0)*isnull(m.FEXCHANGERATE,1)) [账期内],
            sum(isnull(t.[超账期1个月],0)*isnull(m.FEXCHANGERATE,1)) [超账期1个月],
            sum(isnull(t.[超账期2个月],0)*isnull(m.FEXCHANGERATE,1)) [超账期2个月],
            sum(isnull(t.[超账期3个月],0)*isnull(m.FEXCHANGERATE,1)) [超账期3个月],
			sum(isnull(t.[超账期4个月及以上],0)*isnull(m.FEXCHANGERATE,1)) [超账期4个月及以上]
            from
            (select t5.FNAME 组织,t4.FNAME 客户,sum(t18.FPayAmountFor-ISNULL(APmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)-ISNULL(ARmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)) 余额,
            case when datediff(dd,t1.FENDDATE,getdate())<=0 then 
            sum(t18.FPayAmountFor-ISNULL(APmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)-ISNULL(ARmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)) end [账期内],
            case when datediff(dd,t1.FENDDATE,getdate())>0 and datediff(dd,t1.FENDDATE,getdate())<=30 then 
            sum(t18.FPayAmountFor-ISNULL(APmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)-ISNULL(ARmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期1个月],
            case when datediff(dd,t1.FENDDATE,getdate())>30 and datediff(dd,t1.FENDDATE,getdate())<=60 then 
            sum(t18.FPayAmountFor-ISNULL(APmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)-ISNULL(ARmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期2个月],
            case when datediff(dd,t1.FENDDATE,getdate())>60 and datediff(dd,t1.FENDDATE,getdate())<=90 then 
            sum(t18.FPayAmountFor-ISNULL(APmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)-ISNULL(ARmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期3个月],
			case when datediff(dd,t1.FENDDATE,getdate())>90 then 
            sum(t18.FPayAmountFor-ISNULL(APmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)-ISNULL(ARmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期4个月及以上],
            t1.FCURRENCYID 币别
            from t_AR_receivable t1
            --left join T_AR_RECEIVABLEENTRY t2 on t1.FID=t2.FID
            left join T_BD_CUSTOMER_L t4 on t4.FCUSTID=t1.FCUSTOMERID and t4.FLOCALEID=2052
            left join T_ORG_ORGANIZATIONS_L t5 on t1.FSALEORGID=t5.FORGID and t5.FLOCALEID=2052
            left join T_BD_CUSTOMER t10 on t4.FCUSTID=t10.FCUSTID
            left join T_BD_CUSTOMERGROUP_L t11 on t10.FPRIMARYGROUP=t11.FID and t11.FLOCALEID=2052
            left join t_AR_receivableFIN t17 on t1.FID=t17.FID
            left join T_AR_RECEIVABLEPLAN t18 ON t1.FID = t18.FID 
            left join (
            SELECT data1.FSourceFromid,data1.FSrcBillId,data1.FSrcRowId,ISNULL(sum(data1.FCURWRITTENOFFAMOUNTFOR),0) fcurwrittenoffamountfor,
            ISNULL(sum(data1.FCURWRITTENOFFAMOUNT),0) fcurwrittenoffamount FROM 
            (SELECT LogEntry.FSourceFromid,FSrcBillId,FSrcRowId,LogEntry.FCURWRITTENOFFAMOUNTFOR,LogEntry.FCURWRITTENOFFAMOUNT FROM T_AR_RECMacthLog PayLog 
            INNER JOIN T_AR_RECMacthLogENTRY LogEntry ON PayLog.Fid = LogEntry.Fid    
            WHERE LogEntry.FSourceFromid = 'AR_receivable') data1
            GROUP BY data1.FSourceFromid,data1.FSrcBillId,data1.FSrcRowId) armatchrecord 
            ON t1.FId = ARmatchRecord.FSrcBillId AND t18.FEntryId = ARmatchRecord.FSrcRowId
            left join (SELECT data2.FSourceFromid,data2.FSrcBillId,data2.FSrcRowId,ISNULL(sum(data2.FCURWRITTENOFFAMOUNTFOR),0) fcurwrittenoffamountfor,
            ISNULL(sum(data2.FCURWRITTENOFFAMOUNT),0) fcurwrittenoffamount 
            FROM (SELECT LogEntry.FSourceFromid,FSrcBillId,FSrcRowId,LogEntry.FCURWRITTENOFFAMOUNTFOR,LogEntry.FCURWRITTENOFFAMOUNT FROM T_AP_PAYMatchLog PayLog 
            INNER JOIN T_AP_PAYMatchLogEntry LogEntry ON PayLog.Fid = LogEntry.Fid    
            WHERE LogEntry.FSourceFromid = 'AR_receivable') data2 
            GROUP BY data2.FSourceFromid,data2.FSrcBillId,data2.FSrcRowId) apmatchrecord 
            ON t1.FId = APmatchRecord.FSrcBillId AND t18.FEntryId = APmatchRecord.FSrcRowId 
            where t1.FDOCUMENTSTATUS='C' and t11.FNAME<>'关联公司'
            group by t5.FNAME,t4.FNAME,t1.FENDDATE,t1.FCURRENCYID
            having sum(t18.FPayAmountFor-ISNULL(APmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)-ISNULL(ARmatchRecord.FCURWRITTENOFFAMOUNTFOR,0)) <>0

            union all
            select t5.FNAME 组织,t4.FNAME 客户,-SUM(ISNULL(t2.FRECTOTALAMOUNTFOR, 0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR, 0)) 收款金额,
            case when datediff(dd,t1.FDATE,getdate())<=0 then -SUM(ISNULL(t2.FRECTOTALAMOUNTFOR, 0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR, 0)) end [账期内],
            case when datediff(dd,t1.FDATE,getdate())>0 and datediff(dd,t1.FDATE,getdate())<=30 then -SUM(ISNULL(t2.FRECTOTALAMOUNTFOR, 0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR, 0)) end [超账期1个月],
            case when datediff(dd,t1.FDATE,getdate())>30 and datediff(dd,t1.FDATE,getdate())<=60 then -SUM(ISNULL(t2.FRECTOTALAMOUNTFOR, 0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR, 0)) end [超账期2个月],
			case when datediff(dd,t1.FDATE,getdate())>60 and datediff(dd,t1.FDATE,getdate())<=90 then -SUM(ISNULL(t2.FRECTOTALAMOUNTFOR, 0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR, 0)) end [超账期3个月],
            case when datediff(dd,t1.FDATE,getdate())>90 then -SUM(ISNULL(t2.FRECTOTALAMOUNTFOR, 0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR, 0)) end [超账期4个月及以上],
            t1.FCURRENCYID 币别
            from T_AR_RECEIVEBILL t1
            left join T_AR_RECEIVEBILLENTRY t2 on t1.FID=t2.FID
            left join T_BD_CUSTOMER_L t4 on t4.FCUSTID=t1.FCONTACTUNIT and t4.FLOCALEID=2052
            left join T_ORG_ORGANIZATIONS_L t5 on t1.FSALEORGID=t5.FORGID and t5.FLOCALEID=2052
            left join T_BD_CUSTOMER t10 on t4.FCUSTID=t10.FCUSTID
            left join T_BD_CUSTOMERGROUP_L t11 on t10.FPRIMARYGROUP=t11.FID and t11.FLOCALEID=2052
            left join (
                SELECT data.FSourceFromid,data.FSrcBillId,data.FSRCROWID,ISNULL(sum(data.FCURWRITTENOFFAMOUNTFOR),0) fcurwrittenoffamountfor,ISNULL(sum(data.FCURWRITTENOFFAMOUNT),0) fcurwrittenoffamount 
                FROM (SELECT LogEntry.FSourceFromid,FSrcBillId,LogEntry.FSRCROWID,LogEntry.FCURWRITTENOFFAMOUNTFOR,LogEntry.FCURWRITTENOFFAMOUNT FROM T_AR_RECMacthLog PayLog 
                INNER JOIN T_AR_RECMacthLogENTRY LogEntry ON PayLog.Fid = LogEntry.Fid 
                WHERE LogEntry.FSourceFromid = 'AR_RECEIVEBILL') data 
                GROUP BY data.FSourceFromid,data.FSrcBillId,data.FSRCROWID) t17 ON t1.FId = t17.FSrcBillId AND t2.FENTRYID = t17.FSRCROWID
            where t1.FDOCUMENTSTATUS='C' and t11.FNAME<>'关联公司'
            group by t5.FNAME,t4.FNAME,t1.FDATE,t1.FCURRENCYID

            union all
            select t5.FNAME 组织,t4.FNAME 客户,SUM(ISNULL(t2.FREFUNDAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) 退款金额,
            case when datediff(dd,t1.FDATE,getdate())<=0 then SUM(ISNULL(t2.FREFUNDAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [账期内],
            case when datediff(dd,t1.FDATE,getdate())>0 and datediff(dd,t1.FDATE,getdate())<=30 then SUM(ISNULL(t2.FREFUNDAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期1个月],
            case when datediff(dd,t1.FDATE,getdate())>30 and datediff(dd,t1.FDATE,getdate())<=60 then SUM(ISNULL(t2.FREFUNDAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期2个月],
			case when datediff(dd,t1.FDATE,getdate())>60 and datediff(dd,t1.FDATE,getdate())<=90 then SUM(ISNULL(t2.FREFUNDAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期3个月],
            case when datediff(dd,t1.FDATE,getdate())>90 then SUM(ISNULL(t2.FREFUNDAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期4个月及以上],
            t1.FCURRENCYID 币别
            from T_AR_REFUNDBILL t1
            left join T_AR_REFUNDBILLENTRY t2 on t1.FID=t2.FID
            left join T_BD_CUSTOMER_L t4 on t4.FCUSTID=t1.FCONTACTUNIT and t4.FLOCALEID=2052
            left join T_ORG_ORGANIZATIONS_L t5 on t1.FSALEORGID=t5.FORGID and t5.FLOCALEID=2052
            left join T_BD_CUSTOMER t10 on t4.FCUSTID=t10.FCUSTID
            left join T_BD_CUSTOMERGROUP_L t11 on t10.FPRIMARYGROUP=t11.FID and t11.FLOCALEID=2052
            left join (SELECT data.FSourceFromid,data.FSrcBillId,data.FSRCROWID,ISNULL(sum(data.FCURWRITTENOFFAMOUNTFOR),0) fcurwrittenoffamountfor,ISNULL(sum(data.FCURWRITTENOFFAMOUNT),0) fcurwrittenoffamount 
                       FROM (SELECT LogEntry.FSourceFromid,FSrcBillId,LogEntry.FSRCROWID,LogEntry.FCURWRITTENOFFAMOUNTFOR,LogEntry.FCURWRITTENOFFAMOUNT FROM T_AR_RECMacthLog PayLog 
                       INNER JOIN T_AR_RECMacthLogENTRY LogEntry ON PayLog.Fid = LogEntry.Fid 
                       WHERE LogEntry.FSourceFromid = 'AR_REFUNDBILL') data 
                       GROUP BY data.FSourceFromid,data.FSrcBillId,data.FSRCROWID) t17 ON t1.FId = t17.FSrcBillId AND t2.FENTRYID = t17.FSRCROWID
            where t1.FDOCUMENTSTATUS='C' and t11.FNAME<>'关联公司'
            group by t5.FNAME,t4.FNAME,t1.FDATE,t1.FCURRENCYID

            union all
            select t5.FNAME 组织,t4.FNAME 客户,SUM(ISNULL(t2.FAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) 应收金额,
            case when datediff(dd,t1.FENDDATE,getdate())<=0 then SUM(ISNULL(t2.FAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [账期内],
            case when datediff(dd,t1.FENDDATE,getdate())>0 and datediff(dd,t1.FENDDATE,getdate())<=30 then SUM(ISNULL(t2.FAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期1个月],
            case when datediff(dd,t1.FENDDATE,getdate())>30 and datediff(dd,t1.FENDDATE,getdate())<=60 then SUM(ISNULL(t2.FAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期2个月],
			case when datediff(dd,t1.FENDDATE,getdate())>60 and datediff(dd,t1.FENDDATE,getdate())<=90 then SUM(ISNULL(t2.FAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期3个月],
            case when datediff(dd,t1.FENDDATE,getdate())>90 then SUM(ISNULL(t2.FAMOUNTFOR,0)-ISNULL(t17.FCURWRITTENOFFAMOUNTFOR,0)) end [超账期4个月及以上],
            t1.FCURRENCYID 币别
            from T_AR_OtherRecAble t1
            left join T_AR_OtherRecAbleENTRY t2 on t1.FID=t2.FID
            left join T_BD_CUSTOMER_L t4 on t4.FCUSTID=t1.FCONTACTUNIT and t4.FLOCALEID=2052
            left join T_ORG_ORGANIZATIONS_L t5 on t1.FSALEORGID=t5.FORGID and t5.FLOCALEID=2052
            left join T_BD_CUSTOMER t10 on t4.FCUSTID=t10.FCUSTID
            left join T_BD_CUSTOMERGROUP_L t11 on t10.FPRIMARYGROUP=t11.FID and t11.FLOCALEID=2052
            left join (SELECT data.FSourceFromid,data.FSrcBillId,data.FSRCROWID,ISNULL(sum(data.FCURWRITTENOFFAMOUNTFOR),0) fcurwrittenoffamountfor,ISNULL(sum(data.FCURWRITTENOFFAMOUNT),0) fcurwrittenoffamount 
                       FROM (SELECT LogEntry.FSourceFromid,FSrcBillId,LogEntry.FSRCROWID,LogEntry.FCURWRITTENOFFAMOUNTFOR,LogEntry.FCURWRITTENOFFAMOUNT FROM T_AR_RECMacthLog PayLog 
                       INNER JOIN T_AR_RECMacthLogENTRY LogEntry ON PayLog.Fid = LogEntry.Fid 
                       WHERE LogEntry.FSourceFromid = 'AR_OtherRecAble') data 
                       GROUP BY data.FSourceFromid,data.FSrcBillId,data.FSRCROWID) t17 ON t1.FId = t17.FSrcBillId AND t2.FENTRYID = t17.FSRCROWID
            where t1.FDOCUMENTSTATUS='C' and t11.FNAME<>'关联公司'
            group by t5.FNAME,t4.FNAME,t1.FENDDATE,t1.FCURRENCYID
            )t
            left join T_BD_RATE m on t.币别=m.FCYFORID and m.FRATETYPEID=2  
            where t.组织='公司名称'
            group by t.组织,t.客户,t.币别
凌轩志
关注
  • 4
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论
专栏目录
金蝶云星空销售、MRP、采购、生产、委外全流程跟踪SQL
weixin_44466090的博客
02-16 1944
select SalesOrderNumber,SalesReviewStatus,SalesClosedStatus,SalesOrderDate,SalesCustom,SalesItemNumber, SalesItemName,SalesQty,SalesPrice,SalesTaxPrice,SalesOriginalCurrency,SalesAmountInBaseCurrency,SalesTaxRate, SalesOriginalCurrencyTax,SalesBaseCurrency
金蝶K3库存账龄分析表（优化）
mamengna的博客
12-28 562
Set NoCount On SET ANSI_WARNINGS OFF Create Table #Happen2( FItemID int Null, FStockID int Null, FBatchNo NVARCHAR(200), FQty decimal(28,10) Null, FCUUnitQty decimal(28,10) Null, FQty1 Decimal(28,10), ...
金蝶Cloud简单账表双击打开对应单据
08-04
金蝶Cloud简单账表双击打开对应单据，代码简单，可以实现单据页签打开和窗口打开等方式
金蝶云星空字典表 SQL 数据库表 开发工具
08-12
方便做SQL视图或开发使用，运行K3CloudDataDictionaryexe.
金蝶K3-Cloud云星空数据库表字典
06-18
金蝶K3-Cloud云星空开发，二次开发
金蝶K3CLOUD 常用SQL
03-10
金蝶K3CLOUD 常用SQL 。金蝶维护人员的好助手
金蝶云星空库存账龄分析表(SQL)
01-16
金蝶云星空库存账龄分析表(SQL)
有老哥写过金蝶云星空的库存账龄表的sql语句嘛
qq_33322336的博客
08-26 1127
有老哥写过金蝶云星空的库存账龄表的sql语句嘛？ 有偿。
金蝶K3 SQL报表系列-库存账龄分析
mamengna的博客
12-27 1723
1、创建存储过程：sql代码如下： create procedure [dbo].[rk_sp_stock_Age] @paraYear int, @parePeriod int as declare @year int declare @period int declare @Fdate datetime --declare @paraYear int --declare @parePe...
金蝶k3库存账龄分析报表（带参数）
hzfw2008的博客
12-14 6136
金蝶k3库存账龄分析报表（带参数）。可以根据需要查看特定账期的库存账龄。
3.基于Android 10 分析Activity启动过程
wangjian_dage的博客
03-07 3919
基于Android10分析Activity启动流程。
序列和序列对象
wangprince2017
12-09 1436
序列和序列对象 Seq 类 Seq类是Biopython最基础的一类, 储存序列信息. from Bio.Seq import Seq. 该类基本格式是Seq(self, data, alphabet=Alphabet()). 类似于字符串, 能够储存蛋白, DNA, RNA序列信息. 该类是不可变的. 该类和str类似, 支持count, find, split, strip. 相比str...
CI 框架中 AR 操作
weixin_30830327的博客
10-14 174
Model 层中的部分代码 1 /** 2 * CI 中的 AR 操作 3 * @author zhaoyingnan 4 **/ 5 public function mAR() 6 { 7 /*************** 查询 *************/ 8 //s...
金蝶kis云+sqlserver报表分析
weixin_49092494的博客
12-08 488
文章目录封装存储过程金蝶kis云执行示例 封装存储过程 sql代码走一波 go drop procedure test1 go create procedure test1 @fromEmpNum varchar(64), @toEmpNum varchar(64) as begin SELECT I.FNumber,I.FName,D.*,isnull(D.入库,0)-isnull(D.出库,0) as [余额] FROM (select E.FItemID, --(case w
金蝶云星空即时库存查询SQL语句SQLServer
qq_30925199的博客
03-26 6800
公司需要，需要同步库存数据，这就需要用SQL语句来写即时库存查询，用了Microsoft SQL Server Management Studio来抓语句，抓了很久抓到如下语句： SELECT * FROM ( SELECT t0.FMATERIALID fmaterialid_id, t0.FSTOCKID fs...
金蝶K3直接SQL报表实现动态行转列报表
Eypsn的专栏
10-13 1414
我们知道，在BOS开发中，想实现动态行转列报表，可以使用交叉分析表来实现，但交叉分析表不太灵活，比如当动态列中有需要复杂的逻辑运算来实现时就无能为力了，下面介绍使用直接SQL报表来实现，也许能给你一点启发。 以如下表数据为例，来说明如何实现： 要求实现这样的报表样式： 具体实现步骤如下： 1、使用以下存储过程随便建一个直接SQL报表「测试行列转换报表」。 CREATE Procedure sp_Rpt_Test AS SET NOCOUNT ON SELECT FUs...
sql按年、季度、月统计实现
a116385895的博客
09-03 5501
#按年统计 SELECT SUM(browseNum) AS browseNum, COUNT(*) AS sheets FROM sbsm_count_picture GROUP BY DATE_FORMAT(DATE, '%Y'); #按月统计 SELECT SUM(browseNum) AS browseNum,SUM(downloadNum) AS downloadNum,SUM(telB...
SQL 按周,月,季度,年查询统计数据
漂渺影子的专栏
03-01 5968
//按自然周统计 select to_char(date,iw),sum() from where group by to_char(date,iw) //按自然月统计 select to_char(date,mm),sum() from where group by to_char(date,mm) //按季统计 select to_char(date,q),sum() fr
跟踪金蝶K3系统后台数据库执行逻辑跟踪，提取原版SQL语句
最新发布
jason_yuanqing2012的专栏
06-25 477
日常进行K3相关操作需要对K3后台数据库逻辑进行监听的时候，需要启用SQL跟踪任务，通过跟踪任务可以获取实时的K3后台执行语句，进而研究其后台执行逻辑。如果需要定位到具体的数据库，可以先使用SELECT DB_ID()找出该数据库的ID，然后勾选显示所有列，再打开列筛选器；7、按下ctrl+f快捷键，调出查找窗口，使用表关键词进行语句查找，即可查找出K3后台数据库执行的语句；DatabaseID填写查询到的数据库ID值，确定即可限制对特定数据库的跟踪；8、将跟踪到的语句复制出来，粘贴至SSMS执行；
金蝶kis专业版sql数据库表
06-25
采用了金蝶KIS专业版SQL数据库表，企业能够实现全面监控和分析数据，便于管理决策。此外，这种数据库还具有高效的存储和查询性能，能够满足大多数企业的需求。 总的来说，金蝶KIS专业版SQL数据库表是一种非常实用的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

凌轩志

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值