XML Tag

Definition

Rules

comcorp

5 characters

Five digit system number assigned to each corp.

house

Six digit house number

Up to six digit house number

cust

Two digit customer number

Two digit customer number

opr

Three digit operator id

3 characters, legal operator id

c_ssn

9 characters

9 digits, numeric

c_title

2 character field

Title associated with customer's name. Valid Values: Alpha-numeric

c_fname

8 character field

Customer's first name. Valid Values

c_init

2 character field

Initials. Valid Values:

c_lname

13 character field

Customer's last name. Valid Values:

c_rareacd

3 digit field

Residence/home phone area code.. Valid Values

c_rphon

7 character field

Customer's residence phone number. Valid Values:

c_bphone

10 character field

Customer's business phone number. Valid Values: If CREDITCHKTRANS, AAAPPPSSSS where aaa=area codeppp=prefix, ssss=suffix.

XML Tag

Column Name

Data Type/Nullable

Definition

comcorp

CORP

CHAR(5)/N

Five digit accounting corp number assigned to each corp

ccr_respcode

MESG_NUM

SMALLINT UNSIGNED/N

2 digit message number

ccf_codetitle

MESG_TITLE

CHAR(40)/N

40 character message title

ccr_codedesc

MESG_DESC

CHAR(160)/N

160 character message

ccr_cursoroption

BACKUP_INDICATOR

CHAR(1)/N

Y = don't allow to pass this entry field