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

crf_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

crf_partition

PARTITION

CHAR(2)

N

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

crf_house

HOUSE

CHAR(6)

N

Up to six digit house number

crf_cust

CUST

CHAR(2)

N

Two digit customer number

crf_stat

STAT

CHAR(1)

N

Status for cust – 1=P/IN 2=P/RS 3=P/CH 4=P/DS 5=ACTIVE 6=DISC 7=X/IN. Valid Values: REFUND STATUS 1,2,3,D,H,P,S,T,W EVENT DESCRIPTION TABLE 1-4

crf_stat_desc

n/a

CHAR(16)

N

Hardcoded descriptions for refund statuses; D = Remove Refund, blank = Unevaluated,1= Hold Refund, 2 Write-off, 3 = Transfer, S = Force to Send, H = Force to Hold, W = Write-off, T = Transfer, X = Balance Change, E = Check File Run, P = Ready to Print, de

crf_source

SOURCE

SMALLINT SIGNED

N

Program that created this refund record. Valid Values: 1=money status, 2=order entry, 3=cutoff,4=Posting

crf_amt

AMT

NUMERIC SIGNED

N

Dollar amount. Valid Values:

crf_intr

INTR

NUMERIC SIGNED

N

Amount of interest to be refunded. Valid Values:

crf_dep

DEP

NUMERIC SIGNED

N

Amount of deposit at time of disconnect. Valid Values: