接口数据库结构字典说明

《接口数据库结构字典说明》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、基础数据表接口接口表：(takgreeinterface)—接口序号列名数据类型长度主键外键允许空说明1idint20是主键(自増)2interfacenamevarchar36接口名称3descriptionvarchar36接口描述4intcrfacctypcvarchar36接口类型5interurlvarchar36接口地址6adddatedatatime添加时间7updatedatedatatime條改时间8usernamevarchar36用户名9passwordvarchar36密码10c

2、onnectionpoolvarchar36连接池11activitynumbervarcha『36最大活动数12remarkvarchar100备注物料表:(takgreemateriel)—接口(格力)序号列名数据类型长度键对应字段说明1idint20是2materielkeynvarchar200PARTCODE物料主键ID3malerielcodenvarchar100DESCRIPTION物料编码4materielnamenvarchar400PARTNAME物料名称5isactivcint1

3、ENABLED是否澈活6categoryidint10外键CATEGORYID类别7unitint10UNITID单位8ischeckint1ISCHECK是否检査9ismlotint1ISMLOT是否(MLOT)环保10maxstockint18MAXQUANTITY最大存量11minstockint18MINQUANTITY垠小存量12priceint18UNITPRICE单价13createtimedatetime6CREATETIME创建时间14updatctimcdatetime6UPDATE

4、TIME更新时间15currencynvarchar100PURCHASECURRENCY购买货币16materieltypeidint10外键PARTTYPEID物料类型ID17diagramnumbernvarchar400DIAGRAMNO图号18modelnvarchar60MODEL型号19signalsnvarchar30SIGNALCODE物料信号20isbatchcontrolint1ISCLOT是否批次控制21ispostpurchaseint1ISPOSTPURCHASE是否邮寄采购

5、22loplloorcodenvarchar50DXCODE顶层码23isprintqcint1ISPRINTQCITEM是否打印QC项目24packpartidint10外键PACKPARTID散件打包ID（但是对应数据在PARKPART表中无记录〉25purchaseidnvarchar30外键PIJRCHASERCODE采购业务员26remarkvarchar100备注采购订单表：（takgreepurchaseorder）—接口（格力）序号列名数据类型长度主键外键对应字段说明1idint20是主

6、键（自增）2orderkeyint10PURCHASEORDERID主键ID3odermumbernvarchar25PURCHASEORDERNO采购单编号4matcriclidint10是PART1D物料ID5orderdatedatetimeORDERDATE采购日期6orderdetailnumberint10PURCHASEORDERDETAILNO行号7orderdetailsequenceint10PURCHASEORDERDETAII,SEQUENCE采购订单明细序号8odertotal

7、quantitynumeric1&4ORDERQUANTITY订单数量总数虽9dliveryquantitynumeric1&4DELIVERYQUANTITY交付数虽10ordertypenviirchar30PURCHASEORDERTYPE采购单类型11orderstatenvarchar40PURCHASEORDERSTATE采购单状态12suppliernvarchar50SUPPLIER供应商13rceivequantitynumeric1&4RECEIVEDQUANTITY收货数fit14

8、returnquantitynumeric1&4RETURNEDQUANTITY送回数量15otherreturnquantitynumeric1&4OTHERRETURNEDQl；ANTITY其他送回数量16depositfeenvarchiir6A10A08寄存费寄存17plandeliverytimedatetimePLANNEDRECEIVEDATE讣划收货时间18remarkvarchar100备注生产订单：（takgreepro