Tables [dbo].[SHExportModulePSNInvoices]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:42 AM Thursday, March 21, 2019
Last Modified1:09:36 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SHExportModulePSNInvoices_InvoiceItemID: InvoiceItemIDInvoiceItemIDint4
False
1 - 1
InvoiceIDint4
False
PSNVendorIDint4
False
InvoiceNumbervarchar(32)32
True
InvoiceDatedatetime8
True
PONumbervarchar(32)32
True
MfgNumbervarchar(25)25
True
ItemNumbervarchar(25)25
True
Quantityint4
True
Costdecimal(14,2)9
True
IsFreightbit1
False
((0))
IsMiscbit1
False
((0))
Descriptionvarchar(64)64
True
Invoicedint4
False
((0))
UnInvoicableint4
False
((0))
CreateDatedatetime8
False
(getdate())
KeyNameKey ColumnsUnique
Cluster Primary Key PK_SHExportModulePSNInvoices_InvoiceItemID: InvoiceItemIDPK_SHExportModulePSNInvoices_InvoiceItemIDInvoiceItemID
True
CREATE TABLE [dbo].[SHExportModulePSNInvoices]
(
[InvoiceItemID] [int] NOT NULL IDENTITY(1, 1),
[InvoiceID] [int] NOT NULL,
[PSNVendorID] [int] NOT NULL,
[InvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceDate] [datetime] NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MfgNumber] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItemNumber] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quantity] [int] NULL,
[Cost] [decimal] (14, 2) NULL,
[IsFreight] [bit] NOT NULL CONSTRAINT [DF_SHExportModulePSNInvoices_IsFreight] DEFAULT ((0)),
[IsMisc] [bit] NOT NULL CONSTRAINT [DF_SHExportModulePSNInvoices_IsMisc] DEFAULT ((0)),
[Description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Invoiced] [int] NOT NULL CONSTRAINT [DF_SHExportModulePSNInvoices_Invoiced] DEFAULT ((0)),
[UnInvoicable] [int] NOT NULL CONSTRAINT [DF_SHExportModulePSNInvoices_UnInvoicable] DEFAULT ((0)),
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SHExportModulePSNInvoices_CreateDate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHExportModulePSNInvoices] ADD CONSTRAINT [PK_SHExportModulePSNInvoices_InvoiceItemID] PRIMARY KEY CLUSTERED  ([InvoiceItemID]) ON [PRIMARY]
GO