FCC/Applications/PumpInfoToDatabase/SqlServer_SinoChemTables.txt

USE [SinoChemPosDatabase]
GO

/****** Object:  Table [dbo].[jy_info]    Script Date: 08/14/2018 14:04:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[jy_info](
	[jihao] [varchar](10) NULL,
	[status] [varchar](10) NULL,
	[youpin] [varchar](12) NULL,
	[qty] [decimal] NULL,
	[amount] [decimal] NULL,
	[fzqty] [decimal] NULL,
	[fzamount] [decimal] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SinoChemPosDatabase]
GO

/****** Object:  Table [dbo].[xiaofei2]    Script Date: 08/14/2018 14:04:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[xiaofei2](
	[jihao] [int] NULL,
	[youpin] [varchar](12) NULL,
	[qty] [decimal] NULL,
	[danjia] [decimal] NULL,
	[amount] [decimal] NULL,
	[xf_date] [datetime] NULL,
	[xf_time] [varchar](8) NULL,
	[liushuino] [double] NULL,
	[fzqty] [decimal] NULL,
	[fzamount] [decimal] NULL,
	[cardno] [varchar](128) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

USE [SinoChemPosDatabase]
GO

/****** Object:  Table [dbo].[jyjpz]    Script Date: 08/14/2018 14:04:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO
#====in some sites, the table name could be: yjpz
CREATE TABLE [dbo].[jyjpz](
	[jihao] [int] NULL,
	[ABtype] [varchar](12) NULL,
	[qianghao] [int] NULL,
	[luojiqh] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO