用友数据库表字典及字段

用友数据库表字典及字段
用友数据库表字典及字段

ID sjk表名序号字段名更名type length isnullable s cale 2066Ufdat fa_Cards1sCardID int400 2067Ufdat fa_Cards2sCardNum varchar50

2068Ufdat fa_Cards3sAssetNum varchar270

2069Ufdat fa_Cards4sAssetName varchar500

2070Ufdat fa_Cards5lOptID int400 2071Ufdat fa_Cards6iOptType smallint200 2072Ufdat fa_Cards7iNewType int410 2073Ufdat fa_Cards8bMultiDept bit100 2074Ufdat fa_Cards9sDeptNum varchar2801

2075Ufdat fa_Cards10sDeptNames varchar4501

2076Ufdat fa_Cards11sTypeNum varchar101

2077Ufdat fa_Cards12sOrgID varchar101

2078Ufdat fa_Cards13sOrgAddID varchar101

2079Ufdat fa_Cards14sOrgDisposeID varchar101

2080Ufdat fa_Cards15sDeprMethodID varchar101

2081Ufdat fa_Cards16sStatusID varchar101

2082Ufdat fa_Cards17sTransTypeNum varchar501

2083Ufdat fa_Cards18sTransDepteNum varchar2801

2084Ufdat fa_Cards19dStartdate datetime813 2085Ufdat fa_Cards20lUsedMonths int410 2086Ufdat fa_Cards21lLife int410 2087Ufdat fa_Cards23sStyle varchar501

2088Ufdat fa_Cards24dblBuildArea float81

2089Ufdat fa_Cards25lBuildNum int410 2090Ufdat fa_Cards26lMachinNum int410 2091Ufdat fa_Cards27dblMachinW float81

2092Ufdat fa_Cards28sSite varchar501

2093Ufdat fa_Cards35dblValue float81

2094Ufdat fa_Cards36dblFCValue float81

2095Ufdat fa_Cards37sCurrency varchar81

2096Ufdat fa_Cards38dblExchangeRate float81

2097Ufdat fa_Cards44dblLegacy float81

2098Ufdat fa_Cards45dblBV float81

2099Ufdat fa_Cards46dblBVRate float81

2100Ufdat fa_Cards48dblDecDeprT float81

2101Ufdat fa_Cards49dblDecDepr float81

2102Ufdat fa_Cards50dblDecDeprRate float81

2103Ufdat fa_Cards51lDecDeprMonths int410 2104Ufdat fa_Cards52dblDecWorkT float81

2105Ufdat fa_Cards53dblDecPerDepr float81

2106Ufdat fa_Cards56dblCanWork float81

2107Ufdat fa_Cards59sWorkUnit varchar101

2108Ufdat fa_Cards100dblPerDepr float81

2109Ufdat fa_Cards140sEvaluateNum varchar51

2110Ufdat fa_Cards145sVoucherNum varchar51

2111Ufdat fa_Cards147dTransDate datetime813 2112Ufdat fa_Cards148iTransPeriod smallint210 2113Ufdat fa_Cards149iVouchsNextMonthAct smallint210 2114Ufdat fa_Cards151dblNetValueAct float81

2115Ufdat fa_Cards152lDeprMonthsAct int410 2116Ufdat fa_Cards153dblCanWorkAct float81

2117Ufdat fa_Cards160dblTransInDeprTCard float81

2118Ufdat fa_Cards161dblTransOutDeprTCardfloat81

2119Ufdat fa_Cards166DblDecPreValueT float80

2120Ufdat fa_Cards167DblRetDecPreValueT float80

2121Ufdat fa_Cards201sOperator varchar200

2122Ufdat fa_Cards202dInputDate datetime813 2123Ufdat fa_Cards203iInputPeriod smallint210 2124Ufdat fa_Cards210sDisposer varchar201

2125Ufdat fa_Cards211sDisposeReason varchar1001

2126Ufdat fa_Cards212dDisposeDate datetime813 2127Ufdat fa_Cards213iDisposePeriod smallint210 2128Ufdat fa_Cards308sZWVoucherType varchar81

2129Ufdat fa_Cards309sZWVoucherNum varchar101

2130Ufdat fa_Cards319sDeprSubjectNum varchar151

2131Ufdat fa_Cards320sDeprSubjectName varchar501

2132Ufdat fa_Cards321sProjectNum varchar201

2133Ufdat fa_Cards322sProjectName varchar501

2134Ufdat fa_Cards465sLockedBy varchar501

2135Ufdat fa_Cards_Detail1sID int400 2136Ufdat fa_Cards_Detail2sCardID int400 2137Ufdat fa_Cards_Detail3sCardNum varchar50

2138Ufdat fa_Cards_Detail4sDeptNum varchar120

2139Ufdat fa_Cards_Detail5lOptID int400 2140Ufdat fa_Cards_Detail6dDisposeDate datetime813 2141Ufdat fa_Cards_Detail7iDisposePeriod int400 2142Ufdat fa_Cards_Detail8dblValue float81

2143Ufdat fa_Cards_Detail9dblDecDeprT float81

2144Ufdat fa_Cards_Detail10dblBV float81

2145Ufdat fa_Cards_Detail11dblCanWork float81

2146Ufdat fa_Cards_Detail12dblTransInDeprTCard float81

2147Ufdat fa_Cards_Detail13dblTransOutDeprTCardfloat81

2148Ufdat fa_Cards_Detail14dblDecPreValueT float80

2149Ufdat fa_Cards_Detail15dblRetDecPreValueT float80

2150Ufdat fa_Cards_Detail16dblBuildArea float81

2151Ufdat fa_Cards_Detail17lBuildNum int410 2152Ufdat fa_Cards_Detail18lMachinNum int410 2153Ufdat fa_Cards_Detail19dblMachinW float81

2210Ufdat fa_DeprTransactions1sCardNum varchar50

2211Ufdat fa_DeprTransactions2sDeprAssetNum varchar271

2212Ufdat fa_DeprTransactions3iInputPeriod smallint210 2213Ufdat fa_DeprTransactions4dblInputValue float81

2214Ufdat fa_DeprTransactions5dblMonthValue float81

2215Ufdat fa_DeprTransactions6dblPeriodValue float81

2216Ufdat fa_DeprTransactions7dblInputDeprTotal float81

2217Ufdat fa_DeprTransactions8dblMonthDeprTotal float81

2218Ufdat fa_DeprTransactions9dblPeriodDeprTotal float81

2219Ufdat fa_DeprTransactions10dblInputBV float81

2220Ufdat fa_DeprTransactions11dblMonthBV float81

2221Ufdat fa_DeprTransactions12dblInputBVRate float81

2222Ufdat fa_DeprTransactions13dblMonthBVRate float81

2223Ufdat fa_DeprTransactions14dblInputCanWork float81

2224Ufdat fa_DeprTransactions15dblInputWorkTotal float81

2225Ufdat fa_DeprTransactions16lInputLife int410 2226Ufdat fa_DeprTransactions17lInputDeprMonths int410 2227Ufdat fa_DeprTransactions18sMonthStatusID varchar101

2228Ufdat fa_DeprTransactions19dblDepr0float81

2229Ufdat fa_DeprTransactions20dblDeprRate0float81

2230Ufdat fa_DeprTransactions21dblDeprT0float81

2232Ufdat fa_DeprTransactions23lUsedMonths0int410 2233Ufdat fa_DeprTransactions24dblDepr1float81

2234Ufdat fa_DeprTransactions25dblDeprRate1float81

2235Ufdat fa_DeprTransactions26dblDeprT1float81

2236Ufdat fa_DeprTransactions27lDeprMonths1int410 2237Ufdat fa_DeprTransactions28lUsedMonths1int410 2238Ufdat fa_DeprTransactions29dblDepr2float81

2239Ufdat fa_DeprTransactions30dblDeprRate2float81

2240Ufdat fa_DeprTransactions31dblDeprT2float81

2241Ufdat fa_DeprTransactions32lDeprMonths2int410 2242Ufdat fa_DeprTransactions33lUsedMonths2int410 2243Ufdat fa_DeprTransactions34dblDepr3float81

2244Ufdat fa_DeprTransactions35dblDeprRate3float81

2245Ufdat fa_DeprTransactions36dblDeprT3float81

2246Ufdat fa_DeprTransactions37lDeprMonths3int410 2247Ufdat fa_DeprTransactions38lUsedMonths3int410 2248Ufdat fa_DeprTransactions39dblDepr4float81

2249Ufdat fa_DeprTransactions40dblDeprRate4float81

2250Ufdat fa_DeprTransactions41dblDeprT4float81

2251Ufdat fa_DeprTransactions42lDeprMonths4int410 2252Ufdat fa_DeprTransactions43lUsedMonths4int410 2253Ufdat fa_DeprTransactions44dblDepr5float81

2254Ufdat fa_DeprTransactions45dblDeprRate5float81

2255Ufdat fa_DeprTransactions46dblDeprT5float81

2256Ufdat fa_DeprTransactions47lDeprMonths5int410 2257Ufdat fa_DeprTransactions48lUsedMonths5int410 2258Ufdat fa_DeprTransactions49dblDepr6float81

2259Ufdat fa_DeprTransactions50dblDeprRate6float81

2260Ufdat fa_DeprTransactions51dblDeprT6float81

2261Ufdat fa_DeprTransactions52lDeprMonths6int410 2262Ufdat fa_DeprTransactions53lUsedMonths6int410 2263Ufdat fa_DeprTransactions54dblDepr7float81

2264Ufdat fa_DeprTransactions55dblDeprRate7float81

2265Ufdat fa_DeprTransactions56dblDeprT7float81

2266Ufdat fa_DeprTransactions57lDeprMonths7int410 2267Ufdat fa_DeprTransactions58lUsedMonths7int410 2268Ufdat fa_DeprTransactions59dblDepr8float81

2269Ufdat fa_DeprTransactions60dblDeprRate8float81

2270Ufdat fa_DeprTransactions61dblDeprT8float81

2271Ufdat fa_DeprTransactions62lDeprMonths8int410 2272Ufdat fa_DeprTransactions63lUsedMonths8int410 2273Ufdat fa_DeprTransactions64dblDepr9float81

2274Ufdat fa_DeprTransactions65dblDeprRate9float81

2275Ufdat fa_DeprTransactions66dblDeprT9float81

2276Ufdat fa_DeprTransactions67lDeprMonths9int410 2277Ufdat fa_DeprTransactions68lUsedMonths9int410 2278Ufdat fa_DeprTransactions69dblDepr10float81

2279Ufdat fa_DeprTransactions70dblDeprRate10float81

2280Ufdat fa_DeprTransactions71dblDeprT10float81

2281Ufdat fa_DeprTransactions72lDeprMonths10int410 2282Ufdat fa_DeprTransactions73lUsedMonths10int410 2283Ufdat fa_DeprTransactions74dblDepr11float81

2284Ufdat fa_DeprTransactions75dblDeprRate11float81

2285Ufdat fa_DeprTransactions76dblDeprT11float81

2287Ufdat fa_DeprTransactions78lUsedMonths11int410 2288Ufdat fa_DeprTransactions79dblDepr12float81

2289Ufdat fa_DeprTransactions80dblDeprRate12float81

2290Ufdat fa_DeprTransactions81dblDeprT12float81

2291Ufdat fa_DeprTransactions82lDeprMonths12int410 2292Ufdat fa_DeprTransactions83lUsedMonths12int410 2293Ufdat fa_DeprTransactions84dblMonthValue0float81

2294Ufdat fa_DeprTransactions85dblMonthValue1float81

2295Ufdat fa_DeprTransactions86dblMonthValue2float81

2296Ufdat fa_DeprTransactions87dblMonthValue3float81

2297Ufdat fa_DeprTransactions88dblMonthValue4float81

2298Ufdat fa_DeprTransactions89dblMonthValue5float81

2299Ufdat fa_DeprTransactions90dblMonthValue6float81

2300Ufdat fa_DeprTransactions91dblMonthValue7float81

2301Ufdat fa_DeprTransactions92dblMonthValue8float81

2302Ufdat fa_DeprTransactions93dblMonthValue9float81

2303Ufdat fa_DeprTransactions94dblMonthValue10float81

2304Ufdat fa_DeprTransactions95dblMonthValue11float81

2305Ufdat fa_DeprTransactions96dblMonthValue12float81

2306Ufdat fa_DeprTransactions97dblThisMonthValue float81

2307Ufdat fa_DeprTransactions98dblThisMonthDepr float81

2308Ufdat fa_DeprTransactions99dblThisMonthDeprT float81

2309Ufdat fa_DeprTransactions100dblDeprThisYear float81

2310Ufdat fa_DeprTransactions101sLockedBy varchar501

2311Ufdat fa_DeprTransactions102dblMonthDecPreValue0float80

2312Ufdat fa_DeprTransactions103dblThisMonthDecPreValu float80

2313Ufdat fa_DeprTransactions104dblThisMonthRetDecPreV float80

2314Ufdat fa_DeprTransactions_Det1sID int400 2315Ufdat fa_DeprTransactions_Det2sCardNum varchar50

2316Ufdat fa_DeprTransactions_Det3sDeptNum varchar120

2317Ufdat fa_DeprTransactions_Det4dblDepr1float81

2318Ufdat fa_DeprTransactions_Det5dblDeprT1float81

2319Ufdat fa_DeprTransactions_Det6dblDepr2float81

2320Ufdat fa_DeprTransactions_Det7dblDeprT2float81

2321Ufdat fa_DeprTransactions_Det8dblDepr3float81

2322Ufdat fa_DeprTransactions_Det9dblDeprT3float81

2323Ufdat fa_DeprTransactions_Det10dblDepr4float81

2324Ufdat fa_DeprTransactions_Det11dblDeprT4float81

2325Ufdat fa_DeprTransactions_Det12dblDepr5float81

2326Ufdat fa_DeprTransactions_Det13dblDeprT5float81

2327Ufdat fa_DeprTransactions_Det14dblDepr6float81

2328Ufdat fa_DeprTransactions_Det15dblDeprT6float81

2329Ufdat fa_DeprTransactions_Det16dblDepr7float81

2330Ufdat fa_DeprTransactions_Det17dblDeprT7float81

2331Ufdat fa_DeprTransactions_Det18dblDepr8float81

2332Ufdat fa_DeprTransactions_Det19dblDeprT8float81

2333Ufdat fa_DeprTransactions_Det20dblDepr9float81

2334Ufdat fa_DeprTransactions_Det21dblDeprT9float81

2335Ufdat fa_DeprTransactions_Det22dblDepr10float81

2336Ufdat fa_DeprTransactions_Det23dblDeprT10float81

2337Ufdat fa_DeprTransactions_Det24dblDepr11float81

2338Ufdat fa_DeprTransactions_Det25dblDeprT11float81

2339Ufdat fa_DeprTransactions_Det26dblDepr12float81

2340Ufdat fa_DeprTransactions_Det27dblDeprT12float81

2341Ufdat fa_DeprTransactions_Det28dblMonthValue1float81 2342Ufdat fa_DeprTransactions_Det29dblMonthValue2float81 2343Ufdat fa_DeprTransactions_Det30dblMonthValue3float81 2344Ufdat fa_DeprTransactions_Det31dblMonthValue4float81 2345Ufdat fa_DeprTransactions_Det32dblMonthValue5float81 2346Ufdat fa_DeprTransactions_Det33dblMonthValue6float81 2347Ufdat fa_DeprTransactions_Det34dblMonthValue7float81 2348Ufdat fa_DeprTransactions_Det35dblMonthValue8float81 2349Ufdat fa_DeprTransactions_Det36dblMonthValue9float81 2350Ufdat fa_DeprTransactions_Det37dblMonthValue10float81 2351Ufdat fa_DeprTransactions_Det38dblMonthValue11float81 2352Ufdat fa_DeprTransactions_Det39dblMonthValue12float81 2353Ufdat fa_DeprTransactions_Det40dblMonthValue13float81 2354Ufdat fa_DeprTransactions_Det41dblDeprThisYear float81

domain prec Defa colstat字段中文名说明关联表及字段0100卡片记录标识

050卡片编号主表关联项

0270资产编码主表关联项

0500资产名称

010fa_Cards_lOptID_D0业务号

05fa_Cards_iOptType_D0业务类型

010fa_Cards_iNewType_D0增加类型

01DF_fa_Cards_bMultiDept0是否多部门使用

02800部门编码串Department.cDepCode 04500部门名称串Department.cDepName 0100资产类型编码fa_AssetTypes.sNum 0100核算方式编码fa_Origins.sID

0100增加方式编码fa_Origins.sAddID 0100减少方式编码fa_Origins.sDecID 0100折旧方法编码fa_Depreciations.sID 0100使用状况编码fa_Status.sID

0500转移类别编码fa_AssetTypes.sNum 02800转移部门编码串Department.cDepCode 0230开始使用日期

010fa_Cards_lUsedMonths_D0已使用月份

010fa_Cards_lLife_D0可使用月份

0500规格型号Inventory.cInvStd 053fa_Cards_dblBuildArea_D0建筑面积

010fa_Cards_lBuildNum_D0间数或座数

010fa_Cards_lMachinNum_D0电机数量

053fa_Cards_dblMachinW_D0电机功率

0500存放地点

053fa_Cards_dblValue_D0原值

053fa_Cards_dblFCValue_D0外币原值

080币种名称foreigncurr

053fa_Cards_dblExchangeRate_D0汇率

053fa_Cards_dblLegacy_D0折旧继承值

053fa_Cards_dblBV_D0净残值

053fa_Cards_dblBVRate_D0净残值率

053fa_Cards_dblDecDeprT_D0减少时累计折旧

053fa_Cards_dblDecDepr_D0减少时折旧

053fa_Cards_dblDecDeprRate_D0减少时折旧率

010fa_Cards_lDecDeprMonths_D0减少时已计提月份

053fa_Cards_dblDecWorkT_D0减少时累计工作量

053fa_Cards_dblDecPerDepr_D0减少时单位折旧

053fa_Cards_dblCanWork_D0工作总量

0100工作量单位

053fa_Cards_dblPerDepr_D0单位折旧

050对应评估单号fa_EvaluateMain.sNum 050变动单号fa_Vouchers.sNum

0230变动日期

05fa_Cards_iTransPeriod_D0变动期间

05fa_Cards_iVouchsNextMonthAct_D0下月开始有效变动单数量

053fa_Cards_dblNetValueAct_D0变动开始有效月初净值

010fa_Cards_lDeprMonthsAct_D0变动开始有效月初已使用月份

053fa_Cards_dblCanWorkAct_D0变动开始有效月初工作总量

053fa_Cards_dblTransInDeprTCard_D0累计折旧转入

053fa_Cards_dblTransOutDeprTCard_D0累计折旧转出

053DF_fa_Cards_dblDecPreValueT0累计减值准备金额

053DF_fa_Cards_dblRetDecPreValueT0累计转回减值准备金额

0200录入人UA_User.cUser_Name 0230录入日期

05fa_Cards_iInputPeriod_D0录入期间

0200注销人UA_User.cUser_Name 01000注销原因

0230注销日期

05fa_Cards_iDisposePeriod_D0注销期间

080凭证类别字Dsign.csign

0100凭证编号

0150折旧科目编码https://www.360docs.net/doc/d019027451.html,ode

0500折旧科目名称https://www.360docs.net/doc/d019027451.html,ode_name 0200项目编码**_项目大类f itemss**.c

0500项目名称**_项目大类f itemss**.c

0500锁定计算机名称

0101自动编号

0100卡片记录标识

050卡片编号

0120部门编码

0100业务号

0230注销日期

0100注销期间

053DF_fa_Cards_Detail_dblValue0原值

053DF_fa_Cards_Detail_dblDecDeprT0减少时累计折旧

053DF_fa_Cards_Detail_dblBV0净残值

053DF_fa_Cards_Detail_dblCanWork0工作总量

053DF_fa_Cards_Detail_dblTransInDeprT0累计折旧转入

053DF_fa_Cards_Detail_dblTransOutDepr0累计折旧转出

053DF_fa_Cards_Detail_dblDecPreValueT0累计减值准备金额

053DF_fa_Cards_Detail_dblRetDecPreVal0累计转回减值准备金额

053DF_fa_Cards_Detail_dblBuildArea0建筑面积

010DF_fa_Cards_Detail_lBuildNum0间数

010DF_fa_Cards_Detail_lMachinNum0电机数量

053DF_fa_Cards_Detail_dblMachinW0电机功率

050卡片编号fa_Cards.sCardNum 0270资产编码fa_Cards.sAssetNum 05fa_DeprTransactions_iInputPeriod_D0录入期间

053fa_DeprTransactions_dblInputValue_0录入时原值

053fa_DeprTransactions_dblMonthValue_0月初原值

053fa_DeprTransactions_dblPeriodValue0期初原值

053fa_DeprTransactions_dblInputDeprTo0录入时累计折旧

053fa_DeprTransactions_dblMonthDeprTo0月初累计折旧

053fa_DeprTransactions_dblPeriodDeprT0期初累计折旧

053fa_DeprTransactions_dblInputBV_D0录入时净残值

053fa_DeprTransactions_dblMonthBV_D0月初净残值

053fa_DeprTransactions_dblInputBVRate0录入时净残值率

053fa_DeprTransactions_dblMonthBVRate0月初净残值率

053fa_DeprTransactions_dblInputCanWor0录入时工作总量

053fa_DeprTransactions_dblInputWorkTo0录入时累计工作量

010fa_DeprTransactions_lInputLife_D0录入时可使用月份

010fa_DeprTransactions_lInputDeprMont0录入时已计提月份

0100月初使用状况编码fa_Status.sID

053fa_DeprTransactions_dblDepr0_D0上年十二月份折旧

053fa_DeprTransactions_dblDeprRate0_D0上年十二月份折旧率

053fa_DeprTransactions_dblDeprT0_D0上年十二月份累计折旧

010fa_DeprTransactions_lDeprMonths0_D0上年十二月份末已计提月份010fa_DeprTransactions_lUsedMonths0_D0上年十二月份末已使用月份053fa_DeprTransactions_dblDepr1_D0一月份折旧

053fa_DeprTransactions_dblDeprRate1_D0一月份折旧率

053fa_DeprTransactions_dblDeprT1_D0一月份累计折旧

010fa_DeprTransactions_lDeprMonths1_D0一月份末已计提月份

010fa_DeprTransactions_lUsedMonths1_D0一月份末已使用月份

053fa_DeprTransactions_dblDepr2_D0二月份折旧

053fa_DeprTransactions_dblDeprRate2_D0二月份折旧率

053fa_DeprTransactions_dblDeprT2_D0二月份累计折旧

010fa_DeprTransactions_lDeprMonths2_D0二月份末已计提月份

010fa_DeprTransactions_lUsedMonths2_D0二月份末已使用月份

053fa_DeprTransactions_dblDepr3_D0三月份折旧

053fa_DeprTransactions_dblDeprRate3_D0三月份折旧率

053fa_DeprTransactions_dblDeprT3_D0三月份累计折旧

010fa_DeprTransactions_lDeprMonths3_D0三月份末已计提月份

010fa_DeprTransactions_lUsedMonths3_D0三月份末已使用月份

053fa_DeprTransactions_dblDepr4_D0四月份折旧

053fa_DeprTransactions_dblDeprRate4_D0四月份折旧率

053fa_DeprTransactions_dblDeprT4_D0四月份累计折旧

010fa_DeprTransactions_lDeprMonths4_D0四月份末已计提月份

010fa_DeprTransactions_lUsedMonths4_D0四月份末已使用月份

053fa_DeprTransactions_dblDepr5_D0五月份折旧

053fa_DeprTransactions_dblDeprRate5_D0五月份折旧率

053fa_DeprTransactions_dblDeprT5_D0五月份累计折旧

010fa_DeprTransactions_lDeprMonths5_D0五月份末已计提月份

010fa_DeprTransactions_lUsedMonths5_D0五月份末已使用月份

053fa_DeprTransactions_dblDepr6_D0六月份折旧

053fa_DeprTransactions_dblDeprRate6_D0六月份折旧率

053fa_DeprTransactions_dblDeprT6_D0六月份累计折旧

010fa_DeprTransactions_lDeprMonths6_D0六月份末已计提月份

010fa_DeprTransactions_lUsedMonths6_D0六月份末已使用月份

053fa_DeprTransactions_dblDepr7_D0七月份折旧

053fa_DeprTransactions_dblDeprRate7_D0七月份折旧率

053fa_DeprTransactions_dblDeprT7_D0七月份累计折旧

010fa_DeprTransactions_lDeprMonths7_D0七月份末已计提月份

010fa_DeprTransactions_lUsedMonths7_D0七月份末已使用月份

053fa_DeprTransactions_dblDepr8_D0八月份折旧

053fa_DeprTransactions_dblDeprRate8_D0八月份折旧率

053fa_DeprTransactions_dblDeprT8_D0八月份累计折旧

010fa_DeprTransactions_lDeprMonths8_D0八月份末已计提月份

010fa_DeprTransactions_lUsedMonths8_D0八月份末已使用月份

053fa_DeprTransactions_dblDepr9_D0九月份折旧

053fa_DeprTransactions_dblDeprRate9_D0九月份折旧率

053fa_DeprTransactions_dblDeprT9_D0九月份累计折旧

010fa_DeprTransactions_lDeprMonths9_D0九月份末已计提月份

010fa_DeprTransactions_lUsedMonths9_D0九月份末已使用月份

053fa_DeprTransactions_dblDepr10_D0十月份折旧

053fa_DeprTransactions_dblDeprRate10_0十月份折旧率

053fa_DeprTransactions_dblDeprT10_D0十月份累计折旧

010fa_DeprTransactions_lDeprMonths10_0十月份末已计提月份

010fa_DeprTransactions_lUsedMonths10_0十月份末已使用月份

053fa_DeprTransactions_dblDepr11_D0十一月份折旧

053fa_DeprTransactions_dblDeprRate11_0十一月份折旧率

053fa_DeprTransactions_dblDeprT11_D0十一月份累计折旧

010fa_DeprTransactions_lDeprMonths11_0十一月份末已计提月份

010fa_DeprTransactions_lUsedMonths11_0十一月份末已使用月份

053fa_DeprTransactions_dblDepr12_D0十二月份折旧

053fa_DeprTransactions_dblDeprRate12_0十二月份折旧率

053fa_DeprTransactions_dblDeprT12_D0十二月份累计折旧

010fa_DeprTransactions_lDeprMonths12_0十二月份末已计提月份

010fa_DeprTransactions_lUsedMonths12_0十二月份末已使用月份

053fa_DeprTransactions_dblMonthValue00上年十二月初原值或本年十二月末原值

053fa_DeprTransactions_dblMonthValue10一月初原值

053fa_DeprTransactions_dblMonthValue20二月初原值

053fa_DeprTransactions_dblMonthValue30三月初原值

053fa_DeprTransactions_dblMonthValue40四月初原值

053fa_DeprTransactions_dblMonthValue50五月初原值

053fa_DeprTransactions_dblMonthValue60六月初原值

053fa_DeprTransactions_dblMonthValue70七月初原值

053fa_DeprTransactions_dblMonthValue80八月初原值

053fa_DeprTransactions_dblMonthValue90九月初原值

053fa_DeprTransactions_dblMonthValue10十月初原值

053fa_DeprTransactions_dblMonthValue10十一月初原值

053fa_DeprTransactions_dblMonthValue10十二月初原值

053fa_DeprTransactions_dblThisMonthVa0现无用

053fa_DeprTransactions_dblThisMonthDe0现无用

053fa_DeprTransactions_dblThisMonthDe0现无用

053fa_DeprTransactions_dblDeprThisYea0本年计提折旧

0500锁定计算机名称

减值准备 - 转回减值准053DF_fa_DeprTransactions_dblMonthDec0上年十二月初累计减值准备

053DF_fa_DeprTransactions_dblThisMont0本期月初累计减值准备

053DF_fa_DeprTransactions_dblThisMont0本期月初累计转回减值准备

0101自动编号

050卡片编号

0120部门编码

053DF_fa_DeprTransactions_Detail_dblD0一月份折旧

053DF_fa_DeprTransactions_Detail_dblD0一月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0二月份折旧

053DF_fa_DeprTransactions_Detail_dblD0二月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0三月份折旧

053DF_fa_DeprTransactions_Detail_dblD0三月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0四月份折旧

053DF_fa_DeprTransactions_Detail_dblD0四月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0五月份折旧

053DF_fa_DeprTransactions_Detail_dblD0五月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0六月份折旧

053DF_fa_DeprTransactions_Detail_dblD0六月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0七月份折旧

053DF_fa_DeprTransactions_Detail_dblD0七月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0八月份折旧

053DF_fa_DeprTransactions_Detail_dblD0八月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0九月份折旧

053DF_fa_DeprTransactions_Detail_dblD0九月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0十月份折旧

053DF_fa_DeprTransactions_Detail_dblD0十月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0十一月份折旧

053DF_fa_DeprTransactions_Detail_dblD0十一月份累计折旧

053DF_fa_DeprTransactions_Detail_dblD0十二月份折旧

053DF_fa_DeprTransactions_Detail_dblD0十二月份累计折旧

053DF_fa_DeprTransactions_Detail_dblM0一月初原值053DF_fa_DeprTransactions_Detail_dblM0二月初原值053DF_fa_DeprTransactions_Detail_dblM0三月初原值053DF_fa_DeprTransactions_Detail_dblM0四月初原值053DF_fa_DeprTransactions_Detail_dblM0五月初原值053DF_fa_DeprTransactions_Detail_dblM0六月初原值053DF_fa_DeprTransactions_Detail_dblM0七月初原值053DF_fa_DeprTransactions_Detail_dblM0八月初原值053DF_fa_DeprTransactions_Detail_dblM0九月初原值053DF_fa_DeprTransactions_Detail_dblM0十月初原值053DF_fa_DeprTransactions_Detail_dblM0十一月初原值053DF_fa_DeprTransactions_Detail_dblM0十二月初原值053DF_fa_DeprTransactions_Detail_dblM0十二月末原值053DF_fa_DeprTransactions_Detail_dblD0本年计提折旧

是否建立检验检验条件IsNew IsDeletedIsActive

FALSE FALSE FALSE 主表关联项FALSE FALSE FALSE 主表关联项FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE Department.cDepCode FALSE FALSE FALSE Department.cDepName FALSE FALSE FALSE fa_AssetTypes.sNum FALSE FALSE FALSE fa_Origins.sID FALSE FALSE FALSE fa_Origins.sAddID FALSE FALSE FALSE fa_Origins.sDecID FALSE FALSE FALSE fa_Depreciations.sID FALSE FALSE FALSE fa_Status.sID FALSE FALSE FALSE fa_AssetTypes.sNum FALSE FALSE FALSE Department.cDepCode FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE Inventory.cInvStd FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE Ok FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE fa_EvaluateMain.sNum FALSE FALSE FALSE fa_Vouchers.sNum FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

UA_User.cUser_Name FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE UA_User.cUser_Name FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE Dsign.csign FALSE FALSE FALSE

FALSE FALSE FALSE https://www.360docs.net/doc/d019027451.html,ode FALSE FALSE FALSE https://www.360docs.net/doc/d019027451.html,ode_name FALSE FALSE FALSE fitemss**.citemcode FALSE FALSE FALSE fitemss**.citemName FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE fa_Cards.sCardNum FALSE FALSE FALSE fa_Cards.sAssetNum FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE fa_Status.sID FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE 备 - 转回减值准备FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE

FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE

相关文档
最新文档