External stored procedures: Templates

TMWAMSEXT_ORDERS_TEMPLETE_SYNC

Allows templates from one shop to be cloned and synced to another shop. If there are templates already created in the receiving shop, they will be deleted and replaced with the templates from the source shop. For example, let’s say that 50 templates have been created in shop 01, and you want to clone those to shop 02. Those 50 templates will be created in shop 02, and any existing templates in shop 02 will be removed.

Input Parameters

Parameter Name

Parameter Information

Parameter Description

@CLONEFROMSHOPID

VARCHAR (12)

The shop containing templates to clone to other shops.

@CLONETOTYPE

VARCHAR (12)

The Shop Type of the shop that will be cloned to. This field is required.

@CLONETODEPT

VARCHAR (12)

The Department of the shop that will be cloned to. This field is required.

@CLONETOSHOPID

VARCHAR (12)

The shop that the templates will be cloned to. This field is required.

TMWAMSEXT_ORDERS_TEMPLETE_SYNC Example:
DECLARE @CLONEFROMSHOPID VARCHAR(12), @CLONETOTYPE VARCHAR(12), @CLONETODEPT VARCHAR(12), @CLONETOSHOPID VARCHAR(12)

 — Set parameter values
SET @CLONEFROMSHOPID = '01'
SET @CLONETOTYPE = 'MAIN SHOP'
SET @CLONETODEPT = 'MAINT'
SET @CLONETOSHOPID = '02'

EXECUTE [dbo].[TMWAMSEXT_ORDERS_TEMPLETE_SYNC] @CLONEFROMSHOPID,@CLONETOTYPE,@CLONETODEPT,@CLONETOSHOPID