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

comcorp

CORP

CHAR(5)

N

5 digit system number assigned to a corp

c_house

HOUSE

CHAR(6)

N

Up to six digit house number

c_cust

CUST

CHAR(2)

N

Two digit customer number

history

HISTORY

CHAR(1)

N

Y=available, N=not available

ledger

LEDGER

CHAR(1)

N

Y=available, N=not available

comment

COMMENT

CHAR(1)

N

Y=available, N=not available

billing_address

BILLING_ADDRESS

CHAR(1)

N

Y=available, N=not available

customer_rates

CUSTOMER_RATES

CHAR(1)

N

Y=available, N=not available

wip_job

WIP_JOB

CHAR(1)

N

Y=available, N=not available

wip_installer

WIP_INSTALLER

CHAR(1)

N

Y=available, N=not available

wip_notruck

WIP_NOTRUCK

CHAR(1)

N

Y=available, N=not available

trouble_call_job

TROUBLE_CALL

CHAR(1)

N

Y=available, N=not available

trouble_call_installer

TROUBLE_CALL_INSTALLER

CHAR(1)

N

Y=available, N=not available

trouble_call_notruck

TROUBLE_CALL_NOTRUCK

CHAR(1)

N

Y=available, N=not available

sro_job

SRO_JOB

CHAR(1)

N

Y=available, N=not available

sro_installer

SRO_INSTALLER

CHAR(1)

N

Y=available, N=not available

sro_notruck

SRO_NOTRUCK

CHAR(1)

N

Y=available, N=not available

job

JOB

CHAR(1)

N

Y=available, N=not available

install

INSTALL

CHAR(1)

N

Y=available, N=not available

no_truck

NO_TRUCK

CHAR(1)

N

Y=available, N=not available

outlet_info

OUTLET_INFO

CHAR(1)

N

Y=available, N=not available

events

EVENTS

CHAR(1)

N

Y=available, N=not available

collections_info

COLLECTIONS_INFO

CHAR(1)

N

Y=available, N=not available

collections_tally

COLLECTIONS_TALLY

CHAR(1)

N

Y=available, N=not available

collections_history

COLLECTIONS_HISTORY

CHAR(1)

N

Y=available, N=not available

collections_step

COLLECTIONS_STEP

CHAR(1)

N

Y=available, N=not available

collections_note_pad

COLLECTIONS_NOTE_PAD

CHAR(1)

N

Y=available, N=not available

efts

EFTS

CHAR(1)

N

Y=available, N=not available

refunds

REFUNDS

CHAR(1)

N

Y=available, N=not available

promo_codes

PROMO_CODES

CHAR(1)

N

Y=available, N=not available

billing_info

BILLING_INFO

CHAR(1)

N

Y=available, N=not available

from

FROM

CHAR(1)

N

Y=available, N=not available

transfer

TRANSFER

CHAR(1)

N

Y=available, N=not available

house_data

HOUSE_DATA

CHAR(1)

N

Y=available, N=not available

customer_data

CUSTOMER_DATA

CHAR(1)

N

Y=available, N=not available

dual_account

DUAL_ACCOUNT

CHAR(1)

N

Y=available, N=not available

subscription_codes

SUBSCRIPTION_CODES

CHAR(1)

N

Y=available, N=not available

auxillary_fields

AUXILLARY_FIELDS

CHAR(1)

N

Y=available, N=not available

alternate_service_address

ALTERNATE_SERVICE_ADDRESS

CHAR(1)

N

Y=available, N=not available