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

cefts_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

cefts_partition

PARTITION

CHAR(2)

N

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

cefts_house

HOUSE

CHAR(6)

N

Up to six digit house number

cefts_cust

CUST

CHAR(2)

N

Two digit customer number

cefts_bacct

BACCT

CHAR(17)

N

Bank account number. Valid Values:

cefts_bank

BANK

CHAR(8)

N

Transit and ABA number of the bank for EFTS transactions. Valid Values:

cefts_finbr

FINBR

CHAR(10)

N

Financial institution number (for Canadian systems). Valid Values:

cefts_cardtyp

CARDTYP

CHAR(1)

N

Card Type. Valid Values: 1=Visa, 2=Mastercard

cefts_acctinf

ACCTINF

CHAR(1)

N

Used to designate the type of account ie. savings or checking. Valid Values:

cefts_encd

ENCD

CHAR(1)

N

User defined encode. Valid Values:

cefts_cardnbr

CARDNBR

VARCHAR(19)

N

Visa/Mastercard account number or customers checking/savings account number. Valid Values:

cefts_efttype

EFTTYPE

CHAR(1)

N

EFTS type. Valid Values: 1=pre-authorized checking, 2=bank card, 3=paymentcard