用友存货核算850数据库变动说明

《用友存货核算850数据库变动说明》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、存货核算850数据库变动说明一、新增表：数据库模块修改对象名称表中文名主备注UFData存货核算IA_MemoSet存货制单摘要内容设置表制单摘要内容设置UFData存货核算IA_DecReadyHead跌价准备科目设置表UFData存货核算IA_DecReady跌价准备单主表UFData存货核算IA_DecReadys跌价准备单子表2002.10.21UFData存货核算IA_EnSubsidiary发出商品明细账发出商品货明细账1、存货制单摘要内容设置表（IA_MemoSet）序号字段中文名字段名typelengthisnul

2、lablescaledomainprecDefacolstat检验检验条件是否建立关联表及字段1自动编号AutoIDint40001012单据类型编码cVouchTypevarchar20020VouchType.cVouchType3字段名称cFieldNamevarchar20102004字段顺序号cFieldOrderint41001005字段中文说明cFieldDescvarchar50105002、跌价准备科目设置表（IA_DecReadyHead）序号字段中文名字段名typelengthisnullablescaled

3、omainprecDefacolstat检验检验条件是否建立关联表及字段1自动编号AutoIDint40001012存货编码cInvCodevarchar2010200存货编码Inventory.cInvCode3存货大类编码cInvCCodevarchar1210120存货大类编码InventoryClass.cInvCCode4跌价准备科目编码cDecHeadvarchar1510150code.ccode5费用科目编码cFyHeadvarchar1510150code.ccode6可变现价格iActualPricemoney

4、81401901、跌价准备单主表（IA_DecReady）序号字段中文名字段名typelengthisnullablescaledomainprecDefacolstat检验检验条件是否建立关联表及字段1跌价准备单主表标识IDint4000100主表关联项2跌价准备单号cDecCodevarchar3000300主表关联项3单据类型编码cVouchTypevarchar20020VouchType.cVouchType4单据日期dDatedatetime80302305部门编码cDepCodevarchar1210120部门编码D

5、epartment.cDepCode6自定义项1cDefine1varchar20102007自定义项2cDefine2varchar20102008自定义项3cDefine3varchar20102009自定义项4cDefine4datetime813023010自定义项5cDefine5int410010011自定义项6cDefine6datetime813023012自定义项7cDefine7float81053013自定义项8cDefine8varchar4104014自定义项9cDefine9varchar8108015

6、自定义项10cDefine10varchar601060016自定义项11cDefine11varchar12010120017自定义项12cDefine12varchar12010120018自定义项13cDefine13varchar12010120019自定义项14cDefine14varchar12010120020自定义项15cDefine15int410010021自定义项16cDefine16float81053022时间戳uftstimestamp8008023单据模版号VT_IDint4100100Voucher

7、Templates.VT_ID24制单人cMakervarchar8108025审核人cVeriPersonvarchar8108026审核日期dVeriDatedatetime813023027业务员编码cPersonCodevarchar81080职员编码Person.cPersonCode28凭证类别字cPZtypevarchar81080Dsign.csign29凭证编号iPZIDint410010030凭证日期iPZDatedatetime813023031凭证摘要cPZdigestvarchar601060032凭证线

8、索号cpzidvarchar30103001、跌价准备单子表（IA_DecReadys）序号字段中文名字段名typelengthisnullablescaledomainprecDefacolstat检验检验条件是否建立关联表及字段1跌价准备单子表