接口数据库结构字典说明.doc

基础数据表接口接口表：（tak_gree_interface）接口序号列名数据类型长度主键外键允许空说明1idint20是主键（自增）2interfacenamevarchar36接口名称3descriptionvarchar36接口描述4interfacetypevarchar36接口类型5interurlvarchar36接口地址6adddatedatatime添加时间7updatedatedatatime修改时间8usernamevarchar36用户名9passwordvarchar36密码10connectionpoolvarchar36连接池11activitynumbervarchar36最大活动数12remarkvarchar100备注物料表：（tak_ gree_materiel）接口（格力）序号列名数据类型长度键对应字段说明1idint20是2materielkeynvarchar200PARTCODE物料主键ID3materielcodenvarchar100DESCRIPTION物料编码4materielnamenvarchar400PARTNAME物料名称5isactiveint1ENABLED是否激活6categoryidint10外键CATEGORYID类别7unitint10UNITID单位8ischeckint1ISCHECK是否检查9ismlotint1ISMLOT是否（MLOT）环保10maxstockint18MAXQUANTITY最大存量11minstockint18MINQUANTITY最小存量12priceint18UNITPRICE单价13createtimedatetime6CREATETIME创建时间14updatetimedatetime6UPDATETIME更新时间15currencynvarchar100PURCHASECURRENCY购买货币16materieltypeidint10外键PARTTYPEID物料类型ID17diagramnumbernvarchar400DIAGRAMNO图号18modelnvarchar60MODEL型号19signalsnvarchar30SIGNALCODE物料信号20isbatchcontrolint1ISCLOT是否批次控制21ispostpurchaseint1ISPOSTPURCHASE是否邮寄采购22topfloorcodenvarchar50DXCODE顶层码23isprintqcint1ISPRINTQCITEM是否打印QC项目24packpartidint10外键PACKPARTID散件打包ID（但是对应数据在PARKPART表中无记录）25purchaseidnvarchar30外键PURCHASERCODE采购业务员26remarkvarchar100备注采购订单表：（tak_ gree_purchaseorder）接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主键（自增）2orderkeyint10PURCHASEORDERID主键ID3odermumbernvarchar25PURCHASEORDERNO采购单编号4materielidint10是PARTID物料ID5orderdatedatetimeORDERDATE采购日期6orderdetailnumberint10PURCHASEORDERDETAILNO行号7orderdetailsequenceint10PURCHASEORDERDETAILSEQUENCE采购订单明细序号8odertotalquantitynumeric18,4ORDERQUANTITY订单数量总数量9dliveryquantitynumeric18,4DELIVERYQUANTITY交付数量10ordertypenvarchar30PURCHASEORDERTYPE采购单类型11orderstatenvarchar40PURCHASEORDERSTATE采购单状态12suppliernvarchar50SUPPLIER供应商13rceivequantitynumeric18,4RECEIVEDQUANTITY收货数量14returnquantitynumeric18,4RETURNEDQUANTITY送回数量15otherreturnquantitynumeric18,4OTHERRETURNEDQUANTITY其他送回数量16depositfeenvarchar6A10A08寄存费寄存17plandeliverytimedatetimePLANNEDRECEIVEDATE计划收货时间18remarkvarchar100备注生产订单: （tak_ gree_productorder）接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主键（自增）2orderkeyint10PRODUCTIONORDERID生产订单ID3ordernumbernvarchar50PRODUCTIONORDERNO生产订单编号4materielidint10是PARTID物料ID5ordertypeidint10是PRODUCTIONORDERTYPEID订单类型ID6orderstateidint10是PRODUCTIONORDERSTATEID订单状态ID7priorityidint10是PRIORITYID优先级ID8createdatedatetime6CREATEDDATE创建时间9creatoridint10是CREATEDBYID创建者ID10releaseddatedatetime6RELEASEDDATE释放时间11releaseridint10是RELEASEDBYID释放者ID12planstartdatedatetime6PLANNEDSTARTDATE计划开始时间13planenddatedatetime6PLANNEDENDDATE计划结束时间14actualstartdatedatetime6ACTUALSTARTDATE实际开始时间15actualenddatedatetime6ACTUALENDDATE实际结束时间16ordertotalint18ORDERQUANTITY订单（订货）数量17finishedquantityint18FINISHEDQUANTITY完成数量18unitidint10是UNITID工作单元ID19worksiteidint10是WORKSITEID分厂ID20saveorderstateidint10是SAVEDPRODUCTIONORDERSTATEID保存的生产状态订单状态ID21issuequantityint18LAUNCHEDQUANTITY发出数量22remarknvarchar600REMARK标记,备注23sequencenumbernvarchar50SEQUENCENUMBER序列号24customerfilenumbernvarchar200CUSTOMERDOCUMENTNO顾客文件编号25rohsint1ROHS（环保物料）26workcenteridint18是WORKCENTERID工作中心ID（产线）27custproductnumbernvarchar50CUSTOMERLOTNO顾客生产编号28requirdatedatetime6REQUIREDATE必须要求时间29bulkinfonvarchar50BULKINFO估计是都是散件订单30detailcodenvarchar50MXCODE明细码31topfloorcodenvarchar50DXCODE顶层码32tmcodenvarchar20TMCODETMCODE33scpcnvarchar20SCPCSCPC34customertypenvarchar160CUSTOMERTYPENAME顾客类型名35startproductquantityint18STARTUPQUANTITY启动生产数量36pauseproductquantityint18SUSPENDQUANTITY暂停生产数量37reproductquantityint18REENTERQUANTITY重入生产数量38itemnumbernvarchar50ITEMNO项目编号39productionmodelnvarchar80PRODUCTIONMODEL机器类型（(外)内联机(物料)）40customercodenvarchar50CUSTOMERCODECUSTOMERCODE41ejjxsnvarchar50EJJXS工艺设置42pinpnvarchar60PINP工艺设置43remark1varchar100备注供应商表：（tak_ gree_supplier）接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主键（自增）2supplierkeyint10ENTERPRISEIDID3suppliercodevarchar36ENTERPRISENAME厂家编码4descriptionvarchar100DESCRIPTION描述5suppliertypevarchar36ENTERPRISETYPEID企业类型6remarkvarchar100备注物料类型（tak_ gree_materieltype）接口（格力）序号列名数据类型长度主键外键允许空说明1idint20是主键（自增）2materieltypekeyvarchar36物料类型ID3materieltypenamevarchar36物料类型名4remarkvarchar100备注拣选单表（tak_ gree_pickingorders）接口序号列名数据类型长度主键外键对应字段说明1idint20是主键（自增）2picknumberkeynvarchar20JXNO拣选单号3timezoneint1SQNO时区(白班，晚班)4timezonestartdatetimeSTDT时区起始时间5timezoneenddatetimeENDT时区结束时间6productionlinenvarchar6CWOC产线7warehouseclerknvarchar20CKGL仓库员8distributionareanvarchar50PSQY配送区域9pickidint1ID拣选单主键10pickdatedatetimeJX_DATE拣选时间11technologicalprocessnvarchar10OPRO工艺流程12pickingmethodint1JXFS拣选方式13ordernumbernvarchar20PDNO订单号14workingprocedureint1OPNO工序15remarkvarchar100备注16packagearea varchar 100 拆包区域 17balanceint1物料余额18pickstateint1拣选状态拣选单明细表（tak_ gree_pickingordersdetail）接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主键（自增）2picknumberkeynvarchar20是JXNO拣选单号3picklinenumberint10JXPO拣选单行号4productnumbernvarchar15PDNO生产订单5linenumberint10PONO行号6processint10OPNO工序7timezoneint10SQNO时区8timezonestartdatetime10STDT时区起始时间9timezoneenddatetime10ENDT时区结束时间10productionlinenvarchar10CWOC产线11demandquantityint10SQSL需求数量12pickquantityint10JXSL拣选数量13allotmentquantityint10PFSL配发数量14suppliernvarchar10SUNO供应商15commonmodenvarchar50GMGY共模16pickstateint1JXZT拣选状态17ordersdetailidint10ID主键18materielcodenvarchar50ITEM物料代码19pickdatedatetimeJX_DATE拣选日期20orderdemanddatedatetimeXQDT订单需求时间21virtualsendquantityint10XNFL虚拟发料数量22orderstartdatedatetimeSTPN订单开始时间23orderenddatedatetimeENPN订单结束时间24pickreturnmaterielint10TLSL拣选退料25productmodelnvarchar50CTPY产品机型26remarknvarchar200REMARK备注/补料原因27sendreturnmaterielint10PSTL配送退料28printnumberint10PRINT_TIME打印次数29sendpersonnelnvarchar50PSRY配送人员30materielmatchingint10WLPB物料配比31materielgroupnvarchar50WLFS物料组32processflownvarchar10OPRO工艺流程33pickmodeint1JXFS拣选方式34ispreloadint1SFYZ是否预装物料35updatedatedatetimeUPDATE_DATE更新时间36picksummarynvarchar20HZJXNO汇总拣选单号37returnmaternumbernvarchar20TLNO退料单号38ismpint1SFMP是否MP39webremarkvarchar100备注配送单表（tak_ gree_distribution）接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主键（自增）2distributionkeyint1ID配送单主键3odrdernumbernvarchar20PSNO配送单号4distributionzonenvarchar20PSQY配送区域5productordernvarchar100PDNO生产订单号6productclassnvarchar50CPPS成品分类7distributiondatedatetimeSGSL配送时间8sendpersonnelnvarchar50PSRY配送员9pickmodeint1JXFS拣选方式10createdatedatetimeCREATE_TIME创建时间11supplierkeynvarchar50SUNO供应商编号12ismpint1SFMP是否13productionlinenvarchar50CWOC产线14timezonekeyint1SQNO时区编号15pickdatedatetimeJX_DATE拣选日期16commonmodenvarchar50GMGY共模17remarkvarchar100备注18distributionstateint配送状态配送单明细表（tak_ gree_distributiondetail）接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主键（自增）2detailkeyint1ID主键3distributionnumbernvarchar20是PSNO配送单号4distributionlineint1PSPO配送行号5productordernvarchar100PDNO生产订单6materielnvarchar50ITEM物料7materielclassnvarchar50WLPS物料类型8pickmodenvarchar50FJFS分拣方式9containernvarchar50BZRQ定容器10mincapacityint18MINRL最小容量11maxcapacityint18MAXRL最大容量12allotmentint18PFSL配发数量(已配送)13distributionstateint1PSZT配送状态14targetdatabasenvarchar36MBKW目标库位15returnquantityint1TLSL退料数量16printnumberint1PRINT_TIME打印次数17updatedatedatetimeUPD_DATE更新时间18updateuserint1UPD_USER更新人19supplierkeyint1SUNO供应商编号20pickordernumbernvarchar20JXNO拣选单号21remarknvarchar50REMARK备注物料组信息（tak_ gree_materielgroup）接口（格力）序号列名数据类型长度主键允许空说明1idint20是主键（自增）2materielgroupkeyvarchar36物料组id3materielgroupnamevarchar36物料组名4remarkvarchar100备注供应商物料关联信息（tak_ gree_suppliertomateriel）序号列名数据类型长度主键外键对应字段说明1idint20是主键（自增）2materielidint10是PARTID物料ID3supplieidint10是ENTERPRISE供应商ID4isjitint1ISJIT是否是JIT物料5isdepositint1ISCONSIGNMENT是否是寄存6ischeckint1ISCHECK是否检查7quotanumeric18,4QUOTA定额8isfrozenint1ISFREEZE是否冻结9remarknvarchar255REMARKS备注10effectivedatedatetimeEFFECTIVEDATE有效期11enddatedatetimeEXPIRATIONDATE截止日期12remark1varchar100备注1分厂信息表（tak_ gree_factory）-接口（格力）序号列名数据类型长度主键外键允许空说明1idint20是主键（自增）2factorykeyvarchar36分厂主键3factorynamevarchar100分厂名4remarkvarchar100备注工作单元信息(tak_ gree_unitwork): -接口（格力）序号列名数据类型长度主键外键允许空说明1idint20是主键（自增）2unitworkkeyvarchar36工作单元主键3unitworknamevarchar36工作单元名4remarkvarchar100备注优先级信息（tak_ gree_priority）-接口（格力）序号列名数据类型长度主键外键允许空说明1idint20是主键（自增）2prioritykeyvarchar36优先级主键3prioritynamevarchar36优先级名称4remarkvarchar100备注注:该表格力不同步接口或平台自己维护产品机型(tak_ gree_producttype) -接口（格力）序号列名数据类型长度主键外键允许空说明1idint20是主键（自增）2producttypekeyvarchar36机型名主键3producttypenamevarchar36机型名4remarkvarchar100备注新增加的表（退货表及明细表，退(补)料领料表及明细表）退料表（tak_gree_returnedmaterial）-接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主键（自增）2returnedmaterialidint10RETURNEDMATERIALID主键ID3returnedmaterialnonvarchar25RETURNEDMATERIALNO编号4sourcesiteidint10是SOURCESITEID源工作位置5createdbyidint10是CREATEDBYID创建人ID6createddatedatetimeCREATEDDATE创建时间7executedbyidint10是EXECUTEDBYID执行人ID8executeddatedatetimeEXECUTEDDATE执行时间9remarksnvarchar255REMARKS备注10stateidint10是STATEID状态ID下发、执行、完成0、1、211actiondatedatetimeACTIONDATE行动时间12actionbyidint10是ACTIONBYID行动人ID13typeidint10是TYPEID退料/补/领类型(0退1补2领)14attributecodenvarchar2ATTRIBUTECODE(属性编码）15qualifiedint1qualified物料属性(合格与否)16fedorreturnint1Fedorreturn是退料还是补料退料明细表（tak_gree_returnmaterdetail）-接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主键(自增)2returnmaterdetailidint10RETURNEDMATERIALDETAILID主键ID3returnedmaterialidint10是RETURNEDMATERIALID返回材料ID4sourcemlotidint10是SOURCEMLOTID源物料批次ID5destinationmlotidint10是DESTINATIONMLOTID目标物料批次ID6plannedquantitynumeric18,4PLANNEDQUANTITY计划数量7actualquantitynumeric18,4ACTUALQUANTITY实际数量8remarksnvarchar255REMARKS备注9destinationequipidint10是DESTINATIONEQUIPMENTID目的库位ID10mlotinvenvariationidint10是MLOTINVENTORYVARIATIONID物料批次清单ID11stateidint10是STATEID状态ID12sourceequipmentidint10SOURCEEQUIPMENTID原库位ID13aloao8nvarchar10A10A08寄存非寄存物料14sourceanvarchar10SOURCEA10A08变化之前寄存非寄存状态15mlothistoryinforidint10MLOTHISTORYINFORID物料批次历史信息16createdbyidint18CREATEDBYID创建人ID17createdatedatetimeCREATEDDATE创建时间18productbatchnvarchar10ProductBatch批次号退货表（tak_gree_returngoods）-接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主键(自增)2returngoodsidint10RETURNGOOdsID主键ID3returngoodsnonvarchar25RETURNGOOdsnumber编号4createdbyi