CREATE TABLE [dbo].[POQOrders]
(
[POQID] [int] NOT NULL IDENTITY(1, 1),
[PONumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POQOrders_PONumber] DEFAULT ((0)),
[POMajor] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POQOrders_POMajor] DEFAULT ((0)),
[POMinor] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VendorID] [int] NOT NULL,
[Date] [datetime] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReqDate] [datetime] NULL,
[TermID] [int] NULL,
[TermDiscountRate] [float] NOT NULL CONSTRAINT [DF_POQOrders_TermDiscountRate] DEFAULT ((0)),
[TermDiscountDate] [datetime] NULL,
[DueDate] [datetime] NOT NULL,
[ShipMethodID] [int] NULL,
[JobID] [int] NULL,
[PurchaserID] [int] NULL,
[OrderToName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OrderToAddress] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OrderToCity] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OrderToState] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OrderToZip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OrderToCountry] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToTypeID] [int] NOT NULL,
[ShipToID] [int] NULL,
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CallID] [int] NULL,
[ClaimNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ABCDNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GLID] [int] NOT NULL,
[Total] [money] NOT NULL CONSTRAINT [DF_POQOrders_Total] DEFAULT ((0)),
[UnReceived] [money] NOT NULL CONSTRAINT [DF_POQOrders_UnReceived] DEFAULT ((0)),
[ApprovedByID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApprovedByDate] [datetime] NULL,
[Locked] [bit] NOT NULL CONSTRAINT [DF_POQOrders_Locked] DEFAULT ((0)),
[Revised] [bit] NOT NULL CONSTRAINT [DF_POQOrders_Revised] DEFAULT ((0)),
[BranchID] [int] NOT NULL,
[RemitBranchID] [int] NOT 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_POQOrders_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_POQOrders_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_POQOrders_DBFileHeaderID] DEFAULT ((1)),
[ExportModule] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EstArrivalDate] [datetime] NULL,
[EstShipDate] [datetime] NULL,
[WarehouseID] [int] NULL,
[BinID] [int] NULL,
[OrderTypeID] [int] NOT NULL CONSTRAINT [DF_POQOrders_OrderTypeID] DEFAULT ((1)),
[BaseTypeID] [int] NOT NULL CONSTRAINT [DF_POQOrders_BaseTypeID] DEFAULT ((1)),
[StatusID] [int] NOT NULL CONSTRAINT [DF_POQOrders_StatusID] DEFAULT ((1)),
[DetailStatusID] [int] NOT NULL CONSTRAINT [DF_POQOrders_DetailStatusID] DEFAULT ((1)),
[ReturnDetailStatusID] [int] NOT NULL CONSTRAINT [DF_POQOrders_ReturnDetailStatusID] DEFAULT ((1)),
[SendMethodID] [tinyint] NOT NULL CONSTRAINT [DF_POQOrders_SendMethodID] DEFAULT ((1)),
[SendStatusID] [int] NOT NULL CONSTRAINT [DF_POQOrders_SendStatusID] DEFAULT ((1)),
[Sent] [int] NOT NULL CONSTRAINT [DF_POQOrders_Sent] DEFAULT ((0)),
[SendAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POQOrders_SendAddress] DEFAULT (''),
[SendContactID] [int] NULL,
[DoSend] [int] NOT NULL CONSTRAINT [DF_POQOrders_DoSend] DEFAULT ((0)),
[VendorConfirmationNumber] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [PK_POQOrders] PRIMARY KEY CLUSTERED ([POQID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_GLID_GLAccounts3] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_OrderTypeID_POOrderTypes] FOREIGN KEY ([OrderTypeID]) REFERENCES [dbo].[POOrderTypes] ([OrderTypeID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_PurchaserID_APPurchasers] FOREIGN KEY ([PurchaserID]) REFERENCES [dbo].[APPurchasers] ([PurchaserID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_RemitBranchID_GLBranches] FOREIGN KEY ([RemitBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_SendContactID_CMContacts] FOREIGN KEY ([SendContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_SendMethodID_SHDocSendMethods] FOREIGN KEY ([SendMethodID]) REFERENCES [dbo].[SHDocSendMethods] ([DocSendMethodID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_SendStatusID_SHDocSendStatuses] FOREIGN KEY ([SendStatusID]) REFERENCES [dbo].[SHDocSendStatuses] ([DocSendStatusID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_ShipMethodID_ShShipMethods] FOREIGN KEY ([ShipMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_StatusID_POStatuses] FOREIGN KEY ([StatusID]) REFERENCES [dbo].[POStatuses] ([StatusID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO
ALTER TABLE [dbo].[POQOrders] ADD CONSTRAINT [FK_POQOrders_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO