CREATE TABLE [dbo].[POOrders]
(
[POID] [int] NOT NULL,
[PONumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS 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_POOrders_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,
[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_POOrders_Total] DEFAULT ((0)),
[UnReceived] [money] NOT NULL CONSTRAINT [DF_POOrders_UnReceived] DEFAULT ((0)),
[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_POOrders_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_POOrders_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[POMajor] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_POMajor] DEFAULT ('0'),
[POMinor] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_POMinor] DEFAULT ('0'),
[ApprovedByID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApprovedByDate] [datetime] NULL,
[Locked] [bit] NOT NULL CONSTRAINT [DF_POOrders_Locked] DEFAULT ((0)),
[Revised] [bit] NOT NULL CONSTRAINT [DF_POOrders_Revised] DEFAULT ((0)),
[BranchID] [int] NOT NULL,
[RemitBranchID] [int] NOT NULL,
[ShipToTypeID] [int] NOT NULL CONSTRAINT [DF_POOrders_ShipToTypeID] DEFAULT ((1)),
[ShipToID] [int] NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_POOrders_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,
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_POOrders_NoteFlag] DEFAULT ((0)),
[OrderTypeID] [int] NOT NULL CONSTRAINT [DF_POOrders_OrderTypeID] DEFAULT ((1)),
[ShTrackingConfigID] [int] NULL,
[BaseTypeID] [int] NOT NULL CONSTRAINT [DF_POOrders_BaseTypeID] DEFAULT ((1)),
[StatusID] [int] NOT NULL CONSTRAINT [DF_POOrders_StatusID] DEFAULT ((1)),
[DetailStatusID] [int] NOT NULL CONSTRAINT [DF_POOrders_DetailStatusID] DEFAULT ((0)),
[ReturnDetailStatusID] [int] NOT NULL CONSTRAINT [DF_POOrders_ReturnDetailStatusID] DEFAULT ((0)),
[OnHold] [bit] NOT NULL CONSTRAINT [DF_POOrders_OnHold] DEFAULT ((0)),
[OnHoldCodeID] [int] NULL,
[ReturnMethodID] [int] NULL,
[ReturnWarehouseID] [int] NULL,
[VendorRMANumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_VendorRMANumber] DEFAULT (''),
[ShipFromAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_ShipFromAttn] DEFAULT (''),
[ShipFromName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_ShipFromName] DEFAULT (''),
[ShipFromAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_ShipFromAddress] DEFAULT (''),
[ShipFromCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_ShipFromCity] DEFAULT (''),
[ShipFromState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_ShipFromState] DEFAULT (''),
[ShipFromZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_ShipFromZip] DEFAULT (''),
[ShipFromCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_ShipFromCountry] DEFAULT (''),
[ShipFromTypeID] [int] NOT NULL CONSTRAINT [DF_POOrders_ShipFromTypeID] DEFAULT ((1)),
[ShipFromID] [int] NULL,
[SendMethodID] [tinyint] NOT NULL CONSTRAINT [DF_POOrders_SendMethodID] DEFAULT ((1)),
[SendStatusID] [int] NOT NULL CONSTRAINT [DF_POOrders_SendStatusID] DEFAULT ((1)),
[Sent] [int] NOT NULL CONSTRAINT [DF_POOrders_Sent] DEFAULT ((0)),
[SendAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrders_SendAddress] DEFAULT (''),
[SendContactID] [int] NULL,
[DoSend] [int] NOT NULL CONSTRAINT [DF_POOrders_DoSend] DEFAULT ((0)),
[VendorConfirmationNumber] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_POOrders_NoteCount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [PK_POOrders] PRIMARY KEY CLUSTERED ([POID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_DetailStatusID_PODetailStatuses] FOREIGN KEY ([DetailStatusID]) REFERENCES [dbo].[PODetailStatuses] ([DetailStatusID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_GLID_GLAccounts3] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_NoteID_POOrderNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[POOrderNotes] ([NoteID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_OrderTypeID_POOrderTypes] FOREIGN KEY ([OrderTypeID]) REFERENCES [dbo].[POOrderTypes] ([OrderTypeID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_PurchaserID_APPurchasers] FOREIGN KEY ([PurchaserID]) REFERENCES [dbo].[APPurchasers] ([PurchaserID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_RemitBranchID_GLBranches] FOREIGN KEY ([RemitBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_ReturnDetailStatusID_PODetailStatuses] FOREIGN KEY ([ReturnDetailStatusID]) REFERENCES [dbo].[PODetailStatuses] ([DetailStatusID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_ReturnMethodID_ShShipMethods] FOREIGN KEY ([ReturnMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_ReturnWarehouseID_ICWarehouses] FOREIGN KEY ([ReturnWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_SendContactID_CMContacts] FOREIGN KEY ([SendContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_SendMethodID_SHDocSendMethods] FOREIGN KEY ([SendMethodID]) REFERENCES [dbo].[SHDocSendMethods] ([DocSendMethodID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_SendStatusID_SHDocSendStatuses] FOREIGN KEY ([SendStatusID]) REFERENCES [dbo].[SHDocSendStatuses] ([DocSendStatusID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_ShipMethodID_ShShipMethods] FOREIGN KEY ([ShipMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_StatusID_POStatuses] FOREIGN KEY ([StatusID]) REFERENCES [dbo].[POStatuses] ([StatusID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO
ALTER TABLE [dbo].[POOrders] ADD CONSTRAINT [FK_POOrders_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO