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

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

2、检验检验条件是否建立关联表及字段1自动编号autoidint40001012单据类型编码cvouchtypevarchar20020vouchtype.cvouchtype3字段名称cfieldnamevarchar20102004字段顺序号cfieldorderint41001005字段中文说明cfielddescvarchar50105002、 跌价准备科目设置表（ia_decreadyhead）序号字段中文名字段名typelengthisnullablescaledomainprecdefacolstat检验检验条件是否建立关联表及字段1自动编号autoidint40001012存货编码

3、cinvcodevarchar2010200存货编码inventory.cinvcode3存货大类编码cinvccodevarchar1210120存货大类编码inventoryclass.cinvccode4跌价准备科目编码cdecheadvarchar1510150code.ccode5费用科目编码cfyheadvarchar1510150code.ccode6可变现价格iactualpricemoney81401903、 跌价准备单主表（ia_decready）序号字段中文名字段名typelengthisnullablescaledomainprecdefacolstat检验检验条件是否

4、建立关联表及字段1跌价准备单主表标识idint4000100主表关联项2跌价准备单号cdeccodevarchar3000300主表关联项3单据类型编码cvouchtypevarchar20020vouchtype.cvouchtype4单据日期ddatedatetime80302305部门编码cdepcodevarchar1210120部门编码department.cdepcode6自定义项1cdefine1varchar20102007自定义项2cdefine2varchar20102008自定义项3cdefine3varchar20102009自定义项4cdefine4datetime8

5、13023010自定义项5cdefine5int410010011自定义项6cdefine6datetime813023012自定义项7cdefine7float81053013自定义项8cdefine8varchar4104014自定义项9cdefine9varchar8108015自定义项10cdefine10varchar601060016自定义项11cdefine11varchar12010120017自定义项12cdefine12varchar12010120018自定义项13cdefine13varchar12010120019自定义项14cdefine14varchar12010

6、120020自定义项15cdefine15int410010021自定义项16cdefine16float81053022时间戳uftstimestamp8008023单据模版号vt_idint4100100vouchertemplates.vt_id24制单人cmakervarchar8108025审核人cveripersonvarchar8108026审核日期dveridatedatetime813023027业务员编码cpersoncodevarchar81080职员编码person.cpersoncode28凭证类别字cpztypevarchar81080dsign.csign29凭证

7、编号ipzidint410010030凭证日期ipzdatedatetime813023031凭证摘要cpzdigestvarchar601060032凭证线索号cpzidvarchar30103004、 跌价准备单子表（ia_decreadys）序号字段中文名字段名typelengthisnullablescaledomainprecdefacolstat检验检验条件是否建立关联表及字段1跌价准备单子表标识autoidint4000101子表关联项2跌价准备单主表标识idvarchar2000200与主表关联：ia_decready.id3仓库编码cwhcodevarchar1210120仓

8、库编码warehouse.cwhcode4存货编码cinvcodevarchar2010200存货编码inventory.cinvcode10存货自由项1cfree1varchar201020011存货自由项2cfree2varchar201020012存货自由项3cfree3varchar201020013存货自由项4cfree4varchar201020014存货自由项5cfree5varchar201020015存货自由项6cfree6varchar201020016存货自由项7cfree7varchar201020017存货自由项8cfree8varchar201020018存货自由项

9、9cfree9varchar201020019存货自由项10cfree10varchar201020020结存数量iquantityfloat81053021结存单价icostfloat81053022结存金额ipricemoney814019023可变现价格iactualcostfloat81053024可变现金额iactualpricemoney814019025应计提金额indecpricemoney814019026已计提金额iadecpricemoney814019027本次计提金额ithispricemoney814019028本次回冲金额ithisrepricemoney8140

10、19040供应商编码cbvencodevarchar2010200供应商编码vendor.cvencode41项目大类编码citem_classvarchar1010100fitem.citem_class42项目大类名称citemcnamevarchar2010200fitem.citem_name43项目编码citemcodevarchar2010200fitemss*.citemcode44项目名称cnamevarchar601060050表体自定义项22cdefine22varchar601060051表体自定义项23cdefine23varchar601060052表体自定义项24c

11、define24varchar601060053表体自定义项25cdefine25varchar601060054表体自定义项26cdefine26float81053055表体自定义项27cdefine27float81053056表体自定义项28cdefine28varchar12010120057表体自定义项29cdefine29varchar12010120058表体自定义项30cdefine30varchar12010120059表体自定义项31cdefine31varchar12010120060表体自定义项32cdefine32varchar12010120061表体自定义项33

12、cdefine33varchar12010120062表体自定义项34cdefine34int410010063表体自定义项35cdefine35int410010064表体自定义项36cdefine36datetime813023065表体自定义项37cdefine37datetime813023080跌价准备科目编码cdecheadvarchar1510150code.ccode81跌价余额ileavepricemoney81401905、 发出商品明细账（ia_ensubsidiary）序号字段中文名字段名typelengthisnullablescaledomainprecdefaco

13、lstat检验检验条件是否建立关联表及字段说明1. 1自动编号autoidint40001012. 2单据编号cvoucodevarchar30103003. 3单据日期dvoudatedatetime81302304. 4单据类型cvoutypevarchar21020vouchtype.cvouchtype5. 5业务类型cbustypevarchar810806. 7收发标志brdflagbit100010true-收 false-发7. 8收发类别编码crdcodevarchar51050rd_style.crdcode8. 9仓库编码cwhcodevarchar1010100ware

14、house.cwhcode9. 10仓库所属部门编码cdepcodevarchar1210120department.cdepcode10. 13销售类型编码cstcodevarchar21020saletype.cstcode11. 14部门编码caccdepvarchar1210120department.cdepcode12. 15业务员编码cpersoncodevarchar81080person.cpersoncode13. 16客户编码ccuscodevarchar2010200customer.ccuscode14. 20对应业务单号cbuscodevarchar3010300t

15、ransvouch.ctvcode/assemvouch.id/checkvouch.ccvcode/matchvouch.cvouchcode15. 22发货退货单主表标识cdlcodeint4100100dispatchlist.dlid16. 25发票主表标识cbillcodeint4100100pursettlevouch.pbvid/salebillvouch.sbvid17. 26对应单据主表标识ienidint410010018. 50自定义项1cdefine1varchar201020019. 51自定义项2cdefine2varchar201020020. 52自定义项3cd

16、efine3varchar201020021. 53自定义项4cdefine4datetime813023022. 54自定义项5cdefine5int410010023. 55自定义项6cdefine6datetime813023024. 56自定义项7cdefine7float81053025. 57自定义项8cdefine8varchar4104026. 58自定义项9cdefine9varchar8108027. 59自定义项10cdefine10varchar601060028. 60自定义项11cdefine11varchar12010120029. 61自定义项12cdefine

17、12varchar12010120030. 62自定义项13cdefine13varchar12010120031. 63自定义项14cdefine14varchar12010120032. 64自定义项15cdefine15int410010033. 65自定义项16cdefine16float81053034. 70制单人cmakervarchar2000200ua_user.cuser_name35. 71记账人caccountervarchar2010200ua_user.cuser_name36. 72记账日期dkeepdatedatetime813023037. 73经手人chan

18、dlervarchar2010200person.cpersoncode38. 100存货编码cinvcodevarchar2000200inventory.cinvcode39. 103存货自由项1cfree1varchar201020040. 104存货自由项2cfree2varchar201020041. 105存货自由项3cfree3varchar201020042. 106存货自由项4cfree4varchar201020043. 107存货自由项5cfree5varchar201020044. 108存货自由项6cfree6varchar201020045. 109存货自由项7cf

19、ree7varchar201020046. 110存货自由项8cfree8varchar201020047. 111存货自由项9cfree9varchar201020048. 113存货自由项10cfree10varchar201020049. 114批号cbatchcodevarchar201020050. 115收入数量iainquantityfloat81053051. 116发出数量iaoutquantityfloat81053052. 117收入单价iincostfloat81053053. 118发出单价ioutcostfloat81053054. 119收入金额iainprice

20、money814019055. 120发出金额iaoutpricemoney814019056. 121累计出库数量isoutquantityfloat81053057. 122累计出库金额isoutmoneymoney814019058. 141项目大类编码citem_classvarchar1010100fitem.citem_class59. 142项目大类名称citemcnamevarchar2010200fitem.citem_name60. 143项目编码citemcodevarchar2010200fitemss*.citemcode61. 144项目名称cnamevarchar

21、601060062. 160表体自定义项22cdefine22varchar601060063. 161表体自定义项23cdefine23varchar601060064. 162表体自定义项24cdefine24varchar601060065. 163表体自定义项25cdefine25varchar601060066. 164表体自定义项26cdefine26float81053067. 165表体自定义项27cdefine27float81053068. 166表体自定义项28cdefine28varchar12010120069. 167表体自定义项29cdefine29varchar

22、12010120070. 168表体自定义项30cdefine30varchar12010120071. 169表体自定义项31cdefine31varchar12010120072. 170表体自定义项32cdefine32varchar12010120073. 171表体自定义项33cdefine33varchar12010120074. 172表体自定义项34cdefine34int410010075. 173表体自定义项35cdefine35int410010076. 174表体自定义项36cdefine36datetime813023077. 175表体自定义项37cdefine37

23、datetime813023078. 180发货退货单子表标识inidint4100100dispatchlists.idlsid/autoid79. 181发票子表标识outidint4100100purbillvouchs.id/salebillvouchs.autoid80. 202实发金额自填标志bmoneyflagbit100010true-自填（与rdrecords表中iflag共同控制）81. 203销售取数标志bsalebit10001082. 210会计期间imonthtinyint100030ua_period.iid83. 211凭证类别字cpztypevarchar81

24、080dsign.csign84. 212凭证编号ipzidint410010085. 213凭证日期ipzdatedatetime813023086. 214凭证摘要cpzdigestvarchar601060087. 215凭证线索号cpzidvarchar3010300生成凭证时的线索号88. 218对方科目编码coppheadvarchar1510150code.ccode89. 219发出商品科目编码coutheadvarchar1510150code.ccode90. 220备注cmemovarchar6010600二、原有表变更字段：修改对象名称表中文名子修改对象名称字段中文名变

25、更描述子备注是否原有字段costjustvouch计划价或售价调整单主表cinvcode存货编码由不可为空改为可为空2002.07.08costjustvouchs计划价或售价调整单子表cunitcode部门编码数据长度由varchar(12)改为varchar(20)，由不可为空改为可为空ia_headset存货科目设置表cinvhead存货科目编码由不可为空改为可为空2002.07.23ia_individual个别计价出入库对应表cissale是否销售发票数据类型由bit改为intia_subsidiary存货明细账caccounter记账人由不可为空改为可为空ia_subsidiary

26、存货明细账carvcode采购到货单号数据长度由varchar(10)改为varchar(30)ia_subsidiary存货明细账cbuscode对应业务单号数据长度由varchar(10)改为varchar(30)ia_subsidiary存货明细账chandler经手人数据长度由varchar(10)改为varchar(20)ia_subsidiary存货明细账cmaker制单人由不可为空改为可为空ia_subsidiary存货明细账cordercode采购订单号数据长度由varchar(10)改为varchar(30)ia_subsidiary存货明细账cpztype凭证类别字数据长度

27、由varchar(2)改为varchar(8)ia_subsidiary存货明细账cvencode供应商编码数据长度由varchar(12)改为varchar(20)ia_subsidiary存货明细账cvoucode单据编号数据长度由varchar(10)改为varchar(30)ia_subsidiary存货明细账cvoutype单据类型数据长度由varchar(2)改为varchar(4)2002.08.13ia_subsidiary存货明细账dkeepdate记账日期由不可为空改为可为空2002.06.21ia_valuationass计价辅助数据表civoucode入库单号数据长度由

28、varchar(10)改为varchar(30)ia_valuationass计价辅助数据表covoucode出库单号数据长度由varchar(10)改为varchar(30)justinvouch出入库调整单主表cjvcode出入库调整单主表标识数据长度由varchar(10)改为varchar(30)justinvouch出入库调整单主表cwhcode仓库编码由不可为空改为可为空2002.08.08justinvouchs出入库调整单子表ccorcode被调整单据编号数据长度由varchar(10)改为varchar(30)justinvouchs出入库调整单子表cjvcode出入库调整单

29、主表标识数据长度由varchar(10)改为varchar(30)三、原有表减少字段：无四、原有表新增字段：修改对象名称表中文名子修改对象名称字段中文名costjustvouch计划价或售价调整单主表caccounter记账人costjustvouch计划价或售价调整单主表ccode计划价或售价调整单号costjustvouch计划价或售价调整单主表cmaker制单人costjustvouch计划价或售价调整单主表id计划价或售价调整单主表标识2costjustvouchs计划价或售价调整单子表cbvencode供应商编码costjustvouchs计划价或售价调整单子表cinvcode存货编

30、码costjustvouchs计划价或售价调整单子表icjvacost调整后计划价或售价costjustvouchs计划价或售价调整单子表icjvbcost调整前计划价或售价ia_headset存货科目设置表cendisphead委托代销科目编码ia_headset存货科目设置表cinvcode存货编码ia_headset存货科目设置表couthead分期发出科目编码ia_subsidiary存货明细账cdefine11-16ia_subsidiary存货明细账cdefine28-37ia_subsidiary存货明细账cfree3-10ia_subsidiary存货明细账nojustquan

31、tity未调整数量ia_subsidiary存货明细账psvsid采购结算单子表标识ia_summary存货总账idirect是否直运业务ia_valuationass计价辅助数据表cflag多次结算用标志ia_valuationass计价辅助数据表ijsdid采购结算单子表标识justinvouch出入库调整单主表bsale销售取数标志justinvouch出入库调整单主表cauto是否自动生成justinvouch出入库调整单主表cdefine11-16justinvouch出入库调整单主表id自动编号justinvouch出入库调整单主表ufts时间戳justinvouch出入库调整单主

32、表vt_id单据模版号justinvouchs出入库调整单子表cbvencode供应商编码justinvouchs出入库调整单子表cdefine28-37justinvouchs出入库调整单子表cfree3-10justinvouchs出入库调整单子表cinvouchcode对应入库单号justinvouchs出入库调整单子表dmadedate生产日期justinvouchs出入库调整单子表imassdate保质期天数五、功能互斥：1、 取消选项独占控制2、 取消期初记账独占控制3、 取消采购结算和存货单据记账的互斥，通过单据加锁方式实现模块互斥类型功能编号功能名称互斥功能模块互斥功能编号互斥

33、功能名称非互斥功能模块非互斥功能编号非互斥功能名称互斥模块0pu040306iaia2002结算成本处理ap0ap0403现结制单iaia3020存货现结制单ap0ap0403现结制单iaia3020存货现结制单as4as026凭证类别编辑iaca0ca04成本计算iaia2001产成品成本分配gl0gl0208记帐iaia3020存货现结制单gl0gl0208记帐iaiascpz生成凭证gl0gl0208记帐iaiascpz生成凭证gl4gl010802选项设置iagl4gl1512结账iaia0asm3102期初记帐iaasm310102期初余额录入ia0asm3102期初记帐iaasm3

34、10103期初余额取数ia0asm3102期初记帐iaasm3102期初记帐ia0asm3102期初记帐iaia000102期初差异录入ia0asm3102期初记帐iaia001002期初分期收款发出商品录入ia0asm3102期初记帐iaia001003期初分期收款发出商品取数ia0asm3102期初记帐iaia001102期初委托代销发出商品录入ia0asm3102期初记帐iaia001103期初委托代销发出商品取数ia0ia000002选项录入iaasm3102期初记帐ia0ia000002选项录入iaia000002选项录入ia0ia000002选项录入iaia0015入库调整单记帐i

35、a0ia000002选项录入iaia0017出库调整单记帐ia0ia000002选项录入iaia0019价格调整单记帐ia0ia000002选项录入iaia2001产成品成本分配ia0ia000002选项录入iaia2002结算成本处理ia0ia000002选项录入iaia2004单据记帐ia0ia000002选项录入iaia2005恢复记帐ia0ia000002选项录入iaia2006期末处理ia0ia000002选项录入iaia2007月末结帐ia0ia0015入库调整单记帐iaia0015入库调整单记帐ia0ia0015入库调整单记帐iaia0017出库调整单记帐ia0ia0015入库调整单记帐iaia0019价格调整单记帐ia0ia0015入库调整单记帐iaia2002结算成本处理ia0ia0015入库调整单记帐ia