Files

138 lines
10 KiB
SQL
Executable File

/* 脚本导出时间:2026/08/18 14:46:02 */
/* 脚本导出人员:系统管理员 */
/* 脚本 说明:T_PUR_POORDER 采购订单*/
-- DROP TABLE T_PUR_POORDER
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'T_PUR_POORDER') AND type in (N'U'))
BEGIN
CREATE TABLE T_PUR_POORDER(
FBILLTYPEID VARCHAR(50) NOT NULL DEFAULT '' , -- 单据类型
FSUPPLYID VARCHAR(50) NOT NULL DEFAULT '' , -- 供应商
FPURCHASERID VARCHAR(50) NOT NULL DEFAULT '' , -- 采购员内码
FBUSINESSTYPE VARCHAR(50) NOT NULL DEFAULT '' , -- 业务类型
FDATE DATE NULL , -- 采购日期
FPURCHASEDEPTID VARCHAR(50) NOT NULL DEFAULT '' , -- 采购部门内码
FASSIGNSUPPLIERID VARCHAR(50) NOT NULL DEFAULT '' , -- 指定供应商内码
FSETTLECURRID VARCHAR(50) NOT NULL DEFAULT '' , -- 结算货币内码
FERPDEL BIT NOT NULL DEFAULT 0 , -- ERP已经删除
FPROVIDERID VARCHAR(50) NOT NULL DEFAULT '' , -- 供货方内码
FPROVIDERCONTACT VARCHAR(50) NOT NULL DEFAULT '' , -- 供货方联系人
FPROVIDERJOB VARCHAR(50) NOT NULL DEFAULT '' , -- 职务
FPROVIDERADDRESS VARCHAR(255) NOT NULL DEFAULT '' , -- 供货方地址
FSETTLEID VARCHAR(50) NOT NULL DEFAULT '' , -- 结算方
FCHARGEID VARCHAR(50) NOT NULL DEFAULT '' , -- 收款方
FPAYCONDITIONID VARCHAR(50) NOT NULL DEFAULT '' , -- 付款条件
FEXCHANGETYPEID VARCHAR(50) NOT NULL DEFAULT '' , -- 汇率类型
FEXCHANGERATE DECIMAL(24,10) NOT NULL DEFAULT 0 , -- 汇率
FCHANGEREASON VARCHAR(max) NOT NULL DEFAULT '' , -- 变更原因
FCHECKERID VARCHAR(50) NOT NULL DEFAULT '' , -- 审核人内码
FCHECKDATE DATE NULL , -- 审核日期
FDISABLEID VARCHAR(50) NOT NULL DEFAULT '' , -- 禁用人
FISPRICEEXCLUDETAX BIT NOT NULL DEFAULT 0 , -- 价外税
FISINCLUDEDTAX BIT NOT NULL DEFAULT 0 , -- 含税
FDISABLEDATE DATETIME NULL , -- 禁用日期
FDESCRIBE VARCHAR(255) NOT NULL DEFAULT '' , -- 描述
FNOTE NVARCHAR(max) NOT NULL DEFAULT '' , -- 备注
FOASTATUS VARCHAR(50) NOT NULL DEFAULT '' , -- 审批状态
FOARESULT VARCHAR(50) NOT NULL DEFAULT '' , -- 审批结果
FINTERID VARCHAR(50) NOT NULL DEFAULT '', -- 表内码
FBILLNO VARCHAR(50) NOT NULL DEFAULT '', -- 单据编号
FGROUPID VARCHAR(50) NOT NULL DEFAULT '', -- 分组内码
FSTATUS INT NOT NULL DEFAULT 0 , -- 状态
FDELETED BIT NOT NULL DEFAULT 0 , --禁用状态 0 = 正常 1 = 禁用
FCOMPANYID VARCHAR(50) NOT NULL DEFAULT '', -- 组织代码
C_YMD DATETIME NULL, -- 资料创建日期
C_USER VARCHAR(20) NOT NULL DEFAULT '', -- 资料创建帐号
M_YMD DATETIME NULL, -- 最后异动日期
M_USER VARCHAR(20) NOT NULL DEFAULT '', -- 最后异动帐号
UID VARCHAR(50) NOT NULL CONSTRAINT [PK_T_PUR_POORDER] PRIMARY KEY NONCLUSTERED
)
END
ELSE
BEGIN
if(not exists(select name from SysColumns where name ='FBILLTYPEID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FBILLTYPEID VARCHAR(50) NOT NULL DEFAULT '' -- 单据类型
if(not exists(select name from SysColumns where name ='FSUPPLYID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FSUPPLYID VARCHAR(50) NOT NULL DEFAULT '' -- 供应商
if(not exists(select name from SysColumns where name ='FPURCHASERID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FPURCHASERID VARCHAR(50) NOT NULL DEFAULT '' -- 采购员内码
if(not exists(select name from SysColumns where name ='FBUSINESSTYPE' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FBUSINESSTYPE VARCHAR(50) NOT NULL DEFAULT '' -- 业务类型
if(not exists(select name from SysColumns where name ='FDATE' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FDATE DATE NULL -- 采购日期
if(not exists(select name from SysColumns where name ='FPURCHASEDEPTID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FPURCHASEDEPTID VARCHAR(50) NOT NULL DEFAULT '' -- 采购部门内码
if(not exists(select name from SysColumns where name ='FASSIGNSUPPLIERID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FASSIGNSUPPLIERID VARCHAR(50) NOT NULL DEFAULT '' -- 指定供应商内码
if(not exists(select name from SysColumns where name ='FSETTLECURRID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FSETTLECURRID VARCHAR(50) NOT NULL DEFAULT '' -- 结算货币内码
if(not exists(select name from SysColumns where name ='FERPDEL' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FERPDEL BIT NOT NULL DEFAULT 0 -- ERP已经删除
if(not exists(select name from SysColumns where name ='FPROVIDERID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FPROVIDERID VARCHAR(50) NOT NULL DEFAULT '' -- 供货方内码
if(not exists(select name from SysColumns where name ='FPROVIDERCONTACT' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FPROVIDERCONTACT VARCHAR(50) NOT NULL DEFAULT '' -- 供货方联系人
if(not exists(select name from SysColumns where name ='FPROVIDERJOB' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FPROVIDERJOB VARCHAR(50) NOT NULL DEFAULT '' -- 职务
if(not exists(select name from SysColumns where name ='FPROVIDERADDRESS' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FPROVIDERADDRESS VARCHAR(255) NOT NULL DEFAULT '' -- 供货方地址
if(not exists(select name from SysColumns where name ='FSETTLEID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FSETTLEID VARCHAR(50) NOT NULL DEFAULT '' -- 结算方
if(not exists(select name from SysColumns where name ='FCHARGEID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FCHARGEID VARCHAR(50) NOT NULL DEFAULT '' -- 收款方
if(not exists(select name from SysColumns where name ='FPAYCONDITIONID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FPAYCONDITIONID VARCHAR(50) NOT NULL DEFAULT '' -- 付款条件
if(not exists(select name from SysColumns where name ='FEXCHANGETYPEID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FEXCHANGETYPEID VARCHAR(50) NOT NULL DEFAULT '' -- 汇率类型
if(not exists(select name from SysColumns where name ='FEXCHANGERATE' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FEXCHANGERATE DECIMAL(24,10) NOT NULL DEFAULT 0 -- 汇率
if(not exists(select name from SysColumns where name ='FCHANGEREASON' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FCHANGEREASON VARCHAR(max) NOT NULL DEFAULT '' -- 变更原因
if(not exists(select name from SysColumns where name ='FCHECKERID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FCHECKERID VARCHAR(50) NOT NULL DEFAULT '' -- 审核人内码
if(not exists(select name from SysColumns where name ='FCHECKDATE' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FCHECKDATE DATE NULL -- 审核日期
if(not exists(select name from SysColumns where name ='FDISABLEID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FDISABLEID VARCHAR(50) NOT NULL DEFAULT '' -- 禁用人
if(not exists(select name from SysColumns where name ='FISPRICEEXCLUDETAX' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FISPRICEEXCLUDETAX BIT NOT NULL DEFAULT 0 -- 价外税
if(not exists(select name from SysColumns where name ='FISINCLUDEDTAX' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FISINCLUDEDTAX BIT NOT NULL DEFAULT 0 -- 含税
if(not exists(select name from SysColumns where name ='FDISABLEDATE' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FDISABLEDATE DATETIME NULL -- 禁用日期
if(not exists(select name from SysColumns where name ='FDESCRIBE' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FDESCRIBE VARCHAR(255) NOT NULL DEFAULT '' -- 描述
if(not exists(select name from SysColumns where name ='FNOTE' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FNOTE NVARCHAR(max) NOT NULL DEFAULT '' -- 备注
if(not exists(select name from SysColumns where name ='FOASTATUS' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FOASTATUS VARCHAR(50) NOT NULL DEFAULT '' -- 审批状态
if(not exists(select name from SysColumns where name ='FOARESULT' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FOARESULT VARCHAR(50) NOT NULL DEFAULT '' -- 审批结果
if(not exists(select name from SysColumns where name ='FCOMPANYID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FCOMPANYID VARCHAR(50) NOT NULL DEFAULT '' -- 组织代码
if(not exists(select name from SysColumns where name ='FINTERID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FINTERID VARCHAR(50) NOT NULL DEFAULT '' -- 表内码
if(not exists(select name from SysColumns where name ='FBILLNO' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FBILLNO VARCHAR(50) NOT NULL DEFAULT '' -- 单据编号
if(not exists(select name from SysColumns where name ='FGROUPID' and id= OBJECT_ID('T_PUR_POORDER')))
Alter Table T_PUR_POORDER add FGROUPID VARCHAR(50) NOT NULL DEFAULT '' -- 分组内码
END
GO
--
IF EXISTS (SELECT * FROM sysindexes WHERE id = OBJECT_ID(N'T_PUR_POORDER') AND name = N't_PUR_POOrder_1' )
Drop Index T_PUR_POORDER.t_PUR_POOrder_1
GO
Create unique index t_PUR_POOrder_1 on T_PUR_POORDER(FINTERID)
GO
--
IF EXISTS (SELECT * FROM sysindexes WHERE id = OBJECT_ID(N'T_PUR_POORDER') AND name = N't_PUR_POOrder_2' )
Drop Index T_PUR_POORDER.t_PUR_POOrder_2
GO
Create unique Clustered index t_PUR_POOrder_2 on T_PUR_POORDER(FBILLNO)
GO
GO