External stored procedures: Vendor

TMTEXT_VENDORS_CREATE

Input Parameters

Parameter Name

Parameter Information

Parameter Description

@VENDORID

VARCHAR(12) Optional

Vendor Identification Number

@ACTIVECODE

CHAR, (1), Optional

Is vendor active

@NAME

VARCHAR, (60), Optional

Full Name of Vendor

@VENDORTYPE

VARCHAR, (12), Optional

Parts, service, fuel, etc

@ADDRESS1

VARCHAR, (50), Optional

Billing address of Vendor

@ADDRESS2

VARCHAR, (50), Optional

Billing address of Vendor

@CITY

VARCHAR, (50), Optional

Billing city of Vendor

@STATE

VARCHAR, (12), Optional

Billing state of Vendor

@ZIPCODE

VARCHAR, (16), Optional

Billing zip code of Vendor

@COUNTY

VARCHAR, (24), Optional

Billing county of Vendor

@COUNTRY

VARCHAR, (12), Optional

Billing country of Vendor

@MAINPHONE

VARCHAR, (20), Optional

Main phone of vendor

@PHONEEXT

CHAR, (6), Optional

Extension of maninphone for vendor

@FAXNUMBER

VARCHAR, (20), Optional

Fax number for vendor

@EMAIL

VARCHAR, (60), Optional

Main email of Vendor

@ONSITESVC

CHAR, (1), Optional

Vendor provides on-site service

@CURRENCUOM

VARCHAR, (12), Optional

Base currency for vendor

@SHIPVIA

VARCHAR, (12), Optional

Vendors shipping method

@PAYTERMS

VARCHAR, (12), Optional

Terms of sale for vendor Net 10 days, Net 30 days

@FEDTAXID

VARCHAR, (50), Optional

Federal Tax ID of vendor

@RISINTERFC

CHAR, (1), Optional

E-Purchasing Flag

@TAXMETHOD

CHAR, (1), Optional

Tax on Tax or Standard

@PRICETBLID

INTEGER, Optional

Price Table ID determines rate unit is invoiced at

@REMITADDR1

VARCHAR, (35), Optional

The Remit to Address

@REMITADDR2

VARCHAR, (35), Optional

The Remit to Address

@REMITCITY

VARCHAR, (20), Optional

The Remit to City

@REMITSTATE

VARCHAR, (12), Optional

The Remit to State

@REMITZIPCODE

VARCHAR, (16), Optional

The Remit to Zip Code

@REMITCOUNTY

VARCHAR, (20), Optional

The Remit to County

@REMITPHONE

VARCHAR, (20), Optional

The Remit to Phone

@REMITEMAIL

VARCHAR, (60), Optional

The Remit to Email Address

@REMITEXT

CHAR, (6), Optional

The Remit to Phone Extension

@VENDORRATING

SMALLINT, Optional

Rating for Vendor

@REMITFAX

VARCHAR, (20), Optional

The Remit to Fax Number

@NATIONALACCT

VARCHAR, (24), Optional

National Account number

@PAYMETHOD

VARCHAR, (12), Optional

Default payment method for POs

@REMITAPID

VARCHAR, (24), Optional

Accounts Payable Remit Code Used in Great Microsoft Dynamics GP instead of Vendor id

@COMPANYID

VARCHAR, (12), Optional

Not currently in use will default to TMT

@LOGINPASSWORD

VARCHAR, (20), Optional

Login Password from VIS

@ALLOWRPTACCESS

CHAR, (1), Optional

Allow VIS access from the Vendor Master. Definition tab.

@SHOPID

VARCHAR, (12). Optional

Shop Identification Number

@PAYGRADEID

VARCHAR, (12), Optional

Paygrade

TMTEXT_VENDORS_CREATE Output Parameters:
@ERROR — INTEGER

TMTEXT_VENDORS_ CREATE Example:
DECLARE @ERROR INT, @VENDORID VARCHAR(12), @ACTIVECODE CHAR(1), @NAME VARCHAR(60), @VENDORTYPE VARCHAR(12), @ADDRESS1 VARCHAR(50), @ADDRESS2 VARCHAR(50), @CITY VARCHAR(50), @STATE VARCHAR(12), @ZIPCODE VARCHAR(16), @COUNTY VARCHAR(24), @COUNTRY VARCHAR(12), @MAINPHONE VARCHAR(20), @PHONEEXT CHAR(6), @FAXNUMBER VARCHAR(20), @EMAIL VARCHAR(60), @ONSITESVC CHAR(1), @CURRENCUOM VARCHAR(12), @SHIPVIA VARCHAR(12), @PAYTERMS VARCHAR(12), @FEDTAXID VARCHAR(50), @RISINTERFC CHAR(1), @TAXMETHOD CHAR(1), @PRICETBLID INT, @REMITADDR1 VARCHAR(35), @REMITADDR2 VARCHAR(35), @REMITCITY VARCHAR(20), @REMITSTATE VARCHAR(12), @REMITZIPCODE VARCHAR(16), @REMITCOUNTY VARCHAR(20), @REMITPHONE VARCHAR(20), @REMITEMAIL VARCHAR(60), @REMITEXT CHAR(6), @VENDORRATING SMALLINT, @REMITFAX VARCHAR(20), @NATIONALACCT VARCHAR(24), @PAYMETHOD VARCHAR(12), @REMITAPID VARCHAR(24), @COMPANYID VARCHAR(12), @LOGINPASSWORD VARCHAR(20), @ALLOWRPTACCESS CHAR(1)

 — Set parameter values

EXEC @RC = [dbo].[TMTEXT_VENDORS_CREATE] @ERROR OUTPUT , @VENDORID, @ACTIVECODE, @NAME, @VENDORTYPE, @ADDRESS1, @ADDRESS2, @CITY, @STATE, @ZIPCODE, @COUNTY, @COUNTRY, @MAINPHONE, @PHONEEXT, @FAXNUMBER, @EMAIL, @ONSITESVC, @CURRENCUOM, @SHIPVIA, @PAYTERMS, @FEDTAXID, @RISINTERFC, @TAXMETHOD, @PRICETBLID, @REMITADDR1, @REMITADDR2, @REMITCITY, @REMITSTATE, @REMITZIPCODE, @REMITCOUNTY, @REMITPHONE, @REMITEMAIL, @REMITEXT, @VENDORRATING, @REMITFAX, @NATIONALACCT, @PAYMETHOD, @REMITAPID, @COMPANYID, @LOGINPASSWORD, @ALLOWRPTACCESS

TMTEXT_VENDOR_MERGE

TMTEXT_VENDOR_MERGE will merge the records of two vendors. This will remove the old vendor and replace with the new vendor in the following tables:
ITEMSUPL, PARTSUPL, ITEMPURREQ, ITEMREQ, VENDORITEM, IMPXREF, TAXMETHOD, UEXTWARR, ORDERSEC, ORDERS, ROTEMPLATE, UNITS, and INTEGRATION_XREF While the parameters are technically optional, they will require values to change the records. They cannot be the same vendor or NULL, but they can be blank (or “”).

Input Parameters

Parameter Name

Parameter Information

Parameter Description

@NEWVENDORID

VARCHAR, (12), Required

The Vendor ID created for the 2 merged companies

@OLDVENDORID

VARCHAR, (12), Required

The previous Vendor ID

TMTEXT_VENDOR_MERGE Output Parameters
@ERRORMESSAGE — VARCHAR(60)

TMTEXT_VENDOR_MERGE Example:
DECLARE @NEWVENDORID VARCHAR(12), @OLDVENDORID VARCHAR(12), @ERRORMESSAGE VARCHAR(60)

 — Set parameter values
SET @NEWVENDORID = 'NEWVEND'
SET @OLDVENDORID = 'OLDVEND'

EXEC @RC = [dbo].[TMTEXT_VENDOR_MERGE] @NEWVENDORID, @OLDVENDORID, @ERRORMESSAGE OUTPUT

 — Return the error code
SELECT @ERRORMESSAGE