XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

XML Tag

Column Name

Data Type

Nullable

Definition

cylt_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

cyclegroup

Beginning cyclegroup delimiter

cycle

Beginning cycle delimiter

cylt_cycle

CYCLE

CHAR(1)

N

In custmaster = customer’s billing cycle, in cycletable = valid cycles for corp. Valid Values: CYCLETABLE A-H

cylt_cycledesc

CYCLEDESC

CHAR(8)

N

Short description pertaining to the cycle code.. Valid Values:

cylt_runday

RUNDAY

SMALLINT UNSIGNED

N

The effective date for the DDPF reports (always is the first day of a run cycle’s date range). Valid Values: 1-31

cylt_fromday

FROMDAY

SMALLINT UNSIGNED

N

1^st day of run cycle’s date range (always equals the RUNDAY). Valid Values: 1-31

cylt_today

TODAY

SMALLINT UNSIGNED

N

Last day of run cycle’s date range. Valid Values: 1-31

cylt_cutoffday

CUTOFFDAY

SMALLINT UNSIGNED

N

The usual day when the Cutoff program is run. Valid Values: 1-31

cylt_recvday

RECVDAY

SMALLINT UNSIGNED

N

The projected date the bills will arrive at the customer’s address. Valid Values: 1-31

cylt_chgfrmdte

CHGFRMDTE

DATETIME

Y

Charged from date for this cycle. Valid Values:

cylt_chgtodte

CHGTODTE

DATETIME

Y

Charged to date for this cycle. Valid Values:

/cycle

Ending cycle delimiter

/cyclegroup

Ending cyclegroup delimiter