生产设备管理系统.xls

资源ID：74646841 资源大小：181.50KB 全文页数：77页
资源格式： XLS 下载积分：15金币

快捷下载

会员登录下载

微信登录下载

三方登录下载：

微信扫一扫登录

下载资源需要15金币

邮箱/手机：
温馨提示：	快捷下载时，用户名和密码都是您填写的邮箱或者手机号，方便查询和重复下载（系统自动生成）。如填写123，账号就是123，密码也是123。
支付方式：
验证码：	换一换

账号：
密码：
验证码：	换一换
当日自动登录忘记密码？

友情提示

1、下载资料失败解决办法

2、PDF文件下载后，可能会被浏览器默认打开，此种情况可以点击浏览器菜单，保存网页到桌面，就可以正常下载了。

3、本站不支持迅雷下载，请使用电脑自带的IE浏览器，或者360浏览器、谷歌浏览器下载即可。

4、本站资源下载后的文档和图纸-无水印,预览文档经过压缩，下载后原文更清晰。

5、试题试卷类文档，如果标题没有明确说明有答案则都视为没有答案，请知晓。

网站客服

侵权投诉

生产设备管理系统.xls

返回总览生产设备管理系统数据表序序号号表表名名1 ICDeviceAccount2 ICDeviceAccessory3 ICDeviceAccident4 ICDeviceAccImprove5 ICDeviceAccReason6 ICDeviceChange7 ICDeviceDoc8 ICDeviceImproveInfo9 ICDeviceImproveInfoEntry10 ICDeviceInspectPlan11 ICDeviceInspectPlanEntry12 ICDeviceInspectRecord13 ICDeviceInspectRecordEntry14 ICDeviceLubePlan15 ICDeviceLubePlanEntry16 ICDeviceLubeRecord17 ICDeviceLubeRecordEntry18 ICDeviceMaintainPlan19 ICDeviceMaintainPlanEntry20 ICDeviceMaintainRecord21 ICDeviceMaintainRecordEntry22 ICDeviceParam23 ICDeviceRepairApply24 ICDeviceRepairApplyProject25 ICDeviceRepairApplySpare26 ICDeviceRepairCheck27 ICDeviceRepairCheckEntry28 ICDeviceRepairPlan29 ICDeviceRepairPlanProject30 ICDeviceRepairPlanSpare31 ICDeviceRepairRecord32 ICDeviceRepairRecordProject33 ICDeviceRepairRecordSpare34 ICDeviceRepairWO35 ICDeviceRepairWOProject36 ICDeviceRepairWOSpare37 ICDeviceRun38 ICDeviceRunEntry39 ICDeviceSparePart40 ICDeviceRepairData41 ICDeviceRepairProject42 ICDeviceLubeData43 ICDeviceLubeDataEntry44 ICDeviceInspectData45 ICDeviceInspectDataEntry46 ICDeviceMaintainData47 ICDeviceMaintainDataEntry48 View_ICDeviceAccount49 View_ICDeviceRun50 View_ICDeviceRepairData51 View_ICDeviceLubeData52 View_ICDeviceLubePlan53 View_ICDeviceLubeRecord54 View_ICDeviceAccident55 View_ICDeviceImproveInfo56 View_ICDeviceInspectData57 View_ICDeviceInspectPlan58 View_ICDeviceInspectRecord59 View_ICDeviceMaintainData60 View_ICDeviceMaintainPlan61 View_ICDeviceMaintainRecord62 View_ICDeviceRepairApply63 View_ICDeviceRepairPlan64 View_ICDeviceRepairWO65 View_ICDeviceRepairRecord66 View_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标准用量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负责人

注意事项

本文（生产设备管理系统.xls）为本站会员（qwe****56）主动上传，淘文阁 - 分享文档赚钱的网站仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对上载内容本身不做任何修改或编辑。若此文所含内容侵犯了您的版权或隐私，请立即通知淘文阁 - 分享文档赚钱的网站（点击联系客服），我们立即给予删除！

温馨提示：如果因为网速或其他原因下载失败请重新下载，重复下载不扣分。