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