Mrpii数据库文档
表1:AD_AssetCard
字段
序号
字段名称 字段说明 字段类型 字段
大小
是否主键 允许空 备注
(1) AssetCode varchar 16 PK
(2) AssetName varchar 60
(3) UomCode varchar 4 Y
(4) AssetSujectCod
e
varchar 15 Y
(5) DepreciationSub
jectCode
varchar 15 Y
(6) AssetTypeCode varchar 4
(7) DepositaryCode varchar 4 Y
(8) InAccountDate smalldate
time
18
(9) StartUseDate smalldate
time
18
(10) StartStopUseDa
te
smalldate
time
18 Y
(11) ADChangeTypeC
ode
varchar 4
(12) UseStatusCode varchar 4
(13) CurrencyCode varchar 3
(14) ExchangeRate decimal 9
(15) FirstAmount decimal 21
(16) FirstFAmount decimal 21
(17) DepreciationWay int 10
(18) IntendingPeriod decimal 11
(19) DraffRate decimal 6
(20) DraffValue decimal 21
(21) PeriodRate decimal 6
(22) PeriodValue decimal 21
(23) UsedPeriod int 10
(24) DepreciationVal
ue
decimal 21
(25) NetValue decimal 21
(26) Intending decimal 21 Y
(27) FinishTask decimal 21 Y
(28) TaskUom varchar 10 Y
(29) PCDepreciation decimal 21 Y
(30) CreateDate smalldate
time
18