USE [payf]
GO

/****** Object:  Table [dbo].[B2B_FH]    Script Date: 07/30/2010 22:48:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[B2B_FH](
	[pkid] [int] IDENTITY(1,1) NOT NULL,
	[environment] [nvarchar](30) NOT NULL,
	[status] [nvarchar](30) NULL,
	[archive] [nvarchar](15) NOT NULL,
	[useridLastupdate] [nvarchar](30) NULL,
	[useridCreator] [nvarchar](30) NULL,
	[client] [nvarchar](9) NULL,
	[SCHEMATYP] [nvarchar](9) NULL,
	[technicalfieldautocreated] [nvarchar](15) NULL,
	[technicalfieldcreated] [datetime] NULL,
	[technicalfieldlastupdate] [datetime] NULL,
	[userdefinedfields5] [nvarchar](15) NULL,
	[userdefinedfields4] [datetime] NULL,
	[userdefinedfields3] [nvarchar](105) NULL,
	[userdefinedfields2] [nvarchar](105) NULL,
	[userdefinedfields1] [nvarchar](105) NULL,
	[sndginst] [nvarchar](33) NOT NULL,
	[rcvginst] [nvarchar](33) NOT NULL,
	[srvcid] [nvarchar](9) NOT NULL,
	[tstcode] [nvarchar](3) NOT NULL,
	[ftype] [nvarchar](9) NOT NULL,
	[fileref] [nvarchar](48) NOT NULL,
	[filedttm] [datetime] NULL,
	[numctblk] [int] NULL,
	[numddblk] [int] NULL,
	[numpcrblk] [int] NULL,
	[numrejblk] [int] NULL,
	[numrvsblk] [int] NULL,
	[numrrvblk] [int] NULL,
	[numrfcblk] [int] NULL,
	[numrfrblk] [int] NULL,
	[numroiblk] [int] NULL,
	[idferrcd] [nvarchar](9) NULL,
	[origfref] [nvarchar](48) NULL,
	[origfname] [nvarchar](96) NULL,
	[origdttm] [datetime] NULL,
	[filerjctrsn] [nvarchar](9) NULL,
	[filebusdt] [datetime] NULL,
	[routingind] [nvarchar](9) NOT NULL,
	[filecycleno] [numeric](10, 0) NULL,
 CONSTRAINT [PK_B2B_FH] PRIMARY KEY CLUSTERED 
(
	[pkid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO