Tables [dbo].[ARHReceiptDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:45 AM Thursday, March 21, 2019
Last Modified1:10:12 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_ARHReceiptDetails: HReceiptID\DetailIDForeign Keys FK_ARHReceiptDetails_HReceiptID_ARHReceipts: [dbo].[ARHReceipts].HReceiptIDHReceiptIDint4
False
Cluster Primary Key PK_ARHReceiptDetails: HReceiptID\DetailIDDetailIDint4
False
Foreign Keys FK_ARHReceiptDetails_HInvoiceID_ARHInvoices: [dbo].[ARHInvoices].HInvoiceIDHInvoiceIDint4
True
HInvoiceNumbervarchar(32)32
True
TermDiscountmoney8
True
Amountmoney8
True
Foreign Keys FK_ARHReceiptDetails_HSalesTaxCreditMemoID_ARHInvoices: [dbo].[ARHInvoices].HSalesTaxCreditMemoIDHSalesTaxCreditMemoIDint4
True
HSalesTaxCreditMemoInvoiceNumbervarchar(15)15
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ARHReceiptDetails: HReceiptID\DetailIDPK_ARHReceiptDetailsHReceiptID, DetailID
True
80
NameColumns
FK_ARHReceiptDetails_HInvoiceID_ARHInvoicesHInvoiceID->[dbo].[ARHInvoices].[HInvoiceID]
FK_ARHReceiptDetails_HReceiptID_ARHReceiptsHReceiptID->[dbo].[ARHReceipts].[HReceiptID]
FK_ARHReceiptDetails_HSalesTaxCreditMemoID_ARHInvoicesHSalesTaxCreditMemoID->[dbo].[ARHInvoices].[HInvoiceID]
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