/
搜索到
299
篇与
的结果
-
深信服AF &锐捷 OID表 一、深信服AF OID1. 找出要监控项目的SNMP字符串（或OID）。要获取SNMP字符串列表，请使用 snmpwalk 命令（net-snmp的部分软件应该在Zabbix安装时同时安装）或等效工具：shell> snmpwalk -v 2c -c public <host IP> .这里的'2c'代表SNMP版本，你也可以将其替换为'1'，以在设备上指定SNMP版本为v1。它会返回给你一个SNMP字符串及其最后一个值的列表。如果不是，那么SNMP 'community' 可能与标准的'public'不同，在这种情况下，请找出它是什么。然后，你可以浏览列表，直到找到要监控的字符串，例如：如果要监视通过端口3进入交换机的字节，你将使用此行中的IF-MIB :: ifInOctets.3字符串：IF-MIB::ifInOctets.3 = Counter32: 3409739121你现在可以使用 snmpget 命令找出'IF-MIB :: ifInOctets.3'的数字OID：shell> snmpget -v 2c -c public -On 10.62.1.22 IF-MIB::ifInOctets.3请注意，字符串中的最后一个数字是你要监控的端口号。请参考: 动态索引.如下所示：.1.3.6.1.2.1.2.2.1.10.3 = Counter32: 3472126941重复一遍，OID中的最后一个号码是端口号。3COM似乎是使用数百个端口号，例如 端口1=端口101，端口3=端口103，但思科使用常规数字，例如。 端口3=3。一些最常用的SNMP OID，Zabbix将自动转换为数字表示。在上面的例子中，值类型是“Counter32”它在内部对应于ASN_COUNTER类型。完整的支持类型包括 ASN_COUNTER, ASN_COUNTER64, ASN_UINTEGER, ASN_UNSIGNED64, ASN_INTEGER, ASN_INTEGER64, ASN_FLOAT, ASN_DOUBLE, ASN_TIMETICKS, ASN_GAUGE, ASN_IPADDRESS, ASN_OCTET_STR 和 ASN_OBJECT_ID (从2.2.8, 2.4.3之后). 这些类型大致对应于snmpget 输出的 "Counter32", "Counter64", "UInteger32", "INTEGER", "Float", "Double", "Timeticks", "Gauge32", "IpAddress", "OCTET STRING", "OBJECT IDENTIFIER", 但也有可能显示为 "STRING", "Hex-STRING", "OID" 或者其它, 这取这取决于显示提示的表达方式。MIBDescriptionOIDSNMPv2-MIB::sysDescr.0系统描述.1.3.6.1.2.1.1.1.0SNMPv2-MIB::sysContact.0联系.1.3.6.1.2.1.1.4.0SNMPv2-MIB::sysName.0系统名.1.3.6.1.2.1.1.5.0SNMPv2-MIB::sysLocation.0位置.1.3.6.1.2.1.1.6.0SNMPv2-MIB::sysServices.0系统服务.1.3.6.1.2.1.1.7.0SNMPv2-MIB::sysConnNum.0连接数.1.3.6.1.2.1.1.10.0SNMPv2-MIB::sysCpuUsage.0cpu占用率.1.3.6.1.2.1.1.11.0SNMPv2-MIB::sysMemUsage.0内存占用率.1.3.6.1.2.1.1.12.0SNMPv2-MIB::sysDiskUsage.0磁盘占用率.1.3.6.1.2.1.1.13.0HOST-RESOURCES-MIB::hrSystemDate.0系统日期.1.3.6.1.2.1.25.1.2.0HOST-RESOURCES-MIB::hrSystemUptime.0运行的时间.1.3.6.1.2.1.25.1.1.0SNMPv2-MIB::sysDescrFull.0系统信息.1.3.6.1.2.1.1.15.0系统信息NameDescriptionOIDhrSystemUptime运行的时间.1.3.6.1.2.1.25.1.1hrSystemDate系统日期.1.3.6.1.2.1.25.1.2hrSystemNumUsers用户数.1.3.6.1.2.1.25.1.5hrSystemProcesses进程数.1.3.6.1.2.1.25.1.6hrSystemMaxProcesses最大进程数.1.3.6.1.2.1.25.1.7HOST-RESOURCES-MIB::hrMemorySize.0系统内存.1.3.6.1.2.1.25.2.2hrStorageTable存储设备信息表（内存，磁盘的使用情况）.1.3.6.1.2.1.25.2.3hrDeviceTable系统设备列表.1.3.6.1.2.1.25.3.2hrSWRunTable系统进程列表.1.3.6.1.2.1.25.4.2CPUNameDescriptionOIDUCD-SNMP-MIB::ssCpuUser用户使用CPU情况.1.3.6.1.4.1.2021.11.9.0UCD-SNMP-MIB::ssCpuSystem.0系统使用CPU情况.1.3.6.1.4.1.2021.11.10.0UCD-SNMP-MIB::ssCpuIdle.0空闲CPU.1.3.6.1.4.1.2021.11.11.0SNMPv2-MIB::sysCpuUsage.0cpu占用率.1.3.6.1.2.1.1.11.0内存NameDescriptionOIDmemTotalSwap总swap分区.1.3.6.1.4.1.2021.4.3memAvailSwap可用swap分区.1.3.6.1.4.1.2021.4.4memTotalReal内存总量(真实内存）.1.3.6.1.4.1.2021.4.5memAvailReal可用内存(真实内存）.1.3.6.1.4.1.2021.4.6memTotalFree可用内存（真实内存+虚拟内存）.1.3.6.1.4.1.2021.4.11memShared共享内存数量.1.3.6.1.4.1.2021.4.13memBufferbuffer内存数量.1.3.6.1.4.1.2021.4.14memCachedCache内存数量.1.3.6.1.4.1.2021.4.15hrMemorySize内存总量.1.3.6.1.2.1.25.2.2hrStorageTable存储设备信息表（内存，磁盘）.1.3.6.1.2.1.25.2.3硬盘NameDescriptionOIDsysDiskUsage磁盘占用率.1.3.6.1.2.1.1.13hrStorageTable存储设备信息表（内存，磁盘）.1.3.6.1.2.1.25.2.3网口NameDescriptionOIDifNumber接口总数.1.3.6.1.2.1.2.1ifTable接口表（接口名，开启状态，MAC，出口流量，入口流量等）.1.3.6.1.2.1.2.2ifIndex索引.1.3.6.1.2.1.2.2.1.1ifName网口.1.3.6.1.2.1.2.2.1.2ifType接口类型.1.3.6.1.2.1.2.2.1.3ifMtu接口MTU.1.3.6.1.2.1.2.2.1.4ifPhysAddress接口mac地址.1.3.6.1.2.1.2.2.1.6ifAdminStatus所希望的接口工作状态.1.3.6.1.2.1.2.2.1.7ifOperStatus当前接口工作状态.1.3.6.1.2.1.2.2.1.8ifInOctets接口收到的字节总数.1.3.6.1.2.1.2.2.1.10ifOutOctets接口发送的字节总数.1.3.6.1.2.1.2.2.1.16地址转换表NameDescriptionOIDatTable地址转换表.1.3.6.1.2.1.3.1IPNameDescriptionOIDipForwarding是否作为一个IP网关.1.3.6.1.2.1.4.1ipDefaultTTLIP头中的Time To Live字段的值.1.3.6.1.2.1.4.2ipInReceivesIP层从下层接收的数据报总数.1.3.6.1.2.1.4.3ipInHdrErrors由于IP头出错而丢弃的数据报.1.3.6.1.2.1.4.4ipInAddrErrors地址出错（无效地址、不支持的地址和非本地主机地址）的数据报.1.3.6.1.2.1.4.5ipForwDatagrams已转发的数据报.1.3.6.1.2.1.4.6ipInUnknownProtos不支持数据报的协议，因而被丢弃.1.3.6.1.2.1.4.7ipInDiscards因缺乏缓冲资源而丢弃的数据报.1.3.6.1.2.1.4.8ipInDelivers由IP层提交给上层的数据报.1.3.6.1.2.1.4.9ipOutRequests由IP层交给下层需要发送的数据报，不包括ipForwDatagrams.1.3.6.1.2.1.4.10ipOutDiscards在输出端因缺乏缓冲资源而丢弃的数据报.1.3.6.1.2.1.4.11ipOutNoRoutes没有到达目标的路由而丢弃的数据报.1.3.6.1.2.1.4.12ipReasmTimeout数据段等待重装配的最长时间（秒）.1.3.6.1.2.1.4.13ipReasmReqds需要重装配的数据段.1.3.6.1.2.1.4.14ipReasmOKs成功重装配的数据段.1.3.6.1.2.1.4.15ipReasmFails不能重装配的数据段.1.3.6.1.2.1.4.16ipFragOKs分段成功的数据段.1.3.6.1.2.1.4.17ipFragFails不能分段的数据段.1.3.6.1.2.1.4.18ipFragCreates产生的数据报分段数.1.3.6.1.2.1.4.19ipAddrTableIP地址表.1.3.6.1.2.1.4.20ipRouteTableIP路由表.1.3.6.1.2.1.4.21ipNetToMediaTableIP与物理地址转换表.1.3.6.1.2.1.4.22ipRoutingDiscards无效的路由项，包括为释放缓冲空间而丢弃路由项.1.3.6.1.2.1.4.23TCPNameDescriptionOIDtcpRtoAlgorithm重传时间算法.1.3.6.1.2.1.6.1tcpRtoMin重传时间最小值.1.3.6.1.2.1.6.2tcpRtoMax重传时间最大值.1.3.6.1.2.1.6.3tcpMaxConn可建立的最大连接数.1.3.6.1.2.1.6.4tcpActiveOpens主动打开的连接数.1.3.6.1.2.1.6.5tcpPassiveOpens被动打开的连接数.1.3.6.1.2.1.6.6tcpAttemptFails连接建立失败数.1.3.6.1.2.1.6.7tcpEstabResets连接复位数.1.3.6.1.2.1.6.8tcpCurrEstab状态为established或closeWait的连接数.1.3.6.1.2.1.6.9tcpInSegs接收的TCP段总数.1.3.6.1.2.1.6.10tcpOutSegs发送的TCP段总数.1.3.6.1.2.1.6.11tcpRetransSegs重传的TCP段总数.1.3.6.1.2.1.6.12tcpConnTable连接表.1.3.6.1.2.1.6.13tcpInErrors接收的出错TCP段数.1.3.6.1.2.1.6.14tcpOutRests发出的含RST标志的段数.1.3.6.1.2.1.6.15UDPName Description OIDudpInDatagrams 接收的数据报总数 .1.3.6.1.2.1.7.1udpNoPorts 没有发现端口而无法提交的数据报 .1.3.6.1.2.1.7.2udpInErrors 出错的数据报 .1.3.6.1.2.1.7.3udpOutDatagrams 上层协议要求输出的数据报 .1.3.6.1.2.1.7.4udpTable UDP表 .1.3.6.1.2.1.7.5SNMPNameDescriptionOIDsnmpInPktsSNMP模块接收到的分组数.1.3.6.1.2.1.11.1snmpInTotalReqVars被成功读取的Object数，包括get-request和get-next操作.1.3.6.1.2.1.11.13snmpInGetRequestsSNMP模块接收到并处理的get-request的分组数.1.3.6.1.2.1.11.15snmpInGetNextsSNMP模块接收到并处理的get-next的分组数.1.3.6.1.2.1.11.16snmpOutGetResponsesSNMP模块发出的get-responses的分组数.1.3.6.1.2.1.11.28snmpEnableAuthenTraps标记是否允许代理程序产生检验失败警告.1.3.6.1.2.1.11.30 -
-
Zabbix 搭配Grafana绘图 一、 安装Grafana1.1 下载wget https://dl.grafana.com/enterprise/release/grafana-enterprise-8.5.4-1.x86_64.rpm1.2 安装yum install grafana-enterprise-8.5.4-1.x86_64.rpm1.4 启动Grafanasystemctl start grafana-server.service systemctl enable grafana-server.service二、配置Grafana2.1 登录Grafana默认用户名密码为： adminhttp://IP:3000/login2.2 安装Zabbix插件2.3 配置Grafana数据源https:/Zabbix服务器IP地址/api_jsonrpc.php2.4 配置仪表盘三、配置NGINX代理grafana编辑 /etc/grafana/grafana.ini 文件 添加以下文件[server] domain = monitor.xxxxxx.com enforce_domain = true root_url = %(protocol)s://%(domain)s/grafana
-
Kingdee-采购管理-T_PUR_MRAPP-退料申请表 T_PUR_MRAPP表描述：退料申请表备注：退料申请信息主键字段名字段描述数据类型长度可空备注✓FID单据内码int 默认值:0null FBILLNO单据编号nvarchar30 默认值:''null FDATE日期datetime 默认值:getdate()null FBILLTYPEID单据类型varchar36 默认值:''null FSUPPLIERID供应商内码int 默认值:0null FRMTYPE退货类型varchar20✓默认值:''null FPURCHASEORGID采购组织int 默认值:0null FAPPORGID申请组织int 默认值:0null FAPPDEPTID申请部门int 默认值:0null FAPPLICANTID申请人int 默认值:0null FRMMODE退货方式varchar20 默认值:''A:补货退货 B:退货并退款 C:扣款不退货 FREPLENISHMODE补货方式varchar20 默认值:''A:按源单补货 B:创建补货订单 FRMREASON退货原因varchar36 默认值:''null FRMLOC退货地点nvarchar120 默认值:''null FDOCUMENTSTATUS单据状态char1 默认值:''A:新建 Z:暂存 B: 审核中 C: 已审核 D:重新审核 FDESCRIPTION描述nvarchar255 默认值:''null FCREATORID制单人int 默认值:0null FCREATEDATE制单日期datetime 默认值:getdate()null FMODIFIERID最近修改人内码int 默认值:0null FMODIFYDATE最新修改日期datetime ✓ FAPPROVERID审核人内码int 默认值:0null FAPPROVEDATE审核日期datetime ✓ FCANCELSTATUS作废状态char1 默认值:''A:未作废 B:已作废 FCANCELLERID作废人内码int 默认值:0null FCANCELDATE作废日期datetime ✓ FIsConvert是否是单据转换char1 默认值:'0'隐藏字段, 判断单据是否是下推或选单生成. FBUSINESSTYPE业务类型nvarchar20 默认值:''枚举:普通:CG委外:WW FOBJECTTYPEID业务对象类型varchar36 默认值:''null FREQUIREORGID需求组织携带int 默认值:0null FCorrespondOrgId对应组织int ✓默认值:0null FCONFIRMSTATUS确认状态char1 默认值:''null FCONFIRMERID确认人int 默认值:0null FCONFIRMDATE确认日期datetime ✓ FBILLTYPEIDVM协同虚拟单据类型varchar36 默认值:''null FCLOSERID关闭人int 默认值:0null FCLOSEDATE关闭日期datetime ✓ FCLOSESTATUS关闭状态char1 默认值:''null--建表脚本--create table T_PUR_MRAPP( FID int default 0 comment '单据内码' ,FBILLNO nvarchar(30) default '' comment '单据编号' ,FDATE datetime default getdate() comment '日期' ,FBILLTYPEID varchar(36) default '''' comment '单据类型' ,FSUPPLIERID int default 0 comment '供应商内码' ,FRMTYPE varchar(20) not null comment '退货类型' ,FPURCHASEORGID int default 0 comment '采购组织' ,FAPPORGID int default 0 comment '申请组织' ,FAPPDEPTID int default 0 comment '申请部门' ,FAPPLICANTID int default 0 comment '申请人' ,FRMMODE varchar(20) default '''' comment '退货方式' ,FREPLENISHMODE varchar(20) default '''' comment '补货方式' ,FRMREASON varchar(36) default '''' comment '退货原因' ,FRMLOC nvarchar(120) default '' comment '退货地点' ,FDOCUMENTSTATUS char(1) default '''' comment '单据状态' ,FDESCRIPTION nvarchar(255) default '' comment '描述' ,FCREATORID int default 0 comment '制单人' ,FCREATEDATE datetime default getdate() comment '制单日期' ,FMODIFIERID int default 0 comment '最近修改人内码' ,FMODIFYDATE datetime not null comment '最新修改日期' ,FAPPROVERID int default 0 comment '审核人内码' ,FAPPROVEDATE datetime not null comment '审核日期' ,FCANCELSTATUS char(1) default '''' comment '作废状态' ,FCANCELLERID int default 0 comment '作废人内码' ,FCANCELDATE datetime not null comment '作废日期' ,FIsConvert char(1) default ''0'' comment '是否是单据转换' ,FBUSINESSTYPE nvarchar(20) default '' comment '业务类型' ,FOBJECTTYPEID varchar(36) default '''' comment '业务对象类型' ,FREQUIREORGID int default 0 comment '需求组织携带' ,FCorrespondOrgId int not null comment '对应组织' ,FCONFIRMSTATUS char(1) default '''' comment '确认状态' ,FCONFIRMERID int default 0 comment '确认人' ,FCONFIRMDATE datetime not null comment '确认日期' ,FBILLTYPEIDVM varchar(36) default '''' comment '协同虚拟单据类型' ,FCLOSERID int default 0 comment '关闭人' ,FCLOSEDATE datetime not null comment '关闭日期' ,FCLOSESTATUS char(1) default '''' comment '关闭状态' ,primary key (FID) ) comment = '退料申请'--查询--select FID as "fid",FBILLNO as "fbillno",FDATE as "fdate",FBILLTYPEID as "fbilltypeid",FSUPPLIERID as "fsupplierid",FRMTYPE as "frmtype",FPURCHASEORGID as "fpurchaseorgid",FAPPORGID as "fapporgid",FAPPDEPTID as "fappdeptid",FAPPLICANTID as "fapplicantid",FRMMODE as "frmmode",FREPLENISHMODE as "freplenishmode",FRMREASON as "frmreason",FRMLOC as "frmloc",FDOCUMENTSTATUS as "fdocumentstatus",FDESCRIPTION as "fdescription",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAPPROVERID as "fapproverid",FAPPROVEDATE as "fapprovedate",FCANCELSTATUS as "fcancelstatus",FCANCELLERID as "fcancellerid",FCANCELDATE as "fcanceldate",FIsConvert as "fisconvert",FBUSINESSTYPE as "fbusinesstype",FOBJECTTYPEID as "fobjecttypeid",FREQUIREORGID as "frequireorgid",FCorrespondOrgId as "fcorrespondorgid",FCONFIRMSTATUS as "fconfirmstatus",FCONFIRMERID as "fconfirmerid",FCONFIRMDATE as "fconfirmdate",FBILLTYPEIDVM as "fbilltypeidvm",FCLOSERID as "fcloserid",FCLOSEDATE as "fclosedate",FCLOSESTATUS as "fclosestatus" from T_PUR_MRAPP--查询(中文字段)--select FID as "单据内码",FBILLNO as "单据编号",FDATE as "日期",FBILLTYPEID as "单据类型",FSUPPLIERID as "供应商内码",FRMTYPE as "退货类型",FPURCHASEORGID as "采购组织",FAPPORGID as "申请组织",FAPPDEPTID as "申请部门",FAPPLICANTID as "申请人",FRMMODE as "退货方式",FREPLENISHMODE as "补货方式",FRMREASON as "退货原因",FRMLOC as "退货地点",FDOCUMENTSTATUS as "单据状态",FDESCRIPTION as "描述",FCREATORID as "制单人",FCREATEDATE as "制单日期",FMODIFIERID as "最近修改人内码",FMODIFYDATE as "最新修改日期",FAPPROVERID as "审核人内码",FAPPROVEDATE as "审核日期",FCANCELSTATUS as "作废状态",FCANCELLERID as "作废人内码",FCANCELDATE as "作废日期",FIsConvert as "是否是单据转换",FBUSINESSTYPE as "业务类型",FOBJECTTYPEID as "业务对象类型",FREQUIREORGID as "需求组织携带",FCorrespondOrgId as "对应组织",FCONFIRMSTATUS as "确认状态",FCONFIRMERID as "确认人",FCONFIRMDATE as "确认日期",FBILLTYPEIDVM as "协同虚拟单据类型",FCLOSERID as "关闭人",FCLOSEDATE as "关闭日期",FCLOSESTATUS as "关闭状态" from T_PUR_MRAPP--INSERT脚本--insert into T_PUR_MRAPP(FID,FBILLNO,FDATE,FBILLTYPEID,FSUPPLIERID,FRMTYPE,FPURCHASEORGID,FAPPORGID,FAPPDEPTID,FAPPLICANTID,FRMMODE,FREPLENISHMODE,FRMREASON,FRMLOC,FDOCUMENTSTATUS,FDESCRIPTION,FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FCANCELSTATUS,FCANCELLERID,FCANCELDATE,FIsConvert,FBUSINESSTYPE,FOBJECTTYPEID,FREQUIREORGID,FCorrespondOrgId,FCONFIRMSTATUS,FCONFIRMERID,FCONFIRMDATE,FBILLTYPEIDVM,FCLOSERID,FCLOSEDATE,FCLOSESTATUS) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)--UPDATE脚本--update T_PUR_MRAPP set FID=?,FBILLNO=?,FDATE=?,FBILLTYPEID=?,FSUPPLIERID=?,FRMTYPE=?,FPURCHASEORGID=?,FAPPORGID=?,FAPPDEPTID=?,FAPPLICANTID=?,FRMMODE=?,FREPLENISHMODE=?,FRMREASON=?,FRMLOC=?,FDOCUMENTSTATUS=?,FDESCRIPTION=?,FCREATORID=?,FCREATEDATE=?,FMODIFIERID=?,FMODIFYDATE=?,FAPPROVERID=?,FAPPROVEDATE=?,FCANCELSTATUS=?,FCANCELLERID=?,FCANCELDATE=?,FIsConvert=?,FBUSINESSTYPE=?,FOBJECTTYPEID=?,FREQUIREORGID=?,FCorrespondOrgId=?,FCONFIRMSTATUS=?,FCONFIRMERID=?,FCONFIRMDATE=?,FBILLTYPEIDVM=?,FCLOSERID=?,FCLOSEDATE=?,FCLOSESTATUS=? where FID=?--delete脚本--delete from T_PUR_MRAPP where FID=?--给字段加备注--alter table T_PUR_MRAPP modify column FID int default 0 comment '单据内码'; alter table T_PUR_MRAPP modify column FBILLNO nvarchar(30) default '' comment '单据编号'; alter table T_PUR_MRAPP modify column FDATE datetime default getdate() comment '日期'; alter table T_PUR_MRAPP modify column FBILLTYPEID varchar(36) default '''' comment '单据类型'; alter table T_PUR_MRAPP modify column FSUPPLIERID int default 0 comment '供应商内码'; alter table T_PUR_MRAPP modify column FRMTYPE varchar(20) not null comment '退货类型'; alter table T_PUR_MRAPP modify column FPURCHASEORGID int default 0 comment '采购组织'; alter table T_PUR_MRAPP modify column FAPPORGID int default 0 comment '申请组织'; alter table T_PUR_MRAPP modify column FAPPDEPTID int default 0 comment '申请部门'; alter table T_PUR_MRAPP modify column FAPPLICANTID int default 0 comment '申请人'; alter table T_PUR_MRAPP modify column FRMMODE varchar(20) default '''' comment '退货方式'; alter table T_PUR_MRAPP modify column FREPLENISHMODE varchar(20) default '''' comment '补货方式'; alter table T_PUR_MRAPP modify column FRMREASON varchar(36) default '''' comment '退货原因'; alter table T_PUR_MRAPP modify column FRMLOC nvarchar(120) default '' comment '退货地点'; alter table T_PUR_MRAPP modify column FDOCUMENTSTATUS char(1) default '''' comment '单据状态'; alter table T_PUR_MRAPP modify column FDESCRIPTION nvarchar(255) default '' comment '描述'; alter table T_PUR_MRAPP modify column FCREATORID int default 0 comment '制单人'; alter table T_PUR_MRAPP modify column FCREATEDATE datetime default getdate() comment '制单日期'; alter table T_PUR_MRAPP modify column FMODIFIERID int default 0 comment '最近修改人内码'; alter table T_PUR_MRAPP modify column FMODIFYDATE datetime not null comment '最新修改日期'; alter table T_PUR_MRAPP modify column FAPPROVERID int default 0 comment '审核人内码'; alter table T_PUR_MRAPP modify column FAPPROVEDATE datetime not null comment '审核日期'; alter table T_PUR_MRAPP modify column FCANCELSTATUS char(1) default '''' comment '作废状态'; alter table T_PUR_MRAPP modify column FCANCELLERID int default 0 comment '作废人内码'; alter table T_PUR_MRAPP modify column FCANCELDATE datetime not null comment '作废日期'; alter table T_PUR_MRAPP modify column FIsConvert char(1) default ''0'' comment '是否是单据转换'; alter table T_PUR_MRAPP modify column FBUSINESSTYPE nvarchar(20) default '' comment '业务类型'; alter table T_PUR_MRAPP modify column FOBJECTTYPEID varchar(36) default '''' comment '业务对象类型'; alter table T_PUR_MRAPP modify column FREQUIREORGID int default 0 comment '需求组织携带'; alter table T_PUR_MRAPP modify column FCorrespondOrgId int not null comment '对应组织'; alter table T_PUR_MRAPP modify column FCONFIRMSTATUS char(1) default '''' comment '确认状态'; alter table T_PUR_MRAPP modify column FCONFIRMERID int default 0 comment '确认人'; alter table T_PUR_MRAPP modify column FCONFIRMDATE datetime not null comment '确认日期'; alter table T_PUR_MRAPP modify column FBILLTYPEIDVM varchar(36) default '''' comment '协同虚拟单据类型'; alter table T_PUR_MRAPP modify column FCLOSERID int default 0 comment '关闭人'; alter table T_PUR_MRAPP modify column FCLOSEDATE datetime not null comment '关闭日期'; alter table T_PUR_MRAPP modify column FCLOSESTATUS char(1) default '''' comment '关闭状态';
-
Kingdee-采购管理-T_PUR_CATALOG_ISSUE-采购目录下发信息表 T_PUR_CATALOG_ISSUE表描述：采购目录下发信息表备注：存储价目表下发信息主键字段名字段描述数据类型长度可空备注✓FISSUEPKID主键varchar36 默认值:''null FID单据内码int ✓默认值:0null FISSUEORGID下发组织int ✓ FISSUEMAN下发人int ✓ FISSUEDATE下发日期datetime ✓ --建表脚本--create table T_PUR_CATALOG_ISSUE( FISSUEPKID varchar(36) default '''' comment '主键' ,FID int not null comment '单据内码' ,FISSUEORGID int not null comment '下发组织' ,FISSUEMAN int not null comment '下发人' ,FISSUEDATE datetime not null comment '下发日期' ,primary key (FISSUEPKID) ) comment = '采购目录下发信息'--查询--select FISSUEPKID as "fissuepkid",FID as "fid",FISSUEORGID as "fissueorgid",FISSUEMAN as "fissueman",FISSUEDATE as "fissuedate" from T_PUR_CATALOG_ISSUE--查询(中文字段)--select FISSUEPKID as "主键",FID as "单据内码",FISSUEORGID as "下发组织",FISSUEMAN as "下发人",FISSUEDATE as "下发日期" from T_PUR_CATALOG_ISSUE--INSERT脚本--insert into T_PUR_CATALOG_ISSUE(FISSUEPKID,FID,FISSUEORGID,FISSUEMAN,FISSUEDATE) values (?,?,?,?,?)--UPDATE脚本--update T_PUR_CATALOG_ISSUE set FISSUEPKID=?,FID=?,FISSUEORGID=?,FISSUEMAN=?,FISSUEDATE=? where FISSUEPKID=?--delete脚本--delete from T_PUR_CATALOG_ISSUE where FISSUEPKID=?--给字段加备注--alter table T_PUR_CATALOG_ISSUE modify column FISSUEPKID varchar(36) default '''' comment '主键'; alter table T_PUR_CATALOG_ISSUE modify column FID int not null comment '单据内码'; alter table T_PUR_CATALOG_ISSUE modify column FISSUEORGID int not null comment '下发组织'; alter table T_PUR_CATALOG_ISSUE modify column FISSUEMAN int not null comment '下发人'; alter table T_PUR_CATALOG_ISSUE modify column FISSUEDATE datetime not null comment '下发日期';
