设备管理系统数据表(xls)(1)

返回总览设备管理系统数据表序号表名表描述1View_ICDeviceRepairCheck设备维修验收视图2ICDeviceAccount设备档案3ICDeviceAccessory设备档案分录4ICDeviceRun设备运行5ICDeviceRunEntry设备运行分录6ICDeviceRepairData设备维修规程7ICDeviceRepairProject设备维修规程分录8ICDeviceLubeData设备润滑规程9ICDeviceLubeDataEntry设备润滑规程分录10ICDeviceLubePlan设备润滑计划11ICDeviceLubePlanEntry设备润滑计划分录12ICDeviceLubeRecord设备润滑记录13ICDeviceLubeRecordEntry设备润滑记录分录14ICDeviceAccident设备事故登记表15ICDeviceAccReason设备事故登记表分录16ICDeviceImproveInfo设备事故改善登记表17ICDeviceImproveInfoEntry设备事故改善登记表分录18ICDeviceInspectData设备点检规程19ICDeviceInspectDataEntry设备点检规程分录20ICDeviceInspectPlan设备点检计划21ICDeviceInspectPlanEntry设备点检计划分录22ICDeviceInspectRecord设备点检记录23ICDeviceInspectRecordEntry设备点检记录分录24ICDeviceMaintainData设备保养规程25ICDeviceMaintainDataEntry设备保养规程分录26ICDeviceMaintainPlan设备保养计划27ICDeviceMaintainPlanEntry设备保养计划分录28ICDeviceMaintainRecord设备保养记录29ICDeviceMaintainRecordEntry设备保养记录分录30ICDeviceRepairApply设备请修31ICDeviceRepairApplyProject设备请修分录32ICDeviceRepairPlan设备维修计划33ICDeviceRepairPlanProject设备维修计划分录34ICDeviceRepairWO设备维修工单35ICDeviceRepairWOProject设备维修工单分录36ICDeviceRepairRecord设备维修记录37ICDeviceRepairRecordProject设备维修记录分录38ICDeviceRepairCheck设备维修验收39ICDeviceRepairCheckEntry设备维修验收分录40View_ICDeviceAccount设备档案视图41View_ICDeviceRun设备运行视图42View_ICDeviceRepairData设备维修规程视图43View_ICDeviceLubeData设备润滑规程视图44View_ICDeviceLubePlan设备润滑计划视图45View_ICDeviceLubeRecord设备润滑记录视图46View_ICDeviceAccident设备事故登记表视图47View_ICDeviceImproveInfo设备事故改善登记表视图48View_ICDeviceInspectData设备点检规程视图49View_ICDeviceInspectPlan设备点检计划视图50View_ICDeviceInspectRecord设备点检记录视图51View_ICDeviceMaintainData设备保养规程视图52View_ICDeviceMaintainPlan设备保养计划视图53View_ICDeviceMaintainRecord设备保养记录视图54View_ICDeviceRepairApply设备请修视图55View_ICDeviceRepairPlan设备维修计划视图56View_ICDeviceRepairWO设备维修工单视图57View_ICDeviceRepairRecord设备维修记录视图返回设备管理系统目录表结构字段名类型描述FBillDateDATETIME制单日期FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FProjectNameSTRING验收项目名称FRepairCheckDateDATETIME验收日期FRepairCheckerIDSTRING验收人FRepairCheckResultINTEGER验收结论FUpperDesValueSTRING目标上限FDeviceIDSTRING设备代码FDeviceID32478STRING设备规格FDeviceID32523STRING使用部门FDeviceID51789STRING设备名称FFactValueSTRING实际值FLowerDesValueSTRING目标下限FNoteSTRING备注FNote_2STRING验收备注FRepairWOBillIDSTRING维修工单号FBillerIDSTRING制单人FBillIDSTRING编号FCheckContentSTRING验收内容FCheckerIDSTRING审核人FDesValueSTRING目标值FDesValueTypeSTRING目标值类型FDeviceID32496STRING设备型号键表键名类型索引表索引名字段触发器表触发器名描述返回设备管理系统目录表结构字段名类型描述FBeginUseDateDATETIME启用日期FLeaveFactoryDateDATETIME出厂日期FABCTypeINTEGERABC分类FAssetNumberINTEGER资产编码FAttributeINTEGER设备属性FBillStatusINTEGER单据状态FSettingPlaceSTRING安装地点FSpecificationSTRING设备规格FCheckerIDINTEGER确认人FManufacturerSTRING制造商FModelSTRING设备型号FPurposeINTEGER生产用途FBillDateDATETIME制单日期FSupplierINTEGER供应商FCheckDateDATETIME确认日期FTechLevelINTEGER技术水平FECoefficientFLOAT电气复杂系数FPowerCapFLOAT动力容量(KW)FWorkTimeFLOAT日制度工作时间(小时)FMCoefficientFLOAT机械复杂系数FResourceNumberINTEGER对应资源代码FStatusINTEGER设备状态FNoteSTRING备注FBillerIDINTEGER制单人FBillIDSTRING编号FClassTypeIDINTEGER事务类型FCountrySTRING制造国别FDeptNumberINTEGER使用部门FDeviceClassINTEGER设备类别FDeviceNameSTRING设备名称FDeviceNumberSTRING设备代码FDeviceTypeINTEGER设备类型FDrawingNumberSTRING图号FIDINTEGER内码FItemNumberINTEGER对应物料代码FLeaveFactoryNumberSTRING出厂编号键表键名类型PK__ICDeviceAccount__62713F9E主键索引表索引名字段PK__ICDeviceAccount__62713F9EFIDIX_FClassFClassTypeIDIX_FNumberFBillID触发器表触发器名描述返回设备管理系统目录表结构字段名类型描述FAccessoryNameSTRING附属设备名称FLeaveFactoryNumberSTRING出厂编号FManufacturerSTRING制造商FAccessoryNumberSTRING附属设备代码FCountrySTRING制造国别FDeviceClassINTEGER设备类别FEntryIDINTEGER分录内码FIndexINTEGER行号FLeaveFactoryDateDATETIME出厂日期FQtyFLOAT附属设备数量FStatusINTEGER设备状态FSupplierINTEGER供应商FDrawingNumberSTRING图号FIDINTEGER内码FModelSTRING设备型号FNoteSTRING备注FSpecificationSTRING设备规格键表键名类型PK__ICDeviceAccessor__532EFC0E主键索引表索引名字段PK__ICDeviceAccessor__532EFC0EFEntryIDIX_FIDFID触发器表触发器名描述返回设备管理系统目录表结构字段名类型描述FBeginDateDATETIME统计开始日期FBillDateDATETIME制单日期FCheckDateDATETIME审核日期FEndDateDATETIME统计截止日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FIDINTEGER内码键表键名类型PK__ICDeviceRun__206E7217主键索引表索引名字段PK__ICDeviceRun__206E7217FIDIX_FBeginDateFClassTypeIDIX_FEndDateFBillID触发器表触发器名描述返回设备管理系统目录表结构字段名类型描述FIndexINTEGER行号FMachineRepairTimeFLOAT机修时间FPowerCutTimeFLOAT停电时间FTimeUnitINTEGER时间单位FBreakDownTimeFLOAT故障停机时间FDeviceIDINTEGER设备代码FEntryIDINTEGER分录内码FIDINTEGER内码FNoteSTRING备注FRunTimeFLOAT运行时间FWaitMaterialTimeFLOAT待料时间FWaitToolTimeFLOAT待具时间键表键名类型PK__ICDeviceRunEntry__280F93DF主键索引表索引名字段PK__ICDeviceRunEntry__280F93DFFEntryIDIX_FDeviceIDFIDIX_FIDFIndex触发器表触发器名描述返回设备管理系统目录表结构字段名类型描述FPlanRepairManHourFLOAT计划维修工时FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FDeviceTypeINTEGER设备类型FForbiddenINTEGER禁用状态FIDINTEGER内码FPeriodUnitINTEGER周期单位FPlanStopManHourFLOAT计划停机工时FRepairCatgINTEGER维修类别FTimeUnitINTEGER时间单位FNoteSTRING备注FPeriodFLOAT维修周期FRepairNameSTRING维修名称FRepairNumberSTRING维修代码键表键名类型PK__ICDeviceRepairDa__3381468B主键索引表索引名字段PK__ICDeviceRepairDa__3381468BFIDIX_FDeviceIDFClassTypeIDIX_FNumberFRepairNumber触发器表触发器名描述返回设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FCheckEmpINTEGER检查人FDesValueTypeINTEGER目标值类型FEntryIDINTEGER分录内码FIDINTEGER内码FInde