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

cqnp_corp

CORP

INT UNSIGNED

N

Five digit accounting corp number assigned to each corp

cqnp_partition

PARTITION

CHAR(2)

N

Data hashing value for database management - equals the last 2 digits of the house #. Valid Values:

cqnp_house

HOUSE

CHAR(6)

N

Up to six digit house number

cqnp_cust

CUST

CHAR(2)

N

Two digit customer number

notepadgroup

Beginning notepadgroup delimiter

notepad

Beginning notepad delimiter

cqnp_createdate

CREATEDATE

DATETIME

N

Creation Date for the report.. Valid Values: Date format MM/DD/YY(4 spaces)hh:mm(1 space)am

cqnp_action

ACTION

CHAR(2)

N

Codd95 Table (208). Action code taken.. Valid Values: 1-95

cqnp_ticklerdate

TICKLERDATE

DATETIME

Y

Tickler date for the last action taken on this account.. Valid Values:

cqnp_oprid

OPRID

CHAR(3)

N

Operator ID.. Valid Values: 3 character alpha/numeric value

cqnp_note

NOTE

VARCHAR(35)

N

Free form comment for the collection Queue collector to use for this account. For the NotePad optn. Valid Values:

/notepad

Ending notepad delimiter

/notepadgroup

Ending notepadgroup delimiter

5/15/01

Changed API name from GetCollectionNotePadFlip to GetCollectionNotePad

Added date formatting to cqnp_createdate description

8/24/01

Updated definition field for cqnp_oprid field