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
|
Download
