GetCustTaxExempt

Input XML Tags

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

Six digit house number

cust

Two digit customer number

 

Output XML Tags

XML Tag

Column Name

Data Type

Nullable

Definition

cte_corp

CORP

INT UNSIGNED

N

Two digit system number assigned to each corp.The corp # is unique only within one Tandem system.. Valid Values:

cte_house

HOUSE

CHAR(6)

N

House number. Valid Values: Alpha/Numeric

cte_cust

CUST

CHAR(2)

N

Customer number. Valid Values:

taxcodegroup

     

Beginning taxcodegroup delimiter

taxcode

     

Beginning taxcode delimiter

cte_taxcode

TAXCODE

CHAR(1)

N

Tax code to which this customer is exempt.. Valid Values: Code36 value, "*" = exempt from all taxes

/taxcode

     

Ending taxcode delimiter

/taxcodegroup

     

Ending taxcodegroup delimiter

 

Source Tables

custtaxexempt

 

Change Log

 

 

Usage

 

 

Associated XML Documents