GetOrderParams

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

XML Tag

Column Name

Data Type

Nullable

Definition

op_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

op_defboxloc

DEFBOXLOC

CHAR(1)

N

Default box location. Valid Values:

op_disprate

DISPRATE

CHAR(1)

N

Display rate amount at outlet level in o/e. Valid Values: 1=yes

op_dwospecl

DWOSPECL

CHAR(3)

N

Special instructions for npay discos. Valid Values:

op_swt1

SWT1

CHAR(1)

N

Switch 1. Valid Values:

op_swt2

SWT2

CHAR(1)

N

Switch 2. Valid Values:

op_swt3

SWT3

CHAR(1)

N

Switch 3. Valid Values:

op_swt4

SWT4

CHAR(1)

N

Switch 4. Valid Values:

op_swt5

SWT5

CHAR(1)

N

Switch 5. Valid Values:

op_draftsumcd

DRAFTSUMCD

SMALLINT SIGNED

N

Payment sum code for bank draft customer. Valid Values: Range from –1 to +4094, excluding 46, 63, 832,845,2944, 2990, and 4032. –1 = not used.

Op_paysum

PAYSUM

SMALLINT SIGNED

N

Payment sum code to display on ledgers. Valid Values: Range from –1 to +4094, excluding 46, 63, 832,845,2944, 2990, and 4032. –1 = not used.

Op_cxlnonpay

CXLNONPAY

CHAR(1)

N

Allow cancel of non pay in order entry. Valid Values: 1 = allow order entry manual cancels of nonpays

op_pkgtbl

PKGTBL

CHAR(1)

N

Switch for package table edit. Valid Values: 1 = zip 2 = f/tax 3 = mgt area

op_movedisc

MOVEDISC

CHAR(1)

N

Reason code used on a New Move-in. Valid Values:

op_xfrdisc

XFRDISC

CHAR(1)

N

Disconnect reason code for xfrs. Valid Values:

op_disctask

DISCTASK

CHAR(3)

N

Disconnect task code. Valid Values: 1-999

op_combo

COMBO

CHAR(1)

N

Combo rate codes at the outlet level. Valid Values: 1=yes

op_trvlpts

TRVLPTS

SMALLINT UNSIGNED

N

Travel points for WIP jobs. Valid Values:

op_movenotrk

MOVENOTRK

CHAR(3)

N

No truck reason used on a New Move-in. Valid Values: 1-999

op_houstreet

HOUSTREET

CHAR(1)

N

Code to indicate this is a street only address, used for adding houses. Valid Values:

op_housnonsvc

HOUSNONSVC

CHAR(1)

N

Code to indicate non-serviceable houses, also blocks order taking in order entry. Valid Values:

op_ptsperhr

PTSPERHR

SMALLINT UNSIGNED

N

Points per hour. Valid Values:

op_notdonpri

NOTDONPRI

CHAR(1)

N

Not-done priority code. Valid Values:

op_aptqual

APTQUAL

CHAR(1)

N

Determines how the system recognizes an apartment for task code select. Valid Values: 1=apt/spc, 2=apt #, 3="A" in complex

op_sroautochk

SROAUTOCHK

CHAR(1)

N

Auto checkin SRO’s. Valid Values: 1 = yes

op_sroaskfix

SROASKFIX

CHAR(1)

N

Ask for fix code on an SRO in dispatch. Valid Values: 1 = YES

op_sroprtwo

SROPRTWO

CHAR(1)

N

Print work order for SROs. Valid Values: 1=YES .

op_srotrvl

SROTRVL

CHAR(1)

N

Travel points to add to SRO orders. Valid Values:

op_ndfixsro

NDFIXSRO

CHAR(3)

N

Code for not done SRO. Valid Values: 1-999

op_srocmpnd

SROCMPND

CHAR(1)

N

Statuses to set to complete in auto-checkin for SRO s. Valid Values: blank=none;1=not done;2=open, A#, NX; 3=all

op_tccmpnd

TCCMPND

CHAR(1)

N

Trouble Call statuses to set to complete w hen doing auto-checkin. Valid Values: blank = none;1=not done;2=open,A#, NX; 3 = all types

op_tcwoprt

TCWOPRT

CHAR(1)

N

Send trouble calls to the pool. Valid Values: 1=print a work order,blank=pool

op_tcchkin

TCCHKIN

CHAR(1)

N

Switch for auto checkin of trouble calls. Valid Values: 1 = YES

op_tctrvl

TCTRVL

CHAR(1)

N

Travel points for trouble call orders. Valid Values:

op_tcndfix

TCNDFIX

CHAR(3)

N

Trouble call not done fix code. Valid Values: 1-999

op_croutesort

CROUTESORT

CHAR(1)

N

Sort blank carrier routes together. Valid Values: 1=yes

op_opgentape

OPGENTAPE

CHAR(1)

N

Flag to create the tape from a file. Valid Values: 1 = YES do it

op_cntpays

CNTPAYS

CHAR(1)

N

Accumulate # of pays for reporting. Valid Values: 1 = yes accum # of pays otherwise match for that exact number

op_carrypay

CARRYPAY

CHAR(1)

N

Gives system ability to carry pays. Valid Values: 1=yes

op_askordtime

ASKORDTIME

CHAR(1)

N

Allow operator override in dispatch when completing work. Valid Values: 1= Ask order time

op_calcprorat

CALCPRORAT

CHAR(1)

N

Calculate and display the prorate in O/E. Valid Values: 1=Calculate prorate in order entry

op_wipinfo

WIPINFO

CHAR(1)

N

Wip info flag indicating display in order entry window. Valid Values: 1=ov/ug, 2=dwell, 3=addrs box

op_zipchk

ZIPCHK

CHAR(1)

N

Edit in order entry if zip code not in table. Valid Values: 1=hard error

op_primsecwrn

PRIMSECWRN

CHAR(1)

N

Edit check for basic on primary/second ary outlets. Valid Values: 1=hard warning

op_phonreq

PHONREQ

CHAR(1)

N

Flag to require customer’s phone number. Valid Values: 1 = yes

op_aptdef

APTDEF

CHAR(1)

N

Apartment Default. Valid Values: NOT APT QUALIFIER this is something else..soon to be announced or removed.

Op_vercusdata

VERCUSDATA

CHAR(1)

N

Verify customer data on a change of service order. Valid Values: 1=verify

op_lbxminamt

LBXMINAMT

NUMERIC SIGNED

N

Lockbox minimum payment amount. Valid Values:

op_lbxmaxamt

LBXMAXAMT

NUMERIC SIGNED

N

Lockbox maximum payment amount. Valid Values:

op_minautowo

MINAUTOWO

NUMERIC UNSIGNED

N

Maximum balance for automatic account write-off should be one cent higher than collection min. Valid Values:

op_nopayqgrp

NOPAYQGRP

SMALLINT SIGNED

N

Used for non-pay disconnects. Valid Values: 1-8

op_nopaypri

NOPAYPRI

CHAR(1)

N

Used for non-pay disconnects. Valid Values:

op_nopaytask

NOPAYTASK

CHAR(3)

N

Task code used for non-pay disconnect orders. Valid Values: 1-999

op_nopaybxoff

NOPAYBXOFF

CHAR(1)

N

Flag used by collections run to change boxes to the off mask when creating non pay disconnect orr. Valid Values: 1=yes

op_nopaycroff

NOPAYCROFF

CHAR(1)

N

Flag for posting to calculate an adjustment for the time a box was turned off until it is reauthor. Valid Values: 1 = yes give credit for time box off.. posting or cancel of nonpay< /td>

op_npayadjrsn

NPAYADJRSN

CHAR(2)

N

Used when credit given for cancelled non-pays. Valid Values: "00"-"ZZ"

op_wrtoffrsn

WRTOFFRSN

CHAR(2)

N

Adjustment reason code. Valid Values: "00"-"ZZ"

op_refundrsn

REFUNDRSN

CHAR(2)

N

Adjustment code used when creating refunds. Valid Values: "00"-"ZZ"

op_recvyrsn

RECVYRSN

CHAR(2)

N

Adjustment code used by posting for recovery batches. Valid Values: "00"-"ZZ"

op_npaydisrsn

NPAYDISRSN

CHAR(1)

N

Non-pay disconnect reason code. Valid Values:

op_crwoffrsn

CRWOFFRSN

CHAR(2)

N

Credit writeoff reason. Valid Values: "00"-"ZZ"

op_cxnopayrsn

CXNOPAYRSN

CHAR(3)

N

Cancel non-pay reason. Valid Values: 1-999

op_depadjrsn1

DEPADJRSN1

CHAR(2)

N

Category P adjustment reason code that affect s the deposit bucket only. Valid Values: "00"-"ZZ"

op_depadjrsn2

DEPADJRSN2

CHAR(2)

N

Category P adjustment reason code that affect s the deposit bucket only. Valid Values: "00"-"ZZ"

op_poolinsgrp

POOLINSGRP

CHAR(1)

N

Checkin flag to send installs to the pool. Valid Values: blank=none, 1=not done, 2= open,A#,nxt, 3=all

op_pooldisc

POOLDISC

CHAR(1)

N

Checkin flag to send disconnects to the pool. Valid Values: blank = none: 1 = not done; 2 = open, A#, NX; 3 = all types

op_poolnpdisc

POOLNPDISC

CHAR(1)

N

Checkin flag to send non pays to the poo l. Valid Values: blank=none, 1=not done, 2=open,A#,nxt, 3=all

op_pooltcs

POOLTCS

CHAR(1)

N

Checkin flag to send trouble calls to the pool. Valid Values: blank = none; 1 = not done; 2 = open, A#, NX; 3 = all types

op_poolsros

POOLSROS

CHAR(1)

N

Checkin flag to send SRO’s to the pool. Valid Values: blank = NONE; 1 = not done; 2 = open, A#, NX; 3 = all types

op_autontinst

AUTONTINST

CHAR(1)

N

No-truck auto complete installation. Valid Values: 1=Allow

op_autontrest

AUTONTREST

CHAR(1)

N

No-truck auto complete on restart. Valid Values: 1=allow

op_autontchg

AUTONTCHG

CHAR(1)

N

No-truck auto complete change of service. Valid Values: 1=allow

op_autontdisc

AUTONTDISC

CHAR(1)

N

No-truck auto complete disconnect. Valid Values: 1=allow

op_autonttc

AUTONTTC

CHAR(1)

N

No-truck auto complete on trouble calls. Valid Values: 1=allow

op_autontsro

AUTONTSRO

CHAR(1)

N

No-truck auto complete on SRO’s. Valid Values: 1=allow

op_cdwgrpinst

CDWGRPINST

CHAR(1)

N

CDW summary group for install. Valid Values: 1-3

op_cdwgrprest

CDWGRPREST

CHAR(1)

N

CDW summary group for restart. Valid Values: 1-3

op_cdwgrpchg

CDWGRPCHG

CHAR(1)

N

CDW summary group for change of service. Valid Values: 1-3

op_cdwgrpdisc

CDWGRPDISC

CHAR(1)

N

kCDW summary group for disconnect. Valid Values: 1-3

op_cdwgrptc

CDWGRPTC

CHAR(1)

N

CDW summary group for trouble calls. Valid Values: 1-3

op_cdwgrpsro

CDWGRPSRO

CHAR(1)

N

CDW summary group for SRO. Valid Values: 1-3

op_verphonchg

VERPHONCHG

CHAR(1)

N

Verify phone # on a change of service. Valid Values: 1 = YES

op_verphondisc

VERPHONDISC

CHAR(1)

N

Verify phone # on a disconnect. Valid Values: 1 = YES

op_verphonrsc

VERPHONRSC

CHAR(1)

N

Verify phone # on reschedules. Valid Values: 1 = YES

op_verphontc

VERPHONTC

CHAR(1)

N

Verify phone # on a trouble call. Valid Values: 1 = YES

op_verssnchg

VERSSNCHG

CHAR(1)

N

Verify social security # on a change of s ervice. Valid Values: 1 = YES

op_verssndisc

VERSSNDISC

CHAR(1)

N

Verify social security # on a disconnect. Valid Values: 1 = YES

op_verssnrsc

VERSSNRSC

CHAR(1)

N

Verify social security # on a reschedule. Valid Values: 1 = YES

op_verssntc

VERSSNTC

CHAR(1)

N

Verify social security # on a trouble call. Valid Values: 1 = YES

op_rschdctr

RSCHDCTR

CHAR(1)

N

Only increment reschedule counter if csr has changed time slot or date. Valid Values: n=increment counter on all changes

op_chkbpclasscode

CHKBPCLASSCODE

CHAR(1)

N

Bypass customer class field in check-in. Valid Values: 1=Bypass this field

op_chkbpcusttype

CHKBPCUSTTYPE

CHAR(1)

N

Bypass customer type field in check-in. Valid Values: 1=Bypass this field

op_chkbpcustinfo

CHKBPCUSTINFO

CHAR(1)

N

Bypass customer info field in check-in. Valid Values: 1=Bypass this field

op_chkbpcamp

CHKBPCAMP

CHAR(1)

N

Bypass campaign field in check-in. Valid Values: 1=Bypass this field

op_chkbpsalesrsn

CHKBPSALESRSN

CHAR(1)

N

Bypass sales reason in check-in. Valid Values: 1=Bypass this field

op_chkbpchangersn

CHKBPCHANGERSN

CHAR(1)

N

Bypass change reason in check-in. Valid Values: 1=Bypass this field

op_chkbpmode

CHKBPMODE

CHAR(1)

N

Bypass billing mode in check-in. Valid Values: 1=Bypass this field

op_chkbpdrop

CHKBPDROP

CHAR(1)

N

Bypass new drop flag in check-in. Valid Values: 1=Bypass this field

op_chkbptag

CHKBPTAG

CHAR(1)

N

Bypass tag number in check-in. Valid Values: 1=Bypass this field

op_chkbpprorate

CHKBPPRORATE

CHAR(1)

N

Bypass pro-rate in check-in. Valid Values: 1=Bypass this field

op_chkbpdisc

CHKBPDISC

CHAR(1)

N

Bypass discount code in check-in. Valid Values: 1=Bypass this field

op_chkbpnewmsg

CHKBPNEWMSG

CHAR(1)

N

Bypass new message field in check-in. Valid Values: 1=Bypass this field

op_chkbpform

CHKBPFORM

CHAR(1)

N

Bypass billing form in check-in. Valid Values: 1=Bypass this field

op_chkbpremsch

CHKBPREMSCH

CHAR(1)

N

Bypass reminder scheme in check-in. Valid Values: 1=Bypass this field

op_chkbpcycle

CHKBPCYCLE

CHAR(1)

N

Bypass billing cycle in check-in. Valid Values: 1=Bypass this field

op_chkbpconst

CHKBPCONST

CHAR(1)

N

Check-in bypass field for construction area. Valid Values: 1=Bypass this field

op_chkbpdwell

CHKBPDWELL

CHAR(1)

N

Bypass dwelling code in check-in. Valid Values: 1=Bypass this field

op_chkbpovug

CHKBPOVUG

CHAR(1)

N

Bypass overhead underground code in check-in. Valid Values: 1=Bypass this field

op_chkbphinfo

CHKBPHINFO

CHAR(1)

N

Bypass the house info field in check-in. Valid Values: 1=Bypass this field

op_chkbptvtype

CHKBPTVTYPE

CHAR(1)

N

Bypass the TV type field in check-in. Valid Values: 1=Bypass this field

op_chkbpbox

CHKBPBOX

CHAR(1)

N

Bypass the box number keyin field in check-in. Valid Values: 1=Bypass this field

op_chkbpaddleq

CHKBPADDLEQ

CHAR(1)

N

Check-in bypass field for the addl equipment field. Valid Values: 1=Bypass this field

op_chkbpboxloc

CHKBPBOXLOC

CHAR(1)

N

Bypass box location keyin in check-in. Valid Values: 1=Bypass this field

op_chkbppin

CHKBPPIN

CHAR(1)

N

Bypass the box PIN # field in check-in. Valid Values: 1=Bypass this field

op_oebpclasscode

OEBPCLASSCODE

CHAR(1)

N

Bypass customer class in order entry. Valid Values: 1 = skip this field

op_oebpcusttype

OEBPCUSTTYPE

CHAR(1)

N

Bypass customer type in order entry and dispa tch. Valid Values: 1 = bypass this field

op_oebpcustinfo

OEBPCUSTINFO

CHAR(1)

N

Bypass customer info field in order entry. Valid Values: 1 = BYPASSS THIS FIELD

op_oebpcamp

OEBPCAMP

CHAR(1)

N

Bypass campaign in order entry/dispatch. Valid Values: 1 = skip this field

op_oebpsalesrsn

OEBPSALESRSN

CHAR(1)

N

Bypass sales reason in order entry and dispat ch. Valid Values: 1 = SKIP/BYPASS THIS FIELD

op_oebpcod

OEBPCOD

CHAR(1)

N

Bypass COD in order entry. Valid Values: 1 = skip/bypass this field

op_oebpmode

OEBPMODE

CHAR(1)

N

Bypass billing mode in order entry and dispat ch. Valid Values: 1 = skip/bypass this field

op_oebpdrop

OEBPDROP

CHAR(1)

N

Bypass new drop field in order entry. Valid Values: 1 = skip/bypass this field

op_oebptag

OEBPTAG

CHAR(1)

N

Bypass tag # field in order entry and dispatc h. Valid Values: 1 = skip/bypass this field

op_oebpprorate

OEBPPRORATE

CHAR(1)

N

Bypass prorate in order entry and dispatch. Valid Values: 1 = skip this field

op_oebpdisc

OEBPDISC

CHAR(1)

N

Bypass discount code in order entry. Valid Values: 1 = ski p this field

op_oebpnewmsg

OEBPNEWMSG

CHAR(1)

N

Bypass new message in order entry and dispatc h. Valid Values: 1 = bypass/skip this field

op_oebpform

OEBPFORM

CHAR(1)

N

Bypass billing form in order entry and dispat ch. Valid Values: 1 = skip (bypass) this field

op_oebppremsch

OEBPPREMSCH

CHAR(1)

N

OP BYPASS REMINDER SCHEME. Valid Values: SPACE OR ‘1’

op_oebpcycle

OEBPCYCLE

CHAR(1)

N

Bypass billing cycle in order entry and dispatch. Valid Values: 1=bypass/skip this field

op_oebpbilldate

OEBPBILLDATE

CHAR(1)

N

Bypass bill date in order entry and dispatch. Valid Values: 1 = bypass/skip this field

op_oebpbox

OEBPBOX

CHAR(1)

N

Bypass box serial # in order entry. Valid Values: 1 = bypass/skip this field

op_oebpwinfo

OEBPWINFO

CHAR(1)

N

Bypass wip info in order entry and dispatch. Valid Values: 1 = skip this field

op_oebpdisptech

OEBPDISPTECH

CHAR(1)

N

Bypass tech # in dispatch. Valid Values: 1=bypass/skip this field

op_oebpdisptag

OEBPDISPTAG

CHAR(1)

N

Bypass tag # in dispatch. Valid Values: 1 = skip this fiel d

op_oebpdispbox

OEBPDISPBOX

CHAR(1)

N

Bypass box serial # in dispatch. Valid Values: 1 = skip th is field

op_oebpaddleq

OEBPADDLEQ

CHAR(1)

N

Bypass additional equipment field in order entry and dispatch. Valid Values: 1 = skip/bypass this field

op_oebpboxloc

OEBPBOXLOC

CHAR(1)

N

Bypass box location in order entry and dispat ch. Valid Values: 1 = skip/bypasss this field

op_oebppin

OEBPPIN

CHAR(1)

N

Bypass box personal info in order entry and dispatch. Valid Values: 1 = skip/bypass this field

op_oebpchangersn

OEBPCHANGERSN

CHAR(1)

N

OP BYPASS CHANGE REASON. Valid Values: SPACE OR ‘1’

op_oebptimecode

OEBPTIMECODE

CHAR(1)

N

Bypass time code in order entry and dispatch. Valid Values: 1= bypass

op_spclcycl

SPCLCYCL

CHAR(1)

N

Customer cycle override. Valid Values: blank=by priority, 1 = use current,2 =use zip code table, 3= use schedule area table

op_spclrem

SPCLREM

CHAR(1)

N

Reminder scheme override. Valid Values: blank=by priority, 1=same as cycle

op_spclchg

SPCLCHG

CHAR(1)

N

Leave existing cycle on change of service restart. Valid Values: 1 = leave existing cycle

op_defrem

DEFREM

CHAR(1)

N

Override reminder scheme. Valid Values: blank = by priority; 1 = same as cycle

op_grp1mode

GRP1MODE

CHAR(1)

N

Default billing mode for priority group 1 for ‘billing defaults’ determination. Valid Values:

op_grp1form

GRP1FORM

CHAR(1)

N

Default form for priority group 1 for ‘billing defaults’ determination. Valid Values:

op_grp1rem

GRP1REM

CHAR(1)

N

Default reminder scheme for priority grp 1 for ‘billing defaults’ determination. Valid Values: CODE36 Table 122

op_grp1pro

GRP1PRO

CHAR(1)

N

Default prorate plan for priority group 1 for ‘billing defaults’ determination. Valid Values:

op_grp1cycl

GRP1CYCL

CHAR(1)

N

Default cycle for priority group 1 for ‘billing defaults’ determination. Valid Values: CODE36 Table 126

op_grp1discnt

GRP1DISCNT

CHAR(1)

N

Default discount code for priority group 1 for ‘billing defaults’ determination. Valid Values:

op_grp1msg

GRP1MSG

CHAR(2)

N

Default new message# for priority group 1 for ‘billing defaults’ determination. Valid Values:

op_grp2mode

GRP2MODE

CHAR(1)

N

Default billing mode for priority group 2 for billing defaults determination. Valid Values:

op_grp2form

GRP2FORM

CHAR(1)

N

Default billing form for priority group 2 for billing defaults determination. Valid Values:

op_grp2rem

GRP2REM

CHAR(1)

N

Default reminder scheme for priority grp 2 for billing defaults determination. Valid Values: CODE36 Table 122

op_grp2pro

GRP2PRO

CHAR(1)

N

Default prorate plan for priority group 2 for billing defaults determination. Valid Values:

op_grp2cycl

GRP2CYCL

CHAR(1)

N

Default cycle for priority group 2 for billing defaults determination. Valid Values: CODE36 Table 126

op_grp2discnt

GRP2DISCNT

CHAR(1)

N

Default discount code for priority group for billing defaults determination. Valid Values:

op_grp2msg

GRP2MSG

CHAR(2)

N

Default new message# for priority group 2 for billing defaults determination. Valid Values:

op_grp3mode

GRP3MODE

CHAR(1)

N

Default billing mode for priority group 3 for billing defaults determination. Valid Values:

op_grp3form

GRP3FORM

CHAR(1)

N

Default billing form for priority group 3 for billing defaults determination. Valid Values:

op_grp3rem

GRP3REM

CHAR(1)

N

Default reminder scheme for priority grp 3 for billing defaults determination. Valid Values: CODE36 Table 122

op_grp3pro

GRP3PRO

CHAR(1)

N

Default prorate plan for priority group 3 for billing defaults determination. Valid Values:

op_grp3cycl

GRP3CYCL

CHAR(1)

N

Default cycle for priority group 3 for billing defaults determination. Valid Values: CODE36 Table 126

op_grp3discnt

GRP3DISCNT

CHAR(1)

N

Default discount code for priority group 3 for billing defaults determination. Valid Values:

op_grp3msg

GRP3MSG

CHAR(2)

N

Default new message# for priority group 3 for billing defaults determination. Valid Values:

op_grp4mode

GRP4MODE

CHAR(1)

N

Default billing mode for priority group 4 for billing defaults determination. Valid Values:

op_grp4form

GRP4FORM

CHAR(1)

N

Default billing form for priority group 4 for billing defaults determination. Valid Values:

op_grp4rem

GRP4REM

CHAR(1)

N

Default reminder scheme for priority grp 4 for billing defaults determination. Valid Values: CODE36 Table 122

op_grp4pro

GRP4PRO

CHAR(1)

N

Default prorate plan for priority group 4 for billing defaults determination. Valid Values:

op_grp4cycl

GRP4CYCL

CHAR(1)

N

Default cycle for priority group 4 for billing defaults determination. Valid Values: CODE36 Table 126

op_grp4discnt

GRP4DISCNT

CHAR(1)

N

Default discount code for priority group 4 for billing defaults determination. Valid Values:

op_grp4msg

GRP4MSG

CHAR(2)

N

Default new message# for priority group 4 for billing defaults determination. Valid Values:

op_grp5mode

GRP5MODE

CHAR(1)

N

Default billing mode for priority group 5 for billing defaults determination. Valid Values:

op_grp5form

GRP5FORM

CHAR(1)

N

Default billing form for priority group 5 for billing defaults determination. Valid Values:

op_grp5rem

GRP5REM

CHAR(1)

N

Default reminder scheme for priority grp 5 for billing defaults determination. Valid Values: CODE36 Table 122

op_grp5pro

GRP5PRO

CHAR(1)

N

Default prorate plan for priority group 5 for billing defaults determination. Valid Values:

op_grp5cycl

GRP5CYCL

CHAR(1)

N

Default cycle for priority group 5 for billing defaults determination. Valid Values: CODE36 Table 126

op_grp5discnt

GRP5DISCNT

CHAR(1)

N

Default discount code for priority group for billing defaults determination. Valid Values:

op_grp5msg

GRP5MSG

CHAR(2)

N

Default new message# for priority group 5 for billing defaults determination. Valid Values:

op_rembclscur

REMBCLSCUR

CHAR(1)

N

Reminder scheme B close at current money. Valid Values: 1 = use to calculate

op_remcclscur

REMCCLSCUR

CHAR(1)

N

Reminder scheme C close at current money. Valid Values: 1 = use to calculate

op_remdclscur

REMDCLSCUR

CHAR(1)

N

Reminder scheme D close at current money. Valid Values: 1 = use to calculate

op_sroqgrp

SROQGRP

SMALLINT UNSIGNED

N

SRO quota group number. Valid Values: 1-8

op_discqgrp

DISCQGRP

SMALLINT UNSIGNED

N

Disconnect quota group. Valid Values: 1-8

op_tcqgrp

TCQGRP

SMALLINT UNSIGNED

N

Trouble call quota group number. Valid Values: 1-8

op_autotrnrsn

AUTOTRNRSN

CHAR(2)

N

Adjustment reason used to transfer money to new account.. Valid Values: "00"-"ZZ"

op_cxlchgsvcrsn

CXLCHGSVCRSN

CHAR(3)

N

If change of service is auto cancelled because of creation of NPD…..the cancel reason to use.. Valid Values: 1-999

op_chkbpcustmail

CHKBPCUSTMAIL

CHAR(1)

N

Cursor by pass control flag for Customer Mail flagkeyin in Check In. Valid Values: Y or N

op_oebpcustmail

OEBPCUSTMAIL

CHAR(1)

N

Cursor by pass control flag for Customer Mail flagkeyin in Order Entry. Valid Values: Y or N

o2p_coverfmt

COVERFMT

SMALLINT SIGNED

N

Cover sheet format. Valid Values:

o2p_filebytech

FILEBYTECH

CHAR(1)

N

Flag to create separate prt’s when doing route cards and work orders. Valid Values: 1=separate Routing print files by tech

o2p_equiprpt

EQUIPRPT

CHAR(1)

N

Routing will create box report. Valid Values: 1=Print

o2p_warnxfer

WARNXFER

CHAR(1)

N

Display transfer info on warning screen. Valid Values: 1 = DISPLAY

o2p_warnppvclb

WARNPPVCLB

CHAR(1)

N

Display PPV Club on warning screen. Valid Values: 1 = DISPLAY

o2p_warnefts

WARNEFTS

CHAR(1)

N

Display EFTS info on warning screen. Valid Values: 1 = DISPLAY

o2p_warndelq

WARNDELQ

CHAR(1)

N

Display delinquent balance on warning screen. Valid Values: 1 = DISPLAY

o2p_warnclust

WARNCLUST

CHAR(1)

N

Display cluster code on warning screen. Valid Values: 1 = DISPLAY

o2p_warncncl

WARNCNCL

CHAR(1)

N

Display cancel reason on warning screen. Valid Values: 1 = DISPLAY

o2p_warnctype

WARNCTYPE

CHAR(1)

N

Display cust type on warning screen. Valid Values: 1 = DISPLAY

o2p_warncinfo

WARNCINFO

CHAR(1)

N

Display customer info on warning screen. Valid Values: 1 = DISPLAY

o2p_warnclass

WARNCLASS

CHAR(1)

N

Display customer class on warning screen. Valid Values: 1 = DISPLAY

o2p_warnwrtoff

WARNWRTOFF

CHAR(1)

N

Display write-off amount on warning screen. Valid Values: 1 = DISPLAY

o2p_warnonpay

WARNONPAY

CHAR(1)

N

Display non-pay info on warning screen. Valid Values: 1 = DISPLAY

o2p_warnbox

WARNBOX

CHAR(1)

N

Display unreturned box on warning screen. Valid Values: 1 = DISPLAY

o2p_warnhinfo

WARNHINFO

CHAR(1)

N

Display house info on warning screen. Valid Values: 1 = DISPLAY

o2p_warndwell

WARNDWELL

CHAR(1)

N

Display dwelling on warning screen. Valid Values: 1 = DISPLAY

o2p_warncarea

WARNCAREA

CHAR(1)

N

Display construction area on warning screen. Valid Values: 1 = DISPLAY

o2p_warnhcmt

WARNHCMT

CHAR(1)

N

Display house file comment on warning screen. Valid Values: 1 = DISPLAY

o2p_warndual

WARNDUAL

CHAR(1)

N

Display dual account info on warning screen. Valid Values: 1 = DISPLAY

o2p_warnoutg

WARNOUTG

CHAR(1)

N

Display outage alert on warning screen. Valid Values: 1 = DISPLAY

o2p_warnmtype

WARNMTYPE

CHAR(1)

N

Display Market type on warning screen. Valid Values: 1 = DISPLAY

o2p_warnzip

WARNZIP

CHAR(1)

N

Display zip code and city on warning screen. Valid Values: 1 = DISPLAY

o2p_warncomplx

WARNCOMPLX

CHAR(1)

N

Display Complex on warning screen. Valid Values: 1 = DISPLAY

o2p_brstagzip

BRSTAGZIP

CHAR(1)

N

Display tag or zip in browse. Valid Values: blank=tag, 1=zip

o2p_brshsecmt

BRSHSECMT

CHAR(1)

N

Display house comment in browse option in o/e. Valid Values: 1=Display

o2p_brsarea

BRSAREA

CHAR(1)

N

O/E browse option for area. Valid Values: blank=mgt, 1=ftax

o2p_brspaycd

BRSPAYCD

CHAR(1)

N

Display number of pay codes when browsing. Valid Values: 1=Display

o2p_wofmtinst

WOFMTINST

SMALLINT SIGNED

N

Format for install. Valid Values:

o2p_wofmtrest

WOFMTREST

SMALLINT SIGNED

N

Format for restart. Valid Values:

o2p_wofmtchg

WOFMTCHG

SMALLINT SIGNED

N

Format for change of service. Valid Values:

o2p_wofmtdisc

WOFMTDISC

SMALLINT SIGNED

N

Format for disconnect. Valid Values:

o2p_wofmttc

WOFMTTC

SMALLINT SIGNED

N

Format for trouble call. Valid Values:

o2p_wofmtsro

WOFMTSRO

SMALLINT SIGNED

N

Format for SRO. Valid Values:

o2p_rcfmtinst

RCFMTINST

SMALLINT SIGNED

N

Format for install. Valid Values:

o2p_rcfmtrest

RCFMTREST

SMALLINT SIGNED

N

Format for restart. Valid Values:

o2p_rcfmtchg

RCFMTCHG

SMALLINT SIGNED

N

Format for change of service. Valid Values:

o2p_rcfmtdisc

RCFMTDISC

SMALLINT SIGNED

N

Route card format for disconnect. Valid Values:

o2p_rcfmttc

RCFMTTC

SMALLINT SIGNED

N

Format for trouble call. Valid Values:

o2p_rcfmtsro

RCFMTSRO

SMALLINT SIGNED

N

Format for SRO. Valid Values:

o2p_brktech1

BRKTECH1

SMALLINT UNSIGNED

N

CDW report subtotal #1: tech number. Valid Values:

o2p_brkdesc1

BRKDESC1

CHAR(12)

N

CDW report subtotal #1: report description. Valid Values:

o2p_brktech2

BRKTECH2

SMALLINT UNSIGNED

N

CDW report subtotal #2: tech number. Valid Values:

o2p_brkdesc2

BRKDESC2

CHAR(12)

N

CDW report subtotal #2: report description. Valid Values:

o2p_brktech3

BRKTECH3

SMALLINT UNSIGNED

N

CDW report subtotal #3: tech number. Valid Values:

o2p_brkdesc3

BRKDESC3

CHAR(12)

N

CDW report subtotal #3: report description. Valid Values:

o2p_brktech4

BRKTECH4

SMALLINT UNSIGNED

N

CDW report subtotal #4: tech number. Valid Values:

o2p_brkdesc4

BRKDESC4

CHAR(12)

N

CDW report subtotal #4: report description. Valid Values:

o2p_brktech5

BRKTECH5

SMALLINT UNSIGNED

N

CDW report subtotal #5: tech number. Valid Values:

o2p_brkdesc5

BRKDESC5

CHAR(12)

N

CDW report subtotal #5: report description. Valid Values:

o2p_brktech6

BRKTECH6

SMALLINT UNSIGNED

N

CDW report subtotal #6: tech number. Valid Values:

o2p_brkdesc6

BRKDESC6

CHAR(12)

N

CDW report subtotal #6: report description. Valid Values:

o2p_acctgarea

ACCTGAREA

CHAR(1)

N

Accounting area switch OR the accounting area OR the accounting area designator….based on program. Valid Values: if switch then 1=mgt area, 2=ftax area

o2p_advcharge

ADVCHARGE

CHAR(1)

N

Advance charge. Valid Values: 1=Charge in advance

o2p_minrefund

MINREFUND

NUMERIC UNSIGNED

N

Minimum balance to qualify for a refund. Valid Values:

o2p_woffhold

WOFFHOLD

SMALLINT UNSIGNED

N

Minimum number of days to hold before writing off a credit balance disconnect. Valid Values:

o2p_intqualify

INTQUALIFY

SMALLINT UNSIGNED

N

Number days to qualify for interest calculation. Valid Values:

o2p_intrate

INTRATE

SMALLINT SIGNED

N

Percentage rate for charging interest. Valid Values:

o2p_intcompnd

INTCOMPND

CHAR(1)

N

Compound interest annually. Valid Values: 1=compound

o2p_intyear

INTYEAR

CHAR(1)

N

Calculate interest for this year only. Valid Values: 1=yes

o2p_intchkin

INTCHKIN

CHAR(1)

N

Display interest at check-in of disco. Valid Values: 1=disp

o2p_sendlist

SENDLIST

CHAR(1)

N

Send refunds switch. Valid Values: 1=Create send list in refunds, blank=put all to hold list

o2p_cxlchecks

CXLCHECKS

CHAR(1)

N

Refund option to process cancelled checks. Valid Values: 1=process cancelled checks

o2p_opencdw01

OPENCDW01

DATETIME

Y

Current Day’s Work file:slot 1 (not yet checked in). Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw02

OPENCDW02

DATETIME

Y

Open CDW in slot 2. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw03

OPENCDW03

DATETIME

Y

Open CDW in slot 3. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw04

OPENCDW04

DATETIME

Y

Open CDW in slot 4. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw05

OPENCDW05

DATETIME

Y

Open CDW in slot 5. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw06

OPENCDW06

DATETIME

Y

Open CDW in slot 6. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw07

OPENCDW07

DATETIME

Y

Open CDW in slot 7. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw08

OPENCDW08

DATETIME

Y

Open CDW in slot 8. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw09

OPENCDW09

DATETIME

Y

Open CDW in slot 9. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw10

OPENCDW10

DATETIME

Y

Open CDW in slot 10. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw11

OPENCDW11

DATETIME

Y

Open CDW in slot 11. Valid Values: If date value in this column…then day is not checked in yet

o2p_opencdw12

OPENCDW12

DATETIME

Y

Open CDW in slot 12. Valid Values: If date value in this column…then day is not checked in yet

o2p_purgecdw1

PURGECDW1

DATETIME

Y

Current Day’s Work file ready to purge in slot 1. Valid Values:

o2p_purgecdw2

PURGECDW2

DATETIME

Y

CDW ready to purge in slot 2. Valid Values:

o2p_purgecdw3

PURGECDW3

DATETIME

Y

CDW ready to purge in slot 3. Valid Values:

o2p_purgecdw4

PURGECDW4

DATETIME

Y

CDW ready to purge in slot 4. Valid Values:

o2p_purgecdw5

PURGECDW5

DATETIME

Y

CDW ready to purge in slot 5. Valid Values:

o2p_wipsort1

WIPSORT1

CHAR(2)

N

Route card Wip sort parameter #1. Valid Values:

o2p_wipsort2

WIPSORT2

CHAR(2)

N

Route card Wip sort parameter #2. Valid Values:

o2p_wipsort3

WIPSORT3

CHAR(2)

N

Route card Wip sort parameter #3. Valid Values:

o2p_wipsort4

WIPSORT4

CHAR(2)

N

Route card Wip sort parameter #4. Valid Values:

o2p_wipsort5

WIPSORT5

CHAR(2)

N

Route card Wip sort parameter #5. Valid Values:

o2p_wipsort6

WIPSORT6

CHAR(2)

N

Route card Wip sort parameter #6. Valid Values:

o2p_tcsort1

TCSORT1

CHAR(2)

N

Route Card trouble call sort parameter #1. Valid Values:

o2p_tcsort2

TCSORT2

CHAR(2)

N

Route card trouble call sort parameter #2. Valid Values:

o2p_tcsort3

TCSORT3

CHAR(2)

N

Route card trouble call sort parameter #3. Valid Values:

o2p_tcsort4

TCSORT4

CHAR(2)

N

Route card trouble call sort parameter #4. Valid Values:

o2p_tcsort5

TCSORT5

CHAR(2)

N

Route card trouble call sort parameter #5. Valid Values:

o2p_tcsort6

TCSORT6

CHAR(2)

N

Route card trouble call sort parameter #6. Valid Values:

o2p_srosort1

SROSORT1

CHAR(2)

N

Route card SRO sort parameter #1. Valid Values:

o2p_srosort2

SROSORT2

CHAR(2)

N

Route card SRO sort parameter #2. Valid Values:

o2p_srosort3

SROSORT3

CHAR(2)

N

Route card SRO sort parameter #3. Valid Values:

o2p_srosort4

SROSORT4

CHAR(2)

N

Route card SRO sort parameter #4. Valid Values:

o2p_srosort5

SROSORT5

CHAR(2)

N

Route card SRO sort parameter #5. Valid Values:

o2p_srosort6

SROSORT6

CHAR(2)

N

Route Card SRO sort parameter #6. Valid Values:

o2p_crpbanknum

CRPBANKNUM

CHAR(8)

N

Corp’s transit/aba bank number for EFTS. Valid Values:

o2p_crppacacct

CRPPACACCT

CHAR(12)

N

Bank PAC account number for EFTS. Valid Values:

o2p_eftfmt

EFTFMT

CHAR(1)

N

EFTS format switch. Valid Values: 0=draft, 1=Toronto Dominion, 2= Canadian Imperial 3=NACHA, 4=Nova Scotia, 5=Bahamas PC

o2p_eftsort

EFTSORT

CHAR(1)

N

EFTS report sort. Valid Values: 1=bank,2=financial #,3=zip,4=f/tax, 5=mgt

o2p_eftdisc

EFTDISC

CHAR(1)

N

Change bill form/mode to S1 on a disconnect,and delete bank record from EFTS table. Valid Values: 1=yes

o2p_eftminbal

EFTMINBAL

NUMERIC SIGNED

N

Minimum balance to process customer on EFTS run. Valid Values:

o2p_pacidnum

PACIDNUM

CHAR(10)

N

Pre-authorized checking id number. Valid Values:

o2p_pacdatactr

PACDATACTR

CHAR(5)

N

Pre-authorized checking data center number. Valid Values:

o2p_pacrunflag

PACRUNFLAG

CHAR(1)

N

PAC has been run this period. Valid Values: 1=run

o2p_pacrundate

PACRUNDATE

DATETIME

Y

Pre Authorized Checking last run date. Valid Values:

o2p_pacopr

PACOPR

CHAR(3)

N

Operator for last Pre Authorized Checking run. Valid Values:

o2p_pactape

PACTAPE

SMALLINT UNSIGNED

N

PAC last run tape #. Valid Values:

o2p_pacrunper

PACRUNPER

CHAR(1)

N

PAC last run period. Valid Values: a-x

o2p_pactransct

PACTRANSCT

CHAR(6)

N

PAC last run transaction count. Valid Values:

o2p_bcpmercht

BCPMERCHT

CHAR(8)

N

Bank card processing merchant number. Valid Values:

o2p_bcpdatactr

BCPDATACTR

CHAR(5)

N

Bank card processing data center number. Valid Values:

o2p_bcprunflag

BCPRUNFLAG

CHAR(1)

N

BCP has been run for this period. Valid Values: 1=run

o2p_bcprundate

BCPRUNDATE

DATETIME

Y

Bank card processing last run date. Valid Values:

o2p_bcpopr

BCPOPR

CHAR(3)

N

Operator ID for last BCP run. Valid Values:

o2p_bcpruntape

BCPRUNTAPE

SMALLINT UNSIGNED

N

Last BCP run tape #. Valid Values:

o2p_bcprunper

BCPRUNPER

CHAR(1)

N

Last BCP run period. Valid Values: a-x

o2p_bcptransct

BCPTRANSCT

CHAR(6)

N

Last BCP run transaction count. Valid Values:

o2p_bcpidnum

BCPIDNUM

CHAR(10)

N

BCP identification number. Valid Values:

o2p_achdest

ACHDEST

CHAR(8)

N

NACHA bank’s destination transit/ABA number. Valid Values:

o2p_achorig

ACHORIG

CHAR(10)

N

NACHA originating bank’s transit/ABA number. Valid Values:

o2p_achidnum

ACHIDNUM

CHAR(10)

N

NACHA identification number. Valid Values:

o2p_achdesc

ACHDESC

CHAR(10)

N

NACHA alpha description. Valid Values:

o2p_achtrace

ACHTRACE

INT UNSIGNED

N

NACHA trace number. Valid Values:

o2p_achrunflag

ACHRUNFLAG

CHAR(1)

N

Denotes if NACHA has been run this period. Valid Values: 1=run

o2p_achrundate

ACHRUNDATE

DATETIME

Y

NACHA last run date. Valid Values:

o2p_achopr

ACHOPR

CHAR(3)

N

Operator ID for last NACHA run. Valid Values:

o2p_achtape

ACHTAPE

SMALLINT UNSIGNED

N

NACHA last run tape #. Valid Values:

o2p_achrunper

ACHRUNPER

CHAR(1)

N

NACHA last run period code. Valid Values:

o2p_achtransct

ACHTRANSCT

CHAR(6)

N

Transaction count on last NACHA run. Valid Values:

o2p_taxround

TAXROUND

CHAR(1)

N

Accumulate tax rounding flag …...not used at this time. Valid Values: 1 = round accumulated tax

o2p_sumregard

SUMREGARD

CHAR(1)

N

Sum regardless flag …....not used at this time. Valid Values:

o2p_nxtcdwprg

NXTCDWPRG

SMALLINT UNSIGNED

N

Next CDW slot to purge. Valid Values:

o2p_dwoeventa

DWOEVENTA

CHAR(1)

N

The Disconnect work order task code for event A.. Valid Values:

o2p_dwoneventa

DWONEVENTA

CHAR(1)

N

The next event from DWO for collections schedule A. Valid Values:

o2p_dwoeventb

DWOEVENTB

CHAR(1)

N

DWO Event for collections schedule B.. Valid Values:

o2p_dwoneventb

DWONEVENTB

CHAR(1)

N

Next collections event for schedule B.. Valid Values:

o2p_dwoeventc

DWOEVENTC

CHAR(1)

N

DWO event for collections schedule C. Valid Values:

o2p_dwoneventc

DWONEVENTC

CHAR(1)

N

Next event from DWO for collections schedule C. Valid Values:

o2p_dwoeventd

DWOEVENTD

CHAR(1)

N

DWO event for collections schedule D. Valid Values:

o2p_dwoneventd

DWONEVENTD

CHAR(1)

N

Next Event from DWO for collections schedule D.. Valid Values:

o2p_quickwarnxfer

QUICKWARNXFER

CHAR(1)

N

Flag if should display Tranfer info on Warning screen if using Quick Access.. Valid Values: 1 = yes

o2p_quickwarnppvclb

QUICKWARNPPVCLB

CHAR(1)

N

When using Quick Access if should display PPV Club info on warning display. Valid Values: 1 = yes

o2p_quickwarnefts

QUICKWARNEFTS

CHAR(1)

N

When using quick access if should display EFTS info or not. Valid Values: 1 = yes

o2p_quickwarndelq

QUICKWARNDELQ

CHAR(1)

N

When using Quick Access if should display prompt if account is deliquent. Valid Values: 1 = yes

o2p_quickwarnclust

QUICKWARNCLUST

CHAR(1)

N

When using quick access if should display cluster info in warning screen. Valid Values: 1 = yes

o2p_quickwarncncl

QUICKWARNCNCL

CHAR(1)

N

When using quick access if the cancel reason should display on the warning screen. Valid Values: 1 = yes

o2p_quickwarnctype

QUICKWARNCTYPE

CHAR(1)

N

When using quick access if the customer type code/description should display in the warnings. Valid Values: 1 = yes

o2p_quickwarncinfo

QUICKWARNCINFO

CHAR(1)

N

When using quick access if the customer info code/descr should display in the warning screen. Valid Values: 1 = yes

o2p_quickwarnclass

QUICKWARNCLASS

CHAR(1)

N

When using quick access if the class code/descriptshould display in the warning screen. Valid Values: 1 = yes

o2p_quickwarnwrtoff

QUICKWARNWRTOFF

CHAR(1)

N

When using quick access if the writeoff warning should display. Valid Values: 1 = yes

o2p_quickwarnonpay

QUICKWARNONPAY

CHAR(1)

N

When using quick access if should display non pay info on the warning screen. Valid Values: 1 = yes

o2p_quickwarnbox

QUICKWARNBOX

CHAR(1)

N

When using quick access if should display prompt for unreturned converter in the warning screen. Valid Values: 1 = yes

o2p_quickwarnhinfo

QUICKWARNHINFO

CHAR(1)

N

When using quick access if should display the House Info code/description in the warning screen. Valid Values: 1 = yes

o2p_quickwarndwell

QUICKWARNDWELL

CHAR(1)

N

When using quick access if should display the Dwelling code descript in the warning screen. Valid Values: 1 = yes

o2p_quickwarncarea

QUICKWARNCAREA

CHAR(1)

N

When using quick access if should display the Construction Area code/descript in the warnings. Valid Values: 1 = yes

o2p_quickwarnhcmt

QUICKWARNHCMT

CHAR(1)

N

When using quick access if should display the House Comment in the warning screen. Valid Values: 1 = yes

o2p_quickwarndual

QUICKWARNDUAL

CHAR(1)

N

When using quick access if should display the DualAccount info in the warning screen. Valid Values: 1 = yes

o2p_quickwarnoutg

QUICKWARNOUTG

CHAR(1)

N

When using quick access if should display the outage alert on the warning screen. Valid Values: 1 = yes

o2p_quickwarnmtype

QUICKWARNMTYPE

CHAR(1)

N

When using quick access if should display the Market Type on the warning screen. Valid Values: 1 = yes

o2p_quickwarnzip

QUICKWARNZIP

CHAR(1)

N

When using quick access if should display the zip code and city description on the warning screen. Valid Values: 1 = yes

o2p_quickwarncomplx

QUICKWARNCOMPLX

CHAR(1)

N

When using quick access if should display the Complex info on the warning screen. Valid Values: 1 = yes

o2p_defhistflip

DEFHISTFLIP

SMALLINT SIGNED

N

Default history sort used when using the History flip. Valid Values: 1 = oldest first 2 = current first

o2p_wofrntctrfmt

WOFRNTCTRFMT

SMALLINT SIGNED

N

Default history sort used when using the History flip. Valid Values: 1 = oldest first 2 = current first

o2p_rcptfmt

RCPTFMT

SMALLINT SIGNED

N

Default history sort used when using the History flip. Valid Values: 1 = oldest first 2 = current first

o2p_drawertallyfmt

DRAWERTALLYFMT

SMALLINT SIGNED

N

Drawer tally format. Valid Values:

o2p_boxrcptfmt

BOXRCPTFMT

SMALLINT SIGNED

N

BOX RECEIPT FORMAT FOR FRONT COUNTER TOOL BOX. Valid Values: Any form server format

o2p_boxagrmntfmt

BOXAGRMNTFMT

SMALLINT SIGNED

N

Box agreement format for front counter tool box. Valid Values: Any form server format

o2p_xferefts

XFEREFTS

CHAR(1)

N

When transferring an account do we want to automatically transfer the EFTS info also. Valid Values: blank = no 1 = yes

o2p_xferbilling

XFERBILLING

CHAR(1)

N

When do a transfer do you want to transfer the Billing address also. Valid Values: blank = no 1 = yes

o2p_xfercomment

XFERCOMMENT

CHAR(1)

N

When doing a transfer do we transfer the customer comments also. Valid Values: blank = no 1=yes

o2p_defevtflip

DEFEVTFLIP

SMALLINT UNSIGNED

N

Used to designate the order of the events displayed in the event flip.. Valid Values: 1=oldest event item first 2=newest event item first

o2p_skipppvdisp

SKIPPPVDISP

CHAR(1)

N

Used to indicate whether or not to display past/pending ppv events when taking a ppv order.. Valid Values: Y=skip display N=do display

o2p_warnvip

WARNVIP

CHAR(1)

N

Designates if Order Processing should display a warning if the VIP flag is set. Valid Values: Y=yes

o2p_warnppvhold

WARNPPVHOLD

CHAR(1)

N

Designates if Order Processing should display a warning if the PPV hold is set. Valid Values: Y=yes

o2p_warnupghold

WARNUPGHOLD

CHAR(1)

N

Designates if Order Processing should display a warning if the Upgrade hold is set. Valid Values: Y=yes

o2p_quickwarnvip

QUICKWARNVIP

CHAR(1)

N

Designates if Order Processing should display a warning during quick access if VIP is set. Valid Values: Y=yes

o2p_quickwarnppvhold

QUICKWARNPPVHOLD

CHAR(1)

N

Designates if Order Processing should display a warning during quick access if there is a PPV hold. Valid Values: Y=yes

o2p_quickwarnupghold

QUICKWARNUPGHOLD

CHAR(1)

N

Designates if Order Processing should display a warning during quick access if there is an upgrade. Valid Values: hold Y=yes

o2p_quickwarntrnhold

QUICKWARNTRNHOLD

CHAR(1)

N

Designates if Order Processing should display a warning during quick access if the transfer hold. Valid Values: is set Y=yes

o2p_warntrnhold

WARNTRNHOLD

CHAR(1)

N

Designates if Order Processing should display a warning if the transfer hold is set. Valid Values: Y=yes

o2p_oebpbrsareacode

OEBPBRSAREACODE

CHAR(1)

N

Designates if Order Processing should display a warning if the transfer hold is set. Valid Values: Y=yes

o2p_oebpareacd

OEBPAREACD

CHAR(1)

N

Designates if Order Processing should display a warning if the transfer hold is set. Valid Values: Y=yes

o2p_oebprphonarea

OEBPRPHONAREA

CHAR(1)

N

Designates if Order Processing should display a warning if the transfer hold is set. Valid Values: Y=yes

o2p_warncust1

WARNCUST1

CHAR(1)

N

Flag designating if should display a warning if there is a customer comment 1.. Valid Values: Y=yes

o2p_warncust2

WARNCUST2

CHAR(1)

N

Flag designating if should display a warning if there is a customer comment type 2.. Valid Values: Y=yes

o2p_warncust3