Tables [dbo].[ARHInvoices]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:45 AM Thursday, March 21, 2019
Last Modified1:15:50 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_ARHInvoices: HInvoiceIDHInvoiceIDint4
False
HInvoiceNumbervarchar(32)32
True
Typechar(2)2
True
Foreign Keys FK_ARHInvoices_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
True
CustomerNamevarchar(255)255
True
Foreign Keys FK_ARHInvoices_BillToID_ARCustomers: [dbo].[ARCustomers].BillToIDBillToIDint4
True
BillToNamevarchar(255)255
True
Foreign Keys FK_ARHInvoices_HApplyToID_ARHInvoices: [dbo].[ARHInvoices].HApplyToIDHApplyToIDint4
True
HApplyToInvoiceNumbervarchar(32)32
True
Foreign Keys FK_ARHInvoices_HMasterInvoiceID_ARHInvoices: [dbo].[ARHInvoices].HMasterInvoiceIDHMasterInvoiceIDint4
True
HMasterInvoiceNumbervarchar(32)32
True
Datedatetime8
True
DatePeriodint4
True
Periodint4
True
Descriptionvarchar(255)255
True
PONumbervarchar(32)32
True
Foreign Keys FK_ARHInvoices_TermID_ShTerms: [dbo].[ShTerms].TermIDTermIDint4
True
Termvarchar(15)15
True
TermDiscountRatefloat8
True
TermDiscountDatedatetime8
True
TermDiscountmoney8
True
DueDatedatetime8
True
Foreign Keys FK_ARHInvoices_SalesRepID_ARSalesReps: [dbo].[ARSalesReps].SalesRepIDSalesRepIDint4
True
SalesRepvarchar(50)50
True
MailToAttnvarchar(64)64
True
MailToNamevarchar(128)128
True
MailToAddressvarchar(64)64
True
MailToCityvarchar(32)32
True
MailToStatevarchar(16)16
True
MailToZipvarchar(16)16
True
MailToCountryvarchar(16)16
True
ShipToAttnvarchar(64)64
True
ShipToNamevarchar(128)128
True
ShipToAddressvarchar(64)64
True
ShipToCityvarchar(32)32
True
ShipToStatevarchar(16)16
True
ShipToZipvarchar(16)16
True
ShipToCountryvarchar(16)16
True
Remarksvarchar(1024)1024
True
DiscountRatefloat8
True
Discountmoney8
True
Freightmoney8
True
Foreign Keys FK_ARHInvoices_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
TaxCodevarchar(15)15
True
Taxmoney8
True
Totalmoney8
True
AdjTotalmoney8
True
Duemoney8
True
Foreign Keys FK_ARHInvoices_HVoidID_ARHInvoices: [dbo].[ARHInvoices].HVoidIDHVoidIDint4
True
HVoidInvoiceNumbervarchar(32)32
True
Modulechar(4)4
True
Sourcevarchar(15)15
True
Referencevarchar(15)15
True
Foreign Keys FK_ARHInvoices_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
True
LocationNamevarchar(255)255
True
Foreign Keys FK_ARHInvoices_TransactionTypeID_SHTransactionTypes: [dbo].[ShTransactionTypes].TransactionTypeIDTransactionTypeIDint4
True
TransactionTypevarchar(64)64
True
Foreign Keys FK_ARHInvoices_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
True
BranchNamevarchar(50)50
True
Foreign Keys FK_ARHInvoices_ARBranchID_GLBranches: [dbo].[GLBranches].ARBranchIDARBranchIDint4
True
ARBranchNamevarchar(50)50
True
Foreign Keys FK_ARHInvoices_ChargeMethodID_ARChargeMethods: [dbo].[ARChargeMethods].ChargeMethodIDChargeMethodIDint4
True
ChargeMethodvarchar(64)64
True
ChargeAccountInfovarchar(64)64
True
Taxablebit1
True
Consolidatebit1
True
ConsolidatedBillingIDint4
True
BillingNumbervarchar(35)35
True
Voidbit1
True
Sentbit1
True
Foreign Keys FK_ARHInvoices_OrderedByContactID_CMContacts: [dbo].[CMContacts].OrderedByContactIDOrderedByContactIDint4
True
OrderedByContactvarchar(50)50
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ARHInvoices: HInvoiceIDPK_ARHInvoicesHInvoiceID
True
80
NameColumns
FK_ARHInvoices_ARBranchID_GLBranchesARBranchID->[dbo].[GLBranches].[BranchID]
FK_ARHInvoices_BillToID_ARCustomersBillToID->[dbo].[ARCustomers].[CustomerID]
FK_ARHInvoices_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ARHInvoices_ChargeMethodID_ARChargeMethodsChargeMethodID->[dbo].[ARChargeMethods].[ChargeMethodID]
FK_ARHInvoices_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_ARHInvoices_HApplyToID_ARHInvoicesHApplyToID->[dbo].[ARHInvoices].[HInvoiceID]
FK_ARHInvoices_HMasterInvoiceID_ARHInvoicesHMasterInvoiceID->[dbo].[ARHInvoices].[HInvoiceID]
FK_ARHInvoices_HVoidID_ARHInvoicesHVoidID->[dbo].[ARHInvoices].[HInvoiceID]
FK_ARHInvoices_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
FK_ARHInvoices_OrderedByContactID_CMContactsOrderedByContactID->[dbo].[CMContacts].[ContactID]
FK_ARHInvoices_SalesRepID_ARSalesRepsSalesRepID->[dbo].[ARSalesReps].[SalesRepID]
FK_ARHInvoices_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_ARHInvoices_TermID_ShTermsTermID->[dbo].[ShTerms].[TermID]
FK_ARHInvoices_TransactionTypeID_SHTransactionTypesTransactionTypeID->[dbo].[ShTransactionTypes].[TransactionTypeID]
CREATE TABLE [dbo].[ARHInvoices]
(
[HInvoiceID] [int] NOT NULL,
[HInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[CustomerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToID] [int] NULL,
[BillToName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HApplyToID] [int] NULL,
[HApplyToInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HMasterInvoiceID] [int] NULL,
[HMasterInvoiceNumber] [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,
[SalesRepID] [int] NULL,
[SalesRep] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DiscountRate] [float] NULL,
[Discount] [money] NULL,
[Freight] [money] NULL,
[TaxCodeID] [int] NULL,
[TaxCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax] [money] NULL,
[Total] [money] NULL,
[AdjTotal] [money] NULL,
[Due] [money] NULL,
[HVoidID] [int] NULL,
[HVoidInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
[LocationID] [int] NULL,
[LocationName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionTypeID] [int] NULL,
[TransactionType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [int] NULL,
[BranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ARBranchID] [int] NULL,
[ARBranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ChargeMethodID] [int] NULL,
[ChargeMethod] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ChargeAccountInfo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Taxable] [bit] NULL,
[Consolidate] [bit] NULL,
[ConsolidatedBillingID] [int] NULL,
[BillingNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Void] [bit] NULL,
[Sent] [bit] NULL,
[OrderedByContactID] [int] NULL,
[OrderedByContact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [PK_ARHInvoices] PRIMARY KEY CLUSTERED  ([HInvoiceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_ARBranchID_GLBranches] FOREIGN KEY ([ARBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_HApplyToID_ARHInvoices] FOREIGN KEY ([HApplyToID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_HMasterInvoiceID_ARHInvoices] FOREIGN KEY ([HMasterInvoiceID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_HVoidID_ARHInvoices] FOREIGN KEY ([HVoidID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_OrderedByContactID_CMContacts] FOREIGN KEY ([OrderedByContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_TransactionTypeID_SHTransactionTypes] FOREIGN KEY ([TransactionTypeID]) REFERENCES [dbo].[ShTransactionTypes] ([TransactionTypeID])
GO