File: global.sql

CREATE TABLE [dbo].[global_transactions](
	[transactionID] [int] IDENTITY(1,1) NOT NULL,
	[Ref] [int] NULL,
	[Invoice] [varchar](50) NULL,
	[Date] [datetime] NULL,
	[Result] [varchar](50) NULL,
	[PaymentType] [varchar](50) NULL,
	[AccountType] [varchar](50) NULL,
	[Account] [varchar](50) NULL,
	[Name] [varchar](50) NULL,
	[Type] [varchar](50) NULL,
	[Status] [varchar](128) NULL,
	[ApprovalCode] [varchar](50) NULL,
	[AuthAmt] [money] NULL,
	[ReqAmt] [money] NULL,
	[MerchantID] [int] NULL,
	[BatchNumber] [int] NULL,
	[ExtData] [varchar](1024) NULL,
	[UserName] [varchar](50) NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[global_merchants](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[merchant] [varchar](50) NOT NULL,
	[shortname] [varchar](4) NULL,
	[username] [varchar](50) NOT NULL,
	[password] [varchar](50) NOT NULL,
	[termType] [varchar](50) NULL,
	[RPNum] [varchar](50) NULL,
	[ResellerKey] [varchar](50) NULL,
	[SEC] [varchar](50) NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[global_void_lookup](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[PNRef] [varchar](50) NULL,
	[VoidedPNRef] [varchar](50) NULL
) ON [PRIMARY]

SET ANSI_PADDING OFF
GO