Tables [dbo].[ICTransferOrders]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:48 AM Thursday, March 21, 2019
Last Modified1:12:19 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_ICTransferOrders: TOIDTOIDint4
False
1 - 1
TONumbervarchar(15)15
False
Foreign Keys FK_ICTransferOrders_AgentID_ShAgents: [dbo].[ShAgents].AgentIDAgentIDint4
True
Datedatetime8
False
Descriptionvarchar(255)255
False
ReqDatedatetime8
True
ShipToTypeIDint4
True
ShipToIDint4
True
Foreign Keys FK_ICTransferOrders_SourceWarehouseID_ICWarehouses: [dbo].[ICWarehouses].SourceWarehouseIDSourceWarehouseIDint4
False
ShipToNamevarchar(128)128
False
('')
ShipToAttnvarchar(64)64
False
('')
ShipToAddressvarchar(64)64
False
('')
ShipToCityvarchar(64)64
False
('')
ShipToStatevarchar(64)64
False
('')
ShipToZipvarchar(64)64
False
('')
ShipToCountryvarchar(64)64
False
('')
Foreign Keys FK_ICTransferOrders_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Remarksvarchar(255)255
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
Batchvarchar(15)15
True
Foreign Keys FK_ICTransferOrders_DestWarehouseID_ICWarehouses: [dbo].[ICWarehouses].DestWarehouseIDDestWarehouseIDint4
True
Lockedbit1
False
((0))
Foreign Keys FK_ICTransferOrders_NoteID_ICTransferOrderNotes: [dbo].[ICTransferOrderNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
RTSourceTechnicianIDint4
True
RTDestTechnicianIDint4
True
NoteCountint4
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ICTransferOrders: TOIDPK_ICTransferOrdersTOID
True
80
NameColumns
FK_ICTransferOrders_AgentID_ShAgentsAgentID->[dbo].[ShAgents].[AgentID]
FK_ICTransferOrders_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ICTransferOrders_DestWarehouseID_ICWarehousesDestWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_ICTransferOrders_NoteID_ICTransferOrderNotesNoteID->[dbo].[ICTransferOrderNotes].[NoteID]
FK_ICTransferOrders_SourceWarehouseID_ICWarehousesSourceWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
CREATE TABLE [dbo].[ICTransferOrders]
(
[TOID] [int] NOT NULL IDENTITY(1, 1),
[TONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AgentID] [int] NULL,
[Date] [datetime] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReqDate] [datetime] NULL,
[ShipToTypeID] [int] NULL,
[ShipToID] [int] NULL,
[SourceWarehouseID] [int] NOT NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToName] DEFAULT (''),
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToAttn] DEFAULT (''),
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToAddress] DEFAULT (''),
[ShipToCity] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToCity] DEFAULT (''),
[ShipToState] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToState] DEFAULT (''),
[ShipToZip] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToZip] DEFAULT (''),
[ShipToCountry] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToCountry] DEFAULT (''),
[BranchID] [int] NOT NULL,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS 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_ICTransferOrders_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICTransferOrders_LastUpdate] DEFAULT (getdate()),
[Batch] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestWarehouseID] [int] NULL,
[Locked] [bit] NOT NULL CONSTRAINT [DF_ICTransferOrders_Locked] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_ICTransferOrders_NoteFlag] DEFAULT ((0)),
[RTSourceTechnicianID] [int] NULL,
[RTDestTechnicianID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_ICTransferOrders_NoteCount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [PK_ICTransferOrders] PRIMARY KEY CLUSTERED  ([TOID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_AgentID_ShAgents] FOREIGN KEY ([AgentID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_DestWarehouseID_ICWarehouses] FOREIGN KEY ([DestWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_NoteID_ICTransferOrderNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[ICTransferOrderNotes] ([NoteID])
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_SourceWarehouseID_ICWarehouses] FOREIGN KEY ([SourceWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO