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