External stored procedures: Customer

Input Parameters

Parameter Name

Parameter Information

Parameter Description

@CUSTOMERID

VARCHAR, (12), Required

Identification number for the customer.

@NAME

VARCHAR, (60), Required

Complete name of the Customer

@CUSTTYPE

VARCHAR, (12), Required

The type of customer

@ADDRESS1

VARCHAR, (35), Required

Billing address of Customer

@ADDRESS2

VARCHAR, (35), Optional

Billing address of Customer

@CITY

VARCHAR, (20), Required

Billing City of Customer

@STATE

VARCHAR, (12), Required

Billing State of Customer

@ZIPCODE

VARCHAR, (16), Required

Billing Zip Code of Customer

@COUNTRY

VARCHAR, (12), Optional

Billing Country of Customer

@COUNTY

VARCHAR, (24), Optional

Billing County of Customer

@MAINPHONE

VARCHAR, (20), Optional

Main phone of Customer

@PHONEEXT

VARCHAR, (6), Optional

Main phone extension of Customer

@FAXNUMBER

VARCHAR, (20), Optional

Fax number of Customer

@EMAIL

VARCHAR, (60), Optional

Email address of Customer

@ACTIVECODE

CHAR, (1), Optional

Is customer an active account

@FEDTAXID

VARCHAR, (24), Optional

Customers Federal Tax ID

@TAXEXEMPT

CHAR, (1), Optional

Is customer Tax Exempt

@PRICETBLID

INTEGER, Required

Price Table ID determines rate unit is invoiced at

@PAYTERMS

VARCHAR, (12), Optional

Identifies what payment terms customer has

@STOPSERVICE

CHAR, (1), Optional

Determines if customer should receive service

@REQPONO

CHAR, (1), Optional

Determines if PO number is required for this customer

@BILLATCLOSE

CHAR, (1), Optional

This corresponds with Create Invoice in Customers > Options > Invoicing

@BILLNAME

VARCHAR, (35), Optional

Who the bill is sent to

@BILLADDRESS1

VARCHAR, (35), Optional

Where the bill is sent

@BILLADDRESS2

VARCHAR, (35), Optional

Where the bill is sent

@BILLCITY

VARCHAR, (20), Optional

City where the bill is sent

@BILLSTATE

VARCHAR, (12), Optional

State where the bill is sent

@BILLZIP

VARCHAR, (16), Optional

Zip Code where the bill is sent

@ACCTTYPE

VARCHAR, (12), Optional

Up to a 12 CHARacter alphaNUMERIC name for the account

@ENFORCECREDIT

CHAR, (1), Optional

Enforces credit limit for the customer

@CREDITLIMIT

NUMERIC, (15,6), Optional

Total Balance due for customer

@INVOICELIMIT

NUMERIC, (15,6), Optional

Maximum amount for any one invoice

@TAXMETHOD

CHAR, (1), Optional

Standard or Tax on Tax

@ALLOWRPTACCESS

CHAR, (1), Optional

This option used to grant access to CIS, but is not used on newer versions.

@EMAILINVOICE

CHAR, (1), Optional

Is customer emailed Invoices

@PAYMETHOD

VARCHAR, (12), Optional

Default method of payment for customer

TMTEXT_CUSTOMERS_CREATE Output Parameters:
@ERROR — INTEGER

TMTEXT_CUSTOMERS_CREATE Example:
DECLARE @ERROR int, @CUSTOMERID VARCHAR(12), @NAME VARCHAR(60), @CUSTTYPE VARCHAR(12), @ADDRESS1 VARCHAR(35), @ADDRESS2 VARCHAR(35), @CITY VARCHAR(20), @STATE VARCHAR(12), @ZIPCODE VARCHAR(16), @COUNTRY VARCHAR(12), @COUNTY VARCHAR(24), @MAINPHONE VARCHAR(20), @PHONEEXT VARCHAR(6), @FAXNUMBER VARCHAR(20), @EMAIL VARCHAR(60), @ACTIVECODE CHAR(1), @FEDTAXID VARCHAR(24), @TAXEXEMPT CHAR(1), @PRICETBLID int, @PAYTERMS VARCHAR(12), @STOPSERVICE CHAR(1), @REQPONO CHAR(1), @BILLATCLOSE CHAR(1), @BILLNAME VARCHAR(35), @BILLADDRESS1 VARCHAR(35), @BILLADDRESS2 VARCHAR(35), @BILLCITY VARCHAR(20), @BILLSTATE VARCHAR(12), @BILLZIP VARCHAR(16), @ACCTTYPE VARCHAR(12), @ENFORCECREDIT CHAR(1), @CREDITLIMIT NUMERIC(15,6), @INVOICELIMIT NUMERIC(15,6), @TAXMETHOD CHAR(1), @ALLOWRPTACCESS CHAR(1), @EMAILINVOICE CHAR(1), @PAYMETHOD VARCHAR(12)

 — Set parameter values
SET @CUSTOMERID = '1000'
SET @NAME = 'Customer'
SET @ADDRESS1 = '123 Customer Ave'

EXEC [dbo].[TMTEXT_CUSTOMERS_CREATE] @ERROR OUTPUT , @CUSTOMERID, @NAME, @CUSTTYPE, @ADDRESS1, @ADDRESS2, @CITY, @STATE, @ZIPCODE, @COUNTRY, @COUNTY, @MAINPHONE, @PHONEEXT, @FAXNUMBER, @EMAIL, @ACTIVECODE, @FEDTAXID, @TAXEXEMPT, @PRICETBLID, @PAYTERMS, @STOPSERVICE, @REQPONO, @BILLATCLOSE, @BILLNAME, @BILLADDRESS1, @BILLADDRESS2, @BILLCITY, @BILLSTATE, @BILLZIP, @ACCTTYPE, @ENFORCECREDIT, @CREDITLIMIT, @INVOICELIMIT, @TAXMETHOD, @ALLOWRPTACCESS, @EMAILINVOICE, @PAYMETHOD

 — Return the error code
Select @ERROR