erp数1.htm

OA数据库源SQL语句完整OA数据库源SQL语句完整OA数据库源SQL语句完整OA数据库源SQL语句完整

</td>
<td class="TD2">
<p align="left">approvalDate
</p>
</td>
</tr>
</table><br />
<h3>
<a name="41">表格[审批_审批记录表]的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<br />
/* Table: LC_Approval                                           */<br />
/*==============================================================*/<br />
create table LC_Approval (<br />
   oid                  int                  identity,<br />
   docType              varchar(8)           null,<br />
   docid                int                  null,<br />
   flowid               int                  null,<br />
   nodeid               int                  null,<br />
   approvaluid          int                  null,<br />
   status               char(1)              null,<br />
   opinion              varchar(50)          null,<br />
   submitDate           datetime             null,<br />
   approvalDate         datetime             null,<br />
   constraint PK_LC_APPROVAL primary key  (oid)<br />
)<br />
go<br />

</p>
</td></tr>
</table><br />
<h2>
<a name="42">客户_公司产品</a> 
</h2>
<h3>
<a name="43">表格[客户_公司产品]的卡片</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#42">客户_公司产品</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#42">KH_Product</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="44">表格[客户_公司产品]的列清单</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">linkname
</p>
</td>
</tr>
<tr>
<td>
<p align="left">商品规格
</p>
</td>
<td>
<p align="left">url
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">商品描述
</p>
</td>
<td class="TD2">
<p align="left">describe
</p>
</td>
</tr>
<tr>
<td>
<p align="left">包装描述
</p>
</td>
<td>
<p align="left">packdesc
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">备注
</p>
</td>
<td class="TD2">
<p align="left">memo
</p>
</td>
</tr>
<tr>
<td>
<p align="left">图片
</p>
</td>
<td>
<p align="left">picture
</p>
</td>
</tr>
</table><br />
<h3>
<a name="45">表格[客户_公司产品]的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<br />
/* Table: KH_Product                                            */<br />
/*==============================================================*/<br />
create table KH_Product (<br />
   oid                  int                  identity,<br />
   linkname             varchar(20)          null,<br />
   url                  varchar(20)          null,<br />
   describe             varchar(100)         null,<br />
   packdesc             varchar(100)         null,<br />
   memo                 varchar(200)         null,<br />
   picture              varchar(50)          null,<br />
   constraint PK_KH_PRODUCT primary key  (oid)<br />
)<br />
go<br />

</p>
</td></tr>
</table><br />
<h2>
<a name="46">客户_客户</a> 
</h2>
<h3>
<a name="47">表格[客户_客户]的卡片</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#46">客户_客户</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#46">KH_Customer</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="48">表格[客户_客户]的列清单</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">customerName
</p>
</td>
</tr>
<tr>
<td>
<p align="left">公司性质
</p>
</td>
<td>
<p align="left">companyType
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">所属行业
</p>
</td>
<td class="TD2">
<p align="left">vocation
</p>
</td>
</tr>
<tr>
<td>
<p align="left">所在地区
</p>
</td>
<td>
<p align="left">city
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">通讯地址
</p>
</td>
<td class="TD2">
<p align="left">address
</p>
</td>
</tr>
<tr>
<td>
<p align="left">邮政编码
</p>
</td>
<td>
<p align="left">zipcode
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">电话
</p>
</td>
<td class="TD2">
<p align="left">phone
</p>
</td>
</tr>
<tr>
<td>
<p align="left">传真
</p>
</td>
<td>
<p align="left">fax
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">电子邮件
</p>
</td>
<td class="TD2">
<p align="left">email
</p>
</td>
</tr>
<tr>
<td>
<p align="left">单位网址
</p>
</td>
<td>
<p align="left">url
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">开户行
</p>
</td>
<td class="TD2">
<p align="left">bank
</p>
</td>
</tr>
<tr>
<td>
<p align="left">银行帐号
</p>
</td>
<td>
<p align="left">account
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">信用状况
</p>
</td>
<td class="TD2">
<p align="left">credit
</p>
</td>
</tr>
<tr>
<td>
<p align="left">客户介绍
</p>
</td>
<td>
<p align="left">introduce
</p>
</td>
</tr>
</table><br />
<h3>
<a name="49">表格[客户_客户]的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<br />
/* Table: KH_Customer                                           */<br />
/*==============================================================*/<br />
create table KH_Customer (<br />
   oid                  int                  identity,<br />
   customerName         varchar(20)          null,<br />
   companyType          int                  null,<br />
   vocation             int                  null,<br />
   city                 varchar(20)          null,<br />
   address              varchar(100)         null,<br />
   zipcode              char(6)              null,<br />
   phone                varchar(20)          null,<br />
   fax                  varchar(20)          null,<br />
   email                varchar(50)          null,<br />
   url                  varchar(50)          null,<br />
   bank                 varchar(20)          null,<br />
   account              varchar(20)          null,<br />
   credit               int                  null,<br />
   introduce            varchar(500)         null,<br />
   constraint PK_KH_CUSTOMER primary key  (oid)<br />
)<br />
go<br />

</p>
</td></tr>
</table><br />
<h2>
<a name="50">客户_客户关心的产品</a> 
</h2>
<h3>
<a name="51">表格[客户_客户关心的产品]的卡片</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#50">客户_客户关心的产品</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#50">KH_CustomerFavorite</a>
</p>
</td>
</tr>
</table><br />
<h3>
<a name="52">表格[客户_客户关心的产品]的列清单</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">customerid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">产品ID
</p>
</td>
<td>
<p align="left">productid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">状态
</p>
</td>
<td class="TD2">
<p align="left">status
</p>
</td>
</tr>
</table><br />
<h3>
<a name="53">表格[客户_客户关心的产品]的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">/*==============================================================*/<br />
/* Ta