Tables [dbo].[InternationalShippingInformation]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created10:12:49 PM Thursday, December 28, 2006
Last Modified9:07:05 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Primary Key PK_InternationalShippingInformation: InternationalShippingInformationIDInternationalShippingInformationIDint4
No
1 - 1
Cluster Key IX_InternationalShippingInformation_OrdersFID: OrdersFIDForeign Keys FK_InternationalShippingInformation_Orders: [dbo].[Orders].OrdersFIDOrdersFIDint4
Yes
OriginLinehaulAgentFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_InternationalPort: [dbo].[InternationalPort].InternationalPortFIDInternationalPortFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_InternationalDirection: [dbo].[InternationalDirection].InternationalDirectionFIDInternationalDirectionFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_InternationalTransportationMode: [dbo].[InternationalTransportationMode].InternationalTransportationModeFIDInternationalTransportationModeFIDint4
Yes
DestinationLinehaulAgentFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_InternationalCustomsAgent: [dbo].[InternationalCustomsAgent].InternationalCustomsAgentFIDInternationalCustomsAgentFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_InternationalCarrier: [dbo].[InternationalCarrier].InternationalCarrierFIDInternationalCarrierFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_InternationalConsolidator: [dbo].[InternationalConsolidator].InternationalConsolidatorFIDInternationalConsolidatorFIDint4
Yes
BillNumbervarchar(32)32
Yes
Foreign Keys FK_InternationalShippingInformation_InternationalBillToType: [dbo].[InternationalBillToType].InternationalBillToTypeFIDInternationalBillToTypeFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_BillToAgent: [dbo].[Agent].BillToAgentFIDBillToAgentFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_ForwardingAgent: [dbo].[Agent].ForwardingAgentFIDForwardingAgentFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_InternationalServiceType: [dbo].[InternationalServiceType].InternationalServiceTypeFIDInternationalServiceTypeFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_InlandDeparturePortFID: [dbo].[InternationalPort].InlandDeparturePortFIDInlandDeparturePortFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_InlandArrivalPortFID: [dbo].[InternationalPort].InlandArrivalPortFIDInlandArrivalPortFIDint4
Yes
SecurityFilingConfirmationvarchar(32)32
Yes
CostPlusbit1
No
((0))
ReadyToBillbit1
No
((0))
ReadyToBillUploadedbit1
No
((0))
ReleasedToBillbit1
No
((0))
TariffIndicatorbit1
No
((0))
GppAppliesbit1
No
((0))
Foreign Keys FK_InternationalShippingInformation_InternationalValuationDeclinedReasonFID: [dbo].[InternationalValuationDeclinedReason].InternationalValuationDeclinedReasonFIDInternationalValuationDeclinedReasonFIDint4
Yes
CertificationNumbervarchar(64)64
Yes
DeductibleAmountmoney8
Yes
Foreign Keys FK_InternationalShippingInformation_InternationalValueTypeFID: [dbo].[InternationalValueType].InternationalValueTypeFIDInternationalValueTypeFIDint4
Yes
TotalLossCoveragebit1
No
((0))
MechanicalMalfunctionbit1
No
((0))
PairsOrSetsbit1
No
((0))
MoldOrMildewbit1
No
((0))
InsuredRatemoney8
Yes
InternalRatemoney8
Yes
BilledRatemoney8
Yes
Foreign Keys FK_InternationalShippingInformation_OriginLinehaulCarrier: [dbo].[InternationalLinehaulCarrier].OriginLinehaulCarrierFIDOriginLinehaulCarrierFIDint4
Yes
Foreign Keys FK_InternationalShippingInformation_DestinationLinehaulCarrier: [dbo].[InternationalLinehaulCarrier].DestinationLinehaulCarrierFIDDestinationLinehaulCarrierFIDint4
Yes
OverlandCarriervarchar(64)64
Yes
IncludeAutoOnCertificatebit1
No
((0))
InsuredValueForAutomoney8
Yes
BookingSalespersonIdvarchar(20)20
Yes
TrackRefCodevarchar(25)25
Yes
Indexes Indexes
NameColumnsUniqueFill Factor
Primary Key PK_InternationalShippingInformation: InternationalShippingInformationIDPK_InternationalShippingInformationInternationalShippingInformationID
Yes
80
Cluster Key IX_InternationalShippingInformation_OrdersFID: OrdersFIDIX_InternationalShippingInformation_OrdersFIDOrdersFID
Yes
Foreign Keys Foreign Keys
NameColumns
FK_InternationalShippingInformation_BillToAgentBillToAgentFID->[dbo].[Agent].[AgentPriKey]
FK_InternationalShippingInformation_DestinationLinehaulCarrierDestinationLinehaulCarrierFID->[dbo].[InternationalLinehaulCarrier].[InternationalLinehaulCarrierID]
FK_InternationalShippingInformation_ForwardingAgentForwardingAgentFID->[dbo].[Agent].[AgentPriKey]
FK_InternationalShippingInformation_InlandArrivalPortFIDInlandArrivalPortFID->[dbo].[InternationalPort].[InternationalPortID]
FK_InternationalShippingInformation_InlandDeparturePortFIDInlandDeparturePortFID->[dbo].[InternationalPort].[InternationalPortID]
FK_InternationalShippingInformation_InternationalBillToTypeInternationalBillToTypeFID->[dbo].[InternationalBillToType].[InternationalBillToTypeID]
FK_InternationalShippingInformation_InternationalCarrierInternationalCarrierFID->[dbo].[InternationalCarrier].[InternationalCarrierID]
FK_InternationalShippingInformation_InternationalConsolidatorInternationalConsolidatorFID->[dbo].[InternationalConsolidator].[InternationalConsolidatorID]
FK_InternationalShippingInformation_InternationalCustomsAgentInternationalCustomsAgentFID->[dbo].[InternationalCustomsAgent].[InternationalCustomsAgentID]
FK_InternationalShippingInformation_InternationalDirectionInternationalDirectionFID->[dbo].[InternationalDirection].[InternationalDirectionID]
FK_InternationalShippingInformation_InternationalPortInternationalPortFID->[dbo].[InternationalPort].[InternationalPortID]
FK_InternationalShippingInformation_InternationalServiceTypeInternationalServiceTypeFID->[dbo].[InternationalServiceType].[InternationalServiceTypeID]
FK_InternationalShippingInformation_InternationalTransportationModeInternationalTransportationModeFID->[dbo].[InternationalTransportationMode].[InternationalTransportationModeID]
FK_InternationalShippingInformation_InternationalValuationDeclinedReasonFIDInternationalValuationDeclinedReasonFID->[dbo].[InternationalValuationDeclinedReason].[InternationalValuationDeclinedReasonID]
FK_InternationalShippingInformation_InternationalValueTypeFIDInternationalValueTypeFID->[dbo].[InternationalValueType].[InternationalValueTypeID]
FK_InternationalShippingInformation_OrdersOrdersFID->[dbo].[Orders].[PriKey]
FK_InternationalShippingInformation_OriginLinehaulCarrierOriginLinehaulCarrierFID->[dbo].[InternationalLinehaulCarrier].[InternationalLinehaulCarrierID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[InternationalShippingInformation]
(
[InternationalShippingInformationID] [int] NOT NULL IDENTITY(1, 1),
[OrdersFID] [int] NULL,
[OriginLinehaulAgentFID] [int] NULL,
[InternationalPortFID] [int] NULL,
[InternationalDirectionFID] [int] NULL,
[InternationalTransportationModeFID] [int] NULL,
[DestinationLinehaulAgentFID] [int] NULL,
[InternationalCustomsAgentFID] [int] NULL,
[InternationalCarrierFID] [int] NULL,
[InternationalConsolidatorFID] [int] NULL,
[BillNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InternationalBillToTypeFID] [int] NULL,
[BillToAgentFID] [int] NULL,
[ForwardingAgentFID] [int] NULL,
[InternationalServiceTypeFID] [int] NULL,
[InlandDeparturePortFID] [int] NULL,
[InlandArrivalPortFID] [int] NULL,
[SecurityFilingConfirmation] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CostPlus] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_CostPlus] DEFAULT ((0)),
[ReadyToBill] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_ReadyToBill] DEFAULT ((0)),
[ReadyToBillUploaded] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_ReadyToBillUploaded] DEFAULT ((0)),
[ReleasedToBill] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_ReleasedToBill] DEFAULT ((0)),
[TariffIndicator] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_TariffIndicator] DEFAULT ((0)),
[GppApplies] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_GppApplies] DEFAULT ((0)),
[InternationalValuationDeclinedReasonFID] [int] NULL,
[CertificationNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeductibleAmount] [money] NULL,
[InternationalValueTypeFID] [int] NULL,
[TotalLossCoverage] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_TotalLossCoverage] DEFAULT ((0)),
[MechanicalMalfunction] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_MechanicalMalfunction] DEFAULT ((0)),
[PairsOrSets] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_PairsOrSets] DEFAULT ((0)),
[MoldOrMildew] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_MoldOrMildew] DEFAULT ((0)),
[InsuredRate] [money] NULL,
[InternalRate] [money] NULL,
[BilledRate] [money] NULL,
[OriginLinehaulCarrierFID] [int] NULL,
[DestinationLinehaulCarrierFID] [int] NULL,
[OverlandCarrier] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IncludeAutoOnCertificate] [bit] NOT NULL CONSTRAINT [DF_InternationalShippingInformation_IncludeAutoOnCertificate] DEFAULT ((0)),
[InsuredValueForAuto] [money] NULL,
[BookingSalespersonId] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TrackRefCode] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [PK_InternationalShippingInformation] PRIMARY KEY NONCLUSTERED  ([InternationalShippingInformationID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [IX_InternationalShippingInformation_OrdersFID] UNIQUE CLUSTERED  ([OrdersFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_BillToAgent] FOREIGN KEY ([BillToAgentFID]) REFERENCES [dbo].[Agent] ([AgentPriKey])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_DestinationLinehaulCarrier] FOREIGN KEY ([DestinationLinehaulCarrierFID]) REFERENCES [dbo].[InternationalLinehaulCarrier] ([InternationalLinehaulCarrierID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_ForwardingAgent] FOREIGN KEY ([ForwardingAgentFID]) REFERENCES [dbo].[Agent] ([AgentPriKey])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InlandArrivalPortFID] FOREIGN KEY ([InlandArrivalPortFID]) REFERENCES [dbo].[InternationalPort] ([InternationalPortID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InlandDeparturePortFID] FOREIGN KEY ([InlandDeparturePortFID]) REFERENCES [dbo].[InternationalPort] ([InternationalPortID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalBillToType] FOREIGN KEY ([InternationalBillToTypeFID]) REFERENCES [dbo].[InternationalBillToType] ([InternationalBillToTypeID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalCarrier] FOREIGN KEY ([InternationalCarrierFID]) REFERENCES [dbo].[InternationalCarrier] ([InternationalCarrierID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalConsolidator] FOREIGN KEY ([InternationalConsolidatorFID]) REFERENCES [dbo].[InternationalConsolidator] ([InternationalConsolidatorID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalCustomsAgent] FOREIGN KEY ([InternationalCustomsAgentFID]) REFERENCES [dbo].[InternationalCustomsAgent] ([InternationalCustomsAgentID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalDirection] FOREIGN KEY ([InternationalDirectionFID]) REFERENCES [dbo].[InternationalDirection] ([InternationalDirectionID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalPort] FOREIGN KEY ([InternationalPortFID]) REFERENCES [dbo].[InternationalPort] ([InternationalPortID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalServiceType] FOREIGN KEY ([InternationalServiceTypeFID]) REFERENCES [dbo].[InternationalServiceType] ([InternationalServiceTypeID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalTransportationMode] FOREIGN KEY ([InternationalTransportationModeFID]) REFERENCES [dbo].[InternationalTransportationMode] ([InternationalTransportationModeID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalValuationDeclinedReasonFID] FOREIGN KEY ([InternationalValuationDeclinedReasonFID]) REFERENCES [dbo].[InternationalValuationDeclinedReason] ([InternationalValuationDeclinedReasonID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_InternationalValueTypeFID] FOREIGN KEY ([InternationalValueTypeFID]) REFERENCES [dbo].[InternationalValueType] ([InternationalValueTypeID])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_Orders] FOREIGN KEY ([OrdersFID]) REFERENCES [dbo].[Orders] ([PriKey])
GO
ALTER TABLE [dbo].[InternationalShippingInformation] ADD CONSTRAINT [FK_InternationalShippingInformation_OriginLinehaulCarrier] FOREIGN KEY ([OriginLinehaulCarrierFID]) REFERENCES [dbo].[InternationalLinehaulCarrier] ([InternationalLinehaulCarrierID])
GO
GRANT SELECT ON  [dbo].[InternationalShippingInformation] TO [MssExec]
GRANT INSERT ON  [dbo].[InternationalShippingInformation] TO [MssExec]
GRANT DELETE ON  [dbo].[InternationalShippingInformation] TO [MssExec]
GRANT UPDATE ON  [dbo].[InternationalShippingInformation] TO [MssExec]
GO
Uses
Used By