新闻列表
联系人:JOPO
电话:0515-89892299
手机:13605100007
传真:0515-88440789
E-mail:jopo99@126.com
QQ:724012323
地址:南京市中山东路300号C座6层
网址:http://www.jopo.com.cn
more新闻详情
仓库记账成本属性修改 |
发布者:JOPO 日期:2018/5/30 点击次:409 |
1 仓库属性修改 Warehouse表中bIncost字段(记入成本)
2 单据上记成本属性
3 异常单据整理
bCredit (U8100) 是否为立账单据
cWhCode (U8100) 仓库编码
cPZID (U8100) 是否生成凭证
bCosting (U8100) 单据是否核算 子表中False/
UPDATE RdRecords01
SET bCosting='True' where id in (SELECT id FROM RdRecord01 where cWhCode='1001')UPDATE RdRecords01
SET bCosting='True' where id in (SELECT id FROM RdRecord01 where cWhCode='1002')UPDATE RdRecords01
SET bCosting='True' where id in (SELECT id FROM RdRecord01 where cWhCode='1003')UPDATE RdRecords01
SET bCosting='True' where id in (SELECT id FROM RdRecord01 where cWhCode='1004')
UPDATE RdRecords01
SET bCosting='True' where id in (SELECT id FROM RdRecord01 where cWhCode='1005')
UPDATE RdRecords01
SET bCosting='True' where id in (SELECT id FROM RdRecord01 where cWhCode='1006')
UPDATE RdRecords01
SET bCosting='True' where id in (SELECT id FROM RdRecord01 where cWhCode='1007')
UPDATE RdRecords01
SET bCosting='True'
UPDATE RdRecords08
SET bCosting='True'
UPDATE RdRecords09
SET bCosting='True'
UPDATE RdRecords10 SET bCosting='True'
UPDATE RdRecords11
SET bCosting='True'
UPDATE RdRecords32
SET bCosting='True'
UPDATE RdRecords34
SET bCosting='True' |