GetAuxInfo

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

auxhousegroup

      

Beginning auxhousegroup delimiter

auxh_corp

CORP

INT UNSIGNED

N

Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system..

auxh_partition

PARTITION

CHAR(2)

N

House auxiliary field x2.

Auxh_house

HOUSE

CHAR(6)

N

House number. Valid Values: Alpha/Numeric

auxh_x1

      

Beginning auxh_x1 delimiter

code

X1

CHAR(1)

N

House auxiliary field x1.

Shortdescription

  

CHAR(8)

  

House auxiliary field x1 short description.

Longdescription

  

CHAR(30)

  

House auxiliary field x1 long description.

Auxh_x1

      

Ending auxh_x1 delimiter

auxh_x2

      

Beginning auxh_x2 delimiter

code

X2

CHAR(2)

N

House auxiliary field x2.

Shortdescription

  

CHAR(8)

  

House auxiliary field x2 short description.

Longdescription

  

CHAR(30)

  

House auxiliary field x2 long description.

Auxh_x2

      

Ending auxh_x2 delimiter

auxh_x3

      

Beginning auxh_x3 delimiter

code

X3

CHAR(3)

N

House auxiliary field x3.

Shortdescription

  

CHAR(8)

  

House auxiliary field x3 short description.

Longdescription

  

CHAR(30)

  

House auxiliary field x3 long description.

Auxh_x3

      

Ending auxh_x3 delimiter

auxh_y1

      

Beginning auxh_y1 delimiter

code

Y1

CHAR(1)

N

House auxiliary field y1.

Shortdescription

  

CHAR(8)

  

House auxiliary field y1 short description.

Longdescription

  

CHAR(30)

  

House auxiliary field y1 long description.

Auxh_y1

      

Ending auxh_y1 delimiter

auxh_y2

      

Beginning auxh_y2 delimiter

code

Y2

CHAR(2)

N

House auxiliary field y2.

Shortdescription

  

CHAR(8)

  

House auxiliary field y2 short description.

Longdescription

  

CHAR(30)

  

House auxiliary field y2 long description.

Auxh_y2

      

Ending auxh_y2 delimiter

auxh_y3

      

Beginning auxh_y3 delimiter

code

Y3

CHAR(3)

N

House auxiliary field y3.

Shortdescription

  

CHAR(8)

  

House auxiliary field y3 short description.

Longdescription

  

CHAR(30)

  

House auxiliary field y3 long description.

Auxh_y3

      

Ending auxh_y3 delimiter

auxh_y6

      

Beginning auxh_y6 delimiter

code

Y6

CHAR(6)

N

House auxiliary field y6.

Shortdescription

  

CHAR(8)

  

House auxiliary field y6 short description.

Longdescription

  

CHAR(30)

  

House auxiliary field y6 long description.

Auxh_y6

      

Ending auxh_y6 delimiter

auxh_y7

      

Beginning auxh_y7 delimiter

code

Y7

CHAR(7)

N

House auxiliary field y7.

Shortdescription

  

CHAR(8)

  

House auxiliary field y7 short description.

Longdescription

  

CHAR(30)

  

House auxiliary field y7 long description.

/auxh_y7

      

Ending auxh_y7 delimiter

/auxhousegroup

      

Ending auxhousegroup delimiter

auxcustgroup

      

Beginning auxcustgroup delimiter

auxc_corp

CORP

INT UNSIGNED

N

Two digit system number assigned to each corp.Thecorp # is unique only within one Tandem system..

auxc_partition

PARTITION

CHAR(2)

N

Data hashing value for database management – equals the last 2 digits of the house #.

Auxc_house

HOUSE

CHAR(6)

N

House number. Valid Values: Alpha/Numeric

auxc_cust

CUST

CHAR(2)

N

Customer number.

Auxc_c1

      

Beginning auxc_c1 delimiter

code

C1

CHAR(1)

N

Customer auxiliary field c1. Valid Values: SET UP BY THE CUSTOMER

shortdescription

  

CHAR(8)

  

Customer auxiliary field c1 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field c1 long description.

/auxc_c1

      

Ending auxc_c1 delimiter

auxc_c2

      

Beginning auxc_c2 delimiter

code

C2

CHAR(2)

N

Customer auxiliary field c2.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field c2 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field c2 long description.

/auxc_c2

      

Ending auxc_c2 delimiter

auxc_c3

      

Beginning auxc_c3 delimiter

code

C3

CHAR(3)

N

Customer auxiliary field c3.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field c3 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field c3 long description.

/auxc_c3

      

Ending auxc_c3 delimiter

auxc_d1

      

Beginning auxc_d1 delimiter

code

D1

CHAR(1)

N

Customer auxiliary field d1.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field d1 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field d1 long description.

/auxc_d1

      

Ending auxc _d1 delimiter

auxc_d2

      

Beginning auxc_d2 delimiter

code

D2

CHAR(2)

N

Customer auxiliary field d2.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field d2 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field d2 long description.

/auxc_d2

      

Ending auxc_d2 delimiter

auxc_d3

      

Beginning auxc_d3 delimiter

code

D3

CHAR(3)

N

Customer auxiliary field d3.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field d3 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field d3 long description.

Auxc_d3

      

Ending auxc_d3 delimiter

auxc_e1

      

Beginning auxc_e1 delimiter

code

E1

CHAR(1)

N

Customer auxiliary field e1.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field e1 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field e1 long description.

/auxc_e1

      

Ending auxc_e1delimiter

auxc_e2

      

Beginning auxc_e2 delimiter

code

E2

CHAR(2)

N

Customer auxiliary field e2.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field e2 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field e2 long description.

/auxc_e2

      

Ending auxc_e2 delimiter

auxc_e3

      

Beginning auxc_e3 delimiter

code

E3

CHAR(3)

N

Customer auxiliary field e3.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field e3 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field e3 long description.

/auxc_e3

      

Ending auxc_e4 delimiter

auxc_e4

      

Beginning auxc_e5 delimiter

code

E4

CHAR(4)

N

Customer auxiliary field e4.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field e4 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field e4 long description.

/auxc_e4

      

Ending auxc_e5 delimiter

auxc_e5

      

Beginning auxc_e6 delimiter

code

E5

CHAR(5)

N

Customer auxiliary field e5.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field e5 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field e5 long description.

/auxc_e5

      

Ending auxc_e5 delimiter

auxc_e6

      

Beginning auxc_e6 delimiter

code

E6

CHAR(6)

N

Customer auxiliary field e6.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field e6 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field e6 long description.

/auxc_e6

      

Ending auxc_e6 delimiter

auxc_e8

      

Beginning auxc_e8 delimiter

code

E8

CHAR(8)

N

Customer auxiliary field e8.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field e8 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field e8 long description.

/auxc_e8

      

Ending auxc_e8 delimiter

auxc_e9

      

Beginning auxc_e9 delimiter

code

E9

CHAR(9)

N

Customer auxiliary field e9.

Shortdescription

  

CHAR(8)

  

Customer auxiliary field e9 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field e9 long description.

/auxc_e9

      

Ending auxc_e9 delimiter

auxc_z15

      

Beginning auxc_z15 delimiter

code

Z15

CHAR(15)

N

Customer auxiliary field. Valid Values: 15 characters

shortdescription

  

CHAR(8)

  

Customer auxiliary field z15 short description.

Longdescription

  

CHAR(30)

  

Customer auxiliary field z15 long description.

/auxc_z15

      

Ending auxc_z15 delimiter

/auxcustgroup

      

Endign auxcustgroup delimiter

 

Source Tables

 

Description