XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

6 digit house number

cust

2 digit customer number

XML Tag

Column Name

Data Type

Nullable

Definition

cpycrd_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

cpycrd_partition

PARTITION

CHAR(2)

N

Data hashing value for database management - equals the last 2 digits of the house #. Valid Values:

cpycrd_house

HOUSE

CHAR(6)

N

Up to six digit house number

cpycrd_cust

CUST

CHAR(2)

N

Two digit customer number

paycardgroup

Beginning paycardgroup delimiter

paycard

Beginning paycard delimiter

cpycrd_cardtype

CARDTYPE

CHAR(1)

N

User defined card type. Valid Values:

cpycrd_cardnumber

CARDNUMBER

CHAR(19)

N

Credit card number. Valid Values:

cpycrd_cardname

CARDNAME

CHAR(26)

N

Card user name. Valid Values:

cpycrd_expiredate

EXPIREDATE

VARCHAR(8)

N

Card expiration date. Valid Values: MMYY

cpycrd_primsecond

PRIMSECOND

CHAR(1)

N

Indicates primary or secondary card. Valid Values: 1=primary 2=secondary

cpycrd_billaddrs

BILLADDRS

CHAR(20)

Y

Billing address. Valid Values:

cpycrd_zipcode

ZIPCODE

CHAR(6)

Y

ZIP code for this address. Valid Values: 6th character could be special city code linking to a city description..2 cities one zip..alpha cc

cpycrd_zip4

ZIP4

CHAR(4)

Y

Additional breakdown of zip code. Valid Values:

cpycrd_declined

DECLINED

SMALLINT UNSIGNED

N

Authorization option. Valid Values: 1=authorization declined

cpycrd_reautho

REAUTHO

SMALLINT UNSIGNED

N

Recurring billing process temporarily sets thisflag to 1 if the payment card requiresreauthorization. Valid Values: 0 or 1

/paycard

Ending paycard delimiter

/paycardgroup

Ending paycardgroup delimiter

5/7/01

Changed YYMM to MMYY in cpycrd_expiredate field

5/10/01

Changed YYMM to MMYY in cpycrd_expiredate field