目 录

1 质量管理

1.1 质量管理

1.1.1 AQL

AQL-单据头

概述
表名称实体名称ORM实体名
T_QM_AQL单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateFModifyDateFMODIFYDATEdatetime8233
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
索引
名称类型字段
PK_QM_AQLCLUSTEREDFID
IDX_QM_AQL_NUMNONCLUSTEREDFNUMBER
IDX_QM_AQL_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_AQLPKFID
触发器
约束
名称类型字段描述
PK_QM_AQL主键约束FID
DF__T_QM_AQL__FID__4C9FC9D5默认值约束FID((0))

AQL-单据头_L

概述
表名称实体名称ORM实体名
T_QM_AQL_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
备注FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_AQL_LCLUSTEREDFPKID
IDX_QM_AQL_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_AQL_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_AQL_L主键约束FPKID
DF__T_QM_AQL___FPKID__4E881247默认值约束FPKID((0))

AQL-单据体

概述
表名称实体名称ORM实体名
V_QM_AQLENTRY单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
代码FCodeCodefcodenvarchar4002000
FValueValuefvaluenvarchar4002000
索引
名称类型字段
主外键
名称类型字段
触发器
名称

1.1.2 物料来源质检规则

物料来源质检规则-单据头

概述
表名称实体名称ORM实体名
T_QM_BDINSPECTRULE单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
检验类型FInspectTypeInspectTypeFINSPECTTYPEchar110('0')
供应商FSupplierIdSupplierIdFSUPPLIERIDint4100
生产车间FWorkshopIdWorkshopIdFWORKSHOPIDint4100((0))
索引
名称类型字段
PK_QM_BDINSPECTRULECLUSTEREDFID
IDX_QM_BDINSPECTRULE_NUMNONCLUSTEREDFNUMBER
IDX_QM_BDINSPECTRULE_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_BDINSPECTRULEPKFID
触发器
约束
名称类型字段描述
PK_QM_BDINSPECTRULE主键约束FID
DF__T_QM_BDINSP__FID__1EA35B6E默认值约束FID((0))
DF__T_QM_BDIN__FMAST__1F977FA7默认值约束FMASTERID((0))
DF__T_QM_BDIN__FINSP__208BA3E0默认值约束FINSPECTTYPE('0')
DF__T_QM_BDIN__FWORK__35EF7036默认值约束FWORKSHOPID((0))

物料来源质检规则-单据头_L

概述
表名称实体名称ORM实体名
T_QM_BDINSPECTRULE_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
备注FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_BDINSPECTRULE_LCLUSTEREDFPKID
IDX_QM_BDINSPECTRULE_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_BDINSPECTRULE_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_BDINSPECTRULE_L主键约束FPKID
DF__T_QM_BDIN__FPKID__2273EC52默认值约束FPKID((0))

物料来源质检规则-单据体

概述
表名称实体名称ORM实体名
T_QM_BDIBRULEENTRY单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
物料编码FMaterialIdMaterialIdFMATERIALIDint4100
当前严格度FCurrentStringencyCurrentStringencyFCURRENTSTRINGENCYchar110('0')
质检方案FQCSchemeIdQCSchemeIdFQCSCHEMEIDint4100
抽样方案FSampleSchemeIdSampleSchemeIdFSAMPLESCHEMEIDint4100
宽严度转换规则FConverRuleConverRuleFCONVERTRULEint4100
生效状态FEffectStatusEffectStatusFEFFECTSTATUSchar110('0')
索引
名称类型字段
PK_QM_BDIBRULEENTRYCLUSTEREDFENTRYID
IDX_QM_BDIBRULEENTRY_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_BDIBRULEENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_BDIBRULEENTRY主键约束FENTRYID
DF__T_QM_BDIB__FENTR__1AD2CA8A默认值约束FENTRYID((0))
DF__T_QM_BDIB__FCURR__1BC6EEC3默认值约束FCURRENTSTRINGENCY('0')
DF__T_QM_BDIB__FEFFE__1CBB12FC默认值约束FEFFECTSTATUS('0')

物料来源质检规则-转换规则表体

概述
表名称实体名称ORM实体名
T_QM_BDIBRULEDETAIL转换规则表体RuleDetailEntity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
严格度FStringencyStringencyFSTRINGENCYchar110('0')
抽样方案FSampleSchemeId1SampleSchemeIdFSAMPLESCHEMEIDint4100
质检方案FQCSchemeId1QCSchemeIdFQCSCHEMEIDint4100
当前严格度FIsCurrentStringencyIsCurrentStringencyFISCURRENTSTRINGENCYchar110('0')
索引
名称类型字段
PK_QM_BDIBRULEDETAILCLUSTEREDFDETAILID
IDX_QM_BDIBDETAIL_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_BDIBRULEDETAILPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_BDIBRULEDETAIL主键约束FDETAILID
DF__T_QM_BDIB__FDETA__1519F134默认值约束FDETAILID((0))
DF__T_QM_BDIB__FENTR__160E156D默认值约束FENTRYID((0))
DF__T_QM_BDIBR__FSEQ__170239A6默认值约束FSEQ((0))
DF__T_QM_BDIB__FSTRI__17F65DDF默认值约束FSTRINGENCY('0')
DF__T_QM_BDIB__FISCU__18EA8218默认值约束FISCURRENTSTRINGENCY('0')

物料来源质检规则-转换记录表体

概述
表名称实体名称ORM实体名
T_QM_BDIBCONVERTRECORD转换记录表体RecordEntity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
转换前严格度FPreStringencyPreStringencyFPRESTRINGENCYchar110('0')
转换前抽样方案FPreSampleSchemeIdPreSampleSchemeIdFPRESAMPLESCHEMEIDint4100
转换前质检方案FPreQCSchemeIdPreQCSchemeIdFPREQCSCHEMEIDint4100
转换后严格度FAftStringencyAftStringencyFAFTSTRINGENCYchar110('0')
转换后抽样方案FAftSampleSchemeIdAftSampleSchemeIdFAFTSAMPLESCHEMEIDint4100
转换后质检方案FAftQCSchemeIdAftQCSchemeIdFAFTQCSCHEMEIDint4100
转换日期FConvertDateConvertDateFCONVERTDATEdatetime8233
计算检验单编号FInspectBillNosInspectBillNosFINSPECTBILLNOSnvarchar5102550
索引
名称类型字段
PK_QM_BDIBCONVERTRECORDCLUSTEREDFDETAILID
IDX_QM_BDIBRECORD_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_BDIBCONVERTRECORDPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_BDIBCONVERTRECORD主键约束FDETAILID
DF__T_QM_BDIB__FDETA__0F6117DE默认值约束FDETAILID((0))
DF__T_QM_BDIB__FENTR__10553C17默认值约束FENTRYID((0))
DF__T_QM_BDIBC__FSEQ__11496050默认值约束FSEQ((0))
DF__T_QM_BDIB__FPRES__123D8489默认值约束FPRESTRINGENCY('0')
DF__T_QM_BDIB__FAFTS__1331A8C2默认值约束FAFTSTRINGENCY('0')

1.1.3 不良品处理单

不良品处理单-单据头

概述
表名称实体名称ORM实体名
T_QM_DEFECTPROCESS单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
单据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
审核人FApproverIdApproverIdFAPPROVERIDint4100
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
作废日期FCancelDateCancelDateFCANCELDATEdatetime8233
作废人FCancelerCANCELERFCANCELERint4100
作废状态FCancelStatusCancelStatusFCANCELSTATUSchar110
单据类型FBillTypeIDFBillTypeIDFBILLTYPEIDvarchar36360
业务类型FBusinessTypeBusinessTypeFBUSINESSTYPEvarchar220('0')
单据日期FDateDateFDATEdatetime8233
来源组织FSourceOrgIdSourceOrgIdFSOURCEORGIDint4100
质检组织FInspectOrgIdINSPECTOrgIdFINSPECTORGIDint4100
部门FInspectDepIdInspectDepIdFINSPECTDEPIDint4100
质检员FInspectorIdInspectorIdFINSPECTORIDint4100
质检组FInspectGroupIdInspectGroupIdFINSPECTGROUPIDint4100
索引
名称类型字段
PK_QM_DEFECTPROCESSCLUSTEREDFID
IDX_QM_DEFECTPROC_NONONCLUSTEREDFBILLNO
IDX_QM_DEFECTPROC_DATENONCLUSTEREDFDATE
主外键
名称类型字段
PK_QM_DEFECTPROCESSPKFID
触发器
约束
名称类型字段描述
PK_QM_DEFECTPROCESS主键约束FID
DF__T_QM_DEFECT__FID__3184214A默认值约束FID((0))
DF__T_QM_DEFE__FBUSI__32784583默认值约束FBUSINESSTYPE('0')

不良品处理单-单据头_L

概述
表名称实体名称ORM实体名
T_QM_DEFECTPROCESS_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
备注FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_DEFECTPROCESS_LCLUSTEREDFPKID
IDX_QM_DEFECTPROCESS_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_DEFECTPROCESS_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_DEFECTPROCESS_L主键约束FPKID
DF__T_QM_DEFECT__FID__34608DF5默认值约束FID((0))

不良品处理单-单据体

概述
表名称实体名称ORM实体名
T_QM_DEFECTPROCESSENTRY单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
物料编码FMateridlIdMateridlIdFMATERIALIDint4100
供应商FSupplierIdSupplierIdFSUPPLIERIDint4100
批号FLotFLotFLOTint4100
单位FUnitIDUnitIDFUNITIDint4100
检验单使用决策FUsePolicyUsePolicyFUSEPOLICYchar110(' ')
检验不良数量FInspectDefectQtyInspectDefectQtyFINSPECTDEFECTQTYdecimal132310((0))
关闭状态FBillStatusFBillStatusFBILLSTATUSchar110('0')
币别FCurrencyCurrencyFCURRENCYint4100
费用项目FExpenseExpenseFEXPENSEint4100
结算组织FSettlOrgIdSettlOrgIdFSETTLORGIDint4100
采购组织FPurOrgIdPurOrgIdFPURORGIDint4100
源单类型FSourceBillTypeSourceBillTypeFSOURCEBILLTYPEvarchar36360
源单编号FSourceBillNoSourceBillNoFSOURCEBILLNOnvarchar160800
源单内码FSourceBillIdSourceBillIdFSOURCEBILLIDint4100
源单分录内码FSourceBillEntryIdSourceBillEntryIdFSOURCEBILLENTRYIDint4100
源单行号FSourceSeqSourceSeqFSOURCESEQint4100
基本单位检验不良数量FBaseInspectDefectQtyBaseInspectDefectQtyFBASEINSPECTDEFECTQTYdecimal132310((0))
基本单位FBaseUnitIDBaseUnitIDFBASEUNITIDint4100
不良处理FDefProcessDefProcessFDEFPROCESSchar110('0')
不良数量FDefectiveQtyDefectiveQtyFDEFECTIVEQTYdecimal132310((0))
是否折让FIsDiscountIsDiscountFISDISCOUNTchar110('0')
源单使用决策表体内码FSourceBillDetailIdSourceBillDetailIdFSOURCEBILLDETAILIDint4100
基本单位不良数量FBaseDefectQtyBaseDefectQtyFBASEDEFECTQTYdecimal132310((0))
折让金额FDiscountQtyDiscountQtyFDISCOUNTQTYdecimal132310((0))
折让选单金额FDisCountSelectQtyDisCountSelectQtyFDISCOUNTSELECTQTYdecimal132310((0))
客户FCustomerIdCustomerIdFCUSTOMERIDint4100((0))
销售组织FSalOrgIdSalOrgIdFSALORGIDint4100((0))
判退FIsReturnIsReturnFISRETURNchar110('1')
MRB分录内码FMRBEntryIdMRBEntryIdFMRBENTRYIDint4100((0))
生产车间FWorkShopIdWorkShopIdFWORKSHOPIDint4100((0))
工序号FOperNumberOperNumberFOPERNUMBERint4100((0))
序列号单位FSNUnitIdSNUnitIdFSNUNITIDint4100((0))
序列号FSerialIdSerialIdFSERIALIDint4100((0))
辅助属性FAuxPropIdAuxPropIdFAUXPROPIDint4100((0))
生产单位FPrdUnitIdPrdUnitIdFPRDUNITIDint4100((0))
单位转换表头数量FUnitTransHeadQtyUnitTransHeadQtyFUNITTRANSHEADQTYdecimal132310((0))
单位转换工序数量FUnitTransOperQtyUnitTransOperQtyFUNITTRANSOPERQTYdecimal132310((0))
标准应付抵扣FStdPayDeductionStdPayDeductionFSTDPAYDEDUCTIONchar110('0')
MRB评审FIsMRBReviewIsMRBReviewFISMRBREVIEWchar110('0')
检验单辅助属性FQcAuXPropIdQcAuXPropIdFQCAUXPROPIDint4100((0))
检验单序列号FQcSerialIdQcSerialIdFQCSERIALIDint4100((0))
可销售FCanSaleCanSaleFCANSALEchar110('0')
索引
名称类型字段
PK_QM_DEFECTPROCESSENTRYCLUSTEREDFENTRYID
IDX_QM_DPE_IDNONCLUSTEREDFID
IDX_QM_DPE_MTRLIDNONCLUSTEREDFMATERIALID
主外键
名称类型字段
PK_QM_DEFECTPROCESSENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_DEFECTPROCESSENTRY主键约束FENTRYID
DF__T_QM_DEFE__FAUXP__0D29F29F默认值约束FAUXPROPID((0))
DF__T_QM_DEFE__FSERI__228F23D9默认值约束FSERIALID((0))
DF__T_QM_DEFE__FSNUN__23834812默认值约束FSNUNITID((0))
DF__T_QM_DEFE__FCANS__2DDC7A7E默认值约束FCANSALE('0')
DF__T_QM_DEFE__FISMR__3A71CC2C默认值约束FISMRBREVIEW('0')
DF__T_QM_DEFE__FQCAU__3B65F065默认值约束FQCAUXPROPID((0))
DF__T_QM_DEFE__FQCSE__3C5A149E默认值约束FQCSERIALID((0))
DF__T_QM_DEFECT__FID__3EDE1C68默认值约束FID((0))
DF__T_QM_DEFE__FENTR__3FD240A1默认值约束FENTRYID((0))
DF__T_QM_DEFE__FSTDP__40B31EB9默认值约束FSTDPAYDEDUCTION('0')
DF__T_QM_DEFEC__FSEQ__40C664DA默认值约束FSEQ((0))
DF__T_QM_DEFE__FISRE__40F3AF68默认值约束FISRETURN('1')
DF__T_QM_DEFE__FUSEP__41BA8913默认值约束FUSEPOLICY(' ')
DF__T_QM_DEFE__FINSP__42AEAD4C默认值约束FINSPECTDEFECTQTY((0))
DF__T_QM_DEFE__FDISC__43A2D185默认值约束FDISCOUNTSUMQTY((0))
DF__T_QM_DEFE__FBILL__4496F5BE默认值约束FBILLSTATUS('0')
DF__T_QM_DEFE__FBASE__458B19F7默认值约束FBASEINSPECTDEFECTQTY((0))
DF__T_QM_DEFE__FBASE__467F3E30默认值约束FBASEDEFECTQTY((0))
DF__T_QM_DEFE__FDISC__47736269默认值约束FDISCOUNTSELECTQTY((0))
DF__T_QM_DEFE__FDEFP__486786A2默认值约束FDEFPROCESS('0')
DF__T_QM_DEFE__FDEFE__495BAADB默认值约束FDEFECTIVEQTY((0))
DF__T_QM_DEFE__FISDI__4A4FCF14默认值约束FISDISCOUNT('0')
DF__T_QM_DEFE__FDISC__4B43F34D默认值约束FDISCOUNTQTY((0))
DF__T_QM_DEFE__FPRDU__559E8A9D默认值约束FPRDUNITID((0))
DF__T_QM_DEFE__FUNIT__5692AED6默认值约束FUNITTRANSHEADQTY((0))
DF__T_QM_DEFE__FUNIT__5786D30F默认值约束FUNITTRANSOPERQTY((0))
DF__T_QM_DEFE__FSALO__5868E441默认值约束FSALORGID((0))
DF__T_QM_DEFE__FCUST__595D087A默认值约束FCUSTOMERID((0))
DF__T_QM_DEFE__FWORK__6C331328默认值约束FWORKSHOPID((0))
DF__T_QM_DEFE__FOPER__6D273761默认值约束FOPERNUMBER((0))
DF__T_QM_DEFE__FMRBE__728B0AFC默认值约束FMRBENTRYID((0))

不良品处理单-单据体_A

概述
表名称实体名称ORM实体名
T_QM_DEFECTPROCESSENTRY_A单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
BOM版本FBomIdBomIdFBOMIDint4100((0))
生产日期FProduceDateProduceDateFPRODUCEDATEdatetime8233
有效期至FExpiryDateExpiryDateFEXPIRYDATEdatetime8233
计划跟踪号FMtoNoMtoNoFMTONOnvarchar5102550
货主类型FOwnerTypeIdOwnerTypeIdFOWNERTYPEIDvarchar36360
货主FOwnerIdOwnerIdFOWNERIDint4100((0))
保管者类型FKeeperTypeIdKeeperTypeIdFKEEPERTYPEIDvarchar36360
保管者FKeeperIdKeeperIdFKEEPERIDint4100((0))
库存组FStockGroupIdStockGroupIdFSTOCKGROUPIDint4100((0))
仓管员FStockerIdStockerIdFSTOCKERIDint4100((0))
基本单位入库选单数量FBaseStockInSelQtyBaseStockInSelQtyFBASESTOCKINSELQTYdecimal132310((0))
入库选单数量FStockInSelQtyStockInSelQtyFSTOCKINSELQTYdecimal132310((0))
仓库FStockIdStockIdFSTOCKIDint4100((0))
仓位FStockLocIdStockLocIdFSTOCKLOCIDint4100((0))
新有效期至FNewExpiryDateNewExpiryDateFNEWEXPIRYDATEdatetime8233
反写检验单折让金额FSrcDiscountSrcDiscountFSRCDISCOUNTdecimal132310((0))
索引
名称类型字段
PK_QM_DEFECTPROCESSENTRY_ACLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_DEFECTPROCESSENTRY_APKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_DEFECTPROCESSENTRY_A主键约束FENTRYID
DF__T_QM_DEFECT__FID__3B3E3D2C默认值约束FID((0))
DF__T_QM_DEFE__FENTR__3C326165默认值约束FENTRYID((0))
DF__T_QM_DEFE__FBOMI__3D26859E默认值约束FBOMID((0))
DF__T_QM_DEFE__FOWNE__3E1AA9D7默认值约束FOWNERID((0))
DF__T_QM_DEFE__FSTOC__3F0ECE10默认值约束FSTOCKGROUPID((0))
DF__T_QM_DEFE__FKEEP__4002F249默认值约束FKEEPERID((0))
DF__T_QM_DEFE__FSTOC__40F71682默认值约束FSTOCKERID((0))
DF__T_QM_DEFE__FBASE__41EB3ABB默认值约束FBASESTOCKINSELQTY((0))
DF__T_QM_DEFE__FSTOC__42DF5EF4默认值约束FSTOCKINSELQTY((0))
DF__T_QM_DEFE__FSTOC__5221A284默认值约束FSTOCKID((0))
DF__T_QM_DEFE__FSTOC__5315C6BD默认值约束FSTOCKLOCID((0))
DF__T_QM_DEFE__FSRCD__7139B43C默认值约束FSRCDISCOUNT((0))

不良品处理单-单据体_L

概述
表名称实体名称ORM实体名
T_QM_DEFECTPROCESSENTRY_L单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
工序说明FOperDescriptionOperDescriptionFOPERDESCRIPTIONnvarchar200010000
使用决策备注FMemoMemoFMEMOnvarchar5102550
索引
名称类型字段
PK_QM_DEFECTPROCESSENTRY_LCLUSTEREDFPKID
主外键
名称类型字段
PK_QM_DEFECTPROCESSENTRY_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_DEFECTPROCESSENTRY_L主键约束FPKID
DF__T_QM_DEFE__FPKID__6F0F7FD3默认值约束FPKID((0))

不良品处理单-子单据体

概述
表名称实体名称ORM实体名
T_QM_DEFECTPROCESSRDETAIL子单据体RefEntity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
源单类型FSrcBillTypeSrcBillTypeFSRCBILLTYPEvarchar36360
源单编号FSrcBillNoSrcBillNoFSRCBILLNOnvarchar160800
源单内码FSrcInterIdSrcInterIdFSRCINTERIDint4100
源单分录行号FSRCENTRYSEQSrcEntrySeqFSRCENTRYSEQint4100
源单分录内码FSrcEntryIdSrcEntryIdFSRCENTRYIDint4100
订单类型FOrderTypeOrderTypeFORDERTYPEvarchar36360
订单编号FOrderBillNoOrderBillNoFORDERBILLNOnvarchar160800
订单内码FOrderIdOrderIdFORDERIDint4100
订单分录行号FOrderEntrySeqOrderEntrySeqFORDERENTRYSEQint4100
订单分录内码FOrderEntryIdOrderEntryIdFORDERENTRYIDint4100
索引
名称类型字段
PK_QM_DEFECTPROCESSRDETAILCLUSTEREDFDETAILID
IDX_QM_DPRD_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_DEFECTPROCESSRDETAILPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_DEFECTPROCESSRDETAIL主键约束FDETAILID
DF__T_QM_DEFE__FDETA__3648D667默认值约束FDETAILID((0))
DF__T_QM_DEFE__FENTR__373CFAA0默认值约束FENTRYID((0))
DF__T_QM_DEFEC__FSEQ__38311ED9默认值约束FSEQ((0))

不良品处理单-关联关系表

概述
表名称实体名称ORM实体名
T_QM_DEFECTPROCESSENTRY_LK关联关系表FEntity_Link
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值
业务流程图FEntity_Link_FFlowIdFlowIdFFLOWIDvarchar36360
推进路线FEntity_Link_FFlowLineIdFlowLineIdFFLOWLINEIDint4100
转换规则FEntity_Link_FRuleIdRuleIdFRULEIDvarchar36360
源单表内码FEntity_Link_FSTableIdSTableIdFSTABLEIDint4100
源单表FEntity_Link_FSTableNameSTableNameFSTABLENAMEvarchar30300
源单内码FEntity_Link_FSBillIdSBillIdFSBILLIDvarchar36360
源单分录内码FEntity_Link_FSIdSIdFSIDvarchar36360
原始携带量FEntity_Link_FBaseInspectDefectQtyOldBaseInspectDefectQtyOldFBASEINSPECTDEFECTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseInspectDefectQtyBaseInspectDefectQtyFBASEINSPECTDEFECTQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseDefectQtyOldBaseDefectQtyOldFBASEDEFECTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseDefectQtyBaseDefectQtyFBASEDEFECTQTYdecimal132310((0))
原始携带量FEntity_Link_FDiscountQtyOldDiscountQtyOldFDISCOUNTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FDiscountQtyDiscountQtyFDISCOUNTQTYdecimal132310((0))
原始携带量FEntity_Link_FSrcDiscountOldSrcDiscountOldFSRCDISCOUNTOLDdecimal132310((0))
修改携带量FEntity_Link_FSrcDiscountSrcDiscountFSRCDISCOUNTdecimal132310((0))
索引
名称类型字段
PK_QM_DEFECTPROCESSENTRY_LKCLUSTEREDFLINKID
IDX_QM_DPE_LK_SIDNONCLUSTEREDFSID
IDX_QM_DPE_LK_SBILLIDNONCLUSTEREDFSBILLID
IDX_QM_DPE_LK_ENTRYDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_DEFECTPROCESSENTRY_LKPKFLINKID
触发器
约束
名称类型字段描述
PK_QM_DEFECTPROCESSENTRY_LK主键约束FLINKID
DF__T_QM_DEFE__FDISC__41A742F2默认值约束FDISCOUNTQTYOLD((0))
DF__T_QM_DEFE__FDISC__429B672B默认值约束FDISCOUNTQTY((0))
DF__T_QM_DEFE__FBASE__4D2C3BBF默认值约束FBASEINSPECTDEFECTQTY((0))
DF__T_QM_DEFE__FBASE__4E205FF8默认值约束FBASEINSPECTDEFECTQTYOLD((0))
DF__T_QM_DEFE__FBASE__4F148431默认值约束FBASEDEFECTQTY((0))
DF__T_QM_DEFE__FBASE__5008A86A默认值约束FBASEDEFECTQTYOLD((0))
DF__T_QM_DEFE__FSRCD__722DD875默认值约束FSRCDISCOUNT((0))
DF__T_QM_DEFE__FSRCD__7321FCAE默认值约束FSRCDISCOUNTOLD((0))

1.1.4 缺陷原因

缺陷原因-单据头

概述
表名称实体名称ORM实体名
T_QM_DEFECTREASON单据头DefectReasonView
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
系统预设FIsSystemSetIsSystemSetFISSYSTEMSETchar110('0')
索引
名称类型字段
PK_QM_DEFECTREASONCLUSTEREDFID
IDX_QM_DEFECTREASON_NUMNONCLUSTEREDFNUMBER
IDX_QM_DEFECTREASON_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_DEFECTREASONPKFID
触发器
约束
名称类型字段描述
PK_QM_DEFECTREASON主键约束FID
DF__T_QM_DEFECT__FID__50705AB9默认值约束FID((0))
DF__T_QM_DEFE__FMAST__51647EF2默认值约束FMASTERID((0))
DF__T_QM_DEFE__FISSY__5258A32B默认值约束FISSYSTEMSET('0')

缺陷原因-单据头_L

概述
表名称实体名称ORM实体名
T_QM_DEFECTREASON_L单据头DefectReasonView
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_DEFECTREASON_LCLUSTEREDFPKID
IDX_QM_DEFECTREASON_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_DEFECTREASON_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_DEFECTREASON_L主键约束FPKID
DF__T_QM_DEFE__FPKID__5440EB9D默认值约束FPKID((0))

1.1.5 缺陷后果

缺陷后果-单据头

概述
表名称实体名称ORM实体名
T_QM_DEFECTRESULT单据头DefectResultView
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
系统预设FIsSystemSetIsSystemSetFISSYSTEMSETchar110('0')
索引
名称类型字段
PK_QM_DEFECTRESULTCLUSTEREDFID
IDX_QM_DEFECTRESULT_NUMNONCLUSTEREDFNUMBER
IDX_QM_DEFECTRESULT_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_DEFECTRESULTPKFID
触发器
约束
名称类型字段描述
PK_QM_DEFECTRESULT主键约束FID
DF__T_QM_DEFECT__FID__5629340F默认值约束FID((0))
DF__T_QM_DEFE__FMAST__571D5848默认值约束FMASTERID((0))
DF__T_QM_DEFE__FISSY__58117C81默认值约束FISSYSTEMSET('0')

缺陷后果-单据头_L

概述
表名称实体名称ORM实体名
T_QM_DEFECTRESULT_L单据头DefectResultView
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_DEFECTRESULT_LCLUSTEREDFPKID
IDX_QM_DEFECTRESULT_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_DEFECTRESULT_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_DEFECTRESULT_L主键约束FPKID
DF__T_QM_DEFE__FPKID__6D0C9967默认值约束FPKID((0))

1.1.6 缺陷类型

缺陷类型-单据头

概述
表名称实体名称ORM实体名
T_QM_DEFECTTYPE单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
系统预设FIsSystemSetIsSystemSetFISSYSTEMSETchar110('0')
组别FGroupGroupFGROUPint4100
索引
名称类型字段
PK_QM_DEFECTTYPECLUSTEREDFID
IDX_QM_DETECTTYPE_NUMNONCLUSTEREDFNUMBER
IDX_QM_DETECTTYPE_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_DEFECTTYPEPKFID
触发器
约束
名称类型字段描述
PK_QM_DEFECTTYPE主键约束FID
DF__T_QM_DEFECT__FID__59F9C4F3默认值约束FID((0))
DF__T_QM_DEFE__FMAST__5AEDE92C默认值约束FMASTERID((0))
DF__T_QM_DEFE__FISSY__5BE20D65默认值约束FISSYSTEMSET('0')

缺陷类型-单据头_L

概述
表名称实体名称ORM实体名
T_QM_DEFECTTYPE_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_DEFECTTYPE_LCLUSTEREDFPKID
IDX_QM_DEFECTTYPE_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_DEFECTTYPE_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_DEFECTTYPE_L主键约束FPKID
DF__T_QM_DEFE__FPKID__1FCD235E默认值约束FPKID((0))

1.1.7 检验项目对应检测值

检验项目对应检测值-单据头

概述
表名称实体名称ORM实体名
V_QM_IIIVRELATED单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检验项目编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdFCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdFUseOrgIdFUSEORGIDint4100
分析方法FAnalysisMethodFAnalysisMethodFANALYSISMETHODchar110
组别FGroupFGroupFGROUPint4100
索引
名称类型字段
主外键
名称类型字段
触发器
名称

检验项目对应检测值-单据头_L

概述
表名称实体名称ORM实体名
V_QM_IIIVRELATED_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检验项目名称FNameNameFNAMEnvarchar2001000
索引
名称类型字段
主外键
名称类型字段
触发器
名称

检验项目对应检测值-检测值单据体

概述
表名称实体名称ORM实体名
T_QM_IIIVRELATEDENTRY检测值单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检测值编码FInspectValueIdInspectValueIdFINSPECTVALUEIDint4100
是否目标值FIsTargetValueIsTargetValueFISTARGETVALUEchar110('0')
默认值FIsDefaultValueIsDefaultValueFISDEFAULTVALUEchar110('0')
索引
名称类型字段
PK_QM_IIIVRELATEDENTRYCLUSTEREDFENTRYID
IDX_QM_IIIVRELATEDE_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_IIIVRELATEDENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_IIIVRELATEDENTRY主键约束FENTRYID
DF__T_QM_IIIV__FISTA__1BBE3206默认值约束FISTARGETVALUE('0')
DF__T_QM_IIIV__FISDE__587AF748默认值约束FISDEFAULTVALUE('0')
DF__T_QM_IIIV__FENTR__671F813E默认值约束FENTRYID((0))

1.1.8 检验依据

检验依据-单据头

概述
表名称实体名称ORM实体名
T_QM_INSPECTBASIS单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
索引
名称类型字段
PK_QM_INSPECTBASISCLUSTEREDFID
IDX_QM_INSPECTBASIS_NUMNONCLUSTEREDFNUMBER
IDX_QM_INSPECTBASIS_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_INSPECTBASISPKFID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBASIS主键约束FID
DF__T_QM_INSPEC__FID__21B56BD0默认值约束FID((0))
DF__T_QM_INSP__FMAST__22A99009默认值约束FMASTERID((0))

检验依据-单据头_L

概述
表名称实体名称ORM实体名
T_QM_INSPECTBASIS_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_INSPECTBASIS_LCLUSTEREDFPKID
IDX_QM_INSPECTBASIS_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_INSPECTBASIS_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBASIS_L主键约束FPKID
DF__T_QM_INSP__FPKID__2491D87B默认值约束FPKID((0))

1.1.9 检验单

检验单-单据头

概述
表名称实体名称ORM实体名
T_QM_INSPECTBILL单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
单据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
审核人FApproverIdApproverIdFAPPROVERIDint4100
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
作废日期FCancelDateCancelDateFCANCELDATEdatetime8233
作废人FCancelerCANCELERFCANCELERint4100
作废状态FCancelStatusCancelStatusFCANCELSTATUSchar110
单据类型FBillTypeIDFBillTypeIDFBILLTYPEIDvarchar36360
来源组织FSourceOrgIdSourceOrgIdFSOURCEORGIDint4100
质检组织FInspectOrgIdInspectOrgIdFINSPECTORGIDint4100
检验部门FInspectDepIdInspectDepIdFINSPECTDEPIDint4100
质检员FInspectorIdInspectorIdFINSPECTORIDint4100
业务类型FBusinessTypeBusinessTypeFBUSINESSTYPEvarchar220('0')
单据日期FDateFDateFDATEdatetime8233
质检组FInspectGroupIdInspectGroupIdFINSPECTGROUPIDint4100
是否已同步FIsSyncedIsSyncedFISSYNCEDchar110
收料员F_QPKY_UserIdF_QPKY_UserIdF_QPKY_USERIDint4100((0))
收料日期F_RZYI_DateF_RZYI_DateF_RZYI_DATEdatetime8233
检验员F_SG_JYYF_SG_JYYF_SG_JYYnvarchar2001000('')
索引
名称类型字段
PK_QM_INSPECTBILLCLUSTEREDFID
IDX_QM_INSPECTBILL_NONONCLUSTEREDFBILLNO
IDX_QM_INSPECTBILL_DATENONCLUSTEREDFDATE
主外键
名称类型字段
PK_QM_INSPECTBILLPKFID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBILL主键约束FID
DF__T_QM_INSP__F_QPK__280CFBE1默认值约束F_QPKY_USERID((0))
DF__T_QM_INSP__F_SG___47EB294E默认值约束F_SG_JYY('')
DF__T_QM_INSP__FBUSI__7F2C14F9默认值约束FBUSINESSTYPE('0')
DF__T_QM_INSPEC__FID__7E37F0C0默认值约束FID((0))

检验单-单据头_L

概述
表名称实体名称ORM实体名
T_QM_INSPECTBILL_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_INSPECTBILL_LCLUSTEREDFPKID
IDX_QM_INSPECTBILL_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_INSPECTBILL_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBILL_L主键约束FPKID
DF__T_QM_INSP__FPKID__6E0188F7默认值约束FPKID((0))

检验单-主表体

概述
表名称实体名称ORM实体名
T_QM_INSPECTBILLENTRY主表体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
质检方案FQCSchemeIdQCSchemeIdFQCSCHEMEIDint4100
单位FUnitIDUnitIdFUNITIDint4100
检验数量FInspectQtyInspectQtyFINSPECTQTYdecimal132310((0))
供应商FSupplierIdSupplierIdFSUPPLIERIDint4100
生产车间FWorkshopIdWorkshopIdFWORKSHOPIDint4100
仓库FStockIdStockIdFSTOCKIDint4100
仓位FStockLocIdStockLocIdFSTOCKLOCIDint4100
批号FLotLotFLOTint4100
检验次数FInspectTimesInspectTimesFINSPECTTIMESint4100
时间单位FTimeUnitTimeUnitFTIMEUNITint4100
耗用时间FConsumeTimeConsumeTimeFCONSUMETIMEdecimal9196
合格数FQualifiedQtyQualifiedQtyFQUALIFIEDQTYdecimal132310((0))
不合格数FUnqualifiedQtyUnqualifiedQtyFUNQUALIFIEDQTYdecimal132310((0))
样本破坏数FSampleDamageQtySampleDamageQtyFSAMPLEDAMAGEQTYdecimal132310((0))
基本单位合格数FBaseQualifiedQtyBaseQualifiedQtyFBASEQUALIFIEDQTYdecimal132310((0))
基本单位不合格数FBaseUnqualifiedQtyBaseUnqualifiedQtyFBASEUNQUALIFIEDQTYdecimal132310((0))
抽样方案FSampleSchemeIdSampleSchemeIdFSAMPLESCHEMEIDint4100
质检开始日期FInspectStartDateInspectStartDateFINSPECTSTARTDATEdatetime8233
质检结束日期FInspectEndDateInspectEndDateFINSPECTENDDATEdatetime8233
允收数FAcceptQtyAcceptQtyFACCEPTQTYint4100
拒收数FRejectQtyRejectQtyFREJECTQTYint4100
样本不合格数FSUnqualifiedQtySUnqualifiedQtyFSUNQUALIFIEDQTYdecimal132310((0))
基本单位样本不合格数FBaseSUnqualifiedQtyBaseSUnqualifiedQtyFBASESUNQUALIFIEDQTYdecimal132310((0))
样本量FSampleQtySampleQtyFSAMPLEQTYint4100
质检状态FQCStatusQCStatusFQCSTATUSchar110('0')
检验单关联标志FIsRelatedIsRelatedFISRELATEDchar110('0')
工序号FOperNumberOperNumberFOPERNUMBERint4100((0))
单位转换表头数量FUnitTransHeadQtyUnitTransHeadQtyFUNITTRANSHEADQTYdecimal132310((0))
单位转换工序数量FUnitTransOperQtyUnitTransOperQtyFUNITTRANSOPERQTYdecimal132310((0))
生产单位FPrdUnitIdPrdUnitIdFPRDUNITIDint4100
辅助属性FAuxPropIdAuxPropIdFAUXPROPIDint4100((0))
序列号单位FSNUnitIDSNUnitIDFSNUNITIDint4100((0))
客户FCustomerIdCustomerIdFCUSTOMERIDint4100((0))
图片FPicturePictureFPICTUREnvarchar5102550
操作指导书FAttachmentAttachmentFATTACHMENTnvarchar5102550
供应商批号FSupplierLotSupplierLotFSUPPLIERLOTnvarchar5102550
生产日期FProduceDateProduceDateFPRODUCEDATEdatetime8233
有效期至FExpiryDateExpiryDateFEXPIRYDATEdatetime8233
币别FCurrencyCurrencyFCURRENCYint4100((0))
折让金额FDiscountQtyDiscountQtyFDISCOUNTQTYdecimal132310((0))
是否拆分行FIsSplitRowIsSplitRowFISSPLITROWchar110('0')
货主类型FOwnerTypeIdOwnerTypeIdFOWNERTYPEIDvarchar36360
货主FOwnerIdOwnerIdFOWNERIDint4100((0))
保管者类型FKeeperTypeIdKeeperTypeIdFKEEPERTYPEIDvarchar36360
保管者FKeeperIdKeeperIdFKEEPERIDint4100((0))
索引
名称类型字段
PK_QM_INSPECTBILLENTRYCLUSTEREDFENTRYID
IDX_QM_IBE_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_INSPECTBILLENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBILLENTRY主键约束FENTRYID
DF__T_QM_INSP__FCUST__00ABDFC5默认值约束FCUSTOMERID((0))
DF__T_QM_INSP__FOWNE__023AC206默认值约束FOWNERID((0))
DF__T_QM_INSP__FKEEP__032EE63F默认值约束FKEEPERID((0))
DF__T_QM_INSP__FENTR__04E4EE4F默认值约束FENTRYID((0))
DF__T_QM_INSP__FOPER__0584D824默认值约束FOPERNUMBER((0))
DF__T_QM_INSP__FQCST__05D91288默认值约束FQCSTATUS('0')
DF__T_QM_INSP__FUNIT__0678FC5D默认值约束FUNITTRANSHEADQTY((0))
DF__T_QM_INSP__FISRE__06CD36C1默认值约束FISRELATED('0')
DF__T_QM_INSP__FUNIT__076D2096默认值约束FUNITTRANSOPERQTY((0))
DF__T_QM_INSP__FINSP__07C15AFA默认值约束FINSPECTQTY((0))
DF__T_QM_INSP__FQUAL__08B57F33默认值约束FQUALIFIEDQTY((0))
DF__T_QM_INSP__FUNQU__09A9A36C默认值约束FUNQUALIFIEDQTY((0))
DF__T_QM_INSP__FSUNQ__0A9DC7A5默认值约束FSUNQUALIFIEDQTY((0))
DF__T_QM_INSP__FSAMP__0B91EBDE默认值约束FSAMPLEDAMAGEQTY((0))
DF__T_QM_INSP__FBASE__0C861017默认值约束FBASEQUALIFIEDQTY((0))
DF__T_QM_INSP__FBASE__0D7A3450默认值约束FBASEUNQUALIFIEDQTY((0))
DF__T_QM_INSP__FBASE__0E6E5889默认值约束FBASESUNQUALIFIEDQTY((0))
DF__T_QM_INSP__FSNUN__18B87380默认值约束FSNUNITID((0))
DF__T_QM_INSP__FISSP__22CF4CC5默认值约束FISSPLITROW('0')
DF__T_QM_INSP__FCURR__3ECAD647默认值约束FCURRENCY((0))
DF__T_QM_INSP__FDISC__3FBEFA80默认值约束FDISCOUNTQTY((0))
DF__T_QM_INSP__FAUXP__4259A791默认值约束FAUXPROPID((0))

检验单-主表体_A

概述
表名称实体名称ORM实体名
T_QM_INSPECTBILLENTRY_A主表体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
物料编码FMaterialIdMaterialIdFMATERIALIDint4100
基本单位FBaseUnitIdBaseUnitIdFBASEUNITIDint4100
基本单位检验数量FBaseInspectQtyBaseInspectQtyFBASEINSPECTQTYdecimal132310((0))
样本破坏承担方FSampleDamageBearerSampleDamageBearerFSAMPLEDAMAGEBEARERchar110('0')
基本单位样本破坏数FBaseSampleDamageQtyBaseSampleDamageQtyFBASESAMPLEDAMAGEQTYdecimal132310((0))
检验结果FInspectResultInspectResultFINSPECTRESULTchar110('0')
源单类型FSrcBillType0SrcBillTypeFSRCBILLTYPEvarchar36360
源单编号FSrcBillNo0SrcBillNoFSRCBILLNOnvarchar160800
源单内码FSrcInterId0SrcInterIdFSRCINTERIDint4100
源单分录内码FSrcEntryId0SrcEntryIdFSRCENTRYIDint4100
源单行号FSrcEntrySeq0SrcEntrySeqFSRCENTRYSEQint4100
基本单位接收数量FBaseAcceptQtyBaseAcceptQtyFBASEACCEPTQTYdecimal132310((0))
基本单位判退数量FBaseRejectQtyBaseRejectQtyFBASEREJECTQTYdecimal132310((0))
基本单位不良数量FBaseDefectQtyBaseDefectQtyFBASEDEFECTQTYdecimal132310((0))
基本单位报废数量FBaseScrapQtyBaseScrapQtyFBASESCRAPQTYdecimal132310((0))
基本单位返修数量FBaseRepairQtyBaseRepairQtyFBASEREPAIRQTYdecimal132310((0))
基本单位挑选数量FBasePickQtyBasePickQtyFBASEPICKQTYdecimal132310((0))
质检子单据标识FQCFormIdQCFormIdFFORMIDvarchar36360
质检子单据编号FQCBillNoQCBillNoFBILLNOnvarchar160800
质检业务类型FQCBusinessTypeQCBusinessTypeFQCBUSINESSTYPEvarchar220('0')
业务流程FBFLowIdFBFLowIdFBFLOWIDvarchar36360(' ')
基本单位料废数量FBaseMtrlScrapQtyBaseMtrlScrapQtyFBASEMTRLSCRAPQTYdecimal132310((0))
基本单位工废数量FBaseProcScrapQtyBaseProcScrapQtyFBASEPROCSCRAPQTYdecimal132310((0))
基本单位让步接收数量FBaseReAcceptQtyBaseReAcceptQtyFBASEREACCEPTQTYdecimal132310((0))
基本单位反写检验数量FBaseWBInspectQtyBaseWBInspectQtyFBASEWBINSPECTQTYdecimal132310((0))
首检FIsFirstInspectIsFirstInspectFISFIRSTINSPECTchar110('0')
生产线FProductLineIdProductLineIdFPRODUCTLINEIDint4100((0))
工位/工序编码FPrdLineLocationPrdLineLocationFPRDLINELOCATIONint4100((0))
基本单位不合格可销售数量FBaseUnQuaSalQtyBaseUnQuaSalQtyFBASEUNQUASALQTYdecimal132310((0))
基本单位返工数量FBaseReMadeQtyBaseReMadeQtyFBASEREMADEQTYdecimal132310((0))
新有效期至FNewExpiryDateNewExpiryDateFNEWEXPIRYDATEdatetime8233
基本单位报废品入库选单数量FBaseStockInScrapSelQtyBaseStockInScrapSelQtyFBASESTOCKINSCRAPSELQTYdecimal132310((0))
基本单位不合格品入库选单数量FBaseStockInFailSelQtyBaseStockInFailSelQtyFBASESTOCKINFAILSELQTYdecimal132310((0))
基本单位合格品入库选单数量FBaseStockInQuaSelQtyBaseStockInQuaSelQtyFBASESTOCKINQUASELQTYdecimal132310((0))
合格品入库选单数量FStockInQuaSelQtyStockInQuaSelQtyFSTOCKINQUASELQTYdecimal132310((0))
不合格品入库选单数量FStockInFailSelQtyStockInFailSelQtyFSTOCKINFAILSELQTYdecimal132310((0))
报废品入库选单数量FStockInScrapSelQtyStockInScrapSelQtyFSTOCKINSCRAPSELQTYdecimal132310((0))
基本单位来料不良数量FBaseIncDefectQtyBaseIncDefectQtyFBASEINCDEFECTQTYdecimal132310((0))
基本单位作业不良数量FBaseProDefectQtyBaseProDefectQtyFBASEPRODEFECTQTYdecimal132310((0))
当前严格度FCurrentStringencyCurrentStringencyFCURRENTSTRINGENCYchar110('1')
BOM版本FBomIdBomIdFBOMIDint4100((0))
计划跟踪号FMtoNoMtoNoFMTONOnvarchar5102550
库存组FStockGroupIdStockGroupIdFSTOCKGROUPIDint4100((0))
仓管员FStockerIdStockerIdFSTOCKERIDint4100((0))
索引
名称类型字段
PK_QM_INSPECTBILLENTRY_ACLUSTEREDFENTRYID
IDX_QM_IBE_A_IDNONCLUSTEREDFID
IDX_QM_IBE_A_BILLNONONCLUSTEREDFBILLNO
IDX_QM_IBE_A_MTRLIDNONCLUSTEREDFMATERIALID
IDX_QM_QC_BUSINESSTYPENONCLUSTEREDFQCBUSINESSTYPE
主外键
名称类型字段
PK_QM_INSPECTBILLENTRY_APKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBILLENTRY_A主键约束FENTRYID
DF__T_QM_INSP__FBOMI__04230A78默认值约束FBOMID((0))
DF__T_QM_INSP__FSTOC__05172EB1默认值约束FSTOCKGROUPID((0))
DF__T_QM_INSP__FSTOC__060B52EA默认值约束FSTOCKERID((0))
DF__T_QM_INSP__FCURR__36E3946F默认值约束FCURRENTSTRINGENCY('1')
DF__T_QM_INSP__FBASE__3A19674B默认值约束FBASEREACCEPTQTY((0))
DF__T_QM_INSP__FBASE__3B0D8B84默认值约束FBASEWBINSPECTQTY((0))
DF__T_QM_INSP__FENTR__52246458默认值约束FENTRYID((0))
DF__T_QM_INSP__FDOCU__540CACCA默认值约束FDOCUMENTSTATUS('B')
DF__T_QM_INSP__FSAMP__5500D103默认值约束FSAMPLEDAMAGEBEARER('0')
DF__T_QM_INSP__FINSP__55F4F53C默认值约束FINSPECTRESULT('0')
DF__T_QM_INSP__FBASE__56E91975默认值约束FBASEINSPECTQTY((0))
DF__T_QM_INSP__FBASE__57DD3DAE默认值约束FBASESAMPLEDAMAGEQTY((0))
DF__T_QM_INSP__FBASE__58B231AD默认值约束FBASEMTRLSCRAPQTY((0))
DF__T_QM_INSP__FBASE__58D161E7默认值约束FBASEACCEPTQTY((0))
DF__T_QM_INSP__FBASE__59A655E6默认值约束FBASEPROCSCRAPQTY((0))
DF__T_QM_INSP__FBASE__59C58620默认值约束FBASEREJECTQTY((0))
DF__T_QM_INSP__FBASE__5AB9AA59默认值约束FBASEDEFECTQTY((0))
DF__T_QM_INSP__FBASE__5BADCE92默认值约束FBASESCRAPQTY((0))
DF__T_QM_INSP__FBASE__5CA1F2CB默认值约束FBASEREPAIRQTY((0))
DF__T_QM_INSP__FBASE__5D961704默认值约束FBASEPICKQTY((0))
DF__T_QM_INSP__FBFLO__5E8A3B3D默认值约束FBFLOWID(' ')
DF__T_QM_INSP__FISFI__643CEBA5默认值约束FISFIRSTINSPECT('0')
DF__T_QM_INSP__FBASE__64E0CE2D默认值约束FBASEREMADEQTY((0))
DF__T_QM_INSP__FPROD__65310FDE默认值约束FPRODUCTLINEID((0))
DF__T_QM_INSP__FPRDL__66253417默认值约束FPRDLINELOCATION((0))
DF__T_QM_INSP__FBASE__67195850默认值约束FBASEUNQUASALQTY((0))
DF__T_QM_INSP__FBASE__6C51A9D5默认值约束FBASESTOCKINSCRAPSELQTY((0))
DF__T_QM_INSP__FSTOC__6D45CE0E默认值约束FSTOCKINSCRAPSELQTY((0))
DF__T_QM_INSP__FSTOC__6E39F247默认值约束FSTOCKINFAILSELQTY((0))
DF__T_QM_INSP__FBASE__6F2E1680默认值约束FBASESTOCKINFAILSELQTY((0))
DF__T_QM_INSP__FSTOC__70223AB9默认值约束FSTOCKINQUASELQTY((0))
DF__T_QM_INSP__FBASE__70973C05默认值约束FBASEINCDEFECTQTY((0))
DF__T_QM_INSP__FBASE__71165EF2默认值约束FBASESTOCKINQUASELQTY((0))
DF__T_QM_INSP__FBASE__718B603E默认值约束FBASEPRODEFECTQTY((0))
DF__T_QM_INSP__FQCBU__53188891默认值约束FQCBUSINESSTYPE('0')

检验单-主表体_L

概述
表名称实体名称ORM实体名
T_QM_INSPECTBILLENTRY_L主表体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
备注FMemoMemoFMEMOnvarchar5102550
工序说明FOperDescriptionOperDescriptionFOPERDESCRIPTIONnvarchar200010000
索引
名称类型字段
PK_QM_INSPECTBILLENTRY_LCLUSTEREDFPKID
IDX_QM_INSPECTBILLENTRY_LNONCLUSTEREDFENTRYIDFLOCALEID
主外键
名称类型字段
PK_QM_INSPECTBILLENTRY_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBILLENTRY_L主键约束FPKID
DF__T_QM_INSP__FPKID__6FE9D169默认值约束FPKID((0))

检验单-使用决策表体

概述
表名称实体名称ORM实体名
T_QM_IBPOLICYDETAIL使用决策表体PolicyDetail
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
状态FPolicyStatusPolicyStatusFSTATUSchar110('0')
数量FPolicyQtyPolicyQtyFQTYdecimal132310((0))
基本单位数量FBasePolicyQtyBasePolicyQtyFBASEQTYdecimal132310((0))
使用决策FUsePolicyUsePolicyFUSEPOLICYchar110('0')
辅助属性FPolicyAuxPropIdPolicyAuxPropIdFAUXPROPIDint4100((0))
物料FPolicyMaterialIdPolicyMaterialIdFMATERIALIDint4100((0))
序列号FSerialIdSerialIdFSERIALIDint4100((0))
不良处理FIsDefectProcessIsDefectProcessFISDEFECTPROCESSchar110('0')
不良品关联标志FIsRelatedDefectIsRelatedDefectFISRELATEDDEFECTchar110('0')
判退FIsReturnIsReturnFISRETURNchar110('1')
MRB评审FIsMRBReviewIsMRBReviewFISMRBREVIEWchar110('0')
MRB评审状态FMRBReviewStatusMRBReviewStatusFMRBREVIEWSTATUSchar110('0')
MRB评审分录内码FMRBEntryIdMRBEntryIdFMRBENTRYIDint4100((0))
可销售FCanSaleCanSaleFCANSALEchar110('0')
箱号FBoxNumberBoxNumberFBOXNUMBERnvarchar160800
是否抽检FIsCheckIsCheckFISCHECKchar110('0')
不良品处理分录内码FDefectEntryIdDefectEntryIdFDEFECTENTRYIDint4100((0))
不良品处理状态FDefectProStatusDefectProStatusFDEFECTPROSTATUSchar110('0')
入库关联标志FInstockFlagInstockFlagFINSTOCKFLAGchar110('0')
检验单原始使用决策FIBUsePolicyIBUsePolicyFIBUSEPOLICYchar110(' ')
索引
名称类型字段
PK_QM_IBPOLICYDETAILCLUSTEREDFDETAILID
IDX_QM_IBPD_ENTRYIDNONCLUSTEREDFENTRYID
IDX_QM_IBPD_SERIALIDNONCLUSTEREDFSERIALID
主外键
名称类型字段
PK_QM_IBPOLICYDETAILPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_IBPOLICYDETAIL主键约束FDETAILID
DF__T_QM_IBPO__FINST__01469DCD默认值约束FINSTOCKFLAG('0')
DF__T_QM_IBPO__FSERI__17C44F47默认值约束FSERIALID((0))
DF__T_QM_IBPO__FISCH__24776C4B默认值约束FISCHECK('0')
DF__T_QM_IBPO__FIBUS__2F6BF0DF默认值约束FIBUSEPOLICY(' ')
DF__T_QM_IBPO__FDEFE__37955F81默认值约束FDEFECTENTRYID((0))
DF__T_QM_IBPO__FDEFE__388983BA默认值约束FDEFECTPROSTATUS('0')
DF__T_QM_IBPO__FISDE__3C01AFBD默认值约束FISDEFECTPROCESS('0')
DF__T_QM_IBPO__FISRE__3CF5D3F6默认值约束FISRELATEDDEFECT('0')
DF__T_QM_IBPO__FDETA__3F118FE4默认值约束FDETAILID((0))
DF__T_QM_IBPO__FENTR__4005B41D默认值约束FENTRYID((0))
DF__T_QM_IBPOL__FSEQ__40F9D856默认值约束FSEQ((0))
DF__T_QM_IBPO__FISRE__41E7D3A1默认值约束FISRETURN('1')
DF__T_QM_IBPO__FSTAT__41EDFC8F默认值约束FSTATUS('0')
DF__T_QM_IBPOL__FQTY__42E220C8默认值约束FQTY((0))
DF__T_QM_IBPO__FMATE__434DCBCA默认值约束FMATERIALID((0))
DF__T_QM_IBPO__FBASE__43D64501默认值约束FBASEQTY((0))
DF__T_QM_IBPO__FAUXP__4441F003默认值约束FAUXPROPID((0))
DF__T_QM_IBPO__FUSEP__44CA693A默认值约束FUSEPOLICY('0')
DF__T_QM_IBPO__FCANS__6EBA7A18默认值约束FCANSALE('0')
DF__T_QM_IBPO__FISMR__6FAE9E51默认值约束FISMRBREVIEW('0')
DF__T_QM_IBPO__FMRBR__70A2C28A默认值约束FMRBREVIEWSTATUS('0')
DF__T_QM_IBPO__FMRBE__7196E6C3默认值约束FMRBENTRYID((0))

检验单-使用决策表体_L

概述
表名称实体名称ORM实体名
T_QM_IBPOLICYDETAIL_L使用决策表体PolicyDetail
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
使用决策备注FMemo1Memo1FMEMOnvarchar5102550
索引
名称类型字段
PK_QM_IBPOLICYDETAIL_LCLUSTEREDFPKID
IDX_IBPOLICYDETAIL_LNONCLUSTEREDFDETAILIDFLOCALEID
主外键
名称类型字段
PK_QM_IBPOLICYDETAIL_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_IBPOLICYDETAIL_L主键约束FPKID
DF__T_QM_IBPO__FPKID__6C194085默认值约束FPKID((0))

检验单-缺陷记录表体

概述
表名称实体名称ORM实体名
T_QM_IBDEFECTDETAIL缺陷记录表体DefectDetail
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
缺陷类型FDefectTypeIdDefectTypeIdFDEFECTTYPEIDint4100
缺陷数量FDefectQtyDefectQtyFDEFECTQTYdecimal132310((0))
基本单位缺陷数量FBaseDefectQty1BaseDefectQtyFBASEDEFECTQTYdecimal132310((0))
缺陷原因FDefectReasonIdDefectReasonIdFDEFECTREASONIDint4100
缺陷等级FDefectLevelDefectLevelFDEFECTLEVELchar110('0')
缺陷后果FDefectResultIdDefectResultIdFDEFECTRESULTIDint4100
序列号FDSerialIdDSerialIdFDSERIALIDint4100((0))
索引
名称类型字段
PK_QM_IBDEFECTDETAILCLUSTEREDFDETAILID
IDX_QM_IBDD_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_IBDEFECTDETAILPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_IBDEFECTDETAIL主键约束FDETAILID
DF__T_QM_IBDE__FDSER__256B9084默认值约束FDSERIALID((0))
DF__T_QM_IBDE__FDETA__778AF331默认值约束FDETAILID((0))
DF__T_QM_IBDE__FENTR__787F176A默认值约束FENTRYID((0))
DF__T_QM_IBDEF__FSEQ__79733BA3默认值约束FSEQ((0))
DF__T_QM_IBDE__FDEFE__7A675FDC默认值约束FDEFECTQTY((0))
DF__T_QM_IBDE__FBASE__7B5B8415默认值约束FBASEDEFECTQTY((0))
DF__T_QM_IBDE__FDEFE__7C4FA84E默认值约束FDEFECTLEVEL('0')

检验单-缺陷记录表体_L

概述
表名称实体名称ORM实体名
T_QM_IBDEFECTDETAIL_L缺陷记录表体DefectDetail
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
缺陷记录备注FDefectMemoDefectMemoFMEMOnvarchar5102550
索引
名称类型字段
PK_QM_IBDEFECTDETAIL_LCLUSTEREDFPKID
IDX_QM_IBDEFECTDETAIL_LNONCLUSTEREDFDETAILIDFLOCALEID
主外键
名称类型字段
PK_QM_IBDEFECTDETAIL_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_IBDEFECTDETAIL_L主键约束FPKID
DF__T_QM_IBDE__FPKID__6A30F813默认值约束FPKID((0))

检验单-检验项目表体

概述
表名称实体名称ORM实体名
T_QM_IBITEMDETAIL检验项目表体ItemDetail
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检验项目FInspectItemIdInspectItemIdFINSPECTITEMIDint4100
分析方法FAnalysisMethodAnalysisMethodFANALYSISMETHODchar110('0')
缺陷等级FDefectlevel1DefectLevel1FDEFECTLEVELchar110('0')
破坏性检验FDestructInspectDestructInspectFDESTRUCTINSPECTchar110('0')
重点检查FKeyInspectKeyInspectFKEYINSPECTchar110('0')
质量标准FQualityStdIdQualityStdIdFQUALITYSTDIDint4100
检验方法FInspectMethodIdInspectMethodIdFINSPECTMETHODIDint4100
检验仪器FInspectInstrumentIdInspectInstrumentIdFINSPECTINSTRUMENTIDint4100
检验依据FInspectBasisIdInspectBasisIdFINSPECTBASISIDint4100
抽样方案FSampleSchemeId1SampleSchemeIdFSAMPLESCHEMEIDint4100
单位FUnitId2UnitIdFUNITIDint4100
比较符FCompareSymbolCompareSymbolFCOMPARESYMBOLchar110('0')
状态FItemStatusItemStatusFSTATUSchar110('0')
允收数FAcceptQty1AcceptQtyFACCEPTQTYint4100
拒收数FRejectQty1RejectQtyFREJECTQTYint4100
样本破坏数FSampleDamageQty1SampleDamageQtyFSAMPLEDAMAGEQTYdecimal132310((0))
基本单位样本破坏数FBaseSampleDamageQty1BaseSampleDamageQtyFBASESAMPLEDAMAGEQTYdecimal132310((0))
样本不合格数FSUnqualifiedQty1SUnqualifiedQtyFSUNQUALIFIEDQTYdecimal132310((0))
基本单位样本不合格数FBaseSUnqualifiedQty1BaseSUnqualifiedQtyFBASESUNQUALIFIEDQTYdecimal132310((0))
样本量FSampleQty1SampleQtyFSAMPLEQTYint4100
检验结果FInspectResult1InspectResultFINSPECTRESULTchar110('0')
启用样本检测值FEnableQcValueEnableQcValueFENABLEQCVALUEchar110('1')
0值无效FIsZeroNotValidateIsZeroNotValidateFISZERONOTVALIDATEchar110('0')
索引
名称类型字段
PK_QM_IBITEMDETAILCLUSTEREDFDETAILID
IDX_QM_IBID_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_IBITEMDETAILPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_IBITEMDETAIL主键约束FDETAILID
DF__T_QM_IBIT__FDETA__2CF2DFA9默认值约束FDETAILID((0))
DF__T_QM_IBIT__FENTR__2DE703E2默认值约束FENTRYID((0))
DF__T_QM_IBITE__FSEQ__2EDB281B默认值约束FSEQ((0))
DF__T_QM_IBIT__FANAL__2FCF4C54默认值约束FANALYSISMETHOD('0')
DF__T_QM_IBIT__FDEFE__30C3708D默认值约束FDEFECTLEVEL('0')
DF__T_QM_IBIT__FDEST__31B794C6默认值约束FDESTRUCTINSPECT('0')
DF__T_QM_IBIT__FKEYI__32ABB8FF默认值约束FKEYINSPECT('0')
DF__T_QM_IBIT__FSTAT__339FDD38默认值约束FSTATUS('0')
DF__T_QM_IBIT__FCOMP__34940171默认值约束FCOMPARESYMBOL('0')
DF__T_QM_IBIT__FINSP__358825AA默认值约束FINSPECTRESULT('0')
DF__T_QM_IBIT__FSAMP__367C49E3默认值约束FSAMPLEDAMAGEQTY((0))
DF__T_QM_IBIT__FSUNQ__37706E1C默认值约束FSUNQUALIFIEDQTY((0))
DF__T_QM_IBIT__FBASE__38649255默认值约束FBASESAMPLEDAMAGEQTY((0))
DF__T_QM_IBIT__FBASE__3958B68E默认值约束FBASESUNQUALIFIEDQTY((0))
DF__T_QM_IBIT__FENAB__4255471B默认值约束FENABLEQCVALUE('1')
DF__T_QM_IBIT__FISZE__57DA7BDA默认值约束FISZERONOTVALIDATE('0')

检验单-检验项目表体_A

概述
表名称实体名称ORM实体名
T_QM_IBITEMDETAIL_A检验项目表体ItemDetail
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检验值FInspectValInspectValFINSPECTVALnvarchar5102550
目标值FTargetValTargetValFTARGETVALnvarchar5102550
上限值FUpLimitUpLimitFUPLIMITnvarchar5102550
下限值FDownLimitDownLimitFDOWNLIMITnvarchar5102550
上偏差FUpOffsetUpOffsetFUPOFFSETnvarchar5102550
下偏差FDownOffsetDownOffsetFDOWNOFFSETnvarchar5102550
检验值KeyFInspectValKeyInspectValKeyFINSPECTVALKEYvarchar36360
目标值KeyFTargetValKeyTargetValKeyFTARGETVALKEYvarchar36360
上限值KeyFUpLimitKeyUpLimitKeyFUPLIMITKEYvarchar36360
下限值KeyFDownLimitKeyDownLimitKeyFDOWNLIMITKEYvarchar36360
上偏差KeyFUpOffsetKeyUpOffsetKeyFUPOFFSETKEYvarchar36360
下偏差KeyFDownOffsetKeyDownOffsetKeyFDOWNOFFSETKEYvarchar36360
检验值(定量)FInspectValQInspectValQFINSPECTVALQdecimal132310
目标值数量FTargetValQTargetValQFTARGETVALQdecimal132310
上限值数量FUpLimitQUpLimitQFUPLIMITQdecimal132310
下限值数量FDownLimitQDownLimitQFDOWNLIMITQdecimal132310
上偏差数量FUpOffsetQUpOffsetQFUPOFFSETQdecimal132310
下偏差数量FDownOffsetQDownOffsetQFDOWNOFFSETQdecimal132310
检验值(定性)FInspectValBInspectValBFINSPECTVALBint4100
目标值基础资料FTargetValBTargetValBFTARGETVALBint4100
上限值基础资料FUpLimitBUpLimitBFUPLIMITBint4100
下限值基础资料FDownLimitBDownLimitBFDOWNLIMITBint4100
上偏差基础资料FUpOffsetBUpOffsetBFUPOFFSETBint4100
下偏差基础资料FDownOffsetBDownOffsetBFDOWNOFFSETBint4100
检验值(其他)FInspectValTInspectValTFINSPECTVALTnvarchar5102550
目标值文本FTargetValTTargetValTFTARGETVALTnvarchar5102550
上限值文本FUpLimitTUpLimitTFUPLIMITTnvarchar5102550
下限值文本FDownLimitTDownLimitTFDOWNLIMITTnvarchar5102550
上偏差文本FUpOffsetTUpOffsetTFUPOFFSETTnvarchar5102550
下偏差文本FDownOffsetTDownOffsetTFDOWNOFFSETTnvarchar5102550
索引
名称类型字段
PK_QM_IBITEMDETAIL_ACLUSTEREDFDETAILID
IDX_QM_IBIDA_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_IBITEMDETAIL_APKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_IBITEMDETAIL_A主键约束FDETAILID
DF__T_QM_IBIT__FDETA__64431493默认值约束FDETAILID((0))
DF__T_QM_IBIT__FENTR__653738CC默认值约束FENTRYID((0))

检验单-检验项目表体_L

概述
表名称实体名称ORM实体名
T_QM_IBITEMDETAIL_L检验项目表体ItemDetail
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检验项目备注FItemMemoItemMemoFMEMOnvarchar5102550
索引
名称类型字段
PK_QM_IBITEMDETAIL_LCLUSTEREDFPKID
IDX_QM_IBITEMDETAIL_LNONCLUSTEREDFDETAILIDFLOCALEID
主外键
名称类型字段
PK_QM_IBITEMDETAIL_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_IBITEMDETAIL_L主键约束FPKID
DF__T_QM_IBIT__FPKID__71D219DB默认值约束FPKID((0))

检验单-参考表体

概述
表名称实体名称ORM实体名
T_QM_IBREFERDETAIL参考表体ReferDetail
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
源单类型FSrcBillTypeSrcBillTypeFSRCBILLTYPEvarchar36360
源单编号FSrcBillNoSrcBillNoFSRCBILLNOnvarchar160800
源单内码FSrcInterIdSrcInterIdFSRCINTERIDint4100
源单分录内码FSrcEntryIdSrcEntryIdFSRCENTRYIDint4100
源单行号FSrcEntrySeqSrcEntrySeqFSRCENTRYSEQint4100
订单类型FOrderTypeOrderTypeFORDERTYPEvarchar36360
订单编号FOrderBillNoOrderBillNoFORDERBILLNOnvarchar160800
订单内码FOrderIdOrderIdFORDERIDint4100
订单分录内码FOrderEntryIdOrderEntryIdFORDERENTRYIDint4100
订单行号FOrderEntrySeqOrderEntrySeqFORDERENTRYSEQint4100
索引
名称类型字段
PK_QM_IBREFERDETAILCLUSTEREDFDETAILID
IDX_QM_IBRD_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_IBREFERDETAILPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_IBREFERDETAIL主键约束FDETAILID
DF__T_QM_IBRE__FDETA__4E53D374默认值约束FDETAILID((0))
DF__T_QM_IBRE__FENTR__4F47F7AD默认值约束FENTRYID((0))
DF__T_QM_IBREF__FSEQ__503C1BE6默认值约束FSEQ((0))

检验单-检测值表体

概述
表名称实体名称ORM实体名
T_QM_IBVALUEGRID检测值表体ValueGrid
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检测值(定量)FInspectValueInspectValueFINSPECTVALUEdecimal132310((0))
检验结果FInspectResult2InspectResultFINSPECTRESULTchar110('0')
检测值(定性)FInspectValueBInspectValueBFINSPCETVALUEBint4100
检测值(其他)FInspectValueTInspectValueTFINSPECTVALUETnvarchar5102550
序列号FVSerialIdVSerialIdFVSERIALIDint4100((0))
索引
名称类型字段
PK_QM_IBVALUEGRIDCLUSTEREDFGRIDID
IDX_QM_IBVG_DETAILIDNONCLUSTEREDFDETAILID
主外键
名称类型字段
PK_QM_IBVALUEGRIDPKFGRIDID
触发器
约束
名称类型字段描述
PK_QM_IBVALUEGRID主键约束FGRIDID
DF__T_QM_IBVA__FVSER__0058A282默认值约束FVSERIALID((0))
DF__T_QM_IBVA__FGRID__489AFA1E默认值约束FGRIDID((0))
DF__T_QM_IBVA__FDETA__498F1E57默认值约束FDETAILID((0))
DF__T_QM_IBVAL__FSEQ__4A834290默认值约束FSEQ((0))
DF__T_QM_IBVA__FINSP__4B7766C9默认值约束FINSPECTVALUE((0))
DF__T_QM_IBVA__FINSP__4C6B8B02默认值约束FINSPECTRESULT('0')

检验单-关联关系表

概述
表名称实体名称ORM实体名
T_QM_INSPECTBILLENTRY_LK关联关系表FEntity_Link
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值
业务流程图FEntity_Link_FFlowIdFlowIdFFLOWIDvarchar36360(' ')
推进路线FEntity_Link_FFlowLineIdFlowLineIdFFLOWLINEIDint4100((0))
转换规则FEntity_Link_FRuleIdRuleIdFRULEIDvarchar36360(' ')
源单表内码FEntity_Link_FSTableIdSTableIdFSTABLEIDint4100
源单表FEntity_Link_FSTableNameSTableNameFSTABLENAMEvarchar30300(' ')
源单内码FEntity_Link_FSBillIdSBillIdFSBILLIDvarchar36360(' ')
源单分录内码FEntity_Link_FSIdSIdFSIDvarchar36360(' ')
原始携带量FEntity_Link_FBaseAcceptQtyOldBaseAcceptQtyOldFBASEACCEPTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseAcceptQtyBaseAcceptQtyFBASEACCEPTQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseRejectQtyOldBaseRejectQtyOldFBASEREJECTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseRejectQtyBaseRejectQtyFBASEREJECTQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseDefectQtyOldBaseDefectQtyOldFBASEDEFECTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseDefectQtyBaseDefectQtyFBASEDEFECTQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseScrapQtyOldBaseScrapQtyOldFBASESCRAPQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseScrapQtyBaseScrapQtyFBASESCRAPQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseRepairQtyOldBaseRepairQtyOldFBASEREPAIRQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseRepairQtyBaseRepairQtyFBASEREPAIRQTYdecimal132310((0))
原始携带量FEntity_Link_FBasePickQtyOldBasePickQtyOldFBASEPICKQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBasePickQtyBasePickQtyFBASEPICKQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseMtrlScrapQtyOldBaseMtrlScrapQtyOldFBASEMTRLSCRAPQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseMtrlScrapQtyBaseMtrlScrapQtyFBASEMTRLSCRAPQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseProcScrapQtyOldBaseProcScrapQtyOldFBASEPROCSCRAPQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseProcScrapQtyBaseProcScrapQtyFBASEPROCSCRAPQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseInspectQtyOldBaseInspectQtyOldFBASEINSPECTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseInspectQtyBaseInspectQtyFBASEINSPECTQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseSampleDamageQtyOldBaseSampleDamageQtyOldFBASESAMPLEDAMAGEQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseSampleDamageQtyBaseSampleDamageQtyFBASESAMPLEDAMAGEQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseReAcceptQtyOldBaseReAcceptQtyOldFBASEREACCEPTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseReAcceptQtyBaseReAcceptQtyFBASEREACCEPTQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseWBInspectQtyOldBaseWBInspectQtyOldFBASEWBINSPECTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseWBInspectQtyBaseWBInspectQtyFBASEWBINSPECTQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseUnQuaSalQtyOldBaseUnQuaSalQtyOldFBASEUNQUASALQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseUnQuaSalQtyBaseUnQuaSalQtyFBASEUNQUASALQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseReMadeQtyOldBaseReMadeQtyOldFBASEREMADEQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseReMadeQtyBaseReMadeQtyFBASEREMADEQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseIncDefectQtyOldBaseIncDefectQtyOldFBASEINCDEFECTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseIncDefectQtyBaseIncDefectQtyFBASEINCDEFECTQTYdecimal132310((0))
原始携带量FEntity_Link_FBaseProDefectQtyOldBaseProDefectQtyOldFBASEPRODEFECTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseProDefectQtyBaseProDefectQtyFBASEPRODEFECTQTYdecimal132310((0))
原始携带量FEntity_Link_FInspectQtyOldInspectQtyOldFINSPECTQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FInspectQtyInspectQtyFINSPECTQTYdecimal132310((0))
索引
名称类型字段
PK_QM_INSPECTBILLENTRY_LKCLUSTEREDFLINKID
IDX_QM_IBE_LK_SIDNONCLUSTEREDFSID
IDX_QM_IBE_LK_SBILLIDNONCLUSTEREDFSBILLID
IDX_QM_IBE_LK_ENTRYDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_INSPECTBILLENTRY_LKPKFLINKID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBILLENTRY_LK主键约束FLINKID
DF__T_QM_INSP__FLINK__1056A0FB默认值约束FLINKID((0))
DF__T_QM_INSP__FSBIL__114AC534默认值约束FSBILLID(' ')
DF__T_QM_INSPE__FSID__123EE96D默认值约束FSID(' ')
DF__T_QM_INSP__FFLOW__13330DA6默认值约束FFLOWID(' ')
DF__T_QM_INSP__FFLOW__142731DF默认值约束FFLOWLINEID((0))
DF__T_QM_INSP__FRULE__151B5618默认值约束FRULEID(' ')
DF__T_QM_INSP__FSTAB__160F7A51默认值约束FSTABLENAME(' ')
DF__T_QM_INSP__FBASE__17039E8A默认值约束FBASEINSPECTQTY((0))
DF__T_QM_INSP__FBASE__17F7C2C3默认值约束FBASEINSPECTQTYOLD((0))
DF__T_QM_INSP__FBASE__18EBE6FC默认值约束FBASEACCEPTQTY((0))
DF__T_QM_INSP__FBASE__19E00B35默认值约束FBASEACCEPTQTYOLD((0))
DF__T_QM_INSP__FBASE__1AD42F6E默认值约束FBASEREJECTQTY((0))
DF__T_QM_INSP__FBASE__1BC853A7默认值约束FBASEREJECTQTYOLD((0))
DF__T_QM_INSP__FBASE__1CBC77E0默认值约束FBASESCRAPQTY((0))
DF__T_QM_INSP__FBASE__1DB09C19默认值约束FBASESCRAPQTYOLD((0))
DF__T_QM_INSP__FBASE__1EA4C052默认值约束FBASEREPAIRQTY((0))
DF__T_QM_INSP__FBASE__1F98E48B默认值约束FBASEREPAIRQTYOLD((0))
DF__T_QM_INSP__FBASE__208D08C4默认值约束FBASEDEFECTQTY((0))
DF__T_QM_INSP__FBASE__21812CFD默认值约束FBASEDEFECTQTYOLD((0))
DF__T_QM_INSP__FBASE__22755136默认值约束FBASESAMPLEDAMAGEQTY((0))
DF__T_QM_INSP__FBASE__2369756F默认值约束FBASESAMPLEDAMAGEQTYOLD((0))
DF__T_QM_INSP__FBASE__245D99A8默认值约束FBASEPICKQTY((0))
DF__T_QM_INSP__FBASE__2551BDE1默认值约束FBASEPICKQTYOLD((0))
DF__T_QM_INSP__FBASE__2CBF6C2D默认值约束FBASEREACCEPTQTY((0))
DF__T_QM_INSP__FBASE__2DB39066默认值约束FBASEWBINSPECTQTY((0))
DF__T_QM_INSP__FBASE__2EA7B49F默认值约束FBASEREACCEPTQTYOLD((0))
DF__T_QM_INSP__FBASE__2F9BD8D8默认值约束FBASEWBINSPECTQTYOLD((0))
DF__T_QM_INSP__FINSP__521E3B6A默认值约束FINSPECTQTY((0))
DF__T_QM_INSP__FINSP__53125FA3默认值约束FINSPECTQTYOLD((0))
DF__T_QM_INSP__FBASE__6254A333默认值约束FBASEUNQUASALQTY((0))
DF__T_QM_INSP__FBASE__6348C76C默认值约束FBASEUNQUASALQTYOLD((0))
DF__T_QM_INSP__FBASE__65D4F266默认值约束FBASEREMADEQTY((0))
DF__T_QM_INSP__FBASE__66C9169F默认值约束FBASEREMADEQTYOLD((0))
DF__T_QM_INSP__FBASE__717DDF77默认值约束FBASEMTRLSCRAPQTY((0))
DF__T_QM_INSP__FBASE__727203B0默认值约束FBASEMTRLSCRAPQTYOLD((0))
DF__T_QM_INSP__FBASE__727F8477默认值约束FBASEINCDEFECTQTY((0))
DF__T_QM_INSP__FBASE__736627E9默认值约束FBASEPROCSCRAPQTY((0))
DF__T_QM_INSP__FBASE__7373A8B0默认值约束FBASEINCDEFECTQTYOLD((0))
DF__T_QM_INSP__FBASE__745A4C22默认值约束FBASEPROCSCRAPQTYOLD((0))
DF__T_QM_INSP__FBASE__7467CCE9默认值约束FBASEPRODEFECTQTY((0))
DF__T_QM_INSP__FBASE__755BF122默认值约束FBASEPRODEFECTQTYOLD((0))

1.1.10 检验仪器

检验仪器-单据头

概述
表名称实体名称ORM实体名
T_QM_INSPECTINSTRUMENT单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
索引
名称类型字段
PK_QM_INSPECTINSTRUMENTCLUSTEREDFID
IDX_QM_INSPECTINS_NUMNONCLUSTEREDFNUMBER
IDX_QM_INSPECTINS_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_INSPECTINSTRUMENTPKFID
触发器
约束
名称类型字段描述
PK_QM_INSPECTINSTRUMENT主键约束FID
DF__T_QM_INSPEC__FID__267A20ED默认值约束FID((0))
DF__T_QM_INSP__FMAST__276E4526默认值约束FMASTERID((0))

检验仪器-单据头_L

概述
表名称实体名称ORM实体名
T_QM_INSPECTINSTRUMENT_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_INSPECTINSTRUMENT_LCLUSTEREDFPKID
IDX_QM_INSPECTINS_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_INSPECTINSTRUMENT_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_INSPECTINSTRUMENT_L主键约束FPKID
DF__T_QM_INSP__FPKID__29568D98默认值约束FPKID((0))

1.1.11 检验项目

检验项目-单据头

概述
表名称实体名称ORM实体名
T_QM_INSPECTITEM单据头
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
分析方法FAnalysisMethodAnalysisMethodFANALYSISMETHODchar110('0')
缺陷等级FDefectlevelDefectLevelFDEFECTLEVELchar110('0')
破坏性检验FDestructInspectDestructInspectFDESTRUCTINSPECTchar110('0')
重点检查FKeyInspectKeyInspectFKEYINSPECTchar110('0')
组别FGroupGroupFGROUPint4100
质量标准FQualityStdIdQualityStdIdFQUALITYSTDIDint4100
检验方法FInspectMethodIdInspectMethodIdFINSPECTMETHODIDint4100
检验仪器FInspectInstrumentIdInspectInstrumentIdFINSPECTINSTRUMENTIDint4100
检验依据FInspectBasisIdInspectBasisIdFINSPECTBASISIDint4100
抽样方案FSampleSchemeIdSampleSchemeIdFSAMPLESCHEMEIDint4100
单位FUnitIdUnitIdFUNITIDint4100
启用样本检测值FEnableQcValueEnableQcValueFENABLEQCVALUEchar110('1')
0值无效FIsZeroNotValidateIsZeroNotValidateFISZERONOTVALIDATEchar110('0')
索引
名称类型字段
PK_QM_INSPECTITEMCLUSTEREDFID
IDX_QM_INSPECTITEM_NUMNONCLUSTEREDFNUMBER
IDX_QM_INSPECTITEM_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_INSPECTITEMPKFID
触发器
约束
名称类型字段描述
PK_QM_INSPECTITEM主键约束FID
DF_T_QM_INSPECTITEM_FANALYSISMETHOD默认值约束FANALYSISMETHOD('0')
DF_T_QM_INSPECTITEM_FDEFECTLEVEL默认值约束FDEFECTLEVEL('0')
DF_T_QM_INSPECTITEM_FDESTRUCTINSPECT默认值约束FDESTRUCTINSPECT('0')
DF__T_QM_INSP__FKEYI__3D294772默认值约束FKEYINSPECT('0')
DF__T_QM_INSP__FENAB__406CFEA9默认值约束FENABLEQCVALUE('1')
DF__T_QM_INSP__FISZE__55F23368默认值约束FISZERONOTVALIDATE('0')
DF__T_QM_INSPEC__FID__5DCA55D7默认值约束FID((0))
DF__T_QM_INSP__FMAST__5EBE7A10默认值约束FMASTERID((0))

检验项目-单据头_L

概述
表名称实体名称ORM实体名
T_QM_INSPECTITEM_L单据头
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_INSPECTITEM_LCLUSTEREDFPKID
IDX_QM_INSPECTITEM_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_INSPECTITEM_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_INSPECTITEM_L主键约束FPKID
DF__T_QM_INSP__FPKID__2B3ED60A默认值约束FPKID((0))

检验项目-对应检测值

概述
表名称实体名称ORM实体名
T_QM_IIIVRELATEDENTRY对应检测值Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检测值编码FInspectValueIdInspectValueIdFINSPECTVALUEIDint4100
是否目标值FIsTargetValueIsTargetValueFISTARGETVALUEchar110('0')
索引
名称类型字段
PK_QM_IIIVRELATEDENTRYCLUSTEREDFENTRYID
IDX_QM_IIIVRELATEDE_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_IIIVRELATEDENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_IIIVRELATEDENTRY主键约束FENTRYID
DF__T_QM_IIIV__FISTA__1BBE3206默认值约束FISTARGETVALUE('0')
DF__T_QM_IIIV__FISDE__587AF748默认值约束FISDEFAULTVALUE('0')
DF__T_QM_IIIV__FENTR__671F813E默认值约束FENTRYID((0))

1.1.12 检验方法

检验方法-单据头

概述
表名称实体名称ORM实体名
T_QM_INSPECTMETHOD单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
索引
名称类型字段
PK_QM_INSPECTMETHODCLUSTEREDFID
IDX_QM_INSPECTMETHOD_NUMNONCLUSTEREDFNUMBER
IDX_QM_INSPECTMETHOD_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_INSPECTMETHODPKFID
触发器
约束
名称类型字段描述
PK_QM_INSPECTMETHOD主键约束FID
DF__T_QM_INSPEC__FID__2D271E7C默认值约束FID((0))
DF__T_QM_INSP__FMAST__2E1B42B5默认值约束FMASTERID((0))

检验方法-单据头_L

概述
表名称实体名称ORM实体名
T_QM_INSPECTMETHOD_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_INSPECTMETHOD_LCLUSTEREDFPKID
IDX_QM_INSPECTMETHOD_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_INSPECTMETHOD_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_INSPECTMETHOD_L主键约束FPKID
DF__T_QM_INSP__FPKID__30038B27默认值约束FPKID((0))

1.1.13 检测值

检测值-单据头

概述
表名称实体名称ORM实体名
T_QM_INSPECTVALUE单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
索引
名称类型字段
PK_QM_INSPECTVALUECLUSTEREDFID
IDX_QM_INSPECTVALUE_NUMNONCLUSTEREDFNUMBER
IDX_QM_INSPECTVALUE_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_INSPECTVALUEPKFID
触发器
约束
名称类型字段描述
PK_QM_INSPECTVALUE主键约束FID
DF__T_QM_INSPEC__FID__31EBD399默认值约束FID((0))
DF__T_QM_INSP__FMAST__32DFF7D2默认值约束FMASTERID((0))

检测值-单据头_L

概述
表名称实体名称ORM实体名
T_QM_INSPECTVALUE_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_INSPECTVALUE_LCLUSTEREDFPKID
IDX_QM_INSPECTVALUE_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_INSPECTVALUE_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_INSPECTVALUE_L主键约束FPKID
DF__T_QM_INSP__FPKID__34C84044默认值约束FPKID((0))

1.1.14 MRB评审单

MRB评审单-单据头

概述
表名称实体名称ORM实体名
T_QM_MRBREVIEWBILL单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
单据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
审核人FApproverIdApproverIdFAPPROVERIDint4100
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
作废日期FCancelDateCancelDateFCANCELDATEdatetime8233
作废人FCancelerCancelerFCANCELERint4100
作废状态FCancelStatusCancelStatusFCANCELSTATUSchar110
单据类型FBillTypeIDBillTypeIDFBILLTYPEIDvarchar36360
业务类型FBusinessTypeBusinessTypeFBUSINESSTYPEvarchar220('0')
单据日期FDateDateFDATEdatetime8233
质检组织FInspectOrgIdInspectOrgIdFINSPECTORGIDint4100
检验部门FInspectDepIdInspectDepIdFINSPECTDEPIDint4100
质检员FInspectorIdInspectorIdFINSPECTORIDint4100
质检组FInspectGroupIdInspectGroupIdFINSPECTGROUPIDint4100
物料编码FMaterialIdMaterialIdFMATERIALIDvarchar36360
批号FLotLotFLOTint4100((0))
生产计划:退货是否影响生产FIsEffectProdIsEffectProdFISEFFECTPRODchar110('0')
上线日期FLaunchDateLaunchDateFLAUNCHDATEdatetime8233
采购:后续供应是否满足计划FIsSupplyMeetIsSupplyMeetFISSUPPLYMEETchar110('0')
外观FAppearanceAppearanceFAPPEARANCEchar110('0')
尺寸FSizeSizeFSIZEchar110('0')
性能FPerformancePerformanceFPERFORMANCEchar110('0')
安全FSecuritySecurityFSECURITYchar110('0')
其他FOthersOthersFOTHERSnvarchar5102550
来料异常责任方FResponsiblePartyResponsiblePartyFRESPONSIBLEPARTYchar110('0')
发供应商异常联络单FIsLiaisonIsLiaisonFISLIAISONchar110('0')
完成日期FFinishDateFinishDateFFINISHDATEdatetime8233
供应商FSupplierIdSupplierIdFSUPPLIERIDint4100
处理部门FProcessDeptIdProcessDeptIdFPROCESSDEPTIDint4100
责任人FRespPersonIdRespPersonIdFRESPPERSONIDint4100
生产车间FWorkShopIdWorkShopIdFWORKSHOPIDint4100((0))
来源组织FSourceOrgIdSourceOrgIdFSOURCEORGIDint4100
工序号FOperNumberOperNumberFOPERNUMBERint4100((0))
生产单位FPrdUnitIdPrdUnitIdFPRDUNITIDint4100((0))
单位转换表头数量FUnitTransHeadQtyUnitTransHeadQtyFUNITTRANSHEADQTYdecimal132310((0))
单位转换工序数量FUnitTransOperQtyUnitTransOperQtyFUNITTRANSOPERQTYdecimal132310((0))
仓库FStockIdStockIdFSTOCKIDint4100((0))
仓位FStockLocIdStockLocIdFSTOCKLOCIDint4100((0))
索引
名称类型字段
PK_QM_MRBREVIEWBILLCLUSTEREDFID
IDX_QM_MRB_MTRLIDNONCLUSTEREDFMATERIALID
IDX_QM_MRB_DATENONCLUSTEREDFDATE
主外键
名称类型字段
PK_QM_MRBREVIEWBILLPKFID
触发器
约束
名称类型字段描述
PK_QM_MRBREVIEWBILL主键约束FID
DF__T_QM_MRBR__FPRDU__0C546513默认值约束FPRDUNITID((0))
DF__T_QM_MRBR__FUNIT__0D48894C默认值约束FUNITTRANSHEADQTY((0))
DF__T_QM_MRBR__FUNIT__0E3CAD85默认值约束FUNITTRANSOPERQTY((0))
DF__T_QM_MRBR__FOPER__0F30D1BE默认值约束FOPERNUMBER((0))
DF__T_QM_MRBR__FWORK__1F9C43B1默认值约束FWORKSHOPID((0))
DF__T_QM_MRBREV__FID__2145F9E5默认值约束FID((0))
DF__T_QM_MRBR__FBUSI__223A1E1E默认值约束FBUSINESSTYPE('0')
DF__T_QM_MRBRE__FLOT__232E4257默认值约束FLOT((0))
DF__T_QM_MRBR__FISEF__24226690默认值约束FISEFFECTPROD('0')
DF__T_QM_MRBR__FISSU__25168AC9默认值约束FISSUPPLYMEET('0')
DF__T_QM_MRBR__FAPPE__260AAF02默认值约束FAPPEARANCE('0')
DF__T_QM_MRBR__FSIZE__26FED33B默认值约束FSIZE('0')
DF__T_QM_MRBR__FPERF__27F2F774默认值约束FPERFORMANCE('0')
DF__T_QM_MRBR__FSECU__28E71BAD默认值约束FSECURITY('0')
DF__T_QM_MRBR__FRESP__29DB3FE6默认值约束FRESPONSIBLEPARTY('0')
DF__T_QM_MRBR__FISLI__2ACF641F默认值约束FISLIAISON('0')
DF__T_QM_MRBR__FSTOC__7CDEAE07默认值约束FSTOCKID((0))
DF__T_QM_MRBR__FSTOC__7DD2D240默认值约束FSTOCKLOCID((0))

MRB评审单-单据头_A

概述
表名称实体名称ORM实体名
T_QM_MRBREVIEWBILL_A单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单位FUnitIDUnitIDFUNITIDint4100((0))
数量FQtyQtyFQTYdecimal132310((0))
急料数量FUrgentQtyUrgentQtyFURGENTQTYdecimal132310((0))
基本单位FBaseUnitIDBaseUnitIDFBASEUNITIDint4100((0))
基本单位数量FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
基本单位急料数量FBaseUrgentQtyBaseUrgentQtyFBASEURGENTQTYdecimal132310((0))
源单类型FSrcBillTypeSrcBillTypeFSRCBILLTYPEvarchar36360
源单编号FSrcBillNoSrcBillNoFSRCBILLNOnvarchar160800
源单内码FSrcInterIdSrcInterIdFSRCINTERIDint4100((0))
源单分录内码FSrcEntryIdSrcEntryIdFSRCENTRYIDint4100((0))
源单分录行号FSrcEntrySeqSrcEntrySeqFSRCENTRYSEQint4100((0))
基本单位工废数量FBaseProcScrapQtyBaseProcScrapQtyFBASEPROCSCRAPQTYdecimal132310((0))
基本单位让步接收数量FBaseReAcceptQtyBaseReAcceptQtyFBASEREACCEPTQTYdecimal132310((0))
基本单位判退数量FBaseRejectQtyBaseRejectQtyFBASEREJECTQTYdecimal132310((0))
基本单位料废数量FBaseMtrlScrapQtyBaseMtrlScrapQtyFBASEMTRLSCRAPQTYdecimal132310((0))
基本单位挑选数量FBasePickQtyBasePickQtyFBASEPICKQTYdecimal132310((0))
检验单使用决策分录内码FIBPolicyDetailIdIBPolicyDetailIdFIBPOLICYDETAILIDint4100((0))
基本单位汇总决策数量FBaseSumPolicyQtyBaseSumPolicyQtyFBASESUMPOLICYQTYdecimal132310((0))
检验单使用决策FIBUsePolicyIBUsePolicyFIBUSEPOLICYchar110('0')
基本单位反写检验数量FBaseWBInspectQtyBaseWBInspectQtyFBASEWBINSPECTQTYdecimal132310((0))
序列号单位FSNUnitIdSNUnitIdFSNUNITIDint4100((0))
基本单位报废数量FBaseScrapQtyBaseScrapQtyFBASESCRAPQTYdecimal132310((0))
基本单位返修数量FBaseRepairQtyBaseRepairQtyFBASEREPAIRQTYdecimal132310((0))
基本单位不良数量FBaseDefectQtyBaseDefectQtyFBASEDEFECTQTYdecimal132310((0))
基本单位返工数量FBaseReMadeQtyBaseReMadeQtyFBASEREMADEQTYdecimal132310((0))
基本单位接收数量FBaseAcceptQtyBaseAcceptQtyFBASEACCEPTQTYdecimal132310((0))
基本单位来料不良数量FBaseIncDefectQtyBaseIncDefectQtyFBASEINCDEFECTQTYdecimal132310((0))
基本单位作业不良数量FBaseProDefectQtyBaseProDefectQtyFBASEPRODEFECTQTYdecimal132310((0))
库存组FStockGroupIdStockGroupIdFSTOCKGROUPIDint4100((0))
仓管员FStockerIdStockerIdFSTOCKERIDint4100((0))
BOM版本FBomIdBomIdFBOMIDint4100((0))
生产日期FProduceDateProduceDateFPRODUCEDATEdatetime8233
有效期至FExpiryDateExpiryDateFEXPIRYDATEdatetime8233
计划跟踪号FMtoNoMtoNoFMTONOnvarchar5102550
货主类型FOwnerTypeIdOwnerTypeIdFOWNERTYPEIDvarchar36360
货主FOwnerIdOwnerIdFOWNERIDint4100((0))
保管者类型FKeeperTypeIdKeeperTypeIdFKEEPERTYPEIDvarchar36360
保管者FKeeperIdKeeperIdFKEEPERIDint4100((0))
基本单位报废品入库选单数量FBaseStockInScrapSelQtyBaseStockInScrapSelQtyFBASESTOCKINSCRAPSELQTYdecimal132310((0))
基本单位不合格品入库选单数量FBaseStockInFailSelQtyBaseStockInFailSelQtyFBASESTOCKINFAILSELQTYdecimal132310((0))
基本单位合格品入库选单数量FBaseStockInQuaSelQtyBaseStockInQuaSelQtyFBASESTOCKINQUASELQTYdecimal132310((0))
合格品入库选单数量FStockInQuaSelQtyStockInQuaSelQtyFSTOCKINQUASELQTYdecimal132310((0))
不合格品入库选单数量FStockInFailSelQtyStockInFailSelQtyFSTOCKINFAILSELQTYdecimal132310((0))
报废品入库选单数量FStockInScrapSelQtyStockInScrapSelQtyFSTOCKINSCRAPSELQTYdecimal132310((0))
检验单分录辅助属性FIBAuxPropIdIBAuxPropIdFIBAUXPROPIDint4100((0))
新有效期至FNewExpiryDateNewExpiryDateFNEWEXPIRYDATEdatetime8233
索引
名称类型字段
PK_QM_MRBREVIEWBILL_ACLUSTEREDFID
IDX_QM_MRB_A_SRCEIDNONCLUSTEREDFSRCENTRYID
主外键
名称类型字段
PK_QM_MRBREVIEWBILL_APKFID
触发器
约束
名称类型字段描述
PK_QM_MRBREVIEWBILL_A主键约束FID
DF__T_QM_MRBREV__FID__03B596FE默认值约束FID((0))
DF__T_QM_MRBR__FSRCI__04A9BB37默认值约束FSRCINTERID((0))
DF__T_QM_MRBR__FSRCE__059DDF70默认值约束FSRCENTRYID((0))
DF__T_QM_MRBR__FSRCE__069203A9默认值约束FSRCENTRYSEQ((0))
DF__T_QM_MRBR__FIBUS__078627E2默认值约束FIBUSEPOLICY('0')
DF__T_QM_MRBR__FUNIT__087A4C1B默认值约束FUNITID((0))
DF__T_QM_MRBR__FBASE__096E7054默认值约束FBASEUNITID((0))
DF__T_QM_MRBRE__FQTY__0A62948D默认值约束FQTY((0))
DF__T_QM_MRBR__FURGE__0B56B8C6默认值约束FURGENTQTY((0))
DF__T_QM_MRBR__FBASE__0C4ADCFF默认值约束FBASEQTY((0))
DF__T_QM_MRBR__FBASE__0D3F0138默认值约束FBASEWBINSPECTQTY((0))
DF__T_QM_MRBR__FBASE__0E332571默认值约束FBASEURGENTQTY((0))
DF__T_QM_MRBR__FBASE__0F2749AA默认值约束FBASEREJECTQTY((0))
DF__T_QM_MRBR__FBASE__101B6DE3默认值约束FBASEPICKQTY((0))
DF__T_QM_MRBR__FBASE__110F921C默认值约束FBASEMTRLSCRAPQTY((0))
DF__T_QM_MRBR__FBASE__1203B655默认值约束FBASEPROCSCRAPQTY((0))
DF__T_QM_MRBR__FBASE__12F7DA8E默认值约束FBASEREACCEPTQTY((0))
DF__T_QM_MRBR__FIBPO__13EBFEC7默认值约束FIBPOLICYDETAILID((0))
DF__T_QM_MRBR__FBASE__14E02300默认值约束FBASESUMPOLICYQTY((0))
DF__T_QM_MRBR__FBASE__1604F0ED默认值约束FBASEINCDEFECTQTY((0))
DF__T_QM_MRBR__FBASE__16F91526默认值约束FBASEPRODEFECTQTY((0))
DF__T_QM_MRBR__FBASE__209067EA默认值约束FBASESCRAPQTY((0))
DF__T_QM_MRBR__FSNUN__20A6DB67默认值约束FSNUNITID((0))
DF__T_QM_MRBR__FBASE__21848C23默认值约束FBASEREPAIRQTY((0))
DF__T_QM_MRBR__FBASE__2278B05C默认值约束FBASEDEFECTQTY((0))
DF__T_QM_MRBR__FBASE__236CD495默认值约束FBASEREMADEQTY((0))
DF__T_QM_MRBR__FBASE__2460F8CE默认值约束FBASEACCEPTQTY((0))
DF__T_QM_MRBR__FSTOC__45BBCB9F默认值约束FSTOCKGROUPID((0))
DF__T_QM_MRBR__FSTOC__46AFEFD8默认值约束FSTOCKERID((0))
DF__T_QM_MRBR__FBOMI__47A41411默认值约束FBOMID((0))
DF__T_QM_MRBR__FOWNE__4898384A默认值约束FOWNERID((0))
DF__T_QM_MRBR__FKEEP__498C5C83默认值约束FKEEPERID((0))
DF__T_QM_MRBR__FBASE__4A8080BC默认值约束FBASESTOCKINSCRAPSELQTY((0))
DF__T_QM_MRBR__FSTOC__4B74A4F5默认值约束FSTOCKINSCRAPSELQTY((0))
DF__T_QM_MRBR__FSTOC__4C68C92E默认值约束FSTOCKINFAILSELQTY((0))
DF__T_QM_MRBR__FBASE__4D5CED67默认值约束FBASESTOCKINFAILSELQTY((0))
DF__T_QM_MRBR__FSTOC__4E5111A0默认值约束FSTOCKINQUASELQTY((0))
DF__T_QM_MRBR__FBASE__50395A12默认值约束FBASESTOCKINQUASELQTY((0))
DF__T_QM_MRBR__FIBAU__512D7E4B默认值约束FIBAUXPROPID((0))

MRB评审单-单据头_L

概述
表名称实体名称ORM实体名
T_QM_MRBREVIEWBILL_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
缺陷描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
处理意见FsettlementSettlementFSETTLEMENTnvarchar5102550
其他方面FOthersDescOthersDescFOTHERSDESCnvarchar5102550
原因FReasonReasonFREASONnvarchar5102550
工序说明FOperDescriptionOperDescriptionFOPERDESCRIPTIONnvarchar200010000
索引
名称类型字段
PK_T_QM_MRBREVIEWBILL_LCLUSTEREDFPKID
IDX_QM_MRB_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_T_QM_MRBREVIEWBILL_LPKFPKID
触发器
约束
名称类型字段描述
PK_T_QM_MRBREVIEWBILL_L主键约束FPKID
IDX_QM_MRB_L唯一约束FID
IDX_QM_MRB_L唯一约束FLOCALEID
DF__T_QM_MRBR__FPKID__1E698D3A默认值约束FPKID((0))
DF__T_QM_MRBREV__FID__1F5DB173默认值约束FID((0))

MRB评审单-单据体

概述
表名称实体名称ORM实体名
T_QM_MRBREVIEWBILLENTRY单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
使用决策FUsePolicyUsePolicyFUSEPOLICYchar110('0')
基本单位使用决策数量FBaseUsePolicyQtyBaseUsePolicyQtyFBASEUSEPOLICYQTYdecimal132310((0))
不良处理FIsDefectProcessIsDefectProcessFISDEFECTPROCESSchar110('0')
决策数量FUsePolicyQtyUsePolicyQtyFUSEPOLICYQTYdecimal132310((0))
序列号FSerialIdSerialIdFSERIALIDint4100((0))
辅助属性FAuxPropIdAuxPropIdFAUXPROPIDint4100((0))
检验单使用决策分录内码FQCDetailIdQCDetailIdFQCDETAILIDint4100((0))
检验使用决策数量FIBPolicyQtyIBPolicyQtyFIBPOLICYQTYdecimal132310((0))
检验使用决策基本单位数量FIBPolicyBaseQtyIBPolicyBaseQtyFIBPOLICYBASEQTYdecimal132310((0))
检验单使用决策FQCUsePolicyQCUsePolicyFQCUSEPOLICYchar110
表体物料编码FEMaterialIdEMaterialIdFEMATERIALIDint4100((0))
检验单序列号FQcSerialIdQcSerialIdFQCSERIALIDint4100((0))
检验单辅助属性FQcAuXPropIdQcAuxPropIdFQCAUXPROPIDint4100((0))
判退FIsReturnIsReturnFISRETURNchar110('1')
不良品处理分录内码FDefectEntryIdDefectEntryIdFDEFECTENTRYIDint4100((0))
基本单位入库选单数量FBaseStockInSelQtyBaseStockInSelQtyFBASESTOCKINSELQTYdecimal132310((0))
入库选单数量FSTOCKINSELQTYSTOCKINSELQTYFSTOCKINSELQTYdecimal132310((0))
索引
名称类型字段
PK_QM_MRBREVIEWBILLENTRYCLUSTEREDFENTRYID
IDX_QM_MRBENTRY_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_MRBREVIEWBILLENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_MRBREVIEWBILLENTRY主键约束FENTRYID
DF__T_QM_MRBR__FISRE__0DD42FDF默认值约束FISRETURN('1')
DF__T_QM_MRBR__FAUXP__0E1E16D8默认值约束FAUXPROPID((0))
DF__T_QM_MRBR__FIBPO__0F123B11默认值约束FIBPOLICYQTY((0))
DF__T_QM_MRBR__FIBPO__10065F4A默认值约束FIBPOLICYBASEQTY((0))
DF__T_QM_MRBR__FQCDE__10FA8383默认值约束FQCDETAILID((0))
DF__T_QM_MRBR__FQCAU__11EEA7BC默认值约束FQCAUXPROPID((0))
DF__T_QM_MRBR__FQCSE__12E2CBF5默认值约束FQCSERIALID((0))
DF__T_QM_MRBR__FEMAT__13D6F02E默认值约束FEMATERIALID((0))
DF__T_QM_MRBREV__FID__16C86B72默认值约束FID((0))
DF__T_QM_MRBR__FUSEP__17BC8FAB默认值约束FUSEPOLICY('0')
DF__T_QM_MRBR__FUSEP__18B0B3E4默认值约束FUSEPOLICYQTY((0))
DF__T_QM_MRBR__FISDE__19A4D81D默认值约束FISDEFECTPROCESS('0')
DF__T_QM_MRBR__FBASE__1A98FC56默认值约束FBASEUSEPOLICYQTY((0))
DF__T_QM_MRBR__FSERI__219AFFA0默认值约束FSERIALID((0))
DF__T_QM_MRBR__FDEFE__397DA7F3默认值约束FDEFECTENTRYID((0))
DF__T_QM_MRBR__FBASE__43D3832D默认值约束FBASESTOCKINSELQTY((0))
DF__T_QM_MRBR__FSTOC__44C7A766默认值约束FSTOCKINSELQTY((0))

MRB评审单-单据体_L

概述
表名称实体名称ORM实体名
T_QM_MRBREVIEWBILLENTRY_L单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
使用决策备注FMemoMemoFMEMOnvarchar5102550
索引
名称类型字段
PK_QM_MRBREVIEWBILLENTRY_LCLUSTEREDFPKID
IDX_QM_MRBE_LNONCLUSTEREDFENTRYIDFLOCALEID
主外键
名称类型字段
PK_QM_MRBREVIEWBILLENTRY_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_MRBREVIEWBILLENTRY_L主键约束FPKID
DF__T_QM_MRBR__FPKID__1C8144C8默认值约束FPKID((0))

MRB评审单-关联关系表

概述
表名称实体名称ORM实体名
T_QM_MRBREVIEWBILL_LK关联关系表FBillHead_Link
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值
业务流程图FBillHead_Link_FFlowIdFlowIdFFLOWIDvarchar36360
推进路线FBillHead_Link_FFlowLineIdFlowLineIdFFLOWLINEIDint4100
转换规则FBillHead_Link_FRuleIdRuleIdFRULEIDvarchar36360
源单表内码FBillHead_Link_FSTableIdSTableIdFSTABLEIDint4100
源单表FBillHead_Link_FSTableNameSTableNameFSTABLENAMEvarchar30300
源单内码FBillHead_Link_FSBillIdSBillIdFSBILLIDvarchar36360
源单分录内码FBillHead_Link_FSIdSIdFSIDvarchar36360
原始携带量FBillHead_Link_FBaseQtyOldBaseQtyOldFBASEQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseReAcceptQtyOldBaseReAcceptQtyOldFBASEREACCEPTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseReAcceptQtyBaseReAcceptQtyFBASEREACCEPTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseRejectQtyOldBaseRejectQtyOldFBASEREJECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseRejectQtyBaseRejectQtyFBASEREJECTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseWBInspectQtyOldBaseWBInspectQtyOldFBASEWBINSPECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseWBInspectQtyBaseWBInspectQtyFBASEWBINSPECTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBasePickQtyOldBasePickQtyOldFBASEPICKQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBasePickQtyBasePickQtyFBASEPICKQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseMtrlScrapQtyOldBaseMtrlScrapQtyOldFBASEMTRLSCRAPQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseMtrlScrapQtyBaseMtrlScrapQtyFBASEMTRLSCRAPQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseProcScrapQtyOldBaseProcScrapQtyOldFBASEPROCSCRAPQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseProcScrapQtyBaseProcScrapQtyFBASEPROCSCRAPQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseScrapQtyOldBaseScrapQtyOldFBASESCRAPQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseScrapQtyBaseScrapQtyFBASESCRAPQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseRepairQtyOldBaseRepairQtyOldFBASEREPAIRQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseRepairQtyBaseRepairQtyFBASEREPAIRQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseDefectQtyOldBaseDefectQtyOldFBASEDEFECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseDefectQtyBaseDefectQtyFBASEDEFECTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseReMadeQtyOldBaseReMadeQtyOldFBASEREMADEQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseReMadeQtyBaseReMadeQtyFBASEREMADEQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseAcceptQtyOldBaseAcceptQtyOldFBASEACCEPTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseAcceptQtyBaseAcceptQtyFBASEACCEPTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseIncDefectQtyOldBaseIncDefectQtyOldFBASEINCDEFECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseIncDefectQtyBaseIncDefectQtyFBASEINCDEFECTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseProDefectQtyOldBaseProDefectQtyOldFBASEPRODEFECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseProDefectQtyBaseProDefectQtyFBASEPRODEFECTQTYdecimal132310((0))
索引
名称类型字段
PK_QM_MRBREVIEWBILL_LKCLUSTEREDFLINKID
IDX_QM_MRB_LK_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_MRBREVIEWBILL_LKPKFLINKID
触发器
约束
名称类型字段描述
PK_QM_MRBREVIEWBILL_LK主键约束FLINKID
DF__T_QM_MRBR__FBASE__00D92A53默认值约束FBASEREJECTQTY((0))
DF__T_QM_MRBR__FBASE__01CD4E8C默认值约束FBASEREJECTQTYOLD((0))
DF__T_QM_MRBR__FBASE__17ED395F默认值约束FBASEINCDEFECTQTY((0))
DF__T_QM_MRBR__FBASE__18E15D98默认值约束FBASEINCDEFECTQTYOLD((0))
DF__T_QM_MRBR__FBASE__19D581D1默认值约束FBASEPRODEFECTQTY((0))
DF__T_QM_MRBR__FBASE__1AC9A60A默认值约束FBASEPRODEFECTQTYOLD((0))
DF__T_QM_MRBR__FBASE__25551D07默认值约束FBASESCRAPQTY((0))
DF__T_QM_MRBR__FBASE__26494140默认值约束FBASESCRAPQTYOLD((0))
DF__T_QM_MRBR__FBASE__273D6579默认值约束FBASEREPAIRQTY((0))
DF__T_QM_MRBR__FBASE__283189B2默认值约束FBASEREPAIRQTYOLD((0))
DF__T_QM_MRBR__FBASE__2925ADEB默认值约束FBASEDEFECTQTY((0))
DF__T_QM_MRBR__FBASE__2A19D224默认值约束FBASEDEFECTQTYOLD((0))
DF__T_QM_MRBR__FBASE__2B0DF65D默认值约束FBASEREMADEQTY((0))
DF__T_QM_MRBR__FBASE__2C021A96默认值约束FBASEREMADEQTYOLD((0))
DF__T_QM_MRBR__FBASE__2CF63ECF默认值约束FBASEACCEPTQTY((0))
DF__T_QM_MRBR__FBASE__2DEA6308默认值约束FBASEACCEPTQTYOLD((0))
DF__T_QM_MRBR__FLINK__7473536E默认值约束FLINKID((0))
DF__T_QM_MRBR__FBASE__756777A7默认值约束FBASEQTY((0))
DF__T_QM_MRBR__FBASE__765B9BE0默认值约束FBASEQTYOLD((0))
DF__T_QM_MRBR__FBASE__774FC019默认值约束FBASEWBINSPECTQTY((0))
DF__T_QM_MRBR__FBASE__7843E452默认值约束FBASEWBINSPECTQTYOLD((0))
DF__T_QM_MRBR__FBASE__7938088B默认值约束FBASEPICKQTY((0))
DF__T_QM_MRBR__FBASE__7A2C2CC4默认值约束FBASEPICKQTYOLD((0))
DF__T_QM_MRBR__FBASE__7B2050FD默认值约束FBASEREACCEPTQTY((0))
DF__T_QM_MRBR__FBASE__7C147536默认值约束FBASEREACCEPTQTYOLD((0))
DF__T_QM_MRBR__FBASE__7D08996F默认值约束FBASEMTRLSCRAPQTY((0))
DF__T_QM_MRBR__FBASE__7DFCBDA8默认值约束FBASEMTRLSCRAPQTYOLD((0))
DF__T_QM_MRBR__FBASE__7EF0E1E1默认值约束FBASEPROCSCRAPQTY((0))
DF__T_QM_MRBR__FBASE__7FE5061A默认值约束FBASEPROCSCRAPQTYOLD((0))

1.1.15 其他请检单

其他请检单-基本信息

概述
表名称实体名称ORM实体名
T_QM_OTHERQCAPP基本信息BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
单据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
审核人FApproverIdApproverIdFAPPROVERIDint4100
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
作废日期FCancelDateCancelDateFCANCELDATEdatetime8233
作废人FCancelerCANCELERFCANCELERint4100
作废状态FCancelStatusCancelStatusFCANCELSTATUSchar110
单据类型FBillTypeIDBillTypeIDFBILLTYPEIDvarchar36360
日期FDateDateFDATEdatetime8233
申请组织FAppOrgIdAppOrgIdFAPPORGIDint4100
部门FAppDepIdAppDepIdFAPPDEPIDint4100
库存组FStockGroupIdStockGroupIdFSTOCKGROUPIDint4100
仓管员FStockerIdStockerIdFSTOCKERIDint4100
索引
名称类型字段
PK_QM_OTHERQCAPPCLUSTEREDFID
IDX_QM_OTHERQCAPP_NONONCLUSTEREDFBILLNO
IDX_QM_OTHERQCAPP_DATENONCLUSTEREDFDATE
主外键
名称类型字段
PK_QM_OTHERQCAPPPKFID
触发器
约束
名称类型字段描述
PK_QM_OTHERQCAPP主键约束FID
DF__T_QM_OTHERQ__FID__6692A791默认值约束FID((0))

其他请检单-基本信息_L

概述
表名称实体名称ORM实体名
T_QM_OTHERQCAPP_L基本信息BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_OTHERQCAPP_LCLUSTEREDFPKID
IDX_QM_OTHERQCAPP_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_OTHERQCAPP_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_OTHERQCAPP_L主键约束FPKID
DF__T_QM_OTHE__FPKID__687AF003默认值约束FPKID((0))

其他请检单-分录明细

概述
表名称实体名称ORM实体名
T_QM_OTHERQCAPPENTRY分录明细Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
物料编码FMaterialIdMaterialIdFMATERIALIDint4100
辅助属性FAuxPropIdAuxPropIdFAUXPROPIDint4100
BOM版本FBomIdBomIdFBOMIDint4100
计划跟踪号FMtoNoMtoNoFMTONOnvarchar5102550
单位FUnitIDUnitIDFUNITIDint4100
数量FQtyQtyFQTYdecimal132310((0))
仓库FStockIdStockIdFSTOCKIDint4100
仓位FStockLocIdStockLocIdFSTOCKLOCIDint4100
批号FLotLotFLOTint4100
生产日期FProduceDateProduceDateFPRODUCEDATEdatetime8233
有效期至FExpiryDateExpiryDateFEXPIRYDATEdatetime8233
基本单位FBaseUnitIdBaseUnitIdFBASEUNITIDint4100((0))
序列号单位FSNUnitIDSNUnitIDFSNUNITIDint4100((0))
基本单位数量FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
序列号单位数量FSNQtySNQtyFSNQTYint4100((0))
货主类型FOwnerTypeIdOwnerTypeIdFOWNERTYPEIDvarchar36360
货主FOwnerIdOwnerIdFOWNERIDint4100((0))
基本单位检验选单数量FBaseSelInspectQtyBaseSelInspectQtyFBASESELINSPECTQTYdecimal132310((0))
检验选单数量FSelInspectQtySelInspectQtyFSELINSPECTQTYdecimal132310((0))
保管者类型FKeeperTypeIdKeeperTypeIdFKEEPERTYPEIDvarchar36360
保管者FKeeperIdKeeperIdFKEEPERIDint4100((0))
基本单位检验数量FBaseInspectQtyBaseInspectQtyFBASEINSPECTQTYdecimal132310((0))
检验数量FInspectQtyInspectQtyFINSPECTQTYdecimal132310((0))
需要检验FIsInspectIsInspectFISINSPECTchar110('0')
索引
名称类型字段
PK_QM_OTHERQCAPPENTRYCLUSTEREDFENTRYID
IDX_QM_OTHERQCAPPE_IDNONCLUSTEREDFID
IDX_QM_OTHERQCAPPE_MTRLIDNONCLUSTEREDFMATERIALID
主外键
名称类型字段
PK_QM_OTHERQCAPPENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_OTHERQCAPPENTRY主键约束FENTRYID
DF__T_QM_OTHE__FENTR__6A633875默认值约束FENTRYID((0))
DF__T_QM_OTHE__FOWNE__6B575CAE默认值约束FOWNERID((0))
DF__T_QM_OTHER__FQTY__6C4B80E7默认值约束FQTY((0))
DF__T_QM_OTHE__FBASE__6D3FA520默认值约束FBASEUNITID((0))
DF__T_QM_OTHE__FBASE__6E33C959默认值约束FBASEQTY((0))
DF__T_QM_OTHE__FSNUN__6F27ED92默认值约束FSNUNITID((0))
DF__T_QM_OTHE__FSNQT__701C11CB默认值约束FSNQTY((0))
DF__T_QM_OTHE__FSELI__71103604默认值约束FSELINSPECTQTY((0))
DF__T_QM_OTHE__FBASE__72045A3D默认值约束FBASESELINSPECTQTY((0))
DF__T_QM_OTHE__FINSP__72F87E76默认值约束FINSPECTQTY((0))
DF__T_QM_OTHE__FBASE__73ECA2AF默认值约束FBASEINSPECTQTY((0))
DF__T_QM_OTHE__FKEEP__74E0C6E8默认值约束FKEEPERID((0))
DF__T_QM_OTHE__FISIN__75D4EB21默认值约束FISINSPECT('0')

其他请检单-序列号子单据体

概述
表名称实体名称ORM实体名
T_QM_OTHERQCAPPSERIAL序列号子单据体SerialSubEntity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
序列号FSerialNoSerialNoFSERIALNOnvarchar160800(' ')
序列号FSerialIdSerialIdFSERIALIDint4100((0))
备注FSerialNoteSerialNoteFSERIALNOTEnvarchar5102550
检验关联标志FInspectFlagInspectFlagFINSPECTFLAGchar110('0')
索引
名称类型字段
PK_QM_OTHERQCAPPSERIALCLUSTEREDFDETAILID
IDX_QM_OTHQCAPPSN_EIDNONCLUSTEREDFENTRYID
IDX_QM_OTHQCAPPSN_SNNONCLUSTEREDFSERIALNO
主外键
名称类型字段
PK_QM_OTHERQCAPPSERIALPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_OTHERQCAPPSERIAL主键约束FDETAILID
DF__T_QM_OTHE__FINSP__00527994默认值约束FINSPECTFLAG('0')
DF__T_QM_OTHE__FDETA__7B8DC477默认值约束FDETAILID((0))
DF__T_QM_OTHE__FENTR__7C81E8B0默认值约束FENTRYID((0))
DF__T_QM_OTHER__FSEQ__7D760CE9默认值约束FSEQ((0))
DF__T_QM_OTHE__FSERI__7E6A3122默认值约束FSERIALNO(' ')
DF__T_QM_OTHE__FSERI__7F5E555B默认值约束FSERIALID((0))

其他请检单-关联关系表

概述
表名称实体名称ORM实体名
T_QM_OTHERQCAPPENTRY_LK关联关系表FEntity_Link
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值
业务流程图FEntity_Link_FFlowIdFlowIdFFLOWIDvarchar36360
推进路线FEntity_Link_FFlowLineIdFlowLineIdFFLOWLINEIDint4100((0))
转换规则FEntity_Link_FRuleIdRuleIdFRULEIDvarchar36360
源单表内码FEntity_Link_FSTableIdSTableIdFSTABLEIDint4100
源单表FEntity_Link_FSTableNameSTableNameFSTABLENAMEvarchar30300
源单内码FEntity_Link_FSBillIdSBillIdFSBILLIDvarchar36360
源单分录内码FEntity_Link_FSIdSIdFSIDvarchar36360
原始携带量FEntity_Link_FBaseQtyOldBaseQtyOldFBASEQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
索引
名称类型字段
PK_QM_OTHERQCAPPENTRY_LKCLUSTEREDFLINKID
IDX_QM_OTHQC_LK_SIDNONCLUSTEREDFSID
IDX_QM_OTHQC_LK_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_OTHERQCAPPENTRY_LKPKFLINKID
触发器
约束
名称类型字段描述
PK_QM_OTHERQCAPPENTRY_LK主键约束FLINKID
DF__T_QM_OTHE__FFLOW__77BD3393默认值约束FFLOWLINEID((0))
DF__T_QM_OTHE__FBASE__78B157CC默认值约束FBASEQTYOLD((0))
DF__T_QM_OTHE__FBASE__79A57C05默认值约束FBASEQTY((0))

1.1.16 决策数量汇总模型

决策数量汇总模型-单据头

概述
表名称实体名称ORM实体名
T_QM_POLICYQTYSUM单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
系统预设FIsSystemSetIsSystemSetFISSYSTEMSETchar110('1')
业务类型FQCBusinessTypeFQCBusinessTypeFQCBUSINESSTYPEvarchar220('0')
索引
名称类型字段
PK_QM_POLICYQTYSUMCLUSTEREDFID
IDX_QM_PQS_BILLNONONCLUSTEREDFBILLNO
主外键
名称类型字段
PK_QM_POLICYQTYSUMPKFID
触发器
约束
名称类型字段描述
PK_QM_POLICYQTYSUM主键约束FID
DF__T_QM_POLICY__FID__01145D6B默认值约束FID((0))
DF__T_QM_POLI__FISSY__02FCA5DD默认值约束FISSYSTEMSET('1')
DF__T_QM_POLI__FQCBU__020881A4默认值约束FQCBUSINESSTYPE('0')

决策数量汇总模型-单据体

概述
表名称实体名称ORM实体名
T_QM_POLICYQTYSUMENTRY单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
目标字段标识FTargetFieldKeyTargetFieldKeyFTARGETFIELDKEYvarchar30300
目标字段属性FTargetFieldPropTargetFieldPropFTARGETFIELDPROPvarchar30300
使用决策FUsePolicyUsePolicyFUSEPOLICYchar110('0')
是否反写FIsWriteBackIsWriteBackFISWRITEBACKchar110('1')
是否不良处理FIsDefectProcessIsDefectProcessFISDEFECTPROCESSchar110('0')
是否MRB评审FIsMRBReviewIsMRBReviewFISMRBREVIEWchar110('0')
索引
名称类型字段
PK_QM_POLICYQTYSUMENTRYCLUSTEREDFENTRYID
IDX_QM_PQSE_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_POLICYQTYSUMENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_POLICYQTYSUMENTRY主键约束FENTRYID
DF__T_QM_POLI__FISDE__39254312默认值约束FISDEFECTPROCESS('0')
DF__T_QM_POLI__FENTR__607283AF默认值约束FENTRYID((0))
DF__T_QM_POLI__FUSEP__6166A7E8默认值约束FUSEPOLICY('0')
DF__T_QM_POLI__FISWR__625ACC21默认值约束FISWRITEBACK('1')
DF__T_QM_POLI__FISMR__6DC655DF默认值约束FISMRBREVIEW('0')

1.1.17 我的质检业绩

1.1.18 质检方案

质检方案-单据头

概述
表名称实体名称ORM实体名
T_QM_QCSCHEME单据头
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
抽样方案FSampleSchemeIdFSampleSchemeIdFSAMPLESCHEMEIDint4100
失效日期FExpireDateFExpireDateFEXPIREDATEdatetime8233
生效日期FEffectDateFEffectDateFEFFECTDATEdatetime8233
操作指导书FAttachmentAttachmentFATTACHMENTnvarchar5102550
图片FImageImageFIMAGEnvarchar5102550
适用范围FApplyScopeApplyScopeFAPPLYSCOPEchar110('3')
适用业务类型FApplyBusinessTypeApplyBusinessTypeFAPPLYBUSINESSTYPEvarchar50500
索引
名称类型字段
PK_QM_QCSCHEMECLUSTEREDFID
IDX_QM_QCSCHEME_NUMNONCLUSTEREDFNUMBER
IDX_QM_QCSCHEME_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_QCSCHEMEPKFID
触发器
约束
名称类型字段描述
PK_QM_QCSCHEME主键约束FID
DF__T_QM_QCSCHE__FID__36B088B6默认值约束FID((0))
DF__T_QM_QCSC__FMAST__37A4ACEF默认值约束FMASTERID((0))
DF__T_QM_QCSC__FAPPL__3F070680默认值约束FAPPLYSCOPE('3')

质检方案-单据头_L

概述
表名称实体名称ORM实体名
T_QM_QCSCHEME_L单据头
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_QCSCHEME_LCLUSTEREDFPKID
IDX_QM_QCSCHEME_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_QCSCHEME_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_QCSCHEME_L主键约束FPKID
DF__T_QM_QCSC__FPKID__398CF561默认值约束FPKID((0))

质检方案-检验项目

概述
表名称实体名称ORM实体名
T_QM_QCSCHEMEENTRY检验项目Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检验项目FInspectItemIdInspectItemIdFINSPECTITEMIDint4100
分析方法FAnalysisMethodAnalysisMethodFANALYSISMETHODchar110('0')
缺陷等级FDefectlevelDefectLevelFDEFECTLEVELchar110('0')
破坏性检验FDestructInspectDestructInspectFDESTRUCTINSPECTchar110('0')
重点检查FKeyInspectKeyInspectFKEYINSPECTchar110('0')
质量标准FQualityStdIdQualityStdIdFQUALITYSTDIDint4100
检验方法FInspectMethodIdInspectMethodIdFINSPECTMETHODIDint4100
检验仪器FInspectInstrumentIdInspectInstrumentIdFINSPECTINSTRUMENTIDint4100
检验依据FInspectBasisIdInspectBasisIdFINSPECTBASISIDint4100
抽样方案FSampleSchemeId1SampleSchemeIdFSAMPLESCHEMEIDint4100
单位FUnitIdUnitIdFUNITIDint4100
比较符FCompareSymbolCompareSymbolFCOMPARESYMBOLchar110('0')
状态FStatusStatusFSTATUSchar110('0')
启用样本检测值FEnableQcValueEnableQcValueFENABLEQCVALUEchar110('1')
0值无效FIsZeroNotValidateIsZeroNotValidateFISZERONOTVALIDATEchar110('0')
索引
名称类型字段
PK_QM_QCSCHEMEENTRYCLUSTEREDFENTRYID
IDX_QM_QCSE_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_QCSCHEMEENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_QCSCHEMEENTRY主键约束FENTRYID
DF_T_QM_QCSCHEMEENTRY_FSTATUS默认值约束FSTATUS('0')
DF_T_QM_QCSCHEMEENTRY_FCOMPARESYMBOL默认值约束FCOMPARESYMBOL('0')
DF__T_QM_QCSC__FANAL__282E2A8C默认值约束FANALYSISMETHOD('0')
DF__T_QM_QCSC__FDEFE__29224EC5默认值约束FDEFECTLEVEL('0')
DF__T_QM_QCSC__FDEST__2A1672FE默认值约束FDESTRUCTINSPECT('0')
DF__T_QM_QCSC__FKEYI__2B0A9737默认值约束FKEYINSPECT('0')
DF__T_QM_QCSC__FENTR__3B753DD3默认值约束FENTRYID((0))
DF__T_QM_QCSC__FENAB__416122E2默认值约束FENABLEQCVALUE('1')
DF__T_QM_QCSC__FISZE__56E657A1默认值约束FISZERONOTVALIDATE('0')

质检方案-检验项目_A

概述
表名称实体名称ORM实体名
T_QM_QCSCHEMEENTRY_A检验项目Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
目标值FTargetValTargetValFTARGETVALnvarchar5102550
上限值FUpLimitUpLimitFUPLIMITnvarchar5102550
下限值FDownLimitDownLimitFDOWNLIMITnvarchar5102550
上偏差FUpOffsetUpOffsetFUPOFFSETnvarchar5102550
下偏差FDownOffsetDownOffsetFDOWNOFFSETnvarchar5102550
目标值KeyFTargetValKeyTargetValKeyFTARGETVALKEYvarchar36360
上限值KeyFUpLimitKeyUpLimitKeyFUPLIMITKEYvarchar36360
下限值KeyFDownLimitKeyDownLimitKeyFDOWNLIMITKEYvarchar36360
上偏差KeyFUpOffsetKeyUpOffsetKeyFUPOFFSETKEYvarchar36360
下偏差KeyFDownOffsetKeyDownOffsetKeyFDOWNOFFSETKEYvarchar36360
目标值数量FTargetValQTargetValQFTARGETVALQdecimal132310
上限值数量FUpLimitQUpLimitQFUPLIMITQdecimal132310
下限值数量FDownLimitQDownLimitQFDOWNLIMITQdecimal132310
上偏差数量FUpOffsetQUpOffsetQFUPOFFSETQdecimal132310
下偏差数量FDownOffsetQDownOffsetQFDOWNOFFSETQdecimal132310
目标值基础资料FTargetValBTargetValBFTARGETVALBint4100
上限值基础资料FUpLimitBUpLimitBFUPLIMITBint4100
下限值基础资料FDownLimitBDownLimitBFDOWNLIMITBint4100
上偏差基础资料FUpOffsetBUpOffsetBFUPOFFSETBint4100
下偏差基础资料FDownOffsetBDownOffsetBFDOWNOFFSETBint4100
目标值文本FTargetValTTargetValTFTARGETVALTnvarchar5102550
上限值文本FUpLimitTUpLimitTFUPLIMITTnvarchar5102550
下限值文本FDownLimitTDownLimitTFDOWNLIMITTnvarchar5102550
上偏差文本FUpOffsetTUpOffsetTFUPOFFSETTnvarchar5102550
下偏差文本FDownOffsetTDownOffsetTFDOWNOFFSETTnvarchar5102550
索引
名称类型字段
PK_QM_QCSCHEMEENTRY_ACLUSTEREDFENTRYID
IDX_QM_QCSEA_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_QCSCHEMEENTRY_APKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_QCSCHEMEENTRY_A主键约束FENTRYID
DF__T_QM_QCSC__FENTR__46B2B1AC默认值约束FENTRYID((0))

质检方案-适用范围

概述
表名称实体名称ORM实体名
T_QM_QCSCHEMESCOPE适用范围EntityScope
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
物料编码FMaterialIdMaterialIdFMATERIALIDint4100((0))
物料分组FMaterialGroupIdMaterialGroupIdFMATERIALGROUPIDint4100((0))
索引
名称类型字段
PK_QM_QCSCHEMESCOPECLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_QCSCHEMESCOPEPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_QCSCHEMESCOPE主键约束FENTRYID
DF__T_QM_QCSCHE__FID__3A425163默认值约束FID((0))
DF__T_QM_QCSC__FENTR__3B36759C默认值约束FENTRYID((0))
DF__T_QM_QCSCH__FSEQ__3C2A99D5默认值约束FSEQ((0))
DF__T_QM_QCSC__FMATE__3D1EBE0E默认值约束FMATERIALID((0))
DF__T_QM_QCSC__FMATE__3E12E247默认值约束FMATERIALGROUPID((0))

1.1.19 检验反写单

检验反写单-单据头

概述
表名称实体名称ORM实体名
T_QM_INSPECTBILLENTRY_A单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110('B')
源单编号FSrcBillNoFSrcBillNoFSRCBILLNOnvarchar160800
源单类型FSrcBillTypeSrcBillTypeFSRCBILLTYPEvarchar36360
基本单位FBaseUnitIdFBaseUnitIdFBASEUNITIDint4100
样本破坏数量FBaseSampleDamageQtyBaseSampleDamageQtyFBASESAMPLEDAMAGEQTYdecimal132310((0))
样本破坏承担方FSampleDamageBearerSampleDamageBearerFSAMPLEDAMAGEBEARERchar110('0')
接收数量FBaseAcceptQtyBaseAcceptQtyFBASEACCEPTQTYdecimal132310((0))
判退数量FBaseRejectQtyBaseRejectQtyFBASEREJECTQTYdecimal132310((0))
不良数量FBaseDefectQtyBaseDefectQtyFBASEDEFECTQTYdecimal132310((0))
报废数量FBaseScrapQtyBaseScrapQtyFBASESCRAPQTYdecimal132310((0))
返修数量FBaseRepairQtyBaseRepairQtyFBASEREPAIRQTYdecimal132310((0))
检验数量FBaseInspectQtyBaseInspectQtyFBASEINSPECTQTYdecimal132310((0))
检验物料FMaterialIdMaterialIdFMATERIALIDint4100
检验结果FInspectResultInspectResultFINSPECTRESULTchar110('0')
业务类型FQCBusinessTypeQCBusinessTypeFQCBUSINESSTYPEvarchar220('0')
挑选数量FBasePickQtyBasePickQtyFBASEPICKQTYdecimal132310((0))
料废数量FBaseMtrlScrapQtyBaseMtrlScrapQtyFBASEMTRLSCRAPQTYdecimal132310((0))
工废数量FBaseProcScrapQtyBaseProcScrapQtyFBASEPROCSCRAPQTYdecimal132310((0))
让步接收数量FBaseReAcceptQtyBaseReAcceptQtyFBASEREACCEPTQTYdecimal132310((0))
基本单位反写检验数量FBaseWBInspectQtyBaseWBInspectQtyFBASEWBINSPECTQTYdecimal132310((0))
工位/工序FPrdLineLocationPrdLineLocationFPRDLINELOCATIONint4100((0))
不合格可销售数量FBaseUnQuaSalQtyBaseUnQuaSalQtyFBASEUNQUASALQTYdecimal132310((0))
源单内码FSrcInterIdSrcInterIdFSRCINTERIDint4100
源单分录内码FSrcEntryIdSrcEntryIdFSRCENTRYIDint4100
源单分录行号FSrcEntrySeqSrcEntrySeqFSRCENTRYSEQint4100
返工数量FBaseReMadeQtyBaseReMadeQtyFBASEREMADEQTYdecimal132310((0))
新有效期至FNewExpiryDateNewExpiryDateFNEWEXPIRYDATEdatetime8233
来料不良数量FBaseIncDefectQtyBaseIncDefectQtyFBASEINCDEFECTQTYdecimal132310((0))
作业不良数量FBaseProDefectQtyBaseProDefectQtyFBASEPRODEFECTQTYdecimal132310((0))
索引
名称类型字段
PK_QM_INSPECTBILLENTRY_ACLUSTEREDFENTRYID
IDX_QM_IBE_A_IDNONCLUSTEREDFID
IDX_QM_IBE_A_BILLNONONCLUSTEREDFBILLNO
IDX_QM_IBE_A_MTRLIDNONCLUSTEREDFMATERIALID
IDX_QM_QC_BUSINESSTYPENONCLUSTEREDFQCBUSINESSTYPE
主外键
名称类型字段
PK_QM_INSPECTBILLENTRY_APKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBILLENTRY_A主键约束FENTRYID
DF__T_QM_INSP__FBOMI__04230A78默认值约束FBOMID((0))
DF__T_QM_INSP__FSTOC__05172EB1默认值约束FSTOCKGROUPID((0))
DF__T_QM_INSP__FSTOC__060B52EA默认值约束FSTOCKERID((0))
DF__T_QM_INSP__FCURR__36E3946F默认值约束FCURRENTSTRINGENCY('1')
DF__T_QM_INSP__FBASE__3A19674B默认值约束FBASEREACCEPTQTY((0))
DF__T_QM_INSP__FBASE__3B0D8B84默认值约束FBASEWBINSPECTQTY((0))
DF__T_QM_INSP__FENTR__52246458默认值约束FENTRYID((0))
DF__T_QM_INSP__FDOCU__540CACCA默认值约束FDOCUMENTSTATUS('B')
DF__T_QM_INSP__FSAMP__5500D103默认值约束FSAMPLEDAMAGEBEARER('0')
DF__T_QM_INSP__FINSP__55F4F53C默认值约束FINSPECTRESULT('0')
DF__T_QM_INSP__FBASE__56E91975默认值约束FBASEINSPECTQTY((0))
DF__T_QM_INSP__FBASE__57DD3DAE默认值约束FBASESAMPLEDAMAGEQTY((0))
DF__T_QM_INSP__FBASE__58B231AD默认值约束FBASEMTRLSCRAPQTY((0))
DF__T_QM_INSP__FBASE__58D161E7默认值约束FBASEACCEPTQTY((0))
DF__T_QM_INSP__FBASE__59A655E6默认值约束FBASEPROCSCRAPQTY((0))
DF__T_QM_INSP__FBASE__59C58620默认值约束FBASEREJECTQTY((0))
DF__T_QM_INSP__FBASE__5AB9AA59默认值约束FBASEDEFECTQTY((0))
DF__T_QM_INSP__FBASE__5BADCE92默认值约束FBASESCRAPQTY((0))
DF__T_QM_INSP__FBASE__5CA1F2CB默认值约束FBASEREPAIRQTY((0))
DF__T_QM_INSP__FBASE__5D961704默认值约束FBASEPICKQTY((0))
DF__T_QM_INSP__FBFLO__5E8A3B3D默认值约束FBFLOWID(' ')
DF__T_QM_INSP__FISFI__643CEBA5默认值约束FISFIRSTINSPECT('0')
DF__T_QM_INSP__FBASE__64E0CE2D默认值约束FBASEREMADEQTY((0))
DF__T_QM_INSP__FPROD__65310FDE默认值约束FPRODUCTLINEID((0))
DF__T_QM_INSP__FPRDL__66253417默认值约束FPRDLINELOCATION((0))
DF__T_QM_INSP__FBASE__67195850默认值约束FBASEUNQUASALQTY((0))
DF__T_QM_INSP__FBASE__6C51A9D5默认值约束FBASESTOCKINSCRAPSELQTY((0))
DF__T_QM_INSP__FSTOC__6D45CE0E默认值约束FSTOCKINSCRAPSELQTY((0))
DF__T_QM_INSP__FSTOC__6E39F247默认值约束FSTOCKINFAILSELQTY((0))
DF__T_QM_INSP__FBASE__6F2E1680默认值约束FBASESTOCKINFAILSELQTY((0))
DF__T_QM_INSP__FSTOC__70223AB9默认值约束FSTOCKINQUASELQTY((0))
DF__T_QM_INSP__FBASE__70973C05默认值约束FBASEINCDEFECTQTY((0))
DF__T_QM_INSP__FBASE__71165EF2默认值约束FBASESTOCKINQUASELQTY((0))
DF__T_QM_INSP__FBASE__718B603E默认值约束FBASEPRODEFECTQTY((0))
DF__T_QM_INSP__FQCBU__53188891默认值约束FQCBUSINESSTYPE('0')

检验反写单-关联关系表

概述
表名称实体名称ORM实体名
T_QM_INSPECTBILLENTRY_LK关联关系表FBillHead_Link
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值
业务流程图FBillHead_Link_FFlowIdFlowIdFFLOWIDvarchar36360(' ')
推进路线FBillHead_Link_FFlowLineIdFlowLineIdFFLOWLINEIDint4100((0))
转换规则FBillHead_Link_FRuleIdRuleIdFRULEIDvarchar36360(' ')
源单表内码FBillHead_Link_FSTableIdSTableIdFSTABLEIDint4100
源单表FBillHead_Link_FSTableNameSTableNameFSTABLENAMEvarchar30300(' ')
源单内码FBillHead_Link_FSBillIdSBillIdFSBILLIDvarchar36360(' ')
源单分录内码FBillHead_Link_FSIdSIdFSIDvarchar36360(' ')
原始携带量FBillHead_Link_FBaseInspectQtyOldBaseInspectQtyOldFBASEINSPECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseInspectQtyBaseInspectQtyFBASEINSPECTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseSampleDamageQtyOldBaseSampleDamageQtyOldFBASESAMPLEDAMAGEQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseSampleDamageQtyBaseSampleDamageQtyFBASESAMPLEDAMAGEQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseAcceptQtyOldBaseAcceptQtyOldFBASEACCEPTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseAcceptQtyBaseAcceptQtyFBASEACCEPTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseReAcceptQtyOldBaseReAcceptQtyOldFBASEREACCEPTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseReAcceptQtyBaseReAcceptQtyFBASEREACCEPTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseRejectQtyOldBaseRejectQtyOldFBASEREJECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseRejectQtyBaseRejectQtyFBASEREJECTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseDefectQtyOldBaseDefectQtyOldFBASEDEFECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseDefectQtyBaseDefectQtyFBASEDEFECTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseScrapQtyOldBaseScrapQtyOldFBASESCRAPQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseScrapQtyBaseScrapQtyFBASESCRAPQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseReMadeQtyOldBaseReMadeQtyOldFBASEREMADEQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseReMadeQtyBaseReMadeQtyFBASEREMADEQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseRepairQtyOldBaseRepairQtyOldFBASEREPAIRQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseRepairQtyBaseRepairQtyFBASEREPAIRQTYdecimal132310((0))
原始携带量FBillHead_Link_FBasePickQtyOldBasePickQtyOldFBASEPICKQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBasePickQtyBasePickQtyFBASEPICKQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseMtrlScrapQtyOldBaseMtrlScrapQtyOldFBASEMTRLSCRAPQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseMtrlScrapQtyBaseMtrlScrapQtyFBASEMTRLSCRAPQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseProcScrapQtyOldBaseProcScrapQtyOldFBASEPROCSCRAPQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseProcScrapQtyBaseProcScrapQtyFBASEPROCSCRAPQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseWBInspectQtyOldBaseWBInspectQtyOldFBASEWBINSPECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseWBInspectQtyBaseWBInspectQtyFBASEWBINSPECTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseUnQuaSalQtyOldBaseUnQuaSalQtyOldFBASEUNQUASALQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseUnQuaSalQtyBaseUnQuaSalQtyFBASEUNQUASALQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseIncDefectQtyOldBaseIncDefectQtyOldFBASEINCDEFECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseIncDefectQtyBaseIncDefectQtyFBASEINCDEFECTQTYdecimal132310((0))
原始携带量FBillHead_Link_FBaseProDefectQtyOldBaseProDefectQtyOldFBASEPRODEFECTQTYOLDdecimal132310((0))
修改携带量FBillHead_Link_FBaseProDefectQtyBaseProDefectQtyFBASEPRODEFECTQTYdecimal132310((0))
索引
名称类型字段
PK_QM_INSPECTBILLENTRY_LKCLUSTEREDFLINKID
IDX_QM_IBE_LK_SIDNONCLUSTEREDFSID
IDX_QM_IBE_LK_SBILLIDNONCLUSTEREDFSBILLID
IDX_QM_IBE_LK_ENTRYDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_INSPECTBILLENTRY_LKPKFLINKID
触发器
约束
名称类型字段描述
PK_QM_INSPECTBILLENTRY_LK主键约束FLINKID
DF__T_QM_INSP__FLINK__1056A0FB默认值约束FLINKID((0))
DF__T_QM_INSP__FSBIL__114AC534默认值约束FSBILLID(' ')
DF__T_QM_INSPE__FSID__123EE96D默认值约束FSID(' ')
DF__T_QM_INSP__FFLOW__13330DA6默认值约束FFLOWID(' ')
DF__T_QM_INSP__FFLOW__142731DF默认值约束FFLOWLINEID((0))
DF__T_QM_INSP__FRULE__151B5618默认值约束FRULEID(' ')
DF__T_QM_INSP__FSTAB__160F7A51默认值约束FSTABLENAME(' ')
DF__T_QM_INSP__FBASE__17039E8A默认值约束FBASEINSPECTQTY((0))
DF__T_QM_INSP__FBASE__17F7C2C3默认值约束FBASEINSPECTQTYOLD((0))
DF__T_QM_INSP__FBASE__18EBE6FC默认值约束FBASEACCEPTQTY((0))
DF__T_QM_INSP__FBASE__19E00B35默认值约束FBASEACCEPTQTYOLD((0))
DF__T_QM_INSP__FBASE__1AD42F6E默认值约束FBASEREJECTQTY((0))
DF__T_QM_INSP__FBASE__1BC853A7默认值约束FBASEREJECTQTYOLD((0))
DF__T_QM_INSP__FBASE__1CBC77E0默认值约束FBASESCRAPQTY((0))
DF__T_QM_INSP__FBASE__1DB09C19默认值约束FBASESCRAPQTYOLD((0))
DF__T_QM_INSP__FBASE__1EA4C052默认值约束FBASEREPAIRQTY((0))
DF__T_QM_INSP__FBASE__1F98E48B默认值约束FBASEREPAIRQTYOLD((0))
DF__T_QM_INSP__FBASE__208D08C4默认值约束FBASEDEFECTQTY((0))
DF__T_QM_INSP__FBASE__21812CFD默认值约束FBASEDEFECTQTYOLD((0))
DF__T_QM_INSP__FBASE__22755136默认值约束FBASESAMPLEDAMAGEQTY((0))
DF__T_QM_INSP__FBASE__2369756F默认值约束FBASESAMPLEDAMAGEQTYOLD((0))
DF__T_QM_INSP__FBASE__245D99A8默认值约束FBASEPICKQTY((0))
DF__T_QM_INSP__FBASE__2551BDE1默认值约束FBASEPICKQTYOLD((0))
DF__T_QM_INSP__FBASE__2CBF6C2D默认值约束FBASEREACCEPTQTY((0))
DF__T_QM_INSP__FBASE__2DB39066默认值约束FBASEWBINSPECTQTY((0))
DF__T_QM_INSP__FBASE__2EA7B49F默认值约束FBASEREACCEPTQTYOLD((0))
DF__T_QM_INSP__FBASE__2F9BD8D8默认值约束FBASEWBINSPECTQTYOLD((0))
DF__T_QM_INSP__FINSP__521E3B6A默认值约束FINSPECTQTY((0))
DF__T_QM_INSP__FINSP__53125FA3默认值约束FINSPECTQTYOLD((0))
DF__T_QM_INSP__FBASE__6254A333默认值约束FBASEUNQUASALQTY((0))
DF__T_QM_INSP__FBASE__6348C76C默认值约束FBASEUNQUASALQTYOLD((0))
DF__T_QM_INSP__FBASE__65D4F266默认值约束FBASEREMADEQTY((0))
DF__T_QM_INSP__FBASE__66C9169F默认值约束FBASEREMADEQTYOLD((0))
DF__T_QM_INSP__FBASE__717DDF77默认值约束FBASEMTRLSCRAPQTY((0))
DF__T_QM_INSP__FBASE__727203B0默认值约束FBASEMTRLSCRAPQTYOLD((0))
DF__T_QM_INSP__FBASE__727F8477默认值约束FBASEINCDEFECTQTY((0))
DF__T_QM_INSP__FBASE__736627E9默认值约束FBASEPROCSCRAPQTY((0))
DF__T_QM_INSP__FBASE__7373A8B0默认值约束FBASEINCDEFECTQTYOLD((0))
DF__T_QM_INSP__FBASE__745A4C22默认值约束FBASEPROCSCRAPQTYOLD((0))
DF__T_QM_INSP__FBASE__7467CCE9默认值约束FBASEPRODEFECTQTY((0))
DF__T_QM_INSP__FBASE__755BF122默认值约束FBASEPRODEFECTQTYOLD((0))

1.1.20 质量标准

质量标准-单据头

概述
表名称实体名称ORM实体名
T_QM_QUALITYSTD单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
索引
名称类型字段
PK_QM_QUALITYSTDCLUSTEREDFID
IDX_QM_QUALITYSTD_NUMNONCLUSTEREDFNUMBER
IDX_QM_QUALITYSTD_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_QUALITYSTDPKFID
触发器
约束
名称类型字段描述
PK_QM_QUALITYSTD主键约束FID
DF__T_QM_QUALIT__FID__3D5D8645默认值约束FID((0))
DF__T_QM_QUAL__FMAST__3E51AA7E默认值约束FMASTERID((0))

质量标准-单据头_L

概述
表名称实体名称ORM实体名
T_QM_QUALITYSTD_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_QUALITYSTD_LCLUSTEREDFPKID
IDX_QM_QUALITYSTD_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_QUALITYSTD_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_QUALITYSTD_L主键约束FPKID
DF__T_QM_QUAL__FPKID__4039F2F0默认值约束FPKID((0))

1.1.21 生产退料请检单

生产退料请检单-单据头

概述
表名称实体名称ORM实体名
T_QM_RETURNMTRAPPQC单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
单据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
审核人FApproverIdApproverIdFAPPROVERIDint4100
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
作废日期FCancelDateCancelDateFCANCELDATEdatetime8233
作废人FCancelerCANCELERFCANCELERint4100
作废状态FCancelStatusCancelStatusFCANCELSTATUSchar110
单据类型FBillTypeIDFBillTypeIDFBILLTYPEIDvarchar36360
单据日期FDateFDateFDATEdatetime8233
收料组织FStockOrgIdStockOrgIdFSTOCKORGIDint4100
生产组织FPrdOrgIdPrdOrgIdFPRDORGIDint4100
库存组FStockGroupIdStockGroupIdFSTOCKGROUPIDint4100
索引
名称类型字段
PK_QM_RETURNMTRAPPQCCLUSTEREDFID
IDX_QM_RETURNMTRAPP_NONONCLUSTEREDFBILLNO
IDX_QM_RETURNMTRAPP_DATENONCLUSTEREDFDATE
主外键
名称类型字段
PK_QM_RETURNMTRAPPQCPKFID
触发器
约束
名称类型字段描述
PK_QM_RETURNMTRAPPQC主键约束FID

生产退料请检单-单据头_L

概述
表名称实体名称ORM实体名
T_QM_RETURNMTRAPPQC_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_RETURNMTRAPPQC_LCLUSTEREDFPKID
IDX_QM_RETURNMTRAPP_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_RETURNMTRAPPQC_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_RETURNMTRAPPQC_L主键约束FPKID
DF__T_QM_RETU__FPKID__26F34CB6默认值约束FPKID((0))

生产退料请检单-明细

概述
表名称实体名称ORM实体名
T_QM_REMTRAPPQCENTRY明细Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
物料编码FMaterialIdMaterialIdFMATERIALIDint4100
辅助属性FAuxPropIdAuxPropIdFAUXPROPIDint4100
BOM版本FBomIdBomIdFBOMIDint4100
计划跟踪号FMtoNoMtoNoFMTONOnvarchar5102550
仓库FStockIdStockIdFSTOCKIDint4100
仓位FStockLocIdStockLocIdFSTOCKLOCIDint4100
批号FLotFLotFLOTint4100
库存状态FStockStatusIdStockStatusIdFSTOCKSTATUSIDint4100
工序号FOperIdOperIdFOPERIDint4100
作业FProcessIdProcessIdFPROCESSIDint4100
生产日期FProduceDateProduceDateFPRODUCEDATEdatetime8233
有效期至FExpiryDateExpiryDateFEXPIRYDATEdatetime8233
单位FUnitIDUnitIDFUNITIDint4100
基本单位FBaseUnitIdBaseUnitIdFBASEUNITIDint4100((0))
序列号单位FSNUnitIDSNUnitIDFSNUNITIDint4100((0))
数量FQtyQtyFQTYdecimal132310((0))
基本单位数量FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
序列号单位数量FSNQtySNQtyFSNQTYint4100((0))
货主类型FOwnerTypeIdOwnerTypeIdFOWNERTYPEIDvarchar36360
货主FOwnerIdOwnerIdFOWNERIDint4100
基本单位检验选单数量FBaseSelInspectQtyBaseSelInspectQtyFBASESELINSPECTQTYdecimal132310((0))
基本单位检验数量FBaseInspectQtyBaseInspectQtyFBASEINSPECTQTYdecimal132310((0))
基本单位良品数量FBaseGoodQtyBaseGoodQtyFBASEGOODQTYdecimal132310((0))
基本单位来料不良数量FBaseIncDefectQtyBaseIncDefectQtyFBASEINCDEFECTQTYdecimal132310((0))
基本单位作业不良数量FBasePrcDefectQtyBasePrcDefectQtyFBASEPRCDEFECTQTYdecimal132310((0))
检验选单数量FSelInspectQtySelInspectQtyFSELINSPECTQTYdecimal132310((0))
检验数量FInspectQtyInspectQtyFINSPECTQTYdecimal132310((0))
良品数量FGoodQtyGoodQtyFGOODQTYdecimal132310((0))
作业不良数量FProcessDefectQtyProcessDefectQtyFPRCDEFECTQTYdecimal132310((0))
来料不良数量FIncDefectQtyIncDefectQtyFINCDEFECTQTYdecimal132310((0))
源单类型FSrcBillTypeSrcBillTypeFSRCBILLTYPEvarchar36360(' ')
源单编号FSrcBillNoSrcBillNoFSRCBILLNOnvarchar160800(' ')
源单内码FSrcInterIdSrcInterIdFSRCINTERIDint4100((0))
源单分录内码FSrcEntryIdSrcEntryIdFSRCENTRYIDint4100((0))
源单行号FSrcEntrySeqSrcEntrySeqFSRCENTRYSEQint4100((0))
订单类型FOrderTypeOrderTypeFORDERTYPEvarchar36360(' ')
订单编号FOrderBillNoOrderBillNoFORDERBILLNOnvarchar160800(' ')
订单内码FOrderIdOrderIdFORDERIDint4100((0))
订单分录内码FOrderEntryIdOrderEntryIdFORDERENTRYIDint4100((0))
订单行号FOrderEntrySeqOrderEntrySeqFORDERENTRYSEQint4100((0))
产品编码FParentMaterialIdParentMaterialIdFPARENTMATERIALIDint4100
生产车间FEWorkShopIdEWorkShopIdFWORKSHOPIDint4100
产品货主类型FParentOwnerTypeIdParentOwnerTypeIdFPARENTOWNERTYPEIDvarchar36360
产品货主FParentOwnerIdParentOwnerIdFPARENTOWNERIDint4100((0))
索引
名称类型字段
PK_QM_REMTRAPPQCENTRYCLUSTEREDFENTRYID
IDX_QM_REMTRAPPE_IDNONCLUSTEREDFID
IDX_QM_REMTRAPPE_MTRLIDNONCLUSTEREDFMATERIALID
主外键
名称类型字段
PK_QM_REMTRAPPQCENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_REMTRAPPQCENTRY主键约束FENTRYID
DF__T_QM_REMT__FSRCE__00CDA3CE默认值约束FSRCENTRYSEQ((0))
DF__T_QM_REMT__FORDE__01C1C807默认值约束FORDERTYPE(' ')
DF__T_QM_REMT__FORDE__02B5EC40默认值约束FORDERBILLNO(' ')
DF__T_QM_REMT__FORDE__03AA1079默认值约束FORDERID((0))
DF__T_QM_REMT__FORDE__049E34B2默认值约束FORDERENTRYID((0))
DF__T_QM_REMT__FORDE__059258EB默认值约束FORDERENTRYSEQ((0))
DF__T_QM_REMT__FSELI__06867D24默认值约束FSELINSPECTQTY((0))
DF__T_QM_REMT__FBASE__077AA15D默认值约束FBASESELINSPECTQTY((0))
DF__T_QM_REMT__FINSP__086EC596默认值约束FINSPECTQTY((0))
DF__T_QM_REMT__FBASE__0962E9CF默认值约束FBASEINSPECTQTY((0))
DF__T_QM_REMT__FGOOD__0A570E08默认值约束FGOODQTY((0))
DF__T_QM_REMT__FBASE__0B4B3241默认值约束FBASEGOODQTY((0))
DF__T_QM_REMT__FINCD__0C3F567A默认值约束FINCDEFECTQTY((0))
DF__T_QM_REMT__FBASE__0D337AB3默认值约束FBASEINCDEFECTQTY((0))
DF__T_QM_REMT__FPRCD__0E279EEC默认值约束FPRCDEFECTQTY((0))
DF__T_QM_REMT__FBASE__0F1BC325默认值约束FBASEPRCDEFECTQTY((0))
DF__T_QM_REMT__FPARE__100FE75E默认值约束FPARENTOWNERID((0))
DF__T_QM_REMT__FENTR__77443994默认值约束FENTRYID((0))
DF__T_QM_REMTR__FQTY__78385DCD默认值约束FQTY((0))
DF__T_QM_REMT__FBASE__792C8206默认值约束FBASEUNITID((0))
DF__T_QM_REMT__FBASE__7A20A63F默认值约束FBASEQTY((0))
DF__T_QM_REMT__FSNUN__7B14CA78默认值约束FSNUNITID((0))
DF__T_QM_REMT__FSNQT__7C08EEB1默认值约束FSNQTY((0))
DF__T_QM_REMT__FSRCB__7CFD12EA默认值约束FSRCBILLTYPE(' ')
DF__T_QM_REMT__FSRCB__7DF13723默认值约束FSRCBILLNO(' ')
DF__T_QM_REMT__FSRCI__7EE55B5C默认值约束FSRCINTERID((0))
DF__T_QM_REMT__FSRCE__7FD97F95默认值约束FSRCENTRYID((0))

生产退料请检单-明细_A

概述
表名称实体名称ORM实体名
T_QM_REMTRAPPQCENTRY_A明细Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
基本单位良品退料选单数量FBaseSelGoodReturnQtyBaseSelGoodReturnQtyFBASESELGOODRETURNQTYdecimal132310((0))
基本单位来料不良退料选单数量FBaseSelIncDefectReturnQtyBaseSelIncDefectReturnQtyFBASESELINCDEFECTRETURNQTYdecimal132310((0))
基本单位作业不良退料选单数量FBaseSelPrcDefectReturnQtyBaseSelPrcDefectReturnQtyFBASESELPRCDEFECTRETURNQTYdecimal132310((0))
基本单位良品退料数量FBaseGoodReturnQtyBaseGoodReturnQtyFBASEGOODRETURNQTYdecimal132310((0))
基本单位来料不良退料数量FBaseIncDefectReturnQtyBaseIncDefectReturnQtyFBASEINCDEFECTRETURNQTYdecimal132310((0))
基本单位作业不良退料数量FBasePrcDefectReturnQtyBasePrcDefectReturnQtyFBASEPRCDEFECTRETURNQTYdecimal132310((0))
良品退料选单数量FSelGoodReturnQtySelGoodReturnQtyFSELGOODRETURNQTYdecimal132310((0))
来料不良退料选单数量FSelIncDefectReturnQtySelIncDefectReturnQtyFSELINCDEFECTRETURNQTYdecimal132310((0))
作业不良退料选单数量FSelPrcDefectReturnQtySelPrcDefectReturnQtyFSELPRCDEFECTRETURNQTYdecimal132310((0))
良品退料数量FGoodReturnQtyGoodReturnQtyFGOODRETURNQTYdecimal132310((0))
作业不良退料数量FProcessDefectReturnQtyProcessDefectReturnQtyFPRCDEFECTRETURNQTYdecimal132310((0))
来料不良退料数量FIncDefectReturnQtyIncDefectReturnQtyFINCDEFECTRETURNQTYdecimal132310((0))
退料类型-供下推生产退料单使用FReturnTypeReturnTypeFRETURNTYPEchar110('1')
用料清单分录内码FPPBomEntryIdPPBomEntryIdFPPBOMENTRYIDint4100((0))
用料清单编号FPPBomBillNoPPBomBillNoFPPBOMBILLNOnvarchar160800
索引
名称类型字段
PK_QM_REMTRAPPQCENTRY_ACLUSTEREDFENTRYID
IDX_QM_REMTRAPPE_A_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_REMTRAPPQCENTRY_APKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_REMTRAPPQCENTRY_A主键约束FENTRYID
DF__T_QM_REMT__FENTR__11F82FD0默认值约束FENTRYID((0))
DF__T_QM_REMT__FBASE__12EC5409默认值约束FBASESELGOODRETURNQTY((0))
DF__T_QM_REMT__FBASE__13E07842默认值约束FBASESELINCDEFECTRETURNQTY((0))
DF__T_QM_REMT__FBASE__14D49C7B默认值约束FBASESELPRCDEFECTRETURNQTY((0))
DF__T_QM_REMT__FBASE__15C8C0B4默认值约束FBASEGOODRETURNQTY((0))
DF__T_QM_REMT__FBASE__16BCE4ED默认值约束FBASEINCDEFECTRETURNQTY((0))
DF__T_QM_REMT__FBASE__17B10926默认值约束FBASEPRCDEFECTRETURNQTY((0))
DF__T_QM_REMT__FSELG__18A52D5F默认值约束FSELGOODRETURNQTY((0))
DF__T_QM_REMT__FSELI__19995198默认值约束FSELINCDEFECTRETURNQTY((0))
DF__T_QM_REMT__FSELP__1A8D75D1默认值约束FSELPRCDEFECTRETURNQTY((0))
DF__T_QM_REMT__FGOOD__1B819A0A默认值约束FGOODRETURNQTY((0))
DF__T_QM_REMT__FPRCD__1C75BE43默认值约束FPRCDEFECTRETURNQTY((0))
DF__T_QM_REMT__FINCD__1D69E27C默认值约束FINCDEFECTRETURNQTY((0))
DF__T_QM_REMT__FRETU__1E5E06B5默认值约束FRETURNTYPE('1')
DF__T_QM_REMT__FPPBO__3CD177EF默认值约束FPPBOMENTRYID((0))

生产退料请检单-序列号子单据体

概述
表名称实体名称ORM实体名
T_QM_REMTRAPPQCSERIAL序列号子单据体QM_ReturnMtrlAppSerial
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
序列号FSerialNoSerialNoFSERIALNOnvarchar160800(' ')
序列号FSerialIdSerialIdFSERIALIDint4100((0))
备注FSerialNoteSerialNoteFSERIALNOTEnvarchar5102550
检验结果FInspectResultInspectResultFINSPECTRESULTchar110
退料关联标志FResStkFlagResStkFlagFRESSTKFLAGchar110('0')
索引
名称类型字段
PK_QM_REMTRAPPQCSERIALCLUSTEREDFDETAILID
IDX_QM_REMTRAPPSN_EIDNONCLUSTEREDFENTRYID
IDX_QM_REMTRAPPSN_SNNONCLUSTEREDFSERIALNO
主外键
名称类型字段
PK_QM_REMTRAPPQCSERIALPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_REMTRAPPQCSERIAL主键约束FDETAILID
DF__T_QM_REMT__FDETA__20464F27默认值约束FDETAILID((0))
DF__T_QM_REMT__FENTR__213A7360默认值约束FENTRYID((0))
DF__T_QM_REMTR__FSEQ__222E9799默认值约束FSEQ((0))
DF__T_QM_REMT__FSERI__2322BBD2默认值约束FSERIALNO(' ')
DF__T_QM_REMT__FSERI__2416E00B默认值约束FSERIALID((0))
DF__T_QM_REMT__FRESS__250B0444默认值约束FRESSTKFLAG('0')

生产退料请检单-关联关系表

概述
表名称实体名称ORM实体名
T_QM_REMTRAPPQCENTRY_LK关联关系表FEntity_Link
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值
业务流程图FEntity_Link_FFlowIdFlowIdFFLOWIDvarchar36360
推进路线FEntity_Link_FFlowLineIdFlowLineIdFFLOWLINEIDint4100((0))
转换规则FEntity_Link_FRuleIdRuleIdFRULEIDvarchar36360
源单表内码FEntity_Link_FSTableIdSTableIdFSTABLEIDint4100
源单表FEntity_Link_FSTableNameSTableNameFSTABLENAMEvarchar30300
源单内码FEntity_Link_FSBillIdSBillIdFSBILLIDvarchar36360
源单分录内码FEntity_Link_FSIdSIdFSIDvarchar36360
原始携带量FEntity_Link_FBaseQtyOldBaseQtyOldFBASEQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
索引
名称类型字段
PK_QM_REMTRAPPQCENTRY_LKCLUSTEREDFLINKID
IDX_QM_REME_LK_SIDNONCLUSTEREDFSID
IDX_QM_REME_LK_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_REMTRAPPQCENTRY_LKPKFLINKID
触发器
约束
名称类型字段描述
PK_QM_REMTRAPPQCENTRY_LK主键约束FLINKID
DF__T_QM_REMT__FFLOW__29CFB961默认值约束FFLOWLINEID((0))
DF__T_QM_REMT__FBASE__2AC3DD9A默认值约束FBASEQTYOLD((0))
DF__T_QM_REMT__FBASE__2BB801D3默认值约束FBASEQTY((0))

1.1.22 样本字码表

样本字码表-单据头

概述
表名称实体名称ORM实体名
T_QM_SAMPLECODE单据头SampleCodeView
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateFModifyDateFMODIFYDATEdatetime8233
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
索引
名称类型字段
PK_QM_SAMPLECODECLUSTEREDFID
IDX_QM_SAMPLECODE_NUMNONCLUSTEREDFNUMBER
主外键
名称类型字段
PK_QM_SAMPLECODEPKFID
触发器
约束
名称类型字段描述
PK_QM_SAMPLECODE主键约束FID
DF__T_QM_SAMPLE__FID__42223B62默认值约束FID((0))

样本字码表-单据头_L

概述
表名称实体名称ORM实体名
T_QM_SAMPLECODE_L单据头SampleCodeView
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
索引
名称类型字段
PK_QM_SAMPLECODE_LCLUSTEREDFPKID
IDX_QM_SAMPLECODE_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_SAMPLECODE_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_SAMPLECODE_L主键约束FPKID
DF__T_QM_SAMP__FPKID__60A6C282默认值约束FPKID((0))

样本字码表-单据体

概述
表名称实体名称ORM实体名
T_QM_SAMPLECODEENTRY单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
样本下限FSampleLowSampleLowFSAMPLELOWint4100
样本上限FSampleUpSampleUpFSAMPLEUPint4100
一般检验水平&ⅠFC1C1FC1char110
一般检验水平&ⅡFC2C2FC2char110
一般检验水平&ⅢFC3C3FC3char110
特殊检验水平&S-1FS1S1FS1char110
特殊检验水平&S-2FS2S2FS2char110
特殊检验水平&S-3FS3S3FS3char110
特殊检验水平&S-4FS4S4FS4char110
索引
名称类型字段
PK_QM_SAMPLECODEENTRYCLUSTEREDFENTRYID
IDX_QM_SAMPLECODEE_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_SAMPLECODEENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_SAMPLECODEENTRY主键约束FENTRYID
DF__T_QM_SAMP__FENTR__44FEA80D默认值约束FENTRYID((0))

1.1.23 抽样方案

抽样方案-单据头

概述
表名称实体名称ORM实体名
T_QM_SAMPLESCHEME单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
抽样次数FSampleTimesSampleTimesFSAMPLETIMESint4100
检验水平FInspectLevelInspectLevelFINSPECTLEVELchar110('0')
严格度FStrictLevelStrictLevelFSTRICTLEVELchar110('0')
失效日期FExpireDateFExpireDateFEXPIREDATEdatetime8233
生效日期FEffectDateFEffectDateFEFFECTDATEdatetime8233
抽样类型FSampleTypeSampleTypeFSAMPLETYPEchar110('0')
AQLFAQLAQLFAQLchar110('0')
系统预设FIsSystemSetIsSystemSetFISSYSTEMSETchar110('0')
允收数和拒收数按公式计算FIsEnableExpressionIsEnableExpressionFISENABLEEXPRESSIONchar110('0')
索引
名称类型字段
PK_QM_SAMPLESCHEMECLUSTEREDFID
IDX_QM_SAMPLESCHEME_NUMNONCLUSTEREDFNUMBER
IDX_QM_SAMPLESCHEME_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_SAMPLESCHEMEPKFID
触发器
约束
名称类型字段描述
PK_QM_SAMPLESCHEME主键约束FID
DF__T_QM_SAMP__FISEN__2CF01DD5默认值约束FISENABLEEXPRESSION('0')
DF__T_QM_SAMPLE__FID__628F0AF4默认值约束FID((0))
DF__T_QM_SAMP__FMAST__63832F2D默认值约束FMASTERID((0))
DF__T_QM_SAMP__FISSY__64775366默认值约束FISSYSTEMSET('0')
DF_T_QM_SAMPLESCHEME_FSAMPLETYPE默认值约束FSAMPLETYPE('0')
DF_T_QM_SAMPLESCHEME_FINSPECTLEVEL默认值约束FINSPECTLEVEL('0')
DF_T_QM_SAMPLESCHEME_FSTRICTLEVEL默认值约束FSTRICTLEVEL('0')
DF_T_QM_SAMPLESCHEME_FAQL默认值约束FAQL('0')

抽样方案-单据头_L

概述
表名称实体名称ORM实体名
T_QM_SAMPLESCHEME_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_SAMPLESCHEME_LCLUSTEREDFPKID
IDX_QM_SAMPLESCHEME_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_SAMPLESCHEME_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_SAMPLESCHEME_L主键约束FPKID
DF__T_QM_SAMP__FPKID__46E6F07F默认值约束FPKID((0))

抽样方案-单据体

概述
表名称实体名称ORM实体名
T_QM_SAMPLESCHEMEENTRY单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
批量FBatchBatchFBATCHint4100
样本量FSampleQtySampleQtyFSAMPLEQTYint4100
允收数FAcceptQtyAcceptQtyFACCEPTQTYint4100
拒收数FRejectQtyRejectQtyFREJECTQTYint4100
样本量字码FSampleCodeSampleCodeFSAMPLECODEchar110
样本量比率(%)FSampleRateSampleRateFSAMPLERATEdecimal9196
样本下限FSampleLowSampleLowFSAMPLELOWint4100
样本上限FSampleUpSampleUpFSAMPLEUPint4100
样本量公式FExpressionExpressionFEXPRESSIONnvarchar2001000(' ')
允收数公式FAcceptExpressionAcceptExpressionFACCEPTEXPRESSIONnvarchar2001000(' ')
拒收数公式FRejectExpressionRejectExpressionFREJECTEXPRESSIONnvarchar2001000(' ')
索引
名称类型字段
PK_QM_SAMPLESCHEMEENTRYCLUSTEREDFENTRYID
IDX_QM_SAMPLESCHEMEE_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_SAMPLESCHEMEENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_SAMPLESCHEMEENTRY主键约束FENTRYID
DF__T_QM_SAMP__FACCE__2DE4420E默认值约束FACCEPTEXPRESSION(' ')
DF__T_QM_SAMP__FREJE__2ED86647默认值约束FREJECTEXPRESSION(' ')
DF__T_QM_SAMP__FEXPR__462A3875默认值约束FEXPRESSION(' ')
DF__T_QM_SAMP__FENTR__665F9BD8默认值约束FENTRYID((0))

1.1.24 抽样方案检索表模型

抽样方案检索表模型-单据头

概述
表名称实体名称ORM实体名
T_QM_SSRETRIEVAL单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateFModifyDateFMODIFYDATEdatetime8233
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
唯一码FCodeCodeFCODEchar110
索引
名称类型字段
PK_QM_SSRETRIEVALCLUSTEREDFID
IDX_QM_SSRETRIEVAL_NUMNONCLUSTEREDFNUMBER
主外键
名称类型字段
PK_QM_SSRETRIEVALPKFID
触发器
约束
名称类型字段描述
PK_QM_SSRETRIEVAL主键约束FID
DF__T_QM_SSRETR__FID__6847E44A默认值约束FID((0))

抽样方案检索表模型-单据头_L

概述
表名称实体名称ORM实体名
T_QM_SSRETRIEVAL_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
备注FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_SSRETRIEVAL_LCLUSTEREDFPKID
IDX_QM_SSRETRIEVAL_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_SSRETRIEVAL_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_SSRETRIEVAL_L主键约束FPKID
DF__T_QM_SSRE__FPKID__6B2450F5默认值约束FPKID((0))

抽样方案检索表模型-单据体

概述
表名称实体名称ORM实体名
T_QM_SSRETRIEVALENTRY单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
样本字码FSampleCodeSampleCodeFSAMPLECODEchar110
样本量FSampleQtySampleQtyFSAMPLEQTYint4100
F0_010_ACF0_010_ACF0_010_ACF0_010_ACint4100
F0_015_ACF0_015_ACF0_015_ACF0_015_ACint4100
F0_025_ACF0_025_ACF0_025_ACF0_025_ACint4100
F0_040_ACF0_040_ACF0_040_ACF0_040_ACint4100
F0_065_ACF0_065_ACF0_065_ACF0_065_ACint4100
F0_10_ACF0_10_ACF0_10_ACF0_10_ACint4100
F0_15_ACF0_15_ACF0_15_ACF0_15_ACint4100
F0_25_ACF0_25_ACF0_25_ACF0_25_ACint4100
F0_40_ACF0_40_ACF0_40_ACF0_40_ACint4100
F0_65_ACF0_65_ACF0_65_ACF0_65_ACint4100
F1_0_ACF1_0_ACF1_0_ACF1_0_ACint4100
F1_5_ACF1_5_ACF1_5_ACF1_5_ACint4100
F2_5_ACF2_5_ACF2_5_ACF2_5_ACint4100
F4_0_ACF4_0_ACF4_0_ACF4_0_ACint4100
F6_5_ACF6_5_ACF6_5_ACF6_5_ACint4100
F10_ACF10_ACF10_ACF10_ACint4100
F15_ACF15_ACF15_ACF15_ACint4100
F25_ACF25_ACF25_ACF25_ACint4100
F40_ACF40_ACF40_ACF40_ACint4100
F65_ACF65_ACF65_ACF65_ACint4100
F100_ACF100_ACF100_ACF100_ACint4100
F150_ACF150_ACF150_ACF150_ACint4100
F250_ACF250_ACF250_ACF250_ACint4100
F400_ACF400_ACF400_ACF400_ACint4100
F650_ACF650_ACF650_ACF650_ACint4100
F1000_ACF1000_ACF1000_ACF1000_ACint4100
索引
名称类型字段
PK_QM_SSRETRIEVALENTRYCLUSTEREDFENTRYID
IDX_QM_SSRE_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_SSRETRIEVALENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_SSRETRIEVALENTRY主键约束FENTRYID
DF__T_QM_SSRE__FENTR__48CF38F1默认值约束FENTRYID((0))

抽样方案检索表模型-单据体_R

概述
表名称实体名称ORM实体名
T_QM_SSRETRIEVALENTRY_R单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
F0_010_REF0_010_REF0_010_REF0_010_REint4100
F0_015_REF0_015_REF0_015_REF0_015_REint4100
F0_025_REF0_025_REF0_025_REF0_025_REint4100
F0_040_REF0_040_REF0_040_REF0_040_REint4100
F0_065_REF0_065_REF0_065_REF0_065_REint4100
F0_10_REF0_10_REF0_10_REF0_10_REint4100
F0_15_REF0_15_REF0_15_REF0_15_REint4100
F0_25_REF0_25_REF0_25_REF0_25_REint4100
F0_40_REF0_40_REF0_40_REF0_40_REint4100
F0_65_REF0_65_REF0_65_REF0_65_REint4100
F1_0_REF1_0_REF1_0_REF1_0_REint4100
F1_5_REF1_5_REF1_5_REF1_5_REint4100
F2_5_REF2_5_REF2_5_REF2_5_REint4100
F4_0_REF4_0_REF4_0_REF4_0_REint4100
F6_5_REF6_5_REF6_5_REF6_5_REint4100
F10_REF10_REF10_REF10_REint4100
F15_REF15_REF15_REF15_REint4100
F25_REF25_REF25_REF25_REint4100
F40_REF40_REF40_REF40_REint4100
F65_REF65_REF65_REF65_REint4100
F100_REF100_REF100_REF100_REint4100
F150_REF150_REF150_REF150_REint4100
F250_REF250_REF250_REF250_REint4100
F400_REF400_REF400_REF400_REint4100
F650_REF650_REF650_REF650_REint4100
F1000_REF1000_REF1000_REF1000_REint4100
索引
名称类型字段
PK_QM_SSRETRIEVALENTRY_RCLUSTEREDFENTRYID
IDX_QM_SSRE_R_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_SSRETRIEVALENTRY_RPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_SSRETRIEVALENTRY_R主键约束FENTRYID
DF__T_QM_SSRE__FENTR__4AB78163默认值约束FENTRYID((0))

1.1.25 抽样方案检索表

抽样方案检索表-单据头

概述
表名称实体名称ORM实体名
T_QM_SSRETRIEVAL单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateFModifyDateFMODIFYDATEdatetime8233
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
索引
名称类型字段
PK_QM_SSRETRIEVALCLUSTEREDFID
IDX_QM_SSRETRIEVAL_NUMNONCLUSTEREDFNUMBER
主外键
名称类型字段
PK_QM_SSRETRIEVALPKFID
触发器
约束
名称类型字段描述
PK_QM_SSRETRIEVAL主键约束FID
DF__T_QM_SSRETR__FID__6847E44A默认值约束FID((0))

抽样方案检索表-单据头_L

概述
表名称实体名称ORM实体名
T_QM_SSRETRIEVAL_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
备注FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_SSRETRIEVAL_LCLUSTEREDFPKID
IDX_QM_SSRETRIEVAL_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_SSRETRIEVAL_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_SSRETRIEVAL_L主键约束FPKID
DF__T_QM_SSRE__FPKID__6B2450F5默认值约束FPKID((0))

抽样方案检索表-单据体

概述
表名称实体名称ORM实体名
V_QM_SSRETRIEVALENTRY单据体Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
样本量字码FSampleCodeSampleCodefsamplecodechar110
样本量FSampleQtySampleQtyfsampleqtyint4100
接收质量限(AQL)&0.010&Ac ReF0_010_AC_REF0_010_AC_REf0_010_ac_renvarchar1050
接收质量限(AQL)&0.015&Ac ReF0_015_AC_REF0_015_AC_REf0_015_ac_renvarchar1050
接收质量限(AQL)&0.025&Ac ReF0_025_AC_REF0_025_AC_REf0_025_ac_renvarchar1050
接收质量限(AQL)&0.040&Ac ReF0_040_AC_REF0_040_AC_REf0_040_ac_renvarchar1050
接收质量限(AQL)&0.065&Ac ReF0_065_AC_REF0_065_AC_REf0_065_ac_renvarchar1050
接收质量限(AQL)&0.10&Ac ReF0_10_AC_REF0_10_AC_REf0_10_ac_renvarchar1050
接收质量限(AQL)&0.15&Ac ReF0_15_AC_REF0_15_AC_REf0_15_ac_renvarchar1050
接收质量限(AQL)&0.25&Ac ReF0_25_AC_REF0_25_AC_REf0_25_ac_renvarchar1050
接收质量限(AQL)&0.40&Ac ReF0_40_AC_REF0_40_AC_REf0_40_ac_renvarchar1050
接收质量限(AQL)&0.65&Ac ReF0_65_AC_REF0_65_AC_REf0_65_ac_renvarchar1050
接收质量限(AQL)&1.0&Ac ReF1_0_AC_REF1_0_AC_REf1_0_ac_renvarchar1050
接收质量限(AQL)&1.5&Ac ReF1_5_AC_REF1_5_AC_REf1_5_ac_renvarchar1050
接收质量限(AQL)&2.5&Ac ReF2_5_AC_REF2_5_AC_REf2_5_ac_renvarchar1050
接收质量限(AQL)&4.0&Ac ReF4_0_AC_REF4_0_AC_REf4_0_ac_renvarchar1050
接收质量限(AQL)&6.5&Ac ReF6_5_AC_REF6_5_AC_REf6_5_ac_renvarchar1050
接收质量限(AQL)&10&Ac ReF10_AC_REF10_AC_REf10_ac_renvarchar1050
接收质量限(AQL)&15&Ac ReF15_AC_REF15_AC_REf15_ac_renvarchar1050
接收质量限(AQL)&25&Ac ReF25_AC_REF25_AC_REf25_ac_renvarchar1050
接收质量限(AQL)&40&Ac ReF40_AC_REF40_AC_REf40_ac_renvarchar1050
接收质量限(AQL)&65&Ac ReF65_AC_REF65_AC_REf65_ac_renvarchar1050
接收质量限(AQL)&100&Ac ReF100_AC_REF100_AC_REf100_ac_renvarchar1050
接收质量限(AQL)&150&Ac ReF150_AC_REF150_AC_REf150_ac_renvarchar1050
接收质量限(AQL)&250&Ac ReF250_AC_REF250_AC_REf250_ac_renvarchar1050
接收质量限(AQL)&400&Ac ReF400_AC_REF400_AC_REf400_ac_renvarchar1050
接收质量限(AQL)&650&Ac ReF650_AC_REF650_AC_REf650_ac_renvarchar1050
接收质量限(AQL)&1000&Ac ReF1000_AC_REF1000_AC_REf1000_ac_renvarchar1050
索引
名称类型字段
主外键
名称类型字段
触发器
名称

1.1.26 库存请检单

库存请检单-单据头

概述
表名称实体名称ORM实体名
T_QM_STKAPPINSPECT单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
单据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
审核人FApproverIdApproverIdFAPPROVERIDint4100
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
作废日期FCancelDateCancelDateFCANCELDATEdatetime8233
作废人FCancelerCANCELERFCANCELERint4100
作废状态FCancelStatusCancelStatusFCANCELSTATUSchar110
单据日期FDateDateFDATEdatetime8233
库存组织FStockOrgIdStockOrgIdFSTOCKORGIDint4100
单据类型FBillTypeIdBillTypeIdFBILLTYPEIDvarchar36360
货主类型FOwnerTypeId0OwnerTypeIdFOWNERTYPEIDvarchar36360(' ')
货主FOwnerId0OwnerIdFOWNERIDint4100((0))
仓管员FStockerIdStockerIdFSTOCKERIDint4100
业务类型FBusinessTypeFBusinessTypeFBUSINESSTYPEchar110('0')
库存组FStockerGroupIdStockerGroupIdFSTOCKERGROUPIDint4100
部门FStockDeptIdStockDeptIdFSTOCKDEPTIDint4100
索引
名称类型字段
PK_QM_STKAPPINSPECTCLUSTEREDFID
IDX_QM_STKAPPINSPECT_NONONCLUSTEREDFBILLNO
IDX_QM_STKAPPINSPECT_DATENONCLUSTEREDFDATE
主外键
名称类型字段
PK_QM_STKAPPINSPECTPKFID
触发器
约束
名称类型字段描述
PK_QM_STKAPPINSPECT主键约束FID
DF__T_QM_STKAPP__FID__09556908默认值约束FID((0))
DF__T_QM_STKA__FBUSI__0A498D41默认值约束FBUSINESSTYPE('0')
DF__T_QM_STKA__FOWNE__0B3DB17A默认值约束FOWNERTYPEID(' ')
DF__T_QM_STKA__FOWNE__0C31D5B3默认值约束FOWNERID((0))

库存请检单-单据头_L

概述
表名称实体名称ORM实体名
T_QM_STKAPPINSPECT_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
备注FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_STKAPPINSPECT_LCLUSTEREDFPKID
IDX_QM_STKAPPINSPECT_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_STKAPPINSPECT_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_STKAPPINSPECT_L主键约束FPKID
DF__T_QM_STKA__FPKID__501CEBAC默认值约束FPKID((0))

库存请检单-明细

概述
表名称实体名称ORM实体名
T_QM_STKAPPINSPECTENTRY明细Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
物料编码FMaterialIdMaterialIdFMATERIALIDint4100
BOM版本FBomIdBomIdFBOMIDint4100
仓库FStockIdStockIdFSTOCKIDint4100
仓位FStockLocIdStockLocIdFSTOCKLOCIDint4100
库存状态FStockStatusIdStockStatusIdFSTOCKSTATUSIDint4100
生产日期FProduceDateProduceDateFPRODUCEDATEdatetime8233
计划跟踪号FMtoNoMTONOFMTONOnvarchar5102550
货主类型FOwnerTypeIdOwnerTypeIdFOWNERTYPEIDvarchar36360
主库存单位数量FStockQtyStockQtyFSTOCKQTYdecimal132310((0))
辅库存单位数量FSecQtySecQtyFSECQTYdecimal132310((0))
数量FQtyQtyFQTYdecimal132310((0))
基本单位数量FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
单位FUnitIDUnitIdFUNITIDint4100
基本单位FBaseUnitIdBaseUnitIdFBASEUNITIDint4100((0))
主库存单位FStockUnitIdStockUnitIdFSTOCKUNITIDint4100
辅库存单位FSecUnitIdSecUnitIdFSECUNITIDint4100
辅助属性FAuxPropIdAuxPropIdFAUXPROPIDint4100
保管者类型FKeeperTypeIdKeeperTypeIdFKEEPERTYPEIDvarchar36360
保管者FKeeperIdKeeperIdFKEEPERIDint4100
货主FOwnerIdOwnerIdFOWNERIDint4100
有效期至FExpiryDateExpiryDateFEXPIRYDATEdatetime8233
批号FLotLotFLOTint4100
业务流程FBFLowIdBFLowIdFBFLOWIDvarchar36360(' ')
序列号单位FSNUnitIDSNUnitIDFSNUNITIDint4100((0))
序列号单位数量FSNQtySNQtyFSNQTYint4100((0))
库存状态转换类型FStockConvertTypeStockConvertTypeFSTOCKCONVERTTYPEchar110('1')
客户FCustomerIdCustomerIdFCUSTOMERIDint4100((0))
源单类型FSrcBillTypeSrcBillTypeFSRCBILLTYPEvarchar36360(' ')
源单编号FSrcBillNoSrcBillNoFSRCBILLNOnvarchar100500(' ')
源单内码FSrcInterIdSrcInterIdFSRCINTERIDint4100((0))
源单分录内码FSrcEntryIdSrcEntryIdFSRCENTRYIDint4100((0))
源单行号FSrcEntrySeqSrcEntrySeqFSRCENTRYSEQint4100((0))
订单类型FOrderTypeOrderTypeFORDERTYPEvarchar36360(' ')
订单编号FOrderBillNoOrderBillNoFORDERBILLNOnvarchar100500(' ')
订单内码FOrderIdOrderIdFORDERIDint4100((0))
订单分录内码FOrderEntryIdOrderEntryIdFORDERENTRYIDint4100((0))
订单行号FOrderEntrySeqOrderEntrySeqFORDERENTRYSEQint4100((0))
质检冻结状态FStkFreezeStatusStkFreezeStatusFSTKFREEZESTATUSint4100
源请检数量FSRCAppQtySRCAppQtyFSRCAPPQTYdecimal132310((0))
基本单位源请检数量FBaseSRCAppQtyBaseSRCAppQtyFBASESRCAPPQTYdecimal132310((0))
检验结果F_RZYI_ComboF_RZYI_ComboF_RZYI_COMBOvarchar20200('')
索引
名称类型字段
PK_QM_STKAPPINSPECTENTRYCLUSTEREDFENTRYID
IDX_QM_STKAPPIE_IDNONCLUSTEREDFID
IDX_QM_STKAPPIE_MTRLIDNONCLUSTEREDFMATERIALID
主外键
名称类型字段
PK_QM_STKAPPINSPECTENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_STKAPPINSPECTENTRY主键约束FENTRYID
DF__T_QM_STKA__FBASE__00C02307默认值约束FBASEQTY((0))
DF__T_QM_STKA__FSTOC__01B44740默认值约束FSTOCKQTY((0))
DF__T_QM_STKA__FSECQ__02A86B79默认值约束FSECQTY((0))
DF__T_QM_STKA__FSNUN__039C8FB2默认值约束FSNUNITID((0))
DF__T_QM_STKA__FSNQT__0490B3EB默认值约束FSNQTY((0))
DF__T_QM_STKA__FSRCA__47AD309D默认值约束FSRCAPPQTY((0))
DF__T_QM_STKA__FBASE__48A154D6默认值约束FBASESRCAPPQTY((0))
DF__T_QM_STKA__FCUST__540683DC默认值约束FCUSTOMERID((0))
DF__T_QM_STKA__FSRCB__54FAA815默认值约束FSRCBILLTYPE(' ')
DF__T_QM_STKA__FSRCB__55EECC4E默认值约束FSRCBILLNO(' ')
DF__T_QM_STKA__FSRCI__56E2F087默认值约束FSRCINTERID((0))
DF__T_QM_STKA__FSRCE__57D714C0默认值约束FSRCENTRYID((0))
DF__T_QM_STKA__FSRCE__58CB38F9默认值约束FSRCENTRYSEQ((0))
DF__T_QM_STKA__FORDE__59BF5D32默认值约束FORDERTYPE(' ')
DF__T_QM_STKA__FORDE__5AB3816B默认值约束FORDERBILLNO(' ')
DF__T_QM_STKA__FORDE__5BA7A5A4默认值约束FORDERID((0))
DF__T_QM_STKA__FORDE__5C9BC9DD默认值约束FORDERENTRYID((0))
DF__T_QM_STKA__FORDE__5D8FEE16默认值约束FORDERENTRYSEQ((0))
DF__T_QM_STKA__F_RZY__6EB7B050默认值约束F_RZYI_COMBO('')
DF__T_QM_STKA__FENTR__7B0749B1默认值约束FENTRYID((0))
DF__T_QM_STKA__FEXPU__7BFB6DEA默认值约束FEXPUNIT(' ')
DF__T_QM_STKA__FSTOC__7CEF9223默认值约束FSTOCKCONVERTTYPE('1')
DF__T_QM_STKA__FBFLO__7DE3B65C默认值约束FBFLOWID(' ')
DF__T_QM_STKAP__FQTY__7ED7DA95默认值约束FQTY((0))
DF__T_QM_STKA__FBASE__7FCBFECE默认值约束FBASEUNITID((0))

库存请检单-明细_A

概述
表名称实体名称ORM实体名
T_QM_STKAPPINSPECTENTRY_A明细Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
检验选单数量FSelInspectQtySelInspectQtyFSELINSPECTQTYdecimal132310((0))
检验数量FInspectQtyInspectQtyFINSPECTQTYdecimal132310((0))
合格数量FQuaQtyQuaQtyFQUAQTYdecimal132310((0))
不合格数量FFailQtyFailQtyFFAILQTYdecimal132310((0))
报废数量FScrapQtyScrapQtyFSCRAPQTYdecimal132310((0))
合格转换选单数量FSelQuaTranQtySelQuaTranQtyFSELQUATRANQTYdecimal132310((0))
合格转换数量FQuaTranQtyQuaTranQtyFQUATRANQTYdecimal132310((0))
不合格转换选单数量FSelFailTranQtySelFailTranQtyFSELFAILTRANQTYdecimal132310((0))
不合格转换数量FFailTranQtyFailTranQtyFFAILTRANQTYdecimal132310((0))
报废转换选单数量FSelScrapTranQtySelScrapTranQtyFSELSCRAPTRANQTYdecimal132310((0))
报废转换数量FScrapTranQtyScrapTranQtyFSCRAPTRANQTYdecimal132310((0))
基本单位检验选单数量FBaseSelInspectQtyBaseSelInspectQtyFBASESELINSPECTQTYdecimal132310((0))
基本单位检验数量FBaseInspectQtyBaseInspectQtyFBASEINSPECTQTYdecimal132310((0))
基本单位合格数量FBaseQuaQtyBaseQuaQtyFBASEQUAQTYdecimal132310((0))
基本单位不合格数量FBaseFailQtyBaseFailQtyFBASEFAILQTYdecimal132310((0))
基本单位报废数量FBaseScrapQtyBaseScrapQtyFBASESCRAPQTYdecimal132310((0))
基本单位合格转换选单数量FBaseSelQuaTranQtyBaseSelQuaTranQtyFBASESELQUATRANQTYdecimal132310((0))
基本单位合格转换数量FBaseQuaTranQtyBaseQuaTranQtyFBASEQUATRANQTYdecimal132310((0))
基本单位不合格转换选单数量FBaseSelFailTranQtyBaseSelFailTranQtyFBASESELFAILTRANQTYdecimal132310((0))
基本单位不合格转换数量FBaseFailTranQtyBaseFailTranQtyFBASEFAILTRANQTYdecimal132310((0))
基本单位报废转换选单数量FBaseSelScrapTranQtyBaseSelScrapTranQtyFBASESELSCRAPTRANQTYdecimal132310((0))
基本单位报废转换数量FBaseScrapTranQtyBaseScrapTranQtyFBASESCRAPTRANQTYdecimal132310((0))
基本单位合格出库选单数量FBaseSelOutStkQtyBaseSelOutStkQtyFBASESELOUTSTKQTYdecimal132310((0))
合格出库选单数量FSelOutStkQTYSelOutStkQTYFSELOUTSTKQTYdecimal132310((0))
不合格可销售出库选单数量FUnQuaSelOutStkQtyUnQuaSelOutStkQtyFUNQUASELOUTSTKQTYdecimal132310((0))
基本单位不合格可销售出库选单数量FBaseUnQuaSOStkQtyBaseUnQuaSOStkQtyFBASEUNQUASOSTKQTYdecimal132310((0))
不合格可销售数量FUnQuaSalQtyUnQuaSalQtyFUNQUASALQTYdecimal132310((0))
基本单位不合格可销售数量FBaseUnQuaSalQtyBaseUnQuaSalQtyFBASEUNQUASALQTYdecimal132310((0))
合格调拨数量FQuaTranDirQtyQuaTranDirQtyFQUATRANDIRQTYdecimal132310((0.0))
合格调拨数量(基本)FBaseQuaTranDirQtyBaseQuaTranDirQtyFBASEQUATRANDIRQTYdecimal132310((0.0))
不合格调拨数量FUnQuaTranDirQtyUnQuaTranDirQtyFUNQUATRANDIRQTYdecimal132310((0.0))
不合格调拨数量(基本)FBaseUnQuaTranDirQtyBaseUnQuaTranDirQtyFBASEUNQUATRANDIRQTYdecimal132310((0.0))
发货检验合格调拨出库数量FDeliChkTranOutQtyDeliChkTranOutQtyFDELICHKTRANOUTQTYdecimal132310((0))
发货检验合格调拨出库数量(基本)FBaseDeliChkTranOutQtyBaseDeliChkTranOutQtyFBASEDELICHKTRANOUTQTYdecimal132310((0))
发货检验不合格调拨出库数量FDeliChkTranOutUQQtyDeliChkTranOutUQQtyFDELICHKTRANOUTUQQTYdecimal132310((0))
发货检验不合格调拨出库数量(基本)FBaseDeliChkTranOutUQQtyBaseDeliChkTranOutUQQtyFBASEDELICHKTRANOUTUQQTYdecimal132310((0))
新有效期至FNewExpiryDateNewExpiryDateFNEWEXPIRYDATEdatetime8233
供应商批号FSupplierLotSupplierLotFSUPPLIERLOTnvarchar5102550
项目编号FProjectNoProjectNoFPROJECTNOnvarchar160800
索引
名称类型字段
PK_QM_STKAPPINSPECTENTRY_ACLUSTEREDFENTRYID
IDX_QM_STKAPPIE_A_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_STKAPPINSPECTENTRY_APKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_STKAPPINSPECTENTRY_A主键约束FENTRYID
DF__T_QM_STKA__FQUAT__14410482默认值约束FQUATRANDIRQTY((0.0))
DF__T_QM_STKA__FBASE__153528BB默认值约束FBASEQUATRANDIRQTY((0.0))
DF__T_QM_STKA__FUNQU__16294CF4默认值约束FUNQUATRANDIRQTY((0.0))
DF__T_QM_STKA__FBASE__171D712D默认值约束FBASEUNQUATRANDIRQTY((0.0))
DF__T_QM_STKA__FDELI__5975446F默认值约束FDELICHKTRANOUTQTY((0))
DF__T_QM_STKA__FBASE__5A6968A8默认值约束FBASEDELICHKTRANOUTQTY((0))
DF__T_QM_STKA__FDELI__5B5D8CE1默认值约束FDELICHKTRANOUTUQQTY((0))
DF__T_QM_STKA__FENTR__5B8E9E58默认值约束FENTRYID((0))
DF__T_QM_STKA__FBASE__5C51B11A默认值约束FBASEDELICHKTRANOUTUQQTY((0))
DF__T_QM_STKA__FSELI__5C82C291默认值约束FSELINSPECTQTY((0))
DF__T_QM_STKA__FINSP__5D76E6CA默认值约束FINSPECTQTY((0))
DF__T_QM_STKA__FQUAQ__5E6B0B03默认值约束FQUAQTY((0))
DF__T_QM_STKA__FFAIL__5F5F2F3C默认值约束FFAILQTY((0))
DF__T_QM_STKA__FSCRA__60535375默认值约束FSCRAPQTY((0))
DF__T_QM_STKA__FSELQ__614777AE默认值约束FSELQUATRANQTY((0))
DF__T_QM_STKA__FQUAT__623B9BE7默认值约束FQUATRANQTY((0))
DF__T_QM_STKA__FSELF__632FC020默认值约束FSELFAILTRANQTY((0))
DF__T_QM_STKA__FFAIL__6423E459默认值约束FFAILTRANQTY((0))
DF__T_QM_STKA__FSELS__65180892默认值约束FSELSCRAPTRANQTY((0))
DF__T_QM_STKA__FSCRA__660C2CCB默认值约束FSCRAPTRANQTY((0))
DF__T_QM_STKA__FBASE__67005104默认值约束FBASESELINSPECTQTY((0))
DF__T_QM_STKA__FBASE__67F4753D默认值约束FBASEINSPECTQTY((0))
DF__T_QM_STKA__FSELO__680D7C89默认值约束FSELOUTSTKQTY((0))
DF__T_QM_STKA__FBASE__68E89976默认值约束FBASEQUAQTY((0))
DF__T_QM_STKA__FBASE__6901A0C2默认值约束FBASESELOUTSTKQTY((0))
DF__T_QM_STKA__FBASE__69DCBDAF默认值约束FBASEFAILQTY((0))
DF__T_QM_STKA__FUNQU__69F5C4FB默认值约束FUNQUASELOUTSTKQTY((0))
DF__T_QM_STKA__FBASE__6AD0E1E8默认值约束FBASESCRAPQTY((0))
DF__T_QM_STKA__FBASE__6AE9E934默认值约束FBASEUNQUASOSTKQTY((0))
DF__T_QM_STKA__FBASE__6BC50621默认值约束FBASESELQUATRANQTY((0))
DF__T_QM_STKA__FUNQU__6BDE0D6D默认值约束FUNQUASALQTY((0))
DF__T_QM_STKA__FBASE__6CB92A5A默认值约束FBASEQUATRANQTY((0))
DF__T_QM_STKA__FBASE__6CD231A6默认值约束FBASEUNQUASALQTY((0))
DF__T_QM_STKA__FBASE__6DAD4E93默认值约束FBASESELFAILTRANQTY((0))
DF__T_QM_STKA__FBASE__6EA172CC默认值约束FBASEFAILTRANQTY((0))
DF__T_QM_STKA__FBASE__6F959705默认值约束FBASESELSCRAPTRANQTY((0))
DF__T_QM_STKA__FBASE__7089BB3E默认值约束FBASESCRAPTRANQTY((0))

库存请检单-明细_L

概述
表名称实体名称ORM实体名
T_QM_STKAPPINSPECTENTRY_L明细Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
备注FMemoMemoFMEMOnvarchar5102550
索引
名称类型字段
PK_QM_STKAPPINSPECTENTRY_LCLUSTEREDFPKID
IDX_QM_STKAPPINSPECTENTRY_LNONCLUSTEREDFENTRYIDFLOCALEID
主外键
名称类型字段
PK_QM_STKAPPINSPECTENTRY_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_STKAPPINSPECTENTRY_L主键约束FPKID
DF__T_QM_STKA__FPKID__5205341E默认值约束FPKID((0))

库存请检单-序列号子单据体

概述
表名称实体名称ORM实体名
T_QM_STKAPPMTRLSERIAL序列号子单据体QM_STKAPPMtrlSerial
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
序列号FSerialNoSerialNoFSERIALNOnvarchar160800(' ')
序列号FSerialIdSerialIdFSERIALIDint4100((0))
备注FSerialNoteSerialNoteFSERIALNOTEnvarchar5102550
检验结果FInspectResultInspectResultFINSPECTRESULTchar110('0')
转换标志FConvertionFlagConvertionFlagFCONVERTIONFLAGchar110('0')
出库关联标志FOutStkFlagOutStkFlagFOUTSTKFLAGchar110('0')
可销售FCanSaleCanSaleFCANSALEchar110('0')
调拨关联标志FTranDirFlagTranDirFlagFTRANDIRFLAGchar110('0')
索引
名称类型字段
PK_QM_STKAPPMTRLSERIALCLUSTEREDFDETAILID
IDX_QM_STKAPPMTRLSN_EIDNONCLUSTEREDFENTRYID
IDX_QM_STKAPPMTRLSN_SNNONCLUSTEREDFSERIALNO
主外键
名称类型字段
PK_QM_STKAPPMTRLSERIALPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_STKAPPMTRLSERIAL主键约束FDETAILID
DF__T_QM_STKA__FINSP__265FB4BD默认值约束FINSPECTRESULT('0')
DF__T_QM_STKA__FCONV__2753D8F6默认值约束FCONVERTIONFLAG('0')
DF__T_QM_STKA__FDETA__53ED7C90默认值约束FDETAILID((0))
DF__T_QM_STKA__FENTR__54E1A0C9默认值约束FENTRYID((0))
DF__T_QM_STKAP__FSEQ__55D5C502默认值约束FSEQ((0))
DF__T_QM_STKA__FSERI__56C9E93B默认值约束FSERIALNO(' ')
DF__T_QM_STKA__FSERI__57BE0D74默认值约束FSERIALID((0))
DF__T_QM_STKA__FOUTS__6BA2DA55默认值约束FOUTSTKFLAG('0')
DF__T_QM_STKA__FTRAN__6C96FE8E默认值约束FTRANDIRFLAG('0')
DF__T_QM_STKA__FCANS__6D8B22C7默认值约束FCANSALE('0')

库存请检单-关联关系表

概述
表名称实体名称ORM实体名
T_QM_STKAPPINSPECTENTRY_LK关联关系表FEntity_Link
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值
业务流程图FEntity_Link_FFlowIdFlowIdFFLOWIDvarchar36360
推进路线FEntity_Link_FFlowLineIdFlowLineIdFFLOWLINEIDint4100((0))
转换规则FEntity_Link_FRuleIdRuleIdFRULEIDvarchar36360
源单表内码FEntity_Link_FSTableIdSTableIdFSTABLEIDint4100
源单表FEntity_Link_FSTableNameSTableNameFSTABLENAMEvarchar30300
源单内码FEntity_Link_FSBillIdSBillIdFSBILLIDvarchar36360
源单分录内码FEntity_Link_FSIdSIdFSIDvarchar36360
原始携带量FEntity_Link_FBaseQtyOldBaseQtyOldFBASEQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
索引
名称类型字段
PK_T_QM_STKAPPINSPECTENTRY_LKCLUSTEREDFLINKID
IDX_QM_SIE_LK_SIDNONCLUSTEREDFSID
IDX_QM_SIE_LK_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_T_QM_STKAPPINSPECTENTRY_LKPKFLINKID
触发器
约束
名称类型字段描述
PK_T_QM_STKAPPINSPECTENTRY_LK主键约束FLINKID
DF__T_QM_STKA__FFLOW__5F783688默认值约束FFLOWLINEID((0))
DF__T_QM_STKA__FBASE__606C5AC1默认值约束FBASEQTYOLD((0))
DF__T_QM_STKA__FBASE__61607EFA默认值约束FBASEQTY((0))

1.1.27 库存请检中转单

库存请检中转单-单据头

概述
表名称实体名称ORM实体名
T_QM_STKAPPTRANSBILL单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
保管者编码FKeeperIdKeeperIdFKEEPERIDint4100
货主FOwnerIdOwnerIdFOWNERIDint4100
仓位FStockLocIdStockLocIdFSTOCKLOCIDint4100
库存组织FStockOrgIdStockOrgIdFSTOCKORGIDint4100
库存主单位FStockUnitIdStockUnitIdFSTOCKUNITIDint4100
库存量FStockQtyStockQtyFSTOCKQTYdecimal132310((0))
库存量(库存辅单位)FStkSecStockQtyStkSecStockQtyFSTKSECSTOCKQTYdecimal132310((0))
计划跟踪号FMtoNoMtoNoFMTONOnvarchar5102550
保管者类型FKeeperTypeIdKeeperTypeIdFKEEPERTYPEIDvarchar36360
货主类型FOwnerTypeIdOwnerTypeIdFOWNERTYPEIDvarchar36360
库存状态FStockStatusIdStockStatusIdFSTOCKSTATUSIDint4100
BOM版本FBomIdBomIdFBOMIDint4100
有效期至FExpiryDateExpiryDateFEXPIRYDATEdatetime8233
物料编码FMaterialIdMaterialIdFMATERIALIDint4100
生产日期FProduceDateProduceDateFPRODUCEDATEdatetime8233
仓库FStockIdStockIdFSTOCKIDint4100
辅助属性FAuxpropIdAuxpropIdFAUXPROPIDint4100
库存辅单位FStkSecUnitIdStkSecUnitIdFSTKSECUNITIDint4100
基本单位FBaseUnitIdBaseUnitIdFBASEUNITIDint4100((0))
基本单位库存量FBaseStockQtyBaseStockQtyFBASESTOCKQTYdecimal132310((0))
GUIDFGUIDGUIDFGUIDvarchar36360(' ')
基本单位可用量FBaseAVBQtyBaseAVBQtyFBASEAVBQTYdecimal132310((0))
可用量FAVBQtyAVBQtyFAVBQTYdecimal132310((0))
可用量(库存辅单位)FStkSecAVBQtyStkSecAVBQtyFSTKSECAVBQTYdecimal132310((0))
批号FLotLotFLOTint4100
项目编号FProjectNoProjectNoFPROJECTNOnvarchar160800
索引
名称类型字段
PK_QM_STKAPPTRANSBILLCLUSTEREDFENTRYID
IDX_QM_STKAPPTRANSBILL_NONONCLUSTEREDFBILLNO
主外键
名称类型字段
PK_QM_STKAPPTRANSBILLPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_STKAPPTRANSBILL主键约束FENTRYID
DF__T_QM_STKA__FENTR__14C71BB4默认值约束FENTRYID((0))
DF__T_QM_STKA__FGUID__15BB3FED默认值约束FGUID(' ')
DF__T_QM_STKA__FEXPU__16AF6426默认值约束FEXPUNIT(' ')
DF__T_QM_STKA__FBASE__17A3885F默认值约束FBASEUNITID((0))
DF__T_QM_STKA__FBASE__1897AC98默认值约束FBASESTOCKQTY((0))
DF__T_QM_STKA__FBASE__198BD0D1默认值约束FBASEAVBQTY((0))
DF__T_QM_STKA__FSTOC__1A7FF50A默认值约束FSTOCKQTY((0))
DF__T_QM_STKA__FAVBQ__1B741943默认值约束FAVBQTY((0))
DF__T_QM_STKA__FSTKS__1C683D7C默认值约束FSTKSECSTOCKQTY((0))
DF__T_QM_STKA__FSTKS__1D5C61B5默认值约束FSTKSECAVBQTY((0))

1.1.28 库存检验控制码

库存检验控制码-单据头

概述
表名称实体名称ORM实体名
T_QM_STKQCCTRLCODE单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
库存检验质检完成自动转换库存状态FQCAutoTranSTKStatusQCAutoTranSTKStatusFQCAUTOTRANSTKSTATUSchar110('0')
合格品仓库仓位FQuaStocksQuaStocksFQUASTOCKSchar110('1')
合格品库存状态FQuaStockStatusIdQuaStockStatusIdFQUASTOCKSTATUSIDint4100
合格品仓库FQuaStockIdQuaStockIdFQUASTOCKIDint4100
合格品仓位FQuaStockLocIdQuaStockLocIdFQUASTOCKLOCIDint4100
不良品仓库仓位FFailStocksFailStocksFFAILSTOCKSchar110('1')
不良品仓位FFailStockLocIdFailStockLocIdFFAILSTOCKLOCIDint4100
不良品库存状态FFailStockStatusIdFailStockStatusIdFFAILSTOCKSTATUSIDint4100
不良品仓库FFailStockIdFailStockIdFFAILSTOCKIDint4100
报废品仓库仓位FScrapStocksScrapStocksFSCRAPSTOCKSchar110('1')
报废品仓位FScrapStockLocIdScrapStockLocIdFSCRAPSTOCKLOCIDint4100
报废品库存状态FScrapStockStatusIdScrapStockStatusIdFSCRAPSTOCKSTATUSIDint4100
报废品仓库FScrapStockIdScrapStockIdFSCRAPSTOCKIDint4100
库存组织FStockOrgIdStockOrgIdFSTOCKORGIDint4100
库存请检自动质检冻结FAppAutoFreezeAppAutoFreezeFAPPAUTOFREEZEchar110('0')
质检冻结库存状态FStkStatusStkStatusFSTKSTATUSint4100
不良品处理单审核自动转换库存状态FDefAutoTranSTKStatusDefAutoTranSTKStatusFDEFAUTOTRANSTKSTATUSchar110('0')
不参与核算质检冻结状态FNASTKStatusNASTKStatusFNASTKSTATUSint4100
不参与核算合格品库存状态FNAQuaStockStatusIdNAQuaStockStatusIdFNAQUASTOCKSTATUSIDint4100
合格品仓位FNAQuaStockLocIdNAQuaStockLocIdFNAQUASTOCKLOCIDint4100
不参与核算不良品库存状态FNAFailStockStatusIdNAFailStockStatusIdFNAFAILSTOCKSTATUSIDint4100
不良品仓位FNAFailStockLocIdNAFailStockLocIdFNAFAILSTOCKLOCIDint4100
不参与核算报废品库存状态FNAScrapStockStatusIdNAScrapStockStatusIdFNASCRAPSTOCKSTATUSIDint4100
报废品仓位FNAScrapStockLocIdNAScrapStockLocIdFNASCRAPSTOCKLOCIDint4100
交互式FIsInteractiveIsInteractiveFISINTERACTIVEchar110('1')
首次复检提醒取生产日期FIsProduceDateIsProduceDateFISPRODUCEDATEchar110('0')
发货请检自动质检冻结FDeAppAutoFreezeDeAppAutoFreezeFDEAPPAUTOFREEZEchar110('0')
发货质检完成自动转换库存状态FDeQCAutoTranSTKStatusDeQCAutoTranSTKStatusFDEQCAUTOTRANSTKSTATUSchar110('0')
库存检验反质检完成自动删除库存状态转换单FQCAutoDeSTKStatusQCAutoDeSTKStatusFQCAUTODESTKSTATUSchar110('0')
不良品处理单反审核自动删除库存状态转换单FDefAutoDeSTKStatusDefAutoDeSTKStatusFDEFAUTODESTKSTATUSchar110('0')
发货检验反质检完成自动删除库存状态转换单FDeQCAutoDeSTKStatusDeQCAutoDeSTKStatusFDEQCAUTODESTKSTATUSchar110('0')
库存状态类型FStockStatusTypeStockStatusTypeFSTOCKSTATUSTYPEvarchar50500
MRB评审单审核自动转换库存状态FMrbAutoTranSTKMrbAutoTranSTKFMRBAUTOTRANSTKchar110('0')
MRB评审单反审核自动删除库存状态转换单FMrbAutoDeSTKMrbAutoDeSTKFMRBAUTODESTKchar110('0')
仅取库存检验日期FIsInspectEndTimeIsInspectEndTimeFISINSPECTENDTIMEchar110('0')
索引
名称类型字段
PK_QM_STKQCCTRLCODECLUSTEREDFID
IDX_QM_STKQCCTRLCODE_NUMNONCLUSTEREDFNUMBER
IDX_QM_STKQCCTRLCODE_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_STKQCCTRLCODEPKFID
触发器
约束
名称类型字段描述
PK_QM_STKQCCTRLCODE主键约束FID
DF__T_QM_STKQCC__FID__0E1A1E25默认值约束FID((0))
DF__T_QM_STKQ__FMAST__0F0E425E默认值约束FMASTERID((0))
DF__T_QM_STKQ__FQCAU__10026697默认值约束FQCAUTOTRANSTKSTATUS('0')
DF__T_QM_STKQ__FQUAS__10F68AD0默认值约束FQUASTOCKS('1')
DF__T_QM_STKQ__FFAIL__11EAAF09默认值约束FFAILSTOCKS('1')
DF__T_QM_STKQ__FSCRA__12DED342默认值约束FSCRAPSTOCKS('1')
DF__T_QM_STKQ__FISIN__221EE697默认值约束FISINTERACTIVE('1')
DF__T_QM_STKQ__FDEFA__334F9B87默认值约束FDEFAUTOTRANSTKSTATUS('0')
DF__T_QM_STKQ__FAPPA__39528DA0默认值约束FAPPAUTOFREEZE('0')
DF__T_QM_STKQ__FISIN__3DC59C28默认值约束FISINSPECTENDTIME('0')
DF__T_QM_STKQ__FISPR__665F024B默认值约束FISPRODUCEDATE('0')
DF__T_QM_STKQ__FDEAP__67532684默认值约束FDEAPPAUTOFREEZE('0')
DF__T_QM_STKQ__FDEQC__68474ABD默认值约束FDEQCAUTOTRANSTKSTATUS('0')
DF__T_QM_STKQ__FMRBA__7AF66595默认值约束FMRBAUTOTRANSTK('0')
DF__T_QM_STKQ__FMRBA__7BEA89CE默认值约束FMRBAUTODESTK('0')
DF__T_QM_STKQ__FQCAU__7D7C35D7默认值约束FQCAUTODESTKSTATUS('0')
DF__T_QM_STKQ__FDEFA__7E705A10默认值约束FDEFAUTODESTKSTATUS('0')
DF__T_QM_STKQ__FDEQC__7F647E49默认值约束FDEQCAUTODESTKSTATUS('0')

库存检验控制码-单据头_A

概述
表名称实体名称ORM实体名
T_QM_STKQCCTRLCODE_A单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
发货不良品处理单审核自动转换库存状态FDelDefAutoTranStatusDelDefAutoTranStatusFDELDEFAUTOTRANSTATUSchar110('0')
发货检验不良品处理单反审核自动删除库存状态转换单FDelDefAutoDeStatusDelDefAutoDeStatusFDELDEFAUTODESTATUSchar110('0')
库存状态转换单单据状态FConvertBillStatusConvertBillStatusFCONVERTBILLSTATUSchar110('3')
库存状态转换单单据状态FDeConvertBillStatusDeConvertBillStatusFDECONVERTBILLSTATUSchar110('3')
检验后自动生成的库存状态转换单触发审批流FIsAutoSubmitFlowIsAutoSubmitFlowFISAUTOSUBMITFLOWchar110('0')
索引
名称类型字段
PK_QM_STKQCCTRLCODE_ACLUSTEREDFID
主外键
名称类型字段
PK_QM_STKQCCTRLCODE_APKFID
触发器
约束
名称类型字段描述
PK_QM_STKQCCTRLCODE_A主键约束FID
DF__T_QM_STKQCC__FID__2FC4C2F0默认值约束FID((0))
DF__T_QM_STKQ__FDELD__30B8E729默认值约束FDELDEFAUTOTRANSTATUS('0')
DF__T_QM_STKQ__FDELD__31AD0B62默认值约束FDELDEFAUTODESTATUS('0')
DF__T_QM_STKQ__FCONV__69989274默认值约束FCONVERTBILLSTATUS('3')
DF__T_QM_STKQ__FDECO__6A8CB6AD默认值约束FDECONVERTBILLSTATUS('3')
DF__T_QM_STKQ__FISAU__6B80DAE6默认值约束FISAUTOSUBMITFLOW('0')

库存检验控制码-单据头_L

概述
表名称实体名称ORM实体名
T_QM_STKQCCTRLCODE_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_STKQCCTRLCODE_LCLUSTEREDFPKID
IDX_QM_STKQCCTRLCODE_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_STKQCCTRLCODE_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_STKQCCTRLCODE_L主键约束FPKID
DF__T_QM_STKQ__FPKID__76429494默认值约束FPKID((0))

库存检验控制码-复检提醒仓库信息

概述
表名称实体名称ORM实体名
T_QM_STKQCCTRLCODEENTRY复检提醒仓库信息Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
仓库编码FStockIdStockIdFSTOCKIDint4100
复检提醒FReCheckWarnReCheckWarnFRECHECKWARNchar110('1')
索引
名称类型字段
PK_QM_STKQCCTRLCODEENTRYCLUSTEREDFENTRYID
IDX_QM_STKQCCTRLCODEE_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_STKQCCTRLCODEENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_STKQCCTRLCODEENTRY主键约束FENTRYID
DF__T_QM_STKQ__FENTR__782ADD06默认值约束FENTRYID((0))
DF__T_QM_STKQ__FRECH__791F013F默认值约束FRECHECKWARN('1')

1.1.29 宽严度转换规则

宽严度转换规则-单据头

概述
表名称实体名称ORM实体名
T_QM_STRICTCONVRULE单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
数据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
禁用状态FForbidStatusForbidStatusFFORBIDSTATUSchar110
编码FNumberNumberFNUMBERnvarchar160800
创建组织FCreateOrgIdCreateOrgIdFCREATEORGIDint4100
使用组织FUseOrgIdUseOrgIdFUSEORGIDint4100
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
禁用人FForbidderIdForbidderIdFFORBIDDERIDint4100
审核人FApproverIdApproverIdFAPPROVERIDint4100
禁用日期FForbidDateForbidDateFFORBIDDATEdatetime8233
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
索引
名称类型字段
PK_QM_STRICTCONVRULECLUSTEREDFID
IDX_QM_STRICTCONVRULE_NUMNONCLUSTEREDFNUMBER
IDX_QM_STRICTCONVRULE_DATENONCLUSTEREDFCREATEDATE
主外键
名称类型字段
PK_QM_STRICTCONVRULEPKFID
触发器
约束
名称类型字段描述
PK_QM_STRICTCONVRULE主键约束FID
DF__T_QM_STRICT__FID__2A150E1A默认值约束FID((0))
DF__T_QM_STRI__FMAST__2B093253默认值约束FMASTERID((0))

宽严度转换规则-单据头_L

概述
表名称实体名称ORM实体名
T_QM_STRICTCONVRULE_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
名称FNameNameFNAMEnvarchar2001000
备注FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_STRICTCONVRULE_LCLUSTEREDFPKID
IDX_QM_STRICTCONVRULE_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_STRICTCONVRULE_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_STRICTCONVRULE_L主键约束FPKID
DF__T_QM_STRI__FPKID__2CF17AC5默认值约束FPKID((0))

宽严度转换规则-明细信息

概述
表名称实体名称ORM实体名
T_QM_STRICTCONVRULEENTRY明细信息Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
从程度FFromStringencyFromStringencyFFROMSTRINGENCYchar110('0')
到程度FToStringencyToStringencyFTOSTRINGENCYchar110('1')
索引
名称类型字段
PK_QM_STRICTCONVRULEENTRYCLUSTEREDFENTRYID
IDX_QM_STRENTRY_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_STRICTCONVRULEENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_STRICTCONVRULEENTRY主键约束FENTRYID
DF__T_QM_STRI__FENTR__2ED9C337默认值约束FENTRYID((0))
DF__T_QM_STRI__FFROM__2FCDE770默认值约束FFROMSTRINGENCY('0')
DF__T_QM_STRI__FTOST__30C20BA9默认值约束FTOSTRINGENCY('1')

宽严度转换规则-转换规则表体

概述
表名称实体名称ORM实体名
T_QM_STRCONVRULEDETAIL转换规则表体RulesEntity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
连续检验批FContinuousNumberContinuousNumberFCONTINUOUSNUMBERint4100
判断因素FJugeFactorJugeFactorFJUGEFACTORchar110('0')
比较符FComOperatorComOperatorFCOMOPERATORchar110('0')
比较值FComValueComValueFCOMVALUEint4100
索引
名称类型字段
PK_QM_STRCONVRULEDETAILCLUSTEREDFDETAILID
IDX_QM_STRCD_ENTRYIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_STRCONVRULEDETAILPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_STRCONVRULEDETAIL主键约束FDETAILID
DF__T_QM_STRC__FDETA__245C34C4默认值约束FDETAILID((0))
DF__T_QM_STRC__FENTR__255058FD默认值约束FENTRYID((0))
DF__T_QM_STRCO__FSEQ__26447D36默认值约束FSEQ((0))
DF__T_QM_STRC__FJUGE__2738A16F默认值约束FJUGEFACTOR('0')
DF__T_QM_STRC__FCOMO__282CC5A8默认值约束FCOMOPERATOR('0')

1.1.30 委外退料请检单

委外退料请检单-单据头

概述
表名称实体名称ORM实体名
T_QM_SUBRMAPPQC单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
单据编号FBillNoBillNoFBILLNOnvarchar160800
单据状态FDocumentStatusDocumentStatusFDOCUMENTSTATUSchar110
审核人FApproverIdApproverIdFAPPROVERIDint4100
审核日期FApproveDateApproveDateFAPPROVEDATEdatetime8233
修改人FModifierIdModifierIdFMODIFIERIDint4100
创建日期FCreateDateCreateDateFCREATEDATEdatetime8233
创建人FCreatorIdCreatorIdFCREATORIDint4100
修改日期FModifyDateModifyDateFMODIFYDATEdatetime8233
作废日期FCancelDateCancelDateFCANCELDATEdatetime8233
作废人FCancelerCANCELERFCANCELERint4100
作废状态FCancelStatusCancelStatusFCANCELSTATUSchar110
收料组织FSupplyOrgIdSupplyOrgIdFSUPPLYORGIDint4100
委外组织FSubOrgIdSubOrgIdFSUBORGIDint4100
单据日期FDateFDateFDATEdatetime8233
库存组FStockGroupIdStockGroupIdFSTOCKGROUPIDint4100
供应商FSupplierSupplierFSUPPLIERint4100
单据类型FBillTypeIDFBillTypeIDFBILLTYPEIDvarchar36360
索引
名称类型字段
PK_QM_SUBRMAPPQCCLUSTEREDFID
IDX_QM_SUBRMAPPQC_NONONCLUSTEREDFBILLNO
IDX_QM_SUBRMAPPQC_DATENONCLUSTEREDFDATE
主外键
名称类型字段
PK_QM_SUBRMAPPQCPKFID
触发器
约束
名称类型字段描述
PK_QM_SUBRMAPPQC主键约束FID

委外退料请检单-单据头_L

概述
表名称实体名称ORM实体名
T_QM_SUBRMAPPQC_L单据头BillHead
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
描述FDescriptionDescriptionFDESCRIPTIONnvarchar5102550
索引
名称类型字段
PK_QM_SUBRMAPPQC_LCLUSTEREDFPKID
IDX_QM_SUBRMAPPQC_ID_LCID_LNONCLUSTEREDFIDFLOCALEID
主外键
名称类型字段
PK_QM_SUBRMAPPQC_LPKFPKID
触发器
约束
名称类型字段描述
PK_QM_SUBRMAPPQC_L主键约束FPKID
DF__T_QM_SUBR__FPKID__7FE0A5A4默认值约束FPKID((0))

委外退料请检单-明细

概述
表名称实体名称ORM实体名
T_QM_SUBRMAPPQCENTRY明细Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
物料编码FMaterialIdMaterialIdFMATERIALIDint4100
供应商FChildSupplierChildSupplierFCHILDSUPPLIERint4100
辅助属性FAuxPropIdAuxPropIdFAUXPROPIDint4100
BOM版本FBomIdBomIdFBOMIDint4100
计划跟踪号FMtoNoMtoNoFMTONOnvarchar5102550
仓库FStockIdStockIdFSTOCKIDint4100
仓位FStockLocIdStockLocIdFSTOCKLOCIDint4100
批号FLotLotFLOTint4100
工序号FOperIdOperIdFOPERIDint4100
作业FProcessIdProcessIdFPROCESSIDint4100
单位FUnitIDUnitIDFUNITIDint4100
数量FQtyQtyFQTYdecimal132310((0))
货主类型FOwnerTypeIdOwnerTypeIdFOWNERTYPEIDvarchar36360
货主FOwnerIdOwnerIdFOWNERIDint4100
检验选单数量FInspectSelQtyInspectSelQtyFINSPECTSELQTYdecimal132310((0))
检验数量FInspectQtyInspectQtyFINSPECTQTYdecimal132310((0))
良品数量FGoodQtyGoodQtyFGOODQTYdecimal132310((0))
来料不良数量FIncDefectQtyIncDefectQtyFINCDEFECTQTYdecimal132310((0))
作业不良数量FProcDefectQtyProcDefectQtyFPROCDEFECTQTYdecimal132310((0))
源单类型FSrcBillTypeSrcBillTypeFSRCBILLTYPEvarchar36360(' ')
源单编号FSrcBillNoSrcBillNoFSRCBILLNOnvarchar160800(' ')
源单内码FSrcBillIdSrcBillIdFSRCBILLIDint4100((0))
源单分录内码FSrcEntryIdSrcEntryIdFSRCENTRYIDint4100((0))
源单行号FSrcSeqSrcSeqFSRCSEQint4100((0))
订单类型FOrderTypeOrderTypeFORDERTYPEvarchar36360(' ')
订单编号FOrderBillNoOrderBillNoFORDERBILLNOnvarchar160800(' ')
订单行号FOrderBillSeqOrderBillSeqFORDERBILLSEQint4100((0))
委外用料清单分录内码FSubPpbomEntryIdSubPpbomEntryIdFSUBPPBOMENTRYIDint4100((0))
委外用料清单内码FSubPpbomIdSubPpbomIdFSUBPPBOMIDint4100((0))
序列号单位FSNUnitIdSNUnitIdFSNUNITIDint4100
序列号单位数量FSNQtySNQtyFSNQTYdecimal132310((0))
委外用料清单编号FSubPpbomNoSubPpbomNoFSUBPPBOMNOnvarchar160800(' ')
基本单位FBaseUnitIdBaseUnitIdFBASEUNITIDint4100((0))
基本单位检验选单数量FBaseInspectSelQtyBaseInspectSelQtyFBASEINSPECTSELQTYdecimal132310((0))
基本单位检验数量FBaseInspectQtyBaseInspectQtyFBASEINSPECTQTYdecimal132310((0))
基本单位良品数量FBaseGoodQtyBaseGoodQtyFBASEGOODQTYdecimal132310((0))
基本单位来料不良数量FBaseIncDefectQtyBaseIncDefectQtyFBASEINCDEFECTQTYdecimal132310((0))
基本单位作业不良数量FBaseProcDefectQtyBaseProcDefectQtyFBASEPROCDEFECTQTYdecimal132310((0))
基本单位数量FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
库存状态FStockStatusIdStockStatusIdFSTOCKSTATUSIDint4100
有效期至FExpDateExpDateFEXPDATEdatetime8233
生产日期FPrdDatePrdDateFPRDDATEdatetime8233
产品货主类型FParentOwnerTypeIdParentOwnerTypeIdFPARENTOWNERTYPEIDvarchar36360
产品货主FParentOwnerIdParentOwnerIdFPARENTOWNERIDint4100((0))
订单内码FOrderIdOrderIdFORDERIDint4100((0))
订单分录内码FOrderEntryIdOrderEntryIdFORDERENTRYIDint4100((0))
产品编码FParentMaterialIdParentMaterialIdFPARENTMATERIALIDint4100
索引
名称类型字段
PK_QM_SUBRMAPPQCENTRYCLUSTEREDFENTRYID
IDX_QM_SUBRMAPPQCE_IDNONCLUSTEREDFID
IDX_QM_SUBRMAPPQCE_MTRLIDNONCLUSTEREDFMATERIALID
主外键
名称类型字段
PK_QM_SUBRMAPPQCENTRYPKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_SUBRMAPPQCENTRY主键约束FENTRYID
DF__T_QM_SUBR__FENTR__01C8EE16默认值约束FENTRYID((0))
DF__T_QM_SUBR__FBASE__02BD124F默认值约束FBASEUNITID((0))
DF__T_QM_SUBRM__FQTY__03B13688默认值约束FQTY((0))
DF__T_QM_SUBR__FBASE__04A55AC1默认值约束FBASEQTY((0))
DF__T_QM_SUBR__FINSP__05997EFA默认值约束FINSPECTSELQTY((0))
DF__T_QM_SUBR__FBASE__068DA333默认值约束FBASEINSPECTSELQTY((0))
DF__T_QM_SUBR__FINSP__0781C76C默认值约束FINSPECTQTY((0))
DF__T_QM_SUBR__FBASE__0875EBA5默认值约束FBASEINSPECTQTY((0))
DF__T_QM_SUBR__FGOOD__096A0FDE默认值约束FGOODQTY((0))
DF__T_QM_SUBR__FBASE__0A5E3417默认值约束FBASEGOODQTY((0))
DF__T_QM_SUBR__FINCD__0B525850默认值约束FINCDEFECTQTY((0))
DF__T_QM_SUBR__FBASE__0C467C89默认值约束FBASEINCDEFECTQTY((0))
DF__T_QM_SUBR__FPROC__0D3AA0C2默认值约束FPROCDEFECTQTY((0))
DF__T_QM_SUBR__FBASE__0E2EC4FB默认值约束FBASEPROCDEFECTQTY((0))
DF__T_QM_SUBR__FPARE__0F22E934默认值约束FPARENTOWNERID((0))
DF__T_QM_SUBR__FSRCB__10170D6D默认值约束FSRCBILLTYPE(' ')
DF__T_QM_SUBR__FSRCB__110B31A6默认值约束FSRCBILLNO(' ')
DF__T_QM_SUBR__FSRCB__11FF55DF默认值约束FSRCBILLID((0))
DF__T_QM_SUBR__FSRCE__12F37A18默认值约束FSRCENTRYID((0))
DF__T_QM_SUBR__FSRCS__13E79E51默认值约束FSRCSEQ((0))
DF__T_QM_SUBR__FORDE__14DBC28A默认值约束FORDERTYPE(' ')
DF__T_QM_SUBR__FORDE__15CFE6C3默认值约束FORDERBILLNO(' ')
DF__T_QM_SUBR__FORDE__16C40AFC默认值约束FORDERID((0))
DF__T_QM_SUBR__FORDE__17B82F35默认值约束FORDERENTRYID((0))
DF__T_QM_SUBR__FORDE__18AC536E默认值约束FORDERBILLSEQ((0))
DF__T_QM_SUBR__FSNQT__19A077A7默认值约束FSNQTY((0))
DF__T_QM_SUBR__FSUBP__1A949BE0默认值约束FSUBPPBOMNO(' ')
DF__T_QM_SUBR__FSUBP__1B88C019默认值约束FSUBPPBOMID((0))
DF__T_QM_SUBR__FSUBP__1C7CE452默认值约束FSUBPPBOMENTRYID((0))

委外退料请检单-明细_A

概述
表名称实体名称ORM实体名
T_QM_SUBRMAPPQCENTRY_A明细Entity
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
良品退料选单数量FSelGoodRtnQtySelGoodRtnQtyFSELGOODRTNQTYdecimal132310((0))
良品退料数量FGoodRtnQtyGoodRtnQtyFGOODRTNQTYdecimal132310((0))
来料不良退料选单数量FSelIncDefectRtnQtySelIncDefectRtnQtyFSELINCDEFECTRTNQTYdecimal132310((0))
来料不良退料数量FIncDefectRtnQtyIncDefectRtnQtyFINCDEFECTRTNQTYdecimal132310((0))
作业不良退料数量FProcDefectRtnQtyProcDefectRtnQtyFPROCDEFECTRTNQTYdecimal132310((0))
作业不良退料选单数量FSelProcDefectRtnQtySelProcDefectRtnQtyFSELPROCDEFECTRTNQTYdecimal132310((0))
基本单位良品退料选单数量FBaseSelGoodRtnQtyBaseSelGoodRtnQtyFBASESELGOODRTNQTYdecimal132310((0))
基本单位来料不良退料数量FBaseIncDefectRtnQtyBaseIncDefectRtnQtyFBASEINCDEFECTRTNQTYdecimal132310((0))
基本单位良品退料数量FBaseGoodRtnQtyBaseGoodRtnQtyFBASEGOODRTNQTYdecimal132310((0))
基本单位来料不良退料选单数量FBaseSelIncDefectRtnQtyBaseSelIncDefectRtnQtyFBASESELINCDEFECTRTNQTYdecimal132310((0))
基本单位作业不良退料数量FBaseProcDefectRtnQtyBaseProcDefectRtnQtyFBASEPROCDEFECTRTNQTYdecimal132310((0))
基本单位作业不良退料选单数量FBaseSelProcDefectRtnQtyBaseSelProcDefectRtnQtyFBASESELPROCDEFECTRTNQTYdecimal132310((0))
退料类型-供下推委外退料使用FReturnTypeReturnTypeFRETURNTYPEchar110('1')
索引
名称类型字段
PK_QM_SUBRMAPPQCENTRY_ACLUSTEREDFENTRYID
IDX_QM_SUBRMAPPQCE_A_IDNONCLUSTEREDFID
主外键
名称类型字段
PK_QM_SUBRMAPPQCENTRY_APKFENTRYID
触发器
约束
名称类型字段描述
PK_QM_SUBRMAPPQCENTRY_A主键约束FENTRYID
DF__T_QM_SUBR__FENTR__1E652CC4默认值约束FENTRYID((0))
DF__T_QM_SUBR__FBASE__1F5950FD默认值约束FBASESELGOODRTNQTY((0))
DF__T_QM_SUBR__FBASE__204D7536默认值约束FBASESELINCDEFECTRTNQTY((0))
DF__T_QM_SUBR__FBASE__2141996F默认值约束FBASESELPROCDEFECTRTNQTY((0))
DF__T_QM_SUBR__FBASE__2235BDA8默认值约束FBASEGOODRTNQTY((0))
DF__T_QM_SUBR__FBASE__2329E1E1默认值约束FBASEINCDEFECTRTNQTY((0))
DF__T_QM_SUBR__FBASE__241E061A默认值约束FBASEPROCDEFECTRTNQTY((0))
DF__T_QM_SUBR__FSELG__25122A53默认值约束FSELGOODRTNQTY((0))
DF__T_QM_SUBR__FSELI__26064E8C默认值约束FSELINCDEFECTRTNQTY((0))
DF__T_QM_SUBR__FSELP__26FA72C5默认值约束FSELPROCDEFECTRTNQTY((0))
DF__T_QM_SUBR__FGOOD__27EE96FE默认值约束FGOODRTNQTY((0))
DF__T_QM_SUBR__FPROC__28E2BB37默认值约束FPROCDEFECTRTNQTY((0))
DF__T_QM_SUBR__FINCD__29D6DF70默认值约束FINCDEFECTRTNQTY((0))
DF__T_QM_SUBR__FRETU__2ACB03A9默认值约束FRETURNTYPE('1')

委外退料请检单-序列号子单据体

概述
表名称实体名称ORM实体名
T_QM_SUBRMAPPQCSERIAL序列号子单据体QM_SUBRMAPPQCSERIAL
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值系统预设
序列号FSerialIdSerialIdFSERIALIDint4100((0))
检验结果FInspectResultInspectResultFINSPECTRESULTchar110
序列号FSerialNoSerialNoFSERIALNOnvarchar160800(' ')
退料关联标志FRtnMtrlAppFlagRtnMtrlAppFlagFRTNMTRLAPPFLAGchar110('0')
备注FSerialNoteSerialNoteFSERIALNOTEnvarchar5102550
索引
名称类型字段
PK_QM_SUBRMAPPQCSERIALCLUSTEREDFDETAILID
IDX_QM_SUBRMAPPQCES_EIDNONCLUSTEREDFENTRYID
IDX_QM_SUBRMAPPES_SNNONCLUSTEREDFSERIALNO
主外键
名称类型字段
PK_QM_SUBRMAPPQCSERIALPKFDETAILID
触发器
约束
名称类型字段描述
PK_QM_SUBRMAPPQCSERIAL主键约束FDETAILID
DF__T_QM_SUBR__FDETA__3083DCFF默认值约束FDETAILID((0))
DF__T_QM_SUBR__FENTR__31780138默认值约束FENTRYID((0))
DF__T_QM_SUBRM__FSEQ__326C2571默认值约束FSEQ((0))
DF__T_QM_SUBR__FSERI__336049AA默认值约束FSERIALNO(' ')
DF__T_QM_SUBR__FSERI__34546DE3默认值约束FSERIALID((0))
DF__T_QM_SUBR__FRTNM__3548921C默认值约束FRTNMTRLAPPFLAG('0')

委外退料请检单-关联关系表

概述
表名称实体名称ORM实体名
T_QM_SUBRMAPPQCENTRY_LK关联关系表FEntity_Link
字段
标题标识实体属性名称数据类型长度精度小数精度允许空值默认值
业务流程图FEntity_Link_FFlowIdFlowIdFFLOWIDvarchar36360
推进路线FEntity_Link_FFlowLineIdFlowLineIdFFLOWLINEIDint4100((0))
转换规则FEntity_Link_FRuleIdRuleIdFRULEIDvarchar36360
源单表内码FEntity_Link_FSTableIdSTableIdFSTABLEIDint4100
源单表FEntity_Link_FSTableNameSTableNameFSTABLENAMEvarchar30300
源单内码FEntity_Link_FSBillIdSBillIdFSBILLIDvarchar36360
源单分录内码FEntity_Link_FSIdSIdFSIDvarchar36360
原始携带量FEntity_Link_FBaseQtyOldBaseQtyOldFBASEQTYOLDdecimal132310((0))
修改携带量FEntity_Link_FBaseQtyBaseQtyFBASEQTYdecimal132310((0))
索引
名称类型字段
PK_QM_SUBRMAPPQCENTRY_LKCLUSTEREDFLINKID
IDX_QM_SUBRMAPPQCE_LK_SIDNONCLUSTEREDFSID
IDX_QM_SUBRMAPPQC_LK_EIDNONCLUSTEREDFENTRYID
主外键
名称类型字段
PK_QM_SUBRMAPPQCENTRY_LKPKFLINKID
触发器
约束
名称类型字段描述
PK_QM_SUBRMAPPQCENTRY_LK主键约束FLINKID
DF__T_QM_SUBR__FFLOW__2CB34C1B默认值约束FFLOWLINEID((0))
DF__T_QM_SUBR__FBASE__2DA77054默认值约束FBASEQTYOLD((0))
DF__T_QM_SUBR__FBASE__2E9B948D默认值约束FBASEQTY((0))