⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 erp数1.htm

📁 OA数据库源SQL语句完整OA数据库源SQL语句完整OA数据库源SQL语句完整OA数据库源SQL语句完整
💻 HTM
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
<tr>
<td>
<p align="left">创建人
</p>
</td>
<td>
<p align="left">creator
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">申请人
</p>
</td>
<td class="TD2">
<p align="left">proposer
</p>
</td>
</tr>
<tr>
<td>
<p align="left">部门ID
</p>
</td>
<td>
<p align="left">deptid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">创建日期
</p>
</td>
<td class="TD2">
<p align="left">createDate
</p>
</td>
</tr>
<tr>
<td>
<p align="left">提交日期
</p>
</td>
<td>
<p align="left">submitDate
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">单据状态
</p>
</td>
<td class="TD2">
<p align="left">status
</p>
</td>
</tr>
<tr>
<td>
<p align="left">审批流程ID
</p>
</td>
<td>
<p align="left">flowid
</p>
</td>
</tr>
</table><br />
<h3>
<a name="29">表格[审批_审批单据的共同信息]的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<br />
/* Table: LC_BusinessDocument                                   */<br />
/*==============================================================*/<br />
create table LC_BusinessDocument (<br />
   oid                  int                  not null,<br />
   docNo                varchar(20)          null,<br />
   creator              int                  null,<br />
   proposer             int                  null,<br />
   deptid               int                  null,<br />
   createDate           datetime             null,<br />
   submitDate           datetime             null,<br />
   status               char(1)              null,<br />
   flowid               int                  null,<br />
   constraint PK_LC_BUSINESSDOCUMENT primary key  (oid)<br />
)<br />
go<br />

</p>
</td></tr>
</table><br />
<h2>
<a name="30">审批_审批流程</a> 
</h2>
<h3>
<a name="31">表格[审批_审批流程]的卡片</a> 
</h3>
<table class="Form" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header" width="25%">
<p align="left">名称
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#30">审批_审批流程</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">代码
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#30">LC_Flow</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="32">表格[审批_审批流程]的列清单</a> 
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
</tr>
<tr>
<td>
<p align="left">主键
</p>
</td>
<td>
<p align="left">oid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">流程名称
</p>
</td>
<td class="TD2">
<p align="left">flowName
</p>
</td>
</tr>
<tr>
<td>
<p align="left">单据类型
</p>
</td>
<td>
<p align="left">docType
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">描述
</p>
</td>
<td class="TD2">
<p align="left">describe
</p>
</td>
</tr>
</table><br />
<h3>
<a name="33">表格[审批_审批流程]的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<br />
/* Table: LC_Flow                                               */<br />
/*==============================================================*/<br />
create table LC_Flow (<br />
   oid                  int                  identity,<br />
   flowName             varchar(20)          null,<br />
   docType              varchar(8)           null,<br />
   describe             varchar(20)          null,<br />
   constraint PK_LC_FLOW primary key  (oid)<br />
)<br />
go<br />

</p>
</td></tr>
</table><br />
<h2>
<a name="34">审批_审批节点</a> 
</h2>
<h3>
<a name="35">表格[审批_审批节点]的卡片</a> 
</h3>
<table class="Form" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header" width="25%">
<p align="left">名称
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#34">审批_审批节点</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">代码
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#34">LC_Node</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="36">表格[审批_审批节点]的列清单</a> 
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
</tr>
<tr>
<td>
<p align="left">主键
</p>
</td>
<td>
<p align="left">oid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">流程ID
</p>
</td>
<td class="TD2">
<p align="left">parentid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">节点名称
</p>
</td>
<td>
<p align="left">name
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">上级节点
</p>
</td>
<td class="TD2">
<p align="left">prenodeid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">审批人
</p>
</td>
<td>
<p align="left">proposer
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">审批部门
</p>
</td>
<td class="TD2">
<p align="left">deptid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">审批职位
</p>
</td>
<td>
<p align="left">jobid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">按部门归属审批
</p>
</td>
<td class="TD2">
<p align="left">isByDept
</p>
</td>
</tr>
</table><br />
<h3>
<a name="37">表格[审批_审批节点]的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<br />
/* Table: LC_Node                                               */<br />
/*==============================================================*/<br />
create table LC_Node (<br />
   oid                  int                  identity,<br />
   parentid             int                  null,<br />
   name                 varchar(20)          null,<br />
   prenodeid            int                  null,<br />
   proposer             int                  null,<br />
   deptid               int                  null,<br />
   jobid                int                  null,<br />
   isByDept             char(1)              null,<br />
   constraint PK_LC_NODE primary key  (oid)<br />
)<br />
go<br />

</p>
</td></tr>
</table><br />
<h2>
<a name="38">审批_审批记录表</a> 
</h2>
<h3>
<a name="39">表格[审批_审批记录表]的卡片</a> 
</h3>
<table class="Form" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header" width="25%">
<p align="left">名称
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#38">审批_审批记录表</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">代码
</p>
</td>
<td width="75%">
<p align="left"><a href="ERP数1.htm#38">LC_Approval</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="40">表格[审批_审批记录表]的列清单</a> 
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
</tr>
<tr>
<td>
<p align="left">主键
</p>
</td>
<td>
<p align="left">oid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">单据类型
</p>
</td>
<td class="TD2">
<p align="left">docType
</p>
</td>
</tr>
<tr>
<td>
<p align="left">单据ID
</p>
</td>
<td>
<p align="left">docid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">审批流程ID
</p>
</td>
<td class="TD2">
<p align="left">flowid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">审批节点
</p>
</td>
<td>
<p align="left">nodeid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">审批人
</p>
</td>
<td class="TD2">
<p align="left">approvaluid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">审批状态
</p>
</td>
<td>
<p align="left">status
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">审批意见
</p>
</td>
<td class="TD2">
<p align="left">opinion
</p>
</td>
</tr>
<tr>
<td>
<p align="left">提交日期
</p>
</td>
<td>
<p align="left">submitDate
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">审批日期
</p>
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -