XML Tag

Definition

Rules

comcorp

Five digit number

Five digit corp number assigned to each corp

house

Six digit house number

Six digit house number

cust

Two digit customer number

Two digit customer number

opr

3 character operator id

3 character operator id

w_wbdate

10 character field

Date field; YYYY-MM-DD

w_wcod

1 character field

1 character field

w_annivday

2 character field

2 character field, 1 - 31; option field, if not sent, system will calculate

optn

2 digit option number

2 digit option number; valid values = 1-Install, 2-Restart, 3-Change of service,4-Disconnect, 5-Rechedule.

w_wntrk

1 digit number

0=not no-truck, 1=no-truck, Blank and null values will default to zero

outletgroup

outletgroup beginning delimiter

If option = Disconnect (4), transaction should not include the outletgroup tag and tags within outletgroup

If option = Reschedule (5) and it is a Disconnect order, transaction should not include the outletgroup tag and tags within outletgroup

outlet

outlet beginning delimiter

wo_outlet

2 digit field

Outlet number. Valid Values: 1-60

ratecode group

ratecodegroup beginning delimiter

ratecode

ratecode beginning delimiter

wor_ratecd

2 character field

Rate code associated with this charge level.

wor_cnt

short

Rate code count for the service on this outlet

pl_taskgp

short

Package lines taskgroup

non_std_amt

6 characters

non standard charge amount

/ratecode

ratecode ending delimiter

/ratecode group

ratecodegroup ending delimiter

/outlet

outlet ending delimiter

/outletgroup

outletgroup ending delimiter

XML Tag

Column Name

Data Type

Nullable

Definition

h_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

c_house

HOUSE

CHAR(6)

N

Up to six digit house number

c_cust

CUST

CHAR(2)

N

Two digit customer number

calc_bill_date

WBDATE

DATETIME

Y

Start/stop bill date for the order.

w_wcycle

WCYCLE

CHAR(1)

N

Billing cycle code. Valid Values: A-D

calc_annivday

ANNIVDAY

SMALLINT SIGNED

N

Day of the month specified as the customer's anniversary day. Valid Values: 1-31

calc_billfrom

FROMDAY

SMALLINT UNSIGNED

N

1st day of run cycle's date range (always equals the RUNDAY). 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

w_wcod

WCOD

CHAR(1)

N

User defined COD code. Valid Values: any valid value in the =CODTABLEset up in Dir. Maint - Control Tables

calc_coddesc

N/A

CHAR(8)

N

Calculated COD amount with decimal point

calc_prorate

N/A

CHAR(8)

N

Calculated Prorate amount with decimal point

calc_bill_to_dte

N/A

CHAR(8)

N

Calculated "Bill To" date

calc_tot_first_bill

N/A

CHAR(8)

N

Calculated Total First Bill amount with decimal point

calc_net_first_bill

N/A

CHAR(8)

N

Calculated Net First Bill amount with decimal point

calc_first_bill_dte

N/A

CHAR(8)

N

Calculated "First Bill" Date

6/12/01

Changed the following tags to match the XML server output.

calc.fromday = calc_billfrom, cylt.recvday = cylt_recvday, calc_bill_to_date = calc_bill_to_dte, calc_first_bill_date = calc_first_bill_dte

8/7/01

Added second "if" statement to outletgroup tag in "Input XML Tags" section.

8/24/01

Changed wording in Input XML Document for Corp Definition column.