杂发单：

SELECT DocNo,* from InvDoc_MiscShipment

SELECT *  from  InvDoc_MiscShipmentCost_Trl

SELECT DocNo,*  from  InvDoc_MiscShipmentCost

SELECT Status as '状态',*  from  InvDoc_MiscShip WHERE DocNo='ZF02023110020'

update InvDoc_MiscShip SET Status='0' WHERE Status='1'  --更新单据状态为开立状态，启动审批流

DELETE  from InvDoc_MiscShip WHERE  (Status='0' or  Status='1')--清除未审核的杂发单（开立或核准中状态)

(Trl 多语表、His历史版本表）