生产设备管理系统

返回总览生产设备管理系统数据表序号表名表描述1ICDeviceAccount设备档案2ICDeviceAccessory设备档案分录3ICDeviceAccident设备事故登记表4ICDeviceAccImprove设备事故登记表分录_改善措施5ICDeviceAccReason设备事故登记表分录6ICDeviceChange设备档案分录_变动情况7ICDeviceDoc设备档案分录_文档管理8ICDeviceImproveInfo设备事故改善登记表9ICDeviceImproveInfoEntry设备事故改善登记表分录10ICDeviceInspectPlan设备点检 计划 项目进度计划表范例计划下载计划下载计划下载课程教学计划下载 11ICDeviceInspectPlanEntry设备点检计划分录12ICDeviceInspectRecord设备点检 记录 混凝土 养护记录下载土方回填监理旁站记录免费下载集备记录下载集备记录下载集备记录下载 13ICDeviceInspectRecordEntry设备点检记录分录14ICDeviceLubePlan设备润滑计划15ICDeviceLubePlanEntry设备润滑计划分录16ICDeviceLubeRecord设备润滑记录17ICDeviceLubeRecordEntry设备润滑记录分录18ICDeviceMaintainPlan设备保养计划19ICDeviceMaintainPlanEntry设备保养计划分录20ICDeviceMaintainRecord设备保养记录21ICDeviceMaintainRecordEntry设备保养记录分录22ICDeviceParam设备档案分录_技术参数23ICDeviceRepairApply设备请修24ICDeviceRepairApplyProject设备请修分录25ICDeviceRepairApplySpare设备请修分录_备件耗用26ICDeviceRepairCheck设备维修验收27ICDeviceRepairCheckEntry设备维修验收分录28ICDeviceRepairPlan设备维修计划29ICDeviceRepairPlanProject设备维修计划分录30ICDeviceRepairPlanSpare设备维修计划分录_备件耗用31ICDeviceRepairRecord设备维修记录32ICDeviceRepairRecordProject设备维修记录分录33ICDeviceRepairRecordSpare设备维修记录分录_备件耗用34ICDeviceRepairWO设备维修工单35ICDeviceRepairWOProject设备维修工单分录36ICDeviceRepairWOSpare设备维修工单分录_备件耗用37ICDeviceRun设备运行38ICDeviceRunEntry设备运行分录39ICDeviceSparePart设备档案分录_设备备件40ICDeviceRepairData设备维修 规程 煤矿测量规程下载煤矿测量规程下载配电网检修规程下载地籍调查规程pdf稳定性研究规程下载 41ICDeviceRepairProject设备维修规程分录42ICDeviceLubeData设备润滑规程43ICDeviceLubeDataEntry设备润滑规程分录44ICDeviceInspectData设备点检规程45ICDeviceInspectDataEntry设备点检规程分录46ICDeviceMaintainData设备保养规程47ICDeviceMaintainDataEntry设备保养规程分录48View_ICDeviceAccount设备档案视图49View_ICDeviceRun设备运行视图50View_ICDeviceRepairData设备维修规程视图51View_ICDeviceLubeData设备润滑规程视图52View_ICDeviceLubePlan设备润滑计划视图53View_ICDeviceLubeRecord设备润滑记录视图54View_ICDeviceAccident设备事故登记表视图55View_ICDeviceImproveInfo设备事故改善登记表视图56View_ICDeviceInspectData设备点检规程视图57View_ICDeviceInspectPlan设备点检计划视图58View_ICDeviceInspectRecord设备点检记录视图59View_ICDeviceMaintainData设备保养规程视图60View_ICDeviceMaintainPlan设备保养计划视图61View_ICDeviceMaintainRecord设备保养记录视图62View_ICDeviceRepairApply设备请修视图63View_ICDeviceRepairPlan设备维修计划视图64View_ICDeviceRepairWO设备维修工单视图65View_ICDeviceRepairRecord设备维修记录视图66View_ICDeviceRepairCheck设备维修验收视图返回生产设备管理系统目录表结构字段名类型描述FABCTypeINTEGERABC分类FAssetNumberINTEGER资产编码FAttributeINTEGER设备属性FBeginUseDateDATETIME启用日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME确认日期FCheckerIDINTEGER确认人FClassTypeIDINTEGER事务类型FCountrySTRING制造国别FDeptNumberINTEGER使用部门FDeviceClassINTEGER设备类别FDeviceNameSTRING设备名称FDeviceNumberSTRING设备代码FDeviceTypeINTEGER设备类型FDrawingNumberSTRING图号FECoefficientFLOAT电气复杂系数FIDINTEGER内码FItemNumberINTEGER对应物料代码FLeaveFactoryDateDATETIME出厂日期FLeaveFactoryNumberSTRING出厂编号FManufacturerSTRING制造商FMCoefficientFLOAT机械复杂系数FModelSTRING设备型号FNoteSTRING备注FPowerCapFLOAT动力容量(KW)FPurposeINTEGER生产用途FResourceNumberINTEGER对应资源代码FSettingPlaceSTRING安装地点FSpecificationSTRING设备规格FStatusINTEGER设备状态FSupplierINTEGER供应商FTechLevelINTEGER技术水平FWorkTimeFLOAT日制度工作时间(小时)键表键名类型PK__ICDeviceAccount__4D01ECC3主键索引表索引名字段PK__ICDeviceAccount__4D01ECC3FIDIX_FClassFClassTypeIDIX_FNumberFBillID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccessoryNameSTRING附属设备名称FAccessoryNumberSTRING附属设备代码FCountrySTRING制造国别FDeviceClassINTEGER设备类别FDrawingNumberSTRING图号FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLeaveFactoryDateDATETIME出厂日期FLeaveFactoryNumberSTRING出厂编号FManufacturerSTRING制造商FModelSTRING设备型号FNoteSTRING备注FQtyFLOAT附属设备数量FSpecificationSTRING设备规格FStatusINTEGER设备状态FSupplierINTEGER供应商键表键名类型PK__ICDeviceAccessor__3DBFA933主键索引表索引名字段PK__ICDeviceAccessor__3DBFA933FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccidentDateDATETIME故障发生日期FAccidentDescribeSTRING故障描述FAccidentFinderINTEGER故障发现人FAccidentIfImproveSTRING是否改善FAccidentManINTEGER故障负责人FAccidentNumberINTEGER故障类别代码FBillDateDATETIME制单日期FBillerINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FIDINTEGER内码键表键名类型PK__ICDeviceAccident__1082EE68主键索引表索引名字段PK__ICDeviceAccident__1082EE68FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccImproveDescribeSTRING改善措施描述FAccImproveMeasureSTRING改善措施FAssessDateDATETIME检查日期FAssessorINTEGER检查人FEntryIDINTEGER分录内码FFunctionaryINTEGER责任人FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING故障原因备注键表键名类型PK__ICDeviceAccImpro__126B36DA主键索引表索引名字段PK__ICDeviceAccImpro__126B36DAFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccidentDescribeSTRING故障描述FAccidentReasonINTEGER故障原因FAccManINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FNoteSTRING故障原因备注键表键名类型PK__ICDeviceAccReaso__1A0C58A2主键索引表索引名字段PK__ICDeviceAccReaso__1A0C58A2FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChangeDateDATETIME设备变更日期FChangeReasonSTRING变更原因FChangeToSTRING变更去向FChangeTypeINTEGER设备变更类型FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING变更备注键表键名类型PK__ICDeviceChange__6D6EBC55主键索引表索引名字段PK__ICDeviceChange__6D6EBC55FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FCopyQtyINTEGER份数FDocContentSTRING文档 内容 财务内部控制制度的内容财务内部控制制度的内容人员招聘与配置的内容项目成本控制的内容消防安全演练内容 FDocNameSTRING文档名称FDocNumberSTRING文档编号FECopyPathSTRING电子文档路径FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING文档备注FStorePlaceSTRING存放地点键表键名类型PK__ICDeviceDoc__741BB9E4主键索引表索引名字段PK__ICDeviceDoc__741BB9E4FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccidentDateDATETIME故障发生日期FAccidentDescribeSTRING故障描述FAccidentNumberINTEGER故障类别代码FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceAccidentBillIDSTRING设备事故登记表编号FDeviceAccidentIDINTEGER设备事故登记表IDFDeviceIDINTEGER设备代码FIDINTEGER内码FNoteSTRING备注键表键名类型PK__ICDeviceImproveI__20B95631主键索引表索引名字段PK__ICDeviceImproveI__20B95631FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccImproveDescribeSTRING改善措施描述FAccImproveMeasureSTRING改善措施FAccManINTEGER责任人FAssessDateDATETIME检查日期FAssessorINTEGER检查人FCheckInfoSTRING检查记录FDeviceIfImproveSTRING改善是否完成FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FNoteSTRING备注键表键名类型PK__ICDeviceImproveI__2D1F2D16主键索引表索引名字段PK__ICDeviceImproveI__2D1F2D16FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FIDINTEGER内码FInspectIDINTEGER点检规程内码FInspectNameSTRING点检名称FInspectNumberSTRING点检代码FInspectPeriodFLOAT点检周期FLastInspectDateDATETIME最近点检日期FNextInspectDateDATETIME下次点检日期FNoteSTRING备注FPeriodUnitINTEGER周期单位FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划截止日期键表键名类型PK__ICDeviceInspectP__430E6E35主键索引表索引名字段PK__ICDeviceInspectP__430E6E35FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FInspectPositionSTRING点检部位FInspectRequireSTRING具体要求FNoteSTRING备注FProjectNameSTRING点检项目名称键表键名类型PK__ICDeviceInspectP__515C8D8C主键索引表索引名字段PK__ICDeviceInspectP__515C8D8CFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBeginDateDATETIME点检开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FEndDateDATETIME点检结束日期FIDINTEGER内码FInspectIDINTEGER点检规程内码FInspectNameSTRING点检名称FInspectNumberSTRING点检代码FInspectPlanBillIDSTRING点检计划编号FInspectPlanIDINTEGER点检计划内码FNoteSTRING备注键表键名类型PK__ICDeviceInspectR__58FDAF54主键索引表索引名字段PK__ICDeviceInspectR__58FDAF54FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FInspectPositionSTRING点检部位FInspectRecordSTRING点检记录FInspectRequireSTRING具体要求FNoteSTRING备注FProjectNameSTRING点检项目名称键表键名类型PK__ICDeviceInspectR__674BCEAB主键索引表索引名字段PK__ICDeviceInspectR__674BCEABFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FIDINTEGER内码FLastLubricateDateDATETIME最近润滑日期FLubricateIDINTEGER润滑规程内码FLubricateNameSTRING润滑名称FLubricateNumberSTRING润滑代码FLubricatePeriodFLOAT润滑周期FNextLubricateDateDATETIME下次润滑日期FNoteSTRING备注FPeriodUnitINTEGER周期单位FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划截止日期键表键名类型PK__ICDeviceLubePlan__5C0F2629主键索引表索引名字段PK__ICDeviceLubePlan__5C0F2629FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLubeIDINTEGER润滑油代码FLubericatePositionSTRING润滑部位FLubricateExplainSTRING润滑说明FNoteSTRING备注FStdQtyFLOAT 标准 excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载 用量FStdQty_BaseFLOAT基本单位标准用量FUnitINTEGER计量单位键表键名类型PK__ICDeviceLubePlan__6A5D4580主键索引表索引名字段PK__ICDeviceLubePlan__6A5D4580FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBeginDateDATETIME润滑开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FEndDateDATETIME润滑结束日期FIDINTEGER内码FLubePlanBillIDSTRING润滑计划编号FLubePlanIDINTEGER润滑计划内码FLubricateIDINTEGER润滑规程内码FLubricateNameSTRING润滑名称FLubricateNumberSTRING润滑代码FNoteSTRING备注键表键名类型PK__ICDeviceLubeReco__74DAD3F3主键索引表索引名字段PK__ICDeviceLubeReco__74DAD3F3FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLubeIDINTEGER润滑油代码FLubeRecordSTRING润滑记录FLubericatePositionSTRING润滑部位FLubricateExplainSTRING润滑说明FNoteSTRING备注FStdQtyFLOAT标准用量FStdQty_BaseFLOAT基本单位标准用量FUnitINTEGER计量单位FUsedQtyFLOAT实际用量FUsedQty_BaseFLOAT基本单位实际用量键表键名类型PK__ICDeviceLubeReco__0328F34A主键索引表索引名字段PK__ICDeviceLubeReco__0328F34AFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FIDINTEGER内码FLastMaintainDateDATETIME最近保养日期FMaintainIDINTEGER保养规程内码FMaintainNameSTRING保养名称FMaintainNumberSTRING保养代码FMaintainPeriodFLOAT保养周期FMaintainTypeINTEGER保养类别FNextMaintainDateDATETIME下次保养日期FNoteSTRING备注FPeriodUnitINTEGER周期单位FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划截止日期键表键名类型PK__ICDeviceMaintain__0B892F21主键索引表索引名字段PK__ICDeviceMaintain__0B892F21FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FMaintainRequireSTRING具体要求FNoteSTRING备注FProjectNameSTRING保养项目名称键表键名类型PK__ICDeviceMaintain__1ACB72B1主键索引表索引名字段PK__ICDeviceMaintain__1ACB72B1FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBeginDateDATETIME保养开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FEndDateDATETIME保养结束日期FIDINTEGER内码FMaintainIDINTEGER保养规程内码FMaintainNameSTRING保养名称FMaintainNumberSTRING保养代码FMaintainPlanBillIDSTRING保养计划编号FMaintainPlanIDINTEGER保养计划内码FMaintainTypeINTEGER保养类别FNoteSTRING备注键表键名类型PK__ICDeviceMaintain__29199208主键索引表索引名字段PK__ICDeviceMaintain__29199208FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FMaintainRecordSTRING保养记录FMaintainRequireSTRING具体要求FMaintainTimeFLOAT保养工时FNoteSTRING备注FProjectNameSTRING保养项目名称FStopTimeFLOAT停机工时FTimeUnitINTEGER时间单位键表键名类型PK__ICDeviceMaintain__385BD598主键索引表索引名字段PK__ICDeviceMaintain__385BD598FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FLowerLimitSTRING下限值FNoteSTRING参数备注FParamExplainSTRING参数说明FParamNameSTRING参数名称FParamNumberSTRING参数代码FParamTypeINTEGER参数值类型FStandardValueSTRING标准值FUpperLimitSTRING上限值键表键名类型PK__ICDeviceParam__7DA5241E主键索引表索引名字段PK__ICDeviceParam__7DA5241EFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FApplyBeginDateDATETIME申请开始日期FApplyDeptIDINTEGER申请部门FApplyEndDateDATETIME申请截止日期FApplyReasonSTRING申请原因FBeginDateDATETIME实际开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceAccidentBillIDSTRING事故登记表号FDeviceAccidentIDINTEGER事故登记表内码FDeviceIDINTEGER设备代码FEndDateDATETIME实际结束日期FIDINTEGER内码FNoteSTRING备注FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划结束日期FRepairContentSTRING维修内容FRepairIDINTEGER维修规程内码FRepairManHourFLOAT维修工时FRepairNameSTRING维修名称FRepairNumberSTRING维修代码FRequireSTRING维修要求FStopManHourFLOAT停机工时FTimeUnitINTEGER时间单位键表键名类型PK__ICDeviceRepairAp__4C62CE45主键索引表索引名字段PK__ICDeviceRepairAp__4C62CE45FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FCheckEmpINTEGER检查人FDesValueSTRING目标值FDesValueTypeINTEGER目标值类型FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLowerDesValueSTRING目标下限FNoteSTRING备注FProjectNameSTRING维修项目名称FRepairRequireSTRING项目维修要求FUpperDesValueSTRING目标上限FWorkDescriptionSTRING维修操作说明键表键名类型PK__ICDeviceRepairAp__615DEB2B主键索引表索引名字段PK__ICDeviceRepairAp__615DEB2BFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAuxQtyFLOAT用量FAuxQty_BaseFLOAT基本单位用量FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING备注FSparePartIDINTEGER基本计量单位FSpaUnitINTEGER计量单位键表键名类型PK__ICDeviceRepairAp__6DC3C210主键索引表索引名字段PK__ICDeviceRepairAp__6DC3C210FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FIDINTEGER内码FNoteSTRING备注FRepairCheckDateDATETIME验收日期FRepairCheckerIDINTEGER验收人FRepairCheckResultINTEGER验收结论FRepairWOBillIDSTRING维修工单号FRepairWOIDINTEGER设备维修工单内码键表键名类型PK__ICDeviceRepairCh__0842AE22主键索引表索引名字段PK__ICDeviceRepairCh__0842AE22FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FCheckContentSTRING验收内容FDesValueSTRING目标值FDesValueTypeINTEGER目标值类型FEntryIDINTEGER分录内码FFactValueSTRING实际值FIDINTEGER内码FIndexINTEGER行号FLowerDesValueSTRING目标下限FNoteSTRING备注FProjectNameSTRING验收项目名称FUpperDesValueSTRING目标上限键表键名类型PK__ICDeviceRepairCh__159CA940主键索引表索引名字段PK__ICDeviceRepairCh__159CA940FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FCurrencyINTEGER币别FDeviceIDINTEGER设备代码FEntrustINTEGER是否外包FIDINTEGER内码FLastRepairDateDATETIME最近维修日期FNextRepairDateDATETIME下次维修日期FNoteSTRING备注FPeriodFLOAT维修周期FPeriodUnitINTEGER周期单位FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划结束日期FPlanRepairFeeFLOAT计划修理费用FPlanRepairManHourFLOAT计划维修工时FPlanStopManHourFLOAT计划停机工时FRepairCatgINTEGER维修类别FRepairContentSTRING维修内容FRepairFeeFLOAT实际修理费用FRepairIDINTEGER维修规程内码FRepairManHourFLOAT实际维修工时FRepairNameSTRING维修名称FRepairNumberSTRING维修代码FRepairSubcntrINTEGER修理单位FRequireSTRING维修要求FStopManHourFLOAT实际停机工时FTimeUnitINTEGER时间单位键表键名类型PK__ICDeviceRepairPl__7564E3D8主键索引表索引名字段PK__ICDeviceRepairPl__7564E3D8FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FCheckEmpINTEGER检查人FDesValueSTRING目标值FDesValueTypeINTEGER目标值类型FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLowerDesValueSTRING目标下限FNoteSTRING备注FProjectNameSTRING维修项目名称FRepairRequireSTRING项目维修要求FUpperDesValueSTRING目标上限FWorkDescriptionSTRING维修操作说明键表键名类型PK__ICDeviceRepairPl__12012286主键索引表索引名字段PK__ICDeviceRepairPl__12012286FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAuxQtyFLOAT用量FAuxQty_BaseFLOAT基本单位用量FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING备注FSparePartIDINTEGER基本计量单位FSpaUnitINTEGER计量单位键表键名类型PK__ICDeviceRepairPl__1E66F96B主键索引表索引名字段PK__ICDeviceRepairPl__1E66F96BFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBeginDateDATETIME实际开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FCurrencyINTEGER币别FDeviceIDINTEGER设备代码FEndDateDATETIME实际结束日期FEntrustINTEGER是否外包FIDINTEGER内码FNoteSTRING备注FPlanRepairFeeFLOAT计划修理费用FPlanRepairManHourFLOAT计划维修工时FPlanStopManHourFLOAT计划停机工时FRepairCatgINTEGER维修类别FRepairContentSTRING维修内容FRepairFeeFLOAT实际修理费用FRepairIDINTEGER维修规程内码FRepairManHourFLOAT实际维修工时FRepairNameSTRING维修名称FRepairNumberSTRING维修代码FRepairSubcntrINTEGER修理单位FRepairWOBillIDSTRING设备维修工单号FRepairWOIDINTEGER设备维修工单内码FRequireSTRING维修要求FStopManHourFLOAT实际停机工时FTimeUnitINTEGER时间单位键表键名类型PK__ICDeviceRepairRe__56AB528E主键索引表索引名字段PK__ICDeviceRepairRe__56AB528EFIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FCheckEmpINTEGER检查人FDesValueSTRING目标值FDesValueTypeINTEGER目标值类型FEntryIDINTEGER分录内码FFactValueSTRING实际值FIDINTEGER内码FIndexINTEGER行号FLowerDesValueSTRING目标下限FNoteSTRING备注FProjectNameSTRING维修项目名称FRepairRequireSTRING项目维修要求FUpperDesValueSTRING目标上限FWorkDescriptionSTRING维修操作说明键表键名类型PK__ICDeviceRepairRe__715F48CA主键索引表索引名字段PK__ICDeviceRepairRe__715F48CAFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAuxQtyFLOAT标准用量FAuxQty_BaseFLOAT基本单位标准用量FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING项目备注FSparePartIDINTEGER基本计量单位FSpaUnitINTEGER计量单位FUsedQtyFLOAT实际用量FUsedQty_BaseFLOAT基本单位实际用量键表键名类型PK__ICDeviceRepairRe__7EB943E8主键索引表索引名字段PK__ICDeviceRepairRe__7EB943E8FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBeginDateDATETIME实际开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FCurrencyINTEGER币别FDeviceIDINTEGER设备代码FEndDateDATETIME实际结束日期FEntrustINTEGER是否外包FIDINTEGER内码FNoteSTRING备注FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划结束日期FPlanRepairFeeFLOAT计划修理费用FPlanRepairManHourFLOAT计划维修工时FPlanStopManHourFLOAT计划停机工时FRepairApplyBillIDSTRING设备请修单号FRepairApplyIDINTEGER设备请修单内码FRepairCatgINTEGER维修类别FRepairContentSTRING维修内容FRepairFeeFLOAT实际修理费用FRepairIDINTEGER维修规程内码FRepairManHourFLOAT实际维修工时FRepairNameSTRING维修名称FRepairNumberSTRING维修代码FRepairPlanBillIDSTRING设备维修计划号FRepairPlanIDINTEGER设备维修计划内码FRepairSubcntrINTEGER修理单位FRequireSTRING维修要求FStopManHourFLOAT实际停机工时FTimeUnitINTEGER时间单位键表键名类型PK__ICDeviceRepairWO__26081B33主键索引表索引名字段PK__ICDeviceRepairWO__26081B33FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FCheckEmpINTEGER检查人FDesValueSTRING目标值FDesValueTypeINTEGER目标值类型FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLowerDesValueSTRING目标下限FNoteSTRING备注FProjectNameSTRING维修项目名称FRepairRequireSTRING项目维修要求FUpperDesValueSTRING目标上限FWorkDescriptionSTRING维修操作说明键表键名类型PK__ICDeviceRepairWO__42A459E1主键索引表索引名字段PK__ICDeviceRepairWO__42A459E1FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAuxQtyFLOAT用量FAuxQty_BaseFLOAT基本单位用量FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING备注FSparePartIDINTEGER基本计量单位FSpaUnitINTEGER计量单位键表键名类型PK__ICDeviceRepairWO__4F0A30C6主键索引表索引名字段PK__ICDeviceRepairWO__4F0A30C6FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBeginDateDATETIME统计开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FEndDateDATETIME统计截止日期FIDINTEGER内码键表键名类型PK__ICDeviceRun__0FC3D459主键索引表索引名字段PK__ICDeviceRun__0FC3D459FIDIX_FBeginDateFClassTypeIDIX_FEndDateFBillID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FBreakDownTimeFLOAT故障停机时间FDeviceIDINTEGER设备代码FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FMachineRepairTimeFLOAT机修时间FNoteSTRING备注FPowerCutTimeFLOAT停电时间FRunTimeFLOAT运行时间FTimeUnitINTEGER时间单位FWaitMaterialTimeFLOAT待料时间FWaitToolTimeFLOAT待具时间键表键名类型PK__ICDeviceRunEntry__1764F621主键索引表索引名字段PK__ICDeviceRunEntry__1764F621FEntryIDIX_FDeviceIDFIDIX_FIDFIndex触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAuxQtyFLOAT备件数量FAuxQty_BaseFLOAT基本单位数量FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FNoteSTRING备件备注FSparePartIDINTEGER备件代码FSpaUnitINTEGER计量单位键表键名类型PK__ICDeviceSparePar__0822B291主键索引表索引名字段PK__ICDeviceSparePar__0822B291FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FDeviceTypeINTEGER设备类型FForbiddenINTEGER禁用状态FIDINTEGER内码FNoteSTRING备注FPeriodFLOAT维修周期FPeriodUnitINTEGER周期单位FPlanRepairManHourFLOAT计划维修工时FPlanStopManHourFLOAT计划停机工时FRepairCatgINTEGER维修类别FRepairNameSTRING维修名称FRepairNumberSTRING维修代码FTimeUnitINTEGER时间单位键表键名类型PK__ICDeviceRepairDa__22D6A8CD主键索引表索引名字段PK__ICDeviceRepairDa__22D6A8CDFIDIX_FDeviceIDFClassTypeIDIX_FNumberFRepairNumber触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChargeEmpINTEGER负责人FCheckEmpINTEGER检查人FDesValueSTRING目标值FDesValueTypeINTEGER目标值类型FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLowerDesValueSTRING目标下限FNoteSTRING备注FProjectNameSTRING维修项目名称FRepairRequireSTRING维修要求FUpperDesValueSTRING目标上限FWorkDescriptionSTRING维修操作说明键表键名类型PK__ICDeviceRepairPr__3218EC5D主键索引表索引名字段PK__ICDeviceRepairPr__3218EC5DFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FDevi