DB_Script/Tables/tbl_TRU_TranDetail.sql

USE [FastMoneyPro_Remit]
GO

/****** Object:  Table [dbo].[TRU_TranDetail]    Script Date: 10/20/2023 2:53:08 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TRU_TranDetail](
	[rowId] [bigint] IDENTITY(1,1) NOT NULL,
	[refId] [varchar](100) NULL,
	[title] [varchar](100) NULL,
	[firstName] [varchar](500) NULL,
	[lastName] [varchar](500) NULL,
	[houseNo] [varchar](200) NULL,
	[street] [varchar](200) NULL,
	[town] [varchar](200) NULL,
	[county] [varchar](200) NULL,
	[country] [varchar](200) NULL,
	[postCode] [varchar](200) NULL,
	[email] [varchar](200) NULL,
	[telephone] [varchar](200) NULL,
	[telephoneType] [varchar](200) NULL,
	[cardNo] [varchar](200) NULL,
	[expiryDate] [datetime] NULL,
	[securityCode] [varchar](200) NULL,
	[transactionreference] [varchar](100) NULL,
	[sitereference] [varchar](100) NULL,
	[errorcode] [varchar](20) NULL,
	[createddate] [datetime] NULL,
	[Tranid] [bigint] NULL,
	[orderreference] [varchar](30) NULL,
	[settlestatus] [varchar](30) NULL,
	[paymenttypedescription] [varchar](150) NULL,
	[responsesitesecurity] [varchar](500) NULL,
	[token] [varchar](100) NULL,
	[requestreference] [varchar](100) NULL,
	[customerid] [bigint] NULL,
	[recordStatus] [varchar](50) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TRU_TranDetail] ADD  DEFAULT (getdate()) FOR [createddate]
GO