CREATE TABLE [dbo].[ARChargeAccountTransactions]
(
[ChargeAccountTransactionID] [int] NOT NULL IDENTITY(1, 1),
[ChargeAccountTypeID] [int] NOT NULL,
[Name] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BnCdNumber] [varbinary] (32) NOT NULL,
[CardNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ChargeAccountInfo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ExpDate] [datetime] NOT NULL,
[SecurityCode] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_Active] DEFAULT ((1)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_LastUpdate] DEFAULT (getdate()),
[AuthorizationNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_AuthorizationNumber] DEFAULT (''),
[PNREF] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_PNREF] DEFAULT (''),
[Results] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_Results] DEFAULT (''),
[DelayedAuthorization] [bit] NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_DelayedAuthorization] DEFAULT ((0)),
[TempAmount] [decimal] (14, 4) NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_TempAmount] DEFAULT ((0)),
[BnRoutingNumber] [varbinary] (32) NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_BnRoutingNumber] DEFAULT (CONVERT([varbinary],'',(0))),
[RoutingNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_RoutingNumber] DEFAULT (''),
[BankName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_BankName] DEFAULT (''),
[BnPaymentAccountID] [varbinary] (64) NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_BnPaymentAccountID] DEFAULT ((0)),
[TransactionNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_TransactionNumber] DEFAULT (''),
[ResultCode] [int] NULL,
[ChargeAccountID] [int] NULL,
[Phone] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARChargeAccountTransactions_Phone] DEFAULT (''),
[CCVaultID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARChargeAccountTransactions] ADD CONSTRAINT [PK_ARChargeAccountTransactions] PRIMARY KEY CLUSTERED ([ChargeAccountTransactionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARChargeAccountTransactions] ADD CONSTRAINT [FK_ARChargeAccountTransactions_CCVaultID_ARCCVaults] FOREIGN KEY ([CCVaultID]) REFERENCES [dbo].[ARCCVaults] ([CCVaultID])
GO
ALTER TABLE [dbo].[ARChargeAccountTransactions] ADD CONSTRAINT [FK_ARChargeAccountTransactions_ChargeAccountTypeID_ARChargeAccountTypes] FOREIGN KEY ([ChargeAccountTypeID]) REFERENCES [dbo].[ARChargeAccountTypes] ([ChargeAccountTypeID])
GO