实物资产卡片多数量拆分流程整理 2021.01.06

select * from INVENTORY_FA_CARD  where (GL_CODE= '00001090' or ORGCODE = '00001090') and   TYPECODE in ('0104','1902')and QTY = 42

--where后可修改为 id或 fa_code 唯一值 进行过滤，

insert into INVENTORY_FA_CARD select * from INVENTORY_FA_CARD  where (GL_CODE= '00001090' or ORGCODE = '00001090') and   TYPECODE in ('0104','1902')and QTY = 42

--重点关注 数量、金额 相关字段

--一次更新多字段--

update INVENTORY_FA_CARD set qty =1,ORIVAL =216.81 where id in ('236162')

--插入

--id,fa_code,表设置了触发器，值会重新生成。

insert into INVENTORY_FA_CARD  select * from INVENTORY_FA_CARD  where id ='236162'

--查询验证，是否新插入成功

select * from INVENTORY_FA_CARD  where (GL_CODE= '00001090' or ORGCODE = '00001090') and   TYPECODE in ('1902')

and QTY = 1

declare

      i number :=1;

begin

     for i in 1..10 loop

        --插入唯一正确值---

        insert into INVENTORY_FA_CARD  select * from INVENTORY_FA_CARD  where id ='236164';    

      end loop;

--查询验证，是否新插入成功

select * from INVENTORY_FA_CARD  where (GL_CODE= '00001090' or ORGCODE = '00001090') and   TYPECODE in ('1902')

and QTY = 1

delete from INVENTORY_FA_CARD where id ='31679';