新闻列表
联系人：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 点击次：352 |
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' |