GetPackageTable

XML Tag

Definition

comcorp

Five digit system number assigned to each corp.

house

6 digit house number

pt_pkg

2 character package table identifier

outlet

2 digit outlet number or Null

XML Tag

Column Name

Data Type

Nullable

Definition

pt_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

pt_pkg

PKG

CHAR(2)

N

Package code. Valid Values:

pt_pkgstop

PKGSTOP

CHAR(6)

N

Valid geographic area stop range. Valid Values: left justified

pt_pkgstr

PKGSTR

CHAR(6)

N

Valid geographic area start range. Valid Values: Left justified

pt_pkgnam

PKGNAM

CHAR(12)

N

Package name. Valid Values:

pt_jobedt

JOBEDT

CHAR(1)

N

Job edit code. Valid Values: 1 = new outlet, 2 = existing outlet, A =primary outlet, B = secondary outlet, blank = no edit

pt_qgrp

QGRP

SMALLINT UNSIGNED

N

Quota group number. Valid Values: 1-8

packagelinegroup

Beginning packagelinesgroup delimiter

packageline

Beginning packageline delimiter

pl_line

LINE

CHAR(4)

N

The package table line number for this rate code. Valid Values: 1 - 1260

pl_rcode

RCODE

CHAR(2)

N

Rate code - to charge for a service or combo of services. Valid Values: Any two alpha characters. AZ-HZ are non-standard rates and codes beginning with 'X' are free rates.

pl_pname

PNAME

CHAR(15)

N

Description for the rate code in this package. Valid Values:

pl_defltcnt

DEFLTCNT

CHAR(1)

N

Force a count on this code. Valid Values: 1= force count equal to the keyed in value value of 1

pl_taskgp

TASKGP

SMALLINT UNSIGNED

N

Code defining the row to select the task from the task matrix in the rate table. Valid Values: 1=use row 1, 2=use row 2, 3=use row 3, 4 =use row 1 in o/e opt 1,2; use row 2 in o/e opt 3

rcd_ramt

RAMT

NUMERIC SIGNED

N

Dollar amount to charge for this rate code. Valid Values:

rcd_rmult

RMULT

CHAR(1)

N

Flag indicating whether this rate code is charged by customer or by outlet. Valid Values: 1=charge by outlet, =charge by customer

rcd_ractv

RACTV

CHAR(1)

N

Flag indicating whether or not this rate code is currently active. Valid Values: 1=rate code is inactive =rate code active

rcd_rtype

RTYPE

CHAR(1)

N

Flag identifying this rate code as a primary or additional basic rate code. Valid Values: 1=primary rate code, 2=additional rate code =normal rate code

rcd_rcatg

RCATG

CHAR(1)

N

Rate code category. Valid Values: D=deposit, R=rent, S=service, I=install

rcd_rcarry

RCARRY

CHAR(1)

N

Flag indicating whether this rate code should be carried to additional outlets. Valid Values: 1=carry =don't carry

rcd_rnonstd

RNONSTD

CHAR(1)

N

Non-standard rate code flag. Valid Values: 1=non standard rate code =regular rate code

rcd_rsrvgrp

RSRVGRP

CHAR(1)

N

Rate code service group, used for reporting. Valid Values: 1-9

rcd_rcombo

RCOMBO

CHAR(1)

N

If service is standalone but combo's with others -this will be the supplier code.. Valid Values: Supplier code for the standalone service

rcd_rbox

RBOX

CHAR(2)

N

Equipment code for this rate. Valid Values: or 0 - 99

rcd_rpays

RPAYS

SMALLINT UNSIGNED

N

The number of pay services this rate code represents. Valid Values:

rcd_rdesc

RDESC

CHAR(8)

N

Rate code short description. Valid Values:

rcd_rname

RNAME

CHAR(16)

N

Rate code description. Valid Values:

rcd_format

FORMAT

CHAR(1)

N

Vendor box format OR mass corrections format OR MSO data rate code format. Valid Values: if MSO then - 0,1,3,4,5,7,9

rcd_digital

DIGITAL

SMALLINT SIGNED

N

Indicator value for digital rate code*or* Indicates whether or not equipment is digitalfor =SUPPORTED_EQUIPMENT.. Valid Values: 0=analog event 1=digital*or*0=not digital 1=digital

rcd_deliverysysid

DELIVERYSYSID

CHAR(20)

N

External system identifier. Each delivery systemis responsible for provisioning and/or deliveringa specific data service.. Valid Values: Alphanumeric character string

rcd_addressable

ADDRESSABLE

SMALLINT UNSIGNED

N

External system identifier. Each delivery systemis responsible for provisioning and/or deliveringa specific data service.. Valid Values: Alphanumeric character string

/packageline

Ending packageline delimiter

/packagelinesgroup

Ending packagelinesgroup delimiter

7/19/01

Modified definition for outlet "input" tag

Added Useage Item 1

Modified definition for output pt_jobedt tag