用友存貨核算850數(shù)據(jù)庫變動說明.doc

此文檔收集于網(wǎng)絡(luò)，如有侵權(quán)，請聯(lián)系網(wǎng)站刪除存貨核算850數(shù)據(jù)庫變動說明一、新增表：數(shù)據(jù)庫模塊修改對象名稱表中文名主備注UFData存貨核算IA_MemoSet存貨制單摘要內(nèi)容設(shè)置表制單摘要內(nèi)容設(shè)置UFData存貨核算IA_DecReadyHead跌價(jià)準(zhǔn)備科目設(shè)置表UFData存貨核算IA_DecReady跌價(jià)準(zhǔn)備單主表UFData存貨核算IA_DecReadys跌價(jià)準(zhǔn)備單子表2002.10.21UFData存貨核算IA_EnSubsidiary發(fā)出商品明細(xì)賬發(fā)出商品貨明細(xì)賬1、 存貨制單摘要內(nèi)容設(shè)置表（IA_MemoSet）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗(yàn)檢驗(yàn)條件是否建立關(guān)聯(lián)表及字段1自動編號AutoIDint40001012單據(jù)類型編碼cVouchTypevarchar20020VouchType.cVouchType3字段名稱cFieldNamevarchar20102004字段順序號cFieldOrderint41001005字段中文說明cFieldDescvarchar50105002、 跌價(jià)準(zhǔn)備科目設(shè)置表（IA_DecReadyHead）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗(yàn)檢驗(yàn)條件是否建立關(guān)聯(lián)表及字段1自動編號AutoIDint40001012存貨編碼cInvCodevarchar2010200存貨編碼Inventory.cInvCode3存貨大類編碼cInvCCodevarchar1210120存貨大類編碼InventoryClass.cInvCCode4跌價(jià)準(zhǔn)備科目編碼cDecHeadvarchar1510150code.ccode5費(fèi)用科目編碼cFyHeadvarchar1510150code.ccode6可變現(xiàn)價(jià)格iActualPricemoney81401903、 跌價(jià)準(zhǔn)備單主表（IA_DecReady）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗(yàn)檢驗(yàn)條件是否建立關(guān)聯(lián)表及字段1跌價(jià)準(zhǔn)備單主表標(biāo)識IDint4000100主表關(guān)聯(lián)項(xiàng)2跌價(jià)準(zhǔn)備單號cDecCodevarchar3000300主表關(guān)聯(lián)項(xiàng)3單據(jù)類型編碼cVouchTypevarchar20020VouchType.cVouchType4單據(jù)日期dDatedatetime80302305部門編碼cDepCodevarchar1210120部門編碼Department.cDepCode6自定義項(xiàng)1cDefine1varchar20102007自定義項(xiàng)2cDefine2varchar20102008自定義項(xiàng)3cDefine3varchar20102009自定義項(xiàng)4cDefine4datetime813023010自定義項(xiàng)5cDefine5int410010011自定義項(xiàng)6cDefine6datetime813023012自定義項(xiàng)7cDefine7float81053013自定義項(xiàng)8cDefine8varchar4104014自定義項(xiàng)9cDefine9varchar8108015自定義項(xiàng)10cDefine10varchar601060016自定義項(xiàng)11cDefine11varchar12010120017自定義項(xiàng)12cDefine12varchar12010120018自定義項(xiàng)13cDefine13varchar12010120019自定義項(xiàng)14cDefine14varchar12010120020自定義項(xiàng)15cDefine15int410010021自定義項(xiàng)16cDefine16float81053022時(shí)間戳uftstimestamp8008023單據(jù)模版號VT_IDint4100100VoucherTemplates.VT_ID24制單人cMakervarchar8108025審核人cVeriPersonvarchar8108026審核日期dVeriDatedatetime813023027業(yè)務(wù)員編碼cPersonCodevarchar81080職員編碼Person.cPersonCode28憑證類別字cPZtypevarchar81080Dsign.csign29憑證編號iPZIDint410010030憑證日期iPZDatedatetime813023031憑證摘要cPZdigestvarchar601060032憑證線索號cpzidvarchar30103004、 跌價(jià)準(zhǔn)備單子表（IA_DecReadys）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗(yàn)檢驗(yàn)條件是否建立關(guān)聯(lián)表及字段1跌價(jià)準(zhǔn)備單子表標(biāo)識AutoIDint4000101子表關(guān)聯(lián)項(xiàng)2跌價(jià)準(zhǔn)備單主表標(biāo)識IDvarchar2000200與主表關(guān)聯(lián)：IA_DecReady.ID3倉庫編碼cWhCodevarchar1210120倉庫編碼Warehouse.cWhCode4存貨編碼cInvCodevarchar2010200存貨編碼Inventory.cInvCode10存貨自由項(xiàng)1cFree1varchar201020011存貨自由項(xiàng)2cFree2varchar201020012存貨自由項(xiàng)3cFree3varchar201020013存貨自由項(xiàng)4cFree4varchar201020014存貨自由項(xiàng)5cFree5varchar201020015存貨自由項(xiàng)6cFree6varchar201020016存貨自由項(xiàng)7cFree7varchar201020017存貨自由項(xiàng)8cFree8varchar201020018存貨自由項(xiàng)9cFree9varchar201020019存貨自由項(xiàng)10cFree10varchar201020020結(jié)存數(shù)量iQuantityfloat81053021結(jié)存單價(jià)iCostfloat81053022結(jié)存金額iPricemoney814019023可變現(xiàn)價(jià)格iActualCostfloat81053024可變現(xiàn)金額iActualPricemoney814019025應(yīng)計(jì)提金額iNDecPricemoney814019026已計(jì)提金額iADecPricemoney814019027本次計(jì)提金額iThisPricemoney814019028本次回沖金額iThisRePricemoney814019040供應(yīng)商編碼cBVencodevarchar2010200供應(yīng)商編碼Vendor.cVenCode41項(xiàng)目大類編碼cItem_classvarchar1010100fitem.citem_class42項(xiàng)目大類名稱cItemCNamevarchar2010200fitem.citem_name43項(xiàng)目編碼cItemCodevarchar2010200fitemss*.citemcode44項(xiàng)目名稱cNamevarchar601060050表體自定義項(xiàng)22cDefine22varchar601060051表體自定義項(xiàng)23cDefine23varchar601060052表體自定義項(xiàng)24cDefine24varchar601060053表體自定義項(xiàng)25cDefine25varchar601060054表體自定義項(xiàng)26cDefine26float81053055表體自定義項(xiàng)27cDefine27float81053056表體自定義項(xiàng)28cDefine28varchar12010120057表體自定義項(xiàng)29cDefine29varchar12010120058表體自定義項(xiàng)30cDefine30varchar12010120059表體自定義項(xiàng)31cDefine31varchar12010120060表體自定義項(xiàng)32cDefine32varchar12010120061表體自定義項(xiàng)33cDefine33varchar12010120062表體自定義項(xiàng)34cDefine34int410010063表體自定義項(xiàng)35cDefine35int410010064表體自定義項(xiàng)36cDefine36datetime813023065表體自定義項(xiàng)37cDefine37datetime813023080跌價(jià)準(zhǔn)備科目編碼cDecHeadvarchar1510150code.ccode81跌價(jià)余額iLeavePricemoney81401905、 發(fā)出商品明細(xì)賬（IA_EnSubsidiary）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗(yàn)檢驗(yàn)條件是否建立關(guān)聯(lián)表及字段說明1. 1自動編號AutoIDint40001012. 2單據(jù)編號cVouCodevarchar30103003. 3單據(jù)日期dVouDatedatetime81302304. 4單據(jù)類型cVouTypevarchar21020VouchType.cVouchType5. 5業(yè)務(wù)類型cBusTypevarchar810806. 7收發(fā)標(biāo)志bRdFlagbit100010TRUE-收 FALSE-發(fā)7. 8收發(fā)類別編碼cRdCodevarchar51050Rd_Style.cRdCode8. 9倉庫編碼cWhCodevarchar1010100Warehouse.cWhCode9. 10倉庫所屬部門編碼cDepCodevarchar1210120Department.cDepCode10. 13銷售類型編碼cSTCodevarchar21020SaleType.cSTCode11. 14部門編碼cAccDepvarchar1210120Department.cDepCode12. 15業(yè)務(wù)員編碼cPersonCodevarchar81080Person.cPersonCode13. 16客戶編碼cCusCodevarchar2010200Customer.cCusCode14. 20對應(yīng)業(yè)務(wù)單號cBusCodevarchar3010300TransVouch.cTVCode/AssemVouch.ID/CheckVouch.cCVCode/MatchVouch.cVouchCode15. 22發(fā)貨退貨單主表標(biāo)識cDLCodeint4100100DispatchList.DLID16. 25發(fā)票主表標(biāo)識cBillCodeint4100100PurSettleVouch.PBVID/SaleBillVouch.SBVID17. 26對應(yīng)單據(jù)主表標(biāo)識iEnIDint410010018. 50自定義項(xiàng)1cDefine1varchar201020019. 51自定義項(xiàng)2cDefine2varchar201020020. 52自定義項(xiàng)3cDefine3varchar201020021. 53自定義項(xiàng)4cDefine4datetime813023022. 54自定義項(xiàng)5cDefine5int410010023. 55自定義項(xiàng)6cDefine6datetime813023024. 56自定義項(xiàng)7cDefine7float81053025. 57自定義項(xiàng)8cDefine8varchar4104026. 58自定義項(xiàng)9cDefine9varchar8108027. 59自定義項(xiàng)10cDefine10varchar601060028. 60自定義項(xiàng)11cDefine11varchar12010120029. 61自定義項(xiàng)12cDefine12varchar12010120030. 62自定義項(xiàng)13cDefine13varchar12010120031. 63自定義項(xiàng)14cDefine14varchar12010120032. 64自定義項(xiàng)15cDefine15int410010033. 65自定義項(xiàng)16cDefine16float81053034. 70制單人cMakervarchar2000200UA_User.cUser_Name35. 71記賬人cAccountervarchar2010200UA_User.cUser_Name36. 72記賬日期dKeepDatedatetime813023037. 73經(jīng)手人cHandlervarchar2010200Person.cPersonCode38. 100存貨編碼cInvCodevarchar2000200Inventory.cInvCode39. 103存貨自由項(xiàng)1cFree1varchar201020040. 104存貨自由項(xiàng)2cFree2varchar201020041. 105存貨自由項(xiàng)3cFree3varchar201020042. 106存貨自由項(xiàng)4cFree4varchar201020043. 107存貨自由項(xiàng)5cFree5varchar201020044. 108存貨自由項(xiàng)6cFree6varchar201020045. 109存貨自由項(xiàng)7cFree7varchar201020046. 110存貨自由項(xiàng)8cFree8varchar201020047. 111存貨自由項(xiàng)9cFree9varchar201020048. 113存貨自由項(xiàng)10cFree10varchar201020049. 114批號cBatchCodevarchar201020050. 115收入數(shù)量iAInQuantityfloat81053051. 116發(fā)出數(shù)量iAOutQuantityfloat81053052. 117收入單價(jià)iInCostfloat81053053. 118發(fā)出單價(jià)iOutCostfloat81053054. 119收入金額iAInPricemoney814019055. 120發(fā)出金額iAOutPricemoney814019056. 121累計(jì)出庫數(shù)量isoutquantityfloat81053057. 122累計(jì)出庫金額isoutmoneymoney814019058. 141項(xiàng)目大類編碼cItem_classvarchar1010100fitem.citem_class59. 142項(xiàng)目大類名稱cItemCNamevarchar2010200fitem.citem_name60. 143項(xiàng)目編碼cItemCodevarchar2010200fitemss*.citemcode61. 144項(xiàng)目名稱cNamevarchar601060062. 160表體自定義項(xiàng)22cDefine22varchar601060063. 161表體自定義項(xiàng)23cDefine23varchar601060064. 162表體自定義項(xiàng)24cDefine24varchar601060065. 163表體自定義項(xiàng)25cDefine25varchar601060066. 164表體自定義項(xiàng)26cDefine26float81053067. 165表體自定義項(xiàng)27cDefine27float81053068. 166表體自定義項(xiàng)28cDefine28varchar12010120069. 167表體自定義項(xiàng)29cDefine29varchar12010120070. 168表體自定義項(xiàng)30cDefine30varchar12010120071. 169表體自定義項(xiàng)31cDefine31varchar12010120072. 170表體自定義項(xiàng)32cDefine32varchar12010120073. 171表體自定義項(xiàng)33cDefine33varchar12010120074. 172表體自定義項(xiàng)34cDefine34int410010075. 173表體自定義項(xiàng)35cDefine35int410010076. 174表體自定義項(xiàng)36cDefine36datetime813023077. 175表體自定義項(xiàng)37cDefine37datetime813023078. 180發(fā)貨退貨單子表標(biāo)識InIDint4100100DispatchLists.iDLsID/AutoID79. 181發(fā)票子表標(biāo)識OutIDint4100100PurBillVouchs.ID/SaleBillVouchs.AutoID80. 202實(shí)發(fā)金額自填標(biāo)志bMoneyFlagbit100010TRUE-自填（與RdRecords表中iFlag共同控制）81. 203銷售取數(shù)標(biāo)志bSalebit10001082. 210會計(jì)期間iMonthtinyint100030UA_Period.iId83. 211憑證類別字cPZtypevarchar81080Dsign.csign84. 212憑證編號iPZIDint410010085. 213憑證日期iPZDatedatetime813023086. 214憑證摘要cPZdigestvarchar601060087. 215憑證線索號cPZIDvarchar3010300生成憑證時(shí)的線索號88. 218對方科目編碼cOppHeadvarchar1510150code.ccode89. 219發(fā)出商品科目編碼cOutHeadvarchar1510150code.ccode90. 220備注cMemovarchar6010600二、原有表變更字段：修改對象名稱表中文名子修改對象名稱字段中文名變更描述子備注是否原有字段CostJustVouch計(jì)劃價(jià)或售價(jià)調(diào)整單主表cInvCode存貨編碼由不可為空改為可為空2002.07.08CostJustVouchs計(jì)劃價(jià)或售價(jià)調(diào)整單子表cUnitCode部門編碼數(shù)據(jù)長度由varchar(12)改為varchar(20)，由不可為空改為可為空IA_HeadSet存貨科目設(shè)置表cInvHead存貨科目編碼由不可為空改為可為空2002.07.23IA_Individual個(gè)別計(jì)價(jià)出入庫對應(yīng)表cIsSale是否銷售發(fā)票數(shù)據(jù)類型由bit改為intIA_Subsidiary存貨明細(xì)賬cAccounter記賬人由不可為空改為可為空IA_Subsidiary存貨明細(xì)賬cARVCode采購到貨單號數(shù)據(jù)長度由varchar(10)改為varchar(30)IA_Subsidiary存貨明細(xì)賬cBusCode對應(yīng)業(yè)務(wù)單號數(shù)據(jù)長度由varchar(10)改為varchar(30)IA_Subsidiary存貨明細(xì)賬cHandler經(jīng)手人數(shù)據(jù)長度由varchar(10)改為varchar(20)IA_Subsidiary存貨明細(xì)賬cMaker制單人由不可為空改為可為空IA_Subsidiary存貨明細(xì)賬cOrderCode采購訂單號數(shù)據(jù)長度由varchar(10)改為varchar(30)IA_Subsidiary存貨明細(xì)賬cPZtype憑證類別字?jǐn)?shù)據(jù)長度由varchar(2)改為varchar(8)IA_Subsidiary存貨明細(xì)賬CVenCode供應(yīng)商編碼數(shù)據(jù)長度由varchar(12)改為varchar(20)IA_Subsidiary存貨明細(xì)賬cVouCode單據(jù)編號數(shù)據(jù)長度由varchar(10)改為varchar(30)IA_Subsidiary存貨明細(xì)賬cVouType單據(jù)類型數(shù)據(jù)長度由varchar(2)改為varchar(4)2002.08.13IA_Subsidiary存貨明細(xì)賬dKeepDate記賬日期由不可為空改為可為空2002.06.21IA_ValuationAss計(jì)價(jià)輔助數(shù)據(jù)表cIVouCode入庫單號數(shù)據(jù)長度由varchar(10)改為varchar(30)IA_ValuationAss計(jì)價(jià)輔助數(shù)據(jù)表cOVouCode出庫單號數(shù)據(jù)長度由varchar(10)改為varchar(30)JustInVouch出入庫調(diào)整單主表cJVCode出入庫調(diào)整單主表標(biāo)識數(shù)據(jù)長度由varchar(10)改為varchar(30)JustInVouch出入庫調(diào)整單主表cWhCode倉庫編碼由不可為空改為可為空2002.08.08JustInVouchs出入庫調(diào)整單子表cCorCode被調(diào)整單據(jù)編號數(shù)據(jù)長度由varchar(10)改為varchar(30)JustInVouchs出入庫調(diào)整單子表cJVCode出入庫調(diào)整單主表標(biāo)識數(shù)據(jù)長度由varchar(10)改為varchar(30)三、原有表減少字段：無四、原有表新增字段：修改對象名稱表中文名子修改對象名稱字段中文名CostJustVouch計(jì)劃價(jià)或售價(jià)調(diào)整單主表cAccounter記賬人CostJustVouch計(jì)劃價(jià)或售價(jià)調(diào)整單主表cCode計(jì)劃價(jià)或售價(jià)調(diào)整單號CostJustVouch計(jì)劃價(jià)或售價(jià)調(diào)整單主表cMaker制單人CostJustVouch計(jì)劃價(jià)或售價(jià)調(diào)整單主表ID計(jì)劃價(jià)或售價(jià)調(diào)整單主表標(biāo)識2CostJustVouchs計(jì)劃價(jià)或售價(jià)調(diào)整單子表cBVenCode供應(yīng)商編碼CostJustVouchs計(jì)劃價(jià)或售價(jià)調(diào)整單子表cInvCode存貨編碼CostJustVouchs計(jì)劃價(jià)或售價(jià)調(diào)整單子表iCJVACost調(diào)整后計(jì)劃價(jià)或售價(jià)CostJustVouchs計(jì)劃價(jià)或售價(jià)調(diào)整單子表iCJVBCost調(diào)整前計(jì)劃價(jià)或售價(jià)IA_HeadSet存貨科目設(shè)置表cEnDispHead委托代銷科目編碼IA_HeadSet存貨科目設(shè)置表cInvCode存貨編碼IA_HeadSet存貨科目設(shè)置表cOutHead分期發(fā)出科目編碼IA_Subsidiary存貨明細(xì)賬cDefine11-16IA_Subsidiary存貨明細(xì)賬cDefine28-37IA_Subsidiary存貨明細(xì)賬cFree3-10IA_Subsidiary存貨明細(xì)賬noJustQuantity未調(diào)整數(shù)量IA_Subsidiary存貨明細(xì)賬psvsid采購結(jié)算單子表標(biāo)識IA_Summary存貨總賬iDirect是否直運(yùn)業(yè)務(wù)IA_ValuationAss計(jì)價(jià)輔助數(shù)據(jù)表cflag多次結(jié)算用標(biāo)志IA_ValuationAss計(jì)價(jià)輔助數(shù)據(jù)表iJSDID采購結(jié)算單子表標(biāo)識JustInVouch出入庫調(diào)整單主表bsale銷售取數(shù)標(biāo)志JustInVouch出入庫調(diào)整單主表cAuto是否自動生成JustInVouch出入庫調(diào)整單主表cDefine11-16JustInVouch出入庫調(diào)整單主表id自動編號JustInVouch出入庫調(diào)整單主表ufts時(shí)間戳JustInVouch出入庫調(diào)整單主表VT_ID單據(jù)模版號JustInVouchs出入庫調(diào)整單子表cBVencode供應(yīng)商編碼JustInVouchs出入庫調(diào)整單子表cDefine28-37JustInVouchs出入庫調(diào)整單子表cFree3-10JustInVouchs出入庫調(diào)整單子表cInVouchCode對應(yīng)入庫單號JustInVouchs出入庫調(diào)整單子表dMadeDate生產(chǎn)日期JustInVouchs出入庫調(diào)整單子表iMassDate保質(zhì)期天數(shù)五、功能互斥：1、 取消選項(xiàng)獨(dú)占控制2、 取消期初記賬獨(dú)占控制3、 取消采購結(jié)算和存貨單據(jù)記賬的互斥，通過單據(jù)加鎖方式實(shí)現(xiàn)模塊互斥類型功能編號功能名稱互斥功能模塊互斥功能編號互斥功能名稱非互斥功能模塊非互斥功能編號非互斥功能名稱互斥模塊0PU040306IAIA2002結(jié)算成本處理AP0AP0403現(xiàn)結(jié)制單IAIA3020存貨現(xiàn)結(jié)制單AP0AP0403現(xiàn)結(jié)制單IAIA3020存貨現(xiàn)結(jié)制單AS4AS026憑證類別編輯IACA0CA04成本計(jì)算IAIA2001產(chǎn)成品成本分配GL0GL0208記帳IAIA3020存貨現(xiàn)結(jié)制單GL0GL0208記帳IAIASCPZ生成憑證GL0GL0208記帳IAIASCPZ生成憑證GL4GL010802選項(xiàng)設(shè)置IAGL4GL1512結(jié)賬IAIA0ASM3102期初記帳IAASM310102期初余額錄入IA0ASM3102期初記帳IAASM310103期初余額取數(shù)IA0ASM3102期初記帳IAASM3102期初記帳IA0ASM3102期初記帳IAIA000102期初差異錄入IA0ASM3102期初記帳IAIA001002期初分期收款發(fā)出商品錄入IA0ASM3102期初記帳IAIA001003期初分期收款發(fā)出商品取數(shù)IA0ASM3102期初記帳IAIA001102期初委托代銷發(fā)出商品錄入IA0ASM3102期初記帳IAIA001103期初委托代銷發(fā)出商品取數(shù)IA0IA000002選項(xiàng)錄入IAASM3102期初記帳IA0IA000002選項(xiàng)錄入IAIA000002選項(xiàng)錄入IA0IA000002選項(xiàng)錄入IAIA0015入庫調(diào)整單記帳IA0IA000002選項(xiàng)錄入IAIA0017出庫調(diào)整單記帳IA0IA000002選項(xiàng)錄入IAIA0019價(jià)格調(diào)整單記帳IA0IA000002選項(xiàng)錄入IAIA2001產(chǎn)成品成本分配IA0IA000002選項(xiàng)錄入IAIA2002結(jié)算成本處理IA0IA000002選項(xiàng)錄入IAIA2004單據(jù)記帳IA0IA000002選項(xiàng)錄入IAIA2005恢復(fù)記帳IA0IA000002選項(xiàng)錄入IAIA2006期末處理IA0IA000002選項(xiàng)錄入IAIA2007月末結(jié)帳IA0IA0015入庫調(diào)整單記帳IAIA0015入庫調(diào)整單記帳IA0IA0015入庫調(diào)整單記帳IAIA0017出庫調(diào)整單記帳IA0IA0015入庫調(diào)整單記帳IAIA0019價(jià)格調(diào)整單記帳IA0IA0015入庫調(diào)整單記帳IAIA2002結(jié)算成本處理IA0IA0015入庫調(diào)整單記帳IAIA