浪潮财务软件资产登记簿净值一列没有数值

浪潮财务软件资产登记簿净值一列没有数值

软件版本： 8.5 pack4 软件模块： 固定资产
问题描述：
   资产登记簿净值一列没有数值
产生原因： 
解决方法：
   Delete From LSZBGS Where F_ID=’ZCDJB’ And F_GSBH=’0001′
go
Delete From LSTIGS Where F_ID=’ZCDJB’ And F_GSBH=’0001′
go
Delete From LSOTGS Where F_ID=’ZCDJB’ And F_GSBH=’0001′
go
Insert Into LSZBGS(F_ID,F_GSBH,F_GSMC,F_NAME,F_HEADH,F_BTGD,F_DETH,F_SUMH,F_FOOTH,F_THICK,F_THIN,F_BMGD,F_SPACE,F_WHERE)
       Values(‘ZCDJB’,’0001′,’A4纸格式’,'资产登记薄’,560,401,79,80,0,9,3,200,10,”)
go
Insert Into LSOTGS (F_ID,F_GSBH,F_OTBH,F_OTBZ,F_JS,F_TEXT,F_PLACE)
       Values(‘ZCDJB’,’0001′,’01′,’H',’1′,’@MC1@’,'L’)
go
Insert Into LSOTGS (F_ID,F_GSBH,F_OTBH,F_OTBZ,F_JS,F_TEXT,F_PLACE)
       Values(‘ZCDJB’,’0001′,’02′,’H',’1′,’@MC2@’,'M’)
go
Insert Into LSOTGS (F_ID,F_GSBH,F_OTBH,F_OTBZ,F_JS,F_TEXT,F_PLACE)
       Values(‘ZCDJB’,’0001′,’04′,’H',’2′,’@MC4@’,'L’)
go
Insert Into LSOTGS (F_ID,F_GSBH,F_OTBH,F_OTBZ,F_JS,F_TEXT,F_PLACE)
       Values(‘ZCDJB’,’0001′,’06′,’H',’2′,’@MC6@’,'R’)
go
Insert Into LSOTGS (F_ID,F_GSBH,F_OTBH,F_OTBZ,F_JS,F_TEXT,F_PLACE)
       Values(‘ZCDJB’,’0001′,’08′,’H',’3′,’@MC8@’,'M’)
go
Insert Into LSOTGS (F_ID,F_GSBH,F_OTBH,F_OTBZ,F_JS,F_TEXT,F_PLACE)
       Values(‘ZCDJB’,’0001′,’09′,’H',’3′,’@MC9@’,'R’)
go
Insert Into LSOTGS (F_ID,F_GSBH,F_OTBH,F_OTBZ,F_JS,F_TEXT,F_PLACE)
       Values(‘ZCDJB’,’0001′,’05′,’H',’2′,’@MC5@’,'M’)
go
Insert Into LSOTGS (F_ID,F_GSBH,F_OTBH,F_OTBZ,F_JS,F_TEXT,F_PLACE)
       Values(‘ZCDJB’,’0001′,’07′,’H',’3′,’@MC7@’,'L’)
go
Insert Into LSOTGS (F_ID,F_GSBH,F_OTBH,F_OTBZ,F_JS,F_TEXT,F_PLACE)
       Values(‘ZCDJB’,’0001′,’03′,’H',’1′,’@MC3@’,'R’)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’001′,’1′,”,’@KJND@年’,'C’,’120′,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’001001′,’2′,’F_MON’,'月’,'C’,’100′,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’001002′,’2′,’F_DAY’,'日’,'C’,’100′,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’002′,’1′,’F_PZBH’,'凭证编号’,'C’,’300′,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’003′,’1′,’F_JY’,'摘要’,'C’,’865′,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’004′,’1′,’F_SL’,'数量’,'S’,’345′,0,”,”,”,”,’0′,0,0,0,”,”)
go
–原值
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’005′,’1′,”,’原值’,”,”,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’005001′,’2′,’F_YZJF’,'借方’,'J’,’518′,0,”,”,”,”,’0′,1,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’005002′,’2′,’F_YZDF’,'贷方’,'J’,’518′,0,”,”,”,”,’0′,1,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’005003′,’2′,’F_YZFX’,'方向’,'M’,’121′,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’005004′,’2′,’F_YZYE’,'余额’,'J’,’518′,0,”,”,”,”,’0′,1,0,0,”,”)
go
–累计折旧
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’007′,’1′,”,’累计折旧’,”,”,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’007001′,’2′,’F_ZJJF’,'借方’,'J’,’518′,0,”,”,”,”,’0′,1,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’007002′,’2′,’F_ZJDF’,'贷方’,'J’,’518′,0,”,”,”,”,’0′,1,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’007003′,’2′,’F_ZJFX’,'方向’,'M’,’121′,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’007004′,’2′,’F_ZJYE’,'余额’,'J’,’518′,0,”,”,”,”,’0′,1,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’008′,’1′,”,’减值准备’,”,”,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’008001′,’2′,’F_JZJF’,'借方’,'J’,’518′,0,”,”,”,”,’0′,1,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’008002′,’2′,’F_JZDF’,'贷方’,'J’,’518′,0,”,”,”,”,’0′,1,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’008003′,’2′,’F_JZFX’,'方向’,'M’,’121′,0,”,”,”,”,’0′,0,0,0,”,”)
go
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’008004′,’2′,’F_JZYE’,'余额’,'J’,’518′,0,”,”,”,”,’0′,1,0,0,”,”)
go
–净值
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’009′,’1′,’F_ZCJZ’,'净值’,'J’,’518′,0,”,”,”,”,’0′,0,0,0,”,”)
go
–现值
Insert Into LSTIGS(F_ID,F_GSBH,F_TIBH,F_JS,F_NAME,F_TEXT,F_TILX,F_WIDTH,F_SUM,F_QFBZ,F_DDDW,F_DISP,F_DATA,F_YHF,F_RED,F_SIGN,F_SORT,F_SXBZ,F_XSGS)
       Values(‘ZCDJB’,’0001′,’010′,’1′,’F_ZCXZ’,'现值’,'J’,’518′,0,”,”,”,”,’0′,0,0,0,”,”)
go

–资产登记薄修改后的格式定义SQL

文章的脚注信息由WordPress的wp-posturl插件自动生成