设备和固定资产数据结构说明书
目录
数据表结构说明.................................................................................................................................4
1、基础字典...............................................................................................................................4
1.1 设备分类字典 sb_zd_class...........................................................................................4
1.2 折旧方法字典 sb_zd_depreciation(暂时没用到)........................................................4
1.3 折旧率字典 sb_zd_depreciation_rate...........................................................................5
1.4 折旧类型字典 sb_zd_depreciation_type......................................................................5
1.5 设备名称字典 sb_zd_equipname.................................................................................5
1.6 设备入出库类型字典 sb_zd_in_out_type...................................................................6
1.7 设备库帐号字典 sb_zd_kzh.........................................................................................6
1.8 设备维修单位字典 sb_zd_maintenance_unit..............................................................6
1.9 设备制造厂商字典 sb_zd_manufacture......................................................................7
1.10 设备计量单位类型字典 sb_zd_measure_type..........................................................7
1.11 设备计量单位字典 sb_zd_measurer..........................................................................8
1.12 设备调配原因字典 sb_zd_move_cause.....................................................................8
1.13 设备状态字典 sb_zd_state.........................................................................................8
1.14 设备供应商字典 sb_zd_supplyer..............................................................................9
1.15 设备单位字典 sb_zd_unit..........................................................................................9
1.16 设备用途字典 sb_zd_usage........................................................................................9
1.17 设备维修类型 sb_zd_maintenance_kind.................................................................10
1.18 设备内部帐号字典 sb_zd_inner_acct_no................................................................10
1.19 设备产地字典 sb_zd_adress.....................................................................................10
1.20 设备配件字典 sb_zd_appendix................................................................................11
2、业务数据表.........................................................................................................................11
2.1 设备现有附件表 sb_appendix....................................................................................11
2.2 设备附件使用表 sb_appendix_use............................................................................12
2.3 设备成本效益信息表 sb_cost_benefit.......................................................................13
2.4 设备折旧变更记录表 sb_depreciation_alter_record.................................................13
2.5 设备折旧记录表 sb_depreciation_record..................................................................14
2.6 设备进口说明表 sb_import_comment.......................................................................14
2.7 设备贷款记录表 sb_in_credit(暂时没用到).............................................................14
2.8 设备购进明细表 sb_in_detl.......................................................................................15
2.9 主设备表 sb_main_equipment...................................................................................16
2.10 设备维修计划单 sb_maintenance_plan(暂时没用到)............................................17
2.11 设备维修记录 sb_maintenance_record....................................................................17
2.12 设备计量记录 sb_measure_record...........................................................................18
2.13 设备调配明细 sb_move_detl...................................................................................18
2.14 设备付款明细 sb_pay_detl.......................................................................................19
2.15 设备服务计划 sb_service_plan(暂时没用到).........................................................19
2.16 设备服务记录 sb_service_record(暂时没用到)......................................................20
