Page Comparison

How To set Up Carrier to TMS.doc

New TMS carrier setup.

SupplyStream UAT: https://ss-ihub-uat-web.azurewebsites.net/

SupplyStream Live: https://www.supplystream.com/

Log into SupplyStream using an admin account.

Select Admin>Carriers>Carrier List

Image Added

Click Create New button.

Image Added

Enter the Carrier Code and Description/Carrier Name then click Save button.

Image Added

Image Added

Now add the carrier to all relevant customers.

Select Admin>Carriers>Carrier Company Access.

Image Added

Click Create New button.

Image Added

Select the company who need access to the carrier then click Add & Close button.

Image Added

Image Added

Next step is need to be done back end.

• Create a CarrierService for the carrier.
• Create to CarrierProviderCarrierServiceTypeMapping.
• Create to CarrierProviderCarrierMapping.

Notes:

Change the below parameter:

INSERT INTO @Temp SELECT 'INTERNATIONAL', 'INTERNATIONAL' = Enter the Carrier Service Name and Carrier Service Code.

@CarrierCompanyCode = CompanyCode/CarrierCode

@CarrierCompanyName = CompanyDescription/CarrierName

@CarrierProvider = Indigina TMS

@ReleaseProfile int = 0

If value is 0, This is QA

If value is 1, This is Live

Run the below script.

SET NOCOUNT ON
DECLARE @Temp TABLE(ServiceName nvarchar(max), ServiceCode nvarchar(max))
INSERT INTO @Temp SELECT 'TESTINTERNATIONAL', 'TESTINTERNATIONAL'

DECLARE @CarrierCompanyName nvarchar(max), @CarrierCompanyCode nvarchar(max), @CarrierCompanyID uniqueidentifier, @CarrierProvider nvarchar(max), @CarrierProviderID uniqueidentifier, @CarrierServiceTypeID uniqueidentifier, @ReleaseProfile int, @NEWID1 uniqueidentifier, @NEWID2 uniqueidentifier, @NEWID3 uniqueidentifier, @UserID uniqueidentifier
SET @CarrierCompanyCode = 'TESTNL'
SET @CarrierCompanyName = 'TEST NL'
SET @CarrierProvider = 'Indigina TMS'
SET @ReleaseProfile = 0 --0-QA/UAT 1-Live

SELECT @NEWID1 = NEWID()
SELECT @NEWID2 = NEWID()
SELECT @NEWID3 = NEWID()

SELECT TOP 1 @CarrierCompanyID = CompanyID FROM Company WHERE CompanyDescription = @CarrierCompanyName AND OwnerCompanyID = CompanyID AND DisableLevel = 0 ORDER BY CreateDate
SELECT TOP 1 @CarrierProviderID = CarrierProviderID FROM CarrierProvider WHERE Name = @CarrierProvider
SELECT TOP 1 @UserID = UserID FROM Users WHERE UserName = 'SystemDefault' AND DisableLevel = 0 ORDER BY CreateDate

IF NOT EXISTS(SELECT * FROM CarrierServiceType WHERE ServiceCode IN (SELECT ServiceCode FROM @Temp))
BEGIN
INSERT INTO CarrierServiceType(CarrierServiceTypeID, CarrierID, ServiceCode, ServiceName, CreateDate, CreateUserID, DisableLevel, LastModifiedDate, LastModifiedUserID)
SELECT @NEWID1, @CarrierCompanyID, ServiceCode, ServiceName, GETUTCDATE(), @UserID, 0, GETUTCDATE(), @UserID FROM @Temp

SELECT TOP 1 @CarrierServiceTypeID = CarrierServiceTypeID FROM CarrierServiceType WHERE ServiceName IN (SELECT ServiceName FROM @Temp)

INSERT INTO CarrierProviderCarrierServiceTypeMapping (CarrierProviderCarrierServiceTypeMappingID, CarrierProviderID, CarrierServiceTypeID, MappedID, MappedCode, CreateDate, CreateUserID, DisableLevel, ReleaseProfile, LastModifiedDate, LastModifiedUserID)
SELECT @NEWID2, @CarrierProviderID, @CarrierServiceTypeID, NULL, ServiceCode, GETUTCDATE(), @UserID, 0, @ReleaseProfile, GETUTCDATE(), @UserID FROM @Temp

INSERT INTO CarrierProviderCarrierMapping (CarrierProviderCarrierMappingID, CarrierProviderID, CarrierID, CreateDate, CreateUserID, DisableLevel, MappedCode, ReleaseProfile, LastModifiedDate, LastModifiedUserID)
SELECT @NEWID3, @CarrierProviderID, @CarrierCompanyID, GETUTCDATE(), @UserID, 0, @CarrierCompanyCode, @ReleaseProfile, GETUTCDATE(), @UserID
END
ELSE
BEGIN
SELECT 'ServiceCodes already exist!!!'
END

Now move on to the TMS site.

URL_UAT:  https://tmsuat.supplystream.com

...