Tables [dbo].[SOInvoices]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:55 AM Thursday, March 21, 2019
Last Modified1:15:55 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SOInvoices: InvoiceIDForeign Keys FK_SOInvoices_InvoiceID_ARInvoices: [dbo].[ARInvoices].InvoiceIDInvoiceIDint4
False
Foreign Keys FK_SOInvoices_PicketID_SOPickets: [dbo].[SOPickets].PicketIDPicketIDint4
True
SONumbervarchar(15)15
False
Foreign Keys FK_SOInvoices_ShipMethodID_ShShipMethods: [dbo].[ShShipMethods].ShipMethodIDShipMethodIDint4
True
Foreign Keys FK_SOInvoices_JobID_ICJobs: [dbo].[ICJobs].JobIDJobIDint4
True
ShipDatedatetime8
True
Foreign Keys FK_SOInvoices_FulfillID_SOFulfills: [dbo].[SOFulfills].FulfillIDFulfillIDint4
True
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
Foreign Keys FK_SOInvoices_OnHoldCodeID_ShOnHoldCodes: [dbo].[ShOnHoldCodes].OnHoldCodeIDOnHoldCodeIDint4
True
OnHoldReleaserIDvarchar(8)8
True
Foreign Keys FK_SOInvoices_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SOInvoices_ARBranchID_GLBranches: [dbo].[GLBranches].ARBranchIDARBranchIDint4
False
EasyMergebit1
False
((0))
DetailCountint4
False
((0))
FulfillDetailCountint4
False
((0))
FulfillJournalIDint4
True
InvoiceJournalIDint4
True
Mergedbit1
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SOInvoices: InvoiceIDPK_SOInvoicesInvoiceID
True
80
NameNo CheckColumns
FK_SOInvoices_ARBranchID_GLBranchesARBranchID->[dbo].[GLBranches].[BranchID]
FK_SOInvoices_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SOInvoices_FulfillID_SOFulfillsFulfillID->[dbo].[SOFulfills].[FulfillID]
FK_SOInvoices_InvoiceID_ARInvoices
True
InvoiceID->[dbo].[ARInvoices].[InvoiceID]
FK_SOInvoices_JobID_ICJobsJobID->[dbo].[ICJobs].[JobID]
FK_SOInvoices_OnHoldCodeID_ShOnHoldCodesOnHoldCodeID->[dbo].[ShOnHoldCodes].[OnHoldCodeID]
FK_SOInvoices_PicketID_SOPicketsPicketID->[dbo].[SOPickets].[PicketID]
FK_SOInvoices_ShipMethodID_ShShipMethodsShipMethodID->[dbo].[ShShipMethods].[ShipMethodID]
CREATE TABLE [dbo].[SOInvoices]
(
[InvoiceID] [int] NOT NULL,
[PicketID] [int] NULL,
[SONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipMethodID] [int] NULL,
[JobID] [int] NULL,
[ShipDate] [datetime] NULL,
[FulfillID] [int] NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SOInvoices_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOInvoices_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[OnHoldCodeID] [int] NULL,
[OnHoldReleaserID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [int] NOT NULL,
[ARBranchID] [int] NOT NULL,
[EasyMerge] [bit] NOT NULL CONSTRAINT [DF_SOInvoices_EasyMerge] DEFAULT ((0)),
[DetailCount] [int] NOT NULL CONSTRAINT [DF_SOInvoices_DetailCount] DEFAULT ((0)),
[FulfillDetailCount] [int] NOT NULL CONSTRAINT [DF_SOInvoices_FulfillDetailCount] DEFAULT ((0)),
[FulfillJournalID] [int] NULL,
[InvoiceJournalID] [int] NULL,
[Merged] [bit] NOT NULL CONSTRAINT [DF_SOInvoices_Merged] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [PK_SOInvoices] PRIMARY KEY CLUSTERED  ([InvoiceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_ARBranchID_GLBranches] FOREIGN KEY ([ARBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_FulfillID_SOFulfills] FOREIGN KEY ([FulfillID]) REFERENCES [dbo].[SOFulfills] ([FulfillID])
GO
ALTER TABLE [dbo].[SOInvoices] WITH NOCHECK ADD CONSTRAINT [FK_SOInvoices_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_PicketID_SOPickets] FOREIGN KEY ([PicketID]) REFERENCES [dbo].[SOPickets] ([PicketID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_ShipMethodID_ShShipMethods] FOREIGN KEY ([ShipMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO