CREATE TABLE [dbo].[APHVouchers]
(
[HVoucherID] [int] NOT NULL,
[HVoucherNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorID] [int] NULL,
[VendorName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HApplyToID] [int] NULL,
[HApplyToVoucherNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceNumber] [varchar] (32) 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,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TermID] [int] NULL,
[Term] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TermDiscountRate] [float] NULL,
[TermDiscountDate] [datetime] NULL,
[TermDiscount] [money] NULL,
[DueDate] [datetime] NULL,
[PurchaserID] [int] NULL,
[Purchaser] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JobID] [int] NULL,
[JobNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Total] [money] NULL,
[AdjTotal] [money] NULL,
[Due] [money] NULL,
[Checks] [money] NULL,
[Module] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Source] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Reference] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionTypeID] [int] NULL,
[TransactionType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HVoidID] [int] NULL,
[HVoidVoucherNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [int] NULL,
[BranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APBranchID] [int] NULL,
[APBranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OnHoldCodeID] [int] NULL,
[OnHoldCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [PK_APHVouchers] PRIMARY KEY CLUSTERED ([HVoucherID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_APBranchID_GLBranches] FOREIGN KEY ([APBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_HApplyToID_APHVouchers] FOREIGN KEY ([HApplyToID]) REFERENCES [dbo].[APHVouchers] ([HVoucherID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_HVoidID_APHVouchers] FOREIGN KEY ([HVoidID]) REFERENCES [dbo].[APHVouchers] ([HVoucherID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_JobID_APJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[APJobs] ([JobID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_PurchaserID_APPurchasers] FOREIGN KEY ([PurchaserID]) REFERENCES [dbo].[APPurchasers] ([PurchaserID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[APHVouchers] ADD CONSTRAINT [FK_APHVouchers_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO