开发工具:
文件大小: 11kb
下载次数: 0
上传时间: 2014-06-14
详细说明： USE [UFDATA_002_2004] GO /****** Object: Table [dbo].[JustInVouchs] Script Date: 06/12/2014 14:09:57 ******/ drop table JustInVouchs drop table IA_Subsidiary SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[JustInVouchs]( [AutoID] [int] NOT NULL, [cJVCode] [varchar](30) NOT NULL, [CorID] [int] NULL, [cCorCode] [varchar](30) NULL, [cInvCode] [varchar](20) NOT NULL, [iJVPrice] [money] NULL, [cJVBatch] [varchar](20) NULL, [cObjCode] [varchar](12) NULL, [cFree1] [varchar](20) NULL, [cFree2] [varchar](20) NULL, [cDefine22] [nvarchar](60) NULL, [cDefine23] [nvarchar](60) NULL, [cDefine24] [nvarchar](60) NULL, [cDefine25] [nvarchar](60) NULL, [cDefine26] [float] NULL, [cDefine27] [float] NULL, [cItemCode] [varchar](20) NULL, [cItem_class] [varchar](10) NULL, [cName] [varchar](60) NULL, [cItemCName] [varchar](20) NULL, [iJustInsId] [int] NULL, [cBVencode] [varchar](20) NULL, [cFree3] [varchar](20) NULL, [iMassDate] [int] NULL, [dMadeDate] [datetime] NULL, [cInVouchCode] [varchar](30) NULL, [cFree4] [varchar](20) NULL, [cFree5] [varchar](20) NULL, [cFree6] [varchar](20) NULL, [cFree7] [varchar](20) NULL, [cFree8] [varchar](20) NULL, [cFree9] [varchar](20) NULL, [cFree10] [varchar](20) NULL, [cDefine28] [varchar](120) NULL, [cDefine29] [varchar](120) NULL, [cDefine30] [varchar](120) NULL, [cDefine31] [varchar](120) NULL, [cDefine32] [varchar](120) NULL, [cDefine33] [varchar](120) NULL, [cDefine34] [int] NULL, [cDefine35] [int] NULL, [cDefine36] [datetime] NULL, [cDefine37] [datetime] NULL, CONSTRAINT [aaaaaJustInVouchs_PK] PRIMARY KEY NONCLUSTERED ( [AutoID] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[IA_Subsidiary] Script Date: 06/12/2014 14:09:57 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[IA_Subsidiary]( [AutoID] [int] IDENTITY(1,1) NOT NULL, [bRdFlag] [bit] NOT NULL, [cBusType] [varchar](8) NULL, [cBusCode] [varchar](30) NULL, [cVouCode] [varchar](30) NULL, [ID] [int] NULL, [ValueID] [int] NULL, [JustID] [int] NULL, [dVouDate] [datetime] NULL, [dKeepDate] [datetime] NULL, [iMonth] [tinyint] NOT NULL, [iPZID] [int] NULL, [iPZDate] [datetime] NULL, [cPZtype] [varchar](8) NULL, [cPZdigest] [varchar](60) NULL, [cInvHead] [varchar](15) NULL, [cDifHead] [varchar](15) NULL, [cOppHead] [varchar](15) NULL, [cVouType] [varchar](4) NULL, [cPTCode] [varchar](2) NULL, [cSTCode] [varchar](2) NULL, [cWhCode] [varchar](10) NULL, [cAccDep] [varchar](12) NULL, [cInvCode] [varchar](20) NOT NULL, [cRdCode] [varchar](5) NULL, [cVenCode] [varchar](20) NULL, [cCusCode] [varchar](20) NULL, [cOrderCode] [varchar](30) NULL, [cARVCode] [varchar](30) NULL, [cBillCode] [int] NULL, [cDLCode] [int] NULL, [cPSPCode] [varchar](12) NULL, [cProCode] [varchar](50) NULL, [cDepCode] [varchar](12) NULL, [cPersonCode] [varchar](8) NULL, [cHandler] [varchar](20) NULL, [iAInQuantity] [float] NULL, [iAOutQuantity] [float] NULL, [iInCost] [float] NULL, [iOutCost] [float] NULL, [iAInPrice] [money] NULL, [iAOutPrice] [money] NULL, [cBatchCode] [varchar](20) NULL, [iDebitDifCost] [money] NULL, [iCreditDifCost] [money] NULL, [cAccounter] [varchar](20) NULL, [cMaker] [varchar](20) NULL, [bFlag] [tinyint] NULL, [bMoneyFlag] [bit] NOT NULL, [bSale] [bit] NOT NULL, [cMemo] [varchar](60) NULL, [cDefine1] [varchar](20) NULL, [cDefine2] [varchar](20) NULL, [cDefine3] [varchar](20) NULL, [cDefine4] [datetime] NULL, [cDefine5] [int] NULL, [cDefine6] [datetime] NULL, [cDefine7] [float] NULL, [cDefine8] [varchar](4) NULL, [cDefine9] [varchar](8) NULL, [cDefine10] [varchar](60) NULL, [cFree1] [varchar](20) NULL, [cFree2] [varchar](20) NULL, [cPZID] [varchar](30) NULL, [cDefine22] [nvarchar](60) NULL, [cDefine23] [nvarchar](60) NULL, [cDefine24] [nvarchar](60) NULL, [cDefine25] [nvarchar](60) NULL, [cDefine26] [float] NULL, [cDefine27] [float] NULL, [cItem_class] [varchar](10) NULL, [cItemCode] [varchar](20) NULL, [cName] [varchar](60) NULL, [cItemCName] [varchar](20) NULL, [noJustQuantity] [userdecimal] NULL, [cFree3] [varchar](20) NULL, [cFree4] [varchar](20) NULL, [cFree5] [varchar](20) NULL, [cFree6] [varchar](20) NULL, [cFree7] [varchar](20) NULL, [cFree8] [varchar](20) NULL, [cFree9] [varchar](20) NULL, [cFree10] [varchar](20) NULL, [cDefine11] [varchar](120) NULL, [cDefine12] [varchar](120) NULL, [cDefine13] [varchar](120) NULL, [cDefine14] [varchar](120) NULL, [cDefine15] [int] NULL, [cDefine16] [float] NULL, [cDefine28] [varchar](120) NULL, [cDefine29] [varchar](120) NULL, [cDefine30] [varchar](120) NULL, [cDefine31] [varchar](120) NULL, [cDefine32] [varchar](120) NULL, [cDefine33] [varchar](120) NULL, [cDefine34] [int] NULL, [cDefine35] [int] NULL, [cDefine36] [datetime] NULL, [cDefine37] [datetime] NULL, [psvsid] [int] NULL, [cCXHDcode] [varchar](30) NULL, [cCXFScode] [varchar](20) NULL, CONSTRAINT [aaaaaIA_Subsidiary_PK] PRIMARY KEY NONCLUSTERED ( [AutoID] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Default [DF__ia_subsid__cDefi__11165497] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__11165497] DEFAULT (NULL) FOR [cDefine22] GO /****** Object: Default [DF__ia_subsid__cDefi__120A78D0] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__120A78D0] DEFAULT (NULL) FOR [cDefine23] GO /****** Object: Default [DF__ia_subsid__cDefi__12FE9D09] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__12FE9D09] DEFAULT (NULL) FOR [cDefine24] GO /****** Object: Default [DF__ia_subsid__cDefi__13F2C142] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__13F2C142] DEFAULT (NULL) FOR [cDefine25] GO /****** Object: Default [DF__ia_subsid__cDefi__14E6E57B] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__14E6E57B] DEFAULT (NULL) FOR [cDefine26] GO /****** Object: Default [DF__ia_subsid__cDefi__15DB09B4] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] ADD CONSTRAINT [DF__ia_subsid__cDefi__15DB09B4] DEFAULT (NULL) FOR [cDefine27] GO /****** Object: Default [DF__JustInVou__cDefi__16CF2DED] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__16CF2DED] DEFAULT (NULL) FOR [cDefine22] GO /****** Object: Default [DF__JustInVou__cDefi__17C35226] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__17C35226] DEFAULT (NULL) FOR [cDefine23] GO /****** Object: Default [DF__JustInVou__cDefi__18B7765F] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__18B7765F] DEFAULT (NULL) FOR [cDefine24] GO /****** Object: Default [DF__JustInVou__cDefi__19AB9A98] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__19AB9A98] DEFAULT (NULL) FOR [cDefine25] GO /****** Object: Default [DF__JustInVou__cDefi__1A9FBED1] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__1A9FBED1] DEFAULT (NULL) FOR [cDefine26] GO /****** Object: Default [DF__JustInVou__cDefi__1B93E30A] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[JustInVouchs] ADD CONSTRAINT [DF__JustInVou__cDefi__1B93E30A] DEFAULT (NULL) FOR [cDefine27] GO /****** Object: ForeignKey [FK__IA_Subsid__cDepC__4F7F3212] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] WITH CHECK ADD FOREIGN KEY([cDepCode]) REFERENCES [dbo].[Department] ([cDepCode]) GO /****** Object: ForeignKey [FK__IA_Subsid__cDepC__5073564B] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] WITH CHECK ADD FOREIGN KEY([cDepCode]) REFERENCES [dbo].[Department] ([cDepCode]) GO /****** Object: ForeignKey [FK__IA_Subsid__cDepC__51677A84] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] WITH CHECK ADD FOREIGN KEY([cDepCode]) REFERENCES [dbo].[Department] ([cDepCode]) GO /****** Object: ForeignKey [FK__IA_Subsid__cInvC__525B9EBD] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] WITH CHECK ADD FOREIGN KEY([cInvCode]) REFERENCES [dbo].[Inventory] ([cInvCode]) GO /****** Object: ForeignKey [FK__IA_Subsid__cInvC__534FC2F6] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] WITH CHECK ADD FOREIGN KEY([cInvCode]) REFERENCES [dbo].[Inventory] ([cInvCode]) GO /****** Object: ForeignKey [FK__IA_Subsid__cInvC__5443E72F] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] WITH CHECK ADD FOREIGN KEY([cInvCode]) REFERENCES [dbo].[Inventory] ([cInvCode]) GO /****** Object: ForeignKey [FK__IA_Subsid__cWhCo__55380B68] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] WITH CHECK ADD FOREIGN KEY([cWhCode]) REFERENCES [dbo].[Warehouse] ([cWhCode]) GO /****** Object: ForeignKey [FK__IA_Subsid__cWhCo__562C2FA1] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] WITH CHECK ADD FOREIGN KEY([cWhCode]) REFERENCES [dbo].[Warehouse] ([cWhCode]) GO /****** Object: ForeignKey [FK__IA_Subsid__cWhCo__572053DA] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[IA_Subsidiary] WITH CHECK ADD FOREIGN KEY([cWhCode]) REFERENCES [dbo].[Warehouse] ([cWhCode]) GO /****** Object: ForeignKey [FK__JustInVou__cInvC__58147813] Script Date: 06/12/2014 14:09:57 ******/ ALTER TABLE [dbo].[JustInVouchs] WITH CHECK ADD FOREIGN KEY([cInvCode]) REFERENCES [dbo].[Inventory] ([cInvCode]) GO ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
