用友存貨核算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跌價準(zhǔn)備科目設(shè)置表UFData存貨核算IA_DecReady跌價準(zhǔn)備單主表UFData存貨核算IA_DecReadys跌價準(zhǔn)備單子表2002.10.21UFData存貨核算IA_EnSubsidiary發(fā)出商品明細(xì)賬發(fā)出商品貨明細(xì)賬1、 存貨制單摘要內(nèi)容設(shè)置表（IA_MemoSet）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗檢驗條件是否建立關(guān)聯(lián)表及字段1自動編號AutoIDint40001012單據(jù)類型編碼cVouchTypevarchar20020VouchType.cVouchType3字段名稱cFieldNamevarchar20102004字段順序號cFieldOrderint41001005字段中文說明cFieldDescvarchar50105002、 跌價準(zhǔn)備科目設(shè)置表（IA_DecReadyHead）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗檢驗條件是否建立關(guān)聯(lián)表及字段1自動編號AutoIDint40001012存貨編碼cInvCodevarchar2010200存貨編碼Inventory.cInvCode3存貨大類編碼cInvCCodevarchar1210120存貨大類編碼InventoryClass.cInvCCode4跌價準(zhǔn)備科目編碼cDecHeadvarchar1510150code.ccode5費用科目編碼cFyHeadvarchar1510150code.ccode6可變現(xiàn)價格iActualPricemoney81401903、 跌價準(zhǔn)備單主表（IA_DecReady）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗檢驗條件是否建立關(guān)聯(lián)表及字段1跌價準(zhǔn)備單主表標(biāo)識IDint4000100主表關(guān)聯(lián)項2跌價準(zhǔn)備單號cDecCodevarchar3000300主表關(guān)聯(lián)項3單據(jù)類型編碼cVouchTypevarchar20020VouchType.cVouchType4單據(jù)日期dDatedatetime80302305部門編碼cDepCodevarchar1210120部門編碼Department.cDepCode6自定義項1cDefine1varchar20102007自定義項2cDefine2varchar20102008自定義項3cDefine3varchar20102009自定義項4cDefine4datetime813023010自定義項5cDefine5int410010011自定義項6cDefine6datetime813023012自定義項7cDefine7float81053013自定義項8cDefine8varchar4104014自定義項9cDefine9varchar8108015自定義項10cDefine10varchar601060016自定義項11cDefine11varchar12010120017自定義項12cDefine12varchar12010120018自定義項13cDefine13varchar12010120019自定義項14cDefine14varchar12010120020自定義項15cDefine15int410010021自定義項16cDefine16float81053022時間戳uftstimestamp8008023單據(jù)模版號VT_IDint4100100VoucherTemplates.VT_ID24制單人cMakervarchar8108025審核人cVeriPersonvarchar8108026審核日期dVeriDatedatetime813023027業(yè)務(wù)員編碼cPersonCodevarchar81080職員編碼Person.cPersonCode28憑證類別字cPZtypevarchar81080Dsign.csign29憑證編號iPZIDint410010030憑證日期iPZDatedatetime813023031憑證摘要cPZdigestvarchar601060032憑證線索號cpzidvarchar30103004、 跌價準(zhǔn)備單子表（IA_DecReadys）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗檢驗條件是否建立關(guān)聯(lián)表及字段1跌價準(zhǔn)備單子表標(biāo)識AutoIDint4000101子表關(guān)聯(lián)項2跌價準(zhǔn)備單主表標(biāo)識IDvarchar2000200與主表關(guān)聯(lián)：IA_DecReady.ID3倉庫編碼cWhCodevarchar1210120倉庫編碼Warehouse.cWhCode4存貨編碼cInvCodevarchar2010200存貨編碼Inventory.cInvCode10存貨自由項1cFree1varchar201020011存貨自由項2cFree2varchar201020012存貨自由項3cFree3varchar201020013存貨自由項4cFree4varchar201020014存貨自由項5cFree5varchar201020015存貨自由項6cFree6varchar201020016存貨自由項7cFree7varchar201020017存貨自由項8cFree8varchar201020018存貨自由項9cFree9varchar201020019存貨自由項10cFree10varchar201020020結(jié)存數(shù)量iQuantityfloat81053021結(jié)存單價iCostfloat81053022結(jié)存金額iPricemoney814019023可變現(xiàn)價格iActualCostfloat81053024可變現(xiàn)金額iActualPricemoney814019025應(yīng)計提金額iNDecPricemoney814019026已計提金額iADecPricemoney814019027本次計提金額iThisPricemoney814019028本次回沖金額iThisRePricemoney814019040供應(yīng)商編碼cBVencodevarchar2010200供應(yīng)商編碼Vendor.cVenCode41項目大類編碼cItem_classvarchar1010100fitem.citem_class42項目大類名稱cItemCNamevarchar2010200fitem.citem_name43項目編碼cItemCodevarchar2010200fitemss*.citemcode44項目名稱cNamevarchar601060050表體自定義項22cDefine22varchar601060051表體自定義項23cDefine23varchar601060052表體自定義項24cDefine24varchar601060053表體自定義項25cDefine25varchar601060054表體自定義項26cDefine26float81053055表體自定義項27cDefine27float81053056表體自定義項28cDefine28varchar12010120057表體自定義項29cDefine29varchar12010120058表體自定義項30cDefine30varchar12010120059表體自定義項31cDefine31varchar12010120060表體自定義項32cDefine32varchar12010120061表體自定義項33cDefine33varchar12010120062表體自定義項34cDefine34int410010063表體自定義項35cDefine35int410010064表體自定義項36cDefine36datetime813023065表體自定義項37cDefine37datetime813023080跌價準(zhǔn)備科目編碼cDecHeadvarchar1510150code.ccode81跌價余額iLeavePricemoney81401905、 發(fā)出商品明細(xì)賬（IA_EnSubsidiary）序號字段中文名字段名typelengthisnullablescaledomainprecDefacolstat檢驗檢驗條件是否建立關(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自定義項1cDefine1varchar201020019. 51自定義項2cDefine2varchar201020020. 52自定義項3cDefine3varchar201020021. 53自定義項4cDefine4datetime813023022. 54自定義項5cDefine5int410010023. 55自定義項6cDefine6datetime813023024. 56自定義項7cDefine7float81053025. 57自定義項8cDefine8varchar4104026. 58自定義項9cDefine9varchar8108027. 59自定義項10cDefine10varchar601060028. 60自定義項11cDefine11varchar12010120029. 61自定義項12cDefine12varchar12010120030. 62自定義項13cDefine13varchar12010120031. 63自定義項14cDefine14varchar12010120032. 64自定義項15cDefine15int410010033. 65自定義項16cDefine16float81053034. 70制單人cMakervarchar2000200UA_User.cUser_Name35. 71記賬人cAccountervarchar2010200UA_User.cUser_Name36. 72記賬日期dKeepDatedatetime813023037. 73經(jīng)手人cHandlervarchar2010200Person.cPersonCode38. 100存貨編碼cInvCodevarchar2000200Inventory.cInvCode39. 103存貨自由項1cFree1varchar201020040. 104存貨自由項2cFree2varchar201020041. 105存貨自由項3cFree3varchar201020042. 106存貨自由項4cFree4varchar201020043. 107存貨自由項5cFree5varchar201020044. 108存貨自由項6cFree6varchar201020045. 109存貨自由項7cFree7varchar201020046. 110存貨自由項8cFree8varchar201020047. 111存貨自由項9cFree9varchar201020048. 113存貨自由項10cFree10varchar201020049. 114批號cBatchCodevarchar201020050. 115收入數(shù)量iAInQuantityfloat81053051. 116發(fā)出數(shù)量iAOutQuantityfloat81053052. 117收入單價iInCostfloat81053053. 118發(fā)出單價iOutCostfloat81053054. 119收入金額iAInPricemoney814019055. 120發(fā)出金額iAOutPricemoney814019056. 121累計出庫數(shù)量isoutquantityfloat81053057. 122累計出庫金額isoutmoneymoney814019058. 141項目大類編碼cItem_classvarchar1010100fitem.citem_class59. 142項目大類名稱cItemCNamevarchar2010200fitem.citem_name60. 143項目編碼cItemCodevarchar2010200fitemss*.citemcode61. 144項目名稱cNamevarchar601060062. 160表體自定義項22cDefine22varchar601060063. 161表體自定義項23cDefine23varchar601060064. 162表體自定義項24cDefine24varchar601060065. 163表體自定義項25cDefine25varchar601060066. 164表體自定義項26cDefine26float81053067. 165表體自定義項27cDefine27float81053068. 166表體自定義項28cDefine28varchar12010120069. 167表體自定義項29cDefine29varchar12010120070. 168表體自定義項30cDefine30varchar12010120071. 169表體自定義項31cDefine31varchar12010120072. 170表體自定義項32cDefine32varchar12010120073. 171表體自定義項33cDefine33varchar12010120074. 172表體自定義項34cDefine34int410010075. 173表體自定義項35cDefine35int410010076. 174表體自定義項36cDefine36datetime813023077. 175表體自定義項37cDefine37datetime813023078. 180發(fā)貨退貨單子表標(biāo)識InIDint4100100DispatchLists.iDLsID/AutoID79. 181發(fā)票子表標(biāo)識OutIDint4100100PurBillVouchs.ID/SaleBillVouchs.AutoID80. 202實發(fā)金額自填標(biāo)志bMoneyFlagbit100010TRUE-自填（與RdRecords表中iFlag共同控制）81. 203銷售取數(shù)標(biāo)志bSalebit10001082. 210會計期間iMonthtinyint100030UA_Period.iId83. 211憑證類別字cPZtypevarchar81080Dsign.csign84. 212憑證編號iPZIDint410010085. 213憑證日期iPZDatedatetime813023086. 214憑證摘要cPZdigestvarchar601060087. 215憑證線索號cPZIDvarchar3010300生成憑證時的線索號88. 218對方科目編碼cOppHeadvarchar1510150code.ccode89. 219發(fā)出商品科目編碼cOutHeadvarchar1510150code.ccode90. 220備注cMemovarchar6010600二、原有表變更字段：修改對象名稱表中文名子修改對象名稱字段中文名變更描述子備注是否原有字段CostJustVouch計劃價或售價調(diào)整單主表cInvCode存貨編碼由不可為空改為可為空2002.07.08CostJustVouchs計劃價或售價調(diào)整單子表cUnitCode部門編碼數(shù)據(jù)長度由varchar(12)改為varchar(20)，由不可為空改為可為空IA_HeadSet存貨科目設(shè)置表cInvHead存貨科目編碼由不可為空改為可為空2002.07.23IA_Individual個別計價出入庫對應(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計價輔助數(shù)據(jù)表cIVouCode入庫單號數(shù)據(jù)長度由varchar(10)改為varchar(30)IA_ValuationAss計價輔助數(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計劃價或售價調(diào)整單主表cAccounter記賬人CostJustVouch計劃價或售價調(diào)整單主表cCode計劃價或售價調(diào)整單號CostJustVouch計劃價或售價調(diào)整單主表cMaker制單人CostJustVouch計劃價或售價調(diào)整單主表ID計劃價或售價調(diào)整單主表標(biāo)識2CostJustVouchs計劃價或售價調(diào)整單子表cBVenCode供應(yīng)商編碼CostJustVouchs計劃價或售價調(diào)整單子表cInvCode存貨編碼CostJustVouchs計劃價或售價調(diào)整單子表iCJVACost調(diào)整后計劃價或售價CostJustVouchs計劃價或售價調(diào)整單子表iCJVBCost調(diào)整前計劃價或售價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è)務(wù)IA_ValuationAss計價輔助數(shù)據(jù)表cflag多次結(jié)算用標(biāo)志IA_ValuationAss計價輔助數(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時間戳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、 取消選項獨占控制2、 取消期初記賬獨占控制3、 取消采購結(jié)算和存貨單據(jù)記賬的互斥，通過單據(jù)加鎖方式實現(xiàn)模塊互斥類型功能編號功能名稱互斥功能模塊互斥功能編號互斥功能名稱非互斥功能模塊非互斥功能編號非互斥功能名稱互斥模塊0PU040306IAIA2002結(jié)算成本處理AP0AP0403現(xiàn)結(jié)制單IAIA3020存貨現(xiàn)結(jié)制單AP0AP0403現(xiàn)結(jié)制單IAIA3020存貨現(xiàn)結(jié)制單AS4AS026憑證類別編輯IACA0CA04成本計算IAIA2001產(chǎn)成品成本分配GL0GL0208記帳IAIA3020存貨現(xiàn)結(jié)制單GL0GL0208記帳IAIASCPZ生成憑證GL0GL0208記帳IAIASCPZ生成憑證GL4GL010802選項設(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選項錄入IAASM3102期初記帳IA0IA000002選項錄入IAIA000002選項錄入IA0IA000002選項錄入IAIA0015入庫調(diào)整單記帳IA0IA000002選項錄入IAIA0017出庫調(diào)整單記帳IA0IA000002選項錄入IAIA0019價格調(diào)整單記帳IA0IA000002選項錄入IAIA2001產(chǎn)成品成本分配IA0IA000002選項錄入IAIA2002結(jié)算成本處理IA0IA000002選項錄入IAIA2004單據(jù)記帳IA0IA000002選項錄入IAIA2005恢復(fù)記帳IA0IA000002選項錄入IAIA2006期末處理IA0IA000002選項錄入IAIA2007月末結(jié)帳IA0IA0015入庫調(diào)整單記帳IAIA0015入庫調(diào)整單記帳IA0IA0015入庫調(diào)整單記帳IAIA0017出庫調(diào)整單記帳IA0IA0015入庫調(diào)整單記帳IAIA0019價格調(diào)整單記帳IA0IA0015入庫調(diào)整單記帳IAIA2002結(jié)算成本處理IA0IA0015入庫調(diào)整單記帳IAIA