XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

Six digit house number

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_wform

WFORM

CHAR(1)

N

Billing form.

w_wmode

WMODE

CHAR(1)

N

Billing mode.

w_wrem

WREM

CHAR(1)

N

Reminder Scheme. Valid Values: A-H only

w_wmsg

WMSG

CHAR(2)

N

Message number on Pay 80 to use for this customer's bill.

w_wdiscnt

w_wcycle

WCYCLE

CHAR(1)

N

Billing cycle code. Valid Values: A-D

w_wpro

WPRO

CHAR(1)

N

Prorate plan number.

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

CHAR(8)

N

calc_prorate

CHAR(1)

N

calc_bill_to_dte

CHAR(10)

N

calc_tot_first_bill

CHAR(9)

N

calc_net_first_bill

CHAR(9)

N

calc_first_bill_dte

CHAR(10)

N

calc_taxexempt

CHAR(1)

Y

6/12/01

Changed the following tags to match the API server code.

w_wbdate = calc_bill_date, calc.fromday = calc_billfrom, cylt.recvday = cylt_recvday, calc_bill_to_date = calc_bill_to_dte

calc_first_bill_date = calc_first_bill_dte, calc_tax_exempt = calc_taxexempt