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

cst_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

cst_house

HOUSE

CHAR(6)

N

Up to six digit house number

cst_cust

CUST

CHAR(2)

N

Two digit customer number

c_tallybucket

TALLYBUCKET

SMALLINT SIGNED

N

Tells which bucket in the Customer Tally table is current.. Valid Values: 0 - 24; 1-12 = Jan-Dec, 13-24 = Jan-Dec

tallycodegroup

Beginning tallycodegroup delimiter

tallycode

Beginning tallycode delimiter

cst_tallycode

TALLYCODE

SMALLINT SIGNED

N

1=aging 3=open to collctns 4=NPDcreated 5=NPD routed 6=NPD cmpltd 7=NSF checks 8=Late Fees 9=Writeoffs 10=Date extextions 11=#Partial Pymts 12=#Pymt

cst_lastdate

LASTDATE

DATETIME

N

The date of the last record update OR date of the last collection step.. Valid Values:

cst_lifecnt

LIFECNT

INT SIGNED

N

Number of times for each tally for the life of the account.. Valid Values:

calc_months24

MONTHS24

SMALLINT SIGNED

N

Number of times for each tally for the last 24 months for the account

calc_current

CURRENT

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-1

CURRENT-1

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-2

CURRENT-2

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-3

CURRENT-3

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-4

CURRENT-4

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-5

CURRENT-5

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-6

CURRENT-6

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-7

CURRENT-7

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-8

CURRENT-8

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-9

CURRENT-9

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-10

CURRENT-10

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

calc_current-11

CURRENT-11

SMALLINT SIGNED

N

If tallycode = 1, Valid Values: highest aging Tally where 0=zero or credit bal, 1= current, 2=30 day, 3=60 day, 4=90 day, 5=120+days; if tallycode not equal to 1, Valid Values: tally count for current month for the account

/tallycode

Ending tallycode delimiter

/tallycodegroup

Ending tallycodegroup delimiter

collectionstatisticgroup

Beginning collectionstatisticgroup

tallycode

Beginning tallycode delimiter

cst_tallycode

TALLYCODE

SMALLINT SIGNED

N

2=mnths on cable, 13=times at 120 aging 14=times at 90 aging 15=times at 60 aging 16=times at 30 aging

cst_lifecnt

LIFECNT

INT SIGNED

N

Number of times for each tally for the life of the account..

/tallycode

Ending tallycode delimiter

/collectionstatisticgroup

Ending collectionstatisticgroup

5/15/01

Added tallygroup delimiter tags

5/25/01

Renamed cst_tallyjan1-cst_tallydec2 tag names and definitions; corrected definition of calc_months24

6/8/01

Added c_tallycode tag, changed tallygroup tag to tallycodegroup, added tallycode tag delimiter within tallycodegroup

Added collectionstatisticgroup delimiter grouping