CREATE TABLE [dbo].[POHReceipts]
(
[HReceiptID] [int] NOT NULL,
[HReceiptNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorID] [int] NULL,
[VendorName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JobID] [int] NULL,
[JobNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL,
[DatePeriod] [int] NULL,
[Period] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Total] [money] NULL,
[UnVouchered] [money] NULL,
[TransactionTypeID] [int] NULL,
[TransactionType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Reversal] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POHReceipts] ADD CONSTRAINT [PK_POHReceipts] PRIMARY KEY CLUSTERED ([HReceiptID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POHReceipts] ADD CONSTRAINT [FK_POHReceipts_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[POHReceipts] ADD CONSTRAINT [FK_POHReceipts_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO