1、接口数据库结构字典说明教材基础数据表接口接口表:(tak_gree_interface)接口序号列名数据类型长度主键外键允许空说明1 idint20是主键(自增)2 interfacenamevarchar36接口名称3 descriptionvarchar36接口描述4 interfacetypevarchar36接口类型5 interurlvarchar36接口地址6 adddatedatatime添加时间7 updatedatedatatime修改时间8 usernamevarchar36用户名9 passwordvarchar36密码10 connectionpoolvarchar36
2、连接池11 activitynumbervarchar36最大活动数12 remarkvarchar100备注物料表:(tak_ gree_materiel)接口(格力)序号列名数据类型长度键对应字段说明1 idint20是2 materielkeynvarchar200PARTCODE物料主键ID3 materielcodenvarchar100DESCRIPTION物料编码4 materielnamenvarchar400PARTNAME物料名称5 isactiveint1ENABLED是否激活6 categoryidint10外键CATEGORYID类别7 unitint10UNITID
3、单位8 ischeckint1ISCHECK是否检查9 ismlotint1ISMLOT是否(MLOT)环保10 maxstockint18MAXQUANTITY最大存量11 minstockint18MINQUANTITY最小存量12 priceint18UNITPRICE单价13 createtimedatetime6CREATETIME创建时间14 updatetimedatetime6UPDATETIME更新时间15 currencynvarchar100PURCHASECURRENCY购买货币16 materieltypeidint10外键PARTTYPEID物料类型ID17 dia
4、gramnumbernvarchar400DIAGRAMNO图号18 modelnvarchar60MODEL型号19 signalsnvarchar30SIGNALCODE物料信号20 isbatchcontrolint1ISCLOT是否批次控制21 ispostpurchaseint1ISPOSTPURCHASE是否邮寄采购22 topfloorcodenvarchar50DXCODE顶层码23 isprintqcint1ISPRINTQCITEM是否打印QC项目24 packpartidint10外键PACKPARTID散件打包ID(但是对应数据在PARKPART表中无记录)25 pur
5、chaseidnvarchar30外键PURCHASERCODE采购业务员26 remarkvarchar100备注采购订单表:(tak_ gree_purchaseorder)接口(格力)序号列名数据类型长度主键外键对应字段说明1 idint20是主键(自增)2 orderkeyint10PURCHASEORDERID主键ID3 odermumbernvarchar25PURCHASEORDERNO采购单编号4 materielidint10是PARTID物料ID5 orderdatedatetimeORDERDATE采购日期6 orderdetailnumberint10PURCHASEO
6、RDERDETAILNO行号7 orderdetailsequenceint10PURCHASEORDERDETAILSEQUENCE采购订单明细序号8 odertotalquantitynumeric18,4ORDERQUANTITY订单数量总数量9 dliveryquantitynumeric18,4DELIVERYQUANTITY交付数量10 ordertypenvarchar30PURCHASEORDERTYPE采购单类型11 orderstatenvarchar40PURCHASEORDERSTATE采购单状态12 suppliernvarchar50SUPPLIER供应商13 rc
7、eivequantitynumeric18,4RECEIVEDQUANTITY收货数量14 returnquantitynumeric18,4RETURNEDQUANTITY送回数量15 otherreturnquantitynumeric18,4OTHERRETURNEDQUANTITY其他送回数量16 depositfeenvarchar6A10A08寄存费寄存17 plandeliverytimedatetimePLANNEDRECEIVEDATE计划收货时间18 remarkvarchar100备注生产订单: (tak_ gree_productorder)接口(格力)序号列名数据类型
8、长度主键外键对应字段说明1 idint20是主键(自增)2 orderkeyint10PRODUCTIONORDERID生产订单ID3 ordernumbernvarchar50PRODUCTIONORDERNO生产订单编号4 materielidint10是PARTID物料ID5 ordertypeidint10是PRODUCTIONORDERTYPEID订单类型ID6 orderstateidint10是PRODUCTIONORDERSTATEID订单状态ID7 priorityidint10是PRIORITYID优先级ID8 createdatedatetime6CREATEDDATE创
9、建时间9 creatoridint10是CREATEDBYID创建者ID10 releaseddatedatetime6RELEASEDDATE释放时间11 releaseridint10是RELEASEDBYID释放者ID12 planstartdatedatetime6PLANNEDSTARTDATE计划开始时间13 planenddatedatetime6PLANNEDENDDATE计划结束时间14 actualstartdatedatetime6ACTUALSTARTDATE实际开始时间15 actualenddatedatetime6ACTUALENDDATE实际结束时间16 ord
10、ertotalint18ORDERQUANTITY订单(订货)数量17 finishedquantityint18FINISHEDQUANTITY完成数量18 unitidint10是UNITID工作单元ID19 worksiteidint10是WORKSITEID分厂ID20 saveorderstateidint10是SAVEDPRODUCTIONORDERSTATEID保存的生产状态订单状态ID21 issuequantityint18LAUNCHEDQUANTITY发出数量22 remarknvarchar600REMARK标记,备注23 sequencenumbernvarchar5
11、0SEQUENCENUMBER序列号24 customerfilenumbernvarchar200CUSTOMERDOCUMENTNO顾客文件编号25 rohsint1ROHS(环保物料)26 workcenteridint18是WORKCENTERID工作中心ID(产线)27 custproductnumbernvarchar50CUSTOMERLOTNO顾客生产编号28 requirdatedatetime6REQUIREDATE必须要求时间29 bulkinfonvarchar50BULKINFO估计是都是散件订单30 detailcodenvarchar50MXCODE明细码31 t
12、opfloorcodenvarchar50DXCODE顶层码32 tmcodenvarchar20TMCODETMCODE33 scpcnvarchar20SCPCSCPC34 customertypenvarchar160CUSTOMERTYPENAME顾客类型名35 startproductquantityint18STARTUPQUANTITY启动生产数量36 pauseproductquantityint18SUSPENDQUANTITY暂停生产数量37 reproductquantityint18REENTERQUANTITY重入生产数量38 itemnumbernvarchar50
13、ITEMNO项目编号39 productionmodelnvarchar80PRODUCTIONMODEL机器类型((外)内联机(物料))40 customercodenvarchar50CUSTOMERCODECUSTOMERCODE41 ejjxsnvarchar50EJJXS工艺设置42 pinpnvarchar60PINP工艺设置43 remark1varchar100备注供应商表:(tak_ gree_supplier)接口(格力)序号列名数据类型长度主键外键对应字段说明1 idint20是主键(自增)2 supplierkeyint10ENTERPRISEIDID3 supplie
14、rcodevarchar36ENTERPRISENAME厂家编码4 descriptionvarchar100DESCRIPTION描述5 suppliertypevarchar36ENTERPRISETYPEID企业类型6 remarkvarchar100备注物料类型(tak_ gree_materieltype)接口(格力)序号列名数据类型长度主键外键允许空说明1 idint20是主键(自增)2 materieltypekeyvarchar36物料类型ID3 materieltypenamevarchar36物料类型名4 remarkvarchar100备注拣选单表(tak_ gree_p
15、ickingorders)接口序号列名数据类型长度主键外键对应字段说明1 idint20是主键(自增)2 picknumberkeynvarchar20JXNO拣选单号3 timezoneint1SQNO时区(白班,晚班)4 timezonestartdatetimeSTDT时区起始时间5 timezoneenddatetimeENDT时区结束时间6 productionlinenvarchar6CWOC产线7 warehouseclerknvarchar20CKGL仓库员8 distributionareanvarchar50PSQY配送区域9 pickidint1ID拣选单主键10 pic
16、kdatedatetimeJX_DATE拣选时间11 technologicalprocessnvarchar10OPRO工艺流程12 pickingmethodint1JXFS拣选方式13 ordernumbernvarchar20PDNO订单号14 workingprocedureint1OPNO工序15 remarkvarchar100备注16 packagearea varchar 100 拆包区域 17 balanceint1物料余额18 pickstateint1拣选状态拣选单明细表(tak_ gree_pickingordersdetail)接口(格力)序号列名数据类型长度主键外
17、键对应字段说明1 idint20是主键(自增)2 picknumberkeynvarchar20是JXNO拣选单号3 picklinenumberint10JXPO拣选单行号4 productnumbernvarchar15PDNO生产订单5 linenumberint10PONO行号6 processint10OPNO工序7 timezoneint10SQNO时区8 timezonestartdatetime10STDT时区起始时间9 timezoneenddatetime10ENDT时区结束时间10 productionlinenvarchar10CWOC产线11 demandquanti
18、tyint10SQSL需求数量12 pickquantityint10JXSL拣选数量13 allotmentquantityint10PFSL配发数量14 suppliernvarchar10SUNO供应商15 commonmodenvarchar50GMGY共模16 pickstateint1JXZT拣选状态17 ordersdetailidint10ID主键18 materielcodenvarchar50ITEM物料代码19 pickdatedatetimeJX_DATE拣选日期20 orderdemanddatedatetimeXQDT订单需求时间21 virtualsendquan
19、tityint10XNFL虚拟发料数量22 orderstartdatedatetimeSTPN订单开始时间23 orderenddatedatetimeENPN订单结束时间24 pickreturnmaterielint10TLSL拣选退料25 productmodelnvarchar50CTPY产品机型26 remarknvarchar200REMARK备注/补料原因27 sendreturnmaterielint10PSTL配送退料28 printnumberint10PRINT_TIME打印次数29 sendpersonnelnvarchar50PSRY配送人员30 materielm
20、atchingint10WLPB物料配比31 materielgroupnvarchar50WLFS物料组32 processflownvarchar10OPRO工艺流程33 pickmodeint1JXFS拣选方式34 ispreloadint1SFYZ是否预装物料35 updatedatedatetimeUPDATE_DATE更新时间36 picksummarynvarchar20HZJXNO汇总拣选单号37 returnmaternumbernvarchar20TLNO退料单号38 ismpint1SFMP是否MP39 webremarkvarchar100备注配送单表(tak_ gre
21、e_distribution)接口(格力)序号列名数据类型长度主键外键对应字段说明1 idint20是主键(自增)2 distributionkeyint1ID配送单主键3 odrdernumbernvarchar20PSNO配送单号4 distributionzonenvarchar20PSQY配送区域5 productordernvarchar100PDNO生产订单号6 productclassnvarchar50CPPS成品分类7 distributiondatedatetimeSGSL配送时间8 sendpersonnelnvarchar50PSRY配送员9 pickmodeint1J
22、XFS拣选方式10 createdatedatetimeCREATE_TIME创建时间11 supplierkeynvarchar50SUNO供应商编号12 ismpint1SFMP是否13 productionlinenvarchar50CWOC产线14 timezonekeyint1SQNO时区编号15 pickdatedatetimeJX_DATE拣选日期16 commonmodenvarchar50GMGY共模17 remarkvarchar100备注18 distributionstateint配送状态配送单明细表(tak_ gree_distributiondetail)接口(格力)序号列名数据类型长度主键外键对应字段说明1 idint20是主键(自增)2 detailkeyint1