CREATE TABLE [dbo].[ARHReceiptDetails]
(
[HReceiptID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[HInvoiceID] [int] NULL,
[HInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TermDiscount] [money] NULL,
[Amount] [money] NULL,
[HSalesTaxCreditMemoID] [int] NULL,
[HSalesTaxCreditMemoInvoiceNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARHReceiptDetails] ADD CONSTRAINT [PK_ARHReceiptDetails] PRIMARY KEY CLUSTERED ([HReceiptID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARHReceiptDetails] ADD CONSTRAINT [FK_ARHReceiptDetails_HInvoiceID_ARHInvoices] FOREIGN KEY ([HInvoiceID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[ARHReceiptDetails] ADD CONSTRAINT [FK_ARHReceiptDetails_HReceiptID_ARHReceipts] FOREIGN KEY ([HReceiptID]) REFERENCES [dbo].[ARHReceipts] ([HReceiptID])
GO
ALTER TABLE [dbo].[ARHReceiptDetails] ADD CONSTRAINT [FK_ARHReceiptDetails_HSalesTaxCreditMemoID_ARHInvoices] FOREIGN KEY ([HSalesTaxCreditMemoID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO