tb_xord_mstr.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[xord_mst]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xord_mst]
GO

CREATE TABLE [dbo].[xord_mst] (
	[xitemseq] [int] IDENTITY (1, 1) NOT NULL ,
	[action_type] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[action_date] [datetime] NULL ,
	[PONO] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ID] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[vendor_nm] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Prno] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[discount] [numeric](4, 2) NULL ,
	[deli_loc] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[Total] [numeric](15, 2) NULL ,
	[Completed] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[post_date] [datetime] NULL ,
	[remark] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[status] [char] (1) NULL ,
	[last_up] [datetime] NULL ,
	[Creator] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Last_Modify] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO