Tables [dbo].[UPSShipment]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:55 AM Thursday, March 21, 2019
Last Modified1:00:55 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
VoidIndicatornchar(10)20
True
ServiceTypevarchar(20)20
True
LeadTrackingNumbervarchar(50)50
True
ShipmentIDvarchar(50)50
True
ActualWeightnvarchar(50)100
True
CODOptionvarchar(15)15
True
CODChargevarchar(50)50
True
CallTagRefNumbervarchar(50)50
True
PkgTrackingNumbervarchar(50)50
True
PkgWeightnvarchar(50)100
True
CollectionDateTimeCharvarchar(50)50
True
Ref1_OrderNumbervarchar(30)30
True
Ref2_InvoiceNumbervarchar(30)30
True
Ref3_ShipmentIDvarchar(30)30
True
ShipmentNotesvarchar(128)128
True
CollectionDatedatetime8
True
FreightCostmoney8
True
SourceTypevarchar(32)32
True
CallIDvarchar(32)32
True
TOIDvarchar(32)32
True
CREATE TABLE [dbo].[UPSShipment]
(
[VoidIndicator] [nchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServiceType] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LeadTrackingNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipmentID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActualWeight] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CODOption] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CODCharge] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallTagRefNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PkgTrackingNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PkgWeight] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CollectionDateTimeChar] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ref1_OrderNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ref2_InvoiceNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ref3_ShipmentID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipmentNotes] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CollectionDate] [datetime] NULL,
[FreightCost] [money] NULL,
[SourceType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TOID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO